with vrtx as ( select value[0] as DATE_DAY, datediff('day', '2023-12-01',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/07ed3c0c-229d-4a37-8455-394e17b22385/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2024-01-27' and date_day>='2023-12-01' ), winr as ( select value[0] as DATE_DAY, datediff('day', '2023-12-01',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/3058ee99-0c75-4459-991a-d0c554660556/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2024-01-27' and date_day>='2023-12-01' ), grail as ( select value[0] as DATE_DAY, datediff('day', '2023-11-03',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/c57b891b-e631-4bd9-a9c9-f93e5fe4e359/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2023-12-30' and date_day>='2023-11-03' ), svy as ( select value[0] as DATE_DAY, datediff('day', '2023-12-01',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/580c9870-74b2-480c-ae05-cb53972b170a/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2024-01-27' and date_day>='2023-12-01' ), lode as ( select value[0] as DATE_DAY, datediff('day', '2023-11-03',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/ea59f11f-f6eb-4603-ad10-e0b75ccaeae6/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2023-12-30' and date_day>='2023-11-03' ), magic as ( select value[0] as DATE_DAY, datediff('day', '2023-12-01',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/e4ce0346-1d2d-49e0-8f9d-1c6c8bc47edb/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2024-04-19' and date_day>='2023-12-01' ), gmx as ( select value[0] as DATE_DAY, datediff('day', '2023-11-03',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/cc2c601a-c1f8-4e5d-8d96-cd54ac52d596/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2024-01-27' and date_day>='2023-11-03' ), alp as ( select value[0] as DATE_DAY, datediff('day', '2023-11-03',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/9958f5e1-ead0-4c80-a098-82cc736c50df/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2023-12-30' and date_day>='2023-11-03' ), lbr as ( select value[0] as DATE_DAY, datediff('day', '2023-11-03',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/ab425988-7d4b-43ed-92e2-d7446c9ba280/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2023-12-30' and date_day>='2023-11-03' ), rdnt as ( select value[0] as DATE_DAY, datediff('day', '2023-12-29',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/36e2186b-79ff-4561-914f-7a02162f7bed/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2024-02-10' and date_day>='2023-12-29' ), pendle as ( select value[0] as DATE_DAY, datediff('day', '2023-11-03',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/94006083-4853-4d64-9b49-c01a507c87a0/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2024-04-19' and date_day>='2023-11-03' ), alpha as ( select value[0] as DATE_DAY, datediff('day', '2023-12-29',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/aa93d216-bdee-48b4-9145-384c168d9eaf/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2024-02-10' and date_day>='2023-12-29' ), gmlp as ( select value[0] as DATE_DAY, datediff('day', '2023-11-03',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/299fbbd3-b5f8-42d2-9007-696b867f13e4/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2023-12-30' and date_day>='2023-11-03' ), ctx as ( select value[0] as DATE_DAY, datediff('day', '2023-12-15',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/9ae50269-efae-433f-9764-44c5576e158b/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2024-03-09' and date_day>='2023-12-15' ), woo as ( select value[0] as DATE_DAY, datediff('day', '2023-11-03',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/e7794e68-f178-4d93-8a46-6648e0165c33/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2023-12-30' and date_day>='2023-11-03' ), gns as ( select value[0] as DATE_DAY, datediff('day', '2023-12-01',date_day) as day_num, value[1] as PAIR_NAME, value[4] as ROLLING_AVG_TVL, first_value(ROLLING_AVG_TVL) over (order by day_num asc) as MIN_TVL, (ROLLING_AVG_TVL-MIN_TVL)*100/MIN_TVL AS PERCENT_CHANGE from ( SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/queries/3c87c326-8c7a-496a-a9c7-f25b31884035/latest-run' ) as response ), lateral FLATTEN (input => response:data:result:rows) where date_day<='2024-01-27' and date_day>='2023-12-01' ) select day_num, percent_change, pair_name from ( select * from vrtx union all select * from winr union all select * from grail union all select * from gmx union all select * from lode union all select * from magic union all select * from alp union all select * from svy union all select * from lbr union all select * from rdnt union all select * from pendle union all select * from alpha union all select * from ctx union all select * from gmlp union all select * from woo union all select * from gns )

STIP Trader Joe KPI Dashboard