PREVIEW / stock_5min / 2009-06-11
file: by_date/stock_5min/2009/2009-06-11.parquet size: 4.6 MB rows: 320,501 symbols: 3,368
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-11 07:00:00 | AAPL | Stock | 5.0221 | 5.0286 | 5.0221 | 5.0286 | 5600.0 |
| 2009-06-11 07:10:00 | AAPL | Stock | 5.0132 | 5.0132 | 5.0089 | 5.0089 | 18200.0 |
| 2009-06-11 07:30:00 | AAPL | Stock | 4.9996 | 4.9996 | 4.9996 | 4.9996 | 2800.0 |
| 2009-06-11 07:40:00 | AAPL | Stock | 5.0043 | 5.0043 | 5.0043 | 5.0043 | 2800.0 |
| 2009-06-11 07:45:00 | AAPL | Stock | 5.0079 | 5.0129 | 5.0 | 5.0129 | 33600.0 |
| 2009-06-11 07:50:00 | AAPL | Stock | 5.0132 | 5.0132 | 5.0129 | 5.0129 | 31500.0 |
| 2009-06-11 07:55:00 | AAPL | Stock | 5.0129 | 5.0182 | 5.0089 | 5.0089 | 55972.0 |
| 2009-06-11 08:00:00 | AAPL | Stock | 5.0136 | 5.0321 | 5.0136 | 5.0279 | 168196.0 |
| 2009-06-11 08:05:00 | AAPL | Stock | 5.0314 | 5.0343 | 5.0232 | 5.025 | 211680.0 |
| 2009-06-11 08:10:00 | AAPL | Stock | 5.0182 | 5.0243 | 5.015 | 5.0157 | 105000.0 |
| 2009-06-11 08:15:00 | AAPL | Stock | 5.0164 | 5.0214 | 5.0143 | 5.0143 | 19180.0 |
| 2009-06-11 08:20:00 | AAPL | Stock | 5.0079 | 5.0139 | 5.0075 | 5.0139 | 63420.0 |
| 2009-06-11 08:25:00 | AAPL | Stock | 5.0139 | 5.0139 | 5.0111 | 5.0111 | 14784.0 |
| 2009-06-11 08:30:00 | AAPL | Stock | 5.0146 | 5.0396 | 5.0011 | 5.0179 | 324380.0 |
| 2009-06-11 08:35:00 | AAPL | Stock | 5.0054 | 5.0143 | 5.0054 | 5.0075 | 57400.0 |
| 2009-06-11 08:40:00 | AAPL | Stock | 5.0021 | 5.0036 | 4.9964 | 4.9968 | 145488.0 |
| 2009-06-11 08:45:00 | AAPL | Stock | 4.9957 | 4.9957 | 4.9832 | 4.9954 | 101892.0 |
| 2009-06-11 08:50:00 | AAPL | Stock | 4.9911 | 4.9911 | 4.9779 | 4.9779 | 174272.0 |
| 2009-06-11 08:55:00 | AAPL | Stock | 4.9761 | 4.9814 | 4.975 | 4.9796 | 144760.0 |
| 2009-06-11 09:00:00 | AAPL | Stock | 4.9804 | 4.9875 | 4.9779 | 4.9818 | 321328.0 |
| 2009-06-11 09:05:00 | AAPL | Stock | 4.9818 | 4.9921 | 4.9818 | 4.9911 | 66864.0 |
| 2009-06-11 09:10:00 | AAPL | Stock | 4.9918 | 5.0 | 4.9911 | 4.9964 | 285180.0 |
| 2009-06-11 09:15:00 | AAPL | Stock | 4.9964 | 4.9982 | 4.9954 | 4.9982 | 28840.0 |
| 2009-06-11 09:20:00 | AAPL | Stock | 4.9954 | 4.9964 | 4.9929 | 4.9929 | 36568.0 |
| 2009-06-11 09:25:00 | AAPL | Stock | 4.9925 | 4.9929 | 4.9875 | 4.9875 | 54600.0 |
| 2009-06-11 09:30:00 | AAPL | Stock | 4.9861 | 4.9946 | 4.9582 | 4.9661 | 17531332.0 |
| 2009-06-11 09:35:00 | AAPL | Stock | 4.9654 | 4.9732 | 4.9482 | 4.9707 | 14753956.0 |
| 2009-06-11 09:40:00 | AAPL | Stock | 4.97 | 4.9979 | 4.9654 | 4.9861 | 15271760.0 |
| 2009-06-11 09:45:00 | AAPL | Stock | 4.9861 | 5.0337 | 4.9861 | 5.0182 | 21639856.0 |
| 2009-06-11 09:50:00 | AAPL | Stock | 5.0171 | 5.0325 | 5.0159 | 5.0239 | 11356604.0 |
| 2009-06-11 09:55:00 | AAPL | Stock | 5.0243 | 5.0268 | 5.0061 | 5.0146 | 9367876.0 |
| 2009-06-11 10:00:00 | AAPL | Stock | 5.0146 | 5.0189 | 4.9932 | 4.9981 | 9598456.0 |
| 2009-06-11 10:05:00 | AAPL | Stock | 4.9989 | 5.0286 | 4.9979 | 5.027 | 11976104.0 |
| 2009-06-11 10:10:00 | AAPL | Stock | 5.0268 | 5.0489 | 5.0268 | 5.0464 | 14820316.0 |
| 2009-06-11 10:15:00 | AAPL | Stock | 5.0461 | 5.0557 | 5.0411 | 5.0443 | 11066468.0 |
| 2009-06-11 10:20:00 | AAPL | Stock | 5.0443 | 5.0461 | 5.0307 | 5.0354 | 7024304.0 |
| 2009-06-11 10:25:00 | AAPL | Stock | 5.0357 | 5.0457 | 5.0343 | 5.0436 | 4888856.0 |
| 2009-06-11 10:30:00 | AAPL | Stock | 5.0439 | 5.0482 | 5.0318 | 5.0336 | 5407108.0 |
| 2009-06-11 10:35:00 | AAPL | Stock | 5.0332 | 5.0339 | 5.0154 | 5.0207 | 6704992.0 |
| 2009-06-11 10:40:00 | AAPL | Stock | 5.0193 | 5.03 | 5.0136 | 5.0193 | 5869136.0 |
| 2009-06-11 10:45:00 | AAPL | Stock | 5.02 | 5.0354 | 5.0189 | 5.0339 | 3092012.0 |
| 2009-06-11 10:50:00 | AAPL | Stock | 5.0343 | 5.0389 | 5.0329 | 5.0339 | 4994276.0 |
| 2009-06-11 10:55:00 | AAPL | Stock | 5.0341 | 5.0343 | 5.0211 | 5.0239 | 4146744.0 |
| 2009-06-11 11:00:00 | AAPL | Stock | 5.0243 | 5.0275 | 5.0179 | 5.0239 | 3617656.0 |
| 2009-06-11 11:05:00 | AAPL | Stock | 5.0232 | 5.0314 | 5.0214 | 5.025 | 3361624.0 |
| 2009-06-11 11:10:00 | AAPL | Stock | 5.0254 | 5.0411 | 5.0221 | 5.0389 | 5060692.0 |
| 2009-06-11 11:15:00 | AAPL | Stock | 5.0396 | 5.0471 | 5.0325 | 5.0454 | 5132820.0 |
| 2009-06-11 11:20:00 | AAPL | Stock | 5.0454 | 5.0518 | 5.0432 | 5.0511 | 5697888.0 |
| 2009-06-11 11:25:00 | AAPL | Stock | 5.0514 | 5.0518 | 5.045 | 5.0461 | 3460044.0 |
| 2009-06-11 11:30:00 | AAPL | Stock | 5.0467 | 5.0479 | 5.035 | 5.0368 | 5057556.0 |
> showing 50 of 320,501 rows — these rows as CSV