tokens AS (

SELECT

DISTINCT token_address,

symbol

FROM

ethereum.core.fact_hourly_token_prices

WHERE

hour::date >= '2022-06-01' AND symbol IN ('USDC', 'DAI', 'USDT', 'sUSD', 'LUSD', 'FRAX', 'MIM', 'UST', 'DOLA', 'FEI', 'TUSD', 'DUSD', 'USDP', 'alUSD', 'VUSD')

),

pools AS (

SELECT

creation_time::date AS date,

pool_address,

token1,

platform,

symbol

FROM

ethereum.core.dim_dex_liquidity_pools

JOIN

tokens

ON

token1 IN (tokens.token_address)

WHERE

platform = 'sushiswap'

),

balances AS (

SELECT

balances.balance_date,

pools.symbol,

SUM(balances.amount_usd) AS tvl

FROM

flipside_prod_db.ethereum.erc20_balances balances

JOIN

pools

ON