TSQL example of using windowing functions with frames

example.sql

select
    pricingdate
   ,price
   ,max(price) over (partition by cusip
                     order by pricingdate
                     rows between 30 preceding and current row) as max_price
   ,min(price) over (partition by cusip
                     order by pricingdate
                     rows between 30 preceding and current row) as min_price
   ,avg(price) over (partition by cusip
                     order by pricingdate
                     rows between 30 preceding and current row) as avg_price
   ,stdev(price) over (partition by cusip
                       order by pricingdate
                       rows between 30 preceding and current row) as stdev_price
   ,var(price) over (partition by cusip
                     order by pricingdate
                     rows between 30 preceding and current row) as var_price
   ,lag(price, 1) over (partition by cusip
                        order by pricingdate) as lag_price
   ,lead(price, 1) over (partition by cusip
                         order by pricingdate) as lead_price
  from dbo.security
  order by pricingdate
;