Query editor
WITHasset_prices AS (SELECT 'USDT0' AS asset, (SELECT price FROM prices.latest WHERE contract_address = 0x201eba5cc46d216ce6dc03f6a759e8e766e956ae AND blockchain = 'mantle') AS usd_priceUNION ALL SELECT 'SyrupUSDT', (SELECT price FROM prices.latest WHERE contract_address = 0xc4374775489cb9c56003bf2c9b12495fc64f0771 AND blockchain = 'plasma')UNION ALL SELECT 'USDC', (SELECT price FROM prices.latest WHERE contract_address = 0x09bc4e0d864854c6afb6eb9a9cdf58ac190d0df9 AND blockchain = 'mantle')UNION ALL SELECT 'USDe', (SELECT price FROM prices.latest WHERE contract_address = 0x4c9edd5852cd905f086c759e8383e09bff1e68b3 AND blockchain = 'ethereum')UNION ALL SELECT 'sUSDe', (SELECT price FROM prices.latest WHERE contract_address = 0x9d39a5de30e57443bff2a8307a4256c8797a3497 AND blockchain = 'ethereum')UNION ALL SELECT 'GHO', (SELECT price FROM prices.latest WHERE contract_address = 0x40d16fc0246ad3160ccc09b8d0d3a2cd28ae6c2f AND blockchain = 'ethereum')UNION ALL SELECT 'WETH', (SELECT price FROM prices.latest WHERE contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 AND blockchain = 'ethereum')UNION ALL SELECT 'wrsETH', (SELECT price FROM prices.latest WHERE contract_address = 0xa1290d69c65a6fe4df752f95823fae25cb99e5a7 AND blockchain = 'ethereum')UNION ALL SELECT 'MNT', (SELECT price FROM prices.latest WHERE contract_address = 0x78c1b0c915c4faa5fffa6cabf0219da63d7f4cb8 AND blockchain = 'mantle')UNION ALL SELECT 'FBTC', (SELECT price FROM prices.latest WHERE contract_address = 0xc96de26018a54d51c097160568752c4e3bd6c364 AND blockchain = 'mantle')),supply_transfers AS (-- USDT0SELECT 'USDT0' AS asset, "to" AS wallet, 6 AS decimals, CAST(value AS DOUBLE) AS raw_value FROM erc20_mantle.evt_Transfer WHERE contract_address = 0x7053bad224f0c021839f6ac645bdae5f8b585b69UNION ALL SELECT 'USDT0', "from", 6, -1 * CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0x7053bad224f0c021839f6ac645bdae5f8b585b69-- SyrupUSDTUNION ALL SELECT 'SyrupUSDT', "to", 6, CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xf8400f3fa9cd9f9e84e93cd9de9f14eb7b5b59b5UNION ALL SELECT 'SyrupUSDT', "from", 6, -1 * CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xf8400f3fa9cd9f9e84e93cd9de9f14eb7b5b59b5-- WETHUNION ALL SELECT 'WETH', "to", 18, CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xeac30ed8609f564ae65c809c4bf42db2ff426d2cUNION ALL SELECT 'WETH', "from", 18, -1 * CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xeac30ed8609f564ae65c809c4bf42db2ff426d2c-- wrsETHUNION ALL SELECT 'wrsETH', "to", 18, CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0x5cc6999ac46f4627309a7ce0f321a3f45d138ed5UNION ALL SELECT 'wrsETH', "from", 18, -1 * CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0x5cc6999ac46f4627309a7ce0f321a3f45d138ed5-- sUSDeUNION ALL SELECT 'sUSDe', "to", 18, CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xaf972f332ff79bd32a6cb6b54f903ea0f9b16c2aUNION ALL SELECT 'sUSDe', "from", 18, -1 * CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xaf972f332ff79bd32a6cb6b54f903ea0f9b16c2a-- USDeUNION ALL SELECT 'USDe', "to", 18, CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xb9aca933c9c0aa854a6dbb7b12f0cc3fdac15ee7UNION ALL SELECT 'USDe', "from", 18, -1 * CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xb9aca933c9c0aa854a6dbb7b12f0cc3fdac15ee7-- USDCUNION ALL SELECT 'USDC', "to", 6, CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xcb8164415274515867ec43cbd284ab5d6d2b304fUNION ALL SELECT 'USDC', "from", 6, -1 * CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xcb8164415274515867ec43cbd284ab5d6d2b304f-- GHOUNION ALL SELECT 'GHO', "to", 18, CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xee1eabe23fa42028809f587b8fe1936b154d2620UNION ALL SELECT 'GHO', "from", 18, -1 * CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xee1eabe23fa42028809f587b8fe1936b154d2620-- MNTUNION ALL SELECT 'MNT', "to", 18, CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0x85d86061e94ce01d3da0f9efa289c86ff136125aUNION ALL SELECT 'MNT', "from", 18, -1 * CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0x85d86061e94ce01d3da0f9efa289c86ff136125a-- FBTCUNION ALL SELECT 'FBTC', "to", 8, CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xfa14c9de267b59a586043372bd98ed99e3ee0533UNION ALL SELECT 'FBTC', "from", 8, -1 * CAST(value AS DOUBLE) FROM erc20_mantle.evt_Transfer WHERE contract_address = 0xfa14c9de267b59a586043372bd98ed99e3ee0533),borrow_transfers AS (-- USDT0SELECT 'USDT0' AS asset, "to" AS wallet, 6 AS decimals, CAST(value AS DOUBLE) AS raw_value FROM erc20_mantle.evt_Transfer WHERE contract_address = 0x5d9e4663d3d532179c404dbe9edf93045f89aded