PREVIEW / stock_5min / 2012-12-18
file: by_date/stock_5min/2012/2012-12-18.parquet size: 5.1 MB rows: 339,641 symbols: 3,510
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-18 04:00:00 | AAPL | Stock | 18.7429 | 18.7918 | 18.7196 | 18.72 | 50064.0 |
| 2012-12-18 04:05:00 | AAPL | Stock | 18.7189 | 18.7493 | 18.7189 | 18.7493 | 8400.0 |
| 2012-12-18 04:10:00 | AAPL | Stock | 18.75 | 18.75 | 18.7493 | 18.7493 | 8820.0 |
| 2012-12-18 04:15:00 | AAPL | Stock | 18.7464 | 18.7464 | 18.7461 | 18.7461 | 8400.0 |
| 2012-12-18 04:20:00 | AAPL | Stock | 18.7464 | 18.7464 | 18.7464 | 18.7464 | 2800.0 |
| 2012-12-18 04:25:00 | AAPL | Stock | 18.7321 | 18.7321 | 18.7143 | 18.7164 | 24640.0 |
| 2012-12-18 04:30:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 2800.0 |
| 2012-12-18 04:35:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 5600.0 |
| 2012-12-18 04:40:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 29960.0 |
| 2012-12-18 04:45:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7071 | 18.7071 | 8400.0 |
| 2012-12-18 04:50:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 14000.0 |
| 2012-12-18 04:55:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 2800.0 |
| 2012-12-18 05:00:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7018 | 18.7143 | 11200.0 |
| 2012-12-18 05:05:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 2800.0 |
| 2012-12-18 05:10:00 | AAPL | Stock | 18.7161 | 18.7161 | 18.7161 | 18.7161 | 5600.0 |
| 2012-12-18 05:20:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7143 | 18.7143 | 12600.0 |
| 2012-12-18 05:25:00 | AAPL | Stock | 18.7143 | 18.7143 | 18.7079 | 18.7079 | 5600.0 |
| 2012-12-18 05:30:00 | AAPL | Stock | 18.7018 | 18.7018 | 18.6946 | 18.6946 | 25200.0 |
| 2012-12-18 05:40:00 | AAPL | Stock | 18.6786 | 18.6786 | 18.6714 | 18.6714 | 9800.0 |
| 2012-12-18 05:45:00 | AAPL | Stock | 18.6661 | 18.6661 | 18.5911 | 18.5911 | 14000.0 |
| 2012-12-18 05:50:00 | AAPL | Stock | 18.5946 | 18.5946 | 18.5946 | 18.5946 | 2800.0 |
| 2012-12-18 05:55:00 | AAPL | Stock | 18.6107 | 18.6275 | 18.6107 | 18.6275 | 5600.0 |
| 2012-12-18 06:00:00 | AAPL | Stock | 18.6271 | 18.63 | 18.6271 | 18.63 | 5600.0 |
| 2012-12-18 06:05:00 | AAPL | Stock | 18.6268 | 18.6268 | 18.6254 | 18.6254 | 8400.0 |
| 2012-12-18 06:10:00 | AAPL | Stock | 18.6411 | 18.6411 | 18.6411 | 18.6411 | 3360.0 |
| 2012-12-18 06:15:00 | AAPL | Stock | 18.6411 | 18.6411 | 18.6411 | 18.6411 | 8400.0 |
| 2012-12-18 06:20:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 26600.0 |
| 2012-12-18 06:35:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6346 | 18.6346 | 8400.0 |
| 2012-12-18 06:40:00 | AAPL | Stock | 18.6375 | 18.6375 | 18.6254 | 18.6339 | 33880.0 |
| 2012-12-18 06:45:00 | AAPL | Stock | 18.6339 | 18.6339 | 18.6071 | 18.6071 | 28000.0 |
| 2012-12-18 06:50:00 | AAPL | Stock | 18.6143 | 18.6143 | 18.6071 | 18.6071 | 16800.0 |
| 2012-12-18 06:55:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 4452.0 |
| 2012-12-18 07:00:00 | AAPL | Stock | 18.5982 | 18.6339 | 18.5946 | 18.6071 | 112000.0 |
| 2012-12-18 07:05:00 | AAPL | Stock | 18.5971 | 18.6429 | 18.5971 | 18.6429 | 169400.0 |
| 2012-12-18 07:10:00 | AAPL | Stock | 18.6429 | 18.6604 | 18.6 | 18.6071 | 377076.0 |
| 2012-12-18 07:15:00 | AAPL | Stock | 18.6093 | 18.6196 | 18.6071 | 18.6196 | 57120.0 |
| 2012-12-18 07:20:00 | AAPL | Stock | 18.6268 | 18.6964 | 18.6125 | 18.6889 | 480900.0 |
| 2012-12-18 07:25:00 | AAPL | Stock | 18.6893 | 18.7425 | 18.6893 | 18.7321 | 618436.0 |
| 2012-12-18 07:30:00 | AAPL | Stock | 18.7321 | 18.7471 | 18.7307 | 18.7329 | 414624.0 |
| 2012-12-18 07:35:00 | AAPL | Stock | 18.7179 | 18.75 | 18.7143 | 18.7368 | 449176.0 |
| 2012-12-18 07:40:00 | AAPL | Stock | 18.7446 | 18.7493 | 18.7357 | 18.7361 | 114436.0 |
| 2012-12-18 07:45:00 | AAPL | Stock | 18.7368 | 18.7425 | 18.7143 | 18.7407 | 255808.0 |
| 2012-12-18 07:50:00 | AAPL | Stock | 18.7386 | 18.7786 | 18.7386 | 18.7786 | 422212.0 |
| 2012-12-18 07:55:00 | AAPL | Stock | 18.7814 | 18.8214 | 18.7789 | 18.8125 | 769636.0 |
| 2012-12-18 08:00:00 | AAPL | Stock | 18.8096 | 18.8518 | 18.7143 | 18.8393 | 1872024.0 |
| 2012-12-18 08:05:00 | AAPL | Stock | 18.8429 | 18.85 | 18.8125 | 18.8129 | 1272432.0 |
| 2012-12-18 08:10:00 | AAPL | Stock | 18.81 | 18.8157 | 18.7789 | 18.7929 | 830088.0 |
| 2012-12-18 08:15:00 | AAPL | Stock | 18.7925 | 18.7939 | 18.7836 | 18.7929 | 809592.0 |
| 2012-12-18 08:20:00 | AAPL | Stock | 18.7929 | 18.8086 | 18.7593 | 18.7807 | 1202348.0 |
| 2012-12-18 08:25:00 | AAPL | Stock | 18.78 | 18.7857 | 18.7593 | 18.7775 | 419580.0 |
> showing 50 of 339,641 rows — these rows as CSV