Query editor
WITH ipor_trades AS(SELECTblock_time AS trade_time,'Wallet 1' AS wallet,(CAST(token_sold_amount_raw AS DOUBLE)/1e18) AS ipor_amount,(CAST(token_bought_amount_raw AS DOUBLE)/1e18) AS eth_amount,(CAST(token_bought_amount_raw AS DOUBLE)/1e18) / (CAST(token_sold_amount_raw AS DOUBLE)/1e18) AS "IPOR/ETH"FROM dex.tradesWHERE tx_hash in (0x2bada158a7de02e24d69986c07c0a7d51b8bf12f65d561fd84869e3208c01fc1,0xae9e09e1338c199010872c3d9f93c68d9e1561c7e01e02b051fcbc8eab5befd5,0x09386e8058d61797dd4e33d42bcd68862b6c6910856b100552a509a202c240f9,0x09fb1367f29be6e4d3498348e22d849b9f8e55a0d925a3dd28aa35c8f89f0c75,0xa64fcb8dcf962168cf9a099207f19035d83c0d9ccb3d3b85c247e605c9a40775,0xa3e496eff20d92e46fba85ccd00d2f9ed65dbe52abf114786d776f931c043136,0xb9375aefcf21f42b4916bc0d173ad64bf946f409b2b199dac7b15f2ea2af4349,0x9b25a00223861a8686bb2afa5cffc30ff7484449ef1b11c6d5313d5056d766e0,0x344c906ea20130d63d00689bfa7f607787d4fc2c64df51a00e37993e32ddef40,0x2171ed5f6e0753caf90082a3810770b966aadf315222c4053d03fdeacb8c00f9,0xa91bf2600dae14a4adb9b33767cfb79bf465b80251f5fee3e6d95c716b20dfac,0xf615d5d7599dedd99e4f19e2e00a48a63f57fece399b0b278722f030b4275b95,0xe98fbabadade4bf53e868e2e7596f04d8b5baa7bb4f58596c068e7aaebff15dc,0xdb0f9d63a5fb924aa5a3dc7a1b13eab6ce4c5167dd3b2771b6a55e4eed4835f5,0x0493aab15a473ca5bdf9ad6c48da5a0366c571bbfaf721deff325523d1ffebba,0xa1407525c2f3eb98ed67586287f87d67a0666f2798e8ed6b62449a043f2b7e58,0x97a9cdafc1277d6e28164bb0986ff54f5b98b7721007dd9e8150b9378ef40c04,0xabcc666dc1e332b5fa5d870c76045ef725e97b251a180351cc7fb07b3e77e43b,0x88366da5c012b19649fb367b3591f3be8aab494151028b0d6b014e2335309aa3,0x1cfe054db915e3d05e59921e63ee9b7ac14aaf73fb43cf97e3e076ec49161be6,0x3a4110f7b2bc2ea27fe22936152974b267cb9d9c21154e88886283ba073700dd,0x07544082cf0267575a0f85f582d2d89f14a7e8a35d38004926069119fbb3c5f7,0xec6775c948f96e46b6a8ca3c6e5a15cb3a7083b36fa8d53eaa2a8a6d0ccc557f,0xf9d3f3fa7082ea882aa3165ac03ba60ff0e79a3eff921e1eb611cc25d009fd5c,0x87ad29af1ad95c6865b9d666622a41bb16012a68227a3501cf6bd4bfa8c2a39e,0x13b633f30ae38e1e4380749ba7cb99145e0be5c5fc2d8158e821ce3368e97f81,0x615d3515666b08b8ecfa2829e6cf5b038a48b04a70b2679f7a861556203c643c,0xc6122694981bb149fa1fe5534d8ea4c5d02d4887dc2f7b82446ce1770da2b7d9,0xbba0325ab8800f707d7df1aa5c23754ef15df074abe28dbe93929ece3d103c9a,0x9a8e1e6975e09d0e85370cc55283b74181f380ebd5722e8596ab91f637f2d17f,0x04808516c76bd2254a9ddd1321c099c167e91be791b16cb94ec34a7344683f63,0xdfb7c4b04bf3dae7691fbfe006d46da9365376b7dee53b8ce67c663bed98f0cd,0xb9ded8af94fc93eedbfe7042688b463bfb6b8bdf5f294c636c70cbf030a1a78a)AND token_sold_symbol = 'IPOR'UNIONSELECTblock_time AS trade_time,'Wallet 2' AS wallet,(CAST(token_sold_amount_raw AS DOUBLE)/1e18) AS ipor_amount,(CAST(token_bought_amount_raw AS DOUBLE)/1e18) AS eth_amount,(CAST(token_bought_amount_raw AS DOUBLE)/1e18) / (CAST(token_sold_amount_raw AS DOUBLE)/1e18) AS "IPOR/ETH"FROM dex.tradesWHERE tx_hash in (0x1a446d041b05594c1b471425a85a89853a87d9a989e323484242a3c9cb4edc31,0x91948dc848f8907cd977b6def3fab9ae6627c305aa0599da66364d7fcabc66ec,0xe19a3b105fafa97f0dde88e79b4c2104446996298bd06a0f32cc16c2fecbb99e,0x7ffa55ea7bbd59d0143d0ed2fad0c16e3fa810f8403b0edb94cac0ee9f1ca824,0xd7db9e12aedc4fb9f883a0650842206e2851c9b2d16ac3533b59ddfc5cdbf1ae,0x9fbcdb2b061476734cd124e7d6820ddbb1a8c30abe591df759e523896a2e1962,0xfea6be831a9a0036f2e6df25e297eca01214bf17907117a3e14a0056b2002ebd,0x9bf58ffc9a492f5552ba1aab5948f2d6ce4ab5a25f470a098b16fe8220c07734,0x43b4a92e0855b52a5201813387dd50844ad7bf0c86605a987270436ebbe94bd7,0xe1c0b64dbb528e2e7376f997a517e1a91f329d9858fab8b67bfd1e44aecdf72a,