Panora - Pool's Swap Performance

0xHaM-dPanora - Pool's Swap Performance

Updated 2025-05-18

with swapEvent as (

SELECT

BLOCK_TIMESTAMP,

TX_HASH,

SENDER,

EVENT_DATA:input_amount as amount_in_raw,

EVENT_DATA:output_amount as amount_out_raw,

EVENT_DATA:x_type_info as token_in,

EVENT_DATA:y_type_info as token_out

from aptos.core.fact_events

JOIN aptos.core.fact_transactions using(BLOCK_TIMESTAMP,TX_HASH)

WHERE PAYLOAD_FUNCTION ilike '0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c%'

AND EVENT_ADDRESS ilike '0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c'

-- AND TX_HASH = '0x92c0447952e2a429ecaa469b02e2c2267fa553b95663a19335ad4e5fbfe2b65e'

AND SUCCESS = TRUE

AND TX_TYPE = 'user_transaction'

AND EVENT_MODULE ilike any ('panora%')

AND EVENT_RESOURCE ilike 'Swap%'

UNION ALL

SELECT

BLOCK_TIMESTAMP,

TX_HASH,

SENDER,

EVENT_DATA:input_amount as amount_in_raw,

EVENT_DATA:output_amount as amount_out_raw,

split(split(EVENT_TYPE, ',')[0], '<')[1] as token_in,

split(split(EVENT_TYPE, ', ')[1], '>')[0] as token_out,

from aptos.core.fact_events

JOIN aptos.core.fact_transactions using(BLOCK_TIMESTAMP,TX_HASH)

WHERE PAYLOAD_FUNCTION ilike '0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c%'

AND EVENT_ADDRESS ilike '0x1c3206329806286fd2223647c9f9b130e66baeb6d7224a18c1f642ffe48f3b4c'

-- AND TX_HASH = '0xa86e42f60402acfbf068c147b5656e857315fde1aa4227772db24d347ce51487'

AND SUCCESS = TRUE

AND TX_TYPE = 'user_transaction'

AND EVENT_MODULE ilike ('SwapGPT%')

AND EVENT_RESOURCE ilike 'Swap%'

Last run: about 1 month ago

2KB

340s

flipside