Query editor
-- todo: update address list to use on chain address listwith burns as (select *from solana.account_activitywhere block_date > date '2023-04-01'and tx_success = trueand token_balance_change < 0-- and token_balance_owner = 'FbnCZoQzE9GrmWxG1yMsYyw4YrEJSZjyNVtF3PDCPzoi'and token_mint_address = 'mb1eu7TzEc71KxDpsmsKoucSSuuoGLv1drys1oP2jh6'and address IN ('AT9c65QDqGxL8gqqGGq1RzQhwuvBAChfkj3nrZZ6HycC' -- nova labs, '2obTR1qc6bjwdrwSBdSbZFN9Tvvr772cRbTELxKa5nkX' -- freedomfi, 'dVmWgq4ovXQSfxwHbwaqQuxQ5J9NAqteVYJqWMBqfDu' -- bobcat 5g)), daily as (select block_date as day, sum(-token_balance_change) mobile_burnedfrom burnsgroup by 1)select day, mobile_burned, sum(mobile_burned) over (order by day asc) as total_mobile_burnedfrom daily;