alleriaFriktion SOL vs mSOL Volts
    Updated 2022-02-20
    -- How much SOL was deposited during the February 4th and February 11th epochs and how many unique users were in the SOL covered call volt?
    -- How much mSOL was deposited during those same epochs and how many unique users were in the covered call volt?
    -- Why do you think one volt has been gaining more adoption than the other?

    -- 4Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2 SOL
    -- Hxtb6APfNtf9m8jJjh7uYp8fCTGr9aeHxBSfiPqCrV6G Friktion SOL main wallet?
    -- 2CKKqsuUvRRg1x15KNDLW9TaefFKgGAquo2t9DdV7Bvf Friktion SOL Call (fcSOL) token account
    -- Fhd3oy4ZBoKPUa6Xk8TzxqTTukbzqYSqKidEFicGVSq2 Friktion wrapped SOL Token Account

    WITH
    SOL as (
    SELECT
    date(block_timestamp) as dates,
    CASE
    WHEN inner_instruction:instructions[0]:parsed:type::string = 'transfer' THEN inner_instruction:instructions[0]:parsed:info:authority::string
    WHEN inner_instruction:instructions[1]:parsed:type::string = 'transfer' THEN inner_instruction:instructions[1]:parsed:info:authority::string
    ELSE 'incorrect'
    END as wallet_address,
    CASE
    WHEN inner_instruction:instructions[0]:parsed:type::string = 'transfer' THEN inner_instruction:instructions[0]:parsed:info:amount / POW(10,9)
    WHEN inner_instruction:instructions[1]:parsed:type::string = 'transfer' THEN inner_instruction:instructions[1]:parsed:info:amount / POW(10,9)
    ELSE 'incorrect'
    END as SOL_amount,

    CASE
    WHEN inner_instruction:instructions[0]:parsed:type::string = 'transfer' THEN inner_instruction:instructions[0]:parsed:info:destination::string
    WHEN inner_instruction:instructions[1]:parsed:type::string = 'transfer' THEN inner_instruction:instructions[1]:parsed:info:destination::string
    ELSE 'incorrect'
    END as epoch,
    *
    FROM solana.events
    --WHERE tx_id = '4Fv3HzL5atPYHRcEVzuPCu2MwHb7qEBzwroBbXLiFDzrADp9CuypCCVMuUjRR33FamrNYzkJSqvCbGiF9rPzjfM2'
    WHERE ((inner_instruction:instructions[0]:parsed:info:authority::string != 'Hxtb6APfNtf9m8jJjh7uYp8fCTGr9aeHxBSfiPqCrV6G' AND inner_instruction:instructions[0]:parsed:type::string = 'transfer')
    OR (inner_instruction:instructions[1]:parsed:info:authority::string != 'Hxtb6APfNtf9m8jJjh7uYp8fCTGr9aeHxBSfiPqCrV6G' AND inner_instruction:instructions[1]:parsed:type::string = 'transfer'))
    AND pretokenbalances[0]:owner::string = 'Hxtb6APfNtf9m8jJjh7uYp8fCTGr9aeHxBSfiPqCrV6G'
    Run a query to Download Data