Query editor
with tradesByHourOfDay as (selecttransactions.block_date, hour(transactions.block_time) as hour, COUNT(distinct (transactions.block_hash)) as numberOfTrades, SUM(gas_used * gas_price * price) / 1e18 as gasFeesUsd, COUNT(distinct (transactions."from")) as NumberOfUsersfrom boba.transactions as transactionsleft join prices.hour on (blockchain = 'boba'and contract_address = 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000and timestamp = date_trunc('hour', transactions.block_time))group byblock_date, HOUR(transactions.block_time)order byblock_date asc, hour asc, numberOfTrades asc)selecthour, FLOOR(AVG(numberOfTrades)) as averageNumberOfTrades, APPROX_PERCENTILE(numberOfTrades, 0.5) as medianNumberOfTrades, FLOOR(AVG(gasFeesUsd)) as averageGasFeesUSD, APPROX_PERCENTILE(gasFeesUsd, 0.5) as medianGasFeesUSD, FLOOR(AVG(numberOfUsers)) as averageNumberOfUsers, APPROX_PERCENTILE(numberOfUsers, 0.5) as medianNumberOfUsersfrom tradesByHourOfDaygroup byhourorder byhour asc