alleriaFriktion SOL vs mSOL Volts
Updated 2022-02-20
999
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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