Query editor
-- Glider TVL over time on BNB Chain.-- Vault set is re-derived from Glider's own router / fee collector (see registry).-- Holdings per token per day = cumulative net transfers in minus out.-- Priced with Dune's daily USD price where the token is covered.WITH legs AS (SELECT "from" AS vault FROM erc20_bnb.evt_transferWHERE "to" IN (0x7e2b68118307ec9669573905de52e394c36399c8, 0x7c5bb330ea12806b2340d7ddba2c062b9c840728)AND evt_block_date >= DATE '2026-06-01'UNIONSELECT "to" FROM erc20_bnb.evt_transferWHERE "from" IN (0x7e2b68118307ec9669573905de52e394c36399c8, 0x7c5bb330ea12806b2340d7ddba2c062b9c840728)AND evt_block_date >= DATE '2026-06-01'),vaults AS (SELECT vault FROM legsWHERE vault NOT IN (0x7e2b68118307ec9669573905de52e394c36399c8, 0x7c5bb330ea12806b2340d7ddba2c062b9c840728,0x0000000000000000000000000000000000000000,0x05b1ad4a184dc08d4296f73616d2bb3e93fe5fca,0x0c57db8d95f52e31274d6432d15b696d9b1035df,0x10ecb5f21d33c5bc2df7bc71813ddf72a9e5d91c,0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae,0x1782a6de750fbfbe926662ab7309b2cd7b180907,0x17c3962c6608ba193b308cc6de741018f33b13d5,0x1ce0d5b107e796efa092580c703e8f63009eddd1,0x27f2a2cf77be50b04792ffc5c586f9e4a41dd4d0,0x2e6dd971e7ce3c7af1d759e27678d58844f06d6c,0x394311a6aaa0d8e3411d8b62de4578d41322d1bd,0x3e938cbc72ae53b54513586605f538a41ac5c4c6,0x40787c134fcad912e8afb75600dadee25ad70516,0x4882c46708d2cf067a61a904915d195727ea2c06,0x4d6509ce07fff689c753fccb335ace82d2d8048e,0x515de61cec8007491e3c83012015bd87ba2ec940,0x594c5907d9d8eae0681aafc7ae0c136f4126b979,0x64c4684bc3073a55fc080d8139440117fdae4e0e,0x687bcec7e7e9dc353b3723172b2df71a7b420101,0x77c96623065dcdb53e8bc629a624a0dd1d4db643,0x78bbc7cca3601c7e6e5faa3b5985049e7f5a1687,0x88e4cc2e69d3ee39d94bb1aa7d66c18a498dbdf4,0x8f0e937bf2973a0a28efff7578e84287502d77cc,0x91f8aff3738825e8eb16fc6f6b1a7a4647bdb299,0xa2d35e418814a8b6367c66a5ac2fec8ea16332b2,0xa75558b3e324e78a0deea13135283788f61a2c4a,0xaa9d5bda8bedc87268fd4280ca6e290a938d3cec,0xb0a498d25fc71fd53715295daeb0a650c27da3a1,0xb41733d5a671faa701561017e6bddf8080a7cf2a,0xb6c088050a0ec6f77cbda71ef0ffbcf1d00ed828,0xbaff813b35ce14cad9c085bdb50b52151aa27eb5,0xbb0dafdd0911e70963a11d3da84ba45c12236479,0xbbf6a762f5db17ecc3bd4a028e3cb6ecbbe42563,0xbfb3dbe8bfe3ec1f7dcb840444ea0e41900d1f10,0xd0cbcb84bfa11f0b42c5d1806f7e179712448f61,0xdad28637e60fe9a21ec05617f38fde82d105b4ed,0xe5cecb911354289e43da4322aade70c9d9962d4b,0xf27de7c0d516b5dbc752b0ed13f582fb2d62a0cf)),flows AS (SELECT t.evt_block_date AS day, t.contract_address AS token, CAST(t.value AS double) AS amtFROM erc20_bnb.evt_transfer t JOIN vaults v ON v.vault = t."to"WHERE t.evt_block_date >= DATE '2026-06-01'UNION ALLSELECT t.evt_block_date, t.contract_address, -CAST(t.value AS double)FROM erc20_bnb.evt_transfer t JOIN vaults v ON v.vault = t."from"WHERE t.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 NULLTHEN h.cum_raw / POWER(10, p.decimals) * p.price END), 2) AS tvl_usd_priced,