binhachonKatana wLUNA Pool - tracking source instead
    Updated 2022-02-20
    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