Service orchestrators

Solstice ServiceOrchestrators.

Shape

Table
service_orchestrators
Rows ≈
1 · 18 columns · local snapshot
Grain
Key not declared
Observed, UTC
Not date-indexed · view built 2026-11-17
Raw sources
raw.riba_eth_logs_decoded, raw.solstice_deployments · raw assets

Query

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

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

Columns

service_orchestrators column definitions
NameTypeDescription
orchestratorVARCHARServiceOrchestrator identity address (not the payout wallet).
walletVARCHARCurrent payout wallet.
is_admittedBOOLEANWhether the latest admission has no later removal.
admissionsBIGINTNumber of admission events.
first_admitted_blockBIGINTFirst admission block.
first_admitted_atTIMESTAMP WITH TIME ZONEUTC first admission timestamp.
admitted_blockBIGINTLatest admission block.
admitted_log_indexBIGINTLatest admission log index.
admitted_transaction_hashVARCHARLatest admission transaction hash.
admitted_atTIMESTAMP WITH TIME ZONEUTC latest admission timestamp.
removed_blockBIGINTRemoval block after the latest admission, if any.
removed_log_indexBIGINTRemoval log index, if any.
removed_transaction_hashVARCHARRemoval transaction hash, if any.
removed_atTIMESTAMP WITH TIME ZONEUTC removal timestamp, if any.
wallet_replaced_blockBIGINTLatest payout wallet replacement block since admission, if any.
wallet_replaced_transaction_hashVARCHARLatest payout wallet replacement transaction hash, if any.
bound_pairsBIGINTOpen (payer, operator) binding spans.
payment_historySTRUCT(date DATE, payer VARCHAR, token VARCHAR, amount DECIMAL(38,0))[]Daily gross payments in token base units, ordered by date, token and payer.

Sample

1 rows from the local snapshot, exactly as stored.

service_orchestrators sample rows
orchestratorwalletis_admittedadmissionsfirst_admitted_blockfirst_admitted_atadmitted_blockadmitted_log_indexadmitted_transaction_hashadmitted_atremoved_blockremoved_log_indexremoved_transaction_hashremoved_atwallet_replaced_blockwallet_replaced_transaction_hashbound_pairspayment_history
0x97a90f5696be5e3c8d3752c92adac287c2b4484e0x97a90f5696be5e3c8d3752c92adac287c2b4484etrue163932282026-09-22 18:54:00+006393228250x0f9621c112e5790b659eee5551b5380bdbb5624ba1a98491b66d20c797b75a462026-09-22 18:54:00+00nullnullnullnullnullnull2[{"date":"2026-10-22","payer":"0x5b27dbc6efefbb5ba8106fb19433048d60d6878f","token":"0xeb466342c4d449bc9f53a865d5cb90586f405215","amount":"2310756789"},{"date":"2026-10-29","payer":"0x5b27dbc6efefbb5ba8106fb19433048d60d6878f","token":"0xeb466342c4d449bc9f53a865d5cb90586f405215","amount":"2303528862"},{"date":"2026-11-02","payer":"0x5b27dbc6efefbb5ba8106fb19433048d60d6878f","token":"0xeb466342c4d449bc9f53a865d5cb90586f405215","amount":"1328676549"},{"date":"2026-11-05","payer":"0x5b27dbc6efefbb5ba8106fb19433048d60d6878f","token":"0xeb466342c4d449bc9f53a865d5cb90586f405215","amount":"991029102"},{"date":"2026-11-12","payer":"0x5b27dbc6efefbb5ba8106fb19433048d60d6878f","token":"0xeb466342c4d449bc9f53a865d5cb90586f405215","amount":"2323721166"}]