Query editor
SELECTproject,blockchain,DATE_TRUNC('day', block_date) AS day,sum(amount_usd) AS volume,count(DISTINCT(taker)) as active_userFROM dex.tradesWHERE(token_bought_address = 0xc5f0f7b66764F6ec8C8Dff7BA683102295E16409OR token_sold_address = 0xc5f0f7b66764F6ec8C8Dff7BA683102295E16409)AND blockchain IN ('ethereum', 'bnb')AND block_date > TIMESTAMP '2023-03-27 00:00:00 UTC'GROUP BY 1, 2, 3