granadohoTotal Unique Users in SOL and mSOL Covered Call Volt
    Updated 2022-02-20
    with sol_tx_list as (
    Select
    distinct tx_id
    From Solana.events
    Where block_timestamp::date >='2022-02-04'
    And block_timestamp::date <= '2022-02-18'
    And index = 2
    And instruction:parsed:info:mint = '4Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2'
    ), sol_volt as (
    Select
    block_timestamp::date as date,
    count(distinct instruction:parsed:info:source) as sol_users
    From Solana.events
    Where block_timestamp::date >='2022-02-04'
    And block_timestamp::date <= '2022-02-18'
    And index = 0
    And succeeded = 'TRUE'
    And tx_id in (select * from sol_tx_list)
    Group by date
    Order by date
    ), msol_tx_list as (
    Select
    distinct tx_id
    From Solana.events
    Where block_timestamp::date >='2022-02-04'
    And block_timestamp::date <= '2022-02-18'
    And index = 2
    And instruction:parsed:info:mint = '6UA3yn28XecAHLTwoCtjfzy3WcyQj1x13bxnH8urUiKt'
    ), msol_volt as (
    Select
    block_timestamp::date as date,
    count(distinct instruction:parsed:info:source) as msol_users
    From Solana.events
    Where block_timestamp::date >='2022-02-04'
    And block_timestamp::date <= '2022-02-18'
    And index = 1
    Run a query to Download Data