Query editor
SELECTproject,date_trunc('day', block_time) as day,SUM(CASE WHEN token_a_address = price_addressTHEN token_a_amount * priceELSE token_b_amount * price END) AS usd_volumeFROM (SELECT DISTINCT ON (tx_hash, trace_address, evt_index)project ||version as project,token_a_address,token_a_amount,token_b_address,token_b_amount,p.contract_address AS price_address,price,block_timeFROM dex.trades tINNER JOIN prices.usd pON date_trunc('minute', block_time) = p.minute AND (token_a_address = p.contract_address OR token_b_address = p.contract_address)WHERE (token_a_address = '\x3472A5A71965499acd81997a54BBA8D852C6E53d'or token_b_address = '\x3472A5A71965499acd81997a54BBA8D852C6E53d')) tGROUP BY 1,2ORDER by day DESC;