PREVIEW / stock_1min / 2012-08-13
file: by_date/stock_1min/2012/2012-08-13.parquet size: 11.8 MB rows: 884,583 symbols: 2,805
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-08-13 04:00:00 | AAPL | Stock | 22.2036 | 22.2036 | 22.1661 | 22.1661 | 15400.0 |
| 2012-08-13 04:01:00 | AAPL | Stock | 22.1661 | 22.1661 | 22.1661 | 22.1661 | 5600.0 |
| 2012-08-13 04:24:00 | AAPL | Stock | 22.1664 | 22.1664 | 22.1664 | 22.1664 | 3276.0 |
| 2012-08-13 04:50:00 | AAPL | Stock | 22.1786 | 22.1786 | 22.1786 | 22.1786 | 2800.0 |
| 2012-08-13 05:10:00 | AAPL | Stock | 22.2054 | 22.2054 | 22.2054 | 22.2054 | 2800.0 |
| 2012-08-13 05:14:00 | AAPL | Stock | 22.2054 | 22.2054 | 22.2054 | 22.2054 | 2800.0 |
| 2012-08-13 05:34:00 | AAPL | Stock | 22.2054 | 22.2054 | 22.2054 | 22.2054 | 2800.0 |
| 2012-08-13 05:41:00 | AAPL | Stock | 22.2054 | 22.2054 | 22.2054 | 22.2054 | 18060.0 |
| 2012-08-13 06:29:00 | AAPL | Stock | 22.2321 | 22.2321 | 22.2321 | 22.2321 | 9800.0 |
| 2012-08-13 06:34:00 | AAPL | Stock | 22.2321 | 22.2321 | 22.2321 | 22.2321 | 11200.0 |
| 2012-08-13 06:59:00 | AAPL | Stock | 22.2464 | 22.2464 | 22.2464 | 22.2464 | 2800.0 |
| 2012-08-13 07:00:00 | AAPL | Stock | 22.2464 | 22.2464 | 22.2464 | 22.2464 | 8400.0 |
| 2012-08-13 07:03:00 | AAPL | Stock | 22.2439 | 22.2439 | 22.2439 | 22.2439 | 8400.0 |
| 2012-08-13 07:08:00 | AAPL | Stock | 22.24 | 22.24 | 22.24 | 22.24 | 5600.0 |
| 2012-08-13 07:15:00 | AAPL | Stock | 22.2714 | 22.2714 | 22.2679 | 22.2679 | 9268.0 |
| 2012-08-13 07:17:00 | AAPL | Stock | 22.2654 | 22.2654 | 22.2625 | 22.2625 | 11900.0 |
| 2012-08-13 07:20:00 | AAPL | Stock | 22.2589 | 22.2589 | 22.2589 | 22.2589 | 2800.0 |
| 2012-08-13 07:21:00 | AAPL | Stock | 22.2589 | 22.2589 | 22.2554 | 22.2554 | 5600.0 |
| 2012-08-13 07:22:00 | AAPL | Stock | 22.2504 | 22.2504 | 22.2464 | 22.2464 | 13328.0 |
| 2012-08-13 07:23:00 | AAPL | Stock | 22.2454 | 22.2454 | 22.2454 | 22.2454 | 2800.0 |
| 2012-08-13 07:25:00 | AAPL | Stock | 22.2411 | 22.2411 | 22.2411 | 22.2411 | 2800.0 |
| 2012-08-13 07:26:00 | AAPL | Stock | 22.2464 | 22.2589 | 22.2464 | 22.2589 | 27720.0 |
| 2012-08-13 07:28:00 | AAPL | Stock | 22.2571 | 22.2589 | 22.2571 | 22.2589 | 5600.0 |
| 2012-08-13 07:29:00 | AAPL | Stock | 22.2589 | 22.2632 | 22.2589 | 22.2632 | 16800.0 |
| 2012-08-13 07:30:00 | AAPL | Stock | 22.2621 | 22.2639 | 22.2621 | 22.2639 | 5600.0 |
| 2012-08-13 07:32:00 | AAPL | Stock | 22.2643 | 22.2643 | 22.2589 | 22.2589 | 14000.0 |
| 2012-08-13 07:37:00 | AAPL | Stock | 22.2589 | 22.2589 | 22.2589 | 22.2589 | 11200.0 |
| 2012-08-13 07:38:00 | AAPL | Stock | 22.2589 | 22.2589 | 22.2589 | 22.2589 | 5600.0 |
| 2012-08-13 07:39:00 | AAPL | Stock | 22.2571 | 22.2571 | 22.2518 | 22.2518 | 8400.0 |
| 2012-08-13 07:42:00 | AAPL | Stock | 22.2607 | 22.2814 | 22.2589 | 22.2814 | 96460.0 |
| 2012-08-13 07:45:00 | AAPL | Stock | 22.2811 | 22.2821 | 22.2811 | 22.2821 | 5600.0 |
| 2012-08-13 07:46:00 | AAPL | Stock | 22.2857 | 22.3196 | 22.2857 | 22.3196 | 141960.0 |
| 2012-08-13 07:47:00 | AAPL | Stock | 22.3175 | 22.3179 | 22.3175 | 22.3179 | 14000.0 |
| 2012-08-13 07:48:00 | AAPL | Stock | 22.3171 | 22.3443 | 22.3171 | 22.3411 | 36400.0 |
| 2012-08-13 07:49:00 | AAPL | Stock | 22.34 | 22.3514 | 22.3393 | 22.3482 | 34076.0 |
| 2012-08-13 07:51:00 | AAPL | Stock | 22.3493 | 22.3571 | 22.3493 | 22.3571 | 16800.0 |
| 2012-08-13 07:52:00 | AAPL | Stock | 22.3571 | 22.3571 | 22.3568 | 22.3571 | 16800.0 |
| 2012-08-13 07:53:00 | AAPL | Stock | 22.345 | 22.3568 | 22.3429 | 22.3429 | 33236.0 |
| 2012-08-13 07:54:00 | AAPL | Stock | 22.3429 | 22.3429 | 22.3429 | 22.3429 | 2800.0 |
| 2012-08-13 07:55:00 | AAPL | Stock | 22.3464 | 22.3464 | 22.3411 | 22.3411 | 36400.0 |
| 2012-08-13 07:56:00 | AAPL | Stock | 22.3411 | 22.3411 | 22.3411 | 22.3411 | 2800.0 |
| 2012-08-13 07:57:00 | AAPL | Stock | 22.3393 | 22.3393 | 22.3261 | 22.3261 | 9100.0 |
| 2012-08-13 08:00:00 | AAPL | Stock | 22.3268 | 22.3429 | 22.2632 | 22.3214 | 324604.0 |
| 2012-08-13 08:01:00 | AAPL | Stock | 22.3336 | 22.3343 | 22.3214 | 22.3236 | 47152.0 |
| 2012-08-13 08:02:00 | AAPL | Stock | 22.3143 | 22.3157 | 22.3018 | 22.3018 | 89936.0 |
| 2012-08-13 08:03:00 | AAPL | Stock | 22.3018 | 22.3036 | 22.3018 | 22.3021 | 12376.0 |
| 2012-08-13 08:04:00 | AAPL | Stock | 22.3014 | 22.3014 | 22.2957 | 22.2968 | 14000.0 |
| 2012-08-13 08:05:00 | AAPL | Stock | 22.3 | 22.3118 | 22.3 | 22.3 | 24920.0 |
| 2012-08-13 08:06:00 | AAPL | Stock | 22.305 | 22.305 | 22.3029 | 22.3036 | 16800.0 |
| 2012-08-13 08:07:00 | AAPL | Stock | 22.2961 | 22.3071 | 22.2961 | 22.2979 | 11200.0 |
> showing 50 of 884,583 rows — these rows as CSV