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
select *
from 'https://data.filecoindataportal.xyz/service_orchestrators.parquet'
limit 10;Columns
| Name | Type | Description |
|---|---|---|
| orchestrator | VARCHAR | ServiceOrchestrator identity address (not the payout wallet). |
| wallet | VARCHAR | Current payout wallet. |
| is_admitted | BOOLEAN | Whether the latest admission has no later removal. |
| admissions | BIGINT | Number of admission events. |
| first_admitted_block | BIGINT | First admission block. |
| first_admitted_at | TIMESTAMP WITH TIME ZONE | UTC first admission timestamp. |
| admitted_block | BIGINT | Latest admission block. |
| admitted_log_index | BIGINT | Latest admission log index. |
| admitted_transaction_hash | VARCHAR | Latest admission transaction hash. |
| admitted_at | TIMESTAMP WITH TIME ZONE | UTC latest admission timestamp. |
| removed_block | BIGINT | Removal block after the latest admission, if any. |
| removed_log_index | BIGINT | Removal log index, if any. |
| removed_transaction_hash | VARCHAR | Removal transaction hash, if any. |
| removed_at | TIMESTAMP WITH TIME ZONE | UTC removal timestamp, if any. |
| wallet_replaced_block | BIGINT | Latest payout wallet replacement block since admission, if any. |
| wallet_replaced_transaction_hash | VARCHAR | Latest payout wallet replacement transaction hash, if any. |
| bound_pairs | BIGINT | Open (payer, operator) binding spans. |
| payment_history | STRUCT(date DATE, payer VARCHAR, token VARCHAR, amount DECIMAL(38,0))[] | Daily gross payments in token base units, ordered by date, token and payer. |
Sample
| orchestrator | wallet | is_admitted | admissions | first_admitted_block | first_admitted_at | admitted_block | admitted_log_index | admitted_transaction_hash | admitted_at | removed_block | removed_log_index | removed_transaction_hash | removed_at | wallet_replaced_block | wallet_replaced_transaction_hash | bound_pairs | payment_history |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x97a90f5696be5e3c8d3752c92adac287c2b4484e | 0x97a90f5696be5e3c8d3752c92adac287c2b4484e | true | 1 | 6393228 | 2026-09-22 18:54:00+00 | 6393228 | 25 | 0x0f9621c112e5790b659eee5551b5380bdbb5624ba1a98491b66d20c797b75a46 | 2026-09-22 18:54:00+00 | null | null | null | null | null | null | 2 | [{"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"}] |