Tobi_1foreign-azure
    Updated 2024-08-24
    SELECT
    CHAIN_ID,
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS transaction_date,
    COUNT(TX_ID) AS transaction_count
    FROM flow.core.fact_transactions;
    WHERE BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_TIMESTAMP())
    GROUP BY CHAIN_ID, transaction_date
    ORDER BY transaction_date, CHAIN_ID;