flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2022, lowest monthly transaction volumn on Ethereum
0x0D203C32bbd48653fcbf1898B7a8d757d391f7Bc
2022, lowest monthly transaction volumn on Ethereum
Updated 2022-08-24
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
date_trunc
(
'month'
,
BLOCK_TIMESTAMP
)
as
month1
,
count
(
DISTINCT
(
TX_HASH
)
)
AS
monthly_transcation
FROM
ethereum
.
core
.
fact_transactions
WHERE
block_timestamp
::
DATE
BETWEEN
'2022-01-01'
AND
'2022-07-31'
group
by
1
order
by
1
Results
Run a query to Download Data