Daily operator metrics

Daily Filecoin Pay operators metrics.

Shape

Table
daily_operator_metrics
Rows ≈
6,252 · 9 columns · local snapshot
Grain
Key not declared
Observed, UTC
2025-11-04 → 2026-11-17 first and last day; days may be missing
Raw sources
raw.filecoin_api_rails, raw.riba_eth_logs, raw.riba_eth_logs_decoded · raw assets

Query

DuckDB, reads the published file
select *
from 'https://data.filecoindataportal.xyz/daily_operator_metrics.parquet'
limit 10;

The published file is rebuilt daily; counts and sample here come from the local snapshot built 2026-11-18.

Columns

daily_operator_metrics column definitions
NameTypeDescription
dateDATEUTC date.
operatorVARCHARFilecoin Pay operator address.
active_railsBIGINTActive rails at end of day.
recurring_railsBIGINTActive rails with a positive recurring rate at end of day.
eligible_recurring_railsBIGINTActive recurring rails counted toward payment run-rate and network fee ARR at end of day.
unique_payersBIGINTPayers across the operator's active rails at end of day.
unique_payeesBIGINTPayees across the operator's active rails at end of day.
filecoin_pay_gross_payment_volume_run_rate_usdDOUBLEEnd-of-day annualized gross stablecoin payment volume run-rate from the operator's active eligible recurring rails.
filecoin_pay_network_fee_arr_usdDOUBLEEnd-of-day annualized Filecoin Pay network fee revenue from the operator's active eligible recurring stablecoin rails.

Sample

5 rows from the local snapshot, latest first, exactly as stored.

daily_operator_metrics sample rows
dateoperatoractive_railsrecurring_railseligible_recurring_railsunique_payersunique_payeesfilecoin_pay_gross_payment_volume_run_rate_usdfilecoin_pay_network_fee_arr_usd
2026-11-170x3bd1e45b2ee60476bf0b1abbef01b420eb3d1be41001100
2026-11-170xbaad98a46ffd36f3bb275366fce71ebd5b73f68d1001100
2026-11-170x194f9ecba5dd7bbfe83e6fe8a77eaf01e14334cd1111116.7291666666668240.08364583333333413
2026-11-170xcd02c120e494a662e3ff21262f9af2ccbb58a0bb2001100
2026-11-170x4d43f8be8b5d42e326a35124d76c46ba8bd61a1911111316.33333333333341.5816666666666672