HosseinUntitled Query
Updated 2022-10-25Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with list1 as (
select address as wallet_address,
min(date) as date_created,
avg(balance / pow(10, 6)) as balance_avg
from osmosis.core.fact_daily_balances
where currency = 'uosmo'
group by address
)
select date_created,
count(distinct(wallet_address)) as wallets_number,
sum(balance_avg) as total_balance,
avg(balance_avg) as average_balance,
(average_balance / wallets_number) as avg_per_wallet
from list1
group by date_created
Run a query to Download Data