Query editor
WITH supply_events AS (SELECTdate_trunc('day', evt_block_time) AS day,value/1e18 AS valueFROM erc20_arbitrum.evt_TransferWHERE contract_address = 0xC0e8d7a022cFfff1EE9d9351fE9BfC917004D9f8AND "from" = 0x0000000000000000000000000000000000000000UNION ALLSELECTdate_trunc('day', evt_block_time) AS day,value/-1e18 AS valueFROM erc20_arbitrum.evt_TransferWHERE contract_address = 0xC0e8d7a022cFfff1EE9d9351fE9BfC917004D9f8AND "to" = 0x0000000000000000000000000000000000000000),daily_supply AS (SELECTday,SUM(SUM(value)) OVER (ORDER BY day) AS supplyFROM supply_eventsGROUP BY day),arfi AS (SELECT date_trunc('day', minute) AS day,5 * AVG(CASE symbolWHEN 'AAVE' THEN (price * 0.004806) / 0.83WHEN 'GMX' THEN (price * 0.05457) / 0.83WHEN 'UNI' THEN (price * 0.1375) / 0.83WHEN 'PENDLE' THEN (price * 0.3822) / 0.83WHEN 'STG' THEN (price * 4.097) / 0.83WHEN 'CRV' THEN (price * 2.044) / 0.83END) AS arfi_index_priceFROM prices.usdWHERE blockchain = 'arbitrum'AND symbol IN ('AAVE', 'GMX', 'UNI', 'PENDLE', 'STG', 'CRV')AND date_trunc('day', minute) >= DATE '2025-03-14'GROUP BY 1ORDER BY 1 DESC)SELECT a.day,a.arfi_index_price,s.supply,a.arfi_index_price * s.supply AS tvlFROM arfi aJOIN daily_supply s ON a.day = s.dayORDER BY a.day DESC;