binhachonKatana wLUNA Pool
Updated 2022-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with katana_claim_transactions as (
select
block_timestamp,
inner_instruction:instructions[1]:parsed:info:destination::string as account,
inner_instruction:instructions[1]:parsed:info:amount::float/1e6 as amount
from solana.events
where block_timestamp::date >= '2022-02-04'
and inner_instruction:instructions[0]:parsed:type::string = 'burn'
and inner_instruction:instructions[1]:parsed:type::string = 'transfer'
and inner_instruction:instructions[1]:parsed:info:source::string = '9baN3ENgbvDau1Myu5H4Gd5CiujWS6c6WuSu87YWahb7' --account that hold LUNA
)
select
block_timestamp::date as blocktime,
sum(amount) as claimed_luna,
count(distinct account) as number_of_claimers
from katana_claim_transactions
group by blocktime
order by blocktime desc
Run a query to Download Data