PREVIEW / stock_1min / 2012-10-02
file: by_date/stock_1min/2012/2012-10-02.parquet size: 12.6 MB rows: 932,971 symbols: 2,808
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:02:00 | AAPL | Stock | 23.625 | 23.625 | 23.625 | 23.625 | 8400.0 |
| 2012-10-02 04:03:00 | AAPL | Stock | 23.625 | 23.625 | 23.625 | 23.625 | 8400.0 |
| 2012-10-02 04:04:00 | AAPL | Stock | 23.6246 | 23.625 | 23.6246 | 23.625 | 5600.0 |
| 2012-10-02 04:05:00 | AAPL | Stock | 23.625 | 23.625 | 23.625 | 23.625 | 2800.0 |
| 2012-10-02 04:23:00 | AAPL | Stock | 23.6279 | 23.6279 | 23.6279 | 23.6279 | 2800.0 |
| 2012-10-02 04:26:00 | AAPL | Stock | 23.6429 | 23.6429 | 23.6429 | 23.6429 | 12880.0 |
| 2012-10-02 05:22:00 | AAPL | Stock | 23.6943 | 23.6943 | 23.6943 | 23.6943 | 8400.0 |
| 2012-10-02 05:23:00 | AAPL | Stock | 23.6943 | 23.6943 | 23.6943 | 23.6943 | 5600.0 |
| 2012-10-02 05:28:00 | AAPL | Stock | 23.6943 | 23.6964 | 23.6943 | 23.6964 | 5600.0 |
| 2012-10-02 05:39:00 | AAPL | Stock | 23.7107 | 23.7107 | 23.7086 | 23.7086 | 19600.0 |
| 2012-10-02 05:47:00 | AAPL | Stock | 23.7071 | 23.7071 | 23.7071 | 23.7071 | 3024.0 |
| 2012-10-02 05:54:00 | AAPL | Stock | 23.7214 | 23.7214 | 23.7107 | 23.7107 | 31864.0 |
| 2012-10-02 05:56:00 | AAPL | Stock | 23.7143 | 23.7143 | 23.7143 | 23.7143 | 2800.0 |
| 2012-10-02 06:02: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:17:00 | AAPL | Stock | 23.7125 | 23.7125 | 23.7125 | 23.7125 | 25200.0 |
| 2012-10-02 06:31:00 | AAPL | Stock | 23.7143 | 23.7179 | 23.7143 | 23.7179 | 6580.0 |
| 2012-10-02 06:51:00 | AAPL | Stock | 23.7239 | 23.7239 | 23.7232 | 23.7232 | 5600.0 |
| 2012-10-02 06:53:00 | AAPL | Stock | 23.7125 | 23.7125 | 23.7125 | 23.7125 | 5600.0 |
| 2012-10-02 06:56:00 | AAPL | Stock | 23.7189 | 23.7189 | 23.7189 | 23.7189 | 12600.0 |
| 2012-10-02 06:58:00 | AAPL | Stock | 23.7318 | 23.7318 | 23.7318 | 23.7318 | 2800.0 |
| 2012-10-02 07:00:00 | AAPL | Stock | 23.7143 | 23.7143 | 23.7143 | 23.7143 | 8232.0 |
| 2012-10-02 07:02:00 | AAPL | Stock | 23.7279 | 23.7282 | 23.7125 | 23.7125 | 19600.0 |
| 2012-10-02 07:03:00 | AAPL | Stock | 23.7036 | 23.7121 | 23.7036 | 23.7121 | 19488.0 |
| 2012-10-02 07:04:00 | AAPL | Stock | 23.7121 | 23.7121 | 23.7036 | 23.7036 | 26236.0 |
| 2012-10-02 07:06:00 | AAPL | Stock | 23.6964 | 23.7036 | 23.6964 | 23.7036 | 22400.0 |
| 2012-10-02 07:14:00 | AAPL | Stock | 23.6961 | 23.6961 | 23.6961 | 23.6961 | 70000.0 |
| 2012-10-02 07:16:00 | AAPL | Stock | 23.6875 | 23.6875 | 23.6875 | 23.6875 | 2800.0 |
| 2012-10-02 07:18:00 | AAPL | Stock | 23.6804 | 23.6804 | 23.6614 | 23.6614 | 17724.0 |
| 2012-10-02 07:19:00 | AAPL | Stock | 23.6782 | 23.6782 | 23.6504 | 23.6571 | 14000.0 |
| 2012-10-02 07:20:00 | AAPL | Stock | 23.6607 | 23.6607 | 23.6607 | 23.6607 | 4480.0 |
| 2012-10-02 07:21:00 | AAPL | Stock | 23.6679 | 23.6679 | 23.6607 | 23.6607 | 5600.0 |
| 2012-10-02 07:22:00 | AAPL | Stock | 23.6661 | 23.6661 | 23.6661 | 23.6661 | 5600.0 |
| 2012-10-02 07:24:00 | AAPL | Stock | 23.6571 | 23.6607 | 23.6429 | 23.6607 | 24444.0 |
| 2012-10-02 07:25:00 | AAPL | Stock | 23.6518 | 23.6518 | 23.6518 | 23.6518 | 2800.0 |
| 2012-10-02 07:27:00 | AAPL | Stock | 23.6464 | 23.6464 | 23.6429 | 23.6429 | 8400.0 |
| 2012-10-02 07:30:00 | AAPL | Stock | 23.6604 | 23.6921 | 23.6604 | 23.6921 | 44800.0 |
| 2012-10-02 07:31:00 | AAPL | Stock | 23.6871 | 23.6964 | 23.6871 | 23.6964 | 28280.0 |
| 2012-10-02 07:32:00 | AAPL | Stock | 23.7018 | 23.7018 | 23.7018 | 23.7018 | 2800.0 |
| 2012-10-02 07:33:00 | AAPL | Stock | 23.7036 | 23.7036 | 23.6964 | 23.6971 | 14000.0 |
| 2012-10-02 07:35:00 | AAPL | Stock | 23.6971 | 23.7036 | 23.6971 | 23.7036 | 8400.0 |
| 2012-10-02 07:36:00 | AAPL | Stock | 23.7036 | 23.7036 | 23.7036 | 23.7036 | 2800.0 |
| 2012-10-02 07:37:00 | AAPL | Stock | 23.6982 | 23.6982 | 23.6964 | 23.6964 | 11620.0 |
| 2012-10-02 07:39:00 | AAPL | Stock | 23.7018 | 23.7018 | 23.6964 | 23.6964 | 14000.0 |
| 2012-10-02 07:42:00 | AAPL | Stock | 23.6939 | 23.6961 | 23.6939 | 23.6961 | 8400.0 |
| 2012-10-02 07:43:00 | AAPL | Stock | 23.6961 | 23.6996 | 23.6943 | 23.6943 | 11200.0 |
| 2012-10-02 07:46:00 | AAPL | Stock | 23.7004 | 23.7004 | 23.7004 | 23.7004 | 2800.0 |
| 2012-10-02 07:47:00 | AAPL | Stock | 23.7064 | 23.7214 | 23.7032 | 23.7214 | 22400.0 |
| 2012-10-02 07:48:00 | AAPL | Stock | 23.7143 | 23.7143 | 23.7143 | 23.7143 | 14000.0 |
| 2012-10-02 07:51:00 | AAPL | Stock | 23.7036 | 23.7036 | 23.7036 | 23.7036 | 2800.0 |
> showing 50 of 932,971 rows — these rows as CSV