princefarzamThe total amount of Orca and Bonfida transferred to Coinbase
    Updated 2022-02-13
    WITH Orca_transfered AS(
    SELECT
    Sum(INSTRUCTION:parsed:info:tokenAmount:amount/pow(10,6)) AS Orca_transfered_to_coinbase
    FROM solana.events
    WHERE block_timestamp::date >='2022-01-31'
    AND INSTRUCTION:programId::string ='TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA' --ORCA programId
    AND INSTRUCTION:parsed:info:mint::string='orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE' --ORCA Token address
    AND INSTRUCTION:parsed:info:destination::string='E1Jopmc9RGSM6LVXC2iEVFVfFHMou1J7baVwPvsqC8f2' --Coinbase wallet related to ORCA
    AND SUCCEEDED='TRUE'
    ),
    Fida_transfered AS(
    SELECT
    Sum(INSTRUCTION:parsed:info:tokenAmount:amount/pow(10,6)) AS fida_transfered_to_coinbase
    FROM solana.events
    WHERE block_timestamp::date >='2022-01-31'
    AND INSTRUCTION:programId::string ='TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA' --bonfida programId
    AND INSTRUCTION:parsed:info:mint::string='EchesyfXePKdLtoiZSL8pBe8Myagyy8ZRqsACNCFGnvp' --bonfida Token address
    AND INSTRUCTION:parsed:info:destination::string='9DdkHY1WbdQCruvQ5g5ZRQEMKcmMwFxC77kDLGZJ3WCQ' --Coinbase wallet related to bonfida
    AND SUCCEEDED='TRUE'
    )
    SELECT
    'TOTAL AMOUNT TRANSFERRED TO COINBASE',
    Orca_transfered_to_coinbase * 3.04 AS TOTAL_AMOUNT_OF_ORCA_TRANSFERRED_IN_USD, --3.04 IS ORCA PRICE AT 14 FEB
    fida_transfered_to_coinbase * 2.56 AS TOTAL_AMOUNT_OF_FIDA_TRANSFERRED_IN_USD --2.56 IS fida PRICE AT 14 FEB
    FROM Orca_transfered orc FULL OUTER JOIN Fida_transfered Fid
    Run a query to Download Data