Query editor
selectt.block_time,-- hashflow contract addresses, if not labeled, uses etherscan's token trackercasewhen hf.contract_address = 0xbfa899c1ad97229d9c604e9ea927c7acb988c05c then 'Wintermute PMM'when hf.contract_address = 0x9a5ef5f053dd2efaff0b74e1876c66f6825774af then 'Kyber PMM' -- 3,3when hf.contract_address = 0xa86689118d8d940d6ad729c2d7872da3fa20dd40 then 'Kekpool PMM' -- kekpoolwhen hf.contract_address = 0x46c7ac58cff631cd57aeb249a1213dff062f146b then 'Tokka Labs PMM' -- ALT privatewhen hf.contract_address = 0x4ba77325aa4452602ceef86fee44df9cdb050289 then 'Alpha Lab PMM' -- Pool AP1when hf.contract_address = 0xb570895414d77b793b1989b3a0d7eb6b13716352 then 'XYZETH PMM'when hf.contract_address = 0xc45f25c12fc9449607d6e6c98a30515ef29eb015 then 'CCC Prod PMM'else CAST(hf.contract_address AS varchar)end as name,CASEWHEN pub.symbol < puq.symbol THEN pub.symbol || '-' || puq.symbolELSE puq.symbol || '-' || pub.symbolEND as token_pair,pub.symbol as token_sold_symbol,puq.symbol as token_bought_symbol,cast(baseTokenAmount as double) / pow(10, pub.decimals) as taker_token_amount,cast(quoteTokenAmount as double) / pow(10, puq.decimals) as maker_token_amount,greatest(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,hf.evt_tx_hash,hf.contract_address,hf.evt_index,hf.evt_block_number,hf.baseToken,hf.baseTokenAmount,-- hf.fees,-- hf.pool,hf.quoteToken,hf.quoteTokenAmount,hf.trader,hf.txid,t.block_date,"from","to"fromhashflow_ethereum.pool_evt_trade hf-- symbol, decimals, and price of the baseTokenleft 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))-- symbol, decimals, and price of the quoteToken