sum(INNER_INSTRUCTION:instructions[0]:parsed:info:amount/1e9) as BOKU_token

from solana.events

where block_timestamp::date>= '2022-03-01'

and INNER_INSTRUCTION:instructions[0]:parsed:type = 'burn'

and INNER_INSTRUCTION:instructions[0]:parsed:info:mint ='C6B1pzKfG126QaccA9nAdKL25Vpthmz6KtfMbG2EDjLG'

and POSTTOKENBALANCES[0]:mint = 'CN7qFa5iYkHz99PTctvT4xXUHnxwjQ5MHxCuTJtPN5uS'

and index =1

and succeeded =TRUE

and INNER_INSTRUCTION:instructions[0]:parsed:info:amount is not NULL