SELECT

e.block_timestamp,

e.tx_hash,

t.symbol,

t.amount,

t.amount_usd,

n.token_id,

n.quantity,

n.contract_address AS nft_contract

FROM ronin.core.fact_event_logs e

LEFT JOIN ronin.core.ez_token_transfers t

ON e.tx_hash = t.tx_hash

AND t.to_address = '0x3ef234bc2a04d86f6041e419458d9acbd077f2c1' -- Fableborne Contract

LEFT JOIN ronin.nft.ez_nft_transfers n

ON e.tx_hash = n.tx_hash

WHERE e.contract_address = '0x3ef234bc2a04d86f6041e419458d9acbd077f2c1'

AND e.TOPIC_0 = '0x0306217cf6445fd510a19c9de37c8de6385bdaf25ae48240b0c9e70e18ad425e'

AND e.block_timestamp >= DATEADD(DAY, -30, CURRENT_DATE)

),

sales_summary AS (

SELECT

nft_contract,

COUNT(DISTINCT tx_hash) AS total_sales,

SUM(amount) AS total_volume,

SUM(amount_usd) AS total_volume_usd

FROM sales_data

WHERE nft_contract = '0x727b7ff568e7173134eb02517c4a87eac390a77b' -- Fableborne Kingdoms contract

GROUP BY nft_contract

total_sales,

total_volume,

total_volume_usd