BLOCK_NUMBER,

BLOCK_TIMESTAMP,

VERSION,

TX_HASH,

EVENT_ADDRESS as MARKETPLACE_ADDRESS,

'OKX' as MARKETPLACE,

EVENT_DATA:amount as NFT_COUNT,

EVENT_DATA:id as LIST_ID,

EVENT_DATA:token_id:token_data_id:collection as COLLECTION_NAME,

EVENT_DATA:token_id:token_data_id:name as NFT_ID,

EVENT_DATA:min_price/pow(10,8) as LIST_PRICE,

EVENT_DATA:id:addr as SELLER,

EVENT_DATA:token_id:token_data_id:creator as CREATOR_ADDDRESS,

EVENT_DATA:market_address as MARKET_ADDRESS

from aptos.core.fact_events

where event_address in ('0x1e6009ce9d288f3d5031c06ca0b19a334214ead798a0cb38808485bd6d997a43')

and EVENT_MODULE = 'okx_listing_utils'

and EVENT_RESOURCE = 'ListingEvent<0x1'

and SUCCESS = 'true'

and TX_TYPE = 'user_transaction'

order by 2 desc

limit 100