sarathprice status1 -sushi
    Updated 2022-01-30
    with data1 as(
    SELECT symbol,sum(price) as sum from ethereum.token_prices_hourly where date_trunc('day',hour) between '2022-01-01' and '2022-01-07'
    group by 1 limit 100),
    data2 as(
    SELECT symbol,sum(price) from ethereum.token_prices_hourly where symbol='SUSHI' and date_trunc('day',hour) between '2022-01-01' and '2022-01-07'
    group by 1
    ),
    data3 as (
    SELECT symbol,sum(price) from ethereum.token_prices_hourly where date_trunc('day',hour) between '2022-01-08' and '2022-01-14'
    group by 1 LIMIT 100),
    data4 as( SELECT symbol,sum(price) from ethereum.token_prices_hourly where symbol='SUSHI' and date_trunc('day',hour) between '2022-01-08' and '2022-01-14'
    group by 1
    ),
    data5 as(
    SELECT symbol,sum(price) from ethereum.token_prices_hourly where date_trunc('day',hour) between '2022-01-15' and '2022-01-21'
    group by 1 limit 100),
    data6 as(
    SELECT symbol,sum(price) from ethereum.token_prices_hourly where symbol='SUSHI' and date_trunc('day',hour) between '2022-01-15' and '2022-01-21'
    group by 1
    ),
    data7 as(
    SELECT symbol,sum(price) as sum from ethereum.token_prices_hourly where date_trunc('day',hour) between '2022-01-22' and '2022-01-29'
    group by 1 limit 100),
    data8 as(
    SELECT symbol,sum(price) from ethereum.token_prices_hourly where symbol='SUSHI' and date_trunc('day',hour) between '2022-01-22' and '2022-01-29'
    group by 1),
    data9 as(SELECT * from data1
    UNION ALL
    SELECT * from DATA2 ),
    data10 as
    (SELECT * from data3
    UNION ALL
    SELECT * from DATA4),
    data11 as(
    SELECT * from data5
    UNION ALL
    Run a query to Download Data