Switchboard23q1_agg_init
Updated 2023-12-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- 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 '2023-01-01' AND '2023-03-31'
AND succeeded
AND program_id = 'SW1TCH7qEPTdLsDHRgPuMQjbQxKdH2aBStViMFnt64f'
AND f.value LIKE 'Program log: Instruction: AggregatorInit'
Run a query to Download Data