PREVIEW / stock_5min / 2011-08-16
file: by_date/stock_5min/2011/2011-08-16.parquet size: 5.0 MB rows: 335,469 symbols: 3,509
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-16 04:05:00 | AAPL | Stock | 13.5539 | 13.5539 | 13.5536 | 13.5536 | 5600.0 |
| 2011-08-16 04:10:00 | AAPL | Stock | 13.5536 | 13.5536 | 13.5536 | 13.5536 | 2800.0 |
| 2011-08-16 04:35:00 | AAPL | Stock | 13.5711 | 13.5711 | 13.5711 | 13.5711 | 2800.0 |
| 2011-08-16 04:45:00 | AAPL | Stock | 13.5775 | 13.5775 | 13.5775 | 13.5775 | 2800.0 |
| 2011-08-16 05:00:00 | AAPL | Stock | 13.5832 | 13.5832 | 13.5832 | 13.5832 | 2800.0 |
| 2011-08-16 06:00:00 | AAPL | Stock | 13.5714 | 13.5714 | 13.5714 | 13.5714 | 8400.0 |
| 2011-08-16 06:30:00 | AAPL | Stock | 13.5936 | 13.5936 | 13.5936 | 13.5936 | 2800.0 |
| 2011-08-16 06:35:00 | AAPL | Stock | 13.5714 | 13.5714 | 13.5714 | 13.5714 | 5600.0 |
| 2011-08-16 06:55:00 | AAPL | Stock | 13.5714 | 13.5714 | 13.5714 | 13.5714 | 5600.0 |
| 2011-08-16 07:00:00 | AAPL | Stock | 13.5707 | 13.5964 | 13.5707 | 13.5818 | 29708.0 |
| 2011-08-16 07:05:00 | AAPL | Stock | 13.58 | 13.5857 | 13.5786 | 13.5807 | 48160.0 |
| 2011-08-16 07:10:00 | AAPL | Stock | 13.5736 | 13.5904 | 13.5718 | 13.5893 | 22400.0 |
| 2011-08-16 07:15:00 | AAPL | Stock | 13.5904 | 13.5904 | 13.5786 | 13.5804 | 41440.0 |
| 2011-08-16 07:20:00 | AAPL | Stock | 13.5929 | 13.6071 | 13.5889 | 13.5929 | 91840.0 |
| 2011-08-16 07:25:00 | AAPL | Stock | 13.5989 | 13.6071 | 13.5857 | 13.5875 | 48440.0 |
| 2011-08-16 07:30:00 | AAPL | Stock | 13.5882 | 13.6032 | 13.5882 | 13.6032 | 15120.0 |
| 2011-08-16 07:35:00 | AAPL | Stock | 13.5964 | 13.5964 | 13.5804 | 13.5875 | 72800.0 |
| 2011-08-16 07:40:00 | AAPL | Stock | 13.5854 | 13.5854 | 13.5714 | 13.5714 | 28700.0 |
| 2011-08-16 07:45:00 | AAPL | Stock | 13.5714 | 13.5786 | 13.5643 | 13.5743 | 51156.0 |
| 2011-08-16 07:50:00 | AAPL | Stock | 13.5721 | 13.5854 | 13.5721 | 13.5846 | 41468.0 |
| 2011-08-16 07:55:00 | AAPL | Stock | 13.5836 | 13.5864 | 13.5804 | 13.5804 | 28000.0 |
| 2011-08-16 08:00:00 | AAPL | Stock | 13.5804 | 13.5893 | 13.5554 | 13.5554 | 373240.0 |
| 2011-08-16 08:05:00 | AAPL | Stock | 13.5536 | 13.5604 | 13.5482 | 13.5482 | 123200.0 |
| 2011-08-16 08:10:00 | AAPL | Stock | 13.5475 | 13.5536 | 13.52 | 13.5275 | 194460.0 |
| 2011-08-16 08:15:00 | AAPL | Stock | 13.5268 | 13.5464 | 13.5218 | 13.5464 | 118524.0 |
| 2011-08-16 08:20:00 | AAPL | Stock | 13.5464 | 13.5671 | 13.5446 | 13.5621 | 310072.0 |
| 2011-08-16 08:25:00 | AAPL | Stock | 13.5621 | 13.5679 | 13.5536 | 13.5671 | 236964.0 |
| 2011-08-16 08:30:00 | AAPL | Stock | 13.5671 | 13.5671 | 13.5418 | 13.5604 | 583492.0 |
| 2011-08-16 08:35:00 | AAPL | Stock | 13.5593 | 13.5961 | 13.5525 | 13.5857 | 710416.0 |
| 2011-08-16 08:40:00 | AAPL | Stock | 13.5857 | 13.5893 | 13.5714 | 13.5714 | 299292.0 |
| 2011-08-16 08:45:00 | AAPL | Stock | 13.5721 | 13.5821 | 13.5711 | 13.5714 | 135380.0 |
| 2011-08-16 08:50:00 | AAPL | Stock | 13.5739 | 13.5893 | 13.5739 | 13.5893 | 28000.0 |
| 2011-08-16 08:55:00 | AAPL | Stock | 13.5861 | 13.5879 | 13.5771 | 13.585 | 234108.0 |
| 2011-08-16 09:00:00 | AAPL | Stock | 13.5832 | 13.6043 | 13.5811 | 13.5821 | 584248.0 |
| 2011-08-16 09:05:00 | AAPL | Stock | 13.5814 | 13.5971 | 13.5804 | 13.5896 | 140196.0 |
| 2011-08-16 09:10:00 | AAPL | Stock | 13.5929 | 13.6064 | 13.5911 | 13.6 | 154700.0 |
| 2011-08-16 09:15:00 | AAPL | Stock | 13.6 | 13.6393 | 13.6 | 13.6393 | 377412.0 |
| 2011-08-16 09:20:00 | AAPL | Stock | 13.6357 | 13.6579 | 13.6357 | 13.6493 | 827988.0 |
| 2011-08-16 09:25:00 | AAPL | Stock | 13.6457 | 13.6507 | 13.625 | 13.625 | 618772.0 |
| 2011-08-16 09:30:00 | AAPL | Stock | 13.6257 | 13.6429 | 13.5836 | 13.6143 | 19864040.0 |
| 2011-08-16 09:35:00 | AAPL | Stock | 13.6146 | 13.6507 | 13.6046 | 13.6341 | 10920616.0 |
| 2011-08-16 09:40:00 | AAPL | Stock | 13.6364 | 13.6414 | 13.6021 | 13.6064 | 8675464.0 |
| 2011-08-16 09:45:00 | AAPL | Stock | 13.6064 | 13.6143 | 13.5893 | 13.5932 | 6498408.0 |
| 2011-08-16 09:50:00 | AAPL | Stock | 13.5946 | 13.6114 | 13.5729 | 13.5964 | 10020808.0 |
| 2011-08-16 09:55:00 | AAPL | Stock | 13.5961 | 13.6161 | 13.5846 | 13.6054 | 6107528.0 |
| 2011-08-16 10:00:00 | AAPL | Stock | 13.6014 | 13.6311 | 13.5932 | 13.6125 | 7186760.0 |
| 2011-08-16 10:05:00 | AAPL | Stock | 13.6132 | 13.6161 | 13.5857 | 13.6007 | 6098148.0 |
| 2011-08-16 10:10:00 | AAPL | Stock | 13.6004 | 13.6154 | 13.5764 | 13.5839 | 6937756.0 |
| 2011-08-16 10:15:00 | AAPL | Stock | 13.5818 | 13.615 | 13.5786 | 13.6114 | 9020340.0 |
| 2011-08-16 10:20:00 | AAPL | Stock | 13.6111 | 13.6321 | 13.6039 | 13.6268 | 7805588.0 |
> showing 50 of 335,469 rows — these rows as CSV