kaibladeUniswap Daily Swap Volume (Optimism)
    Updated 2022-10-13
    SELECT DATE_TRUNC('day', block_timestamp) AS "Days",
    COUNT(tx_hash) AS "Swap Volume"
    FROM optimism.core.fact_event_logs
    WHERE origin_to_address IN ('0xe592427a0aece92de3edee1f18e0157c05861564','0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45')
    AND block_timestamp >= CURRENT_DATE() - INTERVAL '3 month'
    AND event_name = 'Swap'

    GROUP BY "Days"


    Run a query to Download Data