TRADE_DATE | CATEGORY | ACTIVE_TRADERS | NEW_TRADERS | UNIQUE_TRADERS | |
|---|---|---|---|---|---|
1 | 2025-06-01 00:00:00.000 | Meme Cooking | 55 | 6 | 25916 |
2 | 2025-05-31 00:00:00.000 | Meme Cooking | 51 | 5 | 25910 |
3 | 2025-05-30 00:00:00.000 | Meme Cooking | 60 | 6 | 25905 |
4 | 2025-05-29 00:00:00.000 | Meme Cooking | 63 | 13 | 25899 |
5 | 2025-05-28 00:00:00.000 | Meme Cooking | 59 | 9 | 25886 |
6 | 2025-05-27 00:00:00.000 | Meme Cooking | 97 | 6 | 25877 |
7 | 2025-05-26 00:00:00.000 | Meme Cooking | 112 | 5 | 25871 |
8 | 2025-05-25 00:00:00.000 | Meme Cooking | 83 | 15 | 25866 |
9 | 2025-05-24 00:00:00.000 | Meme Cooking | 65 | 9 | 25851 |
10 | 2025-05-23 00:00:00.000 | Meme Cooking | 89 | 11 | 25842 |
11 | 2025-05-22 00:00:00.000 | Meme Cooking | 115 | 25 | 25831 |
12 | 2025-05-21 00:00:00.000 | Meme Cooking | 81 | 8 | 25806 |
13 | 2025-05-20 00:00:00.000 | Meme Cooking | 83 | 5 | 25798 |
14 | 2025-05-19 00:00:00.000 | Meme Cooking | 101 | 13 | 25793 |
15 | 2025-05-18 00:00:00.000 | Meme Cooking | 84 | 19 | 25780 |
16 | 2025-05-17 00:00:00.000 | Meme Cooking | 114 | 14 | 25761 |
17 | 2025-05-16 00:00:00.000 | Meme Cooking | 98 | 10 | 25747 |
18 | 2025-05-15 00:00:00.000 | Meme Cooking | 105 | 10 | 25737 |
19 | 2025-05-14 00:00:00.000 | Meme Cooking | 130 | 11 | 25727 |
20 | 2025-05-13 00:00:00.000 | Meme Cooking | 120 | 10 | 25716 |
adriaparcerisasnear memedotcooking 2
Updated 8 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
),
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: about 10 hours ago
...
262
14KB
559s