SELECT DISTINCT FROM_CURRENCY, TO_CURRENCY, POOL_IDS[0] AS poolid

FROM osmosis.core.fact_swaps

WHERE POOL_IDS[1] IS NULL

AND POOL_IDS[0] IS NOT NULL),

tpool2 AS (

SELECT FROM_CURRENCY, PROJECT_NAME AS TO_cur, poolid

FROM tpool1

LEFT JOIN osmosis.core.dim_labels

ON tpool1.TO_CURRENCY = osmosis.core.dim_labels.ADDRESS

),

tpool AS(

SELECT MAX(Concat(PROJECT_NAME,'/',TO_cur)) AS Pool_Pair, poolid

From tpool2

LEFT JOIN osmosis.core.dim_labels

ON tpool2.FROM_CURRENCY = osmosis.core.dim_labels.ADDRESS

GROUP BY 2),

t1 AS (

SELECT Date_trunc('day',BLOCK_TIMESTAMP) AS Date, POOL_IDS[0] AS pool

FROM osmosis.core.fact_swaps

WHERE block_timestamp::date >= '2022-05-01'

UNION ALL

SELECT Date_trunc('day',BLOCK_TIMESTAMP), POOL_IDS[1]

FROM osmosis.core.fact_swaps

WHERE block_timestamp::date >= '2022-05-01'

UNION ALL

SELECT Date_trunc('day',BLOCK_TIMESTAMP), POOL_IDS[2]

FROM osmosis.core.fact_swaps