shreexDaily Swap Volume Of Stable Coins
    Updated 2022-10-07
    select
    date_trunc('day',block_timestamp) as date,
    symbol_in as token,
    sum(amount_in_usd) as volume,
    count(distinct tx_hash) as number_of_swaps,
    count(distinct origin_from_address) as number_of_swappers
    from optimism.velodrome.ez_swaps where block_timestamp >= '2022-01-01'
    and token_address_in in ('0x7f5c764cbc14f9669b88837ca1490cca17c31607','0x94b008aa00579c1307b0ef2c499ad98a8ce58e58','0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9','0xda10009cbd5d07dd0cecc66161fc93d7c9000da1')
    GROUP BY date,token
    ORDER BY date
    Run a query to Download Data