with final_tab as ( ---------------------------AVAX------------------------------------ WITH AVAX AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7' group by 1) select "Price Range", count(distinct day) as "Day Count", 'AVAX' as "Currency" from tab1 group by 1 order by 2), ----------------------------PTP--------------------------------------- PTP AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x22d4002028f537599be9f666d1c4fa138522f9c8' group by 1) select "Price Range", count(distinct day) as "Day Count", 'PTP' as "Currency" from tab1 group by 1 order by 2), ------------------------PNG----------------------------------------------------- PNG AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x60781c2586d68229fde47564546784ab3faca982' group by 1) select "Price Range", count(distinct day) as "Day Count", 'PNG' as "Currency" from tab1 group by 1 order by 2), ----------------------------JOE------------------------------------- JOE AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x6e84a6216ea6dacc71ee8e6b0a5b7322eebc0fdd' group by 1) select "Price Range", count(distinct day) as "Day Count", 'JOE' as "Currency" from tab1 group by 1 order by 2), ----------------------------SNEK------------------------------------- SNEK AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0xeeee99b35eb6af5e7d76dd846dbe4bcc0c60ca1d' group by 1) select "Price Range", count(distinct day) as "Day Count", 'SNEK' as "Currency" from tab1 group by 1 order by 2), ----------------------------ELK------------------------------------- ELK AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0xeeeeeb57642040be42185f49c52f7e9b38f8eeee' group by 1) select "Price Range", count(distinct day) as "Day Count", 'ELK' as "Currency" from tab1 group by 1 order by 2), ----------------------------QI------------------------------------- BENQI AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x8729438eb15e2c8b576fcc6aecda6a148776c0f5' group by 1) select "Price Range", count(distinct day) as "Day Count", 'BENQI' as "Currency" from tab1 group by 1 order by 2), ----------------------------XETA------------------------------------- XETA AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x31c994ac062c1970c086260bc61babb708643fac' group by 1) select "Price Range", count(distinct day) as "Day Count", 'XETA' as "Currency" from tab1 group by 1 order by 2), ----------------------------TIME------------------------------------- TIME AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0xb54f16fb19478766a268f172c9480f8da1a7c9c3' group by 1) select "Price Range", count(distinct day) as "Day Count", 'TIME' as "Currency" from tab1 group by 1 order by 2), ----------------------------CLY------------------------------------- CLY AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0xec3492a2508ddf4fdc0cd76f31f340b30d1793e6' group by 1) select "Price Range", count(distinct day) as "Day Count", 'CLY' as "Currency" from tab1 group by 1 order by 2), ----------------------------GMD------------------------------------- GMD AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x1fe70939c2cec8f31e8f7729442658586b469972' group by 1) select "Price Range", count(distinct day) as "Day Count", 'GMD' as "Currency" from tab1 group by 1 order by 2), ----------------------------WXT------------------------------------- WXT AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0xfcde4a87b8b6fa58326bb462882f1778158b02f1' group by 1) select "Price Range", count(distinct day) as "Day Count", 'WXT' as "Currency" from tab1 group by 1 order by 2), ----------------------------XAVA------------------------------------- XAVA AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0xd1c3f94de7e5b45fa4edbba472491a9f4b166fc4' group by 1) select "Price Range", count(distinct day) as "Day Count", 'XAVA' as "Currency" from tab1 group by 1 order by 2), ----------------------------DEP------------------------------------- DEP AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0xd4d026322c88c2d49942a75dff920fcfbc5614c1' group by 1) select "Price Range", count(distinct day) as "Day Count", 'DEP' as "Currency" from tab1 group by 1 order by 2), ----------------------------DYP------------------------------------- DYP AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x961c8c0b1aad0c0b10a51fef6a867e3091bcef17' group by 1) select "Price Range", count(distinct day) as "Day Count", 'DYP' as "Currency" from tab1 group by 1 order by 2), ----------------------------DEXTF------------------------------------- DEXTF AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x03e8d118a1864c7dc53bf91e007ab7d91f5a06fa' group by 1) select "Price Range", count(distinct day) as "Day Count", 'DEXTF' as "Currency" from tab1 group by 1 order by 2), ----------------------------QI------------------------------------- QI AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0xa56f9a54880afbc30cf29bb66d2d9adcdcaeadd6' group by 1) select "Price Range", count(distinct day) as "Day Count", 'QI DAO' as "Currency" from tab1 group by 1 order by 2), ----------------------------YAK------------------------------------- YAK AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x59414b3089ce2af0010e7523dea7e2b35d776ec7' group by 1) select "Price Range", count(distinct day) as "Day Count", 'YAK' as "Currency" from tab1 group by 1 order by 2), ----------------------------NEWO------------------------------------- NEWO AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x4bfc90322dd638f81f034517359bd447f8e0235a' group by 1) select "Price Range", count(distinct day) as "Day Count", 'NEWO' as "Currency" from tab1 group by 1 order by 2), ----------------------------INFRA------------------------------------- INFRA AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0xa4fb4f0ff2431262d236778495145ecbc975c38b' group by 1) select "Price Range", count(distinct day) as "Day Count", 'INFRA' as "Currency" from tab1 group by 1 order by 2), ----------------------------MELD------------------------------------- MELD AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x333000333b26ee30214b4af6419d9ab07a450400' group by 1) select "Price Range", count(distinct day) as "Day Count", 'MELD' as "Currency" from tab1 group by 1 order by 2), ----------------------------ROCO------------------------------------- ROCO AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0xb2a85c5ecea99187a977ac34303b80acbddfa208' group by 1) select "Price Range", count(distinct day) as "Day Count", 'ROCO' as "Currency" from tab1 group by 1 order by 2), ----------------------------SB------------------------------------- SB AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x7d1232b90d3f809a54eeaeebc639c62df8a8942f' group by 1) select "Price Range", count(distinct day) as "Day Count", 'SB' as "Currency" from tab1 group by 1 order by 2), ----------------------------VTX------------------------------------- VTX AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x5817d4f0b62a59b17f75207da1848c2ce75e7af4' group by 1) select "Price Range", count(distinct day) as "Day Count", 'VTX' as "Currency" from tab1 group by 1 order by 2), ----------------------------CINU------------------------------------- CINU AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0xc11bf915db4b43714bc8d32bf83bf5ea53d40981' group by 1) select "Price Range", count(distinct day) as "Day Count", 'CINU' as "Currency" from tab1 group by 1 order by 2), ----------------------------CAI------------------------------------- CAI AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x48f88a3fe843ccb0b5003e70b4192c1d7448bef0' group by 1) select "Price Range", count(distinct day) as "Day Count", 'CAI' as "Currency" from tab1 group by 1 order by 2), ----------------------------ODDZ------------------------------------- ODDZ AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.01 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0xb0a6e056b587d0a85640b39b1cb44086f7a26a1e' group by 1) select "Price Range", count(distinct day) as "Day Count", 'ODDZ' as "Currency" from tab1 group by 1 order by 2), ----------------------------ZOO------------------------------------- ZOO AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '510 AND (max(PRICE)-min(PRICE))<=20 THEN '1020 AND (max(PRICE)-min(PRICE))<=50 THEN '2050 AND (max(PRICE)-min(PRICE))<=100 THEN '50100 AND (max(PRICE)-min(PRICE))<=500 THEN '100500 AND (max(PRICE)-min(PRICE))<=1000 THEN '5001000 THEN 'RoPC>1000 USD' END AS "Price Range" from avalanche.core.fact_hourly_token_prices where token_address='0x1b88d7ad51626044ec62ef9803ea264da4442f32' group by 1) select "Price Range", count(distinct day) as "Day Count", 'ZOO' as "Currency" from tab1 group by 1 order by 2), ----------------------------KLO------------------------------------- KLO AS (with tab1 as (select hour::date as day, CASE WHEN (max(PRICE)-min(PRICE))<=0.0001 THEN 'RoPC<=0.0001 USD' WHEN (max(PRICE)-min(PRICE))>0.0001 AND (max(PRICE)-min(PRICE))<=0.001 THEN '0.00010.001 AND (max(PRICE)-min(PRICE))<=0.01 THEN '0.0010.01 AND (max(PRICE)-min(PRICE))<=0.05 THEN '0.010.05 AND (max(PRICE)-min(PRICE))<=0.1 THEN '0.050.1 AND (max(PRICE)-min(PRICE))<=0.25 THEN '0.10.25 AND (max(PRICE)-min(PRICE))<=0.5 THEN '0.250.5 AND (max(PRICE)-min(PRICE))<=1 THEN '0.51 AND (max(PRICE)-min(PRICE))<=5 THEN '15 AND (max(PRICE)-min(PRICE))<=10 THEN '5

Insights into Avalanche Tokens: A Comprehensive Dashboard