Query editor
with tradesByDayOfWeek as (selectdate_trunc('day', transactions.block_time) AS block_date,day_of_week(transactions.block_time) as dayOfWeek, COUNT(distinct (transactions.block_hash)) as numberOfTrades, SUM(gas_used * gas_price * price) / 1e18 as gasFeesUsd, COUNT(distinct (transactions."from")) as NumberOfUsers, COUNT(distinct (address)) as contractsDeployedfrom boba.transactions as transactionsleft join boba.creation_traces as traces on transactions.to = traces.addressleft join prices.hour on (blockchain = 'boba'and contract_address = 0xdeaddeaddeaddeaddeaddeaddeaddeaddead0000and timestamp = date_trunc('hour', transactions.block_time))GROUP BYdate_trunc('day', transactions.block_time),day_of_week(transactions.block_time)ORDER BYblock_date ASC,dayOfWeek ASC,numberOfTrades ASC)selectdayOfWeek,CASEWHEN dayOfWeek = 1 THEN 'Monday'WHEN dayOfWeek = 2 THEN 'Tuesday'WHEN dayOfWeek = 3 THEN 'Wednesday'WHEN dayOfWeek = 4 THEN 'Thursday'WHEN dayOfWeek = 5 THEN 'Friday'WHEN dayOfWeek = 6 THEN 'Saturday'WHEN dayOfWeek = 7 THEN 'Sunday'END as weekday, 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 medianNumberOfUsersFROMtradesByDayOfWeekGROUP BYdayOfWeekORDER BYdayOfWeek ASC