date_trunc('day', block_timestamp),

sum(gas_used) / count(distinct block_id) as av_gas_per_block

from ethereum.TRANSACTIONs

where block_timestamp > '2021-04-14'

and block_timestamp < '2021-04-25'

group by 1

order by 1