Payments

Filecoin Pay payment events.

Shape

Table
payments
Rows ≈
359,591 · 19 columns · local snapshot
Grain
Key not declared
Observed, UTC
2025-11-13 → 2026-11-16 first and last day; days may be missing
Raw sources
raw.filecoin_api_rails, raw.riba_eth_logs_decoded · raw assets

Query

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

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

Columns

payments column definitions
NameTypeDescription
dateDATEUTC event date.
event_atTIMESTAMP WITH TIME ZONEUTC event timestamp.
block_numberBIGINTEvent block number.
transaction_hashVARCHAREvent transaction hash.
event_nameVARCHARPayment event name.
rail_idBIGINTFilecoin Pay rail identifier.
payerVARCHARPayer address.
payeeVARCHARPayee address.
operatorVARCHAROperator address.
service_fee_recipientVARCHARService fee recipient address.
tokenVARCHARERC20 token address.
token_symbolVARCHARERC20 token symbol.
token_decimalsINTEGERERC20 token decimals.
is_stablecoinBOOLEANWhether the rail token is a tagged stablecoin.
gross_amountDOUBLEGross amount paid, in token units.
net_payee_amountDOUBLENet amount credited to the payee, in token units.
operator_commissionDOUBLEOperator commission, in token units.
network_feeDOUBLENetwork fee, in token units.
gross_amount_usdDOUBLEGross amount paid in USD for tagged stablecoins.

Sample

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

payments sample rows
dateevent_atblock_numbertransaction_hashevent_namerail_idpayerpayeeoperatorservice_fee_recipienttokentoken_symboltoken_decimalsis_stablecoingross_amountnet_payee_amountoperator_commissionnetwork_feegross_amount_usd
2026-11-162026-11-16 23:55:30+0065522310xb25dca4124409407ced52434576e2d30ec6db6c87b48eb0d00512bccd74acde2RailOneTimePaymentProcessed29750x305025d07c1dee47f25a4990179eff2becddca0b0xbfe564709368dee852f50aa1fc7c01d54ada2f2f0x8408502033c418e1bbc97ce9ac48e5528f371a9f0x8408502033c418e1bbc97ce9ac48e5528f371a9f0x80b98d3aa09ffff255c3ba4a241111ff1262f045USDFC18true0.0110.01094500.0000550.011
2026-11-162026-11-16 23:55:00+0065522300xf8a6a846b59a0804241f20708681928a9147ef6cd75f00916068396bcbd3538dRailOneTimePaymentProcessed28980x305025d07c1dee47f25a4990179eff2becddca0b0xc2541f6a90c9aec2b409a832c8072c44caebdedf0x8408502033c418e1bbc97ce9ac48e5528f371a9f0x8408502033c418e1bbc97ce9ac48e5528f371a9f0x80b98d3aa09ffff255c3ba4a241111ff1262f045USDFC18true0.0110.01094500.0000550.011
2026-11-162026-11-16 23:55:00+0065522300x4cd305e33c90a56434d4746c86fd56ab33134bf25db57a689e10c22e0cbed1b7RailOneTimePaymentProcessed29290x305025d07c1dee47f25a4990179eff2becddca0b0x5c6536dd888d9ed78b92f37e2f815be19e1f5d2b0x8408502033c418e1bbc97ce9ac48e5528f371a9f0x8408502033c418e1bbc97ce9ac48e5528f371a9f0x80b98d3aa09ffff255c3ba4a241111ff1262f045USDFC18true0.0110.01094500.0000550.011
2026-11-162026-11-16 23:55:00+0065522300x4d5abff0e1780ed52c8246f48538e57f2f85fec17511462eff1717999b81999bRailOneTimePaymentProcessed29270x305025d07c1dee47f25a4990179eff2becddca0b0x20a287fc3aac63578eefc3309b041fc65c6f2e140x8408502033c418e1bbc97ce9ac48e5528f371a9f0x8408502033c418e1bbc97ce9ac48e5528f371a9f0x80b98d3aa09ffff255c3ba4a241111ff1262f045USDFC18true0.0110.01094500.0000550.011
2026-11-162026-11-16 23:54:30+0065522290xe8335bb2ea2300bae185ed0cb924250915a758131b4091ec602f3e3060c5f2b0RailOneTimePaymentProcessed29080x305025d07c1dee47f25a4990179eff2becddca0b0x80df099a0e3ff32930d7a761a86c978da597e9fd0x8408502033c418e1bbc97ce9ac48e5528f371a9f0x8408502033c418e1bbc97ce9ac48e5528f371a9f0x80b98d3aa09ffff255c3ba4a241111ff1262f045USDFC18true0.0110.01094500.0000550.011