SELECT

count(*) AS "Swap Count",

count(DISTINCT FROM_ADDRESS) AS "Unique Swapper Count",

SUM(CASE

WHEN FROM_ASSET = 'THOR.RUNE' THEN FROM_AMOUNT

WHEN TO_ASSET = 'THOR.RUNE' THEN TO_AMOUNT

END) AS "Total Volume THOR.RUNE"

FROM

thorchain.defi.fact_swaps

WHERE block_timestamp::date >= '{{Start_Date}}' AND block_timestamp::date <= CURRENT_DATE - 1

),

PriceData AS (

SELECT

MAX(price) AS "Average Price"

FROM

thorchain.price.ez_prices_hourly

WHERE

symbol = 'RUNE'

AND hour >= date_trunc('day', CURRENT_TIMESTAMP - INTERVAL '1 DAY')

AND hour < date_trunc('day', CURRENT_TIMESTAMP)

),

SwapCount24H AS (

SELECT

count(*) AS "Swap Count 24H",

SUM(CASE

WHEN FROM_ASSET = 'THOR.RUNE' THEN FROM_AMOUNT

WHEN TO_ASSET = 'THOR.RUNE' THEN TO_AMOUNT

END) AS "Total Volume THOR.RUNE 24H"

FROM

thorchain.defi.fact_swaps

WHERE

BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP - INTERVAL '24 HOURS'

),

SwapCount30D AS (

SELECT