Trader Address | Total Volume (USD) | Total Trades | |
|---|---|---|---|
1 | 0x46665d63cea2fcc4fd883d4a387e2b6d27d2f307 | 41429831.05 | 45 |
2 | 0xc2230fe48b9c66703f2ca6f9a7df1e67bff39c9c | 5913553.53792628 | 169 |
3 | 0xf5c68545948f94a8e109be7fe0040b8ff3fe40c4 | 5803423.24740532 | 152 |
4 | 0x66029a4eeb0bd288eb4953060126f311dff40a19 | 5671899.95498058 | 149 |
5 | 0xe5c31590b812abbb2d591166788876782fb512ba | 5637210.01609567 | 155 |
6 | 0xd61698a82ebe18563b1f6051e34c9b691b6fe6f8 | 4954672.90382611 | 190 |
7 | 0x3b1f256256265b7750c62ca3aa6a94a2157112cc | 4552877.51 | 164 |
8 | 0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc | 4498617.55 | 118111 |
9 | 0x149fe28aa39c280815a6ba917b817b06cd968bcf | 3959981.30036334 | 180 |
10 | 0x6a0f683e2c6bb04ad859298daaafe08ea41c7aba | 2842138.92 | 184 |
11 | 0x81f721c2c86ed240d09a5061b4315a0709522e0a | 2348708.63328 | 19 |
12 | 0x9c680197a02dbc645b03c7094d4c8025be850c2a | 2335442.04297689 | 220 |
13 | 0x2ecb08f87f075b5769fe543d0e52e40140575ea7 | 2141190.77 | 2707 |
14 | 0xa9f34ab6c0655111557a5f0aa43126be44d414e4 | 1806448.91 | 39 |
15 | 0xfc3c962fad2c1cc77f1a0d46e7b8a2de79a21774 | 1620019.28 | 16 |
16 | 0xc0fc9bfd335cde161598070812c3d59e26863518 | 1333678.97788202 | 1256 |
17 | 0x0ed1a0fb0cffc913d6dc25e28bc13010b66531c1 | 1264407.17 | 67 |
18 | 0xf17c498693bf1a8241fcaf5111ed15519c6d9bef | 1208306.76908166 | 1852 |
19 | 0xa4c8fb6e77ed0e3d862302a4c70c07db04aafaa7 | 1079700.91 | 9 |
20 | 0x39152aa1a78ea8961b7f7bfcebaf700aea2040ab | 1035572.38977955 | 205 |
Mrftisleepy-pink
Updated 24 hours 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 nft_trades AS (
SELECT
logs.tx_hash,
nfts.from_address AS seller,
pays.from_address AS buyer,
pays.amount_usd
FROM ronin.core.fact_event_logs logs
LEFT JOIN (
SELECT
tx_hash,
from_address,
amount_usd
FROM ronin.core.ez_token_transfers
WHERE to_address IN (
'0x3ef234bc2a04d86f6041e419458d9acbd077f2c1', -- Collection Offer Proxy
'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3', -- Market Gateway Proxy
'0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' -- Market Gateway Multi Send Proxy
)
UNION ALL
SELECT
tx_hash,
from_address,
amount_usd
FROM ronin.core.ez_native_transfers
WHERE to_address IN (
'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3', -- Market Gateway Proxy
'0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' -- Market Gateway Multi Send Proxy
)
AND trace_index = 0
) pays ON logs.tx_hash = pays.tx_hash
LEFT JOIN (
SELECT
tx_hash,
from_address
FROM ronin.nft.ez_nft_transfers
WHERE is_mint = 'FALSE'
Last run: about 24 hours agoAuto-refreshes every 12 hours
100
6KB
77s