TRADER | NUMBER_OF_TRADES | UNIQUE_AXIES_TRADED | TOTAL_VOLUME_USD | AVG_TRADE_VALUE_USD | AVG_TRADE_SIZE_USD | |
|---|---|---|---|---|---|---|
1 | 0x094300dacf0eed244664e326d27406f0b90b8809 | 8846 | 8505 | 32694.77 | 3.7 | 3.7 |
2 | 0x538427affd6bd911882ef2373009016760b8df1d | 518 | 512 | 26568.54 | 51.29 | 51.29 |
3 | 0x26b2aad259273de76f6299bb477f9ea829bc946e | 667 | 667 | 25668.37 | 38.48 | 38.48 |
4 | 0x76951f6e84213f189fee1524d382b312dfd85ebc | 1050 | 1037 | 24767.36 | 23.59 | 23.59 |
5 | 0x1d45856c85f2f4425f57c848ea503d5ff4e1f857 | 344 | 344 | 23322.21 | 67.8 | 67.8 |
6 | 0xc22395ad28aa56566ae847859ea744c02f9a2f42 | 523 | 522 | 20906.09 | 39.97 | 39.97 |
7 | 0xd2c912039ae856874814150f0b51921cb4ff25a9 | 434 | 336 | 19774.05 | 45.56 | 45.56 |
8 | 0x3dbd94f0c7226bd943a0afdc5de68ef766764f07 | 887 | 887 | 15881.29 | 17.9 | 17.9 |
9 | 0x6f3e3606a0418e690cd36db180a0a2754ab39fb3 | 249 | 249 | 14995.72 | 60.22 | 60.22 |
10 | 0xf81848273c326bbe496273ef4c6443090c15dbbc | 1390 | 1390 | 14211.08 | 10.22 | 10.22 |
ellerydurwinnmidonm
Updated 2025-04-03
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 nft_transfers_with_price AS (
SELECT
t.block_timestamp,
t.from_address,
t.to_address,
t.token_id,
t.quantity,
t.tx_hash,
COALESCE(p.price, 0) as token_price
FROM ronin.nft.ez_nft_transfers t
LEFT JOIN ronin.price.ez_prices_hourly p
ON DATE_TRUNC('hour', t.block_timestamp) = p.hour
AND p.symbol = 'RON'
WHERE t.contract_address = '0x32950db2a7164ae833121501c797d79e7b79d74c'
AND t.block_timestamp >= DATEADD('day', -30, CURRENT_DATE())
AND t.from_address != '0x0000000000000000000000000000000000000000'
),
transfers_with_value AS (
SELECT
n.*,
ft.value as transaction_value
FROM nft_transfers_with_price n
LEFT JOIN ronin.core.fact_transactions ft
ON n.tx_hash = ft.tx_hash
),
trading_volume AS (
SELECT
from_address as trader,
COUNT(*) as number_of_trades,
COUNT(DISTINCT token_id) as unique_axies_traded,
-- SUM(token_price * CAST(quantity AS FLOAT) * transaction_value) as total_volume_usd,
-- AVG(token_price * CAST(quantity AS FLOAT) * transaction_value) as avg_trade_value_usd
SUM(token_price * transaction_value) as total_volume_usd,
AVG(token_price * transaction_value) as avg_trade_value_usd
Last run: 24 days ago
10
759B
5s