PREVIEW / stock_5min / 2012-10-26
file: by_date/stock_5min/2012/2012-10-26.parquet size: 4.6 MB rows: 308,716 symbols: 3,465
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-10-26 04:00:00 | AAPL | Stock | 21.7143 | 21.7143 | 21.6432 | 21.6432 | 13440.0 |
| 2012-10-26 04:05:00 | AAPL | Stock | 21.6618 | 21.6618 | 21.6618 | 21.6618 | 8400.0 |
| 2012-10-26 04:10:00 | AAPL | Stock | 21.6696 | 21.6696 | 21.6607 | 21.6607 | 5880.0 |
| 2012-10-26 04:15:00 | AAPL | Stock | 21.6607 | 21.6786 | 21.6429 | 21.6786 | 68936.0 |
| 2012-10-26 04:20:00 | AAPL | Stock | 21.7161 | 21.7857 | 21.7161 | 21.7857 | 140728.0 |
| 2012-10-26 04:25:00 | AAPL | Stock | 21.7893 | 21.7893 | 21.7893 | 21.7893 | 2800.0 |
| 2012-10-26 04:30:00 | AAPL | Stock | 21.7861 | 21.8393 | 21.7857 | 21.8214 | 82152.0 |
| 2012-10-26 04:40:00 | AAPL | Stock | 21.7857 | 21.7929 | 21.7857 | 21.7929 | 40600.0 |
| 2012-10-26 04:45:00 | AAPL | Stock | 21.7857 | 21.7857 | 21.7857 | 21.7857 | 66472.0 |
| 2012-10-26 04:50:00 | AAPL | Stock | 21.7857 | 21.7857 | 21.7536 | 21.7536 | 77000.0 |
| 2012-10-26 04:55:00 | AAPL | Stock | 21.7857 | 21.7857 | 21.7857 | 21.7857 | 83440.0 |
| 2012-10-26 05:10:00 | AAPL | Stock | 21.7889 | 21.7889 | 21.7889 | 21.7889 | 11200.0 |
| 2012-10-26 05:20:00 | AAPL | Stock | 21.7857 | 21.7857 | 21.7857 | 21.7857 | 14000.0 |
| 2012-10-26 05:25:00 | AAPL | Stock | 21.7857 | 21.7857 | 21.7857 | 21.7857 | 137200.0 |
| 2012-10-26 05:30:00 | AAPL | Stock | 21.7857 | 21.7861 | 21.7857 | 21.7857 | 93548.0 |
| 2012-10-26 05:35:00 | AAPL | Stock | 21.75 | 21.75 | 21.7164 | 21.7164 | 5600.0 |
| 2012-10-26 05:40:00 | AAPL | Stock | 21.75 | 21.75 | 21.75 | 21.75 | 10220.0 |
| 2012-10-26 05:45:00 | AAPL | Stock | 21.7846 | 21.7854 | 21.7846 | 21.7854 | 8400.0 |
| 2012-10-26 05:50:00 | AAPL | Stock | 21.7514 | 21.7857 | 21.7514 | 21.7729 | 30800.0 |
| 2012-10-26 06:05:00 | AAPL | Stock | 21.75 | 21.75 | 21.75 | 21.75 | 2800.0 |
| 2012-10-26 06:10:00 | AAPL | Stock | 21.7504 | 21.7504 | 21.75 | 21.75 | 11200.0 |
| 2012-10-26 06:15:00 | AAPL | Stock | 21.7411 | 21.75 | 21.7411 | 21.75 | 74704.0 |
| 2012-10-26 06:20:00 | AAPL | Stock | 21.7357 | 21.75 | 21.7325 | 21.75 | 16800.0 |
| 2012-10-26 06:25:00 | AAPL | Stock | 21.7325 | 21.7496 | 21.7325 | 21.7496 | 14840.0 |
| 2012-10-26 06:40:00 | AAPL | Stock | 21.7496 | 21.7496 | 21.7496 | 21.7496 | 2800.0 |
| 2012-10-26 06:45:00 | AAPL | Stock | 21.7446 | 21.7446 | 21.7446 | 21.7446 | 29092.0 |
| 2012-10-26 07:00:00 | AAPL | Stock | 21.7446 | 21.7504 | 21.7325 | 21.7411 | 82096.0 |
| 2012-10-26 07:05:00 | AAPL | Stock | 21.7411 | 21.75 | 21.7189 | 21.7286 | 189700.0 |
| 2012-10-26 07:10:00 | AAPL | Stock | 21.7289 | 21.8036 | 21.7207 | 21.7857 | 354984.0 |
| 2012-10-26 07:15:00 | AAPL | Stock | 21.7857 | 21.8393 | 21.7857 | 21.8343 | 241976.0 |
| 2012-10-26 07:20:00 | AAPL | Stock | 21.8361 | 21.8393 | 21.8143 | 21.8218 | 293692.0 |
| 2012-10-26 07:25:00 | AAPL | Stock | 21.8254 | 21.8393 | 21.8071 | 21.8125 | 504364.0 |
| 2012-10-26 07:30:00 | AAPL | Stock | 21.81 | 21.81 | 21.7921 | 21.7921 | 127036.0 |
| 2012-10-26 07:35:00 | AAPL | Stock | 21.8168 | 21.8321 | 21.8161 | 21.8321 | 44156.0 |
| 2012-10-26 07:40:00 | AAPL | Stock | 21.8318 | 21.8375 | 21.7946 | 21.8036 | 136024.0 |
| 2012-10-26 07:45:00 | AAPL | Stock | 21.8036 | 21.8121 | 21.7875 | 21.805 | 55300.0 |
| 2012-10-26 07:50:00 | AAPL | Stock | 21.8104 | 21.8104 | 21.7857 | 21.7911 | 172508.0 |
| 2012-10-26 07:55:00 | AAPL | Stock | 21.7914 | 21.8746 | 21.7914 | 21.8571 | 1415736.0 |
| 2012-10-26 08:00:00 | AAPL | Stock | 21.8236 | 21.8571 | 21.7325 | 21.8393 | 1944236.0 |
| 2012-10-26 08:05:00 | AAPL | Stock | 21.8411 | 21.8693 | 21.8232 | 21.8496 | 2821784.0 |
| 2012-10-26 08:10:00 | AAPL | Stock | 21.8571 | 21.8689 | 21.8393 | 21.8507 | 2078832.0 |
| 2012-10-26 08:15:00 | AAPL | Stock | 21.8696 | 21.8718 | 21.8232 | 21.8389 | 1675408.0 |
| 2012-10-26 08:20:00 | AAPL | Stock | 21.8561 | 21.8561 | 21.8061 | 21.81 | 1238244.0 |
| 2012-10-26 08:25:00 | AAPL | Stock | 21.8171 | 21.8393 | 21.8039 | 21.8246 | 462812.0 |
| 2012-10-26 08:30:00 | AAPL | Stock | 21.8457 | 21.8571 | 21.8261 | 21.8339 | 1749916.0 |
| 2012-10-26 08:35:00 | AAPL | Stock | 21.8325 | 21.8443 | 21.8143 | 21.82 | 1032444.0 |
| 2012-10-26 08:40:00 | AAPL | Stock | 21.8318 | 21.8439 | 21.8286 | 21.8375 | 976584.0 |
| 2012-10-26 08:45:00 | AAPL | Stock | 21.8343 | 21.8482 | 21.8321 | 21.84 | 2099580.0 |
| 2012-10-26 08:50:00 | AAPL | Stock | 21.8436 | 21.8454 | 21.8304 | 21.8393 | 2244396.0 |
| 2012-10-26 08:55:00 | AAPL | Stock | 21.8364 | 21.8371 | 21.8046 | 21.8143 | 1990436.0 |
> showing 50 of 308,716 rows — these rows as CSV