pimi1356-HdnUm3 Pool #634 - wETH.grv / OSMO
    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/65381C5F3FD21442283D56925E62EA524DED8B6927F0FF94E21E0020954C40B5' as address1,
    'WETH.grv' as symbol1,
    avg (price) as USDPrice
    from osmosis.core.dim_prices
    where symbol = 'WETH'
    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 = [634]
    and action = 'pool_joined'
    group by 1)


    select DATE_TRUNC('day', block_timestamp) AS date,
    case when date < '2022-11-29' then 'Before Pool Of The Week day'
    when date >= '2022-11-29' then 'After Pool Of The Week day'
    end as span,
    action as ACTION,
    Run a query to Download Data