PREVIEW / stock_1min / 2008-01-22
file: by_date/stock_1min/2008/2008-01-22.parquet size: 14.2 MB rows: 1,121,324 symbols: 2,686
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-22 04:07:00 | AAPL | Stock | 5.1289 | 5.1321 | 5.1289 | 5.1321 | 5600.0 |
| 2008-01-22 04:13:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0893 | 5.0893 | 8400.0 |
| 2008-01-22 04:14:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0893 | 5.0893 | 5600.0 |
| 2008-01-22 04:15:00 | AAPL | Stock | 5.1514 | 5.5 | 5.1396 | 5.1396 | 30856.0 |
| 2008-01-22 04:20:00 | AAPL | Stock | 5.1132 | 5.1136 | 5.1132 | 5.1136 | 9800.0 |
| 2008-01-22 04:23:00 | AAPL | Stock | 5.1068 | 5.1068 | 5.1068 | 5.1068 | 8400.0 |
| 2008-01-22 04:33:00 | AAPL | Stock | 5.0982 | 5.0982 | 5.0982 | 5.0982 | 8400.0 |
| 2008-01-22 04:34:00 | AAPL | Stock | 5.0982 | 5.0982 | 5.0982 | 5.0982 | 33600.0 |
| 2008-01-22 04:35:00 | AAPL | Stock | 5.125 | 5.1279 | 5.125 | 5.1279 | 16800.0 |
| 2008-01-22 04:36:00 | AAPL | Stock | 5.1289 | 5.1289 | 5.1289 | 5.1289 | 2800.0 |
| 2008-01-22 04:39:00 | AAPL | Stock | 5.1246 | 5.1246 | 5.1246 | 5.1246 | 16800.0 |
| 2008-01-22 04:40:00 | AAPL | Stock | 5.1282 | 5.1282 | 5.1282 | 5.1282 | 2800.0 |
| 2008-01-22 04:41:00 | AAPL | Stock | 5.1282 | 5.1282 | 5.1282 | 5.1282 | 5600.0 |
| 2008-01-22 04:42:00 | AAPL | Stock | 5.1282 | 5.1468 | 5.1282 | 5.1468 | 5600.0 |
| 2008-01-22 04:44:00 | AAPL | Stock | 5.1504 | 5.1504 | 5.1504 | 5.1504 | 5600.0 |
| 2008-01-22 04:46:00 | AAPL | Stock | 5.1675 | 5.1675 | 5.1675 | 5.1675 | 2800.0 |
| 2008-01-22 04:47:00 | AAPL | Stock | 5.1786 | 5.1786 | 5.1786 | 5.1786 | 8400.0 |
| 2008-01-22 04:48:00 | AAPL | Stock | 5.1643 | 5.1929 | 5.1643 | 5.1929 | 19600.0 |
| 2008-01-22 04:53:00 | AAPL | Stock | 5.1929 | 5.1929 | 5.1929 | 5.1929 | 2800.0 |
| 2008-01-22 04:55:00 | AAPL | Stock | 5.1786 | 5.1786 | 5.1786 | 5.1786 | 19600.0 |
| 2008-01-22 04:56:00 | AAPL | Stock | 5.1786 | 5.1971 | 5.1786 | 5.1971 | 16800.0 |
| 2008-01-22 04:57:00 | AAPL | Stock | 5.1964 | 5.2057 | 5.1964 | 5.2057 | 28000.0 |
| 2008-01-22 04:58:00 | AAPL | Stock | 5.1964 | 5.1964 | 5.1964 | 5.1964 | 5600.0 |
| 2008-01-22 04:59:00 | AAPL | Stock | 5.1964 | 5.1964 | 5.1964 | 5.1964 | 2800.0 |
| 2008-01-22 05:00:00 | AAPL | Stock | 5.2232 | 5.2232 | 5.2232 | 5.2232 | 2800.0 |
| 2008-01-22 05:05:00 | AAPL | Stock | 5.2214 | 5.2214 | 5.2214 | 5.2214 | 2800.0 |
| 2008-01-22 05:06:00 | AAPL | Stock | 5.2193 | 5.2193 | 5.2193 | 5.2193 | 2800.0 |
| 2008-01-22 05:07:00 | AAPL | Stock | 5.2193 | 5.2193 | 5.2054 | 5.2054 | 5600.0 |
| 2008-01-22 05:15:00 | AAPL | Stock | 5.2143 | 5.2143 | 5.2143 | 5.2143 | 3948.0 |
| 2008-01-22 05:16:00 | AAPL | Stock | 5.2143 | 5.2143 | 5.2143 | 5.2143 | 2800.0 |
| 2008-01-22 05:19:00 | AAPL | Stock | 5.2411 | 5.2411 | 5.2411 | 5.2411 | 8400.0 |
| 2008-01-22 05:20:00 | AAPL | Stock | 5.2411 | 5.245 | 5.2411 | 5.245 | 19600.0 |
| 2008-01-22 05:28:00 | AAPL | Stock | 5.25 | 5.25 | 5.25 | 5.25 | 16800.0 |
| 2008-01-22 05:35:00 | AAPL | Stock | 5.2836 | 5.2836 | 5.2836 | 5.2836 | 18340.0 |
| 2008-01-22 05:36:00 | AAPL | Stock | 5.2736 | 5.2736 | 5.2736 | 5.2736 | 2800.0 |
| 2008-01-22 05:39:00 | AAPL | Stock | 5.2789 | 5.2789 | 5.2782 | 5.2782 | 30240.0 |
| 2008-01-22 05:41:00 | AAPL | Stock | 5.2679 | 5.2679 | 5.2679 | 5.2679 | 14000.0 |
| 2008-01-22 05:42:00 | AAPL | Stock | 5.2679 | 5.2679 | 5.2679 | 5.2679 | 2800.0 |
| 2008-01-22 05:43:00 | AAPL | Stock | 5.2536 | 5.2536 | 5.2536 | 5.2536 | 5600.0 |
| 2008-01-22 05:46:00 | AAPL | Stock | 5.2679 | 5.2679 | 5.2679 | 5.2679 | 5600.0 |
| 2008-01-22 05:49:00 | AAPL | Stock | 5.25 | 5.25 | 5.25 | 5.25 | 14000.0 |
| 2008-01-22 05:50:00 | AAPL | Stock | 5.2679 | 5.2679 | 5.2679 | 5.2679 | 2828.0 |
| 2008-01-22 05:51:00 | AAPL | Stock | 5.3211 | 5.3211 | 5.3211 | 5.3211 | 5600.0 |
| 2008-01-22 05:52:00 | AAPL | Stock | 5.3211 | 5.3211 | 5.2679 | 5.2804 | 11200.0 |
| 2008-01-22 05:53:00 | AAPL | Stock | 5.2804 | 5.2804 | 5.2804 | 5.2804 | 16800.0 |
| 2008-01-22 05:55:00 | AAPL | Stock | 5.2836 | 5.2836 | 5.2836 | 5.2836 | 14000.0 |
| 2008-01-22 06:01:00 | AAPL | Stock | 5.2821 | 5.2821 | 5.2821 | 5.2821 | 8400.0 |
| 2008-01-22 06:05:00 | AAPL | Stock | 5.3211 | 5.3211 | 5.2821 | 5.3211 | 42000.0 |
| 2008-01-22 06:07:00 | AAPL | Stock | 5.3211 | 5.3211 | 5.3211 | 5.3211 | 15120.0 |
| 2008-01-22 06:08:00 | AAPL | Stock | 5.3211 | 5.3211 | 5.3211 | 5.3211 | 16828.0 |
> showing 50 of 1,121,324 rows — these rows as CSV