TOKEN_PAIR | TOTAL_WALLETS | TOTAL_SWAPS | TOTAL_VOLUME_USD | AVG_VOLUME_PER_WALLET | AVG_SWAPS_PER_WALLET | |
|---|---|---|---|---|---|---|
1 | SOIL/WETH (Ethereum) | 60 | 285 | 104475.08090092 | 1741.251348349 | 4.75 |
2 | SOIL/USDT (Polygon) | 6941 | 128349 | 24487150.1761402 | 3527.899463498 | 18.491427748 |
datavortexPER TOKEN
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 ethereum_daily_prices 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)
),
ethereum_classified_swaps AS (
SELECT
block_timestamp
,DATE(block_timestamp) AS swap_date
,tx_hash
,origin_from_address AS wallet
,contract_address
,(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 ethereum_daily_prices dp ON DATE(block_timestamp) = dp.price_date
WHERE
contract_address = LOWER('0x7090Cc8DFA04b0BBAc6520063c9c1ea677C368a0')
AND event_name = 'Swap'
),
polygon_daily_prices 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 2 months ago
2
150B
88s