Tobi_12024-06-07 07:56 PM
    Updated 2024-06-07
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_date,
    FEE AS transaction_fee,
    COUNT(*) AS transaction_count
    FROM
    solana.core.fact_transactions;
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP())
    GROUP BY
    transaction_date,
    transaction_fee
    ORDER BY
    transaction_date,
    transaction_fee;

    QueryRunArchived: QueryRun has been archived