Rails
Filecoin Pay rails.
Shape
- Table
- rails
- Rows ≈
- 3,059 · 40 columns · local snapshot
- Grain
- Key not declared
- Observed, UTC
- Not date-indexed · view built 2026-11-17
- Raw sources
- raw.filecoin_api_rails, raw.riba_eth_logs, raw.riba_eth_logs_decoded · raw assets
Query
select *
from 'https://data.filecoindataportal.xyz/rails.parquet'
limit 10;Columns
| Name | Type | Description |
|---|---|---|
| rail_id | BIGINT | Filecoin Pay rail identifier. |
| payer | VARCHAR | Payer address. |
| payee | VARCHAR | Payee address. |
| token | VARCHAR | ERC20 token address. |
| token_symbol | VARCHAR | ERC20 token symbol. |
| token_decimals | INTEGER | ERC20 token decimals. |
| is_stablecoin | BOOLEAN | Whether the rail token is a tagged stablecoin. |
| operator | VARCHAR | Operator address. |
| service | VARCHAR | Service classification. |
| validator | VARCHAR | Validator address. |
| service_fee_recipient | VARCHAR | Service fee recipient address. |
| commission_rate_bps | BIGINT | Commission rate in basis points. |
| is_arr_eligible | BOOLEAN | Whether the rail counts toward recurring run-rate (tagged stablecoin, non-Dealbot payer). |
| created_block | BIGINT | Creation block number. |
| created_log_index | BIGINT | Creation log index. |
| created_transaction_hash | VARCHAR | Creation transaction hash. |
| created_at | TIMESTAMP WITH TIME ZONE | UTC creation timestamp. |
| terminated_block | BIGINT | Termination block number, if any. |
| terminated_log_index | BIGINT | Termination log index, if any. |
| terminated_transaction_hash | VARCHAR | Termination transaction hash, if any. |
| terminated_by | VARCHAR | Address that terminated the rail, if any. |
| terminated_end_epoch | BIGINT | End epoch emitted on termination, if any. |
| terminated_at | TIMESTAMP WITH TIME ZONE | UTC termination timestamp, if any. |
| terminated_end_at | TIMESTAMP WITH TIME ZONE | UTC termination end timestamp, if any. |
| is_terminated | BOOLEAN | Whether the rail has a termination event. |
| data_set_id | BIGINT | Warm Storage data set paid by the rail, if any. |
| state | VARCHAR | Current lifecycle state (active, terminated, finalized), from the Filecoin API. |
| payment_rate | DECIMAL(38,0) | Current payment rate in token base units per epoch, from the Filecoin API. |
| lockup_period | BIGINT | Current lockup period in epochs, from the Filecoin API. |
| lockup_fixed | DECIMAL(38,0) | Current fixed lockup in token base units, from the Filecoin API. |
| settled_up_to | BIGINT | Epoch settled up to, from the Filecoin API. |
| total_settled_amount | DECIMAL(38,0) | Cumulative settled amount in token base units, from the Filecoin API. |
| total_net_payee_amount | DECIMAL(38,0) | Cumulative settled amount net to payee in token base units, from the Filecoin API. |
| total_one_time_amount | DECIMAL(38,0) | Cumulative one-time payments in token base units, from the Filecoin API. |
| total_one_time_net_payee_amount | DECIMAL(38,0) | Cumulative one-time payments net to payee in token base units, from the Filecoin API. |
| api_indexed_block | BIGINT | Latest API indexer block before the snapshot. |
| api_observed_at | TIMESTAMP | UTC Filecoin API snapshot timestamp. |
| rate_history | STRUCT(date DATE, rate DECIMAL(38,0))[] | Sparse end-of-day rates in token base units per epoch, ordered by date. |
| history_start | DATE | First UTC date in FEVM checkpoint coverage. |
| history_end | DATE | Last UTC date in FEVM checkpoint coverage. |
Sample
| rail_id | payer | payee | token | token_symbol | token_decimals | is_stablecoin | operator | service | validator | service_fee_recipient | commission_rate_bps | is_arr_eligible | created_block | created_log_index | created_transaction_hash | created_at | terminated_block | terminated_log_index | terminated_transaction_hash | terminated_by | terminated_end_epoch | terminated_at | terminated_end_at | is_terminated | data_set_id | state | payment_rate | lockup_period | lockup_fixed | settled_up_to | total_settled_amount | total_net_payee_amount | total_one_time_amount | total_one_time_net_payee_amount | api_indexed_block | api_observed_at | rate_history | history_start | history_end |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3059 | 0x305025d07c1dee47f25a4990179eff2becddca0b | 0x73684a70ffab6c6aec474ec0c13b376607ec4af4 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | true | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | false | 6552154 | 5 | 0xb4ab61ca767737cdc63018770b73903c674496d6adfdc7b54531c60f0a2648ed | 2026-11-16 23:17:00+00 | null | null | null | null | null | null | null | false | 1949 | active | 1389998177627 | 86400 | 420000000000000000 | 6552154 | 0 | 0 | 80000000000000000 | 79600000000000000 | 6554937 | 2026-11-17 22:29:36.211178 | [{"date":"2026-11-16","rate":"1388894281486"}] | 2025-08-01 | 2026-11-16 |
| 3058 | 0x305025d07c1dee47f25a4990179eff2becddca0b | 0x73684a70ffab6c6aec474ec0c13b376607ec4af4 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | true | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | false | 6551673 | 0 | 0xdebba219f23eeadbb730bc4cb30e7bc6d862e834d34e30a3dd77c72728fbc432 | 2026-11-16 19:16:30+00 | null | null | null | null | null | null | null | false | 1948 | active | 1390274151663 | 86400 | 409000000000000000 | 6551673 | 0 | 0 | 91000000000000000 | 90545000000000000 | 6554937 | 2026-11-17 22:29:36.211178 | [{"date":"2026-11-16","rate":"1388894281486"}] | 2025-08-01 | 2026-11-16 |
| 3057 | 0x261465ebfc3e3e84c36da8985912ade2a052756e | 0xc38658920c2f47b5a6d311640210e14c8d2b8c88 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | true | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | true | 6551484 | 39 | 0x60687c607638eca81e7e2b428882581777a97b77cd6e0fa87cda3851c34c1ea2 | 2026-11-16 17:42:00+00 | null | null | null | null | null | null | null | false | 1947 | active | 1388889094419 | 86400 | 453000000000000000 | 6551484 | 0 | 0 | 47000000000000000 | 46765000000000000 | 6554937 | 2026-11-17 22:29:36.211178 | [{"date":"2026-11-16","rate":"1388889094419"}] | 2025-08-01 | 2026-11-16 |
| 3056 | 0x5f4ccc7001a98375e46d2b5ac5024832cb525622 | 0xe597df49cf802765488f9004a764d5fdaad5dd10 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | true | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | true | 6551257 | 43 | 0x9f5a97f7f8154ecff01169f6ab94b30959f8679e099cbef3fcb86f6ba8702b5d | 2026-11-16 15:48:30+00 | null | null | null | null | null | null | null | false | 1946 | active | 1417397342954 | 86400 | 443000000000000000 | 6551257 | 0 | 0 | 57000000000000000 | 56715000000000000 | 6554937 | 2026-11-17 22:29:36.211178 | [{"date":"2026-11-16","rate":"1417397342954"}] | 2025-08-01 | 2026-11-16 |
| 3055 | 0x305025d07c1dee47f25a4990179eff2becddca0b | 0x73684a70ffab6c6aec474ec0c13b376607ec4af4 | 0x80b98d3aa09ffff255c3ba4a241111ff1262f045 | USDFC | 18 | true | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | FWSS | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0x8408502033c418e1bbc97ce9ac48e5528f371a9f | 0 | false | 6551194 | 71 | 0x367b0eb4f773f837e3d2107c13a75a559b77dc12c6142ae756e745ec33b84b37 | 2026-11-16 15:17:00+00 | null | null | null | null | null | null | null | false | 1945 | active | 1390550125698 | 86400 | 398000000000000000 | 6551194 | 0 | 0 | 102000000000000000 | 101490000000000000 | 6554937 | 2026-11-17 22:29:36.211178 | [{"date":"2026-11-16","rate":"1389170255521"}] | 2025-08-01 | 2026-11-16 |