PREVIEW / stock_1min / 2010-10-20
file: by_date/stock_1min/2010/2010-10-20.parquet size: 12.7 MB rows: 952,729 symbols: 2,836
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-20 04:07:00 | AAPL | Stock | 11.0318 | 11.0571 | 11.0318 | 11.0571 | 16800.0 |
| 2010-10-20 04:12:00 | AAPL | Stock | 11.0536 | 11.0536 | 11.0536 | 11.0536 | 2800.0 |
| 2010-10-20 04:13:00 | AAPL | Stock | 11.0321 | 11.0321 | 11.0321 | 11.0321 | 2800.0 |
| 2010-10-20 05:01:00 | AAPL | Stock | 11.0446 | 11.0446 | 11.0446 | 11.0446 | 2800.0 |
| 2010-10-20 05:08:00 | AAPL | Stock | 11.0489 | 11.0489 | 11.0489 | 11.0489 | 2800.0 |
| 2010-10-20 05:40:00 | AAPL | Stock | 11.0346 | 11.0346 | 11.0346 | 11.0346 | 3080.0 |
| 2010-10-20 05:42:00 | AAPL | Stock | 11.0346 | 11.0346 | 11.0346 | 11.0346 | 16800.0 |
| 2010-10-20 05:56:00 | AAPL | Stock | 11.0346 | 11.0346 | 11.0346 | 11.0346 | 11172.0 |
| 2010-10-20 06:07:00 | AAPL | Stock | 11.0446 | 11.0446 | 11.0446 | 11.0446 | 8400.0 |
| 2010-10-20 06:14:00 | AAPL | Stock | 11.0536 | 11.0536 | 11.0536 | 11.0536 | 2800.0 |
| 2010-10-20 06:18:00 | AAPL | Stock | 11.0446 | 11.0446 | 11.0446 | 11.0446 | 2800.0 |
| 2010-10-20 06:19:00 | AAPL | Stock | 11.0446 | 11.0446 | 11.0446 | 11.0446 | 2800.0 |
| 2010-10-20 06:25:00 | AAPL | Stock | 11.0446 | 11.0446 | 11.0446 | 11.0446 | 11200.0 |
| 2010-10-20 06:26:00 | AAPL | Stock | 11.0318 | 11.0329 | 11.0318 | 11.0329 | 11200.0 |
| 2010-10-20 06:29:00 | AAPL | Stock | 11.0368 | 11.0368 | 11.0368 | 11.0368 | 2800.0 |
| 2010-10-20 06:30:00 | AAPL | Stock | 11.0293 | 11.0536 | 11.0179 | 11.0179 | 40236.0 |
| 2010-10-20 06:31:00 | AAPL | Stock | 11.0179 | 11.0179 | 11.0179 | 11.0179 | 5600.0 |
| 2010-10-20 06:35:00 | AAPL | Stock | 11.0229 | 11.0229 | 11.0229 | 11.0229 | 8400.0 |
| 2010-10-20 06:36:00 | AAPL | Stock | 11.0357 | 11.0357 | 11.0357 | 11.0357 | 2800.0 |
| 2010-10-20 07:00:00 | AAPL | Stock | 11.0268 | 11.0268 | 11.0232 | 11.0264 | 11200.0 |
| 2010-10-20 07:01:00 | AAPL | Stock | 11.0264 | 11.0264 | 11.0264 | 11.0264 | 2800.0 |
| 2010-10-20 07:03:00 | AAPL | Stock | 11.0264 | 11.0268 | 11.0264 | 11.0268 | 28000.0 |
| 2010-10-20 07:05:00 | AAPL | Stock | 11.0325 | 11.0325 | 11.0325 | 11.0325 | 14000.0 |
| 2010-10-20 07:06:00 | AAPL | Stock | 11.0321 | 11.0321 | 11.0321 | 11.0321 | 14000.0 |
| 2010-10-20 07:08:00 | AAPL | Stock | 11.0318 | 11.0343 | 11.0318 | 11.0343 | 36400.0 |
| 2010-10-20 07:10:00 | AAPL | Stock | 11.0389 | 11.0407 | 11.0389 | 11.0407 | 19740.0 |
| 2010-10-20 07:11:00 | AAPL | Stock | 11.0411 | 11.0411 | 11.0393 | 11.0393 | 30800.0 |
| 2010-10-20 07:12:00 | AAPL | Stock | 11.0439 | 11.0439 | 11.0393 | 11.0436 | 28000.0 |
| 2010-10-20 07:14:00 | AAPL | Stock | 11.0375 | 11.0393 | 11.0375 | 11.0393 | 5600.0 |
| 2010-10-20 07:18:00 | AAPL | Stock | 11.0425 | 11.0432 | 11.0425 | 11.0432 | 39200.0 |
| 2010-10-20 07:19:00 | AAPL | Stock | 11.0411 | 11.0411 | 11.0411 | 11.0411 | 8400.0 |
| 2010-10-20 07:22:00 | AAPL | Stock | 11.0418 | 11.0418 | 11.0418 | 11.0418 | 5600.0 |
| 2010-10-20 07:23:00 | AAPL | Stock | 11.0418 | 11.0418 | 11.0418 | 11.0418 | 2800.0 |
| 2010-10-20 07:24:00 | AAPL | Stock | 11.0418 | 11.0418 | 11.0357 | 11.0357 | 19824.0 |
| 2010-10-20 07:26:00 | AAPL | Stock | 11.0418 | 11.0418 | 11.0418 | 11.0418 | 2800.0 |
| 2010-10-20 07:30:00 | AAPL | Stock | 11.0411 | 11.0418 | 11.0364 | 11.0418 | 70000.0 |
| 2010-10-20 07:31:00 | AAPL | Stock | 11.0364 | 11.0364 | 11.0357 | 11.0357 | 28476.0 |
| 2010-10-20 07:32:00 | AAPL | Stock | 11.035 | 11.035 | 11.035 | 11.035 | 8400.0 |
| 2010-10-20 07:34:00 | AAPL | Stock | 11.0354 | 11.0357 | 11.0354 | 11.0357 | 41944.0 |
| 2010-10-20 07:36:00 | AAPL | Stock | 11.0375 | 11.0375 | 11.0375 | 11.0375 | 2800.0 |
| 2010-10-20 07:38:00 | AAPL | Stock | 11.0382 | 11.0382 | 11.0357 | 11.0357 | 40600.0 |
| 2010-10-20 07:39:00 | AAPL | Stock | 11.0361 | 11.0361 | 11.0361 | 11.0361 | 5600.0 |
| 2010-10-20 07:41:00 | AAPL | Stock | 11.0357 | 11.0357 | 11.0357 | 11.0357 | 5600.0 |
| 2010-10-20 07:43:00 | AAPL | Stock | 11.0439 | 11.0446 | 11.0411 | 11.0411 | 16800.0 |
| 2010-10-20 07:45:00 | AAPL | Stock | 11.0464 | 11.0536 | 11.045 | 11.0536 | 66892.0 |
| 2010-10-20 07:46:00 | AAPL | Stock | 11.0639 | 11.0639 | 11.0536 | 11.0593 | 33600.0 |
| 2010-10-20 07:47:00 | AAPL | Stock | 11.0604 | 11.0604 | 11.0604 | 11.0604 | 2800.0 |
| 2010-10-20 07:48:00 | AAPL | Stock | 11.0579 | 11.0618 | 11.0571 | 11.0618 | 33600.0 |
| 2010-10-20 07:51:00 | AAPL | Stock | 11.0539 | 11.0568 | 11.0536 | 11.0536 | 83720.0 |
| 2010-10-20 07:52:00 | AAPL | Stock | 11.0536 | 11.0536 | 11.045 | 11.045 | 16800.0 |
> showing 50 of 952,729 rows — these rows as CSV