Query editor
select * from (-- =====================================================================-- Fluid Lite ETH Vault (iETHv2) — Headline Stats — v1-- Latest complete-day headline: exchange price, 7d/30d net user APR,-- lifetime average APR, TVL. Self-contained copy of the "Fluid Lite-- ETH — Daily Metrics" query (8000996) logic — cross-query references-- to private queries are enterprise-only. If 8000996 is later-- scheduled as a materialized view, repoint this at-- dune."0xfluid".result_<mv_name> (mirrors the lite-usd pattern).-- =====================================================================with inception as (select date '2023-02-12' as start_day), days as (select cast(i.start_day + n * interval '1' day as date) as dayfrom inception as icross join unnest(sequence(0,cast(date_diff('day', i.start_day, current_date) as integer))) as t(n))-- exchange-price checkpoints: last event per day, px_events as (selectcast(block_time as date) as day, block_time, cast(varbinary_to_uint256(topic2) as double) / 1e18 as pricefrom ethereum.logswhere contract_address = 0xa0d3707c569ff8c87fa923d3823ec5d81c98be78and topic0 = 0xcde545703e0372175cadfff811d67c32910c3dcb33199679b3271c4106afdf9aand block_number >= 16609585), px_daily as (select day, max_by(price, block_time) as pricefrom px_eventsgroup by day)-- iETHv2 share supply from ERC-20 Transfer mints/burns, supply_deltas as (selectcast(block_time as date) as day, sum(casewhen topic1 = 0x0000000000000000000000000000000000000000000000000000000000000000then cast(varbinary_to_uint256(data) as double) / 1e18when topic2 = 0x0000000000000000000000000000000000000000000000000000000000000000then -cast(varbinary_to_uint256(data) as double) / 1e18else 0e0end) as deltafrom ethereum.logswhere contract_address = 0xa0d3707c569ff8c87fa923d3823ec5d81c98be78and topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3efand block_number >= 16609585and (