TX_COUNT | USER | POOL_COUNT | SOLD_TOKENS | BOUGHT_TOKENS | VOL | |
|---|---|---|---|---|---|---|
1 | 6611733 | 443881 | 2342 | 1194 | 1173 | 4077080915.34 |
AmiRtotal
Updated 2025-01-29
9
1
2
3
4
5
6
7
8
9
›
⌄
select
count(DISTINCT TX_hash) as tx_count,
count (DISTINCT ORIGIN_FROM_ADDRESS) as user,
count(DISTINCT pool_name) as pool_count,
count(DISTINCT token_in) as sold_tokens,
count(DISTINCT token_out) as bought_tokens,
sum(AMOUNT_OUT_USD) as vol
from base.defi.ez_dex_swaps
where BLOCK_TIMESTAMP>=current_date-60 and platform='aerodrome'
Last run: 3 months ago
1
47B
8s