PREVIEW / stock_5min / 2012-12-17
file: by_date/stock_5min/2012/2012-12-17.parquet size: 4.9 MB rows: 333,936 symbols: 3,516
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-12-17 04:00:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.0357 | 18.0793 | 93100.0 |
| 2012-12-17 04:05:00 | AAPL | Stock | 18.0393 | 18.0393 | 18.0386 | 18.0386 | 8400.0 |
| 2012-12-17 04:10:00 | AAPL | Stock | 18.0179 | 18.0321 | 18.0179 | 18.0321 | 11200.0 |
| 2012-12-17 04:15:00 | AAPL | Stock | 18.0532 | 18.0611 | 18.0375 | 18.0375 | 39200.0 |
| 2012-12-17 04:20:00 | AAPL | Stock | 18.0375 | 18.0536 | 18.0375 | 18.0536 | 7700.0 |
| 2012-12-17 04:25:00 | AAPL | Stock | 18.0375 | 18.0375 | 18.0375 | 18.0375 | 10920.0 |
| 2012-12-17 04:30:00 | AAPL | Stock | 18.0179 | 18.0429 | 18.0071 | 18.0429 | 56000.0 |
| 2012-12-17 04:35:00 | AAPL | Stock | 18.0 | 18.0 | 17.9946 | 17.9946 | 8400.0 |
| 2012-12-17 04:40:00 | AAPL | Stock | 17.965 | 17.965 | 17.9379 | 17.9379 | 25032.0 |
| 2012-12-17 04:45:00 | AAPL | Stock | 17.9179 | 17.9179 | 17.9179 | 17.9179 | 2800.0 |
| 2012-12-17 04:50:00 | AAPL | Stock | 17.9175 | 17.9196 | 17.9029 | 17.9089 | 25200.0 |
| 2012-12-17 04:55:00 | AAPL | Stock | 17.9036 | 17.9036 | 17.9 | 17.9 | 32956.0 |
| 2012-12-17 05:00:00 | AAPL | Stock | 17.885 | 17.885 | 17.825 | 17.85 | 65940.0 |
| 2012-12-17 05:05:00 | AAPL | Stock | 17.8304 | 17.8304 | 17.8304 | 17.8304 | 57960.0 |
| 2012-12-17 05:10:00 | AAPL | Stock | 17.8193 | 17.8196 | 17.7875 | 17.7893 | 19600.0 |
| 2012-12-17 05:15:00 | AAPL | Stock | 17.8068 | 17.8104 | 17.7929 | 17.8104 | 25200.0 |
| 2012-12-17 05:20:00 | AAPL | Stock | 17.8214 | 17.8557 | 17.8214 | 17.8557 | 24080.0 |
| 2012-12-17 05:25:00 | AAPL | Stock | 17.85 | 17.8536 | 17.85 | 17.8532 | 14000.0 |
| 2012-12-17 05:30:00 | AAPL | Stock | 17.8411 | 17.8571 | 17.8411 | 17.8571 | 105252.0 |
| 2012-12-17 05:35:00 | AAPL | Stock | 17.8536 | 17.8536 | 17.8536 | 17.8536 | 2800.0 |
| 2012-12-17 05:40:00 | AAPL | Stock | 17.8511 | 17.8511 | 17.8464 | 17.8464 | 16800.0 |
| 2012-12-17 05:45:00 | AAPL | Stock | 17.8536 | 17.8536 | 17.8357 | 17.8357 | 5600.0 |
| 2012-12-17 05:50:00 | AAPL | Stock | 17.8321 | 17.8321 | 17.825 | 17.8293 | 22400.0 |
| 2012-12-17 05:55:00 | AAPL | Stock | 17.8464 | 17.8536 | 17.8375 | 17.8375 | 56000.0 |
| 2012-12-17 06:00:00 | AAPL | Stock | 17.8514 | 17.8514 | 17.8514 | 17.8514 | 5600.0 |
| 2012-12-17 06:05:00 | AAPL | Stock | 17.8321 | 17.8321 | 17.7821 | 17.7821 | 122892.0 |
| 2012-12-17 06:10:00 | AAPL | Stock | 17.7861 | 17.8089 | 17.7857 | 17.7964 | 30800.0 |
| 2012-12-17 06:15:00 | AAPL | Stock | 17.7946 | 17.8029 | 17.7857 | 17.7857 | 30520.0 |
| 2012-12-17 06:20:00 | AAPL | Stock | 17.8161 | 17.8161 | 17.7857 | 17.7857 | 100352.0 |
| 2012-12-17 06:25:00 | AAPL | Stock | 17.7864 | 17.7943 | 17.7679 | 17.7854 | 173768.0 |
| 2012-12-17 06:30:00 | AAPL | Stock | 17.7746 | 17.7821 | 17.7661 | 17.7821 | 47488.0 |
| 2012-12-17 06:35:00 | AAPL | Stock | 17.7679 | 17.7786 | 17.7536 | 17.7536 | 76020.0 |
| 2012-12-17 06:40:00 | AAPL | Stock | 17.7782 | 17.7782 | 17.75 | 17.7589 | 58520.0 |
| 2012-12-17 06:45:00 | AAPL | Stock | 17.7589 | 17.7675 | 17.7389 | 17.7675 | 192864.0 |
| 2012-12-17 06:50:00 | AAPL | Stock | 17.7854 | 17.8393 | 17.7732 | 17.835 | 159432.0 |
| 2012-12-17 06:55:00 | AAPL | Stock | 17.8214 | 17.8218 | 17.8214 | 17.8214 | 73696.0 |
| 2012-12-17 07:00:00 | AAPL | Stock | 17.8393 | 17.8804 | 17.8214 | 17.8682 | 227836.0 |
| 2012-12-17 07:05:00 | AAPL | Stock | 17.8686 | 17.96 | 17.8686 | 17.9282 | 219772.0 |
| 2012-12-17 07:10:00 | AAPL | Stock | 17.9268 | 17.9286 | 17.8625 | 17.8743 | 306264.0 |
| 2012-12-17 07:15:00 | AAPL | Stock | 17.8661 | 17.9286 | 17.85 | 17.9107 | 272748.0 |
| 2012-12-17 07:20:00 | AAPL | Stock | 17.9268 | 17.9286 | 17.9107 | 17.9196 | 114828.0 |
| 2012-12-17 07:25:00 | AAPL | Stock | 17.9125 | 17.95 | 17.9114 | 17.9464 | 124768.0 |
| 2012-12-17 07:30:00 | AAPL | Stock | 17.9557 | 17.9607 | 17.9311 | 17.9554 | 71400.0 |
| 2012-12-17 07:35:00 | AAPL | Stock | 17.9475 | 17.9782 | 17.9454 | 17.9454 | 67284.0 |
| 2012-12-17 07:40:00 | AAPL | Stock | 17.9446 | 17.9464 | 17.9107 | 17.9464 | 212800.0 |
| 2012-12-17 07:45:00 | AAPL | Stock | 17.9386 | 17.9657 | 17.9361 | 17.9646 | 113092.0 |
| 2012-12-17 07:50:00 | AAPL | Stock | 17.9507 | 17.9629 | 17.9386 | 17.9629 | 94612.0 |
| 2012-12-17 07:55:00 | AAPL | Stock | 17.9621 | 18.0179 | 17.9621 | 18.0075 | 359912.0 |
| 2012-12-17 08:00:00 | AAPL | Stock | 18.0214 | 18.0536 | 17.7461 | 18.01 | 1030568.0 |
| 2012-12-17 08:05:00 | AAPL | Stock | 17.9986 | 18.1393 | 17.985 | 18.1071 | 1239336.0 |
> showing 50 of 333,936 rows — these rows as CSV