VOLUME_CATEGORY | TRANSACTION_COUNT | UNIQUE_TRADERS | TOTAL_VOLUME_USD | AVG_VOLUME_USD | MEDIAN_VOLUME_USD | PERCENTAGE_OF_TRANSACTIONS | PERCENTAGE_OF_VOLUME | |
|---|---|---|---|---|---|---|---|---|
1 | 0-10 USD | 1304 | 611 | 2897.73993203 | 2.222193199 | 1.014789137 | 9.75 | 0.05 |
2 | 10-100 USD | 4203 | 612 | 240885.8231632 | 57.312829684 | 65.792675 | 31.43 | 4.33 |
3 | 100-1K USD | 4963 | 250 | 1851815.31746302 | 373.124182443 | 309.83448 | 37.11 | 33.32 |
4 | 1K-10K USD | 1538 | 46 | 3316805.09625855 | 2156.570283653 | 1929.413987188 | 11.5 | 59.67 |
5 | 10K-100K USD | 8 | 3 | 145977.449786419 | 18247.181223302 | 19446.816755832 | 0.06 | 2.63 |
6 | >100K USD | 1358 | 368 | 10.15 |
superflyzealous-violet
Updated 9 days ago
999
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
30
31
32
33
34
35
36
›
⌄
WITH token_prices AS (
SELECT
date_trunc('day', hour)::date as date,
symbol,
median(price) as price_usd
FROM ethereum.price.ez_prices_hourly
WHERE symbol in ('NEP','ENA','SWELL','WETH','KING','SURF','WSTETH','SWETH','USDE','SUSDE','RSWETH','RSETH','SWBTC','PZETH','WEETH')
AND date_trunc('day', hour) >= '2024-12-02'
GROUP BY 1, 2
),
ambient_contract_txns AS (
SELECT tx_hash
FROM swell.core.fact_event_logs
WHERE contract_address = '0xaaaaaaaa82812f0a1f274016514ba2ca933bf24d'
),
transaction_indexes AS (
SELECT
tx_hash,
min(event_index) as first_event_index,
max(event_index) as last_event_index
FROM swell.core.ez_decoded_event_logs
JOIN ambient_contract_txns USING (tx_hash)
GROUP BY 1
),
single_event_txns AS (
SELECT
block_timestamp::date as transaction_date,
tx_hash,
ORIGIN_FROM_ADDRESS as wallet_address,
c.SYMBOL as input_token_symbol,
decoded_log:"value" / pow(10, DECIMALS) as input_token_amount,
input_token_amount * price_usd as input_token_amount_usd,
null as output_token_symbol,
null as output_token_amount,
null as output_token_amount_usd
FROM swell.core.ez_decoded_event_logs
Last run: 9 days ago
6
431B
7s