hessTotal EMDX Activities
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with emdx as ( select DISTINCT origin_from_address
from avalanche.core.ez_dex_swaps
where symbol_out = 'EMDX')
select label_type, count(DISTINCT(tx_hash)) as total_tx, sum(amount_usd) as volume
from avalanche.core.ez_token_transfers a join avalanche.core.dim_labels b on a.to_address = b.address
where origin_from_address in (select origin_from_address from emdx)
and label_type != 'token' and label_type != 'chadmin'
and block_timestamp::date >= '2023-01-01'
group by 1
Run a query to Download Data