No Data to Display
SandeshNFT trades copy
Updated 2025-03-26
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 trades @ https://flipsidecrypto.xyz/studio/queries/a0501b02-ed37-48a9-8d22-2fb4f1f602d5
-- 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
, contract_address as nft_contract
, name as collection
Last run: 29 days ago
0
2B
12s