datavortexweekly trends
    Updated 2024-09-05
    SELECT
    DATE_TRUNC('week', block_timestamp) AS week,
    SUM(amount_usd) AS total_volume,
    COUNT(DISTINCT tx_hash) AS weekly_transactions
    FROM
    optimism.core.ez_token_transfers
    WHERE
    contract_address = LOWER('0x296F55F8Fb28E498B858d0BcDA06D955B2Cb3f97')
    GROUP BY
    week
    ORDER BY
    week;

    QueryRunArchived: QueryRun has been archived