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),

SingleSideT as (

select tx_id,

count (tx_id) as TXS_Count

from osmosis.core.fact_liquidity_provider_actions

where action = 'pool_joined'

and tx_status = 'SUCCEEDED'

group by 1

having TXS_Count < 2),

BothAssetsT as (

select tx_id,

count (tx_id) as TXS_Count

from osmosis.core.fact_liquidity_provider_actions

where action = 'pool_joined'

and tx_status = 'SUCCEEDED'

group by 1

having TXS_Count > 1),

maintable as (

select 'Carefully Wade In (Single Side)' as join_type,

liquidity_provider_address,

count (distinct tx_id) as TX_Count,

count (distinct liquidity_provider_address) as Users_Count,

sum (amount/pow(10,decimal)) as Total_Token_Volume,

avg (amount/pow(10,decimal)) as Average_Token_Volume,

sum (amount*usdprice/pow(10,decimal)) as Total_USD_Volume,

avg (amount*usdprice/pow(10,decimal)) as Average_USD_Volume