tomilayoodd-silver
    Updated 2024-10-13
    SELECT
    DISTINCT(FROM_ADDRESS) AS active_user_address,
    COUNT(TX_HASH) AS transaction_count
    FROM
    blast.core.fact_transactions;
    WHERE
    BLOCK_TIMESTAMP BETWEEN '2023-09-01' AND '2023-09-30'
    GROUP BY
    FROM_ADDRESS
    HAVING
    transaction_count > 0
    ORDER BY
    transaction_count DESC;

    QueryRunArchived: QueryRun has been archived