PREVIEW / stock_5min / 2007-01-12
file: by_date/stock_5min/2007/2007-01-12.parquet size: 3.3 MB rows: 238,770 symbols: 2,495
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2007-01-12 04:20:00 | AAPL | Stock | 3.4171 | 3.4171 | 3.4171 | 3.4171 | 14000.0 |
| 2007-01-12 04:50:00 | AAPL | Stock | 3.4168 | 3.4168 | 3.4161 | 3.4161 | 28000.0 |
| 2007-01-12 04:55:00 | AAPL | Stock | 3.4168 | 3.4171 | 3.4168 | 3.4171 | 19600.0 |
| 2007-01-12 05:20:00 | AAPL | Stock | 3.4214 | 3.4214 | 3.4214 | 3.4214 | 8400.0 |
| 2007-01-12 05:35:00 | AAPL | Stock | 3.4196 | 3.4196 | 3.4182 | 3.4182 | 70000.0 |
| 2007-01-12 05:40:00 | AAPL | Stock | 3.4182 | 3.4182 | 3.4182 | 3.4182 | 5600.0 |
| 2007-01-12 05:45:00 | AAPL | Stock | 3.4107 | 3.4107 | 3.4107 | 3.4107 | 36400.0 |
| 2007-01-12 05:50:00 | AAPL | Stock | 3.4107 | 3.4107 | 3.4107 | 3.4107 | 19600.0 |
| 2007-01-12 05:55:00 | AAPL | Stock | 3.4107 | 3.4111 | 3.4071 | 3.4111 | 201628.0 |
| 2007-01-12 06:00:00 | AAPL | Stock | 3.4111 | 3.4111 | 3.4111 | 3.4111 | 112000.0 |
| 2007-01-12 06:10:00 | AAPL | Stock | 3.4193 | 3.4193 | 3.4193 | 3.4193 | 5600.0 |
| 2007-01-12 06:15:00 | AAPL | Stock | 3.4093 | 3.4093 | 3.4046 | 3.4046 | 78400.0 |
| 2007-01-12 06:20:00 | AAPL | Stock | 3.4036 | 3.4036 | 3.4036 | 3.4036 | 2800.0 |
| 2007-01-12 06:50:00 | AAPL | Stock | 3.4143 | 3.4175 | 3.4143 | 3.4175 | 28000.0 |
| 2007-01-12 06:55:00 | AAPL | Stock | 3.4029 | 3.4029 | 3.4018 | 3.4025 | 28000.0 |
| 2007-01-12 07:00:00 | AAPL | Stock | 3.4021 | 3.4036 | 3.4021 | 3.4036 | 43960.0 |
| 2007-01-12 07:05:00 | AAPL | Stock | 3.4036 | 3.4036 | 3.3936 | 3.3939 | 81200.0 |
| 2007-01-12 07:15:00 | AAPL | Stock | 3.3964 | 3.4 | 3.3964 | 3.3964 | 72800.0 |
| 2007-01-12 07:20:00 | AAPL | Stock | 3.3975 | 3.3975 | 3.3968 | 3.3968 | 28000.0 |
| 2007-01-12 07:25:00 | AAPL | Stock | 3.3996 | 3.3996 | 3.3964 | 3.3964 | 30800.0 |
| 2007-01-12 07:30:00 | AAPL | Stock | 3.3968 | 3.3968 | 3.3929 | 3.3946 | 461720.0 |
| 2007-01-12 07:35:00 | AAPL | Stock | 3.3946 | 3.3946 | 3.3857 | 3.3857 | 271880.0 |
| 2007-01-12 07:40:00 | AAPL | Stock | 3.3886 | 3.3886 | 3.3857 | 3.3857 | 9324.0 |
| 2007-01-12 07:45:00 | AAPL | Stock | 3.3889 | 3.3929 | 3.3889 | 3.3929 | 479696.0 |
| 2007-01-12 07:50:00 | AAPL | Stock | 3.3929 | 3.3929 | 3.3821 | 3.385 | 648144.0 |
| 2007-01-12 07:55:00 | AAPL | Stock | 3.3836 | 3.3989 | 3.38 | 3.3989 | 727160.0 |
| 2007-01-12 08:00:00 | AAPL | Stock | 3.3946 | 3.3946 | 3.375 | 3.3775 | 2737308.0 |
| 2007-01-12 08:05:00 | AAPL | Stock | 3.3775 | 3.3804 | 3.3746 | 3.3768 | 1372616.0 |
| 2007-01-12 08:10:00 | AAPL | Stock | 3.3775 | 3.3786 | 3.375 | 3.3771 | 484540.0 |
| 2007-01-12 08:15:00 | AAPL | Stock | 3.3771 | 3.3771 | 3.3679 | 3.3739 | 1330952.0 |
| 2007-01-12 08:20:00 | AAPL | Stock | 3.3754 | 3.3779 | 3.375 | 3.3754 | 391468.0 |
| 2007-01-12 08:25:00 | AAPL | Stock | 3.3768 | 3.3821 | 3.3764 | 3.3818 | 695996.0 |
| 2007-01-12 08:30:00 | AAPL | Stock | 3.3821 | 3.3904 | 3.3821 | 3.3889 | 1331764.0 |
| 2007-01-12 08:35:00 | AAPL | Stock | 3.3889 | 3.3929 | 3.3864 | 3.3893 | 1244488.0 |
| 2007-01-12 08:40:00 | AAPL | Stock | 3.3896 | 3.3925 | 3.3882 | 3.3882 | 2120636.0 |
| 2007-01-12 08:45:00 | AAPL | Stock | 3.3875 | 3.3893 | 3.3857 | 3.3893 | 1601880.0 |
| 2007-01-12 08:50:00 | AAPL | Stock | 3.3893 | 3.39 | 3.3879 | 3.3882 | 258160.0 |
| 2007-01-12 08:55:00 | AAPL | Stock | 3.3886 | 3.3886 | 3.3854 | 3.3857 | 575512.0 |
| 2007-01-12 09:00:00 | AAPL | Stock | 3.3861 | 3.3914 | 3.3857 | 3.3904 | 600012.0 |
| 2007-01-12 09:05:00 | AAPL | Stock | 3.3904 | 3.3907 | 3.3861 | 3.3864 | 752220.0 |
| 2007-01-12 09:10:00 | AAPL | Stock | 3.3857 | 3.3886 | 3.3839 | 3.3839 | 929404.0 |
| 2007-01-12 09:15:00 | AAPL | Stock | 3.3839 | 3.3886 | 3.3832 | 3.3879 | 885864.0 |
| 2007-01-12 09:20:00 | AAPL | Stock | 3.3879 | 3.3879 | 3.3825 | 3.3825 | 639968.0 |
| 2007-01-12 09:25:00 | AAPL | Stock | 3.3832 | 3.3832 | 3.3757 | 3.3779 | 3162040.0 |
| 2007-01-12 09:30:00 | AAPL | Stock | 3.3782 | 3.3786 | 3.3486 | 3.3611 | 92893080.0 |
| 2007-01-12 09:35:00 | AAPL | Stock | 3.3614 | 3.3736 | 3.3554 | 3.3578 | 50057280.0 |
| 2007-01-12 09:40:00 | AAPL | Stock | 3.3579 | 3.365 | 3.3518 | 3.3575 | 39906552.0 |
| 2007-01-12 09:45:00 | AAPL | Stock | 3.3575 | 3.3611 | 3.3468 | 3.3593 | 42227360.0 |
| 2007-01-12 09:50:00 | AAPL | Stock | 3.3596 | 3.3607 | 3.3482 | 3.3582 | 34854820.0 |
| 2007-01-12 09:55:00 | AAPL | Stock | 3.3582 | 3.3714 | 3.3543 | 3.3693 | 31339532.0 |
> showing 50 of 238,770 rows — these rows as CSV