MLDZMNInfo about Hack program
Updated 2023-03-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with t1 as (select
RECORDED_HOUR::date as day,
avg(close) as price
from solana.core.fact_token_prices_hourly
where symbol ='SOL'
group by 1)
select
min(BLOCK_TIMESTAMP) as "First Hack",
max(BLOCK_TIMESTAMP) as "Last Hack",
datediff('day',"First Hack","Last Hack") as "Active days",
count(distinct tx_id) as "# of Hacks"
from solana.core.fact_events s left join t1 a on s.BLOCK_TIMESTAMP::date=a.day
where PROGRAM_ID='3VtjHnDuDD1QreJiYNziDsdkeALMT6b2F9j3AXdL4q8v'
and SUCCEEDED='TRUE'
Run a query to Download Data