Query editor
-- Glider TVL over time on BNB Chain.-- Every strategy asset enters or leaves a Glider portfolio through one of three-- contracts: Glider's router, Glider's fee collector, or Ondo's GMTokenManager-- (which mints/burns the tokenised-stock assets). Filtering on those three is-- selective and cheap, and captures the portfolio holdings that carry the value.WITH infra AS (SELECT * FROM (VALUES(0x7e2b68118307ec9669573905de52e394c36399c8), -- Glider router(0x7c5bb330ea12806b2340d7ddba2c062b9c840728), -- Glider fee collector(0x91f8aff3738825e8eb16fc6f6b1a7a4647bdb299) -- Ondo GMTokenManager) AS t(a)),flows AS (-- assets moving INTO portfoliosSELECT evt_block_date AS day, contract_address AS token, CAST(value AS double) AS amtFROM erc20_bnb.evt_transferWHERE "from" IN (0x7e2b68118307ec9669573905de52e394c36399c8,0x7c5bb330ea12806b2340d7ddba2c062b9c840728,0x91f8aff3738825e8eb16fc6f6b1a7a4647bdb299)AND "to" NOT IN (0x7e2b68118307ec9669573905de52e394c36399c8,0x7c5bb330ea12806b2340d7ddba2c062b9c840728,0x91f8aff3738825e8eb16fc6f6b1a7a4647bdb299,0x0000000000000000000000000000000000000000)AND evt_block_date >= DATE '2026-06-01'UNION ALL-- assets moving OUT of portfoliosSELECT evt_block_date, contract_address, -CAST(value AS double)FROM erc20_bnb.evt_transferWHERE "to" IN (0x7e2b68118307ec9669573905de52e394c36399c8,0x7c5bb330ea12806b2340d7ddba2c062b9c840728,0x91f8aff3738825e8eb16fc6f6b1a7a4647bdb299)AND "from" NOT IN (0x7e2b68118307ec9669573905de52e394c36399c8,0x7c5bb330ea12806b2340d7ddba2c062b9c840728,0x91f8aff3738825e8eb16fc6f6b1a7a4647bdb299,0x0000000000000000000000000000000000000000)AND evt_block_date >= DATE '2026-06-01'),daily_net AS (SELECT day, token, SUM(amt) AS net_raw FROM flows GROUP BY 1,2),holdings AS (SELECT day, token,SUM(net_raw) OVER (PARTITION BY token ORDER BY dayROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_rawFROM daily_net),px AS (SELECT DATE_TRUNC('day', minute) AS day, contract_address AS token,AVG(price) AS price, MAX(decimals) AS decimalsFROM prices.usdWHERE blockchain = 'bnb' AND minute >= TIMESTAMP '2026-06-01'GROUP BY 1,2)SELECT h.day,ROUND(SUM(CASE WHEN p.price IS NOT NULL AND h.cum_raw > 0THEN h.cum_raw / POWER(10, p.decimals) * p.price END), 2) AS tvl_usd,COUNT(DISTINCT CASE WHEN h.cum_raw > 0 THEN h.token END) AS tokens_held,COUNT(DISTINCT CASE WHEN h.cum_raw > 0 AND p.price IS NOT NULLTHEN h.token END) AS tokens_pricedFROM holdings hLEFT JOIN px p ON p.token = h.token AND p.day = h.dayGROUP BY 1