WEBVTT

00:00.700 --> 00:06.700
And the last video we have seen that we can down sample and aggregate our data with the ACT method and

00:06.850 --> 00:12.730
we can actually get open high low and close prices in one line of code by using the ACT method.

00:12.730 --> 00:15.750
However there's also a special method for this.

00:15.880 --> 00:21.660
The surprise open high low close method or short o h let's c.

00:21.820 --> 00:27.710
So first of all we import pandas and again we are working with the stocks data set.

00:27.730 --> 00:30.260
So here we have the first five rows.

00:30.280 --> 00:31.540
Again we have fed daily data.

00:31.540 --> 00:38.170
And let's assume that you want to down sample the data to NGL frequency and we want to have the annual

00:38.170 --> 00:41.290
open high low and close prices.

00:41.290 --> 00:47.910
Then we can do this same with the reasonable method and passing a to the rule parameter.

00:47.940 --> 00:51.580
And as a matter of taste are superior to the kind parameter.

00:51.880 --> 00:53.780
And then we change here.

00:53.800 --> 01:00.240
The open high low close method and this looks actually pretty familiar.

01:00.450 --> 01:06.150
So we have a multi and next service on the order and next level the stock takes us.

01:06.390 --> 01:12.660
And for each and every stock we have open high low close prices so that was the video on the open high

01:12.660 --> 01:16.470
low close method and see us on the next video by.