Query editor
WITH addresses AS (SELECT address, blockchain FROM cex.addresses WHERE cex_name = 'FixedFloat'), eth_ethereum AS (SELECTtx.block_time, "to" AS recipient, hash AS txn_hash, tx.value / POWER(10, 18) * usd.price AS usd_value, usd.symbol, 'ethereum' AS blockchainFROM ethereum.transactions txINNER JOIN prices.usd usdON usd.minute = date_trunc('minute', tx.block_time)WHERE tx."from" IN (SELECT address FROM addresses WHERE blockchain = 'ethereum')-- WHERE tx.hash = 0xc4a43c1191f9ca97c7ec8873dcbb83f833ebe902939ec7095d509cd07ef13521AND usd.contract_address IS NULLAND usd.blockchain IS NULLAND usd.symbol = 'ETH'AND tx.value / POWER(10, 18) * usd.price < {{input_usd_2}} * 1.1AND tx.value / POWER(10, 18) * usd.price > {{input_usd_2}} * 0.9AND tx.block_time > timestamp '{{start_time_2}}'AND tx.block_time < timestamp '{{end_time_2}}'), erc_ethereum AS (SELECTtx.evt_block_time, "to" AS recipient, evt_tx_hash AS txn_hash, tx.value / POWER(10, usd.decimals) * usd.price AS usd_value, usd.symbol, usd.blockchainFROM erc20_ethereum.evt_transfer txINNER JOIN prices.usd usdON usd.minute = date_trunc('minute', tx.evt_block_time)AND tx.contract_address = usd.contract_addressWHERE tx."from" IN (SELECT address FROM addresses WHERE blockchain = 'ethereum')AND usd.blockchain = 'ethereum'AND tx.value / POWER(10, usd.decimals) * usd.price < {{input_usd_2}} * 1.1AND tx.value / POWER(10, usd.decimals) * usd.price > {{input_usd_2}} * 0.9AND tx.evt_block_time > timestamp '{{start_time_2}}'AND tx.evt_block_time < timestamp '{{end_time_2}}'), trx_tron AS (SELECTtx.block_time, "to" AS recipient, hash AS txn_hash, tx.value / POWER(10, 6) * usd.price AS usd_value, usd.symbol, 'tron' AS blockchainFROM tron.transactions txINNER JOIN prices.usd usdON usd.minute = date_trunc('minute', tx.block_time)WHERE tx."from" IN (0x2A0BC323D8654FB825E303852B97B1AB1A17C04D -- TDoXUNZ6PajKuiUkcYg3EDSV9bnqGqsbcf)AND usd.contract_address IS NULLAND usd.blockchain IS NULLAND usd.symbol = 'TRX'AND tx.value / POWER(10, 6) * usd.price < {{input_usd_2}} * 1.1AND tx.value / POWER(10, 6) * usd.price > {{input_usd_2}} * 0.9AND tx.block_time > timestamp '{{start_time_2}}'