mohamadreza221166top 50 performers for BTC volt on Friktion
    Updated 2022-07-25
    SELECT (INNER_INSTRUCTION:instructions[0]:parsed:info:source) AS wallet, sum(INNER_INSTRUCTION:instructions[1]:parsed:info:amount) / 1000000000 AS amount_BTC
    FROM solana.core.fact_events
    WHERE PROGRAM_ID ='VoLT1mJz1sbnxwq5Fv2SXjdVDgPXrb9tJyC8WpMDkSp'
    AND SUCCEEDED = 'TRUE'
    AND wallet IS NOT NULL
    AND INNER_INSTRUCTION:instructions[1]:parsed:info:mint IN('3BjcHXvyzMsjmeqE2qFLx45K4XFx3JPiyRnjJiF5MAHt','THjfJ7GUeW6aMU6dzYYFVs5LnKNvmPzgk2wbh3bWagC')
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 50



    Run a query to Download Data