princefarzamThe total amount of Orca and Bonfida transferred to Coinbase
Updated 2022-02-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
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