Switchboard24m1_agg_init
Updated 2024-02-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- forked from 22q1_agg_init @ https://flipsidecrypto.xyz/edit/queries/ad801ab3-d543-42eb-99a6-2f5361cd5bd1
-- total aggregatorInit ixns for time period
-- to query each aggregator account address
SELECT DISTINCT block_timestamp, account_keys[1]:pubkey AS aggregator, account_keys[0]:pubkey AS authority
FROM solana.core.fact_events
INNER JOIN solana.core.fact_transactions USING (tx_id, block_timestamp, succeeded)
INNER JOIN lateral flatten (input => log_messages) f
WHERE block_timestamp BETWEEN '2024-01-01' AND '2024-01-31'
AND succeeded
AND program_id = 'SW1TCH7qEPTdLsDHRgPuMQjbQxKdH2aBStViMFnt64f'
AND f.value LIKE 'Program log: Instruction: AggregatorInit'
QueryRunArchived: QueryRun has been archived