SELECT

block_timestamp,

TX_HASH,

origin_from_Address AS Seller,

DECODED_LOG:offerer::STRING AS buyer,

DECODED_LOG:consideration[0]:token::STRING AS collection_Address,

DECODED_LOG:consideration[0]:identifier::STRING AS TOKENID,

DECODED_LOG:offer[0]:amount/1e18::NUMBER AS price_SEI,

price_SEI*price AS price_USD,

DATE_TRUNC('day', block_timestamp) as date_day

FROM sei.core_evm.ez_decoded_event_logs

INNER JOIN sei.price.ez_prices_hourly

ON symbol='WSEI'

AND HOUR=date_trunc('hour',block_timestamp)

WHERE EVENT_NAME='OrderFulfilled'

AND origin_to_Address='0x224ecb4eae96d31372d1090c3b0233c8310dbbab' and block_timestamp::Date >= '2024-12-03'

union ALl

SELECT

block_timestamp,

TX_HASH,

origin_from_Address AS buyer,

DECODED_LOG:offerer::STRING AS seller,

DECODED_LOG:consideration[0]:token::STRING AS collection_Address,

DECODED_LOG:consideration[0]:identifier::STRING AS TOKENID,

DECODED_LOG:consideration[0]:amount/1e18::NUMBER AS price_SEI,

price_SEI*price AS price_USD,

DATE_TRUNC('day', block_timestamp) as date_day

FROM sei.core_evm.ez_decoded_event_logs

INNER JOIN sei.price.ez_prices_hourly

ON symbol='WSEI'

AND HOUR=date_trunc('hour',block_timestamp)

WHERE EVENT_NAME='OrderFulfilled'

AND origin_to_Address='0x0000000000000068f116a894984e2db1123eb395' and block_timestamp::Date >= '2024-12-03'