lo.tx_hash,

'Buy' as event,

block_timestamp,

origin_from_Address as buyer,

DECODED_LOG:sell:price / pow(10, 18) as trade_amount,

DECODED_LOG:sell:tokenId as tokenId,

DECODED_LOG:sell:trader as Seller

FROM

blast.core.ez_decoded_event_logs lo

WHERE

lo.contract_address in( '0x56bfb3a51a7a2d4f685e5107cee05a58a0f1ad61','0x5b8c52f4ebdb7c1eb01405a6e03916bba2a974c9')

and event_name = 'Buy'

union

all

SELECT

lo.tx_hash,

'Accept bid' as event,

block_timestamp,

origin_from_Address as Seller,

DECODED_LOG:buyOrder:price / pow(10, 18) as trade_amount,

DECODED_LOG:buyOrder:tokenId as tokenId,

DECODED_LOG:buyOrder:trader as buyer

FROM

blast.core.ez_decoded_event_logs lo

WHERE

lo.contract_address in( '0x56bfb3a51a7a2d4f685e5107cee05a58a0f1ad61','0x5b8c52f4ebdb7c1eb01405a6e03916bba2a974c9')

and event_name = 'Sell'

order by 3 desc

limit 5000