Trader Address | Total Trades | Total Volume (USD) | |
|---|---|---|---|
1 | 0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc | 116778 | 4492731.4 |
2 | 0x7467a7ac7f29c9b654349493b0f41e4eaa2a685a | 53512 | 729807.35 |
3 | 0x8c260ff164446b32abe6f98b343fab6cefde059f | 12071 | 180417.45296868 |
4 | 0xdc137922d89c629a22c287ac63fa6ea2fdc3aa69 | 9563 | 134579.07 |
5 | 0x8b8e1d77b16f614923acd718257aca260fb9a92f | 7786 | 153065.920725116 |
6 | 0x728ffa00dd9f7c63d71d14746f10e66b9b2a5e39 | 6702 | 100879.91 |
7 | 0x9ce9895a921f0b19eea852ddf82cc3070ede58ed | 6686 | 101276.56 |
8 | 0xebe533ee081d0d1bbeb7d5b4b7b81184ab6e30b2 | 6671 | 100477.19 |
9 | 0x12140eb0d27d8b5bd8b2b0ba704ac52c103f6ca1 | 6667 | 101671.29 |
10 | 0x2dc1c84dfb0b5c0bff3ed8a93bb0ab5abc6e4003 | 6662 | 101562.6 |
11 | 0x0aa18964847cb76d2c3990d26739f18ebdb8b04d | 6656 | 101120.43 |
12 | 0xf33077432ca4d8f1ec6f880dfb8d632a1da74953 | 6645 | 101635.65 |
13 | 0x3ede8901d5e8384fabec5baefe3fced4b5a03347 | 6645 | 101936.87 |
14 | 0x2f49fe0b9582627f14f4253dd71098ffe840572c | 6645 | 100552.19 |
15 | 0x9dc1afdce53265d8f1ebb71422c038bbe56eeafa | 6639 | 101723.97 |
16 | 0x2fa97f0eaa7dc8c434e74f7e85e6d4284c2828e8 | 6626 | 100912.48 |
17 | 0xe42f620064e7845c80ecce1f7088ad348e65117d | 6619 | 100812.15 |
18 | 0x107b72fb0d640ea57a36d900230f148bbfb52475 | 6615 | 99659.92 |
19 | 0x6edb6b4a9593a3790e54b65e6393f4d094916eba | 6599 | 100051.75 |
20 | 0x18e7be7af6e7830414d3ed307b117bcbec4c520c | 6595 | 101642.4 |
Mrftiscared-magenta
Updated 5 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 5 hours agoAuto-refreshes every 12 hours
100
6KB
161s