TOTAL_TRANSACTIONS | UNIQUE_WALLETS | TOTAL_VOLUME_USD | MAX_SINGLE_TRADE_USD | AVG_TRADES_PER_WALLET | AVG_VOLUME_PER_WALLET | UNIQUE_INPUT_TOKENS | UNIQUE_OUTPUT_TOKENS | FIRST_TRANSACTION_DATE | LAST_TRANSACTION_DATE | ACTIVE_DAYS | AVG_DAILY_TRANSACTIONS | AVG_DAILY_USERS | AVG_DAILY_VOLUME_USD | TOP_PAIRS_VOLUME_USD | AVG_TOP_TRADER_TX_COUNT | AVG_TOP_TRADER_VOLUME_USD | TOP_TRADERS_TOTAL_VOLUME_USD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 16448 | 1539 | 12223768.2075668 | 22164.273268272 | 10.687459 | 7942.669400628 | 18 | 17 | 2024-12-24 00:00:00.000 | 2025-04-04 00:00:00.000 | 101 | 162.851485 | 31.079208 | 124732.328648641 | 749.8 | 893576.997704344 | 11616500.9701565 |
superflyoutdoor-amaranth
Updated 2025-04-04
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) first_event_index,
max (event_index) 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 transaction_date,
tx_hash ,
ORIGIN_FROM_ADDRESS wallet_address,
c.SYMBOL input_token,
decoded_log:"value" /pow(10,DECIMALS) input_amount,
input_amount * price_usd input_amount_usd ,
null output_token,
null output_amount,
null output_amount_usd
from swell.core.ez_decoded_event_logs join transaction_indexes using (tx_hash)
join swell.core.dim_contracts c on ADDRESS = CONTRACT_ADDRESS
join token_prices p on (p.symbol = c.symbol and block_timestamp::date = p.date)
Last run: 2 months ago
1
217B
38s