PREVIEW / stock_5min / 2008-09-09
file: by_date/stock_5min/2008/2008-09-09.parquet size: 4.6 MB rows: 324,194 symbols: 3,333
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-09 05:25:00 | AAPL | Stock | 5.66 | 5.66 | 5.66 | 5.66 | 8400.0 |
| 2008-09-09 06:55:00 | AAPL | Stock | 5.6782 | 5.6782 | 5.6782 | 5.6782 | 5600.0 |
| 2008-09-09 07:15:00 | AAPL | Stock | 5.6768 | 5.6768 | 5.6768 | 5.6768 | 3276.0 |
| 2008-09-09 07:20:00 | AAPL | Stock | 5.6768 | 5.6768 | 5.6768 | 5.6768 | 12124.0 |
| 2008-09-09 07:25:00 | AAPL | Stock | 5.6768 | 5.6768 | 5.6768 | 5.6768 | 2800.0 |
| 2008-09-09 07:45:00 | AAPL | Stock | 5.6696 | 5.6725 | 5.6696 | 5.6725 | 9940.0 |
| 2008-09-09 07:50:00 | AAPL | Stock | 5.6732 | 5.6732 | 5.6714 | 5.6714 | 16800.0 |
| 2008-09-09 07:55:00 | AAPL | Stock | 5.6696 | 5.6696 | 5.6696 | 5.6696 | 19600.0 |
| 2008-09-09 08:00:00 | AAPL | Stock | 5.6786 | 5.6843 | 5.6646 | 5.6679 | 417172.0 |
| 2008-09-09 08:05:00 | AAPL | Stock | 5.6696 | 5.6696 | 5.6525 | 5.6607 | 178024.0 |
| 2008-09-09 08:10:00 | AAPL | Stock | 5.6554 | 5.6589 | 5.6339 | 5.6339 | 159740.0 |
| 2008-09-09 08:15:00 | AAPL | Stock | 5.6282 | 5.64 | 5.6232 | 5.6268 | 74368.0 |
| 2008-09-09 08:20:00 | AAPL | Stock | 5.6254 | 5.6321 | 5.625 | 5.6254 | 25172.0 |
| 2008-09-09 08:25:00 | AAPL | Stock | 5.625 | 5.625 | 5.6146 | 5.6214 | 251188.0 |
| 2008-09-09 08:30:00 | AAPL | Stock | 5.62 | 5.62 | 5.6107 | 5.6114 | 58184.0 |
| 2008-09-09 08:35:00 | AAPL | Stock | 5.6114 | 5.6164 | 5.6107 | 5.6146 | 142128.0 |
| 2008-09-09 08:40:00 | AAPL | Stock | 5.6221 | 5.6268 | 5.6146 | 5.6146 | 16800.0 |
| 2008-09-09 08:45:00 | AAPL | Stock | 5.6146 | 5.6246 | 5.6146 | 5.6246 | 5600.0 |
| 2008-09-09 08:50:00 | AAPL | Stock | 5.6182 | 5.6189 | 5.615 | 5.615 | 44800.0 |
| 2008-09-09 08:55:00 | AAPL | Stock | 5.6143 | 5.6143 | 5.5893 | 5.5893 | 339192.0 |
| 2008-09-09 09:00:00 | AAPL | Stock | 5.5875 | 5.6071 | 5.5664 | 5.5936 | 339892.0 |
| 2008-09-09 09:05:00 | AAPL | Stock | 5.5907 | 5.5936 | 5.5807 | 5.5868 | 231168.0 |
| 2008-09-09 09:10:00 | AAPL | Stock | 5.5868 | 5.5989 | 5.5854 | 5.5904 | 157164.0 |
| 2008-09-09 09:15:00 | AAPL | Stock | 5.5929 | 5.5971 | 5.5879 | 5.5918 | 81200.0 |
| 2008-09-09 09:20:00 | AAPL | Stock | 5.5889 | 5.5929 | 5.5861 | 5.5861 | 88704.0 |
| 2008-09-09 09:25:00 | AAPL | Stock | 5.5889 | 5.6068 | 5.5861 | 5.6043 | 593096.0 |
| 2008-09-09 09:30:00 | AAPL | Stock | 5.6021 | 5.6143 | 5.5536 | 5.5961 | 21116172.0 |
| 2008-09-09 09:35:00 | AAPL | Stock | 5.5968 | 5.66 | 5.5961 | 5.6364 | 20732656.0 |
| 2008-09-09 09:40:00 | AAPL | Stock | 5.6361 | 5.6946 | 5.6266 | 5.6721 | 24404128.0 |
| 2008-09-09 09:45:00 | AAPL | Stock | 5.6704 | 5.7071 | 5.6664 | 5.6879 | 17145632.0 |
| 2008-09-09 09:50:00 | AAPL | Stock | 5.6871 | 5.7046 | 5.6732 | 5.7036 | 12334644.0 |
| 2008-09-09 09:55:00 | AAPL | Stock | 5.705 | 5.71 | 5.6607 | 5.6654 | 13871592.0 |
| 2008-09-09 10:00:00 | AAPL | Stock | 5.6646 | 5.6654 | 5.6354 | 5.6507 | 15863680.0 |
| 2008-09-09 10:05:00 | AAPL | Stock | 5.6507 | 5.6696 | 5.6354 | 5.6364 | 12888260.0 |
| 2008-09-09 10:10:00 | AAPL | Stock | 5.6368 | 5.6425 | 5.6182 | 5.6332 | 13917120.0 |
| 2008-09-09 10:15:00 | AAPL | Stock | 5.6329 | 5.6554 | 5.6204 | 5.635 | 9761472.0 |
| 2008-09-09 10:20:00 | AAPL | Stock | 5.6361 | 5.6675 | 5.6329 | 5.6536 | 9120692.0 |
| 2008-09-09 10:25:00 | AAPL | Stock | 5.6536 | 5.6646 | 5.6368 | 5.6507 | 9493652.0 |
| 2008-09-09 10:30:00 | AAPL | Stock | 5.6514 | 5.6786 | 5.6296 | 5.6768 | 10793104.0 |
| 2008-09-09 10:35:00 | AAPL | Stock | 5.6757 | 5.6786 | 5.6521 | 5.6736 | 7694120.0 |
| 2008-09-09 10:40:00 | AAPL | Stock | 5.6736 | 5.6764 | 5.6457 | 5.6586 | 7589736.0 |
| 2008-09-09 10:45:00 | AAPL | Stock | 5.6564 | 5.6757 | 5.6504 | 5.6718 | 12571664.0 |
| 2008-09-09 10:50:00 | AAPL | Stock | 5.6721 | 5.6921 | 5.6582 | 5.6614 | 13886180.0 |
| 2008-09-09 10:55:00 | AAPL | Stock | 5.6614 | 5.6689 | 5.6357 | 5.6564 | 14561540.0 |
| 2008-09-09 11:00:00 | AAPL | Stock | 5.6564 | 5.675 | 5.6496 | 5.6686 | 9015580.0 |
| 2008-09-09 11:05:00 | AAPL | Stock | 5.6693 | 5.6743 | 5.6511 | 5.6511 | 7099372.0 |
| 2008-09-09 11:10:00 | AAPL | Stock | 5.6511 | 5.6525 | 5.6021 | 5.6211 | 17007984.0 |
| 2008-09-09 11:15:00 | AAPL | Stock | 5.6211 | 5.6246 | 5.5964 | 5.6196 | 14352688.0 |
| 2008-09-09 11:20:00 | AAPL | Stock | 5.62 | 5.6461 | 5.6193 | 5.6446 | 8465660.0 |
| 2008-09-09 11:25:00 | AAPL | Stock | 5.6446 | 5.6604 | 5.6436 | 5.6536 | 6041924.0 |
> showing 50 of 324,194 rows — these rows as CSV