strawbettyassets goETH swap for
Updated 2022-05-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with goeth_to as (
select case when swap_to_asset_id = 0
then 'ALGO' else asset_name
end as swap_for,
sum(swap_from_amount) as sell_go_eth,
count(distinct swapper) as number_of_wallets,
count(distinct tx_group_id) as number_of_sale
from flipside_prod_db.algorand.swaps s
left join flipside_prod_db.algorand.asset a on s.swap_to_asset_id = a.asset_id
where swap_from_asset_id = '386195940'
and block_timestamp::date >= '2022-04-01'
group by 1
order by 2 desc
)
select * from goeth_to
Run a query to Download Data