MLDZMNhpf2
    Updated 2023-03-23
    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