block_number,

block_timestamp,

version,

tx_hash,

success,

payload_function,

(CASE

when event_resource = 'BuyEvent' THEN 'Market Buy'

when event_resource = 'SellEvent' THEN 'Accepted Bid'

when event_resource = 'FillCollectionBidEvent' THEN 'Accepted Collection Bid'

END

) AS event,

event_address,

event_data,

event_data:amount AS quantity,

event_data:seller AS seller,

event_data:buyer AS buyer,

event_data:price/pow(10,8) AS price,

(event_data:price/pow(10,8))*2.5/100 AS platform_fee,

event_data:token_id:token_data_id:collection AS collection_name,

event_data:token_id:token_data_id:name AS nft_id,

event_data:token_id:token_data_id:creator AS collection_creator,

account_address AS platform_address,

'Topaz' AS platform_name

FROM aptos.core.fact_events

WHERE event_module = 'events'

AND account_address = '0x2c7bccf7b31baf770fdbcc768d9e9cb3d87805e255355df5db32ac9a669010a2'

AND event_resource IN ('BuyEvent','SellEvent','FillCollectionBidEvent')

ORDER BY 2 DESC

LIMIT 100