strawbettyAlgo swap to other assets
Updated 2022-06-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
with table1 as (
select
sw.swap_to_asset_id as asset_id,
sum(sw.swap_from_amount) as algo_volume,
avg(sw.swap_from_amount) as average_algorand
from algorand.swaps sw
where date(sw.block_timestamp) >= '2022-05-11'
and date(sw.block_timestamp) <= '2022-05-12'
and sw.swap_from_asset_id = '0'
and sw.swap_from_amount > 0
group by asset_id
order by algo_volume DESC
limit 10
)
SELECT
lb.asset_name as name,
algo_volume,
average_algorand
FROM table1 res
left join algorand.account_asset lb on lb.asset_id = res.asset_id
group by name,algo_volume, average_algorand
order by algo_volume DESC
Run a query to Download Data