TRADE_WEEK | Highest Price Paid USD | Unique Buyer Wallets | |
|---|---|---|---|
1 | 2024-09-30 00:00:00.000 | 1620.3 | 79 |
2 | 2024-10-07 00:00:00.000 | 1337.99 | 82 |
3 | 2024-10-14 00:00:00.000 | 520.25 | 101 |
4 | 2024-10-21 00:00:00.000 | 345.76 | 62 |
5 | 2024-10-28 00:00:00.000 | 2218.5 | 45 |
6 | 2024-11-04 00:00:00.000 | 309.02 | 52 |
7 | 2024-11-11 00:00:00.000 | 369.5 | 41 |
8 | 2024-11-18 00:00:00.000 | 3097 | 43 |
9 | 2024-11-25 00:00:00.000 | 4039.2 | 38 |
10 | 2024-12-02 00:00:00.000 | 33869.1 | 75 |
11 | 2024-12-09 00:00:00.000 | 3195 | 247 |
12 | 2024-12-16 00:00:00.000 | 877.8 | 105 |
13 | 2024-12-23 00:00:00.000 | 343.8 | 45 |
14 | 2024-12-30 00:00:00.000 | 836.22 | 66 |
15 | 2025-01-06 00:00:00.000 | 1791 | 71 |
16 | 2025-01-13 00:00:00.000 | 6130.88 | 269 |
17 | 2025-01-20 00:00:00.000 | 317.52 | 94 |
18 | 2025-01-27 00:00:00.000 | 1950.48055 | 48 |
19 | 2025-02-03 00:00:00.000 | 663 | 61 |
20 | 2025-02-10 00:00:00.000 | 670.27 | 48 |
Kruys-Collinsthoughtful-gold
Updated 2025-04-01
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 runiverse_nft_transfers AS (
SELECT
tx_hash,
block_timestamp,
from_address,
to_address,
token_id,
quantity,
name AS nft_name
FROM ronin.nft.ez_nft_transfers
WHERE name ILIKE '%runiverse%'
AND to_address != '0x0000000000000000000000000000000000000000' -- Exclude burns
),
marketplace_transactions AS (
SELECT
logs.tx_hash,
pays.from_address AS buyer,
nfts.from_address AS seller,
pays.amount_usd AS transaction_value,
nfts.block_timestamp
FROM ronin.core.fact_event_logs logs
INNER JOIN (
SELECT tx_hash, from_address, block_timestamp
FROM runiverse_nft_transfers
) nfts ON logs.tx_hash = nfts.tx_hash
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
Last run: 27 days ago
27
1KB
11s