date_trunc(day,recorded_at)::date as date

,avg(price) as OSMO_PRICE

from osmosis.core.dim_prices

where recorded_at>='2022-8-28' and date<='2022-10-27'

and SYMBOL='OSMO'

group by 1

order by 1

,lst_all as (

select

block_timestamp::date as date

,tx_id

,tx_from

,OSMO_PRICE

from osmosis.core.fact_transactions f

join lst_OSMO_Price on lst_OSMO_Price.date = block_timestamp::date

where TX_STATUS='SUCCEEDED'

date

,count(DISTINCT tx_id) as tx_count

,count(DISTINCT tx_from) as wallets

,avg(OSMO_PRICE) as OSMO_PRICE

,sum(tx_count) over(order by date) as growth_tx_count

,sum(wallets) over(order by date) as growth_wallets

from lst_all

group by 1

order by 1