binhachonKatana wLUNA Pool - tracking source instead
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,
posttokenbalances[2]:owner::string as owner,
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
avg(amount) as average_size,
count(distinct owner) as number_of_claimers,
count(*) / number_of_claimers as claim_per_account
from katana_claim_transactions
Run a query to Download Data