iboo-jbj2MVthe total volume of DRGNZ
Updated 2022-03-20
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 from_DRGNZ as (
select tx_id
-- block_timestamp::date as date,
-- sum(INNER_INSTRUCTION:instructions [1]:parsed:info:amount/1e2) as DRGNZ_amount
from solana.events
where posttokenbalances[0]:mint ='CzXF8oUJSsB9ADKV99WAi2TgytqAyKvQw6EihwiL9em4'
and index = 2
and instruction:programId='675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8'
and INNER_INSTRUCTION:instructions [1]:parsed:info:amount is not NULL
and INNER_INSTRUCTION:instructions [1]:parsed:type = 'transfer'
and INNER_INSTRUCTION:instructions [1]:program = 'spl-token'
and INNER_INSTRUCTION:instructions [1]:programId = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
and POSTTOKENBALANCES[3]:mint != 'H8BWkkGKpSpZVhuvuCAHBwWGWVrkAq9Dw3EH3okjy8dg'
and INNER_INSTRUCTION:instructions[2]:parsed:type !='mintTo'
and succeeded=true
and block_timestamp::date >= '2022-03-01'
group by 1
),
to_DRGNZ as (
select tx_id
from solana.events
where posttokenbalances[1]:mint ='CzXF8oUJSsB9ADKV99WAi2TgytqAyKvQw6EihwiL9em4'
and index = 2
and instruction:programId='675kPX9MHTjS2zt1qfr1NYHuzeLXfQM9H24wFSUt1Mp8'
and INNER_INSTRUCTION:instructions [1]:parsed:info:amount is not NULL
and INNER_INSTRUCTION:instructions [1]:parsed:type = 'transfer'
and INNER_INSTRUCTION:instructions [1]:program = 'spl-token'
and INNER_INSTRUCTION:instructions [1]:programId = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
and POSTTOKENBALANCES[3]:mint != 'H8BWkkGKpSpZVhuvuCAHBwWGWVrkAq9Dw3EH3okjy8dg'
and INNER_INSTRUCTION:instructions[2]:parsed:type !='mintTo'
and succeeded=true
and block_timestamp::date >= '2022-03-01'
group by 1
),
all_tx_ids as (
select tx_id from from_DRGNZ