with get_data as (

-- 1 - Meteora Volume

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/832194a8-c480-4924-badd-1f9a7ae47d00/data/latest'):data as response

union all

-- 2 - Orca Volume

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/62cdce36-37d6-49ed-9aac-77c9d5d3df71/data/latest'):data as response

union all

-- 3 - Raydium CLMM Volume

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/23c2d554-b63d-4508-8ed5-d51ce5f0ef86/data/latest'):data as response

union all

-- 4 - Raydium DLMM Volume

select

livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/1982171d-e84e-4739-8661-1dfa974fbf4d/data/latest'):data as response

, pools_details as (

select

--block_timestamp

-- , index

-- , event_type

iff(event_type = 'initialize', 0, 1) as account_index

, decoded_instruction:accounts[3 + account_index]:pubkey as pool_address

, decoded_instruction:accounts[7 + account_index]:pubkey as token_x