Query editor
-- Step 1: Identify large GOAT token transactionsWITH LargeTransactions AS (SELECTblock_time,trader_id,token_bought_symbol,token_bought_amountFROMdex_solana.tradesWHEREtoken_bought_symbol = 'GOAT'AND token_bought_amount > 1000000),-- Step 2: Count the number of large transactions per dayWhaleActivity AS (SELECTDATE(block_time) AS transaction_date,COUNT(*) AS number_of_large_transactionsFROMLargeTransactionsGROUP BYDATE(block_time))-- Step 3: Retrieve and order daily large transaction countsSELECTwa.transaction_date,wa.number_of_large_transactionsFROMWhaleActivity waORDER BYwa.transaction_date;