freemartianDaily Sell Volume
Updated 2022-05-20
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select sum(SWAP_FROM_AMOUNT) as sell_volume, date_trunc('day', block_timestamp::date) as DATE,
(CASE
when SWAP_FROM_ASSET_ID = '386195940' then 'goETH'
when SWAP_FROM_ASSET_ID = '386192725' then 'goBTC'
else 'others'
end) as asset
from flipside_prod_db.algorand.swaps
where SWAP_FROM_ASSET_ID in ('386192725','386195940')
and block_timestamp::date > '2022-04-01'
group by asset, DATE
Run a query to Download Data