PREVIEW / stock_5min / 2007-10-30
file: by_date/stock_5min/2007/2007-10-30.parquet size: 4.2 MB rows: 309,306 symbols: 3,160
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-30 05:45:00 | AAPL | Stock | 6.6104 | 6.6104 | 6.6104 | 6.6104 | 8400.0 |
| 2007-10-30 05:55:00 | AAPL | Stock | 6.605 | 6.605 | 6.595 | 6.595 | 14000.0 |
| 2007-10-30 07:10:00 | AAPL | Stock | 6.5775 | 6.5775 | 6.5775 | 6.5775 | 14000.0 |
| 2007-10-30 07:25:00 | AAPL | Stock | 6.5796 | 6.5946 | 6.5725 | 6.575 | 103880.0 |
| 2007-10-30 07:30:00 | AAPL | Stock | 6.5754 | 6.5754 | 6.5714 | 6.5714 | 46200.0 |
| 2007-10-30 07:35:00 | AAPL | Stock | 6.5714 | 6.5714 | 6.5714 | 6.5714 | 42000.0 |
| 2007-10-30 07:40:00 | AAPL | Stock | 6.5714 | 6.5846 | 6.5607 | 6.5625 | 127792.0 |
| 2007-10-30 07:45:00 | AAPL | Stock | 6.5668 | 6.5714 | 6.5668 | 6.5714 | 6608.0 |
| 2007-10-30 07:50:00 | AAPL | Stock | 6.5707 | 6.5761 | 6.5707 | 6.5761 | 21000.0 |
| 2007-10-30 07:55:00 | AAPL | Stock | 6.5579 | 6.5625 | 6.5579 | 6.5625 | 5600.0 |
| 2007-10-30 08:00:00 | AAPL | Stock | 6.5696 | 6.5804 | 6.5696 | 6.5786 | 360640.0 |
| 2007-10-30 08:05:00 | AAPL | Stock | 6.5786 | 6.5864 | 6.5739 | 6.5811 | 142184.0 |
| 2007-10-30 08:10:00 | AAPL | Stock | 6.5821 | 6.5879 | 6.5786 | 6.5818 | 289492.0 |
| 2007-10-30 08:15:00 | AAPL | Stock | 6.5821 | 6.5857 | 6.5821 | 6.5825 | 30800.0 |
| 2007-10-30 08:20:00 | AAPL | Stock | 6.5825 | 6.5839 | 6.5821 | 6.5821 | 29260.0 |
| 2007-10-30 08:25:00 | AAPL | Stock | 6.5836 | 6.5857 | 6.5836 | 6.5857 | 23576.0 |
| 2007-10-30 08:30:00 | AAPL | Stock | 6.585 | 6.585 | 6.5839 | 6.5839 | 28000.0 |
| 2007-10-30 08:35:00 | AAPL | Stock | 6.5839 | 6.6446 | 6.5839 | 6.6436 | 5219956.0 |
| 2007-10-30 08:40:00 | AAPL | Stock | 6.6439 | 6.6989 | 6.6436 | 6.6961 | 6767908.0 |
| 2007-10-30 08:45:00 | AAPL | Stock | 6.6961 | 6.7036 | 6.6693 | 6.6782 | 3783136.0 |
| 2007-10-30 08:50:00 | AAPL | Stock | 6.6786 | 6.6829 | 6.6607 | 6.6664 | 2088268.0 |
| 2007-10-30 08:55:00 | AAPL | Stock | 6.67 | 6.6732 | 6.6429 | 6.6486 | 2577148.0 |
| 2007-10-30 09:00:00 | AAPL | Stock | 6.6482 | 6.6696 | 6.6482 | 6.6607 | 1423716.0 |
| 2007-10-30 09:05:00 | AAPL | Stock | 6.66 | 6.6696 | 6.6518 | 6.6654 | 1414532.0 |
| 2007-10-30 09:10:00 | AAPL | Stock | 6.6654 | 6.6654 | 6.6561 | 6.6561 | 637644.0 |
| 2007-10-30 09:15:00 | AAPL | Stock | 6.6582 | 6.6661 | 6.6479 | 6.655 | 374080.0 |
| 2007-10-30 09:20:00 | AAPL | Stock | 6.6539 | 6.6568 | 6.65 | 6.6532 | 170800.0 |
| 2007-10-30 09:25:00 | AAPL | Stock | 6.6571 | 6.6571 | 6.6411 | 6.6496 | 1807064.0 |
| 2007-10-30 09:30:00 | AAPL | Stock | 6.6511 | 6.6521 | 6.6307 | 6.6422 | 26692736.0 |
| 2007-10-30 09:35:00 | AAPL | Stock | 6.6429 | 6.6607 | 6.6289 | 6.6446 | 23380308.0 |
| 2007-10-30 09:40:00 | AAPL | Stock | 6.6454 | 6.6528 | 6.6339 | 6.64 | 14495908.0 |
| 2007-10-30 09:45:00 | AAPL | Stock | 6.6396 | 6.645 | 6.6289 | 6.6414 | 10225404.0 |
| 2007-10-30 09:50:00 | AAPL | Stock | 6.6418 | 6.6454 | 6.6354 | 6.6396 | 10127096.0 |
| 2007-10-30 09:55:00 | AAPL | Stock | 6.6407 | 6.6446 | 6.6329 | 6.64 | 8622012.0 |
| 2007-10-30 10:00:00 | AAPL | Stock | 6.6396 | 6.6429 | 6.6232 | 6.6261 | 13226220.0 |
| 2007-10-30 10:05:00 | AAPL | Stock | 6.625 | 6.6254 | 6.5975 | 6.6025 | 16986480.0 |
| 2007-10-30 10:10:00 | AAPL | Stock | 6.6025 | 6.6132 | 6.5986 | 6.6129 | 12456612.0 |
| 2007-10-30 10:15:00 | AAPL | Stock | 6.6125 | 6.6282 | 6.6075 | 6.6268 | 11328604.0 |
| 2007-10-30 10:20:00 | AAPL | Stock | 6.6279 | 6.6443 | 6.6189 | 6.6379 | 13878284.0 |
| 2007-10-30 10:25:00 | AAPL | Stock | 6.6379 | 6.6582 | 6.6293 | 6.6575 | 17747156.0 |
| 2007-10-30 10:30:00 | AAPL | Stock | 6.6575 | 6.6714 | 6.6521 | 6.6639 | 30431660.0 |
| 2007-10-30 10:35:00 | AAPL | Stock | 6.6643 | 6.6775 | 6.6639 | 6.6643 | 20399876.0 |
| 2007-10-30 10:40:00 | AAPL | Stock | 6.6645 | 6.6664 | 6.625 | 6.6643 | 9649668.0 |
| 2007-10-30 10:45:00 | AAPL | Stock | 6.6646 | 6.6721 | 6.6579 | 6.6661 | 7949396.0 |
| 2007-10-30 10:50:00 | AAPL | Stock | 6.6661 | 6.6875 | 6.6661 | 6.6868 | 17050124.0 |
| 2007-10-30 10:55:00 | AAPL | Stock | 6.6868 | 6.7064 | 6.6868 | 6.6982 | 21001512.0 |
| 2007-10-30 11:00:00 | AAPL | Stock | 6.6975 | 6.6989 | 6.6875 | 6.6964 | 10779636.0 |
| 2007-10-30 11:05:00 | AAPL | Stock | 6.696 | 6.7007 | 6.6914 | 6.6925 | 10935344.0 |
| 2007-10-30 11:10:00 | AAPL | Stock | 6.6921 | 6.7007 | 6.6871 | 6.6939 | 8519252.0 |
| 2007-10-30 11:15:00 | AAPL | Stock | 6.6939 | 6.6979 | 6.6904 | 6.6914 | 7710500.0 |
> showing 50 of 309,306 rows — these rows as CSV