PapasotgoBTC,goETH daily since April
Updated 2022-05-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
date_trunc('day',block_timestamp) as block_day,
asset_name as ASA_name,
swap_to_asset_id as ASA_id,
count(swap_to_asset_id) as Swaps,
count(DISTINCT(swapper)) as Users
from algorand.swaps a
left join algorand.asset b on b.asset_id = a.swap_to_asset_id
where block_timestamp >= '2022-04-01' AND
swap_from_amount > 1 AND
(swap_to_asset_id = '386192725' OR
swap_to_asset_id = '386195940')
group by block_day,swap_to_asset_id,asset_name
order by block_day
Run a query to Download Data