LoriYagami-3606Sol attk 2
    Updated 2022-10-17
    with
    label as (
    select address
    from solana.core.dim_labels
    where address in
    ('mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68','5fNfvyp5czQVX77yoACa3JJVEhdRaWjPuazuWgjhTqEH','JD3bq9hGdy38PuWQ4h2YJpELmHVGPPfFSuFkpzAd9zfu')
    )
    select *
    from (
    select block_timestamp::date as date,
    case when block_timestamp >= '2022-09-01' and block_timestamp <'2022-10-11' then 'Before Mango Hack'
    when block_timestamp >= '2022-10-11' then 'After Mango Hack' else null end as type,
    count (distinct tx_id) as tx_count,
    count (distinct signers[0]) as wallet
    from solana.core.fact_transactions
    join label
    on instructions[0]:programId =address
    and block_timestamp >= '2022-09-01'
    and succeeded = 'TRUE'
    group by 1,2
    order by 1
    )
    where type is not null



    Run a query to Download Data