nitsUntitled Query
    Updated 2022-12-08
    with pricet as (
    select recorded_at::date as day,
    address,
    symbol,
    avg (price) as USDPrice
    from osmosis.core.dim_prices t1 join osmosis.core.dim_labels t2 on t1.symbol = t2.project_name
    where symbol != 'IOV'
    group by 1,2,3

    union all
    select recorded_at::date as day,
    'ibc/D176154B0C63D1F9C6DCFB4F70349EBF2E2B5A87A05902F57A6AE92B863E9AEC' as address1,
    'stOSMO' as symbol1,
    avg (price) as USDPrice
    from osmosis.core.dim_prices t1 join osmosis.core.dim_labels t2 on t1.symbol = t2.project_name
    where symbol = 'OSMO'
    group by 1,2,3)
    ,

    newtable as (
    select liquidity_provider_address as New_LPer,
    min (block_timestamp) as mindate
    from osmosis.core.fact_liquidity_provider_actions
    where tx_status = 'SUCCEEDED'
    and pool_id = '833'
    and action = 'pool_joined'
    group by 1)

    SELECT * from newtable LIMIT 100

    -- select block_Timestamp::date as date,
    -- case when date < '2022-11-11' then 'Before Being Chosen as Pool Of The Week'
    -- when date >= '2022-11-11' then 'After Being Chosen as Pool Of The Week'
    -- end as timespan,
    -- action,
    Run a query to Download Data