PREVIEW / stock_5min / 2011-03-17
file: by_date/stock_5min/2011/2011-03-17.parquet size: 4.9 MB rows: 331,781 symbols: 3,517
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-17 04:00:00 | AAPL | Stock | 11.8071 | 11.8082 | 11.8046 | 11.8082 | 16800.0 |
| 2011-03-17 04:05:00 | AAPL | Stock | 11.82 | 11.8589 | 11.82 | 11.8504 | 58800.0 |
| 2011-03-17 04:10:00 | AAPL | Stock | 11.8571 | 11.8757 | 11.8571 | 11.8679 | 36400.0 |
| 2011-03-17 04:15:00 | AAPL | Stock | 11.875 | 11.875 | 11.875 | 11.875 | 25200.0 |
| 2011-03-17 04:20:00 | AAPL | Stock | 11.8464 | 11.8464 | 11.8464 | 11.8464 | 2800.0 |
| 2011-03-17 04:30:00 | AAPL | Stock | 11.8214 | 11.8493 | 11.8214 | 11.8493 | 33600.0 |
| 2011-03-17 04:35:00 | AAPL | Stock | 11.8329 | 11.8329 | 11.8257 | 11.8257 | 5600.0 |
| 2011-03-17 04:40:00 | AAPL | Stock | 11.825 | 11.825 | 11.825 | 11.825 | 2800.0 |
| 2011-03-17 04:50:00 | AAPL | Stock | 11.85 | 11.85 | 11.8407 | 11.8407 | 25200.0 |
| 2011-03-17 04:55:00 | AAPL | Stock | 11.8514 | 11.8571 | 11.8214 | 11.8214 | 30800.0 |
| 2011-03-17 05:00:00 | AAPL | Stock | 11.8304 | 11.8304 | 11.8218 | 11.8218 | 8400.0 |
| 2011-03-17 05:05:00 | AAPL | Stock | 11.8286 | 11.8286 | 11.8286 | 11.8286 | 2800.0 |
| 2011-03-17 05:10:00 | AAPL | Stock | 11.8521 | 11.8521 | 11.8521 | 11.8521 | 2800.0 |
| 2011-03-17 05:15:00 | AAPL | Stock | 11.8589 | 11.8857 | 11.8536 | 11.8536 | 22400.0 |
| 2011-03-17 05:20:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 5600.0 |
| 2011-03-17 05:25:00 | AAPL | Stock | 11.8393 | 11.8571 | 11.8393 | 11.8571 | 32200.0 |
| 2011-03-17 05:30:00 | AAPL | Stock | 11.8571 | 11.8571 | 11.8571 | 11.8571 | 2800.0 |
| 2011-03-17 05:35:00 | AAPL | Stock | 11.875 | 11.875 | 11.875 | 11.875 | 16800.0 |
| 2011-03-17 05:40:00 | AAPL | Stock | 11.875 | 11.8857 | 11.8671 | 11.8671 | 22400.0 |
| 2011-03-17 05:45:00 | AAPL | Stock | 11.8654 | 11.8654 | 11.8654 | 11.8654 | 2800.0 |
| 2011-03-17 06:00:00 | AAPL | Stock | 11.8575 | 11.8575 | 11.8575 | 11.8575 | 11200.0 |
| 2011-03-17 06:05:00 | AAPL | Stock | 11.8575 | 11.8714 | 11.8575 | 11.8714 | 16800.0 |
| 2011-03-17 06:10:00 | AAPL | Stock | 11.8575 | 11.8575 | 11.8575 | 11.8575 | 11200.0 |
| 2011-03-17 06:15:00 | AAPL | Stock | 11.8604 | 11.8604 | 11.8604 | 11.8604 | 2800.0 |
| 2011-03-17 06:20:00 | AAPL | Stock | 11.8575 | 11.875 | 11.8575 | 11.875 | 8400.0 |
| 2011-03-17 06:25:00 | AAPL | Stock | 11.8732 | 11.8732 | 11.8679 | 11.8679 | 5600.0 |
| 2011-03-17 06:30:00 | AAPL | Stock | 11.8632 | 11.8689 | 11.8575 | 11.8689 | 19600.0 |
| 2011-03-17 06:35:00 | AAPL | Stock | 11.8686 | 11.8714 | 11.8575 | 11.8575 | 77980.0 |
| 2011-03-17 06:40:00 | AAPL | Stock | 11.8575 | 11.8643 | 11.8214 | 11.8214 | 220360.0 |
| 2011-03-17 06:45:00 | AAPL | Stock | 11.8214 | 11.8214 | 11.8214 | 11.8214 | 28000.0 |
| 2011-03-17 06:55:00 | AAPL | Stock | 11.8321 | 11.8321 | 11.8321 | 11.8321 | 8400.0 |
| 2011-03-17 07:00:00 | AAPL | Stock | 11.8432 | 11.8518 | 11.8268 | 11.8464 | 135520.0 |
| 2011-03-17 07:05:00 | AAPL | Stock | 11.8393 | 11.8568 | 11.8393 | 11.8446 | 13300.0 |
| 2011-03-17 07:10:00 | AAPL | Stock | 11.8561 | 11.8561 | 11.8446 | 11.85 | 86800.0 |
| 2011-03-17 07:15:00 | AAPL | Stock | 11.85 | 11.8618 | 11.85 | 11.8532 | 95368.0 |
| 2011-03-17 07:20:00 | AAPL | Stock | 11.8393 | 11.8482 | 11.8379 | 11.8464 | 30800.0 |
| 2011-03-17 07:25:00 | AAPL | Stock | 11.8389 | 11.8439 | 11.83 | 11.8429 | 37800.0 |
| 2011-03-17 07:30:00 | AAPL | Stock | 11.8454 | 11.8482 | 11.8421 | 11.8421 | 25200.0 |
| 2011-03-17 07:35:00 | AAPL | Stock | 11.8464 | 11.8604 | 11.8429 | 11.8604 | 114156.0 |
| 2011-03-17 07:40:00 | AAPL | Stock | 11.8596 | 11.8839 | 11.85 | 11.8839 | 895972.0 |
| 2011-03-17 07:45:00 | AAPL | Stock | 11.8839 | 11.8839 | 11.875 | 11.875 | 309316.0 |
| 2011-03-17 07:50:00 | AAPL | Stock | 11.875 | 11.8954 | 11.8686 | 11.8907 | 436408.0 |
| 2011-03-17 07:55:00 | AAPL | Stock | 11.8907 | 11.9 | 11.8786 | 11.885 | 84000.0 |
| 2011-03-17 08:00:00 | AAPL | Stock | 11.8775 | 11.9107 | 11.8714 | 11.9079 | 1103760.0 |
| 2011-03-17 08:05:00 | AAPL | Stock | 11.9079 | 11.9164 | 11.9 | 11.9046 | 589820.0 |
| 2011-03-17 08:10:00 | AAPL | Stock | 11.9071 | 11.9221 | 11.9071 | 11.9204 | 450100.0 |
| 2011-03-17 08:15:00 | AAPL | Stock | 11.9196 | 11.955 | 11.9196 | 11.9464 | 915908.0 |
| 2011-03-17 08:20:00 | AAPL | Stock | 11.9464 | 11.9689 | 11.9357 | 11.9689 | 788788.0 |
| 2011-03-17 08:25:00 | AAPL | Stock | 11.9679 | 11.9911 | 11.9607 | 11.9671 | 1424248.0 |
| 2011-03-17 08:30:00 | AAPL | Stock | 11.9643 | 11.9714 | 11.9486 | 11.97 | 851284.0 |
> showing 50 of 331,781 rows — these rows as CSV