HosseinUntitled Query
    Updated 2022-10-25
    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