PREVIEW / stock_1min / 2007-02-05
file: by_date/stock_1min/2007/2007-02-05.parquet size: 9.1 MB rows: 744,589 symbols: 2,031
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 |
|---|---|---|---|---|---|---|---|
| 2007-02-05 07:12:00 | AAPL | Stock | 3.0154 | 3.0154 | 3.0154 | 3.0154 | 9800.0 |
| 2007-02-05 07:18:00 | AAPL | Stock | 3.0154 | 3.0154 | 3.0154 | 3.0154 | 2800.0 |
| 2007-02-05 07:38:00 | AAPL | Stock | 3.0157 | 3.0157 | 3.0157 | 3.0157 | 2800.0 |
| 2007-02-05 08:00:00 | AAPL | Stock | 3.015 | 3.0179 | 3.0054 | 3.0179 | 91952.0 |
| 2007-02-05 08:02:00 | AAPL | Stock | 3.0161 | 3.0161 | 3.0161 | 3.0161 | 28000.0 |
| 2007-02-05 08:04:00 | AAPL | Stock | 3.0157 | 3.0161 | 3.0157 | 3.0161 | 11200.0 |
| 2007-02-05 08:11:00 | AAPL | Stock | 3.0111 | 3.0114 | 3.0111 | 3.0114 | 11200.0 |
| 2007-02-05 08:12:00 | AAPL | Stock | 3.0107 | 3.0107 | 3.0093 | 3.0107 | 67200.0 |
| 2007-02-05 08:13:00 | AAPL | Stock | 3.0104 | 3.0129 | 3.0104 | 3.0107 | 64120.0 |
| 2007-02-05 08:15:00 | AAPL | Stock | 3.0093 | 3.0107 | 3.0089 | 3.0089 | 54320.0 |
| 2007-02-05 08:17:00 | AAPL | Stock | 3.0082 | 3.0093 | 3.0082 | 3.0093 | 19600.0 |
| 2007-02-05 08:18:00 | AAPL | Stock | 3.0111 | 3.0111 | 3.0111 | 3.0111 | 2800.0 |
| 2007-02-05 08:20:00 | AAPL | Stock | 3.0111 | 3.0111 | 3.0107 | 3.0107 | 8400.0 |
| 2007-02-05 08:23:00 | AAPL | Stock | 3.0111 | 3.0161 | 3.0111 | 3.0111 | 67620.0 |
| 2007-02-05 08:25:00 | AAPL | Stock | 3.0111 | 3.0111 | 3.0111 | 3.0111 | 7980.0 |
| 2007-02-05 08:27:00 | AAPL | Stock | 3.0125 | 3.0125 | 3.0111 | 3.0111 | 11620.0 |
| 2007-02-05 08:28:00 | AAPL | Stock | 3.0107 | 3.0107 | 3.0107 | 3.0107 | 6440.0 |
| 2007-02-05 08:30:00 | AAPL | Stock | 3.0107 | 3.0143 | 3.0107 | 3.0143 | 45080.0 |
| 2007-02-05 08:31:00 | AAPL | Stock | 3.0143 | 3.0179 | 3.0143 | 3.0161 | 189420.0 |
| 2007-02-05 08:32:00 | AAPL | Stock | 3.0161 | 3.0196 | 3.0125 | 3.0179 | 53116.0 |
| 2007-02-05 08:34:00 | AAPL | Stock | 3.0175 | 3.0196 | 3.0107 | 3.0125 | 176624.0 |
| 2007-02-05 08:36:00 | AAPL | Stock | 3.0171 | 3.0179 | 3.0171 | 3.0179 | 36400.0 |
| 2007-02-05 08:37:00 | AAPL | Stock | 3.0179 | 3.0179 | 3.0179 | 3.0179 | 28000.0 |
| 2007-02-05 08:38:00 | AAPL | Stock | 3.0179 | 3.0179 | 3.0179 | 3.0179 | 75600.0 |
| 2007-02-05 08:39:00 | AAPL | Stock | 3.0179 | 3.0179 | 3.0179 | 3.0179 | 14000.0 |
| 2007-02-05 08:40:00 | AAPL | Stock | 3.0161 | 3.0161 | 3.0161 | 3.0161 | 14000.0 |
| 2007-02-05 08:41:00 | AAPL | Stock | 3.0179 | 3.0179 | 3.0179 | 3.0179 | 30940.0 |
| 2007-02-05 08:42:00 | AAPL | Stock | 3.0179 | 3.0179 | 3.0179 | 3.0179 | 15960.0 |
| 2007-02-05 08:43:00 | AAPL | Stock | 3.0179 | 3.0196 | 3.0179 | 3.0196 | 59640.0 |
| 2007-02-05 08:44:00 | AAPL | Stock | 3.0196 | 3.0196 | 3.0196 | 3.0196 | 5600.0 |
| 2007-02-05 08:46:00 | AAPL | Stock | 3.0164 | 3.0164 | 3.0164 | 3.0164 | 2800.0 |
| 2007-02-05 08:47:00 | AAPL | Stock | 3.0193 | 3.0193 | 3.0179 | 3.0179 | 12600.0 |
| 2007-02-05 08:49:00 | AAPL | Stock | 3.0196 | 3.0225 | 3.0196 | 3.0225 | 30800.0 |
| 2007-02-05 08:51:00 | AAPL | Stock | 3.02 | 3.02 | 3.02 | 3.02 | 11200.0 |
| 2007-02-05 08:52:00 | AAPL | Stock | 3.0225 | 3.0225 | 3.0225 | 3.0225 | 14000.0 |
| 2007-02-05 08:54:00 | AAPL | Stock | 3.0225 | 3.0225 | 3.02 | 3.02 | 47600.0 |
| 2007-02-05 08:55:00 | AAPL | Stock | 3.02 | 3.0261 | 3.02 | 3.0261 | 299712.0 |
| 2007-02-05 08:56:00 | AAPL | Stock | 3.025 | 3.0261 | 3.025 | 3.0261 | 9856.0 |
| 2007-02-05 08:57:00 | AAPL | Stock | 3.025 | 3.0254 | 3.0246 | 3.0246 | 39200.0 |
| 2007-02-05 08:59:00 | AAPL | Stock | 3.025 | 3.025 | 3.025 | 3.025 | 21000.0 |
| 2007-02-05 09:02:00 | AAPL | Stock | 3.0218 | 3.025 | 3.0214 | 3.0239 | 19600.0 |
| 2007-02-05 09:03:00 | AAPL | Stock | 3.0239 | 3.025 | 3.0239 | 3.025 | 14000.0 |
| 2007-02-05 09:04:00 | AAPL | Stock | 3.0232 | 3.0232 | 3.0129 | 3.0182 | 485660.0 |
| 2007-02-05 09:05:00 | AAPL | Stock | 3.0182 | 3.0182 | 3.0179 | 3.0182 | 49000.0 |
| 2007-02-05 09:06:00 | AAPL | Stock | 3.0161 | 3.0161 | 3.0125 | 3.0125 | 24836.0 |
| 2007-02-05 09:07:00 | AAPL | Stock | 3.0125 | 3.0125 | 3.0121 | 3.0125 | 76160.0 |
| 2007-02-05 09:08:00 | AAPL | Stock | 3.0125 | 3.0125 | 3.0107 | 3.0125 | 224000.0 |
| 2007-02-05 09:09:00 | AAPL | Stock | 3.0125 | 3.0125 | 3.0125 | 3.0125 | 6804.0 |
| 2007-02-05 09:10:00 | AAPL | Stock | 3.0118 | 3.0182 | 3.0029 | 3.0179 | 506520.0 |
| 2007-02-05 09:11:00 | AAPL | Stock | 3.0171 | 3.0171 | 3.0139 | 3.0139 | 5600.0 |
> showing 50 of 744,589 rows — these rows as CSV