PREVIEW / stock_1min / 2011-01-25
file: by_date/stock_1min/2011/2011-01-25.parquet size: 13.2 MB rows: 989,576 symbols: 2,862
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-25 05:37:00 | AAPL | Stock | 12.04 | 12.04 | 12.04 | 12.04 | 2800.0 |
| 2011-01-25 05:51:00 | AAPL | Stock | 12.0446 | 12.0446 | 12.0446 | 12.0446 | 5600.0 |
| 2011-01-25 06:01:00 | AAPL | Stock | 12.0518 | 12.0518 | 12.0518 | 12.0518 | 2800.0 |
| 2011-01-25 06:25:00 | AAPL | Stock | 12.0429 | 12.0429 | 12.0429 | 12.0429 | 2800.0 |
| 2011-01-25 06:31:00 | AAPL | Stock | 12.0568 | 12.0568 | 12.0568 | 12.0568 | 2800.0 |
| 2011-01-25 07:02:00 | AAPL | Stock | 12.0625 | 12.0625 | 12.0625 | 12.0625 | 8400.0 |
| 2011-01-25 07:03:00 | AAPL | Stock | 12.0679 | 12.0679 | 12.0675 | 12.0675 | 5600.0 |
| 2011-01-25 07:04:00 | AAPL | Stock | 12.0536 | 12.0536 | 12.0536 | 12.0536 | 2800.0 |
| 2011-01-25 07:05:00 | AAPL | Stock | 12.0643 | 12.0643 | 12.0643 | 12.0643 | 2800.0 |
| 2011-01-25 07:06:00 | AAPL | Stock | 12.0607 | 12.0607 | 12.0607 | 12.0607 | 5600.0 |
| 2011-01-25 07:07:00 | AAPL | Stock | 12.0629 | 12.0643 | 12.0629 | 12.0643 | 5600.0 |
| 2011-01-25 07:10:00 | AAPL | Stock | 12.0679 | 12.0679 | 12.0679 | 12.0679 | 5600.0 |
| 2011-01-25 07:11:00 | AAPL | Stock | 12.0711 | 12.0714 | 12.0711 | 12.0714 | 8400.0 |
| 2011-01-25 07:12:00 | AAPL | Stock | 12.0714 | 12.0714 | 12.0714 | 12.0714 | 2800.0 |
| 2011-01-25 07:14:00 | AAPL | Stock | 12.0707 | 12.0707 | 12.0707 | 12.0707 | 2800.0 |
| 2011-01-25 07:16:00 | AAPL | Stock | 12.0711 | 12.0711 | 12.0711 | 12.0711 | 2800.0 |
| 2011-01-25 07:17:00 | AAPL | Stock | 12.065 | 12.0704 | 12.0629 | 12.065 | 28280.0 |
| 2011-01-25 07:18:00 | AAPL | Stock | 12.0707 | 12.0707 | 12.0707 | 12.0707 | 5600.0 |
| 2011-01-25 07:20:00 | AAPL | Stock | 12.0714 | 12.0714 | 12.0625 | 12.0625 | 15344.0 |
| 2011-01-25 07:22:00 | AAPL | Stock | 12.0579 | 12.0579 | 12.0579 | 12.0579 | 2800.0 |
| 2011-01-25 07:23:00 | AAPL | Stock | 12.0571 | 12.0571 | 12.0571 | 12.0571 | 5600.0 |
| 2011-01-25 07:24:00 | AAPL | Stock | 12.0493 | 12.0575 | 12.0493 | 12.0571 | 29260.0 |
| 2011-01-25 07:26:00 | AAPL | Stock | 12.0625 | 12.0625 | 12.0625 | 12.0625 | 2800.0 |
| 2011-01-25 07:28:00 | AAPL | Stock | 12.0579 | 12.0579 | 12.0579 | 12.0579 | 2800.0 |
| 2011-01-25 07:29:00 | AAPL | Stock | 12.0582 | 12.0582 | 12.0571 | 12.0571 | 7280.0 |
| 2011-01-25 07:31:00 | AAPL | Stock | 12.0661 | 12.0661 | 12.0661 | 12.0661 | 5600.0 |
| 2011-01-25 07:36:00 | AAPL | Stock | 12.0646 | 12.0646 | 12.0646 | 12.0646 | 2800.0 |
| 2011-01-25 07:38:00 | AAPL | Stock | 12.0643 | 12.0643 | 12.0618 | 12.0618 | 5600.0 |
| 2011-01-25 07:39:00 | AAPL | Stock | 12.0607 | 12.0607 | 12.0607 | 12.0607 | 5600.0 |
| 2011-01-25 07:40:00 | AAPL | Stock | 12.0575 | 12.0575 | 12.0571 | 12.0571 | 11200.0 |
| 2011-01-25 07:45:00 | AAPL | Stock | 12.0518 | 12.0518 | 12.0425 | 12.0425 | 17220.0 |
| 2011-01-25 07:46:00 | AAPL | Stock | 12.0425 | 12.0425 | 12.0425 | 12.0425 | 2800.0 |
| 2011-01-25 07:48:00 | AAPL | Stock | 12.0357 | 12.0357 | 12.0357 | 12.0357 | 5600.0 |
| 2011-01-25 07:49:00 | AAPL | Stock | 12.0304 | 12.0304 | 12.0286 | 12.0286 | 70000.0 |
| 2011-01-25 07:52:00 | AAPL | Stock | 12.0243 | 12.0268 | 12.0232 | 12.0268 | 35392.0 |
| 2011-01-25 07:58:00 | AAPL | Stock | 12.0318 | 12.0318 | 12.0304 | 12.0304 | 22400.0 |
| 2011-01-25 08:00:00 | AAPL | Stock | 12.0286 | 12.0479 | 12.025 | 12.0304 | 79856.0 |
| 2011-01-25 08:01:00 | AAPL | Stock | 12.0304 | 12.0357 | 12.0304 | 12.0304 | 50540.0 |
| 2011-01-25 08:03:00 | AAPL | Stock | 12.0286 | 12.0286 | 12.0214 | 12.0214 | 45220.0 |
| 2011-01-25 08:04:00 | AAPL | Stock | 12.0214 | 12.0214 | 12.0214 | 12.0214 | 17220.0 |
| 2011-01-25 08:05:00 | AAPL | Stock | 12.0229 | 12.0232 | 12.0229 | 12.0232 | 9800.0 |
| 2011-01-25 08:08:00 | AAPL | Stock | 12.0229 | 12.0232 | 12.0161 | 12.0161 | 115360.0 |
| 2011-01-25 08:09:00 | AAPL | Stock | 12.0164 | 12.0164 | 12.0121 | 12.0121 | 54600.0 |
| 2011-01-25 08:10:00 | AAPL | Stock | 12.0143 | 12.0161 | 12.0107 | 12.0154 | 70840.0 |
| 2011-01-25 08:11:00 | AAPL | Stock | 12.0104 | 12.0104 | 11.9979 | 11.9979 | 82740.0 |
| 2011-01-25 08:12:00 | AAPL | Stock | 11.9975 | 12.0 | 11.9957 | 12.0 | 153440.0 |
| 2011-01-25 08:13:00 | AAPL | Stock | 11.9971 | 12.0029 | 11.995 | 12.0029 | 138628.0 |
| 2011-01-25 08:14:00 | AAPL | Stock | 12.0029 | 12.0036 | 12.0029 | 12.0036 | 8400.0 |
| 2011-01-25 08:15:00 | AAPL | Stock | 12.0036 | 12.0071 | 12.0032 | 12.0054 | 19600.0 |
| 2011-01-25 08:16:00 | AAPL | Stock | 12.0054 | 12.0071 | 12.0046 | 12.0071 | 38920.0 |
> showing 50 of 989,576 rows — these rows as CSV