Total (Swap Path)

RayyykTotal (Swap Path)

Updated 2 days ago

-- thorchain

with res1 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/f27444e1-7260-4b47-aa5e-672294345e37/data/latest') as result),

data1 as (select result:data as json_result_must_pivot from res1),

thorchain as (select 'THORChain' as platform,

value:SWAP_PATH as swap_path,

value:AFFILIATE_FEE_USD as fee_usd,

value:VOLUME_USD as volume_usd

from data1,

LATERAL FLATTEN(input => data1.json_result_must_pivot::VARIANT) d),

-- maya

res2 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/d2e57e59-9940-4124-b4d1-c4c52918632f/data/latest') as result),

data2 as (select result:data as json_result_must_pivot from res2),

maya as (select 'Maya Protocol' as platform,

value:SWAP_PATH as swap_path,

value:AFFILIATE_FEE_USD as fee_usd,

value:VOLUME_USD as volume_usd

from data2,

LATERAL FLATTEN(input => data2.json_result_must_pivot::VARIANT) d),

-- lifi

res3 as(select livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/c2bd718d-e047-4372-a2ef-cf45649bcd04/data/latest') as result),

data3 as (select result:data as json_result_must_pivot from res3),

lifi as (select 'LiFi' as platform,

value:SWAP_PATH as swap_path,

value:FEE_USD as fee_usd,

value:VOLUME_USD as volume_usd

from data3,

LATERAL FLATTEN(input => data3.json_result_must_pivot::VARIANT) d),

Last run: 2 days ago

...

244

10KB