PREVIEW / stock_5min / 2008-09-17
file: by_date/stock_5min/2008/2008-09-17.parquet size: 5.0 MB rows: 347,285 symbols: 3,365
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-17 06:10:00 | AAPL | Stock | 5.02 | 5.02 | 5.0157 | 5.0157 | 8400.0 |
| 2008-09-17 06:30:00 | AAPL | Stock | 5.0132 | 5.0132 | 5.0132 | 5.0132 | 8400.0 |
| 2008-09-17 07:05:00 | AAPL | Stock | 5.0357 | 5.0357 | 5.0357 | 5.0357 | 2800.0 |
| 2008-09-17 07:15:00 | AAPL | Stock | 5.0057 | 5.0057 | 5.0057 | 5.0057 | 2800.0 |
| 2008-09-17 07:25:00 | AAPL | Stock | 5.0132 | 5.0132 | 4.9904 | 5.0036 | 144200.0 |
| 2008-09-17 07:30:00 | AAPL | Stock | 4.9875 | 5.0 | 4.9875 | 4.9875 | 33348.0 |
| 2008-09-17 07:35:00 | AAPL | Stock | 5.025 | 5.025 | 5.025 | 5.025 | 2800.0 |
| 2008-09-17 07:50:00 | AAPL | Stock | 5.0107 | 5.0107 | 5.0107 | 5.0107 | 2800.0 |
| 2008-09-17 07:55:00 | AAPL | Stock | 5.0107 | 5.0107 | 5.0107 | 5.0107 | 2800.0 |
| 2008-09-17 08:00:00 | AAPL | Stock | 5.0007 | 5.0239 | 5.0007 | 5.0239 | 79380.0 |
| 2008-09-17 08:05:00 | AAPL | Stock | 5.0239 | 5.025 | 5.0107 | 5.0107 | 109900.0 |
| 2008-09-17 08:10:00 | AAPL | Stock | 5.0171 | 5.0243 | 5.0125 | 5.0125 | 98000.0 |
| 2008-09-17 08:15:00 | AAPL | Stock | 5.01 | 5.0161 | 4.9896 | 4.9896 | 150052.0 |
| 2008-09-17 08:20:00 | AAPL | Stock | 4.9961 | 5.0171 | 4.9929 | 5.0171 | 339640.0 |
| 2008-09-17 08:25:00 | AAPL | Stock | 5.0143 | 5.0143 | 5.0 | 5.0014 | 352996.0 |
| 2008-09-17 08:30:00 | AAPL | Stock | 5.0014 | 5.0125 | 4.9779 | 4.9821 | 442260.0 |
| 2008-09-17 08:35:00 | AAPL | Stock | 4.9725 | 4.9821 | 4.9639 | 4.9821 | 338128.0 |
| 2008-09-17 08:40:00 | AAPL | Stock | 4.9821 | 4.9857 | 4.9821 | 4.9821 | 117012.0 |
| 2008-09-17 08:45:00 | AAPL | Stock | 4.9839 | 4.9896 | 4.9839 | 4.9896 | 9800.0 |
| 2008-09-17 08:50:00 | AAPL | Stock | 4.9893 | 4.9893 | 4.9893 | 4.9893 | 2800.0 |
| 2008-09-17 08:55:00 | AAPL | Stock | 4.9893 | 4.9893 | 4.9757 | 4.9757 | 28840.0 |
| 2008-09-17 09:00:00 | AAPL | Stock | 4.9779 | 4.9814 | 4.9643 | 4.9643 | 206864.0 |
| 2008-09-17 09:05:00 | AAPL | Stock | 4.9614 | 4.9614 | 4.9511 | 4.9539 | 386372.0 |
| 2008-09-17 09:10:00 | AAPL | Stock | 4.9604 | 4.9643 | 4.9546 | 4.9643 | 49700.0 |
| 2008-09-17 09:15:00 | AAPL | Stock | 4.9654 | 4.9654 | 4.9464 | 4.9479 | 224252.0 |
| 2008-09-17 09:20:00 | AAPL | Stock | 4.9521 | 4.9521 | 4.9464 | 4.9464 | 73220.0 |
| 2008-09-17 09:25:00 | AAPL | Stock | 4.9568 | 4.9625 | 4.9361 | 4.9493 | 357504.0 |
| 2008-09-17 09:30:00 | AAPL | Stock | 4.9411 | 4.9468 | 4.7889 | 4.8475 | 43222116.0 |
| 2008-09-17 09:35:00 | AAPL | Stock | 4.8471 | 4.8839 | 4.8357 | 4.8804 | 19586448.0 |
| 2008-09-17 09:40:00 | AAPL | Stock | 4.8807 | 4.9171 | 4.8532 | 4.8886 | 18345964.0 |
| 2008-09-17 09:45:00 | AAPL | Stock | 4.8896 | 4.9014 | 4.8721 | 4.8893 | 14433468.0 |
| 2008-09-17 09:50:00 | AAPL | Stock | 4.8896 | 4.9107 | 4.8611 | 4.8968 | 15689324.0 |
| 2008-09-17 09:55:00 | AAPL | Stock | 4.8975 | 4.9036 | 4.855 | 4.8771 | 12945828.0 |
| 2008-09-17 10:00:00 | AAPL | Stock | 4.8768 | 4.8893 | 4.8525 | 4.8654 | 14830844.0 |
| 2008-09-17 10:05:00 | AAPL | Stock | 4.8646 | 4.8864 | 4.8393 | 4.8814 | 17747268.0 |
| 2008-09-17 10:10:00 | AAPL | Stock | 4.8807 | 4.8971 | 4.8214 | 4.8379 | 19980660.0 |
| 2008-09-17 10:15:00 | AAPL | Stock | 4.8371 | 4.8582 | 4.83 | 4.8343 | 12119800.0 |
| 2008-09-17 10:20:00 | AAPL | Stock | 4.835 | 4.8493 | 4.8214 | 4.8246 | 11279492.0 |
| 2008-09-17 10:25:00 | AAPL | Stock | 4.8243 | 4.8529 | 4.8225 | 4.8321 | 11366740.0 |
| 2008-09-17 10:30:00 | AAPL | Stock | 4.8336 | 4.8655 | 4.8279 | 4.8404 | 12584740.0 |
| 2008-09-17 10:35:00 | AAPL | Stock | 4.84 | 4.8464 | 4.8143 | 4.8232 | 16500596.0 |
| 2008-09-17 10:40:00 | AAPL | Stock | 4.8243 | 4.8393 | 4.8182 | 4.8339 | 10972024.0 |
| 2008-09-17 10:45:00 | AAPL | Stock | 4.8336 | 4.8404 | 4.8132 | 4.8214 | 10188528.0 |
| 2008-09-17 10:50:00 | AAPL | Stock | 4.8214 | 4.8321 | 4.7979 | 4.8315 | 13119484.0 |
| 2008-09-17 10:55:00 | AAPL | Stock | 4.8314 | 4.8446 | 4.8179 | 4.8409 | 8548848.0 |
| 2008-09-17 11:00:00 | AAPL | Stock | 4.8407 | 4.8489 | 4.8261 | 4.8289 | 9563736.0 |
| 2008-09-17 11:05:00 | AAPL | Stock | 4.8289 | 4.8321 | 4.8071 | 4.8129 | 10183236.0 |
| 2008-09-17 11:10:00 | AAPL | Stock | 4.8139 | 4.815 | 4.7725 | 4.7771 | 13695612.0 |
| 2008-09-17 11:15:00 | AAPL | Stock | 4.7768 | 4.7946 | 4.7729 | 4.7796 | 12437096.0 |
| 2008-09-17 11:20:00 | AAPL | Stock | 4.7796 | 4.7964 | 4.7782 | 4.7907 | 10091536.0 |
> showing 50 of 347,285 rows — these rows as CSV