PREVIEW / stock_1min / 2012-03-14
file: by_date/stock_1min/2012/2012-03-14.parquet size: 13.0 MB rows: 959,228 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-03-14 04:01:00 | AAPL | Stock | 20.3371 | 20.3371 | 20.3371 | 20.3371 | 2800.0 |
| 2012-03-14 04:03:00 | AAPL | Stock | 20.3396 | 20.3396 | 20.3396 | 20.3396 | 11200.0 |
| 2012-03-14 04:04:00 | AAPL | Stock | 20.3382 | 20.3382 | 20.3382 | 20.3382 | 5600.0 |
| 2012-03-14 04:05:00 | AAPL | Stock | 20.3461 | 20.3461 | 20.3461 | 20.3461 | 5600.0 |
| 2012-03-14 04:06:00 | AAPL | Stock | 20.3429 | 20.3436 | 20.3411 | 20.3436 | 14840.0 |
| 2012-03-14 04:07:00 | AAPL | Stock | 20.3443 | 20.3571 | 20.3443 | 20.3571 | 8400.0 |
| 2012-03-14 04:09:00 | AAPL | Stock | 20.3593 | 20.3593 | 20.3593 | 20.3593 | 2800.0 |
| 2012-03-14 04:14:00 | AAPL | Stock | 20.3889 | 20.3889 | 20.3889 | 20.3889 | 2800.0 |
| 2012-03-14 04:15:00 | AAPL | Stock | 20.3914 | 20.3914 | 20.3914 | 20.3914 | 3360.0 |
| 2012-03-14 04:16:00 | AAPL | Stock | 20.3611 | 20.3611 | 20.3611 | 20.3611 | 2800.0 |
| 2012-03-14 04:21:00 | AAPL | Stock | 20.3825 | 20.3825 | 20.3825 | 20.3825 | 14000.0 |
| 2012-03-14 04:25:00 | AAPL | Stock | 20.3829 | 20.3829 | 20.3829 | 20.3829 | 14000.0 |
| 2012-03-14 04:26:00 | AAPL | Stock | 20.3929 | 20.3929 | 20.3929 | 20.3929 | 14000.0 |
| 2012-03-14 04:27:00 | AAPL | Stock | 20.3825 | 20.3825 | 20.3825 | 20.3825 | 2800.0 |
| 2012-03-14 04:30:00 | AAPL | Stock | 20.3825 | 20.3825 | 20.3825 | 20.3825 | 8260.0 |
| 2012-03-14 04:37:00 | AAPL | Stock | 20.4025 | 20.4036 | 20.4025 | 20.4036 | 5600.0 |
| 2012-03-14 04:42:00 | AAPL | Stock | 20.4339 | 20.4339 | 20.4339 | 20.4339 | 2800.0 |
| 2012-03-14 04:50:00 | AAPL | Stock | 20.4464 | 20.4607 | 20.4464 | 20.4607 | 30800.0 |
| 2012-03-14 04:51:00 | AAPL | Stock | 20.4464 | 20.4464 | 20.4464 | 20.4464 | 12600.0 |
| 2012-03-14 04:52:00 | AAPL | Stock | 20.4321 | 20.4321 | 20.4321 | 20.4321 | 9800.0 |
| 2012-03-14 04:59:00 | AAPL | Stock | 20.4329 | 20.4329 | 20.4325 | 20.4325 | 12992.0 |
| 2012-03-14 05:01:00 | AAPL | Stock | 20.4604 | 20.4604 | 20.4604 | 20.4604 | 2800.0 |
| 2012-03-14 05:02:00 | AAPL | Stock | 20.4604 | 20.4643 | 20.4604 | 20.4643 | 33656.0 |
| 2012-03-14 05:03:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4643 | 20.4643 | 2800.0 |
| 2012-03-14 05:04:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4643 | 20.4643 | 2800.0 |
| 2012-03-14 05:06:00 | AAPL | Stock | 20.5118 | 20.5118 | 20.5 | 20.5 | 15400.0 |
| 2012-03-14 05:09:00 | AAPL | Stock | 20.4825 | 20.4825 | 20.4821 | 20.4821 | 11900.0 |
| 2012-03-14 05:10:00 | AAPL | Stock | 20.4993 | 20.4993 | 20.4993 | 20.4993 | 2800.0 |
| 2012-03-14 05:13:00 | AAPL | Stock | 20.4989 | 20.4993 | 20.4989 | 20.4993 | 5600.0 |
| 2012-03-14 05:20:00 | AAPL | Stock | 20.4946 | 20.4946 | 20.4946 | 20.4946 | 2800.0 |
| 2012-03-14 05:21:00 | AAPL | Stock | 20.4929 | 20.4929 | 20.4929 | 20.4929 | 2800.0 |
| 2012-03-14 05:22:00 | AAPL | Stock | 20.4993 | 20.4993 | 20.4993 | 20.4993 | 2800.0 |
| 2012-03-14 05:23:00 | AAPL | Stock | 20.5 | 20.5286 | 20.5 | 20.5286 | 45416.0 |
| 2012-03-14 05:24:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.5179 | 20.5179 | 5600.0 |
| 2012-03-14 05:28:00 | AAPL | Stock | 20.5304 | 20.5357 | 20.5304 | 20.5357 | 16772.0 |
| 2012-03-14 05:29:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.5107 | 20.5107 | 16520.0 |
| 2012-03-14 05:30:00 | AAPL | Stock | 20.5107 | 20.5107 | 20.4996 | 20.5 | 36400.0 |
| 2012-03-14 05:31:00 | AAPL | Stock | 20.4996 | 20.4996 | 20.4996 | 20.4996 | 2800.0 |
| 2012-03-14 05:32:00 | AAPL | Stock | 20.5 | 20.5 | 20.4996 | 20.4996 | 8400.0 |
| 2012-03-14 05:33:00 | AAPL | Stock | 20.4982 | 20.4982 | 20.4982 | 20.4982 | 2800.0 |
| 2012-03-14 05:34:00 | AAPL | Stock | 20.4982 | 20.5 | 20.4982 | 20.5 | 11200.0 |
| 2012-03-14 05:35:00 | AAPL | Stock | 20.4964 | 20.5057 | 20.4964 | 20.5057 | 8400.0 |
| 2012-03-14 05:36:00 | AAPL | Stock | 20.5061 | 20.5061 | 20.5061 | 20.5061 | 2800.0 |
| 2012-03-14 05:37:00 | AAPL | Stock | 20.4914 | 20.4914 | 20.4914 | 20.4914 | 5600.0 |
| 2012-03-14 05:40:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 2800.0 |
| 2012-03-14 05:43:00 | AAPL | Stock | 20.5143 | 20.5143 | 20.5143 | 20.5143 | 2800.0 |
| 2012-03-14 05:44:00 | AAPL | Stock | 20.4918 | 20.4918 | 20.4914 | 20.4914 | 25844.0 |
| 2012-03-14 05:46:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 2800.0 |
| 2012-03-14 05:47:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 44128.0 |
| 2012-03-14 05:48:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 33600.0 |
> showing 50 of 959,228 rows — these rows as CSV