hour,

from_address

(

select

from_address,

min(date_trunc('hour', block_timestamp)) as "hour"

from

blast.core.fact_transactions

group by

1

)

group by

1