PREVIEW / stock_1min / 2011-11-04
file: by_date/stock_1min/2011/2011-11-04.parquet size: 12.7 MB rows: 954,038 symbols: 2,824
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-11-04 04:27:00 | AAPL | Stock | 14.3571 | 14.3571 | 14.3571 | 14.3571 | 5600.0 |
| 2011-11-04 05:10:00 | AAPL | Stock | 14.3571 | 14.3571 | 14.3571 | 14.3571 | 19600.0 |
| 2011-11-04 05:37:00 | AAPL | Stock | 14.3929 | 14.3929 | 14.3929 | 14.3929 | 2800.0 |
| 2011-11-04 06:18:00 | AAPL | Stock | 14.4068 | 14.4068 | 14.4068 | 14.4068 | 2800.0 |
| 2011-11-04 07:00:00 | AAPL | Stock | 14.3929 | 14.3929 | 14.3929 | 14.3929 | 8400.0 |
| 2011-11-04 07:04:00 | AAPL | Stock | 14.3832 | 14.3832 | 14.3832 | 14.3832 | 2800.0 |
| 2011-11-04 07:05:00 | AAPL | Stock | 14.385 | 14.385 | 14.385 | 14.385 | 2800.0 |
| 2011-11-04 07:06:00 | AAPL | Stock | 14.385 | 14.385 | 14.385 | 14.385 | 2800.0 |
| 2011-11-04 07:18:00 | AAPL | Stock | 14.3907 | 14.3907 | 14.3907 | 14.3907 | 2800.0 |
| 2011-11-04 07:20:00 | AAPL | Stock | 14.39 | 14.3929 | 14.39 | 14.3929 | 33600.0 |
| 2011-11-04 07:22:00 | AAPL | Stock | 14.3932 | 14.3932 | 14.3932 | 14.3932 | 2800.0 |
| 2011-11-04 07:32:00 | AAPL | Stock | 14.3939 | 14.3939 | 14.3929 | 14.3929 | 25200.0 |
| 2011-11-04 07:34:00 | AAPL | Stock | 14.4 | 14.4007 | 14.4 | 14.4007 | 5600.0 |
| 2011-11-04 07:35:00 | AAPL | Stock | 14.4018 | 14.4018 | 14.4018 | 14.4018 | 4116.0 |
| 2011-11-04 07:37:00 | AAPL | Stock | 14.4036 | 14.4036 | 14.4036 | 14.4036 | 5600.0 |
| 2011-11-04 07:41:00 | AAPL | Stock | 14.4011 | 14.4014 | 14.3989 | 14.3989 | 35728.0 |
| 2011-11-04 07:42:00 | AAPL | Stock | 14.4064 | 14.4064 | 14.4064 | 14.4064 | 2800.0 |
| 2011-11-04 07:43:00 | AAPL | Stock | 14.4046 | 14.4068 | 14.4046 | 14.4068 | 5600.0 |
| 2011-11-04 07:44:00 | AAPL | Stock | 14.4082 | 14.4082 | 14.4036 | 14.4036 | 11200.0 |
| 2011-11-04 07:45:00 | AAPL | Stock | 14.4082 | 14.4082 | 14.4082 | 14.4082 | 2800.0 |
| 2011-11-04 07:49:00 | AAPL | Stock | 14.4118 | 14.4118 | 14.4118 | 14.4118 | 5908.0 |
| 2011-11-04 07:50:00 | AAPL | Stock | 14.4168 | 14.4168 | 14.4168 | 14.4168 | 5600.0 |
| 2011-11-04 07:52:00 | AAPL | Stock | 14.4171 | 14.4175 | 14.4171 | 14.4175 | 8400.0 |
| 2011-11-04 07:53:00 | AAPL | Stock | 14.4143 | 14.4143 | 14.4143 | 14.4143 | 2800.0 |
| 2011-11-04 07:55:00 | AAPL | Stock | 14.3604 | 14.4111 | 14.3604 | 14.4111 | 47208.0 |
| 2011-11-04 07:56:00 | AAPL | Stock | 14.4111 | 14.4111 | 14.4111 | 14.4111 | 5600.0 |
| 2011-11-04 07:57:00 | AAPL | Stock | 14.4043 | 14.4043 | 14.385 | 14.3857 | 33600.0 |
| 2011-11-04 07:58:00 | AAPL | Stock | 14.3846 | 14.3846 | 14.3661 | 14.375 | 58296.0 |
| 2011-11-04 07:59:00 | AAPL | Stock | 14.3679 | 14.3679 | 14.3571 | 14.3571 | 23800.0 |
| 2011-11-04 08:00:00 | AAPL | Stock | 14.3696 | 14.3832 | 14.3393 | 14.3393 | 108584.0 |
| 2011-11-04 08:01:00 | AAPL | Stock | 14.3304 | 14.3464 | 14.3304 | 14.3464 | 12040.0 |
| 2011-11-04 08:02:00 | AAPL | Stock | 14.3393 | 14.3411 | 14.3393 | 14.3411 | 5600.0 |
| 2011-11-04 08:03:00 | AAPL | Stock | 14.3411 | 14.3414 | 14.3343 | 14.3343 | 25200.0 |
| 2011-11-04 08:04:00 | AAPL | Stock | 14.3339 | 14.3368 | 14.3214 | 14.3214 | 110096.0 |
| 2011-11-04 08:05:00 | AAPL | Stock | 14.3525 | 14.3525 | 14.3321 | 14.3321 | 8400.0 |
| 2011-11-04 08:06:00 | AAPL | Stock | 14.3536 | 14.3557 | 14.3532 | 14.3557 | 30800.0 |
| 2011-11-04 08:07:00 | AAPL | Stock | 14.35 | 14.35 | 14.35 | 14.35 | 2800.0 |
| 2011-11-04 08:09:00 | AAPL | Stock | 14.35 | 14.35 | 14.35 | 14.35 | 2800.0 |
| 2011-11-04 08:10:00 | AAPL | Stock | 14.3554 | 14.3607 | 14.3554 | 14.3607 | 23772.0 |
| 2011-11-04 08:11:00 | AAPL | Stock | 14.3518 | 14.3518 | 14.3482 | 14.3482 | 16800.0 |
| 2011-11-04 08:13:00 | AAPL | Stock | 14.3546 | 14.355 | 14.3543 | 14.355 | 14000.0 |
| 2011-11-04 08:14:00 | AAPL | Stock | 14.355 | 14.3571 | 14.355 | 14.3571 | 11200.0 |
| 2011-11-04 08:15:00 | AAPL | Stock | 14.3604 | 14.3625 | 14.3571 | 14.3575 | 54740.0 |
| 2011-11-04 08:16:00 | AAPL | Stock | 14.3489 | 14.3571 | 14.3489 | 14.3571 | 30240.0 |
| 2011-11-04 08:17:00 | AAPL | Stock | 14.3571 | 14.3571 | 14.3571 | 14.3571 | 3192.0 |
| 2011-11-04 08:18:00 | AAPL | Stock | 14.3536 | 14.3536 | 14.3536 | 14.3536 | 3220.0 |
| 2011-11-04 08:19:00 | AAPL | Stock | 14.3536 | 14.3536 | 14.3482 | 14.3482 | 25760.0 |
| 2011-11-04 08:20:00 | AAPL | Stock | 14.3464 | 14.3464 | 14.3464 | 14.3464 | 2800.0 |
| 2011-11-04 08:23:00 | AAPL | Stock | 14.35 | 14.35 | 14.3464 | 14.3464 | 13972.0 |
| 2011-11-04 08:24:00 | AAPL | Stock | 14.3446 | 14.3554 | 14.3361 | 14.3532 | 44128.0 |
> showing 50 of 954,038 rows — these rows as CSV