Query editor
-- Calculate the total transactions involving GOAT for each hourWITH hourly_transactions AS (SELECTEXTRACT(HOUR FROM block_time) AS hour, -- Extract the hour from the block timeCOUNT(*) AS transactions -- Count the number of transactions for each hourFROMdex_solana.tradesWHEREtoken_bought_symbol = 'GOAT' OR token_sold_symbol = 'GOAT' -- Filter for trades involving GOATGROUP BYEXTRACT(HOUR FROM block_time))-- Calculate the average number of transactions per hourSELECThour,AVG(transactions) AS average_transactionsFROMhourly_transactionsGROUP BYhourORDER BYhour;