Query editor
WITH token_flows as (SELECTdate(evt_block_time) as dt,SUM(CASE WHEN "from" = 0x0000000000000000000000000000000000000000 THEN 1 ELSE -1 END * (value / POWER(10, 18))) as valueFROMerc20_ethereum.evt_transferWHERE contract_address = 0xdd629e5241cbc5919847783e6c96b2de4754e438 -- mTBILLand 0x0000000000000000000000000000000000000000 in ("from", "to")GROUP BY 1),calendar AS (SELECTdateFROMUNNEST(SEQUENCE(timestamp '2025-06-01',CURRENT_DATE,INTERVAL '1' DAY)) AS tab(date)),token_balance as (SELECTcl.date,SUM(COALESCE(tf.value, 0)) OVER (ORDER BY cl.date) as token_balanceFROMcalendar clLEFT JOINtoken_flows tfON cl.date = tf.dt),prices as (SELECTdt AS date,MAX(price_usd) as priceFROM dune.steakhouse.result_token_priceWHERE token_address in (0xdd629e5241cbc5919847783e6c96b2de4754e438 -- mTBILL)AND blockchain = 'ethereum'GROUP BY 1)SELECTdate,token_balance AS supply,token_balance * price AS TVL,POW((price/LAG(price,7) OVER(ORDER BY date ASC)), 365.0/7.0) -1 AS APY_7d,POW((price/LAG(price,30) OVER(ORDER BY date ASC)), 365.0/30.0) -1 AS APY_30d