headitmanagerNumber of Swaps for each Asset
Updated 2022-05-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with calculate_vol as (
select
(case
when swap_to_asset_id=226701642 then swap_to_amount
when swap_from_asset_id=226701642 then swap_from_amount
end
) as volume
,date_trunc('day', block_timestamp) as swapdate
, swap_program
,(case
when swap_from_asset_id=226701642 then swap_to_asset_id end
) as asset_id
from algorand.swaps
where swap_to_asset_id=226701642 or swap_from_asset_id=226701642
)
select count(calculate_vol.asset_id) as number_used , asset_name from calculate_vol inner join algorand.asset on calculate_vol.asset_id=algorand.asset.asset_id
group by asset_name
Run a query to Download Data