MLDZMNhpf2
Updated 2023-03-23
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
BLOCK_TIMESTAMP::date as date,
case when SUCCEEDED='TRUE' then 'Succeeded hack' else 'failed hack' end as status,
count(distinct tx_id) as no_hacks,
count(distinct SIGNERS[0]) as no_victims,
sum(no_victims) over (order by date) as total_victims
from solana.core.fact_events
where PROGRAM_ID='3VtjHnDuDD1QreJiYNziDsdkeALMT6b2F9j3AXdL4q8v'
and BLOCK_TIMESTAMP>='2022-03-04' and BLOCK_TIMESTAMP<='2022-04-24'
group by 1,2
Run a query to Download Data