iboo-jbj2MVthe amount of BOKU have been farmed
Updated 2022-03-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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