Query editor
SELECTCAST(block_date AS DATE) AS block_date,TRY_CAST(tx_hash AS VARCHAR) AS tx_hash,TRY_CAST(user AS VARCHAR) AS user,usd_value,CASEWHEN order_id IS NOT NULLAND LENGTH(CAST(varbinary_to_uint256(varbinary_substring(order_id, 1, 32)) AS VARCHAR)) = 10THEN 'api'WHEN order_id IS NOT NULLAND LENGTH(CAST(varbinary_to_uint256(varbinary_substring(order_id, 1, 32)) AS VARCHAR)) >= 17THEN 'interface'ELSE 'okx_bot'END AS flag,blockchainFROM "query_5172651(dt='21')"WHERE CAST(block_date AS DATE) BETWEEN CURRENT_DATE - INTERVAL '19' DAY AND CURRENT_DATE