PREVIEW / stock_5min / 2013-03-01
file: by_date/stock_5min/2013/2013-03-01.parquet size: 5.0 MB rows: 331,017 symbols: 3,460
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 |
|---|---|---|---|---|---|---|---|
| 2013-03-01 04:35:00 | AAPL | Stock | 15.8371 | 15.8371 | 15.8371 | 15.8371 | 2800.0 |
| 2013-03-01 05:10:00 | AAPL | Stock | 15.7911 | 15.7911 | 15.7911 | 15.7911 | 5600.0 |
| 2013-03-01 05:45:00 | AAPL | Stock | 15.7589 | 15.7589 | 15.7589 | 15.7589 | 5600.0 |
| 2013-03-01 06:30:00 | AAPL | Stock | 15.7232 | 15.7232 | 15.7143 | 15.7143 | 18676.0 |
| 2013-03-01 07:10:00 | AAPL | Stock | 15.7143 | 15.7179 | 15.7139 | 15.7139 | 38920.0 |
| 2013-03-01 07:20:00 | AAPL | Stock | 15.6914 | 15.6914 | 15.6914 | 15.6914 | 2800.0 |
| 2013-03-01 07:35:00 | AAPL | Stock | 15.6961 | 15.6964 | 15.6961 | 15.6964 | 14000.0 |
| 2013-03-01 07:40:00 | AAPL | Stock | 15.6964 | 15.6979 | 15.6964 | 15.6964 | 81200.0 |
| 2013-03-01 07:45:00 | AAPL | Stock | 15.6964 | 15.7071 | 15.6936 | 15.6957 | 38052.0 |
| 2013-03-01 07:50:00 | AAPL | Stock | 15.6832 | 15.6832 | 15.6832 | 15.6832 | 2800.0 |
| 2013-03-01 07:55:00 | AAPL | Stock | 15.6821 | 15.6821 | 15.6554 | 15.6554 | 33600.0 |
| 2013-03-01 08:00:00 | AAPL | Stock | 15.6675 | 15.7143 | 15.6607 | 15.6661 | 204232.0 |
| 2013-03-01 08:05:00 | AAPL | Stock | 15.6661 | 15.6661 | 15.6354 | 15.6586 | 279692.0 |
| 2013-03-01 08:10:00 | AAPL | Stock | 15.6514 | 15.6554 | 15.625 | 15.635 | 314272.0 |
| 2013-03-01 08:15:00 | AAPL | Stock | 15.635 | 15.7679 | 15.6321 | 15.6518 | 232288.0 |
| 2013-03-01 08:20:00 | AAPL | Stock | 15.6518 | 15.7679 | 15.6361 | 15.6411 | 340452.0 |
| 2013-03-01 08:25:00 | AAPL | Stock | 15.6375 | 15.6396 | 15.6321 | 15.6393 | 338184.0 |
| 2013-03-01 08:30:00 | AAPL | Stock | 15.6375 | 15.6414 | 15.6314 | 15.6357 | 189140.0 |
| 2013-03-01 08:35:00 | AAPL | Stock | 15.6357 | 15.6557 | 15.6357 | 15.6439 | 316568.0 |
| 2013-03-01 08:40:00 | AAPL | Stock | 15.6439 | 15.6707 | 15.6439 | 15.665 | 168140.0 |
| 2013-03-01 08:45:00 | AAPL | Stock | 15.6707 | 15.6739 | 15.6361 | 15.6393 | 819980.0 |
| 2013-03-01 08:50:00 | AAPL | Stock | 15.6429 | 15.6429 | 15.6175 | 15.625 | 723268.0 |
| 2013-03-01 08:55:00 | AAPL | Stock | 15.625 | 15.6504 | 15.6211 | 15.6321 | 360696.0 |
| 2013-03-01 09:00:00 | AAPL | Stock | 15.6329 | 15.6514 | 15.6329 | 15.6357 | 267372.0 |
| 2013-03-01 09:05:00 | AAPL | Stock | 15.6393 | 15.6429 | 15.6321 | 15.6425 | 287140.0 |
| 2013-03-01 09:10:00 | AAPL | Stock | 15.6425 | 15.6429 | 15.6339 | 15.6389 | 235396.0 |
| 2013-03-01 09:15:00 | AAPL | Stock | 15.6414 | 15.6518 | 15.6304 | 15.6507 | 405972.0 |
| 2013-03-01 09:20:00 | AAPL | Stock | 15.6543 | 15.6554 | 15.6429 | 15.6429 | 69664.0 |
| 2013-03-01 09:25:00 | AAPL | Stock | 15.6429 | 15.6521 | 15.6429 | 15.6439 | 629832.0 |
| 2013-03-01 09:30:00 | AAPL | Stock | 15.6432 | 15.6493 | 15.55 | 15.5657 | 30873556.0 |
| 2013-03-01 09:35:00 | AAPL | Stock | 15.5629 | 15.5714 | 15.4821 | 15.4857 | 27044976.0 |
| 2013-03-01 09:40:00 | AAPL | Stock | 15.4836 | 15.5089 | 15.4446 | 15.4914 | 21984200.0 |
| 2013-03-01 09:45:00 | AAPL | Stock | 15.4929 | 15.5232 | 15.4843 | 15.5 | 12512472.0 |
| 2013-03-01 09:50:00 | AAPL | Stock | 15.5043 | 15.5261 | 15.4861 | 15.5082 | 11680256.0 |
| 2013-03-01 09:55:00 | AAPL | Stock | 15.5079 | 15.5177 | 15.4725 | 15.4932 | 9935604.0 |
| 2013-03-01 10:00:00 | AAPL | Stock | 15.4929 | 15.5214 | 15.4871 | 15.505 | 9036832.0 |
| 2013-03-01 10:05:00 | AAPL | Stock | 15.5091 | 15.55 | 15.4929 | 15.5371 | 11187008.0 |
| 2013-03-01 10:10:00 | AAPL | Stock | 15.5368 | 15.5596 | 15.5144 | 15.5252 | 8368976.0 |
| 2013-03-01 10:15:00 | AAPL | Stock | 15.5247 | 15.5271 | 15.4668 | 15.4668 | 9876160.0 |
| 2013-03-01 10:20:00 | AAPL | Stock | 15.4707 | 15.4889 | 15.4554 | 15.4561 | 9548140.0 |
| 2013-03-01 10:25:00 | AAPL | Stock | 15.4571 | 15.4839 | 15.4243 | 15.4339 | 14294140.0 |
| 2013-03-01 10:30:00 | AAPL | Stock | 15.4346 | 15.4821 | 15.4321 | 15.4593 | 9347548.0 |
| 2013-03-01 10:35:00 | AAPL | Stock | 15.4596 | 15.4714 | 15.45 | 15.4671 | 5801992.0 |
| 2013-03-01 10:40:00 | AAPL | Stock | 15.4646 | 15.5264 | 15.4571 | 15.5043 | 9022048.0 |
| 2013-03-01 10:45:00 | AAPL | Stock | 15.5039 | 15.5268 | 15.4843 | 15.4893 | 4770416.0 |
| 2013-03-01 10:50:00 | AAPL | Stock | 15.4857 | 15.5354 | 15.4821 | 15.5246 | 6119036.0 |
| 2013-03-01 10:55:00 | AAPL | Stock | 15.5246 | 15.5308 | 15.5057 | 15.5271 | 4829384.0 |
| 2013-03-01 11:00:00 | AAPL | Stock | 15.5311 | 15.597 | 15.5257 | 15.5471 | 11656344.0 |
| 2013-03-01 11:05:00 | AAPL | Stock | 15.5464 | 15.5546 | 15.5068 | 15.5071 | 5911808.0 |
| 2013-03-01 11:10:00 | AAPL | Stock | 15.5104 | 15.5171 | 15.4946 | 15.4957 | 4546472.0 |
> showing 50 of 331,017 rows — these rows as CSV