Query editor
SELECTDATE_TRUNC ('day', block_date) "day",blockchain,SUM (amount_usd) AS daily_trade_usd,COUNT (DISTINCT (tx_hash)) daily_tradeFROM nft.tradesWHERE blockchain = 'ethereum'AND block_date > TRY_CAST('2020-01-01' AS DATE)GROUP BY 2,1ORDER BY DATE_TRUNC ('day', block_date) DESC