select date(RECORDED_AT) as pdate, avg(price) as price

from osmosis.core.dim_prices

where symbol = 'HUAHUA'

group by pdate

select count(distinct tx_id) as tx_count,

count(distinct liquidity_provider_address) as wallets,

sum(amount/1e6 * price) as usd_vol

from osmosis.core.fact_liquidity_provider_actions lq join ev_price_tbl on date(lq.block_timestamp) = ev_price_tbl.pdate

where pool_id in (605,606)

and tx_status = 'SUCCEEDED'

and action in ('pool_joined','pool_exited')

and block_timestamp >= CURRENT_DATE - 7