PREVIEW / stock_5min / 2007-10-04
file: by_date/stock_5min/2007/2007-10-04.parquet size: 4.1 MB rows: 302,871 symbols: 3,128
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-10-04 05:30:00 | AAPL | Stock | 5.6425 | 5.6425 | 5.6425 | 5.6425 | 5600.0 |
| 2007-10-04 05:50:00 | AAPL | Stock | 5.6464 | 5.6464 | 5.645 | 5.645 | 8400.0 |
| 2007-10-04 05:55:00 | AAPL | Stock | 5.6429 | 5.6429 | 5.6429 | 5.6429 | 14000.0 |
| 2007-10-04 06:05:00 | AAPL | Stock | 5.6429 | 5.6429 | 5.6429 | 5.6429 | 10360.0 |
| 2007-10-04 06:30:00 | AAPL | Stock | 5.6429 | 5.6429 | 5.6429 | 5.6429 | 11200.0 |
| 2007-10-04 06:40:00 | AAPL | Stock | 5.6429 | 5.6429 | 5.6429 | 5.6429 | 14000.0 |
| 2007-10-04 07:00:00 | AAPL | Stock | 5.6489 | 5.6504 | 5.6486 | 5.6504 | 58800.0 |
| 2007-10-04 07:10:00 | AAPL | Stock | 5.6446 | 5.6446 | 5.6446 | 5.6446 | 2800.0 |
| 2007-10-04 07:20:00 | AAPL | Stock | 5.6475 | 5.6475 | 5.6446 | 5.6446 | 56000.0 |
| 2007-10-04 07:30:00 | AAPL | Stock | 5.6429 | 5.6429 | 5.6429 | 5.6429 | 35952.0 |
| 2007-10-04 07:35:00 | AAPL | Stock | 5.6361 | 5.6375 | 5.6361 | 5.6375 | 5600.0 |
| 2007-10-04 07:45:00 | AAPL | Stock | 5.6446 | 5.6446 | 5.6446 | 5.6446 | 5600.0 |
| 2007-10-04 07:50:00 | AAPL | Stock | 5.6446 | 5.6446 | 5.6446 | 5.6446 | 2800.0 |
| 2007-10-04 07:55:00 | AAPL | Stock | 5.6446 | 5.6446 | 5.6446 | 5.6446 | 78400.0 |
| 2007-10-04 08:00:00 | AAPL | Stock | 5.6429 | 5.6554 | 5.6343 | 5.6518 | 490560.0 |
| 2007-10-04 08:05:00 | AAPL | Stock | 5.65 | 5.6518 | 5.6432 | 5.6446 | 447636.0 |
| 2007-10-04 08:10:00 | AAPL | Stock | 5.6432 | 5.6493 | 5.6389 | 5.6411 | 671132.0 |
| 2007-10-04 08:15:00 | AAPL | Stock | 5.6418 | 5.6425 | 5.6393 | 5.6425 | 242704.0 |
| 2007-10-04 08:20:00 | AAPL | Stock | 5.6464 | 5.6518 | 5.6464 | 5.65 | 252700.0 |
| 2007-10-04 08:25:00 | AAPL | Stock | 5.6504 | 5.6504 | 5.6357 | 5.6357 | 709240.0 |
| 2007-10-04 08:30:00 | AAPL | Stock | 5.6354 | 5.6464 | 5.6339 | 5.6429 | 393204.0 |
| 2007-10-04 08:35:00 | AAPL | Stock | 5.6425 | 5.6425 | 5.6361 | 5.6371 | 52080.0 |
| 2007-10-04 08:40:00 | AAPL | Stock | 5.6375 | 5.6425 | 5.6375 | 5.6382 | 81872.0 |
| 2007-10-04 08:45:00 | AAPL | Stock | 5.6414 | 5.645 | 5.6393 | 5.6393 | 154224.0 |
| 2007-10-04 08:50:00 | AAPL | Stock | 5.6393 | 5.6411 | 5.6386 | 5.6411 | 82236.0 |
| 2007-10-04 08:55:00 | AAPL | Stock | 5.6407 | 5.6479 | 5.6404 | 5.6479 | 83300.0 |
| 2007-10-04 09:00:00 | AAPL | Stock | 5.6475 | 5.6539 | 5.6475 | 5.6518 | 311444.0 |
| 2007-10-04 09:05:00 | AAPL | Stock | 5.6518 | 5.6521 | 5.6486 | 5.6489 | 85904.0 |
| 2007-10-04 09:10:00 | AAPL | Stock | 5.65 | 5.6511 | 5.65 | 5.65 | 171920.0 |
| 2007-10-04 09:15:00 | AAPL | Stock | 5.6507 | 5.6507 | 5.6371 | 5.6439 | 116200.0 |
| 2007-10-04 09:20:00 | AAPL | Stock | 5.6436 | 5.645 | 5.6436 | 5.645 | 36400.0 |
| 2007-10-04 09:25:00 | AAPL | Stock | 5.6461 | 5.6464 | 5.6371 | 5.6429 | 442400.0 |
| 2007-10-04 09:30:00 | AAPL | Stock | 5.6429 | 5.6457 | 5.5875 | 5.6086 | 29731492.0 |
| 2007-10-04 09:35:00 | AAPL | Stock | 5.6091 | 5.6171 | 5.5887 | 5.6007 | 15068396.0 |
| 2007-10-04 09:40:00 | AAPL | Stock | 5.6018 | 5.6061 | 5.5789 | 5.5879 | 15851024.0 |
| 2007-10-04 09:45:00 | AAPL | Stock | 5.5889 | 5.6 | 5.575 | 5.5807 | 21394856.0 |
| 2007-10-04 09:50:00 | AAPL | Stock | 5.5811 | 5.5829 | 5.5357 | 5.5357 | 35610624.0 |
| 2007-10-04 09:55:00 | AAPL | Stock | 5.5357 | 5.5471 | 5.4821 | 5.5454 | 55741140.0 |
| 2007-10-04 10:00:00 | AAPL | Stock | 5.5457 | 5.5518 | 5.5243 | 5.5432 | 16933560.0 |
| 2007-10-04 10:05:00 | AAPL | Stock | 5.5439 | 5.5536 | 5.5411 | 5.5489 | 14385700.0 |
| 2007-10-04 10:10:00 | AAPL | Stock | 5.5489 | 5.5593 | 5.5268 | 5.537 | 17501876.0 |
| 2007-10-04 10:15:00 | AAPL | Stock | 5.5375 | 5.5557 | 5.5325 | 5.5396 | 13767488.0 |
| 2007-10-04 10:20:00 | AAPL | Stock | 5.5382 | 5.5604 | 5.5382 | 5.5532 | 10086888.0 |
| 2007-10-04 10:25:00 | AAPL | Stock | 5.5536 | 5.5561 | 5.5414 | 5.5414 | 8403276.0 |
| 2007-10-04 10:30:00 | AAPL | Stock | 5.5414 | 5.5532 | 5.5389 | 5.5486 | 8194872.0 |
| 2007-10-04 10:35:00 | AAPL | Stock | 5.5486 | 5.5521 | 5.5389 | 5.5479 | 8557304.0 |
| 2007-10-04 10:40:00 | AAPL | Stock | 5.5477 | 5.5686 | 5.5429 | 5.5643 | 11970644.0 |
| 2007-10-04 10:45:00 | AAPL | Stock | 5.5643 | 5.5775 | 5.5625 | 5.5768 | 13404132.0 |
| 2007-10-04 10:50:00 | AAPL | Stock | 5.5768 | 5.5929 | 5.5764 | 5.5893 | 11087552.0 |
| 2007-10-04 10:55:00 | AAPL | Stock | 5.5904 | 5.5946 | 5.58 | 5.5879 | 11990748.0 |
> showing 50 of 302,871 rows — these rows as CSV