Query editor
with hashflow as (select'ethereum' as blockchain,'Hashflow' as project,null as version,block_date,block_time,token_sold_symbol as taker_symbol,token_bought_symbol as maker_symbol,CASEWHEN hf.token_sold_symbol < hf.token_bought_symbol THEN hf.token_sold_symbol || '-' || hf.token_bought_symbolELSE hf.token_bought_symbol || '-' || hf.token_sold_symbolEND as token_pair,taker_token_amount,maker_token_amount,"baseTokenAmount" as taker_token_amount_raw,"quoteTokenAmount" as maker_token_amount_raw,amount_usd,"baseToken" as taker_token,"quoteToken" as maker_token,trader as taker,contract_address as maker,"name" as pmm, -- hashflow's maker is MMcontract_address as project_contract_address,evt_tx_hash as tx_hash,"from" as tx_from,"to" as tx_to,-- trace_address,evt_indexfrom query_3148654 hf-- hf all time),get_trade as (SELECTblockchain,project,version,block_date,block_time,token_sold_symbol as taker_symbol,token_bought_symbol as maker_symbol,token_pair,token_sold_amount as taker_token_amount,token_bought_amount as maker_token_amount,token_sold_amount_raw as taker_token_amount_raw,token_bought_amount_raw as maker_token_amount_raw,amount_usd,token_sold_address as taker_token,token_bought_address as maker_token,taker,maker,null as pmm,project_contract_address,tx_hash,tx_from,tx_to,-- trace_address,evt_indexFROM