granadohoTotal Deposited SOL and mSOL in SOL and mSOL Covered Call Volt
    Updated 2022-02-21
    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,
    sum(inner_instruction:instructions[1]:parsed:info:amount/1e9) as deposited_sol
    From Solana.events
    Where block_timestamp::date >='2022-02-04'
    And block_timestamp::date <= '2022-02-18'
    And index = 3
    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,
    sum(instruction:parsed:info:tokenAmount:uiAmount) as deposited_msol
    From Solana.events
    Where block_timestamp::date >='2022-02-04'
    And block_timestamp::date <= '2022-02-18'
    And index = 2
    Run a query to Download Data