HadisehCelsius Swaps
Updated 2022-06-21
9
1
2
3
4
5
6
7
8
›
⌄
with wallet as ( select address
from flipside_prod_db.crosschain.address_labels
where ADDRESS_NAME = 'celsius wallet'
)
select symbol_in , platform, count(DISTINCT(TX_HASH)) as total_swaps , sum(AMOUNT_IN_USD) as total_amount
from ethereum.core.ez_dex_swaps
where ORIGIN_FROM_ADDRESS in ( select address from wallet)
group by symbol_in , platform
Run a query to Download Data