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