BLOCK_NUMBER,

BLOCK_TIMESTAMP,

VERSION,

TX_HASH,

EVENT_ADDRESS,

'BlueMove' as marketplace,

EVENT_DATA:bid/pow(10,8) as price,

EVENT_DATA:bider_address as seller,

EVENT_DATA:id:token_data_id:collection as collection_name,

EVENT_DATA:id:token_data_id:name as nft_name,

EVENT_DATA:id:token_data_id:creator as creator_address

from aptos.core.fact_events

where event_address in ('0xd1fd99c1944b84d1670a2536417e997864ad12303d19eac725891691b04d614e')

and EVENT_MODULE = 'marketplaceV2'

and EVENT_RESOURCE = 'BidEvent'

and SUCCESS = 'true'

and TX_TYPE = 'user_transaction'

order by 2 desc

limit 100