iboo-jbj2MVthe total volume of DRGNZ
    Updated 2022-03-20
    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