Pmisha-bmlMdxq1.veSBR Analysis
Updated 2022-02-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with ep4 as (SELECT
sum (inner_instruction:instructions[0]:parsed:info:amount/1e6) as amount_epoch4
from solana.events
WHERE block_timestamp <='2022-02-17' ---2/10 to 2/17 epoch 4
and instruction:programId='LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'
and PRETOKENBALANCES:mint='Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1'
and succeeded = 'TRUE'
),
ep5 as (SELECT
sum (inner_instruction:instructions[0]:parsed:info:amount/1e6) as amount_epoch5
from solana.events
WHERE block_timestamp <= '2022-02-24' ---2/17 to 2/24 epoch 5
and instruction:programId='LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'
and PRETOKENBALANCES:mint='Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1'
and succeeded = 'TRUE'
)
select amount_epoch4 , amount_epoch5 from ep4 ,ep5
Run a query to Download Data