PREVIEW / stock_5min / 2013-08-06
file: by_date/stock_5min/2013/2013-08-06.parquet size: 5.2 MB rows: 342,192 symbols: 3,512
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-06 04:00:00 | AAPL | Stock | 16.7739 | 16.7768 | 16.7739 | 16.7768 | 11200.0 |
| 2013-08-06 05:30:00 | AAPL | Stock | 16.7257 | 16.7321 | 16.7257 | 16.7321 | 5600.0 |
| 2013-08-06 05:35:00 | AAPL | Stock | 16.7321 | 16.7321 | 16.7321 | 16.7321 | 2800.0 |
| 2013-08-06 06:00:00 | AAPL | Stock | 16.7679 | 16.7679 | 16.7679 | 16.7679 | 6748.0 |
| 2013-08-06 06:05:00 | AAPL | Stock | 16.7768 | 16.7768 | 16.7768 | 16.7768 | 2800.0 |
| 2013-08-06 06:10:00 | AAPL | Stock | 16.7679 | 16.7679 | 16.7679 | 16.7679 | 2800.0 |
| 2013-08-06 06:20:00 | AAPL | Stock | 16.7589 | 16.7589 | 16.7589 | 16.7589 | 12320.0 |
| 2013-08-06 06:25:00 | AAPL | Stock | 16.75 | 16.75 | 16.7446 | 16.7446 | 21280.0 |
| 2013-08-06 06:30:00 | AAPL | Stock | 16.7214 | 16.7214 | 16.7214 | 16.7214 | 4200.0 |
| 2013-08-06 06:50:00 | AAPL | Stock | 16.7196 | 16.7196 | 16.6964 | 16.6964 | 57316.0 |
| 2013-08-06 07:00:00 | AAPL | Stock | 16.7139 | 16.7139 | 16.7139 | 16.7139 | 2800.0 |
| 2013-08-06 07:05:00 | AAPL | Stock | 16.6964 | 16.7146 | 16.6964 | 16.7146 | 5600.0 |
| 2013-08-06 07:10:00 | AAPL | Stock | 16.7214 | 16.7214 | 16.7214 | 16.7214 | 2800.0 |
| 2013-08-06 07:15:00 | AAPL | Stock | 16.7268 | 16.7429 | 16.7268 | 16.7321 | 28280.0 |
| 2013-08-06 07:25:00 | AAPL | Stock | 16.7404 | 16.7404 | 16.7404 | 16.7404 | 2800.0 |
| 2013-08-06 07:30:00 | AAPL | Stock | 16.7357 | 16.7357 | 16.7357 | 16.7357 | 2800.0 |
| 2013-08-06 07:45:00 | AAPL | Stock | 16.725 | 16.725 | 16.725 | 16.725 | 8400.0 |
| 2013-08-06 07:50:00 | AAPL | Stock | 16.725 | 16.725 | 16.7214 | 16.7214 | 5600.0 |
| 2013-08-06 07:55:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 5292.0 |
| 2013-08-06 08:00:00 | AAPL | Stock | 16.705 | 16.7407 | 16.705 | 16.7193 | 97580.0 |
| 2013-08-06 08:05:00 | AAPL | Stock | 16.725 | 16.725 | 16.7071 | 16.7161 | 63644.0 |
| 2013-08-06 08:10:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7139 | 16.7139 | 19880.0 |
| 2013-08-06 08:15:00 | AAPL | Stock | 16.7214 | 16.7282 | 16.7214 | 16.7214 | 12600.0 |
| 2013-08-06 08:20:00 | AAPL | Stock | 16.7214 | 16.7286 | 16.7179 | 16.7182 | 29568.0 |
| 2013-08-06 08:25:00 | AAPL | Stock | 16.7214 | 16.7286 | 16.7214 | 16.7286 | 33880.0 |
| 2013-08-06 08:30:00 | AAPL | Stock | 16.725 | 16.7357 | 16.725 | 16.7357 | 86800.0 |
| 2013-08-06 08:35:00 | AAPL | Stock | 16.7411 | 16.7479 | 16.7386 | 16.7479 | 46200.0 |
| 2013-08-06 08:40:00 | AAPL | Stock | 16.7479 | 16.7479 | 16.7375 | 16.7375 | 118328.0 |
| 2013-08-06 08:45:00 | AAPL | Stock | 16.7393 | 16.7393 | 16.725 | 16.7332 | 141988.0 |
| 2013-08-06 08:50:00 | AAPL | Stock | 16.7343 | 16.7389 | 16.7254 | 16.7325 | 82936.0 |
| 2013-08-06 08:55:00 | AAPL | Stock | 16.735 | 16.7361 | 16.7268 | 16.7314 | 110068.0 |
| 2013-08-06 09:00:00 | AAPL | Stock | 16.7314 | 16.7375 | 16.7304 | 16.7371 | 67200.0 |
| 2013-08-06 09:05:00 | AAPL | Stock | 16.7375 | 16.7393 | 16.7354 | 16.7354 | 39200.0 |
| 2013-08-06 09:10:00 | AAPL | Stock | 16.7379 | 16.7389 | 16.7325 | 16.7325 | 19600.0 |
| 2013-08-06 09:15:00 | AAPL | Stock | 16.7339 | 16.7368 | 16.7325 | 16.7368 | 67200.0 |
| 2013-08-06 09:20:00 | AAPL | Stock | 16.7368 | 16.7457 | 16.735 | 16.7457 | 98000.0 |
| 2013-08-06 09:25:00 | AAPL | Stock | 16.7393 | 16.7396 | 16.7068 | 16.7146 | 133140.0 |
| 2013-08-06 09:30:00 | AAPL | Stock | 16.715 | 16.775 | 16.7143 | 16.7586 | 11464516.0 |
| 2013-08-06 09:35:00 | AAPL | Stock | 16.7571 | 16.8264 | 16.7471 | 16.82 | 10448116.0 |
| 2013-08-06 09:40:00 | AAPL | Stock | 16.8193 | 16.8532 | 16.815 | 16.8433 | 10123456.0 |
| 2013-08-06 09:45:00 | AAPL | Stock | 16.8386 | 16.8436 | 16.7957 | 16.8339 | 8131144.0 |
| 2013-08-06 09:50:00 | AAPL | Stock | 16.8304 | 16.8454 | 16.7739 | 16.7816 | 7517412.0 |
| 2013-08-06 09:55:00 | AAPL | Stock | 16.7846 | 16.8054 | 16.7404 | 16.805 | 10110100.0 |
| 2013-08-06 10:00:00 | AAPL | Stock | 16.8054 | 16.8218 | 16.7725 | 16.7921 | 5641748.0 |
| 2013-08-06 10:05:00 | AAPL | Stock | 16.7975 | 16.8079 | 16.7886 | 16.8036 | 2678564.0 |
| 2013-08-06 10:10:00 | AAPL | Stock | 16.8036 | 16.8143 | 16.7768 | 16.8075 | 4799004.0 |
| 2013-08-06 10:15:00 | AAPL | Stock | 16.8046 | 16.8046 | 16.7786 | 16.7875 | 2914464.0 |
| 2013-08-06 10:20:00 | AAPL | Stock | 16.7864 | 16.7911 | 16.7336 | 16.7465 | 6702136.0 |
| 2013-08-06 10:25:00 | AAPL | Stock | 16.7486 | 16.7736 | 16.7421 | 16.7621 | 4349240.0 |
| 2013-08-06 10:30:00 | AAPL | Stock | 16.7639 | 16.7668 | 16.7214 | 16.7296 | 4583180.0 |
> showing 50 of 342,192 rows — these rows as CSV