dayname(a.block_timestamp) as days,

DAYOFWEEK(a.block_timestamp) as day_num,

avg(b.near_price*TRANSACTION_FEE)/pow(10,24) as daily_avg_fee

FROM near.core.fact_transactions a

LEFT JOIN (SELECT date_trunc('day',timestamp) as date,

median(price_usd) as near_price

FROM near.core.fact_prices

WHERE symbol = 'wNEAR'

GROUP BY date) b

ON date_trunc('day',a.block_timestamp) = b.date

WHERE date_trunc('day',a.block_timestamp) between CURRENT_DATE -30 and CURRENT_DATE-1

GROUP by hours,days,day_num

ORDER BY day_num