Tobi_12024-06-08 07:48 AM
    Updated 2024-06-08
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_date,
    COUNT(*) AS daily_sales_count
    FROM
    solana.core.fact_transactions;
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE)
    GROUP BY
    transaction_date
    ORDER BY
    transaction_date;