flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Polygon 2022-07-01
Abolfazl_771025
Polygon 2022-07-01
Updated 2022-07-17
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
BLOCK_TIMESTAMP
::
DATE
AS
"Time"
,
COUNT
(
1
)
AS
"Number Of Transactions"
,
COUNT
(
DISTINCT
FROM_ADDRESS
)
AS
"Number Of Unique Address"
FROM
flipside_prod_db
.
polygon
.
transactions
WHERE
"Time"
>=
'2022-07-01'
GROUP
BY
"Time"
ORDER
BY
"Time"
Results
Run a query to Download Data