Query editor
WITHfee AS (SELECT evt_tx_hash AS tx, arbitrary(contract_address) AS fee_token, SUM(value) AS fee_rawFROM erc20_ethereum.evt_TransferWHERE "to" = 0x89899093e9278f1305613077954faff8c25140d3AND evt_block_time >= now() - interval '180' dayGROUP BY evt_tx_hash),sw AS (SELECT evt_tx_hash AS tx, evt_block_time AS t, evt_tx_from AS trader,tokenIn AS token_in, amountIn AS amount_in_raw,middleToken AS middle_token, middleAmount AS middle_raw,swapProtocol AS swap_protocol, mayanProtocol AS mayan_protocol, false AS is_nativeFROM mayan_ethereum.mayanforwarder2_evt_swapandforwardederc20WHERE evt_block_time >= now() - interval '180' dayUNION ALLSELECT evt_tx_hash, evt_block_time, evt_tx_from,0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2, amountIn,middleToken, middleAmount, swapProtocol, mayanProtocol, trueFROM mayan_ethereum.mayanforwarder2_evt_swapandforwardedethWHERE evt_block_time >= now() - interval '180' day),base AS (SELECT sw.*, fee.fee_token, fee.fee_rawFROM sw JOIN fee ON sw.tx = fee.tx),px AS (SELECT contract_address, date(timestamp) AS d, price, decimals, symbolFROM prices.dayWHERE blockchain = 'ethereum' AND timestamp >= now() - interval '181' day),txs AS (SELECT hash, gas_used, gas_priceFROM ethereum.transactionsWHERE block_time >= now() - interval '180' day),outflow AS (SELECT tx, out_token, out_raw, out_amount, out_usdFROM (SELECT tr.evt_tx_hash AS tx, tr.contract_address AS out_token, tr.value AS out_raw,tr.value / power(10, coalesce(p.decimals, 18)) AS out_amount,tr.value / power(10, coalesce(p.decimals, 18)) * p.price AS out_usd,row_number() OVER (PARTITION BY tr.evt_tx_hashORDER BY tr.value / power(10, coalesce(p.decimals, 18)) * coalesce(p.price, 0) DESC,tr.value DESC) AS rnFROM erc20_ethereum.evt_Transfer trJOIN base b ON b.tx = tr.evt_tx_hash AND b.trader = tr."to"LEFT JOIN prices.day p ON p.blockchain = 'ethereum'AND p.contract_address = tr.contract_addressAND date(p.timestamp) = date(tr.evt_block_time)WHERE tr.evt_block_time >= now() - interval '181' day) WHERE rn = 1)SELECTb.t AS block_time,b.tx AS tx_hash,b.trader,b.is_native,