iboo-jbj2MVthe amount of BOKU have been farmed
    Updated 2022-03-20
    select
    block_timestamp::date as date ,
    sum(INNER_INSTRUCTION:instructions[0]:parsed:info:amount/1e9) as BOKU_reward,
    count (DISTINCT tx_id) as transactions
    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
    group by 1
    Run a query to Download Data