KaskoazulAlgorand Stablecoins swap to
Updated 2022-04-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select block_timestamp::date as fecha,
case swap_to_asset_id
when 312769 then 'USDT'
when 31566704 then 'USDC'
when 465865291 then 'STBL'
end as asset_to,
count(tx_group_id) as daily_swaps_to,
sum(daily_swaps_to) over (partition by asset_to order by fecha) as cum_swaps_to,
sum(swap_to_amount) as daily_amount_to,
sum(daily_amount_to) over (partition by asset_to order by fecha) as cum_amount_to
from algorand.swaps
where fecha >= '2022-03-01'
and fecha < '2022-04-01'
and swap_to_asset_id in (312769, 31566704, 465865291)
group by 1, 2
Run a query to Download Data