PREVIEW / stock_1min / 2013-04-19
file: by_date/stock_1min/2013/2013-04-19.parquet size: 12.8 MB rows: 951,342 symbols: 2,811
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-04-19 04:14:00 | AAPL | Stock | 14.0264 | 14.0264 | 14.0264 | 14.0264 | 11200.0 |
| 2013-04-19 04:18:00 | AAPL | Stock | 14.0268 | 14.0268 | 14.0268 | 14.0268 | 2800.0 |
| 2013-04-19 04:19:00 | AAPL | Stock | 14.0264 | 14.0264 | 14.0264 | 14.0264 | 11200.0 |
| 2013-04-19 04:20:00 | AAPL | Stock | 14.0268 | 14.0268 | 14.0268 | 14.0268 | 2800.0 |
| 2013-04-19 04:50:00 | AAPL | Stock | 14.0496 | 14.0496 | 14.0496 | 14.0496 | 5600.0 |
| 2013-04-19 04:51:00 | AAPL | Stock | 14.0536 | 14.0536 | 14.0536 | 14.0536 | 2800.0 |
| 2013-04-19 05:05:00 | AAPL | Stock | 14.0557 | 14.0557 | 14.0557 | 14.0557 | 2800.0 |
| 2013-04-19 05:30:00 | AAPL | Stock | 14.0536 | 14.0536 | 14.0536 | 14.0536 | 20496.0 |
| 2013-04-19 05:34:00 | AAPL | Stock | 14.0486 | 14.0486 | 14.0486 | 14.0486 | 2800.0 |
| 2013-04-19 05:46:00 | AAPL | Stock | 14.0679 | 14.0679 | 14.0679 | 14.0679 | 2800.0 |
| 2013-04-19 06:02:00 | AAPL | Stock | 14.0779 | 14.0779 | 14.0779 | 14.0779 | 2800.0 |
| 2013-04-19 06:15:00 | AAPL | Stock | 14.0779 | 14.0779 | 14.0779 | 14.0779 | 2800.0 |
| 2013-04-19 06:21:00 | AAPL | Stock | 14.0786 | 14.0786 | 14.0786 | 14.0786 | 5600.0 |
| 2013-04-19 06:31:00 | AAPL | Stock | 14.0632 | 14.0632 | 14.0486 | 14.0486 | 27244.0 |
| 2013-04-19 06:48:00 | AAPL | Stock | 14.0796 | 14.0796 | 14.0782 | 14.0796 | 8764.0 |
| 2013-04-19 07:00:00 | AAPL | Stock | 14.0607 | 14.0786 | 14.0536 | 14.0786 | 8596.0 |
| 2013-04-19 07:09:00 | AAPL | Stock | 14.0707 | 14.0707 | 14.0707 | 14.0707 | 2800.0 |
| 2013-04-19 07:10:00 | AAPL | Stock | 14.0696 | 14.0707 | 14.0696 | 14.0707 | 14000.0 |
| 2013-04-19 07:11:00 | AAPL | Stock | 14.07 | 14.07 | 14.07 | 14.07 | 5600.0 |
| 2013-04-19 07:13:00 | AAPL | Stock | 14.0554 | 14.0614 | 14.0554 | 14.0614 | 5600.0 |
| 2013-04-19 07:15:00 | AAPL | Stock | 14.0486 | 14.0614 | 14.0486 | 14.0614 | 16548.0 |
| 2013-04-19 07:16:00 | AAPL | Stock | 14.0536 | 14.0625 | 14.0536 | 14.0625 | 22400.0 |
| 2013-04-19 07:20:00 | AAPL | Stock | 14.0571 | 14.0571 | 14.0571 | 14.0571 | 9940.0 |
| 2013-04-19 07:22:00 | AAPL | Stock | 14.0625 | 14.0625 | 14.0625 | 14.0625 | 2800.0 |
| 2013-04-19 07:24:00 | AAPL | Stock | 14.0714 | 14.0714 | 14.0643 | 14.0643 | 5852.0 |
| 2013-04-19 07:25:00 | AAPL | Stock | 14.0714 | 14.0714 | 14.0714 | 14.0714 | 16800.0 |
| 2013-04-19 07:26:00 | AAPL | Stock | 14.0714 | 14.0714 | 14.0714 | 14.0714 | 8932.0 |
| 2013-04-19 07:30:00 | AAPL | Stock | 14.0736 | 14.0736 | 14.0714 | 14.0714 | 16912.0 |
| 2013-04-19 07:32:00 | AAPL | Stock | 14.0536 | 14.0536 | 14.0529 | 14.0529 | 8400.0 |
| 2013-04-19 07:33:00 | AAPL | Stock | 14.0571 | 14.0571 | 14.0529 | 14.0529 | 5600.0 |
| 2013-04-19 07:34:00 | AAPL | Stock | 14.0536 | 14.0536 | 14.0536 | 14.0536 | 2800.0 |
| 2013-04-19 07:35:00 | AAPL | Stock | 14.0393 | 14.0393 | 14.0393 | 14.0393 | 2800.0 |
| 2013-04-19 07:36:00 | AAPL | Stock | 14.0514 | 14.0514 | 14.0514 | 14.0514 | 2800.0 |
| 2013-04-19 07:37:00 | AAPL | Stock | 14.0536 | 14.0714 | 14.0536 | 14.0714 | 50120.0 |
| 2013-04-19 07:38:00 | AAPL | Stock | 14.0557 | 14.0557 | 14.0507 | 14.0507 | 5880.0 |
| 2013-04-19 07:41:00 | AAPL | Stock | 14.0543 | 14.0571 | 14.0539 | 14.0571 | 15400.0 |
| 2013-04-19 07:42:00 | AAPL | Stock | 14.0675 | 14.0675 | 14.0675 | 14.0675 | 2800.0 |
| 2013-04-19 07:43:00 | AAPL | Stock | 14.0607 | 14.0607 | 14.0607 | 14.0607 | 8400.0 |
| 2013-04-19 07:45:00 | AAPL | Stock | 14.0611 | 14.0643 | 14.0611 | 14.0643 | 11200.0 |
| 2013-04-19 07:46:00 | AAPL | Stock | 14.0611 | 14.0614 | 14.0611 | 14.0614 | 5600.0 |
| 2013-04-19 07:47:00 | AAPL | Stock | 14.0679 | 14.0679 | 14.0625 | 14.0675 | 8400.0 |
| 2013-04-19 07:49:00 | AAPL | Stock | 14.0589 | 14.0589 | 14.0589 | 14.0589 | 5600.0 |
| 2013-04-19 07:50:00 | AAPL | Stock | 14.0536 | 14.0571 | 14.0464 | 14.0554 | 106400.0 |
| 2013-04-19 07:51:00 | AAPL | Stock | 14.0479 | 14.0479 | 14.0468 | 14.0468 | 23800.0 |
| 2013-04-19 07:52:00 | AAPL | Stock | 14.0475 | 14.0482 | 14.0368 | 14.0368 | 22400.0 |
| 2013-04-19 07:54:00 | AAPL | Stock | 14.045 | 14.045 | 14.045 | 14.045 | 2800.0 |
| 2013-04-19 07:57:00 | AAPL | Stock | 14.0446 | 14.0446 | 14.0436 | 14.0446 | 8400.0 |
| 2013-04-19 07:58:00 | AAPL | Stock | 14.0464 | 14.0464 | 14.0464 | 14.0464 | 2800.0 |
| 2013-04-19 07:59:00 | AAPL | Stock | 14.0446 | 14.0446 | 14.0361 | 14.0361 | 17080.0 |
| 2013-04-19 08:00:00 | AAPL | Stock | 14.0507 | 14.0714 | 14.0357 | 14.0432 | 147532.0 |
> showing 50 of 951,342 rows — these rows as CSV