select distinct

case Success when 'TRUE' THEN 'YES' WHEN 'FALSE' THEN 'NO' END AS Tran_Success,

TX_FEE ,

gas_price,

block_id,

gas_used,

LEFT(from_address, 5) as from_address ,

avg(TX_FEE) over (partition by block_id,Success order by Block_id ) as AVG_FEE

from ethereum.transactions t

where 1=1

AND To_address = '0xdd69da9a83cedc730bc4d3c56e96d29acc05ecde'

--and function_name = 'mint'

--and Success = 'TRUE'

and function_signature = '0x877a294a'

-- and block_id = 13282945

and( block_id >= 13282934 and block_id <= 13282951)

and date_trunc('hour',block_timestamp ) > '2021-09-23T00:55:55Z' and date_trunc('hour',block_timestamp ) < '2021-09-23T17:00:55Z'

order by block_id desc