add in labels and avg daily price

select top 100 a.*, b.project_name, c.price,

balance / POW(10, decimal) * price USD_balance

from osmosis.core.fact_daily_balances a LEFT JOIN osmosis.core.dim_labels b on a.currency = b.ADDRESS

-- LEFT JOIN osmosis.core.dim_prices c on LOWER(b.PROJECT_NAME) = lower(c.SYMBOL) and c.recorded_at = '2022-09-01 00:01:00.000'

left join (SELECT symbol, recorded_at::DATE recorded_at ,avg(price) price

from osmosis.core.dim_prices --where symbol = 'ATOM'

group by 1,2) c

on LOWER(b.PROJECT_NAME) = lower(c.SYMBOL) and c.recorded_at = a.date

where 1=1

and currency not like 'gamm%'

and date ='2022-09-01'

select date, balance_type,

balance / POW(10, decimal) as adjusted_bal

from osmosis.core.fact_daily_balances

where 1=1

and address = 'osmo1f48dwj5fptfdhxud687yt99ew4n0nyqryw3sn7'

and currency = 'uosmo'

and date <'2022-09-01'

date,

balance_type,

SUM(balance / POW (10, decimal)) as adjusted_bal

osmosis.core.fact_daily_balances

1 = 1

--and address = 'osmo1f48dwj5fptfdhxud687yt99ew4n0nyqryw3sn7'

and currency = 'uosmo'

-- and date <'2022-09-01'

-- and date >= '2021-12-14'

group by

1,