Query editor
-- Trust × $U Vault Events Log-- Visualization: Table-- Chronological list of all deposit and withdrawal events on the OAV---- Trust $U OAV (vault shares / twtU): 0x1A89B7A36EC8993525aEeEABBe0f505e5b91fDb1-- $U token (for USD pricing): 0xcE24439F2D9C6a2289F741120FE202248B666666WITH pricing AS (SELECTDATE_TRUNC('day', minute) AS day,AVG(price) AS priceFROM prices.usdWHERE contract_address = 0xcE24439F2D9C6a2289F741120FE202248B666666AND blockchain = 'bnb'GROUP BY 1)SELECTevt_block_time,action,user,evt_tx_hash,amount,COALESCE(amount * p.price, amount) AS amount_usdFROM (SELECTl.block_time AS evt_block_time,'Deposit' AS action,varbinary_ltrim(topic1) AS user,get_href('https://bscscan.com/tx/' || CAST(l.tx_hash AS VARCHAR), CAST(l.tx_hash AS VARCHAR)) AS evt_tx_hash,CAST(bytearray_to_uint256(varbinary_substring(data, 1, 32)) AS DOUBLE) / 1e18 AS amountFROM bnb.logs lWHERE l.contract_address = 0x1A89B7A36EC8993525aEeEABBe0f505e5b91fDb1AND topic0 = 0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7UNION ALLSELECTl.block_time AS evt_block_time,'Withdraw' AS action,varbinary_ltrim(topic1) AS user,get_href('https://bscscan.com/tx/' || CAST(l.tx_hash AS VARCHAR), CAST(l.tx_hash AS VARCHAR)) AS evt_tx_hash,-CAST(bytearray_to_uint256(varbinary_substring(data, 1, 32)) AS DOUBLE) / 1e18 AS amountFROM bnb.logs lWHERE l.contract_address = 0x1A89B7A36EC8993525aEeEABBe0f505e5b91fDb1AND topic0 = 0xfbde797d201c681b91056529119e0b02407c7bb96a4a2c75c01fc9667232c8db) eventsLEFT JOIN pricing p ON p.day = DATE_TRUNC('day', evt_block_time)ORDER BY evt_block_time DESC