PREVIEW / stock_5min / 2008-01-08
file: by_date/stock_5min/2008/2008-01-08.parquet size: 4.5 MB rows: 324,840 symbols: 3,264
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-08 04:15:00 | AAPL | Stock | 6.3804 | 6.3804 | 6.3786 | 6.3786 | 5600.0 |
| 2008-01-08 05:15:00 | AAPL | Stock | 6.4054 | 6.4054 | 6.4054 | 6.4054 | 2800.0 |
| 2008-01-08 05:20:00 | AAPL | Stock | 6.3786 | 6.3786 | 6.3786 | 6.3786 | 2800.0 |
| 2008-01-08 05:25:00 | AAPL | Stock | 6.3857 | 6.3857 | 6.3857 | 6.3857 | 2800.0 |
| 2008-01-08 05:30:00 | AAPL | Stock | 6.375 | 6.375 | 6.3714 | 6.3714 | 14000.0 |
| 2008-01-08 05:35:00 | AAPL | Stock | 6.3607 | 6.3607 | 6.3607 | 6.3607 | 2800.0 |
| 2008-01-08 06:55:00 | AAPL | Stock | 6.4054 | 6.4054 | 6.4054 | 6.4054 | 2800.0 |
| 2008-01-08 07:00:00 | AAPL | Stock | 6.3964 | 6.4179 | 6.3932 | 6.4179 | 92400.0 |
| 2008-01-08 07:10:00 | AAPL | Stock | 6.4157 | 6.4157 | 6.4107 | 6.4107 | 123200.0 |
| 2008-01-08 07:15:00 | AAPL | Stock | 6.4139 | 6.4161 | 6.4139 | 6.4161 | 9800.0 |
| 2008-01-08 07:20:00 | AAPL | Stock | 6.4179 | 6.4189 | 6.4179 | 6.4189 | 50400.0 |
| 2008-01-08 07:25:00 | AAPL | Stock | 6.4189 | 6.4286 | 6.4189 | 6.4279 | 116200.0 |
| 2008-01-08 07:30:00 | AAPL | Stock | 6.4464 | 6.4464 | 6.4282 | 6.4282 | 118440.0 |
| 2008-01-08 07:35:00 | AAPL | Stock | 6.4282 | 6.4286 | 6.4282 | 6.4286 | 19600.0 |
| 2008-01-08 07:45:00 | AAPL | Stock | 6.4107 | 6.4196 | 6.4107 | 6.4161 | 42000.0 |
| 2008-01-08 07:50:00 | AAPL | Stock | 6.4132 | 6.4161 | 6.4107 | 6.4143 | 100800.0 |
| 2008-01-08 07:55:00 | AAPL | Stock | 6.4071 | 6.4139 | 6.4068 | 6.4107 | 78400.0 |
| 2008-01-08 08:00:00 | AAPL | Stock | 6.4136 | 6.4282 | 6.3929 | 6.3968 | 1099980.0 |
| 2008-01-08 08:05:00 | AAPL | Stock | 6.3968 | 6.4107 | 6.3936 | 6.4068 | 959084.0 |
| 2008-01-08 08:10:00 | AAPL | Stock | 6.4046 | 6.4057 | 6.3861 | 6.4 | 994196.0 |
| 2008-01-08 08:15:00 | AAPL | Stock | 6.3982 | 6.4032 | 6.3971 | 6.4032 | 506492.0 |
| 2008-01-08 08:20:00 | AAPL | Stock | 6.4046 | 6.4071 | 6.3986 | 6.4036 | 643832.0 |
| 2008-01-08 08:25:00 | AAPL | Stock | 6.4004 | 6.4043 | 6.3989 | 6.4021 | 204260.0 |
| 2008-01-08 08:30:00 | AAPL | Stock | 6.4021 | 6.4146 | 6.4 | 6.4004 | 576464.0 |
| 2008-01-08 08:35:00 | AAPL | Stock | 6.4018 | 6.4036 | 6.3989 | 6.4036 | 372400.0 |
| 2008-01-08 08:40:00 | AAPL | Stock | 6.4061 | 6.415 | 6.4 | 6.4007 | 726488.0 |
| 2008-01-08 08:45:00 | AAPL | Stock | 6.4018 | 6.4079 | 6.4 | 6.4057 | 334040.0 |
| 2008-01-08 08:50:00 | AAPL | Stock | 6.4032 | 6.4114 | 6.4004 | 6.4107 | 227780.0 |
| 2008-01-08 08:55:00 | AAPL | Stock | 6.4107 | 6.4143 | 6.405 | 6.405 | 626724.0 |
| 2008-01-08 09:00:00 | AAPL | Stock | 6.4043 | 6.4089 | 6.3925 | 6.3932 | 640472.0 |
| 2008-01-08 09:05:00 | AAPL | Stock | 6.4 | 6.4214 | 6.3954 | 6.4139 | 524580.0 |
| 2008-01-08 09:10:00 | AAPL | Stock | 6.4175 | 6.4304 | 6.4143 | 6.4221 | 698180.0 |
| 2008-01-08 09:15:00 | AAPL | Stock | 6.4232 | 6.4364 | 6.4107 | 6.425 | 661108.0 |
| 2008-01-08 09:20:00 | AAPL | Stock | 6.4282 | 6.4439 | 6.4282 | 6.4425 | 731108.0 |
| 2008-01-08 09:25:00 | AAPL | Stock | 6.4429 | 6.4482 | 6.4279 | 6.4286 | 1080800.0 |
| 2008-01-08 09:30:00 | AAPL | Stock | 6.4304 | 6.4821 | 6.3614 | 6.4371 | 46233768.0 |
| 2008-01-08 09:35:00 | AAPL | Stock | 6.4364 | 6.4764 | 6.4107 | 6.4268 | 35134652.0 |
| 2008-01-08 09:40:00 | AAPL | Stock | 6.4268 | 6.4618 | 6.4071 | 6.4125 | 26750724.0 |
| 2008-01-08 09:45:00 | AAPL | Stock | 6.4121 | 6.4429 | 6.3939 | 6.4075 | 29831004.0 |
| 2008-01-08 09:50:00 | AAPL | Stock | 6.4075 | 6.4293 | 6.4039 | 6.4114 | 18575872.0 |
| 2008-01-08 09:55:00 | AAPL | Stock | 6.4118 | 6.415 | 6.3857 | 6.4079 | 24794252.0 |
| 2008-01-08 10:00:00 | AAPL | Stock | 6.4086 | 6.4675 | 6.3921 | 6.4661 | 35238056.0 |
| 2008-01-08 10:05:00 | AAPL | Stock | 6.4657 | 6.5039 | 6.4557 | 6.4857 | 34453160.0 |
| 2008-01-08 10:10:00 | AAPL | Stock | 6.4864 | 6.5036 | 6.4682 | 6.4989 | 22723120.0 |
| 2008-01-08 10:15:00 | AAPL | Stock | 6.4989 | 6.5164 | 6.4882 | 6.4964 | 22656844.0 |
| 2008-01-08 10:20:00 | AAPL | Stock | 6.4964 | 6.5018 | 6.4768 | 6.5 | 17840620.0 |
| 2008-01-08 10:25:00 | AAPL | Stock | 6.4986 | 6.5068 | 6.4679 | 6.4789 | 17071880.0 |
| 2008-01-08 10:30:00 | AAPL | Stock | 6.4796 | 6.4961 | 6.4696 | 6.4879 | 14015764.0 |
| 2008-01-08 10:35:00 | AAPL | Stock | 6.4871 | 6.4925 | 6.4682 | 6.4821 | 12470948.0 |
| 2008-01-08 10:40:00 | AAPL | Stock | 6.4821 | 6.485 | 6.4679 | 6.4729 | 13099492.0 |
> showing 50 of 324,840 rows — these rows as CSV