flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
rocketbois.neartopia.near 2
ML6
rocketbois.neartopia.near 2
Updated 2022-10-17
Copy Reference
Fork
9
1
2
3
4
›
⌄
select
count
(
distinct
tx_signer
)
as
s
,
to_date
(
block_timestamp
)
as
date
from
near
.
core
.
fact_transactions
where
tx_receiver
=
'rocketbois.neartopia.near'
and
to_date
(
block_timestamp
)
>=
current_date
-
90
group
by
date
Results
Run a query to Download Data