0xaimanALGO Swap Out Volume
Updated 2022-07-07
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
27
28
›
⌄
with raw as (select s.TX_GROUP_ID,
t.tx_id,
SWAP_PROGRAM,
ADDRESS_NAME,
TX_MESSAGE:txn:grp as grp_id,
l.ASSET_NAME,
l2.ASSET_NAME as an1,
SWAP_FROM_AMOUNT,
SWAP_TO_AMOUNT
from flipside_prod_db.algorand.swaps s inner join flipside_prod_db.algorand.asset l on s.SWAP_from_ASSET_ID=l.ASSET_ID
inner join flipside_prod_db.algorand.asset l2 on s.SWAP_TO_ASSET_ID=l2.ASSET_ID
inner join flipside_prod_db.algorand.labels l3 on s.pool_address=l3.ADDRESS
left join flipside_prod_db.algorand.transfers t on s.TX_GROUP_ID=t.TX_GROUP_ID
where s.block_timestamp>='2022-06-27'
),
raw2 as (select SWAP_PROGRAM,ADDRESS_NAME, tx_id,ASSET_NAME ,an1,
SWAP_FROM_AMOUNT,
SWAP_TO_AMOUNT , case when grp_id is null then 'Not Via Alammex' else 'Via Alammex' end as aggt from raw)
select aggt, sum(SWAP_FROM_AMOUNT) algo_vol_in, sum(SWAP_TO_AMOUNT) algo_vol_out
from raw2
where asset_name='ALGO'
group by 1
limit 5000
Run a query to Download Data