SELECT

date_trunc('day', recorded_at) as day,

symbol,

avg(price) as price

FROM osmosis.core.dim_prices

WHERE recorded_at > '2022-01-01'

GROUP BY 1,2

SELECT

DATE,

project_name as balance_type,

count(DISTINCT osmosis.core.fact_daily_balances.address) as holders,

sum((balance/ power(10, decimal)) * price) as bal,

sum((balance/ power(10, decimal)) * price) / count(DISTINCT osmosis.core.fact_daily_balances.address) as avg_bal

FROM osmosis.core.fact_daily_balances

LEFT outer JOIN osmosis.core.dim_labels

ON CURRENCY = osmosis.core.dim_labels.ADDRESS

LEFT OUTER JOIN tab1

on project_name = symbol

AND day = date

WHERE date > '2022-05-10'

GROUP BY 1,2

HAVING bal BETWEEN 500000 AND 1000000000