SELECT

tx_hash,

block_timestamp,

from_address as seller,

to_address as buyer,

contract_address as nft_contract,

name as collection,

token_id,

quantity

FROM ronin.nft.ez_nft_transfers

WHERE block_timestamp >= DATEADD(day, -90, CURRENT_TIMESTAMP) --

),

token_payments AS (

SELECT

tx_hash,

from_address as buyer,

symbol,

amount,

amount_usd

FROM ronin.core.ez_token_transfers

WHERE to_address IN (

'0x3ef234bc2a04d86f6041e419458d9acbd077f2c1',

'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3',

'0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc'

)

),

nft_sales AS (

SELECT

nft.tx_hash,

nft.block_timestamp,

nft.seller,

nft.buyer,

nft.collection,