Query editor
WITH liqudity AS (SELECTSUM(value) AS daily_supplyFROM (SELECTevt_block_time,TRY_CAST(value AS DOUBLE) / 1e18 AS valueFROM erc20_base.evt_transferWHERE contract_address = 0x4200000000000000000000000000000000000006 /* TCAP 2.0 */AND "from" = 0x2b70cea59a418d77265482564610ef4d681d5ad6UNION ALLSELECTevt_block_time,-TRY_CAST(value AS DOUBLE) / 1e18 AS valueFROM erc20_base.evt_transferWHERE contract_address = 0x4200000000000000000000000000000000000006 /* TCAP 2.0 */AND "to" = 0x2b70cea59a418d77265482564610ef4d681d5ad6) AS c),price_usd AS (SELECTprice AS eth_price_usdFROM prices.usdWHERE symbol = 'WETH'AND blockchain = 'base'AND minute <= NOW()ORDER BY minute DESCLIMIT 1)SELECTdaily_supply * -1 AS supply_weth,daily_supply * COALESCE(eth_price_usd, 0) * -1 AS liqudity_usdFROM liqudityLEFT JOIN price_usd ON TRUE