PREVIEW / stock_5min / 2012-10-02
file: by_date/stock_5min/2012/2012-10-02.parquet size: 4.7 MB rows: 319,305 symbols: 3,469
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-02 04:00:00 | AAPL | Stock | 23.625 | 23.625 | 23.6246 | 23.625 | 22400.0 |
| 2012-10-02 04:05:00 | AAPL | Stock | 23.625 | 23.625 | 23.625 | 23.625 | 2800.0 |
| 2012-10-02 04:20:00 | AAPL | Stock | 23.6279 | 23.6279 | 23.6279 | 23.6279 | 2800.0 |
| 2012-10-02 04:25:00 | AAPL | Stock | 23.6429 | 23.6429 | 23.6429 | 23.6429 | 12880.0 |
| 2012-10-02 05:20:00 | AAPL | Stock | 23.6943 | 23.6943 | 23.6943 | 23.6943 | 14000.0 |
| 2012-10-02 05:25:00 | AAPL | Stock | 23.6943 | 23.6964 | 23.6943 | 23.6964 | 5600.0 |
| 2012-10-02 05:35:00 | AAPL | Stock | 23.7107 | 23.7107 | 23.7086 | 23.7086 | 19600.0 |
| 2012-10-02 05:45:00 | AAPL | Stock | 23.7071 | 23.7071 | 23.7071 | 23.7071 | 3024.0 |
| 2012-10-02 05:50:00 | AAPL | Stock | 23.7214 | 23.7214 | 23.7107 | 23.7107 | 31864.0 |
| 2012-10-02 05:55:00 | AAPL | Stock | 23.7143 | 23.7143 | 23.7143 | 23.7143 | 2800.0 |
| 2012-10-02 06:00:00 | AAPL | Stock | 23.7054 | 23.7054 | 23.7 | 23.7 | 8400.0 |
| 2012-10-02 06:10:00 | AAPL | Stock | 23.7054 | 23.7054 | 23.7054 | 23.7054 | 2800.0 |
| 2012-10-02 06:15:00 | AAPL | Stock | 23.7125 | 23.7125 | 23.7125 | 23.7125 | 25200.0 |
| 2012-10-02 06:30:00 | AAPL | Stock | 23.7143 | 23.7179 | 23.7143 | 23.7179 | 6580.0 |
| 2012-10-02 06:50:00 | AAPL | Stock | 23.7239 | 23.7239 | 23.7125 | 23.7125 | 11200.0 |
| 2012-10-02 06:55:00 | AAPL | Stock | 23.7189 | 23.7318 | 23.7189 | 23.7318 | 15400.0 |
| 2012-10-02 07:00:00 | AAPL | Stock | 23.7143 | 23.7282 | 23.7036 | 23.7036 | 73556.0 |
| 2012-10-02 07:05:00 | AAPL | Stock | 23.6964 | 23.7036 | 23.6964 | 23.7036 | 22400.0 |
| 2012-10-02 07:10:00 | AAPL | Stock | 23.6961 | 23.6961 | 23.6961 | 23.6961 | 70000.0 |
| 2012-10-02 07:15:00 | AAPL | Stock | 23.6875 | 23.6875 | 23.6504 | 23.6571 | 34524.0 |
| 2012-10-02 07:20:00 | AAPL | Stock | 23.6607 | 23.6679 | 23.6429 | 23.6607 | 40124.0 |
| 2012-10-02 07:25:00 | AAPL | Stock | 23.6518 | 23.6518 | 23.6429 | 23.6429 | 11200.0 |
| 2012-10-02 07:30:00 | AAPL | Stock | 23.6604 | 23.7036 | 23.6604 | 23.6971 | 89880.0 |
| 2012-10-02 07:35:00 | AAPL | Stock | 23.6971 | 23.7036 | 23.6964 | 23.6964 | 36820.0 |
| 2012-10-02 07:40:00 | AAPL | Stock | 23.6939 | 23.6996 | 23.6939 | 23.6943 | 19600.0 |
| 2012-10-02 07:45:00 | AAPL | Stock | 23.7004 | 23.7214 | 23.7004 | 23.7143 | 39200.0 |
| 2012-10-02 07:50:00 | AAPL | Stock | 23.7036 | 23.7125 | 23.7036 | 23.7125 | 67200.0 |
| 2012-10-02 07:55:00 | AAPL | Stock | 23.7018 | 23.7125 | 23.6939 | 23.7121 | 101108.0 |
| 2012-10-02 08:00:00 | AAPL | Stock | 23.7007 | 23.7125 | 23.6964 | 23.7107 | 192472.0 |
| 2012-10-02 08:05:00 | AAPL | Stock | 23.71 | 23.75 | 23.7071 | 23.75 | 565712.0 |
| 2012-10-02 08:10:00 | AAPL | Stock | 23.7489 | 23.7507 | 23.7343 | 23.7411 | 100408.0 |
| 2012-10-02 08:15:00 | AAPL | Stock | 23.7325 | 23.7464 | 23.7229 | 23.7321 | 108612.0 |
| 2012-10-02 08:20:00 | AAPL | Stock | 23.7393 | 23.7425 | 23.71 | 23.71 | 130200.0 |
| 2012-10-02 08:25:00 | AAPL | Stock | 23.7107 | 23.7143 | 23.6968 | 23.6968 | 99148.0 |
| 2012-10-02 08:30:00 | AAPL | Stock | 23.7018 | 23.7071 | 23.6964 | 23.7036 | 33600.0 |
| 2012-10-02 08:35:00 | AAPL | Stock | 23.7054 | 23.7118 | 23.6961 | 23.7107 | 144424.0 |
| 2012-10-02 08:40:00 | AAPL | Stock | 23.7032 | 23.7032 | 23.6786 | 23.6804 | 181608.0 |
| 2012-10-02 08:45:00 | AAPL | Stock | 23.6807 | 23.6957 | 23.6696 | 23.6714 | 313096.0 |
| 2012-10-02 08:50:00 | AAPL | Stock | 23.6714 | 23.6764 | 23.6661 | 23.6704 | 103880.0 |
| 2012-10-02 08:55:00 | AAPL | Stock | 23.6704 | 23.6764 | 23.6471 | 23.6532 | 259980.0 |
| 2012-10-02 09:00:00 | AAPL | Stock | 23.65 | 23.65 | 23.6321 | 23.6368 | 308812.0 |
| 2012-10-02 09:05:00 | AAPL | Stock | 23.6321 | 23.6321 | 23.6 | 23.6268 | 618912.0 |
| 2012-10-02 09:10:00 | AAPL | Stock | 23.6268 | 23.6368 | 23.6104 | 23.625 | 185696.0 |
| 2012-10-02 09:15:00 | AAPL | Stock | 23.625 | 23.625 | 23.6104 | 23.6225 | 102620.0 |
| 2012-10-02 09:20:00 | AAPL | Stock | 23.6211 | 23.625 | 23.6111 | 23.6161 | 96404.0 |
| 2012-10-02 09:25:00 | AAPL | Stock | 23.6214 | 23.6518 | 23.6071 | 23.6464 | 743764.0 |
| 2012-10-02 09:30:00 | AAPL | Stock | 23.6361 | 23.7225 | 23.5618 | 23.6721 | 25211116.0 |
| 2012-10-02 09:35:00 | AAPL | Stock | 23.6721 | 23.6832 | 23.5546 | 23.6139 | 13928544.0 |
| 2012-10-02 09:40:00 | AAPL | Stock | 23.6146 | 23.6629 | 23.5714 | 23.6125 | 10896564.0 |
| 2012-10-02 09:45:00 | AAPL | Stock | 23.6192 | 23.7107 | 23.6164 | 23.6846 | 10532452.0 |
> showing 50 of 319,305 rows — these rows as CSV