PREVIEW / stock_5min / 2011-02-17
file: by_date/stock_5min/2011/2011-02-17.parquet size: 4.9 MB rows: 331,043 symbols: 3,527
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-17 04:00:00 | AAPL | Stock | 12.7929 | 12.8571 | 12.7929 | 12.7929 | 33460.0 |
| 2011-02-17 04:15:00 | AAPL | Stock | 12.8321 | 12.8321 | 12.8321 | 12.8321 | 2800.0 |
| 2011-02-17 04:20:00 | AAPL | Stock | 12.8054 | 12.8357 | 12.8054 | 12.8054 | 19600.0 |
| 2011-02-17 04:25:00 | AAPL | Stock | 12.8054 | 12.8286 | 12.8054 | 12.8054 | 16800.0 |
| 2011-02-17 04:30:00 | AAPL | Stock | 12.8054 | 12.8054 | 12.8054 | 12.8054 | 27888.0 |
| 2011-02-17 04:40:00 | AAPL | Stock | 12.8039 | 12.8039 | 12.8039 | 12.8039 | 5600.0 |
| 2011-02-17 04:45:00 | AAPL | Stock | 12.7625 | 12.7625 | 12.7514 | 12.7514 | 38220.0 |
| 2011-02-17 04:50:00 | AAPL | Stock | 12.6864 | 12.7625 | 12.6793 | 12.7625 | 36820.0 |
| 2011-02-17 04:55:00 | AAPL | Stock | 12.7225 | 12.7321 | 12.6925 | 12.7018 | 33600.0 |
| 2011-02-17 05:00:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7018 | 12.7018 | 5600.0 |
| 2011-02-17 05:05:00 | AAPL | Stock | 12.7143 | 12.75 | 12.7143 | 12.75 | 8120.0 |
| 2011-02-17 05:10:00 | AAPL | Stock | 12.7029 | 12.75 | 12.7029 | 12.75 | 23660.0 |
| 2011-02-17 05:15:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6793 | 12.6793 | 32340.0 |
| 2011-02-17 05:20:00 | AAPL | Stock | 12.6468 | 12.6468 | 12.5714 | 12.5714 | 25228.0 |
| 2011-02-17 05:25:00 | AAPL | Stock | 12.5893 | 12.5893 | 12.5496 | 12.5496 | 61040.0 |
| 2011-02-17 05:30:00 | AAPL | Stock | 12.6143 | 12.6429 | 12.5418 | 12.5418 | 72296.0 |
| 2011-02-17 05:40:00 | AAPL | Stock | 12.67 | 12.6786 | 12.67 | 12.6714 | 22400.0 |
| 2011-02-17 05:45:00 | AAPL | Stock | 12.6768 | 12.6929 | 12.6768 | 12.6929 | 47740.0 |
| 2011-02-17 05:50:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 2800.0 |
| 2011-02-17 05:55:00 | AAPL | Stock | 12.6939 | 12.6939 | 12.6939 | 12.6939 | 4844.0 |
| 2011-02-17 06:00:00 | AAPL | Stock | 12.7036 | 12.725 | 12.6786 | 12.6786 | 91000.0 |
| 2011-02-17 06:05:00 | AAPL | Stock | 12.7 | 12.7143 | 12.6996 | 12.7143 | 8400.0 |
| 2011-02-17 06:10:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7071 | 12.7071 | 55524.0 |
| 2011-02-17 06:15:00 | AAPL | Stock | 12.7093 | 12.7214 | 12.7018 | 12.7214 | 50400.0 |
| 2011-02-17 06:20:00 | AAPL | Stock | 12.7214 | 12.7321 | 12.7214 | 12.7321 | 22400.0 |
| 2011-02-17 06:30:00 | AAPL | Stock | 12.7143 | 12.75 | 12.69 | 12.7307 | 30800.0 |
| 2011-02-17 06:35:00 | AAPL | Stock | 12.75 | 12.7811 | 12.75 | 12.7811 | 50260.0 |
| 2011-02-17 06:40:00 | AAPL | Stock | 12.7568 | 12.8029 | 12.7568 | 12.7789 | 72240.0 |
| 2011-02-17 06:45:00 | AAPL | Stock | 12.7632 | 12.7839 | 12.7632 | 12.7686 | 93940.0 |
| 2011-02-17 06:50:00 | AAPL | Stock | 12.7857 | 12.7857 | 12.7686 | 12.7857 | 25200.0 |
| 2011-02-17 06:55:00 | AAPL | Stock | 12.7857 | 12.7857 | 12.7857 | 12.7857 | 8400.0 |
| 2011-02-17 07:00:00 | AAPL | Stock | 12.7782 | 12.8304 | 12.7679 | 12.8214 | 265188.0 |
| 2011-02-17 07:05:00 | AAPL | Stock | 12.825 | 12.8571 | 12.825 | 12.8468 | 448000.0 |
| 2011-02-17 07:10:00 | AAPL | Stock | 12.85 | 12.8664 | 12.8218 | 12.8293 | 248108.0 |
| 2011-02-17 07:15:00 | AAPL | Stock | 12.83 | 12.8393 | 12.8096 | 12.8389 | 177968.0 |
| 2011-02-17 07:20:00 | AAPL | Stock | 12.8304 | 12.8571 | 12.8236 | 12.8236 | 157724.0 |
| 2011-02-17 07:25:00 | AAPL | Stock | 12.8236 | 12.8286 | 12.8036 | 12.8036 | 207116.0 |
| 2011-02-17 07:30:00 | AAPL | Stock | 12.8036 | 12.8214 | 12.7821 | 12.7864 | 325444.0 |
| 2011-02-17 07:35:00 | AAPL | Stock | 12.7868 | 12.8296 | 12.7857 | 12.825 | 171472.0 |
| 2011-02-17 07:40:00 | AAPL | Stock | 12.8286 | 12.8314 | 12.7946 | 12.7961 | 277704.0 |
| 2011-02-17 07:45:00 | AAPL | Stock | 12.7932 | 12.8004 | 12.7793 | 12.7793 | 292320.0 |
| 2011-02-17 07:50:00 | AAPL | Stock | 12.7789 | 12.8168 | 12.7789 | 12.8071 | 309316.0 |
| 2011-02-17 07:55:00 | AAPL | Stock | 12.8132 | 12.8171 | 12.8043 | 12.8071 | 295484.0 |
| 2011-02-17 08:00:00 | AAPL | Stock | 12.8071 | 12.8439 | 12.7918 | 12.8414 | 1339828.0 |
| 2011-02-17 08:05:00 | AAPL | Stock | 12.8418 | 12.8736 | 12.8371 | 12.8736 | 629944.0 |
| 2011-02-17 08:10:00 | AAPL | Stock | 12.8721 | 12.8839 | 12.8571 | 12.8754 | 914060.0 |
| 2011-02-17 08:15:00 | AAPL | Stock | 12.8754 | 12.8911 | 12.8721 | 12.8864 | 655284.0 |
| 2011-02-17 08:20:00 | AAPL | Stock | 12.8857 | 12.8864 | 12.8661 | 12.8661 | 283080.0 |
| 2011-02-17 08:25:00 | AAPL | Stock | 12.8696 | 12.8729 | 12.8454 | 12.85 | 886284.0 |
| 2011-02-17 08:30:00 | AAPL | Stock | 12.85 | 12.8546 | 12.8425 | 12.8518 | 480480.0 |
> showing 50 of 331,043 rows — these rows as CSV