Updated 2022-05-01
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
BLOCK_TIMESTAMP::date ,SWAP_PROGRAM, count(SWAPPER) as num_tx ,sum(SWAP_TO_AMOUNT) as amount , 'swap to'
from algorand.swaps
where SWAP_TO_ASSET_ID = 694432641
GROUP by 1,2
UNION
select
BLOCK_TIMESTAMP::date ,SWAP_PROGRAM ,count(SWAPPER) as num_tx ,sum(SWAP_From_AMOUNT) as amount ,'swap from'
from algorand.swaps
where SWAP_From_ASSET_ID = 694432641
GROUP by 1,2
Run a query to Download Data