binhachonMarket Volatility - #1
Updated 2022-05-22
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('day', block_timestamp) as time,
platform,
sum(coalesce(amount_in_usd, amount_out_usd)) as volume_usd,
count(*) as number_of_trades
from flipside_prod_db.ethereum_core.ez_dex_swaps
where time >= '2022-05-09'
and time <= '2022-05-15'
-- and token_in != '0x61b5c3aee3a25f6f83531d548a4d2ee58450f5d9'
-- and token_out != '0x61b5c3aee3a25f6f83531d548a4d2ee58450f5d9'
group by 1, 2
Run a query to Download Data