amirrzDaily Active Users on Solana DeFi on Average
    Updated 2022-10-15
    with
    table1 as (
    select
    block_timestamp::date as date,
    case
    when
    block_timestamp >= '2022-09-11' and block_timestamp <'2022-10-11 23:00:00.000' then 'Before Mango Hack'
    when
    block_timestamp >= '2022-10-11 23:00:00.000' then 'After Mango Hack' else null end as timespan,
    count (distinct tx_id) as TX_Count,
    count (distinct signers[0]) as Users_Count
    from
    solana.core.fact_transactions t1 join solana.core.dim_labels t2 on t1.instructions[0]:programId = t2.address
    where
    address_name not in ('token program','associated token account','systeminstruction','memo program','config_instruction','token 2022 program','pyth oracle')
    and
    timespan is not null
    and
    succeeded = 'TRUE' group by 1,2)

    select
    timespan,
    avg (tx_count) as Average_TX_Count,
    avg (users_Count) as Average_Users_Count
    from
    table1 group by 1
    Run a query to Download Data