larrypenguinContracts-Eth-Fact
    Updated 2023-03-22
    SELECT
    CONTRACT_ADDRESS,
    trunc(BLOCK_TIMESTAMP,'day') as time,
    COUNT(DISTINCT TX_HASH) as transactions
    FROM
    ethereum.core.fact_decoded_event_logs
    WHERE
    time = '2023-03-22'
    GROUP BY
    CONTRACT_ADDRESS,
    time
    ORDER BY
    transactions DESC;

    Run a query to Download Data