larrypenguinContracts Eth Top
    Updated 2023-04-22
    SELECT
    *
    FROM (
    SELECT
    trunc(BLOCK_TIMESTAMP, 'month') AS time,
    COUNT(DISTINCT TX_HASH) AS transactions,
    row_number() OVER (PARTITION BY time ORDER BY transactions DESC) as contract_rank,
    CONTRACT_ADDRESS
    FROM
    ethereum.core.fact_decoded_event_logs
    GROUP BY
    CONTRACT_ADDRESS,
    time
    ORDER BY
    time DESC)
    WHERE
    contract_rank <= 10
    Run a query to Download Data