Query editor
withL1Vest as (selectdate_trunc('week', evt_block_time) as day,sum(value / 1e18) as L1_Vestedfromsynthetix_ethereum.SNX_evt_Transferwhereevt_tx_hash not in (0x0a4000aefe194802fb56c4c7030c98cf1f5ea6c86ed81e06a3a609222a7d679b, 0x0527ee8991f1ff49894695d8763f8328ad3768f78832c9d52e9e61e8bde159ca)and evt_block_time > now() - interval '365' dayand "from" IN ((0xDA4eF8520b1A57D7d63f1E249606D1A459698876),(0xAc86855865CbF31c8f9FBB68C749AD5Bd72802e3),(0xFAd53Cc9480634563E8ec71E8e693Ffd07981d38))Group by1),L2Vest as (select date_trunc('week', evt_block_time) as day,sum(value / 1e18) as L2_Vestedfromsynthetix_optimism.SNX_evt_Transferwhereevt_tx_hash not in (0x901dc14e7426d2ef575194c1fd69e40600ca5432e12a7b2a1014900d6ff3d544, 0x190dccb91ccc48d2b303aeb0df5f6d865e0ca264324caeece6382d97e1ae1888)and evt_block_time > now() - interval '365' dayand "from" IN ((0x6330D5F08f51057F36F46d6751eCDc0c65Ef7E9e),(0x47eE58801C1AC44e54FF2651aE50525c5cfc66d0),(0x5Fc9B8d2B7766f061bD84a41255fD1A76Fd1FAa2))group by 1),snx_price as (select date_trunc('week', minute) as day, avg(price) as price from prices.usdwhere contract_address = (0xC011a73ee8576Fb46F5E1c5751cA3B9Fe0af2a6F)and minute > now() - interval '365' daygroup by date_trunc('week', minute))selectt1.day,L1_Vested,coalesce(L2_Vested,0) as L2_Vested,L1_Vested + coalesce(L2_Vested,0) as Total_Release,sum(L1_Vested) over (order byt1.day) as Cumulative_Release_L1,sum(L2_Vested) over (order byt1.day) as Cumulative_Release_L2,sum(L1_Vested + coalesce(L2_Vested,0)) over (order byt1.day) as Cumulative_Release_Total,