PREVIEW / stock_5min / 2012-11-28
file: by_date/stock_5min/2012/2012-11-28.parquet size: 4.8 MB rows: 322,108 symbols: 3,482
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 |
|---|---|---|---|---|---|---|---|
| 2012-11-28 04:20:00 | AAPL | Stock | 20.8218 | 20.8218 | 20.8218 | 20.8218 | 2800.0 |
| 2012-11-28 04:25:00 | AAPL | Stock | 20.8054 | 20.8054 | 20.8054 | 20.8054 | 2800.0 |
| 2012-11-28 06:15:00 | AAPL | Stock | 20.7946 | 20.7946 | 20.7946 | 20.7946 | 5600.0 |
| 2012-11-28 06:30:00 | AAPL | Stock | 20.7861 | 20.7861 | 20.7857 | 20.7857 | 39508.0 |
| 2012-11-28 06:55:00 | AAPL | Stock | 20.7571 | 20.7571 | 20.7571 | 20.7571 | 2800.0 |
| 2012-11-28 07:00:00 | AAPL | Stock | 20.7529 | 20.7886 | 20.7529 | 20.7836 | 14000.0 |
| 2012-11-28 07:10:00 | AAPL | Stock | 20.7768 | 20.7779 | 20.7536 | 20.7536 | 36120.0 |
| 2012-11-28 07:15:00 | AAPL | Stock | 20.7764 | 20.7857 | 20.7746 | 20.7857 | 119672.0 |
| 2012-11-28 07:20:00 | AAPL | Stock | 20.8054 | 20.8054 | 20.8054 | 20.8054 | 4760.0 |
| 2012-11-28 07:30:00 | AAPL | Stock | 20.7857 | 20.7857 | 20.7857 | 20.7857 | 5600.0 |
| 2012-11-28 07:35:00 | AAPL | Stock | 20.7857 | 20.7857 | 20.7696 | 20.7696 | 33320.0 |
| 2012-11-28 07:40:00 | AAPL | Stock | 20.7643 | 20.7714 | 20.7529 | 20.7589 | 53200.0 |
| 2012-11-28 07:45:00 | AAPL | Stock | 20.7607 | 20.7661 | 20.7396 | 20.7396 | 114800.0 |
| 2012-11-28 07:50:00 | AAPL | Stock | 20.7411 | 20.7411 | 20.7411 | 20.7411 | 20300.0 |
| 2012-11-28 07:55:00 | AAPL | Stock | 20.75 | 20.75 | 20.7464 | 20.7464 | 5600.0 |
| 2012-11-28 08:00:00 | AAPL | Stock | 20.7425 | 20.8036 | 20.7289 | 20.7293 | 295120.0 |
| 2012-11-28 08:05:00 | AAPL | Stock | 20.7261 | 20.7464 | 20.7207 | 20.7411 | 539756.0 |
| 2012-11-28 08:10:00 | AAPL | Stock | 20.7404 | 20.7404 | 20.7186 | 20.7311 | 98784.0 |
| 2012-11-28 08:15:00 | AAPL | Stock | 20.7257 | 20.7318 | 20.6711 | 20.6961 | 415016.0 |
| 2012-11-28 08:20:00 | AAPL | Stock | 20.6904 | 20.6964 | 20.655 | 20.6789 | 302932.0 |
| 2012-11-28 08:25:00 | AAPL | Stock | 20.6836 | 20.7071 | 20.6821 | 20.6996 | 163716.0 |
| 2012-11-28 08:30:00 | AAPL | Stock | 20.7071 | 20.7071 | 20.6789 | 20.6839 | 185752.0 |
| 2012-11-28 08:35:00 | AAPL | Stock | 20.6864 | 20.6925 | 20.6732 | 20.6786 | 249312.0 |
| 2012-11-28 08:40:00 | AAPL | Stock | 20.6786 | 20.6871 | 20.6679 | 20.685 | 348796.0 |
| 2012-11-28 08:45:00 | AAPL | Stock | 20.6768 | 20.6768 | 20.6479 | 20.6554 | 534212.0 |
| 2012-11-28 08:50:00 | AAPL | Stock | 20.6486 | 20.6679 | 20.6371 | 20.6532 | 697564.0 |
| 2012-11-28 08:55:00 | AAPL | Stock | 20.6532 | 20.6532 | 20.6289 | 20.6429 | 397152.0 |
| 2012-11-28 09:00:00 | AAPL | Stock | 20.6429 | 20.6607 | 20.6429 | 20.6429 | 218428.0 |
| 2012-11-28 09:05:00 | AAPL | Stock | 20.6429 | 20.6429 | 20.5964 | 20.62 | 788144.0 |
| 2012-11-28 09:10:00 | AAPL | Stock | 20.6125 | 20.6125 | 20.5893 | 20.6096 | 882588.0 |
| 2012-11-28 09:15:00 | AAPL | Stock | 20.6071 | 20.6096 | 20.5757 | 20.5786 | 707924.0 |
| 2012-11-28 09:20:00 | AAPL | Stock | 20.5836 | 20.5979 | 20.5643 | 20.5714 | 638708.0 |
| 2012-11-28 09:25:00 | AAPL | Stock | 20.5668 | 20.6207 | 20.5621 | 20.6196 | 1779960.0 |
| 2012-11-28 09:30:00 | AAPL | Stock | 20.6196 | 20.6221 | 20.5054 | 20.5644 | 25810288.0 |
| 2012-11-28 09:35:00 | AAPL | Stock | 20.5632 | 20.6279 | 20.5575 | 20.5779 | 16404556.0 |
| 2012-11-28 09:40:00 | AAPL | Stock | 20.58 | 20.6429 | 20.5625 | 20.5954 | 12177984.0 |
| 2012-11-28 09:45:00 | AAPL | Stock | 20.5954 | 20.5954 | 20.5143 | 20.5341 | 13493676.0 |
| 2012-11-28 09:50:00 | AAPL | Stock | 20.5296 | 20.5882 | 20.515 | 20.5879 | 8361332.0 |
| 2012-11-28 09:55:00 | AAPL | Stock | 20.5878 | 20.5929 | 20.5564 | 20.5771 | 5060300.0 |
| 2012-11-28 10:00:00 | AAPL | Stock | 20.5704 | 20.5707 | 20.4557 | 20.4574 | 14036008.0 |
| 2012-11-28 10:05:00 | AAPL | Stock | 20.4568 | 20.51 | 20.4493 | 20.4671 | 10985856.0 |
| 2012-11-28 10:10:00 | AAPL | Stock | 20.4668 | 20.5536 | 20.4379 | 20.5304 | 14540988.0 |
| 2012-11-28 10:15:00 | AAPL | Stock | 20.5304 | 20.5671 | 20.5225 | 20.5379 | 6744500.0 |
| 2012-11-28 10:20:00 | AAPL | Stock | 20.5379 | 20.61 | 20.5279 | 20.5989 | 10225012.0 |
| 2012-11-28 10:25:00 | AAPL | Stock | 20.5964 | 20.6161 | 20.5679 | 20.5904 | 10013052.0 |
| 2012-11-28 10:30:00 | AAPL | Stock | 20.5889 | 20.6118 | 20.5739 | 20.5864 | 4671128.0 |
| 2012-11-28 10:35:00 | AAPL | Stock | 20.5818 | 20.6864 | 20.5564 | 20.6626 | 13674416.0 |
| 2012-11-28 10:40:00 | AAPL | Stock | 20.6596 | 20.7036 | 20.6389 | 20.6418 | 9495948.0 |
| 2012-11-28 10:45:00 | AAPL | Stock | 20.6431 | 20.6764 | 20.6182 | 20.6516 | 6934256.0 |
| 2012-11-28 10:50:00 | AAPL | Stock | 20.6553 | 20.6561 | 20.5811 | 20.5925 | 7319732.0 |
> showing 50 of 322,108 rows — these rows as CSV