vahid-2jsEENAssets swaped by new wallets
Updated 2022-06-15
9
1
2
3
4
5
6
7
›
⌄
with new_wallets as ( select *, date_trunc('day', b.block_timestamp) as date from flipside_prod_db.algorand.account a
left join algorand.block b on a.created_at = b.block_id where closed_at is null and date >= '2022-05-01' and date < '2022-05-31'),
assets as (
select asset.asset_name, count(swap.tx_group_id) as swaps
from algorand.swaps swap inner join algorand.asset asset on swap.swap_to_asset_id = asset.asset_id
where block_timestamp between '2022-05-04' and '2022-05-10' and swap_from_amount > 0
group by 1 order by 2 desc) select * from assets order by 2 desc limit 10
Run a query to Download Data