NFT_CONTRACT | COLLECTION | TOTAL_TRADES | TOTAL_ITEMS | TOTAL_VOLUME_USD | UNIQUE_BUYERS | |
|---|---|---|---|---|---|---|
1 | 0x727b7ff568e7173134eb02517c4a87eac390a77b | Fableborne Kingdoms | 2531 | 3388 | 820852.858617 | 851 |
SandeshNFT Sales Ronin Fableborne
Updated 2025-03-11
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
›
⌄
-- forked from NFT Sales Ronin copy @ https://flipsidecrypto.xyz/studio/queries/d687444e-19f1-4f5c-b056-1299dcaa14b9
-- forked from NFT Sales Ronin @ https://flipsidecrypto.xyz/studio/queries/3c03198a-52d7-4ded-8ba6-6563f032e338
-- forked from TLM https://flipsidecrypto.xyz/TheLaughingMan/q/zd9PrybB0sGM/daily-stats
with offer_sales as (
SELECT
logs.block_timestamp
, 'collection-offer' as label
, logs.tx_hash
, buyer
, seller
, symbol
, amount
, amount_usd
, collection
, nft_contract
, token_id
, quantity
from ronin.core.fact_event_logs logs
LEFT JOIN (
SELECT
tx_hash
, from_address as buyer
, symbol
, amount
, amount_usd
from ronin.core.ez_token_transfers
WHERE 1=1
--AND tx_hash = '0xb93daf89d0a2a32e00382888ce2425e058319751fc481768cd5fc53f82f5f86e'
AND to_address = '0x3ef234bc2a04d86f6041e419458d9acbd077f2c1' --Collection Offer Proxy
) pays on logs.tx_hash = pays.tx_hash
LEFT JOIN (
SELECT
tx_hash
, from_address as seller
Last run: about 1 month ago
1
98B
13s