decode_swap_data_ink

tkvresearchdecode_swap_data_ink

Updated 2025-04-01

select decoded_log:pool::variant as pool_contract,

'Velodrome' as label

from ink.core.ez_decoded_event_logs

where

ORIGIN_FUNCTION_SIGNATURE = '0xb7e0d4c0'

and

event_name = 'PoolCreated'

union all

select decoded_log:pair::variant as pool_contract,

'Inkyswap' as label

from ink.core.ez_decoded_event_logs

where

ORIGIN_FUNCTION_SIGNATURE = '0x83451838'

and

event_name = 'PairCreated'

union all

select decoded_log:pool::variant as pool_contract,

'Velodrome Slipstream' as label

from ink.core.ez_decoded_event_logs

where

ORIGIN_FUNCTION_SIGNATURE = '0xb5007d1f'

and

event_name = 'PoolCreated'

union all

select decoded_log:pair::variant as pool_contract,

'Squid Swap' as label

from ink.core.ez_decoded_event_logs

where

ORIGIN_FUNCTION_SIGNATURE = '0xe8078d94'

and

event_name = 'SetAutomatedMarketMakerPair'

--take contract of DYOR Swap

-- select *,

-- '0x' || SUBSTR(DATA, 27, 40) AS pair

-- -- TO_NUMBER(SUBSTR(DATA, 67, 64), 16) AS arg3

Last run: 25 days ago

4KB

flipside