PREVIEW / stock_1min / 2013-07-10
file: by_date/stock_1min/2013/2013-07-10.parquet size: 13.2 MB rows: 976,713 symbols: 2,829
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-10 04:00:00 | AAPL | Stock | 15.1232 | 15.1232 | 15.1232 | 15.1232 | 8400.0 |
| 2013-07-10 06:17:00 | AAPL | Stock | 15.0679 | 15.0679 | 15.0679 | 15.0679 | 4256.0 |
| 2013-07-10 06:19:00 | AAPL | Stock | 15.0679 | 15.0679 | 15.0679 | 15.0679 | 2800.0 |
| 2013-07-10 06:22:00 | AAPL | Stock | 15.0679 | 15.0679 | 15.0679 | 15.0679 | 4256.0 |
| 2013-07-10 06:27:00 | AAPL | Stock | 15.0679 | 15.0679 | 15.0679 | 15.0679 | 8400.0 |
| 2013-07-10 06:48:00 | AAPL | Stock | 15.0718 | 15.0718 | 15.0718 | 15.0718 | 11200.0 |
| 2013-07-10 06:53:00 | AAPL | Stock | 15.0718 | 15.0718 | 15.0718 | 15.0718 | 2800.0 |
| 2013-07-10 06:56:00 | AAPL | Stock | 15.0718 | 15.0718 | 15.0718 | 15.0718 | 5600.0 |
| 2013-07-10 07:20:00 | AAPL | Stock | 15.0718 | 15.0718 | 15.0714 | 15.0714 | 7364.0 |
| 2013-07-10 07:25:00 | AAPL | Stock | 15.0414 | 15.0414 | 15.0414 | 15.0414 | 2800.0 |
| 2013-07-10 07:27:00 | AAPL | Stock | 15.0393 | 15.0468 | 15.0393 | 15.0393 | 22400.0 |
| 2013-07-10 07:32:00 | AAPL | Stock | 15.0421 | 15.0421 | 15.0357 | 15.0357 | 22400.0 |
| 2013-07-10 07:50:00 | AAPL | Stock | 15.0375 | 15.0375 | 15.0368 | 15.0368 | 14000.0 |
| 2013-07-10 07:51:00 | AAPL | Stock | 15.0318 | 15.0318 | 15.0318 | 15.0318 | 2800.0 |
| 2013-07-10 07:55:00 | AAPL | Stock | 15.0218 | 15.0218 | 15.0218 | 15.0218 | 8400.0 |
| 2013-07-10 07:58:00 | AAPL | Stock | 15.0218 | 15.0218 | 15.0218 | 15.0218 | 2800.0 |
| 2013-07-10 07:59:00 | AAPL | Stock | 15.0232 | 15.0232 | 15.0079 | 15.0079 | 46200.0 |
| 2013-07-10 08:00:00 | AAPL | Stock | 15.0164 | 15.0307 | 15.0096 | 15.0096 | 69636.0 |
| 2013-07-10 08:01:00 | AAPL | Stock | 15.0079 | 15.0146 | 15.0079 | 15.0146 | 5600.0 |
| 2013-07-10 08:02:00 | AAPL | Stock | 15.0179 | 15.0196 | 15.0179 | 15.0196 | 11200.0 |
| 2013-07-10 08:03:00 | AAPL | Stock | 15.0189 | 15.0318 | 15.0079 | 15.0318 | 181664.0 |
| 2013-07-10 08:04:00 | AAPL | Stock | 15.0286 | 15.0286 | 15.0286 | 15.0286 | 2800.0 |
| 2013-07-10 08:05:00 | AAPL | Stock | 15.0304 | 15.045 | 15.0304 | 15.045 | 16800.0 |
| 2013-07-10 08:08:00 | AAPL | Stock | 15.0446 | 15.0546 | 15.0446 | 15.0536 | 47320.0 |
| 2013-07-10 08:09:00 | AAPL | Stock | 15.0571 | 15.0668 | 15.0536 | 15.0668 | 25340.0 |
| 2013-07-10 08:10:00 | AAPL | Stock | 15.0568 | 15.0568 | 15.0568 | 15.0568 | 3836.0 |
| 2013-07-10 08:11:00 | AAPL | Stock | 15.0507 | 15.0507 | 15.0507 | 15.0507 | 2800.0 |
| 2013-07-10 08:12:00 | AAPL | Stock | 15.0432 | 15.0432 | 15.0432 | 15.0432 | 2800.0 |
| 2013-07-10 08:16:00 | AAPL | Stock | 15.0357 | 15.0357 | 15.0357 | 15.0357 | 3360.0 |
| 2013-07-10 08:17:00 | AAPL | Stock | 15.0357 | 15.0364 | 15.0357 | 15.0357 | 20412.0 |
| 2013-07-10 08:18:00 | AAPL | Stock | 15.0393 | 15.0393 | 15.0393 | 15.0393 | 2800.0 |
| 2013-07-10 08:21:00 | AAPL | Stock | 15.0554 | 15.0554 | 15.0554 | 15.0554 | 2800.0 |
| 2013-07-10 08:22:00 | AAPL | Stock | 15.04 | 15.04 | 15.0382 | 15.0393 | 22400.0 |
| 2013-07-10 08:23:00 | AAPL | Stock | 15.0393 | 15.0393 | 15.0393 | 15.0393 | 8400.0 |
| 2013-07-10 08:27:00 | AAPL | Stock | 15.0479 | 15.0479 | 15.0464 | 15.0464 | 11200.0 |
| 2013-07-10 08:28:00 | AAPL | Stock | 15.0564 | 15.0564 | 15.0564 | 15.0564 | 5600.0 |
| 2013-07-10 08:30:00 | AAPL | Stock | 15.0539 | 15.0539 | 15.0518 | 15.0518 | 8400.0 |
| 2013-07-10 08:31:00 | AAPL | Stock | 15.0536 | 15.0536 | 15.0536 | 15.0536 | 2800.0 |
| 2013-07-10 08:37:00 | AAPL | Stock | 15.0654 | 15.0654 | 15.0579 | 15.0579 | 6216.0 |
| 2013-07-10 08:38:00 | AAPL | Stock | 15.0643 | 15.0643 | 15.0536 | 15.0536 | 50400.0 |
| 2013-07-10 08:39:00 | AAPL | Stock | 15.055 | 15.055 | 15.055 | 15.055 | 2800.0 |
| 2013-07-10 08:40:00 | AAPL | Stock | 15.0557 | 15.0557 | 15.0536 | 15.0536 | 37212.0 |
| 2013-07-10 08:41:00 | AAPL | Stock | 15.05 | 15.05 | 15.0382 | 15.0382 | 5600.0 |
| 2013-07-10 08:42:00 | AAPL | Stock | 15.0368 | 15.0482 | 15.0368 | 15.0443 | 15848.0 |
| 2013-07-10 08:43:00 | AAPL | Stock | 15.0375 | 15.0375 | 15.0375 | 15.0375 | 2800.0 |
| 2013-07-10 08:44:00 | AAPL | Stock | 15.0436 | 15.0507 | 15.0436 | 15.0507 | 8400.0 |
| 2013-07-10 08:45:00 | AAPL | Stock | 15.0421 | 15.0421 | 15.0386 | 15.0386 | 16800.0 |
| 2013-07-10 08:46:00 | AAPL | Stock | 15.0411 | 15.0411 | 15.0411 | 15.0411 | 2800.0 |
| 2013-07-10 08:47:00 | AAPL | Stock | 15.0396 | 15.0396 | 15.0396 | 15.0396 | 2800.0 |
| 2013-07-10 08:48:00 | AAPL | Stock | 15.0386 | 15.0518 | 15.0386 | 15.0518 | 16800.0 |
> showing 50 of 976,713 rows — these rows as CSV