MONTH | COUNT | |
---|---|---|
1 | 2024-01-01 00:00:00.000 | 19716277 |
2 | 2023-11-01 00:00:00.000 | 20161697 |
3 | 2023-12-01 00:00:00.000 | 32378426 |
Switchboardd_ixn_save_result
Updated 2024-02-06
9
1
2
3
4
5
6
7
8
9
›
⌄
1SELECT
date_trunc('month', block_timestamp) AS month, COUNT(DISTINCT tx_id) AS count
FROM
solana.core.fact_decoded_instructions
WHERE
block_timestamp BETWEEN '2023-06-01' AND '2024-02-01'
AND program_id = 'SW1TCH7qEPTdLsDHRgPuMQjbQxKdH2aBStViMFnt64f'
AND decoded_instruction:name = 'aggregatorSaveResult'
GROUP BY 1
Last run: 11 months ago
3
112B
8s