PREVIEW / stock_5min / 2014-02-03
file: by_date/stock_5min/2014/2014-02-03.parquet size: 5.9 MB rows: 383,553 symbols: 3,547
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-03 05:35:00 | AAPL | Stock | 17.8571 | 17.8571 | 17.8571 | 17.8571 | 2800.0 |
| 2014-02-03 06:05:00 | AAPL | Stock | 17.8089 | 17.8089 | 17.8089 | 17.8089 | 3388.0 |
| 2014-02-03 06:30:00 | AAPL | Stock | 17.8214 | 17.8214 | 17.8214 | 17.8214 | 13328.0 |
| 2014-02-03 06:35:00 | AAPL | Stock | 17.8379 | 17.8379 | 17.8379 | 17.8379 | 2800.0 |
| 2014-02-03 06:40:00 | AAPL | Stock | 17.8493 | 17.8571 | 17.8493 | 17.8571 | 55104.0 |
| 2014-02-03 06:45:00 | AAPL | Stock | 17.8411 | 17.8411 | 17.8411 | 17.8411 | 4788.0 |
| 2014-02-03 06:50:00 | AAPL | Stock | 17.8482 | 17.8482 | 17.8482 | 17.8482 | 2800.0 |
| 2014-02-03 07:10:00 | AAPL | Stock | 17.91 | 17.9143 | 17.91 | 17.9143 | 47600.0 |
| 2014-02-03 07:15:00 | AAPL | Stock | 17.9196 | 17.9196 | 17.9196 | 17.9196 | 2800.0 |
| 2014-02-03 07:25:00 | AAPL | Stock | 17.9218 | 17.9361 | 17.9218 | 17.9271 | 12320.0 |
| 2014-02-03 07:30:00 | AAPL | Stock | 17.9375 | 17.9429 | 17.9375 | 17.9429 | 24080.0 |
| 2014-02-03 07:35:00 | AAPL | Stock | 17.9261 | 17.9307 | 17.9261 | 17.9279 | 16576.0 |
| 2014-02-03 07:50:00 | AAPL | Stock | 17.9093 | 17.9279 | 17.8946 | 17.9279 | 53788.0 |
| 2014-02-03 07:55:00 | AAPL | Stock | 17.9268 | 17.9429 | 17.915 | 17.9429 | 75600.0 |
| 2014-02-03 08:00:00 | AAPL | Stock | 17.9321 | 17.9821 | 17.8932 | 17.9643 | 121156.0 |
| 2014-02-03 08:05:00 | AAPL | Stock | 17.9554 | 17.9821 | 17.9554 | 17.9764 | 142240.0 |
| 2014-02-03 08:10:00 | AAPL | Stock | 17.9696 | 17.9732 | 17.9643 | 17.9732 | 45360.0 |
| 2014-02-03 08:15:00 | AAPL | Stock | 17.9732 | 18.035 | 17.9732 | 18.025 | 421064.0 |
| 2014-02-03 08:20:00 | AAPL | Stock | 18.0229 | 18.0321 | 18.0179 | 18.025 | 125300.0 |
| 2014-02-03 08:25:00 | AAPL | Stock | 18.0257 | 18.0257 | 17.9975 | 18.0089 | 192164.0 |
| 2014-02-03 08:30:00 | AAPL | Stock | 18.0021 | 18.0089 | 17.9714 | 17.9821 | 141624.0 |
| 2014-02-03 08:35:00 | AAPL | Stock | 17.9818 | 17.9907 | 17.9732 | 17.9907 | 80248.0 |
| 2014-02-03 08:40:00 | AAPL | Stock | 17.9911 | 17.9911 | 17.9696 | 17.9732 | 117264.0 |
| 2014-02-03 08:45:00 | AAPL | Stock | 17.9725 | 17.9807 | 17.9543 | 17.9543 | 119644.0 |
| 2014-02-03 08:50:00 | AAPL | Stock | 17.9561 | 17.9721 | 17.9561 | 17.9568 | 95004.0 |
| 2014-02-03 08:55:00 | AAPL | Stock | 17.9554 | 17.9654 | 17.9518 | 17.9654 | 117348.0 |
| 2014-02-03 09:00:00 | AAPL | Stock | 17.9646 | 17.9654 | 17.9589 | 17.9654 | 53172.0 |
| 2014-02-03 09:05:00 | AAPL | Stock | 17.9654 | 17.9679 | 17.9496 | 17.9496 | 39200.0 |
| 2014-02-03 09:10:00 | AAPL | Stock | 17.9493 | 17.95 | 17.9368 | 17.9421 | 36288.0 |
| 2014-02-03 09:15:00 | AAPL | Stock | 17.935 | 17.9446 | 17.8786 | 17.9368 | 37380.0 |
| 2014-02-03 09:20:00 | AAPL | Stock | 17.9321 | 17.9371 | 17.9179 | 17.9179 | 212240.0 |
| 2014-02-03 09:25:00 | AAPL | Stock | 17.9243 | 17.9675 | 17.9243 | 17.9593 | 372344.0 |
| 2014-02-03 09:30:00 | AAPL | Stock | 17.9504 | 18.0166 | 17.9364 | 18.0139 | 13614384.0 |
| 2014-02-03 09:35:00 | AAPL | Stock | 18.0161 | 18.0939 | 18.0029 | 18.0789 | 12362952.0 |
| 2014-02-03 09:40:00 | AAPL | Stock | 18.0736 | 18.0893 | 18.0418 | 18.0534 | 8104544.0 |
| 2014-02-03 09:45:00 | AAPL | Stock | 18.0536 | 18.0599 | 18.0189 | 18.0321 | 7951496.0 |
| 2014-02-03 09:50:00 | AAPL | Stock | 18.0314 | 18.0832 | 18.0161 | 18.0832 | 7566692.0 |
| 2014-02-03 09:55:00 | AAPL | Stock | 18.0832 | 18.1332 | 18.0779 | 18.1182 | 9730084.0 |
| 2014-02-03 10:00:00 | AAPL | Stock | 18.1136 | 18.1186 | 18.0357 | 18.0379 | 8799504.0 |
| 2014-02-03 10:05:00 | AAPL | Stock | 18.0382 | 18.0804 | 18.0321 | 18.0611 | 5501020.0 |
| 2014-02-03 10:10:00 | AAPL | Stock | 18.0657 | 18.07 | 18.0221 | 18.0404 | 7789600.0 |
| 2014-02-03 10:15:00 | AAPL | Stock | 18.0479 | 18.0479 | 17.9221 | 17.9361 | 7774928.0 |
| 2014-02-03 10:20:00 | AAPL | Stock | 17.9329 | 17.9679 | 17.9161 | 17.9611 | 6120940.0 |
| 2014-02-03 10:25:00 | AAPL | Stock | 17.9611 | 17.9864 | 17.9107 | 17.9843 | 5497716.0 |
| 2014-02-03 10:30:00 | AAPL | Stock | 17.9839 | 18.0246 | 17.9565 | 18.0143 | 5028968.0 |
| 2014-02-03 10:35:00 | AAPL | Stock | 18.0157 | 18.0357 | 17.9921 | 18.0129 | 4826528.0 |
| 2014-02-03 10:40:00 | AAPL | Stock | 18.0061 | 18.0396 | 18.0057 | 18.0311 | 3736712.0 |
| 2014-02-03 10:45:00 | AAPL | Stock | 18.0357 | 18.0411 | 18.0004 | 18.0021 | 2270660.0 |
| 2014-02-03 10:50:00 | AAPL | Stock | 18.0121 | 18.0161 | 17.9729 | 17.9919 | 3059280.0 |
| 2014-02-03 10:55:00 | AAPL | Stock | 17.995 | 18.0268 | 17.9851 | 18.0182 | 2489816.0 |
> showing 50 of 383,553 rows — these rows as CSV