Updated 2022-12-07
    with pricee as (
    select
    DATE_TRUNC('day', recorded_at) as day,
    address as address,
    symbol as symbol,
    avg (price) as USDPrice
    from osmosis.core.dim_prices a join osmosis.core.dim_labels b on a.symbol = b.project_name
    where symbol NOT in ('IOV')
    group by 1,2,3

    union all
    select DATE_TRUNC('day', recorded_at) as day,
    'ibc/D176154B0C63D1F9C6DCFB4F70349EBF2E2B5A87A05902F57A6AE92B863E9AEC' as address,
    'stOSMO' as symbol,
    avg (price) as USDPrice
    from osmosis.core.dim_prices a join osmosis.core.dim_labels b on a.symbol = b.project_name where symbol = 'OSMO'
    and symbol NOT in ('IOV')
    group by 1,2,3),

    newLPer as (
    select
    liquidity_provider_address as New_LP_provider,
    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
    case when block_timestamp < '2022-11-11' then 'Before Pool Of The Week day'
    when block_timestamp >= '2022-11-11' then 'After Pool Of The Week day'
    end as span,
    count (distinct tx_id) as TX,
    Run a query to Download Data