Query editor
WITH instructions AS (SELECTblock_time,CASE-- FillUserOrder: pos_9 = Volume (USDC spent)WHEN bytearray_substring(data, 1, 8) = 0x4100000000000000THEN bytearray_to_uint256(bytearray_reverse(bytearray_substring(data, 9, 8))) / 1e6-- FillUserReduce: pos_17 = Volume (USDC received)WHEN bytearray_substring(data, 1, 8) = 0x4900000000000000THEN bytearray_to_uint256(bytearray_reverse(bytearray_substring(data, 17, 8))) / 1e6END AS VolumeFROM solana.instruction_callsWHERE executing_account = 'pReDicTmksnPfkfiz33ndSdbe2dY43KYPg4U2dbvHvb'AND block_time >= DATE '2025-12-04'AND tx_successAND bytearray_substring(data, 1, 8) IN (0x4100000000000000, 0x4900000000000000))SELECTDATE_TRUNC('day', block_time) AS date,SUM(Volume) AS Daily_Volume,SUM(SUM(Volume)) OVER(ORDER BY DATE_TRUNC('day', block_time)) AS Cum_VolumeFROM instructionsGROUP BY 1ORDER BY 1 DESC