MLDZMNInfo about Hack program
    Updated 2023-03-23
    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'