nsa2000Daily variation of Kamino transactions
    Updated 2022-10-10
    with kamino_program as (
    SELECT
    -- tr.signers
    tx_id
    , block_timestamp
    , instruction:accounts[0] as user
    from
    solana.core.fact_events ev -- inner join solana.core.fact_transactions tr using(tx_id)
    WHERE
    -- address_name ilike '%Hubble %'
    program_id = '6LtLpnUFNByNXLyCoK9wA2MykKAmQNZKBdY8s47dehDc' -- Kamino
    -- and instruction:accounts[0] != 'H5s8388JNiFMigoy5fhEEED5nB5i2UGPxh1Gh3cBvqQd'
    -- and tx_id = '4VEyMHCskeLsYuTwnoxmfooAuvCvMXV2NrdQThXg8HLVKb9XHP6VNEkfrJR4ceWUs2wAR11r5tBhL4kitgYrRz7y'
    and block_timestamp >= CURRENT_DATE - INTERVAL'3 months'
    -- 1=1
    -- limit 10
    )


    SELECT
    distinct block_timestamp::date as DAY
    , count(distinct tx_id) over (partition by DAY) as daily_kamino_usage
    , count(distinct tx_id) over () as kamino_total_usage
    from
    kamino_program
    Run a query to Download Data