Jonasovivacious-ivory
Updated 2024-08-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
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