flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
BECOME A PARTNER
flipside
GN3
yasmin-n-d-r-h
GN3
Updated 2022-10-16
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with
per_day
as
(
select
date_trunc
(
'day'
,
block_timestamp
)
as
day
,
sum
(
tx_count
)
as
Tx_per_day
from
gnosis
.
core
.
fact_blocks
where
DAY
>=
CURRENT_DATE
-
30
group
by
1
)
select
day
,
tx_per_day
from
per_day
Results
Run a query to Download Data