Query editor
-- Candidate source-of-truth ledger for the Clearstar Reactor Euler cluster on Monad.-- One tall materialized source feeds market state, suppliers, borrowers, flows, and QA.WITHvaults AS (SELECT *FROM (VALUES(0x144290085da25e3078425c6f4a477fd8cab0c43e, 'eFXRP-1', 'FXRP', 0xce6170ea245dc8d1f275a710a062b70f125f0110, 6, 0xe9b786f98c1e85126e3604e60022943caab57a78),(0x1475d3da9ca6a3aa14f76b7f5e9da0d0bcf1b2f9, 'eAUSD-12', 'AUSD', 0x00000000efe302beaa2b3e6e1b18d08d69a9012a, 6, 0xc8b12a7a1d39397959b6237fd4f32321a45197da),(0x1905eddf5943ef6c92ccf1469bd40fc2cb4a77b0, 'eUSDC-12', 'USDC', 0x754704bc059f8c67012fed69bc8a327a5aafb603, 6, 0x243012360f73b3d21c8f8560cbdb18b5a9d43b4c),(0x2f13d29b4eff12fc5e6b2560ed5183354c38a82f, 'eUSDT0-9', 'USDT0', 0xe7cd86e13ac4309349f30b3435a9d337750fc82d, 6, 0x2182985311c4581eb334b6ff209265a488c14a67)) AS t(vault_address, vault_name, asset_symbol, asset_address, decimals, dtoken_address)),earn_vaults AS (SELECT *FROM (VALUES(0xb58915867d28759dcd12e5e6610f72a9edf4758f, 0x1475d3da9ca6a3aa14f76b7f5e9da0d0bcf1b2f9, 'Clearstar Earn AUSD'),(0xe1bca19baa63894d374578320551633320436523, 0x1905eddf5943ef6c92ccf1469bd40fc2cb4a77b0, 'Clearstar Earn USDC')) AS t(earn_vault_address, reactor_vault_address, earn_vault_name)),vault_status AS (SELECT'vault_status' AS record_type,v.vault_address, v.vault_name, v.asset_symbol, v.asset_address, v.dtoken_address, v.decimals,e.evt_block_time, e.evt_block_date, e.evt_block_number, e.evt_index,e.evt_tx_hash AS tx_hash, e.evt_tx_from AS tx_from, e.evt_tx_to AS tx_to,CAST(NULL AS varbinary) AS account, CAST(NULL AS varbinary) AS account_prefix,CAST(NULL AS varbinary) AS evc_owner, CAST(NULL AS varbinary) AS counterparty,CAST(NULL AS varchar) AS flow_type,CAST(NULL AS decimal(38,0)) AS asset_delta_raw,CAST(NULL AS decimal(38,0)) AS shares_delta_raw,CAST(NULL AS decimal(38,0)) AS debt_delta_raw,CAST(e.cash AS decimal(38,0)) AS cash_raw,CAST(e.totalborrows AS decimal(38,0)) AS total_borrows_raw,CAST(e.totalshares AS decimal(38,0)) AS total_shares_raw,CAST(e.accumulatedfees AS decimal(38,0)) AS accumulated_fees_raw,CAST(e.interestaccumulator AS decimal(38,0)) AS interest_accumulator_raw,CAST(e.interestrate AS decimal(38,0)) AS interest_rate_spy_raw,CAST(e.timestamp AS bigint) AS status_timestamp,CAST(NULL AS integer) AS supply_cap_encoded,CAST(NULL AS integer) AS borrow_cap_encoded,CAST(NULL AS varbinary) AS collateral_vault,CAST(NULL AS integer) AS borrow_ltv_bps,CAST(NULL AS integer) AS liquidation_ltv_bps,CAST(NULL AS integer) AS interest_fee_bps,CAST(NULL AS varchar) AS bridge_source_chain,CAST(NULL AS varchar) AS bridge_source_contract,CAST(NULL AS bigint) AS bridge_message_countFROM euler_v2_monad.evault_evt_vaultstatus eJOIN vaults v ON v.vault_address = e.contract_addressWHERE e.evt_block_date >= DATE '2026-01-01'),share_transfers AS (SELECT'supply_share_flow' AS record_type,v.vault_address, v.vault_name, v.asset_symbol, v.asset_address, v.dtoken_address, v.decimals,e.evt_block_time, e.evt_block_date, e.evt_block_number, e.evt_index,e.evt_tx_hash, e.evt_tx_from, e.evt_tx_to,x.account, CAST(NULL AS varbinary), CAST(NULL AS varbinary), x.counterparty, x.flow_type,