DATE_TRUNC(transactions.block_timestamp) AS date,

events.tx_hash,

events.origin_to_address AS marketplace,

events.event_inputs:from AS seller,

events.event_inputs:to AS buyer,

events.event_inputs:tokenId AS token,

events.contract_address AS collection,

transactions.matic_value AS price

polygon.core.fact_event_logs events

polygon.core.fact_transactions transactions

events.tx_hash = transactions.tx_hash

events.block_timestamp::date >= (CURRENT_DATE - 30)

AND

events.event_inputs:tokenId IS NOT NULL

AND

events.event_name = 'Transfer'

AND

events.tx_status = 'SUCCESS'

AND

events.event_inputs:from <> '0x0000000000000000000000000000000000000000'

AND

events.event_inputs:to <> '0x0000000000000000000000000000000000000000'

AND

transactions.matic_value > 0

AND

events.contract_address = '0x9d5533a41578917ac1ece34078f7b8dd5a24bc7e'