AERODROME_ADDRESSES | AERODROME_TRADES | AERODROME_VOLUME | PCT_ADDRESSES | PCT_TRADES | PCT_VOLUME | |
|---|---|---|---|---|---|---|
1 | 2081378 | 79329144 | 202024385040.96 | 1.54 | 13.62 | 46.62 |
feyikemiAerodrome %
Updated 2025-05-16
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
›
⌄
WITH total AS (
SELECT
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS total_addresses,
COUNT(DISTINCT TX_HASH) AS total_trades,
SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS total_volume
FROM base.defi.ez_dex_swaps
),
aerodrome AS (
SELECT
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS aerodrome_addresses,
COUNT(DISTINCT TX_HASH) AS aerodrome_trades,
SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS aerodrome_volume
FROM base.defi.ez_dex_swaps
WHERE PLATFORM ILIKE '%aerodrome%'
)
SELECT
aerodrome_addresses,
aerodrome_trades,
aerodrome_volume,
ROUND(aerodrome_addresses * 100.0 / NULLIF(total_addresses, 0), 2) AS pct_addresses,
ROUND(aerodrome_trades * 100.0 / NULLIF(total_trades, 0), 2) AS pct_trades,
ROUND(aerodrome_volume * 100.0 / NULLIF(total_volume, 0), 2) AS pct_volume
FROM total, aerodrome
Last run: 16 days ago
1
53B
132s