flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Daily transactions(From July 1, 2020)
hosein778
Daily transactions(From July 1, 2020)
Updated 2022-07-11
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
SELECT
DATE
(
block_timestamp
)
as
date
,
COUNT
(
tx_id
)
as
daily_transactions
FROM
flipside_prod_db
.
polygon
.
transactions
WHERE
date
>=
DATE_FROM_PARTS
(
2020
,
7
,
1
)
GROUP
BY
date
ORDER
BY
date
;
Results
Run a query to Download Data