PREVIEW / stock_1min / 2011-01-31
file: by_date/stock_1min/2011/2011-01-31.parquet size: 13.6 MB rows: 1,015,344 symbols: 2,873
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-31 04:19:00 | AAPL | Stock | 11.9654 | 11.9654 | 11.9654 | 11.9654 | 2800.0 |
| 2011-01-31 04:46:00 | AAPL | Stock | 11.9929 | 11.9929 | 11.9929 | 11.9929 | 16520.0 |
| 2011-01-31 05:12:00 | AAPL | Stock | 11.9893 | 11.9929 | 11.9893 | 11.9929 | 5600.0 |
| 2011-01-31 05:27:00 | AAPL | Stock | 11.9971 | 11.9971 | 11.9971 | 11.9971 | 2800.0 |
| 2011-01-31 05:55:00 | AAPL | Stock | 11.9836 | 11.9836 | 11.9836 | 11.9836 | 5600.0 |
| 2011-01-31 06:07:00 | AAPL | Stock | 12.0082 | 12.0096 | 12.0082 | 12.0096 | 17360.0 |
| 2011-01-31 06:26:00 | AAPL | Stock | 12.0289 | 12.0289 | 12.0289 | 12.0289 | 5600.0 |
| 2011-01-31 06:50:00 | AAPL | Stock | 12.0139 | 12.0139 | 12.0096 | 12.0096 | 8400.0 |
| 2011-01-31 07:00:00 | AAPL | Stock | 12.0214 | 12.0214 | 12.0214 | 12.0214 | 4200.0 |
| 2011-01-31 07:03:00 | AAPL | Stock | 12.0139 | 12.0143 | 12.0139 | 12.0143 | 16100.0 |
| 2011-01-31 07:10:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 12320.0 |
| 2011-01-31 07:11:00 | AAPL | Stock | 12.0 | 12.0 | 12.0 | 12.0 | 6748.0 |
| 2011-01-31 07:19:00 | AAPL | Stock | 12.0121 | 12.0121 | 12.0036 | 12.0036 | 10668.0 |
| 2011-01-31 07:22:00 | AAPL | Stock | 12.0161 | 12.0214 | 12.0161 | 12.0214 | 38892.0 |
| 2011-01-31 07:23:00 | AAPL | Stock | 12.0332 | 12.0339 | 12.0254 | 12.0254 | 31640.0 |
| 2011-01-31 07:24:00 | AAPL | Stock | 12.0257 | 12.0257 | 12.0196 | 12.0196 | 14000.0 |
| 2011-01-31 07:26:00 | AAPL | Stock | 12.0243 | 12.0243 | 12.0243 | 12.0243 | 2800.0 |
| 2011-01-31 07:31:00 | AAPL | Stock | 12.0111 | 12.0268 | 12.0111 | 12.0268 | 13384.0 |
| 2011-01-31 07:32:00 | AAPL | Stock | 12.0336 | 12.0336 | 12.0336 | 12.0336 | 2800.0 |
| 2011-01-31 07:33:00 | AAPL | Stock | 12.035 | 12.0354 | 12.035 | 12.0354 | 5600.0 |
| 2011-01-31 07:34:00 | AAPL | Stock | 12.0354 | 12.0393 | 12.0354 | 12.0393 | 23828.0 |
| 2011-01-31 07:36:00 | AAPL | Stock | 12.0464 | 12.05 | 12.0411 | 12.0411 | 55160.0 |
| 2011-01-31 07:37:00 | AAPL | Stock | 12.0464 | 12.0493 | 12.0464 | 12.0493 | 14000.0 |
| 2011-01-31 07:38:00 | AAPL | Stock | 12.0532 | 12.0532 | 12.0532 | 12.0532 | 2800.0 |
| 2011-01-31 07:39:00 | AAPL | Stock | 12.0486 | 12.0532 | 12.0464 | 12.0464 | 13300.0 |
| 2011-01-31 07:40:00 | AAPL | Stock | 12.0521 | 12.0571 | 12.0521 | 12.0536 | 86940.0 |
| 2011-01-31 07:42:00 | AAPL | Stock | 12.0536 | 12.0536 | 12.0464 | 12.0464 | 28168.0 |
| 2011-01-31 07:43:00 | AAPL | Stock | 12.0464 | 12.0464 | 12.0464 | 12.0464 | 14000.0 |
| 2011-01-31 07:44:00 | AAPL | Stock | 12.0471 | 12.0471 | 12.0471 | 12.0471 | 2800.0 |
| 2011-01-31 07:45:00 | AAPL | Stock | 12.0471 | 12.0471 | 12.0471 | 12.0471 | 11200.0 |
| 2011-01-31 07:46:00 | AAPL | Stock | 12.05 | 12.05 | 12.0468 | 12.0468 | 20020.0 |
| 2011-01-31 07:47:00 | AAPL | Stock | 12.05 | 12.05 | 12.05 | 12.05 | 8400.0 |
| 2011-01-31 07:48:00 | AAPL | Stock | 12.0496 | 12.0496 | 12.0496 | 12.0496 | 2800.0 |
| 2011-01-31 07:50:00 | AAPL | Stock | 12.0536 | 12.0536 | 12.0536 | 12.0536 | 2800.0 |
| 2011-01-31 07:54:00 | AAPL | Stock | 12.0536 | 12.0536 | 12.0536 | 12.0536 | 2800.0 |
| 2011-01-31 07:58:00 | AAPL | Stock | 12.0525 | 12.0525 | 12.0525 | 12.0525 | 2800.0 |
| 2011-01-31 08:00:00 | AAPL | Stock | 12.0386 | 12.0536 | 12.0021 | 12.0264 | 128632.0 |
| 2011-01-31 08:01:00 | AAPL | Stock | 12.025 | 12.0307 | 12.0143 | 12.025 | 39844.0 |
| 2011-01-31 08:02:00 | AAPL | Stock | 12.0179 | 12.0179 | 12.0179 | 12.0179 | 4760.0 |
| 2011-01-31 08:03:00 | AAPL | Stock | 12.0182 | 12.0236 | 12.0161 | 12.0236 | 13160.0 |
| 2011-01-31 08:04:00 | AAPL | Stock | 12.0107 | 12.0161 | 12.0089 | 12.0161 | 22680.0 |
| 2011-01-31 08:05:00 | AAPL | Stock | 12.0175 | 12.0246 | 12.0161 | 12.0232 | 32900.0 |
| 2011-01-31 08:06:00 | AAPL | Stock | 12.0196 | 12.025 | 12.0179 | 12.025 | 80080.0 |
| 2011-01-31 08:08:00 | AAPL | Stock | 12.025 | 12.035 | 12.025 | 12.035 | 32200.0 |
| 2011-01-31 08:09:00 | AAPL | Stock | 12.0354 | 12.0357 | 12.0354 | 12.0357 | 14000.0 |
| 2011-01-31 08:10:00 | AAPL | Stock | 12.0357 | 12.0464 | 12.0357 | 12.0418 | 55580.0 |
| 2011-01-31 08:11:00 | AAPL | Stock | 12.0479 | 12.0479 | 12.0436 | 12.0436 | 5600.0 |
| 2011-01-31 08:12:00 | AAPL | Stock | 12.0482 | 12.0536 | 12.0482 | 12.05 | 162596.0 |
| 2011-01-31 08:13:00 | AAPL | Stock | 12.0507 | 12.0507 | 12.0468 | 12.0468 | 5600.0 |
| 2011-01-31 08:15:00 | AAPL | Stock | 12.0493 | 12.05 | 12.0464 | 12.0464 | 81620.0 |
> showing 50 of 1,015,344 rows — these rows as CSV