zakkisyedSolana: Weekly average users
    Updated 2022-01-29
    --this query refreshes daily
    select avg(no_of_users), weekly
    from
    (
    select count (distinct (tx_from_address)) as no_of_users, --select number of unique wallet addresses
    date_trunc('week', block_timestamp) as weekly --truncate block_timestamp data to a day grouping
    from solana.transactions

    where block_timestamp >= '2022-01-01'
    and succeeded = 'TRUE'---- -- filter out successful transactions for accuracy

    group by 2
    order by 2 asc

    )
    group by 2
    order by 1 desc
    Run a query to Download Data