PREVIEW / stock_1min / 2012-02-15
file: by_date/stock_1min/2012/2012-02-15.parquet size: 13.5 MB rows: 995,563 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 |
|---|---|---|---|---|---|---|---|
| 2012-02-15 04:00:00 | AAPL | Stock | 18.2982 | 18.3211 | 18.2982 | 18.3211 | 5600.0 |
| 2012-02-15 04:03:00 | AAPL | Stock | 18.4286 | 18.455 | 18.4286 | 18.455 | 11200.0 |
| 2012-02-15 04:04:00 | AAPL | Stock | 18.4921 | 18.4921 | 18.4921 | 18.4921 | 2800.0 |
| 2012-02-15 04:07:00 | AAPL | Stock | 18.4982 | 18.4982 | 18.4982 | 18.4982 | 2800.0 |
| 2012-02-15 04:08:00 | AAPL | Stock | 18.4643 | 18.5 | 18.4643 | 18.5 | 5600.0 |
| 2012-02-15 04:10:00 | AAPL | Stock | 18.5 | 18.5 | 18.5 | 18.5 | 2800.0 |
| 2012-02-15 04:11:00 | AAPL | Stock | 18.5 | 18.5243 | 18.5 | 18.5243 | 8400.0 |
| 2012-02-15 04:14:00 | AAPL | Stock | 18.5 | 18.5 | 18.5 | 18.5 | 2800.0 |
| 2012-02-15 04:15:00 | AAPL | Stock | 18.5 | 18.5 | 18.5 | 18.5 | 11060.0 |
| 2012-02-15 04:17:00 | AAPL | Stock | 18.5 | 18.5 | 18.5 | 18.5 | 8400.0 |
| 2012-02-15 04:34:00 | AAPL | Stock | 18.4821 | 18.4821 | 18.4821 | 18.4821 | 2800.0 |
| 2012-02-15 04:35:00 | AAPL | Stock | 18.4911 | 18.4911 | 18.4911 | 18.4911 | 2800.0 |
| 2012-02-15 04:36:00 | AAPL | Stock | 18.4893 | 18.4893 | 18.4893 | 18.4893 | 2800.0 |
| 2012-02-15 04:46:00 | AAPL | Stock | 18.4825 | 18.4825 | 18.4825 | 18.4825 | 2800.0 |
| 2012-02-15 04:47:00 | AAPL | Stock | 18.4893 | 18.4893 | 18.4893 | 18.4893 | 2800.0 |
| 2012-02-15 04:48:00 | AAPL | Stock | 18.475 | 18.475 | 18.4732 | 18.4732 | 16800.0 |
| 2012-02-15 04:49:00 | AAPL | Stock | 18.4643 | 18.4643 | 18.4643 | 18.4643 | 12600.0 |
| 2012-02-15 04:50:00 | AAPL | Stock | 18.4643 | 18.4643 | 18.4643 | 18.4643 | 2800.0 |
| 2012-02-15 04:51:00 | AAPL | Stock | 18.4571 | 18.4639 | 18.4571 | 18.4639 | 14000.0 |
| 2012-02-15 04:53:00 | AAPL | Stock | 18.4639 | 18.4643 | 18.4639 | 18.4643 | 30800.0 |
| 2012-02-15 04:55:00 | AAPL | Stock | 18.4607 | 18.4607 | 18.4607 | 18.4607 | 2800.0 |
| 2012-02-15 04:57:00 | AAPL | Stock | 18.4493 | 18.4493 | 18.4493 | 18.4493 | 2800.0 |
| 2012-02-15 05:05:00 | AAPL | Stock | 18.4554 | 18.4554 | 18.4554 | 18.4554 | 2800.0 |
| 2012-02-15 05:09:00 | AAPL | Stock | 18.4554 | 18.4554 | 18.4536 | 18.4536 | 8400.0 |
| 2012-02-15 05:11:00 | AAPL | Stock | 18.4893 | 18.4893 | 18.4893 | 18.4893 | 8400.0 |
| 2012-02-15 05:12:00 | AAPL | Stock | 18.4893 | 18.4893 | 18.4893 | 18.4893 | 2800.0 |
| 2012-02-15 05:33:00 | AAPL | Stock | 18.4643 | 18.4643 | 18.4643 | 18.4643 | 7000.0 |
| 2012-02-15 05:35:00 | AAPL | Stock | 18.4589 | 18.4589 | 18.4554 | 18.4554 | 17360.0 |
| 2012-02-15 05:36:00 | AAPL | Stock | 18.4643 | 18.4643 | 18.4643 | 18.4643 | 17528.0 |
| 2012-02-15 05:44:00 | AAPL | Stock | 18.4482 | 18.4482 | 18.4325 | 18.4325 | 13832.0 |
| 2012-02-15 05:55:00 | AAPL | Stock | 18.4575 | 18.4575 | 18.4575 | 18.4575 | 5600.0 |
| 2012-02-15 05:57:00 | AAPL | Stock | 18.4561 | 18.4561 | 18.4561 | 18.4561 | 2800.0 |
| 2012-02-15 05:58:00 | AAPL | Stock | 18.4561 | 18.4561 | 18.4561 | 18.4561 | 9380.0 |
| 2012-02-15 06:01:00 | AAPL | Stock | 18.4536 | 18.4536 | 18.4536 | 18.4536 | 28000.0 |
| 2012-02-15 06:06:00 | AAPL | Stock | 18.4464 | 18.4464 | 18.4464 | 18.4464 | 14000.0 |
| 2012-02-15 06:07:00 | AAPL | Stock | 18.4464 | 18.4464 | 18.4464 | 18.4464 | 17108.0 |
| 2012-02-15 06:08:00 | AAPL | Stock | 18.4464 | 18.4464 | 18.4464 | 18.4464 | 24892.0 |
| 2012-02-15 06:21:00 | AAPL | Stock | 18.455 | 18.455 | 18.4464 | 18.4464 | 25200.0 |
| 2012-02-15 06:25:00 | AAPL | Stock | 18.4536 | 18.4536 | 18.4536 | 18.4536 | 2800.0 |
| 2012-02-15 06:28:00 | AAPL | Stock | 18.4518 | 18.4604 | 18.4464 | 18.4604 | 151200.0 |
| 2012-02-15 06:30:00 | AAPL | Stock | 18.455 | 18.455 | 18.455 | 18.455 | 2800.0 |
| 2012-02-15 06:32:00 | AAPL | Stock | 18.4604 | 18.4604 | 18.4604 | 18.4604 | 8960.0 |
| 2012-02-15 06:38:00 | AAPL | Stock | 18.4561 | 18.4561 | 18.4561 | 18.4561 | 7000.0 |
| 2012-02-15 06:39:00 | AAPL | Stock | 18.4471 | 18.4471 | 18.4464 | 18.4464 | 11200.0 |
| 2012-02-15 06:42:00 | AAPL | Stock | 18.45 | 18.45 | 18.45 | 18.45 | 12600.0 |
| 2012-02-15 06:49:00 | AAPL | Stock | 18.4464 | 18.4464 | 18.4429 | 18.4429 | 13580.0 |
| 2012-02-15 06:54:00 | AAPL | Stock | 18.4429 | 18.4429 | 18.4429 | 18.4429 | 3220.0 |
| 2012-02-15 06:57:00 | AAPL | Stock | 18.4464 | 18.4464 | 18.4464 | 18.4464 | 2800.0 |
| 2012-02-15 06:58:00 | AAPL | Stock | 18.4464 | 18.4532 | 18.4464 | 18.4532 | 29652.0 |
| 2012-02-15 07:00:00 | AAPL | Stock | 18.4393 | 18.4536 | 18.4286 | 18.4286 | 216300.0 |
> showing 50 of 995,563 rows — these rows as CSV