roketCopy of Copy of Copy of pool
    Updated 2022-12-05
    --creator :: https://app.flipsidecrypto.com/velocity/queries/47962ef8-7eb9-4c33-b9d2-790b1df8ce15
    --Tnx Dear 0xHaM☰d
    with priceTb as (
    select
    recorded_at::date as p_date,
    address,
    symbol,
    avg(price) as usd_price
    from osmosis.core.dim_prices a join osmosis.core.dim_labels b on a.symbol = b.project_name
    where symbol != 'IOV'
    group by 1,2,3

    union all
    select
    recorded_at::date as p_date,
    'ibc/D176154B0C63D1F9C6DCFB4F70349EBF2E2B5A87A05902F57A6AE92B863E9AEC' as address1,
    'stOSMO' as symbol1,
    avg(price) as usd_price
    from osmosis.core.dim_prices a join osmosis.core.dim_labels b on a.symbol = b.project_name
    where symbol = 'OSMO'
    group by 1,2,3
    union all
    select
    recorded_at::date as p_date,
    'ibc/92BE0717F4678905E53F4E45B2DED18BC0CB97BF1F8B6A25AFEDF3D5A879B4D5' as address1,
    'IST' as symbol1,
    '1' as usd_price
    from osmosis.core.dim_prices
    group by 1,2,3
    union all
    select
    Run a query to Download Data