banbannardOptimism Velo Bounty 3
Updated 2022-07-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
⌄
select data,
regexp_substr_all(SUBSTR(DATA, 2, len(DATA)), '.{64}') AS segmented_data,
ethereum.public.udf_hex_to_int(
segmented_data [0] :: STRING
) AS tokenID,
segmented_data [1] :: STRING AS pool_address,
ethereum.public.udf_hex_to_int(
segmented_data [2] :: STRING
) AS deposit_type
/*
when pool_address = '0xe8537b6ff1039cb9ed0b71713f697ddbadbb717d' then 'VolatileV1 AMM - VELO/USDC'
when pool_address = '0x47029bc8f5cbe3b464004e87ef9c9419a48018cd' then 'VolatileV1 AMM - OP/USDC'
when pool_address = '0xd16232ad60188b68076a235c65d692090caba155' then 'StableV1 AMM - USDC/sUSD'
when pool_address = '0xffd74ef185989bff8752c818a53a47fc45388f08' then 'VolatileV1 AMM - VELO/OP'
when pool_address = '0x79c912fef520be002c2b6e57ec4324e260f38e50' then 'VolatileV1 AMM - WETH/USDC'
when pool_address = '0xfd7fddfc0a729ecf45fb6b12fa3b71a575e1966f' then 'StableV1 AMM - WETH/sETH'
when pool_address = '0x4f7ebc19844259386dbddb7b2eb759eefc6f8353' then 'StableV1 AMM - USDC/DAI'
when pool_address = '0x207addb05c548f262219f6bfc6e11c02d0f7fdbe' then 'StableV1 AMM - USDC/LUSD'
when pool_address = '0x9355292f66552ea5717b274d27eefc8254011d83' then 'VolatileV1 AMM - THALES/USDC'
when pool_address = '0xcdd41009e74bd1ae4f7b2eecf892e4bc718b9302' then 'VolatileV1 AMM - WETH/OP'
else null
end as pool_names, */
from optimism.core.fact_event_logs
where tx_hash = '0x516c3537d534415e5d00845b6b718d93d5f2066e1f9aa795931177b21b5bf5b0'
Run a query to Download Data