flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
2023-08-29 04:19 PM
LTirrell
2023-08-29 04:19 PM
Updated 2023-08-29
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
block_timestamp
,
tx_id
,
purchaser
,
seller
,
mint
,
sales_amount
from
solana
.
core
.
fact_votes_agg_block
where
PROGRAM_ID
=
'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K'
and
succeeded
=
'True'
and
date_trunc
(
'hour'
,
block_timestamp
)
=
{
{
date
}
}
Results
Run a query to Download Data