freemartianDEXs Stats - number
Updated 2022-05-22
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select sum(SWAP_FROM_AMOUNT) as from_volume, swap_program, count (distinct tx_group_id) as number_transaction, 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 swap_program, asset, DATE
Run a query to Download Data