2844TOP BURNERS
    Updated 2022-10-10
    select SIGNERS[0] as "user"
    , SUM (inner_instructions[0]:instructions[0]:parsed:info:amount/1e6) as BURN_AMOUNT
    from solana.core.fact_transactions
    where instructions[0]:programId='HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
    and inner_instructions[0]:instructions[0]:parsed:type='burn'
    group by 1
    ORDER BY 2 DESC
    limit 5
    Run a query to Download Data