BLOCK_NUMBER,

BLOCK_TIMESTAMP,

VERSION,

TX_HASH,

EVENT_ADDRESS,

'Mercato' as marketplace,

EVENT_DATA:bid_buyer as buyer,

EVENT_DATA:bid:inner as bid_inner,

to_timestamp(EVENT_DATA:timestamp) as bidding_timestamp,

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

EVENT_DATA:collection:inner as collection_inner

from aptos.core.fact_events

where event_address in ('0xe11c12ec495f3989c35e1c6a0af414451223305b579291fc8f3d9d0575a23c26')

and EVENT_MODULE = 'biddings_v2'

and EVENT_RESOURCE = 'DeleteCollectionBidEvent'

and SUCCESS = 'true'

and TX_TYPE = 'user_transaction'

order by 2 desc

limit 100