(with main as ((select 'Swap to WAVAX' as swap_type, * from osmosis.core.fact_swaps where to_currency = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373' and TX_SUCCEEDED = 'TRUE') union (select 'Swap From WAVAX' as swap_type, * from osmosis.core.fact_swaps where from_currency = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373' and TX_SUCCEEDED = 'TRUE')), diff as (select swap_type, tx_id, block_timestamp, lead (BLOCK_TIMESTAMP) over (order by BLOCK_TIMESTAMP) as next_tx_time from main), tab1 as (select swap_type, tx_id,block_timestamp,next_tx_time,DATEDIFF(SECOND, BLOCK_TIMESTAMP, next_tx_time) as diff_time from diff) select case when diff_time >= '0' and diff_time <= '5' then 'Under 5 Sec' when diff_time >= '6' and diff_time <= '15' then '6-15 Sec' when diff_time >= '15' and diff_time <= '30' then '16-30 Sec' when diff_time >= '31' and diff_time <= '50' then '31-50 Sec' when diff_time >= '51' and diff_time <= '75' then '51-75 Sec' when diff_time >= '75' and diff_time <= '150' then '75-150 Sec' when diff_time >= '151' and diff_time <= '300' then '150-300 Sec' when diff_time >= '301' then 'Above 5 Min' end as "Time Difference", count(*) as "Number of Swaps", 'Time Difference Between All Swaps' as "Type" from tab1 where "Time Difference" is not null group by 1) union all (with main as ((select 'Swap to WAVAX' as swap_type, * from osmosis.core.fact_swaps where to_currency = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373' and TX_SUCCEEDED = 'TRUE') union (select 'Swap From WAVAX' as swap_type, * from osmosis.core.fact_swaps where from_currency = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373' and TX_SUCCEEDED = 'TRUE')), diff as (select swap_type, tx_id, block_timestamp, lead (BLOCK_TIMESTAMP) over (order by BLOCK_TIMESTAMP) as next_tx_time from main where swap_type = 'Swap to WAVAX'), tab1 as (select swap_type, tx_id,block_timestamp,next_tx_time,DATEDIFF(SECOND, BLOCK_TIMESTAMP, next_tx_time) as diff_time from diff) select case when diff_time >= '0' and diff_time <= '5' then 'Under 5 Sec' when diff_time >= '6' and diff_time <= '15' then '6-15 Sec' when diff_time >= '15' and diff_time <= '30' then '16-30 Sec' when diff_time >= '31' and diff_time <= '50' then '31-50 Sec' when diff_time >= '51' and diff_time <= '75' then '51-75 Sec' when diff_time >= '75' and diff_time <= '150' then '75-150 Sec' when diff_time >= '151' and diff_time <= '300' then '150-300 Sec' when diff_time >= '301' then 'Above 5 Min' end as "Time Difference", count(*) as "Number of Swaps to WAVAX", 'Time Difference Between Swaps To' as "Type" from tab1 where "Time Difference" is not null group by 1) union all (with main as ((select 'Swap to WAVAX' as swap_type, * from osmosis.core.fact_swaps where to_currency = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373' and TX_SUCCEEDED = 'TRUE') union (select 'Swap From WAVAX' as swap_type, * from osmosis.core.fact_swaps where from_currency = 'ibc/6F62F01D913E3FFE472A38C78235B8F021B511BC6596ADFF02615C8F83D3B373' and TX_SUCCEEDED = 'TRUE')), diff as (select swap_type, tx_id, block_timestamp, lead (BLOCK_TIMESTAMP) over (order by BLOCK_TIMESTAMP) as next_tx_time from main where swap_type = 'Swap From WAVAX'), tab1 as (select swap_type, tx_id,block_timestamp,next_tx_time,DATEDIFF(SECOND, BLOCK_TIMESTAMP, next_tx_time) as diff_time from diff) select case when diff_time >= '0' and diff_time <= '5' then 'Under 5 Sec' when diff_time >= '6' and diff_time <= '15' then '6-15 Sec' when diff_time >= '15' and diff_time <= '30' then '16-30 Sec' when diff_time >= '31' and diff_time <= '50' then '31-50 Sec' when diff_time >= '51' and diff_time <= '75' then '51-75 Sec' when diff_time >= '75' and diff_time <= '150' then '75-150 Sec' when diff_time >= '151' and diff_time <= '300' then '150-300 Sec' when diff_time >= '301' then 'Above 5 Min' end as "Time Difference", count(*) as "Number of Swaps From WAVAX", 'Time Difference Between Swaps From' as "Type" from tab1 where "Time Difference" is not null group by 1)

[Osmosis] - WAVAX Activity