Query editor
WITH SetComputeUnitPrice AS (SELECTBYTEARRAY_TO_BIGINT(BYTEARRAY_REVERSE(BYTEARRAY_SUBSTRING(data, 2, 8))) AS unit_price,*FROM solana.instruction_callsWHEREexecuting_account = 'ComputeBudget111111111111111111111111111111'AND BYTEARRAY_SUBSTRING(data, 1, 1) = 0x03AND block_time > CURRENT_TIMESTAMP - INTERVAL '24' hour),SetComputeUnitLimit AS(SELECTBYTEARRAY_TO_BIGINT(BYTEARRAY_REVERSE(BYTEARRAY_SUBSTRING(data, 2, 8))) AS unit_limit,*FROM solana.instruction_callsWHEREexecuting_account = 'ComputeBudget111111111111111111111111111111'AND BYTEARRAY_SUBSTRING(data, 1, 1) = 0x02AND block_time > CURRENT_TIMESTAMP - INTERVAL '24' hour),calculate_fee AS(SELECTtx.id,tx.block_time,(CASEWHEN NOT a.unit_price IS NULL AND NOT b.unit_limit IS NULLTHEN (a.unit_price * b.unit_limit) / POWER(10, 15)WHEN NOT a.unit_price IS NULL AND b.unit_limit IS NULLTHEN (a.unit_price * 200000) / POWER(10, 15)ELSE 0END) AS priority_feeFROM solana.transactions AS txINNER JOIN SetComputeUnitPrice AS aON a.tx_id = tx.idINNER JOIN SetComputeUnitLimit AS bON b.tx_id = tx.idWHEREtx.block_time > CURRENT_TIMESTAMP - INTERVAL '24' hourand tx.success = true)SELECTDATE_TRUNC('minute', block_time) AS minute,MIN(priority_fee) AS min_priority_fee,AVG(priority_fee) AS avg_priority_fee,MAX(priority_fee) AS max_priority_fee,sum(priority_fee) as total_priority_feeFROM calculate_feewhere priority_fee >0GROUP BY1order by minute desc