flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
collective-silver
permary
collective-silver
Updated 2024-10-28
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
date
(
block_timestamp
)
as
date
,
count
(
*
)
as
total_tx
from
kaia
.
core
.
fact_transactions
where
date
(
block_timestamp
)
=
current_date
group
by
date
order
by
date
;
Results
Last run: 3 months ago
DATE
TOTAL_TX
1
2024-10-21 00:00:00.000
343574
1
1
36B
1s