Query editor
-- L2 deposit escrow: 0x5Fd79D46EBA7F351fe49BFF9E87cdeA6c821eF9fwithSNX_L2_totalSupply as (SELECTtime,SUM(SNX) over ( ORDER BYtime) as SNX_balance from (SELECTDATE_TRUNC('day', evt_block_time) as time,sum( (CASEWHENcontract_address = (0xC011a73ee8576Fb46F5E1c5751cA3B9Fe0af2a6F)THENvalue / 1e18ELSE0END) * (CASEWHENsender = (0x5Fd79D46EBA7F351fe49BFF9E87cdeA6c821eF9f)THEN1ELSE- 1END)) as SNXFROM(select *, to as sender from synthetix_ethereum.SNX_evt_Transferwhere "to" = (0x5Fd79D46EBA7F351fe49BFF9E87cdeA6c821eF9f)or "from" = (0x5Fd79D46EBA7F351fe49BFF9E87cdeA6c821eF9f)and contract_address = (0xC011a73ee8576Fb46F5E1c5751cA3B9Fe0af2a6F))group by 1order by time asc)),SNX_L1_totalSupply as (selectdate_trunc('day', call_block_time) as day,(output_0) / 1e18 as SNX_total_supply_L1fromsynthetix_ethereum.SNX_call_totalSupplyorder by call_block_time desc),SNX_price_table as (select * from (select date_trunc('day', minute) as day, minute, price,row_number() over (partition by date_trunc('day', minute) order by minute desc) as helper from prices.usdwhere symbol = 'SNX'and blockchain = 'ethereum'order by minute desc)where helper = 1order by day desc)select *, (L1_totalSupply - L1_totalSupply_t0) / L1_totalSupply * 365 / day_diff * 100 as L1_inflation,(L2_totalSupply - L2_totalSupply_t0) / L2_totalSupply * 365 / day_diff * 100 as L2_inflation,