WITH TAB1 AS (

SELECT

date_trunc('day', block_timestamp) AS date,

tx_id,

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,