granadohoTotal Deposited SOL and mSOL in SOL and mSOL Covered Call Volt
Updated 2022-02-21
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with sol_tx_list as (
Select
distinct tx_id
From Solana.events
Where block_timestamp::date >='2022-02-04'
And block_timestamp::date <= '2022-02-18'
And index = 2
And instruction:parsed:info:mint = '4Hnh1UCC6HLzx9NaGKnTVHR2bANcRrhydumdHCnrT3i2'
), sol_volt as (
Select
block_timestamp::date as date,
sum(inner_instruction:instructions[1]:parsed:info:amount/1e9) as deposited_sol
From Solana.events
Where block_timestamp::date >='2022-02-04'
And block_timestamp::date <= '2022-02-18'
And index = 3
And succeeded = 'TRUE'
And tx_id in (select * from sol_tx_list)
Group by date
Order by date
), msol_tx_list as (
Select
distinct tx_id
From Solana.events
Where block_timestamp::date >='2022-02-04'
And block_timestamp::date <= '2022-02-18'
And index = 2
And instruction:parsed:info:mint = '6UA3yn28XecAHLTwoCtjfzy3WcyQj1x13bxnH8urUiKt'
), msol_volt as (
Select
block_timestamp::date as date,
sum(instruction:parsed:info:tokenAmount:uiAmount) as deposited_msol
From Solana.events
Where block_timestamp::date >='2022-02-04'
And block_timestamp::date <= '2022-02-18'
And index = 2
Run a query to Download Data