Query editor
withtvl_query AS (SELECT'FF' AS locator, day,SUM(tvl) AS TVLFROM query_3900274GROUP BY 1,2ORDER BY day DESCLIMIT 1),volumes AS (withcarbon_txs AS (SELECT *,CASE WHEN sourceToken = 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee then 0x78c1b0C915c4FAA5FffA6CAbf0219DA63d7f4cb8 else sourceToken END as alt_sourceToken,CASE WHEN targetToken = 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee then 0x78c1b0C915c4FAA5FffA6CAbf0219DA63d7f4cb8 else targetToken END as alt_targetTokenFROM graphene_mantle.CarbonController_evt_TokensTraded ttORDER BY evt_block_time DESC),date_series AS (SELECTsequence(timestamp '2023-11-01 00:00',date_trunc('day', cast(now() as timestamp)),INTERVAL '1' DAY) AS dates),token_series AS (SELECT distinct token_addressFROM (SELECT alt_sourceToken AS token_addressFROM carbon_txsUNIONSELECT alt_targetToken AS token_addressFROM carbon_txs)),hours_tokens AS (SELECTdates.date AS date,token_addressFROM date_seriesCROSS JOIN UNNEST(dates) AS dates(date)CROSS JOIN token_series),dex_prices as (SELECT hour, contract_address, MAX(median_price) AS median_priceFROM (SELECT hour, contract_address, median_priceFROM dex.pricesWHERE contract_address in (SELECT alt_sourceToken AS token_addressFROM carbon_txsUNIONSELECT alt_targetToken AS token_addressFROM carbon_txs)