flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
The number of daily transactions and unique addresses on Polygon
kiacrypto
The number of daily transactions and unique addresses on Polygon
Updated 2022-07-09
Copy Reference
Fork
9
1
2
3
›
⌄
select
date_trunc
(
'day'
,
block_timestamp
)
as
date
,
case
when
date
>=
'2022-07-01'
then
'July'
else
'June'
end
as
month
,
count
(
tx_hash
)
as
tx_count
,
count
(
distinct
from_address
)
as
unique_user_count
from
polygon
.
core
.
fact_transactions
group
by
1
,
2
Results
Run a query to Download Data