WITH base_data AS (

-- Calculate the swap size, swap count, and categorize time periods

SELECT

BLOCK_TIMESTAMP,

COALESCE(FROM_AMOUNT_USD, TO_AMOUNT_USD) AS SWAP_SIZE,

FROM_ADDRESS,

CASE

WHEN BLOCK_TIMESTAMP >= DATEADD(DAY, -1, CURRENT_TIMESTAMP) THEN '24H'

WHEN BLOCK_TIMESTAMP >= DATEADD(DAY, -7, CURRENT_TIMESTAMP) THEN '7D'

WHEN BLOCK_TIMESTAMP >= DATEADD(DAY, -30, CURRENT_TIMESTAMP) THEN '30D'

ELSE 'TOTAL'

END AS PERIOD

FROM

thorchain.defi.fact_swaps

WHERE

BLOCK_TIMESTAMP between '{{START_DATE}}' and '{{END_DATE}}' -- Assuming the total is for swaps after 2024

and affiliate_address='okw'),

period_summary AS (

-- Summarize data for each period

SELECT

PERIOD,

COUNT(*) AS SWAP_COUNT,

COUNT(DISTINCT FROM_ADDRESS) AS SWAPPER_COUNT,

SUM(SWAP_SIZE) AS TOTAL_VOLUME

FROM

base_data

GROUP BY

PERIOD

),

previous_periods AS (

-- Calculate the previous period data for percentage change calculations

SELECT