SELECT

block_timestamp,

tx_hash,

buyer_address,

seller_address,

origin_from_address,

origin_to_address,

nft_address

FROM

ethereum.core.ez_nft_sales

WHERE

1 = 1

AND block_timestamp::DATE BETWEEN '2022-06-01' AND '2022-06-30'

AND platform_name = 'opensea'

AND event_type IN ('sale')

LIMIT 10

SELECT

s.block_timestamp,

s.tx_hash,

s.buyer_address,

s.seller_address,

l.tx_status,

l.event_inputs:_from,

l.event_inputs:_to

FROM

base_sales AS s

LEFT JOIN ethereum.core.fact_event_logs AS l

ON l.topics[0] IN (

'0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62',

'0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

)

AND s.tx_hash = l.tx_hash

AND s.origin_from_address = l.origin_from_address