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/65381C5F3FD21442283D56925E62EA524DED8B6927F0FF94E21E0020954C40B5' as address1,

'WETH.grv' as symbol1,

avg (price) as USDPrice

from osmosis.core.dim_prices

where symbol = 'WETH'

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 = '634'

and action = 'pool_joined'

group by 1)

select block_Timestamp::date as date,

case when date < '2022-11-29' then 'Before Being Chosen as Pool Of The Week'

when date >= '2022-11-29' then 'After Being Chosen as Pool Of The Week'

end as timespan,

action,

count (distinct tx_id) as TX_Count,

count (distinct liquidity_provider_address) as Active_LPers,

count (distinct new_lper) as New_LPers,