PREVIEW / stock_5min / 2013-11-29
file: by_date/stock_5min/2013/2013-11-29.parquet size: 3.1 MB rows: 193,483 symbols: 3,448
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-11-29 04:00:00 | AAPL | Stock | 19.5754 | 19.6332 | 19.5754 | 19.6214 | 36428.0 |
| 2013-11-29 04:05:00 | AAPL | Stock | 19.6179 | 19.6179 | 19.6179 | 19.6179 | 11200.0 |
| 2013-11-29 04:15:00 | AAPL | Stock | 19.5982 | 19.5982 | 19.5982 | 19.5982 | 2800.0 |
| 2013-11-29 04:20:00 | AAPL | Stock | 19.6 | 19.6 | 19.5839 | 19.5839 | 8400.0 |
| 2013-11-29 04:25:00 | AAPL | Stock | 19.6 | 19.6311 | 19.6 | 19.6311 | 22400.0 |
| 2013-11-29 04:35:00 | AAPL | Stock | 19.6236 | 19.6236 | 19.6154 | 19.6214 | 11536.0 |
| 2013-11-29 04:40:00 | AAPL | Stock | 19.6214 | 19.6314 | 19.6214 | 19.6314 | 5600.0 |
| 2013-11-29 04:45:00 | AAPL | Stock | 19.6214 | 19.6214 | 19.6214 | 19.6214 | 8400.0 |
| 2013-11-29 04:55:00 | AAPL | Stock | 19.6157 | 19.6157 | 19.6157 | 19.6157 | 2800.0 |
| 2013-11-29 05:15:00 | AAPL | Stock | 19.6421 | 19.6429 | 19.6421 | 19.6421 | 13664.0 |
| 2013-11-29 05:20:00 | AAPL | Stock | 19.6514 | 19.6607 | 19.6514 | 19.6607 | 5600.0 |
| 2013-11-29 05:25:00 | AAPL | Stock | 19.6607 | 19.6607 | 19.6607 | 19.6607 | 2800.0 |
| 2013-11-29 05:30:00 | AAPL | Stock | 19.6464 | 19.6464 | 19.6429 | 19.6429 | 5600.0 |
| 2013-11-29 05:35:00 | AAPL | Stock | 19.6429 | 19.6429 | 19.6429 | 19.6429 | 2800.0 |
| 2013-11-29 05:50:00 | AAPL | Stock | 19.63 | 19.63 | 19.6157 | 19.6157 | 16800.0 |
| 2013-11-29 05:55:00 | AAPL | Stock | 19.6182 | 19.6182 | 19.6182 | 19.6182 | 2800.0 |
| 2013-11-29 06:00:00 | AAPL | Stock | 19.6425 | 19.6625 | 19.6368 | 19.6625 | 60060.0 |
| 2013-11-29 06:05:00 | AAPL | Stock | 19.6607 | 19.6771 | 19.6607 | 19.6771 | 19600.0 |
| 2013-11-29 06:10:00 | AAPL | Stock | 19.6714 | 19.6714 | 19.6714 | 19.6714 | 2800.0 |
| 2013-11-29 06:15:00 | AAPL | Stock | 19.6771 | 19.6821 | 19.6518 | 19.6518 | 80976.0 |
| 2013-11-29 06:20:00 | AAPL | Stock | 19.6429 | 19.6771 | 19.6429 | 19.6771 | 170464.0 |
| 2013-11-29 06:25:00 | AAPL | Stock | 19.6675 | 19.6714 | 19.6675 | 19.6714 | 5600.0 |
| 2013-11-29 06:35:00 | AAPL | Stock | 19.6429 | 19.6429 | 19.6393 | 19.6393 | 14140.0 |
| 2013-11-29 06:40:00 | AAPL | Stock | 19.6393 | 19.645 | 19.6236 | 19.6439 | 93800.0 |
| 2013-11-29 06:45:00 | AAPL | Stock | 19.6446 | 19.6554 | 19.6446 | 19.6554 | 18200.0 |
| 2013-11-29 06:50:00 | AAPL | Stock | 19.6554 | 19.6607 | 19.6554 | 19.6607 | 11200.0 |
| 2013-11-29 06:55:00 | AAPL | Stock | 19.6536 | 19.6536 | 19.6536 | 19.6536 | 36176.0 |
| 2013-11-29 07:00:00 | AAPL | Stock | 19.6536 | 19.6607 | 19.6429 | 19.6607 | 101500.0 |
| 2013-11-29 07:05:00 | AAPL | Stock | 19.6607 | 19.6607 | 19.6439 | 19.6607 | 105056.0 |
| 2013-11-29 07:10:00 | AAPL | Stock | 19.6571 | 19.6571 | 19.6536 | 19.6536 | 39256.0 |
| 2013-11-29 07:15:00 | AAPL | Stock | 19.6554 | 19.6607 | 19.6518 | 19.6536 | 66920.0 |
| 2013-11-29 07:20:00 | AAPL | Stock | 19.6554 | 19.6554 | 19.6536 | 19.6536 | 25200.0 |
| 2013-11-29 07:25:00 | AAPL | Stock | 19.645 | 19.6546 | 19.6429 | 19.6429 | 64568.0 |
| 2013-11-29 07:30:00 | AAPL | Stock | 19.6429 | 19.6429 | 19.6293 | 19.6339 | 115864.0 |
| 2013-11-29 07:35:00 | AAPL | Stock | 19.6357 | 19.6418 | 19.6357 | 19.64 | 47600.0 |
| 2013-11-29 07:40:00 | AAPL | Stock | 19.6418 | 19.65 | 19.64 | 19.65 | 115080.0 |
| 2013-11-29 07:45:00 | AAPL | Stock | 19.65 | 19.6518 | 19.6464 | 19.6464 | 48888.0 |
| 2013-11-29 07:50:00 | AAPL | Stock | 19.6443 | 19.6443 | 19.6339 | 19.6339 | 136444.0 |
| 2013-11-29 07:55:00 | AAPL | Stock | 19.6339 | 19.6418 | 19.6339 | 19.6393 | 15960.0 |
| 2013-11-29 08:00:00 | AAPL | Stock | 19.6379 | 19.685 | 19.6264 | 19.6714 | 748328.0 |
| 2013-11-29 08:05:00 | AAPL | Stock | 19.6643 | 19.6771 | 19.4821 | 19.6614 | 476224.0 |
| 2013-11-29 08:10:00 | AAPL | Stock | 19.6618 | 19.6875 | 19.6607 | 19.6775 | 358736.0 |
| 2013-11-29 08:15:00 | AAPL | Stock | 19.6786 | 19.6939 | 19.6786 | 19.6857 | 341208.0 |
| 2013-11-29 08:20:00 | AAPL | Stock | 19.6861 | 19.6893 | 19.6804 | 19.6811 | 157892.0 |
| 2013-11-29 08:25:00 | AAPL | Stock | 19.6804 | 19.6825 | 19.6607 | 19.6682 | 387436.0 |
| 2013-11-29 08:30:00 | AAPL | Stock | 19.6696 | 19.6764 | 19.6643 | 19.6693 | 230720.0 |
| 2013-11-29 08:35:00 | AAPL | Stock | 19.6639 | 19.6689 | 19.645 | 19.655 | 355404.0 |
| 2013-11-29 08:40:00 | AAPL | Stock | 19.6504 | 19.6568 | 19.6432 | 19.6471 | 151312.0 |
| 2013-11-29 08:45:00 | AAPL | Stock | 19.65 | 19.6536 | 19.6461 | 19.6536 | 168700.0 |
| 2013-11-29 08:50:00 | AAPL | Stock | 19.6539 | 19.6596 | 19.6539 | 19.6596 | 27076.0 |
> showing 50 of 193,483 rows — these rows as CSV