Jonasovivacious-ivory
    Updated 2024-08-28
    with

    A as(
    select account_address as user, min(block_timestamp) as block_timestamp
    from solana.core.fact_token_balances
    where mint = '2b1kV6DkPAnxd5ixfnxCpjxmKwqjjaYmCZfHsFu24GXo'
    group by 1 ),

    B as(
    select date_trunc('week',block_timestamp) as time, count(user) as user
    from A
    group by 1 )

    select *, sum(user) over(order by time) as total
    from B
    order by time desc




    QueryRunArchived: QueryRun has been archived