VOLUME_BUCKET | TRADER_COUNT | |
|---|---|---|
1 | 0-100 | 10 |
2 | 100-500 | 4 |
3 | 500-1K | 1 |
datavortexswappers categories
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') -- WETH
GROUP BY DATE(hour)
),
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') -- USDT
GROUP BY DATE(hour)
),
ethereum_swaps_today AS (
SELECT
origin_from_address AS wallet,
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') -- SOIL/WETH
AND event_name = 'Swap'
AND DATE(block_timestamp) = CURRENT_DATE
),
polygon_swaps_today AS (
SELECT
origin_from_address AS wallet,
ABS((decoded_log:amount0) / 1e18) * dp.avg_daily_price AS volume_usd
FROM polygon.core.ez_decoded_event_logs
LEFT JOIN polygon_daily_prices dp ON DATE(block_timestamp) = dp.price_date
WHERE
contract_address IN (
'0x2f3c540b426ee34afaf6597d8e3575f54bd08ea8',
Last run: about 1 month ago
3
41B
4s