Query editor
WITH large_token_purchases AS (SELECTblock_date,token_bought_symbol,token_bought_address,token_bought_amount,amount_usdFROMwoofi.tradesWHEREtoken_bought_symbol = 'WOO'AND token_bought_amount > 10000)SELECTblock_date,token_bought_symbol,COUNT(DISTINCT token_bought_address) AS distinct_buyers,SUM(amount_usd) AS total_spent_usdFROMlarge_token_purchasesGROUP BYblock_date, token_bought_symbolORDER BYblock_date ASC;