SELECT

ORIGIN_FROM_ADDRESS as Swapper,

block_timestamp as Swap_date,

LAG(block_timestamp) OVER (

PARTITION BY Swapper

ORDER BY

block_timestamp

) AS prev_Swap_date

FROM

{{Blokchain}}.defi.ez_dex_swaps

where 1=1

and BLOCK_TIMESTAMP::date between '{{Start_date}}' and '{{End_date}}'

and platform in ('trader-joe-v1', 'trader-joe-v2')

),

Swap_time as (

SELECT

Swapper,

AVG(

DATEDIFF(hour, prev_Swap_date, Swap_date)

) AS avg_Swap_gap

FROM

SwapGaps

WHERE

prev_Swap_date IS NOT NULL

GROUP BY

Swapper

ORDER BY

Swapper

case

when avg_Swap_gap < 12 then 'A: < 12 Hours'

when avg_Swap_gap between 12

and 24 then 'B: 12-24 Hours'

when avg_Swap_gap between 24