Query editor
WITH jupiterZ AS (SELECTa.call_block_time AS block_time,a.call_tx_id AS tx_id,a.account_input_mint AS input_token,a.account_output_mint AS output_token,COALESCE(a.input_amount,bytearray_to_uint256 (bytearray_reverse (bytearray_substring (a.call_data, 1 + 8, 8)))) AS input_amount,COALESCE(a.input_amount,bytearray_to_uint256 (bytearray_reverse (bytearray_substring (a.call_data, 1 + 8, 8)))) * b1.price / POWER(10, b1.decimals) AS input_usd,COALESCE(a.output_amount,bytearray_to_uint256 (bytearray_reverse (bytearray_substring (a.call_data, 1 + 8 + 8, 8)))) AS output_amount,COALESCE(a.output_amount,bytearray_to_uint256 (bytearray_reverse (bytearray_substring (a.call_data, 1 + 8 + 8, 8)))) * b2.price / POWER(10, b2.decimals) AS output_usdFROMjupiter_solana.order_engine_call_fill aLEFT JOIN prices.usd_forward_fill AS b1 ON (b1.blockchain = 'solana'AND DATE_TRUNC('minute', a.call_block_time) = b1.minuteAND TOBASE58 (b1.contract_address) = a.account_input_mint)LEFT JOIN prices.usd_forward_fill AS b2 ON (b2.blockchain = 'solana'AND DATE_TRUNC('minute', a.call_block_time) = b2.minuteAND TOBASE58 (b2.contract_address) = a.account_output_mint)WHEREa.call_instruction_name = 'fill'AND a.call_block_time > now() - INTERVAL '30' day),-- 获取代币符号信息trade_with_symbols AS (SELECTDATE(j.block_time) AS trade_date,j.input_token,