PREVIEW / stock_5min / 2011-11-30
file: by_date/stock_5min/2011/2011-11-30.parquet size: 5.1 MB rows: 349,348 symbols: 3,566
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-30 05:35:00 | AAPL | Stock | 13.2875 | 13.2875 | 13.2875 | 13.2875 | 5600.0 |
| 2011-11-30 06:00:00 | AAPL | Stock | 13.2993 | 13.2993 | 13.2993 | 13.2993 | 5600.0 |
| 2011-11-30 06:10:00 | AAPL | Stock | 13.3729 | 13.3729 | 13.3661 | 13.3661 | 8400.0 |
| 2011-11-30 06:40:00 | AAPL | Stock | 13.4625 | 13.4625 | 13.4625 | 13.4625 | 2800.0 |
| 2011-11-30 07:00:00 | AAPL | Stock | 13.42 | 13.42 | 13.42 | 13.42 | 2800.0 |
| 2011-11-30 07:05:00 | AAPL | Stock | 13.4082 | 13.4196 | 13.4082 | 13.4107 | 44380.0 |
| 2011-11-30 07:10:00 | AAPL | Stock | 13.4079 | 13.4379 | 13.4079 | 13.4379 | 34720.0 |
| 2011-11-30 07:15:00 | AAPL | Stock | 13.4107 | 13.4107 | 13.4107 | 13.4107 | 6300.0 |
| 2011-11-30 07:20:00 | AAPL | Stock | 13.4071 | 13.4071 | 13.3993 | 13.3993 | 60200.0 |
| 2011-11-30 07:25:00 | AAPL | Stock | 13.3929 | 13.3929 | 13.3929 | 13.3929 | 2800.0 |
| 2011-11-30 07:30:00 | AAPL | Stock | 13.3971 | 13.3971 | 13.3929 | 13.3929 | 5600.0 |
| 2011-11-30 07:40:00 | AAPL | Stock | 13.3821 | 13.3821 | 13.3821 | 13.3821 | 2800.0 |
| 2011-11-30 07:45:00 | AAPL | Stock | 13.3929 | 13.4021 | 13.3929 | 13.3929 | 42000.0 |
| 2011-11-30 07:50:00 | AAPL | Stock | 13.3961 | 13.3982 | 13.3961 | 13.3982 | 36400.0 |
| 2011-11-30 08:00:00 | AAPL | Stock | 13.3961 | 13.5429 | 13.3839 | 13.5429 | 1129744.0 |
| 2011-11-30 08:05:00 | AAPL | Stock | 13.5361 | 13.5625 | 13.5182 | 13.5318 | 775992.0 |
| 2011-11-30 08:10:00 | AAPL | Stock | 13.5196 | 13.5479 | 13.5179 | 13.5454 | 625072.0 |
| 2011-11-30 08:15:00 | AAPL | Stock | 13.545 | 13.5964 | 13.545 | 13.5714 | 930188.0 |
| 2011-11-30 08:20:00 | AAPL | Stock | 13.58 | 13.58 | 13.5371 | 13.55 | 475216.0 |
| 2011-11-30 08:25:00 | AAPL | Stock | 13.5536 | 13.565 | 13.5446 | 13.5643 | 190260.0 |
| 2011-11-30 08:30:00 | AAPL | Stock | 13.5675 | 13.6168 | 13.5643 | 13.5986 | 901544.0 |
| 2011-11-30 08:35:00 | AAPL | Stock | 13.5993 | 13.6154 | 13.5804 | 13.6154 | 777056.0 |
| 2011-11-30 08:40:00 | AAPL | Stock | 13.6104 | 13.6311 | 13.6089 | 13.6214 | 1060864.0 |
| 2011-11-30 08:45:00 | AAPL | Stock | 13.6207 | 13.6343 | 13.6107 | 13.6343 | 974428.0 |
| 2011-11-30 08:50:00 | AAPL | Stock | 13.6286 | 13.6375 | 13.6261 | 13.6293 | 442568.0 |
| 2011-11-30 08:55:00 | AAPL | Stock | 13.6336 | 13.635 | 13.5904 | 13.6075 | 1239140.0 |
| 2011-11-30 09:00:00 | AAPL | Stock | 13.615 | 13.635 | 13.6096 | 13.6107 | 532000.0 |
| 2011-11-30 09:05:00 | AAPL | Stock | 13.6164 | 13.6164 | 13.6004 | 13.6064 | 321748.0 |
| 2011-11-30 09:10:00 | AAPL | Stock | 13.6054 | 13.6143 | 13.5954 | 13.5982 | 105840.0 |
| 2011-11-30 09:15:00 | AAPL | Stock | 13.5971 | 13.6054 | 13.5946 | 13.6054 | 107212.0 |
| 2011-11-30 09:20:00 | AAPL | Stock | 13.6064 | 13.6221 | 13.6064 | 13.6211 | 170016.0 |
| 2011-11-30 09:25:00 | AAPL | Stock | 13.6164 | 13.6225 | 13.6039 | 13.6175 | 1870176.0 |
| 2011-11-30 09:30:00 | AAPL | Stock | 13.6171 | 13.6293 | 13.5364 | 13.5537 | 21306040.0 |
| 2011-11-30 09:35:00 | AAPL | Stock | 13.5561 | 13.5882 | 13.5482 | 13.5711 | 9848972.0 |
| 2011-11-30 09:40:00 | AAPL | Stock | 13.5736 | 13.5843 | 13.5279 | 13.575 | 12577488.0 |
| 2011-11-30 09:45:00 | AAPL | Stock | 13.5725 | 13.5886 | 13.53 | 13.5654 | 11103848.0 |
| 2011-11-30 09:50:00 | AAPL | Stock | 13.5657 | 13.5779 | 13.5371 | 13.5536 | 5870816.0 |
| 2011-11-30 09:55:00 | AAPL | Stock | 13.5604 | 13.5743 | 13.5429 | 13.5607 | 4954936.0 |
| 2011-11-30 10:00:00 | AAPL | Stock | 13.5625 | 13.575 | 13.5524 | 13.5632 | 5692064.0 |
| 2011-11-30 10:05:00 | AAPL | Stock | 13.5629 | 13.5671 | 13.5107 | 13.5204 | 9322796.0 |
| 2011-11-30 10:10:00 | AAPL | Stock | 13.5211 | 13.5411 | 13.5143 | 13.5343 | 8114988.0 |
| 2011-11-30 10:15:00 | AAPL | Stock | 13.5339 | 13.5518 | 13.5289 | 13.5468 | 4762044.0 |
| 2011-11-30 10:20:00 | AAPL | Stock | 13.5473 | 13.5814 | 13.5446 | 13.5754 | 6216560.0 |
| 2011-11-30 10:25:00 | AAPL | Stock | 13.5757 | 13.5893 | 13.5675 | 13.5843 | 6347152.0 |
| 2011-11-30 10:30:00 | AAPL | Stock | 13.5843 | 13.5979 | 13.5704 | 13.5782 | 5151356.0 |
| 2011-11-30 10:35:00 | AAPL | Stock | 13.5779 | 13.6071 | 13.5779 | 13.6071 | 5730368.0 |
| 2011-11-30 10:40:00 | AAPL | Stock | 13.6071 | 13.6161 | 13.5982 | 13.6082 | 5845616.0 |
| 2011-11-30 10:45:00 | AAPL | Stock | 13.6086 | 13.6125 | 13.5818 | 13.5946 | 6983788.0 |
| 2011-11-30 10:50:00 | AAPL | Stock | 13.595 | 13.6021 | 13.5829 | 13.5993 | 3430280.0 |
| 2011-11-30 10:55:00 | AAPL | Stock | 13.5968 | 13.6061 | 13.5875 | 13.6007 | 3932292.0 |
> showing 50 of 349,348 rows — these rows as CSV