Switchboardd_ixn_save_result
    Updated 2024-02-06
    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
    MONTH
    COUNT
    1
    2024-01-01 00:00:00.00019716277
    2
    2023-11-01 00:00:00.00020161697
    3
    2023-12-01 00:00:00.00032378426
    3
    112B
    8s