kaibladeOptimism Daily USDC Transfer Volume
    Updated 2022-11-21
    WITH op_usdc_data AS
    (SELECT *,raw_amount*1e-6 AS amount
    FROM optimism.core.fact_token_transfers
    WHERE contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607'
    AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '2 months'
    )

    SELECT DATE_TRUNC ('days', block_timestamp) AS "Days",
    COUNT(tx_hash) AS "Transfer Volume"

    FROM op_usdc_data

    GROUP BY "Days"
    Run a query to Download Data