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

, token_id

, quantity

from ronin.nft.ez_nft_transfers