shreexDaily Swap Volume Of Stable Coins
Updated 2022-10-07
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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