Hadisehtop wallets
Updated 2022-06-22
9
1
2
3
4
5
6
7
8
9
›
⌄
with wallet as ( select address
from flipside_prod_db.crosschain.address_labels
where ADDRESS_NAME = 'celsius wallet')
select top 10 ORIGIN_FROM_ADDRESS , 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 ORIGIN_FROM_ADDRESS
order by 3 desc
Run a query to Download Data