avg volume per wallet (usd) | avg tx per wallet | |
|---|---|---|
1 | 3519.625770294 | 18.410476599 |
datavortexdaily
Updated 2025-04-17
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 EthereumDailyPrices AS (
SELECT
DATE(hour) AS price_date,
AVG(price) AS avg_daily_price
FROM ethereum.price.ez_prices_hourly
WHERE token_address = LOWER('0x54991328ab43c7d5d31c19d1b9fa048e77b5cd16')
GROUP BY DATE(hour)
),
EthereumClassifiedSwaps AS (
SELECT
block_timestamp,
DATE(block_timestamp) AS swap_date,
tx_hash,
origin_from_address AS wallet,
contract_address AS contract,
(decoded_log:amount0) / 1e18 AS soil_amount_tokens,
CASE
WHEN CAST(decoded_log:amount0 AS DECIMAL) < 0 THEN 'Buy SOIL'
WHEN CAST(decoded_log:amount0 AS DECIMAL) > 0 THEN 'Sell SOIL'
ELSE 'Unknown'
END AS buy_soil_or_sell_soil,
ABS((decoded_log:amount0) / 1e18) * dp.avg_daily_price AS volume_usd
FROM ethereum.core.ez_decoded_event_logs
LEFT JOIN EthereumDailyPrices dp ON DATE(block_timestamp) = dp.price_date
WHERE
contract_address = LOWER('0x7090Cc8DFA04b0BBAc6520063c9c1ea677C368a0')
AND event_name = 'Swap'
),
PolygonDailyPrices AS (
SELECT
DATE(hour) AS price_date,
AVG(price) AS avg_daily_price
FROM polygon.price.ez_prices_hourly
WHERE token_address = LOWER('0x43C73b90E0C2A355784dCf0Da12f477729b31e77')
GROUP BY DATE(hour)
),
Last run: about 1 month ago
1
31B
92s