Afonso_Diaz2023-08-03 12:33 PM
Updated 2023-08-03
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
t1 as (
select
tx_id,
block_timestamp,
signers[0] as user,
Instruction:accounts[1] as drive,
((inner_instruction:instructions[0]:parsed:info:amount::int * 10e-10)/0.25) * pow(1024, 3) as bytes
from solana.core.fact_events
where succeeded = 1
and array_size(Instruction:accounts) = 9
and program_id = '2e1wdyNhUvE76y6yUCvah2KaviavMJYKoRun8acMRBZZ'
),
t2 as (
select
tx_id,
block_timestamp,
signers[0] as user,
Instruction:accounts[1] as drive,
(((inner_instruction:instructions[3]:parsed:info:amount::int * 10e-10)/0.25) * pow(1024, 3)) as bytes
from solana.core.fact_events
where succeeded = 1
and array_size(Instruction:accounts) = 13
and program_id = '2e1wdyNhUvE76y6yUCvah2KaviavMJYKoRun8acMRBZZ'
),
t3 as (
select
tx_id,
block_timestamp,
signers[0] as user,
Instruction:accounts[2] as drive,
(((inner_instruction:instructions[4]:parsed:info:amount::int * 10e-10)/0.25) * pow(1024, 3)) as bytes
from solana.core.fact_events
Run a query to Download Data