PREVIEW / stock_1min / 2012-01-24
file: by_date/stock_1min/2012/2012-01-24.parquet size: 12.5 MB rows: 927,375 symbols: 2,860
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-01-24 04:10:00 | AAPL | Stock | 15.2679 | 15.2679 | 15.2679 | 15.2679 | 2800.0 |
| 2012-01-24 04:11:00 | AAPL | Stock | 15.2643 | 15.2643 | 15.2643 | 15.2643 | 11200.0 |
| 2012-01-24 04:16:00 | AAPL | Stock | 15.2643 | 15.2679 | 15.2643 | 15.2679 | 8400.0 |
| 2012-01-24 04:47:00 | AAPL | Stock | 15.25 | 15.25 | 15.2464 | 15.2464 | 8400.0 |
| 2012-01-24 04:48:00 | AAPL | Stock | 15.2354 | 15.2354 | 15.2354 | 15.2354 | 5600.0 |
| 2012-01-24 04:49:00 | AAPL | Stock | 15.2496 | 15.2496 | 15.2496 | 15.2496 | 2800.0 |
| 2012-01-24 05:04:00 | AAPL | Stock | 15.2432 | 15.2432 | 15.2143 | 15.2143 | 5600.0 |
| 2012-01-24 05:20:00 | AAPL | Stock | 15.2279 | 15.2279 | 15.2279 | 15.2279 | 5600.0 |
| 2012-01-24 05:21:00 | AAPL | Stock | 15.2279 | 15.2279 | 15.2279 | 15.2279 | 2800.0 |
| 2012-01-24 05:55:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 2800.0 |
| 2012-01-24 06:01:00 | AAPL | Stock | 15.1964 | 15.1964 | 15.1964 | 15.1964 | 14000.0 |
| 2012-01-24 06:02:00 | AAPL | Stock | 15.1964 | 15.1964 | 15.1964 | 15.1964 | 4200.0 |
| 2012-01-24 06:21:00 | AAPL | Stock | 15.2232 | 15.2232 | 15.2 | 15.2 | 10640.0 |
| 2012-01-24 07:00:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 4900.0 |
| 2012-01-24 07:01:00 | AAPL | Stock | 15.2311 | 15.2311 | 15.2286 | 15.2286 | 8400.0 |
| 2012-01-24 07:02:00 | AAPL | Stock | 15.2179 | 15.2179 | 15.2143 | 15.2143 | 10220.0 |
| 2012-01-24 07:04:00 | AAPL | Stock | 15.2146 | 15.2232 | 15.2143 | 15.2232 | 25480.0 |
| 2012-01-24 07:06:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 2800.0 |
| 2012-01-24 07:09:00 | AAPL | Stock | 15.2107 | 15.2107 | 15.2107 | 15.2107 | 2800.0 |
| 2012-01-24 07:10:00 | AAPL | Stock | 15.2179 | 15.2179 | 15.2179 | 15.2179 | 8400.0 |
| 2012-01-24 07:11:00 | AAPL | Stock | 15.2164 | 15.2164 | 15.2164 | 15.2164 | 2800.0 |
| 2012-01-24 07:12:00 | AAPL | Stock | 15.2214 | 15.2214 | 15.2214 | 15.2214 | 2800.0 |
| 2012-01-24 07:15:00 | AAPL | Stock | 15.2232 | 15.2232 | 15.2232 | 15.2232 | 5600.0 |
| 2012-01-24 07:16:00 | AAPL | Stock | 15.2143 | 15.2268 | 15.2143 | 15.2268 | 15400.0 |
| 2012-01-24 07:19:00 | AAPL | Stock | 15.2139 | 15.2139 | 15.2107 | 15.2107 | 14000.0 |
| 2012-01-24 07:22:00 | AAPL | Stock | 15.2196 | 15.2196 | 15.2179 | 15.2179 | 8848.0 |
| 2012-01-24 07:26:00 | AAPL | Stock | 15.225 | 15.225 | 15.225 | 15.225 | 2800.0 |
| 2012-01-24 07:28:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 13720.0 |
| 2012-01-24 07:29:00 | AAPL | Stock | 15.2107 | 15.2107 | 15.2046 | 15.2046 | 6916.0 |
| 2012-01-24 07:30:00 | AAPL | Stock | 15.2193 | 15.2214 | 15.2193 | 15.2214 | 16100.0 |
| 2012-01-24 07:31:00 | AAPL | Stock | 15.2207 | 15.2207 | 15.2207 | 15.2207 | 2800.0 |
| 2012-01-24 07:32:00 | AAPL | Stock | 15.2111 | 15.2111 | 15.2111 | 15.2111 | 5600.0 |
| 2012-01-24 07:34:00 | AAPL | Stock | 15.2107 | 15.2107 | 15.2107 | 15.2107 | 2800.0 |
| 2012-01-24 07:35:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 5600.0 |
| 2012-01-24 07:37:00 | AAPL | Stock | 15.2079 | 15.2079 | 15.2079 | 15.2079 | 2800.0 |
| 2012-01-24 07:38:00 | AAPL | Stock | 15.2071 | 15.2071 | 15.2018 | 15.2018 | 11200.0 |
| 2012-01-24 07:39:00 | AAPL | Stock | 15.1968 | 15.1968 | 15.1964 | 15.1964 | 8400.0 |
| 2012-01-24 07:40:00 | AAPL | Stock | 15.1996 | 15.1996 | 15.1964 | 15.1996 | 56728.0 |
| 2012-01-24 07:44:00 | AAPL | Stock | 15.2007 | 15.2007 | 15.2007 | 15.2007 | 16800.0 |
| 2012-01-24 07:49:00 | AAPL | Stock | 15.2 | 15.2 | 15.2 | 15.2 | 2800.0 |
| 2012-01-24 07:51:00 | AAPL | Stock | 15.2032 | 15.2032 | 15.2032 | 15.2032 | 2800.0 |
| 2012-01-24 07:52:00 | AAPL | Stock | 15.2018 | 15.2018 | 15.2018 | 15.2018 | 2800.0 |
| 2012-01-24 07:54:00 | AAPL | Stock | 15.2025 | 15.2025 | 15.2018 | 15.2018 | 5600.0 |
| 2012-01-24 07:55:00 | AAPL | Stock | 15.2 | 15.2 | 15.2 | 15.2 | 2800.0 |
| 2012-01-24 07:56:00 | AAPL | Stock | 15.2068 | 15.2068 | 15.2068 | 15.2068 | 2800.0 |
| 2012-01-24 07:57:00 | AAPL | Stock | 15.2021 | 15.2025 | 15.1982 | 15.1982 | 20272.0 |
| 2012-01-24 07:58:00 | AAPL | Stock | 15.1993 | 15.1993 | 15.1964 | 15.1964 | 5600.0 |
| 2012-01-24 08:00:00 | AAPL | Stock | 15.2032 | 15.23 | 15.1943 | 15.2139 | 123704.0 |
| 2012-01-24 08:01:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2139 | 15.2139 | 5992.0 |
| 2012-01-24 08:02:00 | AAPL | Stock | 15.2071 | 15.2071 | 15.2071 | 15.2071 | 4200.0 |
> showing 50 of 927,375 rows — these rows as CSV