select

RECORDED_AT::date as date_price

,avg(price) as avg_price

from osmosis.core.dim_prices

where symbol='OSMO'

group by 1

select

block_timestamp::date as date

,split(CURRENCY,'/')[2] as pool

,count(DISTINCT VALIDATOR_ADDRESS) as validators

,count(DISTINCT DELEGATOR_ADDRESS) as delegators

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

,sum(amount/pow(10,decimal)*avg_price) as volume_usd

from osmosis.core.fact_superfluid_staking

join lst_price on date_price = block_timestamp::date

where CURRENCY is not NULL

and pool in ('1', '678', '704', '712', '674', '722', '9', '604', '497', '812', '584', '3', '481', '42', '463', '15')

and TX_STATUS='SUCCEEDED'

group by 1,2

order by 1