flipside
FLIPSIDEAI
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
polygon
esi69
polygon
Updated 2022-07-08
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
BLOCK_TIMESTAMP
::
date
date
,
count
(
DISTINCT
tx_hash
)
as
tx_hash
,
count
(
DISTINCT
FROM_ADDRESS
)
as
unique_from_addres
,
count
(
DISTINCT
to_address
)
as
unique_to_address
from
polygon
.
core
.
fact_transactions
where
date
>=
'2022-01-01'
group
by
1
Results
Run a query to Download Data