PREVIEW / stock_1min / 2010-11-15
file: by_date/stock_1min/2010/2010-11-15.parquet size: 12.6 MB rows: 948,972 symbols: 2,844
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-11-15 04:05:00 | AAPL | Stock | 11.0154 | 11.0154 | 11.0154 | 11.0154 | 2800.0 |
| 2010-11-15 06:22:00 | AAPL | Stock | 11.0536 | 11.0536 | 11.0536 | 11.0536 | 3640.0 |
| 2010-11-15 06:40:00 | AAPL | Stock | 11.0536 | 11.0536 | 11.0536 | 11.0536 | 8400.0 |
| 2010-11-15 06:47:00 | AAPL | Stock | 11.0625 | 11.0625 | 11.0625 | 11.0625 | 11200.0 |
| 2010-11-15 06:48:00 | AAPL | Stock | 11.0625 | 11.0625 | 11.0625 | 11.0625 | 14000.0 |
| 2010-11-15 06:50:00 | AAPL | Stock | 11.0625 | 11.0625 | 11.0625 | 11.0625 | 5600.0 |
| 2010-11-15 07:01:00 | AAPL | Stock | 11.0536 | 11.0536 | 11.0536 | 11.0536 | 5600.0 |
| 2010-11-15 07:06:00 | AAPL | Stock | 11.0464 | 11.0464 | 11.0464 | 11.0464 | 2800.0 |
| 2010-11-15 07:07:00 | AAPL | Stock | 11.0446 | 11.0446 | 11.0446 | 11.0446 | 2800.0 |
| 2010-11-15 07:09:00 | AAPL | Stock | 11.0532 | 11.0532 | 11.0532 | 11.0532 | 2800.0 |
| 2010-11-15 07:10:00 | AAPL | Stock | 11.0546 | 11.0611 | 11.0539 | 11.0611 | 14000.0 |
| 2010-11-15 07:14:00 | AAPL | Stock | 11.0596 | 11.0611 | 11.0596 | 11.0611 | 102200.0 |
| 2010-11-15 07:16:00 | AAPL | Stock | 11.0611 | 11.0611 | 11.0611 | 11.0611 | 2800.0 |
| 2010-11-15 07:17:00 | AAPL | Stock | 11.0611 | 11.0611 | 11.0611 | 11.0611 | 17080.0 |
| 2010-11-15 07:20:00 | AAPL | Stock | 11.0611 | 11.0693 | 11.0611 | 11.0611 | 61488.0 |
| 2010-11-15 07:24:00 | AAPL | Stock | 11.0611 | 11.0611 | 11.0611 | 11.0611 | 14000.0 |
| 2010-11-15 07:25:00 | AAPL | Stock | 11.0611 | 11.0611 | 11.0611 | 11.0611 | 2800.0 |
| 2010-11-15 07:26:00 | AAPL | Stock | 11.0571 | 11.0571 | 11.0571 | 11.0571 | 7000.0 |
| 2010-11-15 07:29:00 | AAPL | Stock | 11.0564 | 11.0564 | 11.0564 | 11.0564 | 2800.0 |
| 2010-11-15 07:30:00 | AAPL | Stock | 11.0579 | 11.0579 | 11.0579 | 11.0579 | 2800.0 |
| 2010-11-15 07:35:00 | AAPL | Stock | 11.0611 | 11.0632 | 11.0611 | 11.0632 | 39200.0 |
| 2010-11-15 07:36:00 | AAPL | Stock | 11.0679 | 11.0689 | 11.0679 | 11.0689 | 14000.0 |
| 2010-11-15 07:40:00 | AAPL | Stock | 11.0671 | 11.0671 | 11.0671 | 11.0671 | 2800.0 |
| 2010-11-15 07:41:00 | AAPL | Stock | 11.0625 | 11.0625 | 11.0625 | 11.0625 | 2800.0 |
| 2010-11-15 07:42:00 | AAPL | Stock | 11.0586 | 11.0586 | 11.0586 | 11.0586 | 5460.0 |
| 2010-11-15 07:43:00 | AAPL | Stock | 11.0625 | 11.0707 | 11.0625 | 11.0707 | 11200.0 |
| 2010-11-15 07:45:00 | AAPL | Stock | 11.0718 | 11.0718 | 11.0718 | 11.0718 | 2800.0 |
| 2010-11-15 07:46:00 | AAPL | Stock | 11.0707 | 11.0707 | 11.0707 | 11.0707 | 2800.0 |
| 2010-11-15 07:47:00 | AAPL | Stock | 11.0714 | 11.0714 | 11.0714 | 11.0714 | 31108.0 |
| 2010-11-15 07:48:00 | AAPL | Stock | 11.0714 | 11.0714 | 11.0714 | 11.0714 | 5600.0 |
| 2010-11-15 07:51:00 | AAPL | Stock | 11.0732 | 11.0732 | 11.0714 | 11.0714 | 28308.0 |
| 2010-11-15 07:54:00 | AAPL | Stock | 11.0714 | 11.0714 | 11.0714 | 11.0714 | 2800.0 |
| 2010-11-15 07:57:00 | AAPL | Stock | 11.0714 | 11.0764 | 11.0714 | 11.0764 | 22400.0 |
| 2010-11-15 07:58:00 | AAPL | Stock | 11.0714 | 11.0714 | 11.0714 | 11.0714 | 2800.0 |
| 2010-11-15 08:00:00 | AAPL | Stock | 11.0625 | 11.0714 | 11.05 | 11.05 | 126280.0 |
| 2010-11-15 08:01:00 | AAPL | Stock | 11.0489 | 11.055 | 11.0489 | 11.055 | 18760.0 |
| 2010-11-15 08:02:00 | AAPL | Stock | 11.0625 | 11.0786 | 11.0625 | 11.0786 | 167160.0 |
| 2010-11-15 08:03:00 | AAPL | Stock | 11.0754 | 11.0786 | 11.075 | 11.0761 | 99540.0 |
| 2010-11-15 08:04:00 | AAPL | Stock | 11.0757 | 11.0786 | 11.0757 | 11.0782 | 23800.0 |
| 2010-11-15 08:05:00 | AAPL | Stock | 11.0786 | 11.0786 | 11.0571 | 11.0711 | 341740.0 |
| 2010-11-15 08:06:00 | AAPL | Stock | 11.0707 | 11.0707 | 11.0693 | 11.0707 | 14000.0 |
| 2010-11-15 08:07:00 | AAPL | Stock | 11.0679 | 11.0707 | 11.0625 | 11.0675 | 40180.0 |
| 2010-11-15 08:08:00 | AAPL | Stock | 11.0711 | 11.0768 | 11.0711 | 11.0768 | 52472.0 |
| 2010-11-15 08:09:00 | AAPL | Stock | 11.0714 | 11.0714 | 11.0679 | 11.0714 | 36232.0 |
| 2010-11-15 08:10:00 | AAPL | Stock | 11.0714 | 11.0714 | 11.0714 | 11.0714 | 13020.0 |
| 2010-11-15 08:11:00 | AAPL | Stock | 11.0714 | 11.0714 | 11.0686 | 11.0689 | 50904.0 |
| 2010-11-15 08:12:00 | AAPL | Stock | 11.0711 | 11.0714 | 11.0682 | 11.0682 | 35560.0 |
| 2010-11-15 08:13:00 | AAPL | Stock | 11.0714 | 11.0714 | 11.0711 | 11.0711 | 22400.0 |
| 2010-11-15 08:14:00 | AAPL | Stock | 11.0714 | 11.0786 | 11.0714 | 11.0746 | 91112.0 |
| 2010-11-15 08:15:00 | AAPL | Stock | 11.0746 | 11.0786 | 11.0714 | 11.0718 | 210112.0 |
> showing 50 of 948,972 rows — these rows as CSV