flipside
GROWTH MCP
IDG PLAYBOOK
JOURNEYS
INSIGHTS
About
Log in
GET STARTED
flipside
Solana playing around transfers
srini
Solana playing around transfers
Updated 2022-11-10
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
date_trunc
(
'day'
,
block_timestamp
)
as
day_
,
mint
,
count
(
*
)
as
calls_
,
count
(
distinct
tx_from
)
as
users
from
solana
.
core
.
fact_transfers
where
block_timestamp
>=
'2022-06-14'
and
block_timestamp
<
'2022-06-16'
group
by
1
,
2
order
by
2
desc
Results
Run a query to Download Data