date_params AS (

SELECT '2022-12-19 23:59:59.999' AS cutoff_time

, cutoff_time::date AS cutoff_date

),

superfluid_staking_pools__raw AS (

SELECT p.pool_id

, (CASE p.assets[0]['asset_address'] WHEN 'uosmo' THEN p.assets[1]['asset_address'] ELSE p.assets[0]['asset_address'] END) AS token0_address

, (CASE p.assets[1]['asset_address'] WHEN 'uosmo' THEN p.assets[1]['asset_address'] ELSE p.assets[0]['asset_address'] END) AS token1_address

FROM osmosis.core.dim_liquidity_pools AS p

WHERE pool_id IN (1, 678, 704, 712, 674, 722, 9, 604, 497, 812, 584, 3, 481, 42, 463, 15)

),

superfluid_staking_pools AS (

SELECT p.pool_id

, concat(t0.project_name, ' / ', t1.project_name) AS pool_name

, p.token0_address

, t0.project_name AS token0_symbol

, t0.decimal AS token0_decimals

, p.token1_address

, t1.project_name AS token1_symbol

, t1.decimal AS token1_decimals

FROM superfluid_staking_pools__raw AS p

LEFT JOIN osmosis.core.dim_tokens AS t0

ON t0.address = p.token0_address

LEFT JOIN osmosis.core.dim_tokens AS t1

ON t1.address = p.token1_address

),