USER_COUNT | TX_COUNT | POOL_COUNT | TOTAL_VOLUME | AVG_TX_VOLUME | |
|---|---|---|---|---|---|
1 | 3312168 | 64045406 | 22136 | 164625535513.46 | 1823.313601149 |
elsinatotal activity
Updated 2025-02-26
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
29
›
⌄
with base as (
SELECT
block_timestamp,
origin_from_address,
tx_hash,
pool_name,
CASE
WHEN amount_in_usd IS NOT NULL AND amount_out_usd IS NOT NULL THEN (amount_in_usd + amount_out_usd) / 2
ELSE COALESCE(amount_in_usd, amount_out_usd)
END AS amount
from
avalanche.defi.ez_dex_swaps
where
platform = 'pangolin' and
amount_in_usd IS NOT NULL OR amount_out_usd IS NOT NULL
)
SELECT
count(DISTINCT origin_from_address) as user_count,
count(DISTINCT tx_hash) as tx_count,
count(distinct pool_name) as pool_count,
sum(amount) as total_volume,
avg(amount) as avg_tx_volume
from base
Last run: about 2 months ago
1
57B
7s