jackguyvelodrome KPI 8 copy
    Updated 2023-04-13
    SELECT
    date_trunc('week', block_timestamp) as week,
    token_symbol,
    sum(CLAIMED_AMOUNT_USD) as volume_usd
    FROM optimism.velodrome.ez_claimed_rewards
    WHERE block_timestamp BETWEEN '2023-01-01' AND '2023-03-31'
    GROUP BY 1,2


    Run a query to Download Data