Query editor
WITH vaults AS (SELECT * FROM (VALUES-- vault_name, proxy_address, underlying_address, underlying_symbol, underlying_decimals, blockchain('Polygon Fluid USDT Vault', 0x54acfc59ab6f31d8da0db6c1725577b1cf53650c, 0xc2132d05d31c914a87c6611c10748aeb04b58e8f, 'USDT0', 6, 'polygon'),('Polygon USDT Fluid Lender Yearn Vault V3', 0x1ac2ea818d8ee89f7b8999d717e730b22d6c7e7b, 0xc2132d05d31c914a87c6611c10748aeb04b58e8f, 'USDT0', 6, 'polygon'),('USDT Aave Lending', 0xf214b8a7687cfc6dbe1a7fa5f68d021ebcfdfcd1, 0xc2132d05d31c914a87c6611c10748aeb04b58e8f, 'USDT0', 6, 'polygon')) AS t(vault_name, proxy_address, underlying_address, underlying_symbol, underlying_decimals, blockchain)),pricing AS (SELECTDATE_TRUNC('day', timestamp) AS day,contract_address,AVG(price) AS priceFROM prices.dayWHERE blockchain = 'polygon'AND timestamp >= TIMESTAMP '2025-08-01'AND contract_address IN (SELECT DISTINCT underlying_address FROM vaults)GROUP BY 1, 2),all_logs AS (SELECT 'polygon' AS blockchain, contract_address, topic0, topic1, data, block_time, tx_hashFROM polygon.logsWHERE block_date >= DATE '2025-08-01' -- earliest polygon vault deployment (verified)AND contract_address IN (0x54acfc59ab6f31d8da0db6c1725577b1cf53650c,0x1ac2ea818d8ee89f7b8999d717e730b22d6c7e7b,0xf214b8a7687cfc6dbe1a7fa5f68d021ebcfdfcd1)AND topic0 IN (0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7, -- Deposit0xfbde797d201c681b91056529119e0b02407c7bb96a4a2c75c01fc9667232c8db) -- Withdraw)SELECTevt_block_time,action,vault_name,get_href(get_chain_explorer_address(blockchain, proxy_address), CAST(proxy_address AS VARCHAR)) AS proxy_address,user_address,get_href('https://polygonscan.com/tx/' || CAST(tx_hash AS VARCHAR), CAST(tx_hash AS VARCHAR)) AS tx_hash,asset,amount,amount_usdFROM (SELECTl.block_time AS evt_block_time,CASE WHEN l.topic0 = 0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7 THEN 'Deposit' ELSE 'Redeem' END AS action,v.vault_name,v.proxy_address,v.blockchain,varbinary_ltrim(l.topic1) AS user_address,l.tx_hash,v.underlying_symbol AS asset,CASE WHEN l.topic0 = 0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7 THEN 1 ELSE -1 END* CAST(bytearray_to_uint256(varbinary_substring(l.data, 1, 32)) AS DOUBLE) / POWER(10, v.underlying_decimals) AS amount,CASE WHEN l.topic0 = 0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7 THEN 1 ELSE -1 END* CAST(bytearray_to_uint256(varbinary_substring(l.data, 1, 32)) AS DOUBLE) / POWER(10, v.underlying_decimals)* COALESCE(p.price, 1.0) AS amount_usd -- USDT0 = USD stable fallbackFROM all_logs lINNER JOIN vaults v ON v.proxy_address = l.contract_address AND v.blockchain = l.blockchainLEFT JOIN pricing pON p.contract_address = v.underlying_addressAND p.day = DATE_TRUNC('day', l.block_time)) activity