BLOCK_TIMESTAMP,

from_address,tx_hash,

ROW_NUMBER() OVER (partition by from_address order by BLOCK_TIMESTAMP) as t_n

from aurora.core.fact_transactions

),

tb2 as (select

BLOCK_TIMESTAMP as first_transaction,

from tb1

where t_n=1),

tb3 as (select

BLOCK_TIMESTAMP as second_transaction,

from tb1

where from_address in (select from_address from tb2)

and t_n=2)

,

tb4 as (select

tb2.from_address,

avg(timediff('hour',first_transaction, second_transaction )) as time_between

from tb2

join tb3 on tb2.from_address=tb3.from_address

group by 1)

select

'Aurora' as platform,

avg(time_between) as average_time

from tb4

),

NEAR as (with tb1 as (select

BLOCK_TIMESTAMP,