Query editor
selectgreatest(coalesce(cast(baseTokenAmount as double) / pow(10, pub.decimals) * pub.price,0),coalesce(cast(quoteTokenAmount as double) / pow(10, puq.decimals) * puq.price,0)) as amount_usd,cast(baseTokenAmount as double) / pow(10, pub.decimals) as taker_token_amount, -- to map to dex dedup querycast(quoteTokenAmount as double) / pow(10, puq.decimals) as maker_token_amount, -- to map to dex dedup querypub.symbol as token_sold_symbol,puq.symbol as token_bought_symbol,casewhen hf.contract_address = 0xbfa899c1ad97229d9c604e9ea927c7acb988c05c then 'Wintermute'when hf.contract_address = 0x9a5ef5f053dd2efaff0b74e1876c66f6825774af then '3,3 Pool'when hf.contract_address = 0xa86689118d8d940d6ad729c2d7872da3fa20dd40 then 'Kekpool'when hf.contract_address = 0x46c7ac58cff631cd57aeb249a1213dff062f146b then 'Altonomy'when hf.contract_address = 0x4ba77325aa4452602ceef86fee44df9cdb050289 then 'Pool AP1'when hf.contract_address = 0xb570895414d77b793b1989b3a0d7eb6b13716352 then 'XYZETH'when hf.contract_address = 0xc45f25c12fc9449607d6e6c98a30515ef29eb015 then 'CCC Prod'else CAST(hf.contract_address AS varchar)end as name,hf.*,t.block_time,t.block_date,"from","to"fromhashflow_ethereum.pool_evt_trade hfleft join prices.usd pub on (pub.blockchain = 'ethereum'and pub.contract_address = (casewhen hf.baseToken = 0x0000000000000000000000000000000000000000 then 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2else hf.baseTokenend)and pub.minute = date_trunc('minute', hf.evt_block_time))left join prices.usd puq on (puq.blockchain = 'ethereum'and puq.contract_address = (casewhen hf.quoteToken = 0x0000000000000000000000000000000000000000 then 0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2else hf.quoteTokenend)and puq.minute = date_trunc('minute', hf.evt_block_time))join ethereum.transactions t on t.hash = hf.evt_tx_hashwhereevt_block_time > now() - interval '15' day -- changeand evt_block_time < now() - interval '1' dayand block_time > now() - interval '15' day -- changeand block_time < now() - interval '1' day