NFT_TYPE | TOTAL_SALES | VOLUME_USD | CREATOR_ROYALTIES_USD | FEES_USD | USER_COUNT | |
|---|---|---|---|---|---|---|
1 | Runiverse Item | 14239 | 263957.0848444 | 6598.92712111 | 13197.85424222 | 23888 |
2 | Runiverse Land | 2763 | 1421891.34906849 | 35547.283726712 | 71094.567453424 | 3184 |
3 | Combined Total | 16997 | 1685848.43391289 | 42146.210847822 | 84292.421695644 | 25492 |
Kruys-Collinsunable-orange
Updated 5 days ago
999
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 (
-- All Runiverse NFT transfers (direct transfers and marketplace)
SELECT
tx_hash,
block_timestamp,
from_address,
to_address,
token_id,
quantity,
name AS nft_name,
contract_address,
CASE
WHEN contract_address = '0x578b65568b7a6a081a477748590774a64d8a4923' THEN 'Runiverse Item'
WHEN contract_address = '0x775f0a0bb8258501d0862df38a7f7ad8f8f7423d' THEN 'Runiverse Land'
ELSE 'Other'
END AS nft_type
FROM ronin.nft.ez_nft_transfers
WHERE name ILIKE '%runiverse%'
AND contract_address IN (
'0x578b65568b7a6a081a477748590774a64d8a4923', -- RuniverseItem
'0x775f0a0bb8258501d0862df38a7f7ad8f8f7423d' -- RuniverseLand
)
AND to_address != '0x0000000000000000000000000000000000000000' -- Exclude burns
),
marketplace_transactions AS (
-- Identify marketplace transactions with payment information
-- The filter and addresses for marketplace transactions was forked from Mrfti / scared-magenta copy @ https://flipsidecrypto.xyz/Mrfti/q/2qli-28Wm1Jz/scared-magenta-copy
SELECT
logs.tx_hash,
pays.from_address AS buyer,
nfts.from_address AS seller,
pays.amount_usd AS transaction_value,
nfts.block_timestamp,
nfts.nft_type
FROM ronin.core.fact_event_logs logs
Last run: 5 days ago
3
234B
21s