Query editor
-- Daily token holdings of Glider portfolios on BNB.-- Anchored ONLY on Glider's own router and fee collector (Glider-exclusive).-- Ondo's GMTokenManager is deliberately excluded: it also serves non-Glider-- holders of the tokenised stocks, so including it would overstate Glider.-- A date spine carries holdings forward across days with no activity.WITH flows AS (SELECT evt_block_date AS day, contract_address AS token, CAST(value AS double) AS amtFROM erc20_bnb.evt_transferWHERE "from" IN (0x7e2b68118307ec9669573905de52e394c36399c8, 0x7c5bb330ea12806b2340d7ddba2c062b9c840728)AND "to" NOT IN (0x7e2b68118307ec9669573905de52e394c36399c8, 0x7c5bb330ea12806b2340d7ddba2c062b9c840728,0x91f8aff3738825e8eb16fc6f6b1a7a4647bdb299, 0x0000000000000000000000000000000000000000)AND evt_block_date >= DATE '2026-06-01'UNION ALLSELECT evt_block_date, contract_address, -CAST(value AS double)FROM erc20_bnb.evt_transferWHERE "to" IN (0x7e2b68118307ec9669573905de52e394c36399c8, 0x7c5bb330ea12806b2340d7ddba2c062b9c840728)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),spine AS (SELECT d AS day FROM UNNEST(SEQUENCE(DATE '2026-06-01', CURRENT_DATE, INTERVAL '1' DAY)) AS x(d)),tok AS (SELECT DISTINCT token FROM daily_net),grid AS (SELECT s.day, t.token FROM spine s CROSS JOIN tok t)SELECT g.day, g.token,SUM(COALESCE(n.net_raw, 0)) OVER (PARTITION BY g.token ORDER BY g.dayROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_rawFROM grid gLEFT JOIN daily_net n ON n.day = g.day AND n.token = g.tokenORDER BY g.day, g.token