PREVIEW / stock_1min / 2011-06-21
file: by_date/stock_1min/2011/2011-06-21.parquet size: 13.5 MB rows: 1,025,945 symbols: 2,884
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-06-21 04:01:00 | AAPL | Stock | 11.2679 | 11.2679 | 11.2679 | 11.2679 | 11200.0 |
| 2011-06-21 04:14:00 | AAPL | Stock | 11.2907 | 11.2907 | 11.2907 | 11.2907 | 2800.0 |
| 2011-06-21 04:35:00 | AAPL | Stock | 11.2907 | 11.2907 | 11.2907 | 11.2907 | 2800.0 |
| 2011-06-21 04:45:00 | AAPL | Stock | 11.2875 | 11.2875 | 11.2875 | 11.2875 | 2800.0 |
| 2011-06-21 05:48:00 | AAPL | Stock | 11.2789 | 11.2789 | 11.2789 | 11.2789 | 2800.0 |
| 2011-06-21 06:02:00 | AAPL | Stock | 11.2586 | 11.2586 | 11.2586 | 11.2586 | 2800.0 |
| 2011-06-21 06:17:00 | AAPL | Stock | 11.265 | 11.265 | 11.2589 | 11.2604 | 16800.0 |
| 2011-06-21 06:19:00 | AAPL | Stock | 11.2679 | 11.2679 | 11.2679 | 11.2679 | 2800.0 |
| 2011-06-21 06:24:00 | AAPL | Stock | 11.275 | 11.275 | 11.275 | 11.275 | 2800.0 |
| 2011-06-21 06:35:00 | AAPL | Stock | 11.2739 | 11.2739 | 11.2739 | 11.2739 | 2800.0 |
| 2011-06-21 06:41:00 | AAPL | Stock | 11.2818 | 11.2818 | 11.2818 | 11.2818 | 2800.0 |
| 2011-06-21 06:43:00 | AAPL | Stock | 11.2654 | 11.2654 | 11.265 | 11.265 | 28000.0 |
| 2011-06-21 06:45:00 | AAPL | Stock | 11.2661 | 11.2661 | 11.2661 | 11.2661 | 2800.0 |
| 2011-06-21 06:54:00 | AAPL | Stock | 11.28 | 11.28 | 11.28 | 11.28 | 5600.0 |
| 2011-06-21 07:00:00 | AAPL | Stock | 11.285 | 11.2925 | 11.285 | 11.2925 | 8400.0 |
| 2011-06-21 07:03:00 | AAPL | Stock | 11.2957 | 11.2957 | 11.2957 | 11.2957 | 2800.0 |
| 2011-06-21 07:05:00 | AAPL | Stock | 11.2932 | 11.2932 | 11.2932 | 11.2932 | 2800.0 |
| 2011-06-21 07:06:00 | AAPL | Stock | 11.2932 | 11.3036 | 11.2932 | 11.3036 | 22624.0 |
| 2011-06-21 07:08:00 | AAPL | Stock | 11.3214 | 11.3214 | 11.3214 | 11.3214 | 28000.0 |
| 2011-06-21 07:11:00 | AAPL | Stock | 11.3143 | 11.3143 | 11.3143 | 11.3143 | 5600.0 |
| 2011-06-21 07:12:00 | AAPL | Stock | 11.3146 | 11.3146 | 11.3143 | 11.3143 | 8400.0 |
| 2011-06-21 07:13:00 | AAPL | Stock | 11.3143 | 11.3143 | 11.3125 | 11.3139 | 14000.0 |
| 2011-06-21 07:14:00 | AAPL | Stock | 11.3075 | 11.3143 | 11.3075 | 11.3143 | 12964.0 |
| 2011-06-21 07:16:00 | AAPL | Stock | 11.3143 | 11.3143 | 11.3143 | 11.3143 | 2800.0 |
| 2011-06-21 07:18:00 | AAPL | Stock | 11.3143 | 11.3143 | 11.3143 | 11.3143 | 38556.0 |
| 2011-06-21 07:20:00 | AAPL | Stock | 11.3211 | 11.3211 | 11.3082 | 11.3082 | 5600.0 |
| 2011-06-21 07:22:00 | AAPL | Stock | 11.3082 | 11.3186 | 11.3082 | 11.3186 | 11200.0 |
| 2011-06-21 07:24:00 | AAPL | Stock | 11.3214 | 11.3214 | 11.3214 | 11.3214 | 14000.0 |
| 2011-06-21 07:26:00 | AAPL | Stock | 11.3254 | 11.3254 | 11.3254 | 11.3254 | 4200.0 |
| 2011-06-21 07:27:00 | AAPL | Stock | 11.3264 | 11.3304 | 11.3264 | 11.3304 | 14000.0 |
| 2011-06-21 07:30:00 | AAPL | Stock | 11.3361 | 11.3361 | 11.3361 | 11.3361 | 2800.0 |
| 2011-06-21 07:31:00 | AAPL | Stock | 11.3325 | 11.3357 | 11.3325 | 11.3357 | 14000.0 |
| 2011-06-21 07:33:00 | AAPL | Stock | 11.3357 | 11.3393 | 11.3357 | 11.3393 | 11200.0 |
| 2011-06-21 07:34:00 | AAPL | Stock | 11.3375 | 11.3375 | 11.3375 | 11.3375 | 2800.0 |
| 2011-06-21 07:35:00 | AAPL | Stock | 11.3375 | 11.3375 | 11.3375 | 11.3375 | 5600.0 |
| 2011-06-21 07:36:00 | AAPL | Stock | 11.3375 | 11.3389 | 11.3339 | 11.3339 | 59920.0 |
| 2011-06-21 07:39:00 | AAPL | Stock | 11.3439 | 11.3446 | 11.3439 | 11.3446 | 32032.0 |
| 2011-06-21 07:40:00 | AAPL | Stock | 11.3482 | 11.35 | 11.3482 | 11.35 | 29204.0 |
| 2011-06-21 07:41:00 | AAPL | Stock | 11.3629 | 11.3632 | 11.3611 | 11.3611 | 62720.0 |
| 2011-06-21 07:42:00 | AAPL | Stock | 11.3571 | 11.3571 | 11.3571 | 11.3571 | 10724.0 |
| 2011-06-21 07:43:00 | AAPL | Stock | 11.3604 | 11.3693 | 11.3604 | 11.3679 | 69720.0 |
| 2011-06-21 07:44:00 | AAPL | Stock | 11.3657 | 11.3661 | 11.365 | 11.3661 | 43484.0 |
| 2011-06-21 07:45:00 | AAPL | Stock | 11.3661 | 11.3668 | 11.3661 | 11.3661 | 53200.0 |
| 2011-06-21 07:46:00 | AAPL | Stock | 11.3664 | 11.3664 | 11.3554 | 11.3564 | 99372.0 |
| 2011-06-21 07:47:00 | AAPL | Stock | 11.3568 | 11.3568 | 11.3396 | 11.3557 | 36400.0 |
| 2011-06-21 07:49:00 | AAPL | Stock | 11.3396 | 11.3396 | 11.3396 | 11.3396 | 2800.0 |
| 2011-06-21 07:51:00 | AAPL | Stock | 11.3429 | 11.3536 | 11.3429 | 11.3536 | 39396.0 |
| 2011-06-21 07:52:00 | AAPL | Stock | 11.345 | 11.345 | 11.3425 | 11.3425 | 8400.0 |
| 2011-06-21 07:53:00 | AAPL | Stock | 11.3439 | 11.3539 | 11.3439 | 11.3539 | 24500.0 |
| 2011-06-21 07:54:00 | AAPL | Stock | 11.3493 | 11.3496 | 11.3493 | 11.3496 | 11200.0 |
> showing 50 of 1,025,945 rows — these rows as CSV