clayopDailyTransferBySize
    Updated 2023-01-29
    SELECT * FROM (
    SELECT
    DATE_TRUNC('month', BLOCK_TIMESTAMP) AS DATE,
    FROM_ADDRESS,
    TO_ADDRESS,
    SUM(AMOUNT) AS TOTAL_AMOUNT
    FROM
    ethereum.core.ez_token_transfers
    WHERE
    CONTRACT_ADDRESS = {{contract_address}}
    GROUP BY
    1, 2, 3
    ORDER BY
    1 ASC, TOTAL_AMOUNT DESC
    )
    WHERE TOTAL_AMOUNT > 10000000

    Run a query to Download Data