Query editor
WITHgrouped_fees AS (SELECTCOUNT(*) as withdrawal_count,block_date,SUM((fee - 5000)) / 1E9 AS priority_feeFROMsolana.transactionsWHERE(signer = '2AQdpHJ2JpcEgPiATUXjQxA8QmafFegfQwSLWSprPicm' -- coinbase exchange 1OR signer = 'H8sMJSCQxfKiFTCfDR3DUMLPwcRbM61LGFJ8N4dK3WjS' -- coinbase exchange 2OR signer = 'GJRs4FwHtemZ5ZE9x3FNvJ8TMwitKTh21yxdRPqn7npE' -- coinbase hot walletOR signer = '4NyK1AdJBNbgaJ9EsKz3J4rfeHsuYdjkTPg3JaNdLeFw')AND block_time > NOW() - INTERVAL '{{days}}' dayAND readonly_unsigned_accounts = 2 -- should only count system transfers hereAND success = TRUEGROUP BYblock_date)SELECTblock_date,priority_fee,withdrawal_count,SUM(priority_fee) OVER () AS total_priority_feeFROMgrouped_feesORDER BYblock_date DESC