CATEGORY | TOTAL_SWAPS | UNIQUE_TRADERS | TOTAL_VOLUME_USD | AVG_TRADE_VOLUME | MAX_TRADE_VOLUME | MEDIAN_TRADE_VOLUME | |
|---|---|---|---|---|---|---|---|
1 | Bot | 4045840 | 536 | 638408496.850487 | 144.443370276 | 8266.353613616 | 27.066045164 |
2 | Stablecoin | 222136 | 56770 | 43798746.2212283 | 129.615451969 | 390777.490175278 | 2.597309743 |
3 | Regular User | 407760 | 58769 | 25143530.0784987 | 88.896027035 | 461799.126549128 | 2.668830687 |
4 | Meme Cooking | 82310 | 3167 | 4341432.96023505 | 74.96862304 | 9786.936957768 | 18.954770771 |
adriaparcerisasnear outlets of increasing trading volume
Updated 6 days ago
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
30
31
32
33
34
35
36
›
⌄
WITH base_data AS (
SELECT
trunc(block_timestamp, 'day') AS trade_date,
tx_hash,
trader,
token_in_contract,
symbol_in,
token_out_contract,
symbol_out,
amount_in,
amount_out,
amount_in_usd,
amount_out_usd,
pool_id
FROM near.defi.ez_dex_swaps
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '{{period}} DAYS'
),
pricing_data AS (
SELECT
trunc(hour, 'day') AS price_date,
token_address,
AVG(price) AS avg_price
FROM near.price.ez_prices_hourly
GROUP BY 1, 2
),
enriched_data AS (
SELECT
b.*,
COALESCE(b.amount_in_usd, b.amount_in * p_in.avg_price) AS final_amount_in_usd,
COALESCE(b.amount_out_usd, b.amount_out * p_out.avg_price) AS final_amount_out_usd
FROM base_data b
LEFT JOIN pricing_data p_in
ON b.trade_date = p_in.price_date
AND b.token_in_contract = p_in.token_address
LEFT JOIN pricing_data p_out
Last run: 6 days ago
4
342B
673s