WITH Tab1 AS (

SELECT

tx_id,

DATE_TRUNC('DAY', block_timestamp) AS date,

affiliate_address,

affiliate_fee_basis_points,

SPLIT(from_asset, '-')[0] AS from_assets,

CASE

WHEN from_assets ILIKE '%/%' THEN SPLIT(from_assets, '/')[1]

ELSE SPLIT(from_assets, '.')[1]

END AS from_asset_names,

SPLIT(to_asset, '-')[0] AS to_assets,

CASE

WHEN to_assets ILIKE '%/%' THEN SPLIT(to_assets, '/')[1]

ELSE SPLIT(to_assets, '.')[1]

END AS to_asset_names,

CONCAT(from_asset_names, ' -> ', to_asset_names) AS assets,

CASE

WHEN assets ILIKE '%RUNE' THEN 2

ELSE 1

END AS numbering,

SUM(from_amount_usd / rune_usd) AS swap_volume

FROM thorchain.defi.fact_swaps

WHERE

block_timestamp :: date >= '{{Start_Date}}'

AND block_timestamp :: date <= '{{End_Date}}'

GROUP BY tx_id, date, affiliate_address, affiliate_fee_basis_points, from_asset, to_asset

),

Tab2 AS (

SELECT

date,

tx_id,

affiliate_address,