select

count(distinct Block_id) Blocks,

datediff(seconds,min(block_timestamp) , max(Block_timestamp)) Time_seconds ,

count(DISTINCT tx_id) Transactions,

count(distinct From_address) Addresses

from ethereum.transactions

where 1=1

AND To_address = '0xdfc243bb46dbdbc5923a52cb46dd237b3648f20c'

and function_name = 'purchase'

and success = 'TRUE'

and date_trunc('hour',block_timestamp ) > '2021-08-07T09:55:55Z'