flipside
FLIPSIDEAI
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Untitled Query
rajs
Untitled Query
Updated 2022-05-09
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
date_trunc
(
'week'
,
block_timestamp
)
as
month
,
count
(
*
)
as
number_of_wallets
from
algorand
.
account
a
left
join
algorand
.
block
b
on
a
.
created_at
=
b
.
block_id
group
by
1
order
by
1
desc
Results
Run a query to Download Data