PREVIEW / stock_1min / 2012-12-27
file: by_date/stock_1min/2012/2012-12-27.parquet size: 12.7 MB rows: 938,724 symbols: 2,846
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-12-27 04:09:00 | AAPL | Stock | 18.2504 | 18.2504 | 18.2504 | 18.2504 | 2800.0 |
| 2012-12-27 04:18:00 | AAPL | Stock | 18.2504 | 18.2504 | 18.2504 | 18.2504 | 2800.0 |
| 2012-12-27 04:42:00 | AAPL | Stock | 18.1968 | 18.1968 | 18.1968 | 18.1968 | 5600.0 |
| 2012-12-27 05:01:00 | AAPL | Stock | 18.2143 | 18.2143 | 18.2143 | 18.2143 | 2800.0 |
| 2012-12-27 05:15:00 | AAPL | Stock | 18.1982 | 18.1982 | 18.1982 | 18.1982 | 14000.0 |
| 2012-12-27 05:16:00 | AAPL | Stock | 18.2071 | 18.2071 | 18.2071 | 18.2071 | 56000.0 |
| 2012-12-27 05:17:00 | AAPL | Stock | 18.2071 | 18.2071 | 18.2071 | 18.2071 | 5572.0 |
| 2012-12-27 06:01:00 | AAPL | Stock | 18.2043 | 18.2043 | 18.2043 | 18.2043 | 2800.0 |
| 2012-12-27 06:10:00 | AAPL | Stock | 18.2018 | 18.2018 | 18.2018 | 18.2018 | 2800.0 |
| 2012-12-27 06:50:00 | AAPL | Stock | 18.2179 | 18.2179 | 18.2179 | 18.2179 | 2800.0 |
| 2012-12-27 07:01:00 | AAPL | Stock | 18.2146 | 18.2146 | 18.2146 | 18.2146 | 2800.0 |
| 2012-12-27 07:06:00 | AAPL | Stock | 18.2464 | 18.2464 | 18.2464 | 18.2464 | 5600.0 |
| 2012-12-27 07:08:00 | AAPL | Stock | 18.2607 | 18.2607 | 18.2607 | 18.2607 | 5600.0 |
| 2012-12-27 07:09:00 | AAPL | Stock | 18.2696 | 18.2714 | 18.2696 | 18.2714 | 10500.0 |
| 2012-12-27 07:11:00 | AAPL | Stock | 18.2786 | 18.2843 | 18.2786 | 18.2843 | 8400.0 |
| 2012-12-27 07:12:00 | AAPL | Stock | 18.2768 | 18.2768 | 18.2768 | 18.2768 | 2800.0 |
| 2012-12-27 07:13:00 | AAPL | Stock | 18.2839 | 18.2839 | 18.2839 | 18.2839 | 2800.0 |
| 2012-12-27 07:17:00 | AAPL | Stock | 18.2818 | 18.2954 | 18.2818 | 18.2954 | 16800.0 |
| 2012-12-27 07:18:00 | AAPL | Stock | 18.3036 | 18.3036 | 18.3036 | 18.3036 | 2884.0 |
| 2012-12-27 07:19:00 | AAPL | Stock | 18.2925 | 18.2925 | 18.2925 | 18.2925 | 2800.0 |
| 2012-12-27 07:20:00 | AAPL | Stock | 18.3214 | 18.3286 | 18.3129 | 18.3214 | 40600.0 |
| 2012-12-27 07:22:00 | AAPL | Stock | 18.3196 | 18.3214 | 18.3196 | 18.3214 | 24304.0 |
| 2012-12-27 07:24:00 | AAPL | Stock | 18.3314 | 18.3314 | 18.3314 | 18.3314 | 6300.0 |
| 2012-12-27 07:26:00 | AAPL | Stock | 18.3389 | 18.3389 | 18.3389 | 18.3389 | 8400.0 |
| 2012-12-27 07:27:00 | AAPL | Stock | 18.3257 | 18.3257 | 18.3257 | 18.3257 | 2800.0 |
| 2012-12-27 07:28:00 | AAPL | Stock | 18.3357 | 18.3446 | 18.3357 | 18.3446 | 8400.0 |
| 2012-12-27 07:29:00 | AAPL | Stock | 18.3393 | 18.3393 | 18.3393 | 18.3393 | 11200.0 |
| 2012-12-27 07:34:00 | AAPL | Stock | 18.3482 | 18.3482 | 18.3482 | 18.3482 | 2800.0 |
| 2012-12-27 07:35:00 | AAPL | Stock | 18.3429 | 18.3429 | 18.3429 | 18.3429 | 2800.0 |
| 2012-12-27 07:36:00 | AAPL | Stock | 18.3414 | 18.3414 | 18.3414 | 18.3414 | 2800.0 |
| 2012-12-27 07:37:00 | AAPL | Stock | 18.3393 | 18.3393 | 18.3393 | 18.3393 | 14000.0 |
| 2012-12-27 07:38:00 | AAPL | Stock | 18.3214 | 18.3214 | 18.3214 | 18.3214 | 2800.0 |
| 2012-12-27 07:39:00 | AAPL | Stock | 18.3393 | 18.3393 | 18.3393 | 18.3393 | 2800.0 |
| 2012-12-27 07:41:00 | AAPL | Stock | 18.3368 | 18.3368 | 18.3368 | 18.3368 | 5600.0 |
| 2012-12-27 07:43:00 | AAPL | Stock | 18.3214 | 18.3214 | 18.3214 | 18.3214 | 2800.0 |
| 2012-12-27 07:44:00 | AAPL | Stock | 18.3375 | 18.3393 | 18.3375 | 18.3393 | 5600.0 |
| 2012-12-27 07:46:00 | AAPL | Stock | 18.3429 | 18.3568 | 18.3429 | 18.3568 | 11200.0 |
| 2012-12-27 07:50:00 | AAPL | Stock | 18.3429 | 18.3429 | 18.3429 | 18.3429 | 4424.0 |
| 2012-12-27 07:54:00 | AAPL | Stock | 18.3271 | 18.3271 | 18.3271 | 18.3271 | 2800.0 |
| 2012-12-27 07:55:00 | AAPL | Stock | 18.3261 | 18.3261 | 18.3261 | 18.3261 | 2800.0 |
| 2012-12-27 07:57:00 | AAPL | Stock | 18.3261 | 18.3261 | 18.3261 | 18.3261 | 2800.0 |
| 2012-12-27 07:59:00 | AAPL | Stock | 18.3357 | 18.3393 | 18.3357 | 18.3393 | 33600.0 |
| 2012-12-27 08:00:00 | AAPL | Stock | 18.3393 | 18.3554 | 18.2464 | 18.3357 | 116984.0 |
| 2012-12-27 08:01:00 | AAPL | Stock | 18.325 | 18.3579 | 18.325 | 18.3579 | 50400.0 |
| 2012-12-27 08:02:00 | AAPL | Stock | 18.3639 | 18.3639 | 18.3393 | 18.35 | 20552.0 |
| 2012-12-27 08:03:00 | AAPL | Stock | 18.3543 | 18.3543 | 18.3436 | 18.3436 | 18060.0 |
| 2012-12-27 08:04:00 | AAPL | Stock | 18.3436 | 18.375 | 18.3436 | 18.375 | 43400.0 |
| 2012-12-27 08:05:00 | AAPL | Stock | 18.3536 | 18.3536 | 18.3536 | 18.3536 | 2800.0 |
| 2012-12-27 08:06:00 | AAPL | Stock | 18.3514 | 18.3514 | 18.3393 | 18.3393 | 30800.0 |
| 2012-12-27 08:08:00 | AAPL | Stock | 18.34 | 18.34 | 18.3393 | 18.3393 | 23240.0 |
> showing 50 of 938,724 rows — these rows as CSV