test pool liquidity

SocioAnalyticatest pool liquidity

Updated 2024-03-14

-- with created_pools as (

-- select

-- REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}') as segmented_data,

-- lower('0x' || substr(topics[1]::string, 27, 40)) as token0,

-- lower('0x' || substr(topics[2]::string, 27, 40)) as token1,

-- lower('0x' || substr(segmented_data[1]::string, 25, 40 )) as pool_address

-- from blast.core.fact_event_logs

-- where contract_address = '0x71b08f13b3c3af35aadeb3949afeb1ded1016127'

-- and topics[0] = '0x783cca1c0412dd0d695e784568c96da2e9c22ff989357a2e8b1d9b2b4e6b7118'

-- and tx_status = 'SUCCESS'

-- )

-- ,

-- add_liquidity as (

-- select

-- 'add_liquidity' as event_type,

-- block_timestamp,

-- block_number,

-- origin_from_address,

-- origin_to_address,

-- ORIGIN_FUNCTION_SIGNATURE,

-- tx_hash,

-- event_index,

-- contract_address,

-- REGEXP_SUBSTR_ALL(SUBSTR(data, 3, len(data)), '.{64}') as segmented_data,

-- livequery.utils.udf_hex_to_int(segmented_data[0]::string) as liquidity,

-- livequery.utils.udf_hex_to_int(segmented_data[1]::string) as amount_0_raw,

-- livequery.utils.udf_hex_to_int(segmented_data[2]::string) as amount_1_raw,

-- lower('0x' || substr(segmented_data[5]::string, 25, 40 )) as pool_address

-- from blast.core.fact_event_logs

-- where topics[0] = '0xbc027f10702771eefa113f3fe98d6c786f429d6a33993ff1f9db044b147b7b0c'

-- and contract_address = '0x434575eaea081b735c985fa9bf63cd7b87e227f9'

-- and tx_status = 'SUCCESS'

-- union all

QueryRunArchived: QueryRun has been archived

flipside