PREVIEW / stock_5min / 2007-11-16
file: by_date/stock_5min/2007/2007-11-16.parquet size: 4.3 MB rows: 313,851 symbols: 3,190
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-11-16 05:20:00 | AAPL | Stock | 5.8707 | 5.8707 | 5.8707 | 5.8707 | 2800.0 |
| 2007-11-16 06:20:00 | AAPL | Stock | 5.8839 | 5.8839 | 5.8839 | 5.8839 | 2800.0 |
| 2007-11-16 06:25:00 | AAPL | Stock | 5.8839 | 5.8839 | 5.8839 | 5.8839 | 2800.0 |
| 2007-11-16 06:45:00 | AAPL | Stock | 5.8571 | 5.8571 | 5.8571 | 5.8571 | 15120.0 |
| 2007-11-16 07:00:00 | AAPL | Stock | 5.8843 | 5.8843 | 5.8843 | 5.8843 | 8400.0 |
| 2007-11-16 07:05:00 | AAPL | Stock | 5.8864 | 5.9175 | 5.8864 | 5.9139 | 50344.0 |
| 2007-11-16 07:15:00 | AAPL | Stock | 5.9064 | 5.9064 | 5.9064 | 5.9064 | 2800.0 |
| 2007-11-16 07:20:00 | AAPL | Stock | 5.91 | 5.9143 | 5.9096 | 5.9143 | 95200.0 |
| 2007-11-16 07:25:00 | AAPL | Stock | 5.9282 | 5.9286 | 5.9268 | 5.9286 | 138320.0 |
| 2007-11-16 07:30:00 | AAPL | Stock | 5.9268 | 5.9311 | 5.9175 | 5.9311 | 22624.0 |
| 2007-11-16 07:35:00 | AAPL | Stock | 5.9286 | 5.9464 | 5.9268 | 5.9268 | 99596.0 |
| 2007-11-16 07:40:00 | AAPL | Stock | 5.9214 | 5.9246 | 5.9179 | 5.9246 | 19600.0 |
| 2007-11-16 07:45:00 | AAPL | Stock | 5.9132 | 5.9132 | 5.9036 | 5.9107 | 64400.0 |
| 2007-11-16 07:50:00 | AAPL | Stock | 5.9082 | 5.9107 | 5.9079 | 5.9107 | 11200.0 |
| 2007-11-16 07:55:00 | AAPL | Stock | 5.9107 | 5.9314 | 5.9107 | 5.9214 | 107156.0 |
| 2007-11-16 08:00:00 | AAPL | Stock | 5.9282 | 5.9707 | 5.9143 | 5.9639 | 1550808.0 |
| 2007-11-16 08:05:00 | AAPL | Stock | 5.9571 | 5.9604 | 5.9325 | 5.9393 | 1017632.0 |
| 2007-11-16 08:10:00 | AAPL | Stock | 5.9489 | 5.9489 | 5.9393 | 5.9461 | 285656.0 |
| 2007-11-16 08:15:00 | AAPL | Stock | 5.9421 | 5.95 | 5.9396 | 5.9404 | 326900.0 |
| 2007-11-16 08:20:00 | AAPL | Stock | 5.9429 | 5.95 | 5.9286 | 5.9286 | 590800.0 |
| 2007-11-16 08:25:00 | AAPL | Stock | 5.9286 | 5.9286 | 5.9175 | 5.9261 | 550256.0 |
| 2007-11-16 08:30:00 | AAPL | Stock | 5.925 | 5.945 | 5.925 | 5.9411 | 438564.0 |
| 2007-11-16 08:35:00 | AAPL | Stock | 5.9411 | 5.9518 | 5.9375 | 5.9482 | 584136.0 |
| 2007-11-16 08:40:00 | AAPL | Stock | 5.9511 | 5.9607 | 5.9464 | 5.96 | 924588.0 |
| 2007-11-16 08:45:00 | AAPL | Stock | 5.9589 | 5.9679 | 5.9339 | 5.9375 | 2038204.0 |
| 2007-11-16 08:50:00 | AAPL | Stock | 5.9346 | 5.9439 | 5.9325 | 5.9339 | 550144.0 |
| 2007-11-16 08:55:00 | AAPL | Stock | 5.9329 | 5.9375 | 5.9314 | 5.9371 | 498204.0 |
| 2007-11-16 09:00:00 | AAPL | Stock | 5.9375 | 5.9375 | 5.92 | 5.925 | 950684.0 |
| 2007-11-16 09:05:00 | AAPL | Stock | 5.9225 | 5.9325 | 5.9196 | 5.9268 | 731640.0 |
| 2007-11-16 09:10:00 | AAPL | Stock | 5.9282 | 5.9446 | 5.9036 | 5.9143 | 2623348.0 |
| 2007-11-16 09:15:00 | AAPL | Stock | 5.9139 | 5.9157 | 5.8875 | 5.8886 | 1475880.0 |
| 2007-11-16 09:20:00 | AAPL | Stock | 5.8921 | 5.8982 | 5.8846 | 5.8918 | 724500.0 |
| 2007-11-16 09:25:00 | AAPL | Stock | 5.8911 | 5.9107 | 5.8911 | 5.9036 | 1203384.0 |
| 2007-11-16 09:30:00 | AAPL | Stock | 5.9021 | 5.9464 | 5.8957 | 5.9036 | 68231240.0 |
| 2007-11-16 09:35:00 | AAPL | Stock | 5.9029 | 5.9354 | 5.8068 | 5.8214 | 38983812.0 |
| 2007-11-16 09:40:00 | AAPL | Stock | 5.8207 | 5.8907 | 5.8196 | 5.8479 | 25362456.0 |
| 2007-11-16 09:45:00 | AAPL | Stock | 5.8479 | 5.8757 | 5.8286 | 5.8586 | 19855920.0 |
| 2007-11-16 09:50:00 | AAPL | Stock | 5.8604 | 5.8604 | 5.7957 | 5.8332 | 24976196.0 |
| 2007-11-16 09:55:00 | AAPL | Stock | 5.8321 | 5.8457 | 5.7836 | 5.7868 | 20619956.0 |
| 2007-11-16 10:00:00 | AAPL | Stock | 5.7879 | 5.8029 | 5.7479 | 5.7507 | 30889824.0 |
| 2007-11-16 10:05:00 | AAPL | Stock | 5.75 | 5.7982 | 5.7479 | 5.7929 | 28045836.0 |
| 2007-11-16 10:10:00 | AAPL | Stock | 5.7939 | 5.8121 | 5.7707 | 5.7861 | 23342144.0 |
| 2007-11-16 10:15:00 | AAPL | Stock | 5.7846 | 5.8068 | 5.7743 | 5.7786 | 16945740.0 |
| 2007-11-16 10:20:00 | AAPL | Stock | 5.7786 | 5.79 | 5.7429 | 5.7561 | 24591280.0 |
| 2007-11-16 10:25:00 | AAPL | Stock | 5.7571 | 5.7671 | 5.7007 | 5.7071 | 29450260.0 |
| 2007-11-16 10:30:00 | AAPL | Stock | 5.7071 | 5.7443 | 5.7057 | 5.7307 | 21315532.0 |
| 2007-11-16 10:35:00 | AAPL | Stock | 5.73 | 5.7321 | 5.6904 | 5.7207 | 22349040.0 |
| 2007-11-16 10:40:00 | AAPL | Stock | 5.7207 | 5.7696 | 5.7167 | 5.7554 | 22546888.0 |
| 2007-11-16 10:45:00 | AAPL | Stock | 5.7554 | 5.78 | 5.7411 | 5.7696 | 17876992.0 |
| 2007-11-16 10:50:00 | AAPL | Stock | 5.7689 | 5.7879 | 5.7607 | 5.7725 | 16237284.0 |
> showing 50 of 313,851 rows — these rows as CSV