flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
0_1. Total Transactions
Movement Team
0_1. Total Transactions
Updated 2 days ago
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with
base
as
(
Select
count
(
*
)
as
"Transactions"
from
movement
.
core
.
fact_transactions
)
,
blocks
as
(
select
count
(
distinct
BLOCK_NUMBER
)
as
"Blocks"
from
movement
.
core
.
fact_blocks
)
select
"Transactions"
,
"Blocks"
from
base
,
blocks
b
Results
Last run: 2 days ago
Transactions
Blocks
1
1835493
510479
1
1
18B
1s