to_char(block_timestamp::date,'YYYY-MM-DD') as eth_day,

COUNT((tx_id)) as transaction_count,

sum(fee_usd) as efees_usd,

avg(fee_usd) as efees_usdavg,

median(fee_usd) as efees_usdmed,

stddev(fee_usd) as efees_usdstd,

efees_usdmed + efees_usdstd as eZ1,

efees_usdmed - efees_usdstd as eZn1

--pFEES_USDstd/pFEES_USDavg as pctavg

-- nullif(pFEES_USDstd/(pFEES_USDmed),0) * 100 as pctmed

FROM ethereum.transactions

GROUP BY eth_day

ORDER BY eth_day DESC

LIMIT 100