PREVIEW / stock_5min / 2012-09-26
file: by_date/stock_5min/2012/2012-09-26.parquet size: 4.8 MB rows: 322,331 symbols: 3,459
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 |
|---|---|---|---|---|---|---|---|
| 2012-09-26 04:00:00 | AAPL | Stock | 24.1025 | 24.1025 | 24.0714 | 24.0714 | 39200.0 |
| 2012-09-26 04:10:00 | AAPL | Stock | 24.0714 | 24.0714 | 24.0714 | 24.0714 | 5600.0 |
| 2012-09-26 04:15:00 | AAPL | Stock | 24.0625 | 24.0625 | 24.0625 | 24.0625 | 14000.0 |
| 2012-09-26 04:25:00 | AAPL | Stock | 24.0536 | 24.0536 | 24.0446 | 24.0446 | 10920.0 |
| 2012-09-26 04:30:00 | AAPL | Stock | 24.0075 | 24.0075 | 24.0075 | 24.0075 | 2800.0 |
| 2012-09-26 04:35:00 | AAPL | Stock | 24.0182 | 24.0182 | 24.0182 | 24.0182 | 2800.0 |
| 2012-09-26 04:50:00 | AAPL | Stock | 24.0625 | 24.0625 | 24.0625 | 24.0625 | 11900.0 |
| 2012-09-26 04:55:00 | AAPL | Stock | 24.0714 | 24.0714 | 24.0714 | 24.0714 | 5600.0 |
| 2012-09-26 05:05:00 | AAPL | Stock | 24.0857 | 24.0857 | 24.0857 | 24.0857 | 5600.0 |
| 2012-09-26 05:10:00 | AAPL | Stock | 24.0893 | 24.0893 | 24.0893 | 24.0893 | 11200.0 |
| 2012-09-26 05:25:00 | AAPL | Stock | 24.0893 | 24.0893 | 24.0893 | 24.0893 | 2800.0 |
| 2012-09-26 05:30:00 | AAPL | Stock | 24.0893 | 24.0893 | 24.0893 | 24.0893 | 5600.0 |
| 2012-09-26 06:30:00 | AAPL | Stock | 24.0643 | 24.0643 | 24.0643 | 24.0643 | 2800.0 |
| 2012-09-26 06:45:00 | AAPL | Stock | 24.0479 | 24.0482 | 24.0479 | 24.0482 | 14000.0 |
| 2012-09-26 06:50:00 | AAPL | Stock | 24.0211 | 24.0254 | 24.0211 | 24.0232 | 18060.0 |
| 2012-09-26 06:55:00 | AAPL | Stock | 24.0268 | 24.0268 | 24.0211 | 24.0211 | 5600.0 |
| 2012-09-26 07:00:00 | AAPL | Stock | 24.0357 | 24.0511 | 24.0357 | 24.0482 | 53200.0 |
| 2012-09-26 07:10:00 | AAPL | Stock | 24.0357 | 24.0357 | 24.0357 | 24.0357 | 2800.0 |
| 2012-09-26 07:15:00 | AAPL | Stock | 24.0357 | 24.0439 | 24.0357 | 24.0421 | 22400.0 |
| 2012-09-26 07:20:00 | AAPL | Stock | 24.0357 | 24.0357 | 24.0 | 24.0004 | 72436.0 |
| 2012-09-26 07:30:00 | AAPL | Stock | 24.0014 | 24.0014 | 23.9575 | 23.9707 | 68320.0 |
| 2012-09-26 07:35:00 | AAPL | Stock | 23.9664 | 23.9664 | 23.9464 | 23.9464 | 60172.0 |
| 2012-09-26 07:40:00 | AAPL | Stock | 23.9396 | 23.9464 | 23.8982 | 23.9143 | 136444.0 |
| 2012-09-26 07:45:00 | AAPL | Stock | 23.9246 | 23.9429 | 23.9143 | 23.9321 | 103264.0 |
| 2012-09-26 07:50:00 | AAPL | Stock | 23.9393 | 23.9607 | 23.9357 | 23.9607 | 136780.0 |
| 2012-09-26 07:55:00 | AAPL | Stock | 23.9607 | 23.9607 | 23.9429 | 23.9432 | 28700.0 |
| 2012-09-26 08:00:00 | AAPL | Stock | 23.9518 | 24.0661 | 23.9143 | 24.0307 | 552244.0 |
| 2012-09-26 08:05:00 | AAPL | Stock | 24.0232 | 24.0232 | 23.9875 | 23.9929 | 182644.0 |
| 2012-09-26 08:10:00 | AAPL | Stock | 23.9893 | 23.9929 | 23.9571 | 23.9643 | 132076.0 |
| 2012-09-26 08:15:00 | AAPL | Stock | 23.9518 | 23.9536 | 23.9404 | 23.9457 | 130676.0 |
| 2012-09-26 08:20:00 | AAPL | Stock | 23.9436 | 23.9464 | 23.9179 | 23.9189 | 125160.0 |
| 2012-09-26 08:25:00 | AAPL | Stock | 23.9229 | 23.9639 | 23.9196 | 23.9639 | 364028.0 |
| 2012-09-26 08:30:00 | AAPL | Stock | 23.9654 | 23.9782 | 23.9557 | 23.9557 | 132552.0 |
| 2012-09-26 08:35:00 | AAPL | Stock | 23.9625 | 23.9636 | 23.9479 | 23.95 | 156184.0 |
| 2012-09-26 08:40:00 | AAPL | Stock | 23.9554 | 23.9554 | 23.9364 | 23.9464 | 233184.0 |
| 2012-09-26 08:45:00 | AAPL | Stock | 23.9375 | 23.9411 | 23.9196 | 23.9196 | 229880.0 |
| 2012-09-26 08:50:00 | AAPL | Stock | 23.9214 | 23.9464 | 23.9211 | 23.9464 | 429716.0 |
| 2012-09-26 08:55:00 | AAPL | Stock | 23.9464 | 23.9582 | 23.9429 | 23.9464 | 144312.0 |
| 2012-09-26 09:00:00 | AAPL | Stock | 23.9446 | 23.96 | 23.9446 | 23.9504 | 169092.0 |
| 2012-09-26 09:05:00 | AAPL | Stock | 23.9586 | 23.9593 | 23.9471 | 23.9554 | 156100.0 |
| 2012-09-26 09:10:00 | AAPL | Stock | 23.9579 | 23.9643 | 23.9496 | 23.9636 | 265440.0 |
| 2012-09-26 09:15:00 | AAPL | Stock | 23.9575 | 23.9582 | 23.9343 | 23.9389 | 167720.0 |
| 2012-09-26 09:20:00 | AAPL | Stock | 23.9454 | 23.9489 | 23.9357 | 23.9357 | 192052.0 |
| 2012-09-26 09:25:00 | AAPL | Stock | 23.9357 | 23.9468 | 23.8739 | 23.8789 | 1450400.0 |
| 2012-09-26 09:30:00 | AAPL | Stock | 23.8832 | 23.8893 | 23.6964 | 23.8621 | 44292892.0 |
| 2012-09-26 09:35:00 | AAPL | Stock | 23.8679 | 23.9246 | 23.8029 | 23.8854 | 23827356.0 |
| 2012-09-26 09:40:00 | AAPL | Stock | 23.8857 | 23.8929 | 23.7571 | 23.7946 | 16598120.0 |
| 2012-09-26 09:45:00 | AAPL | Stock | 23.7918 | 23.8054 | 23.625 | 23.7061 | 25647300.0 |
| 2012-09-26 09:50:00 | AAPL | Stock | 23.7061 | 23.7836 | 23.6964 | 23.7696 | 15311520.0 |
| 2012-09-26 09:55:00 | AAPL | Stock | 23.7682 | 23.7718 | 23.7232 | 23.767 | 8424192.0 |
> showing 50 of 322,331 rows — these rows as CSV