PREVIEW / stock_1min / 2012-04-23
file: by_date/stock_1min/2012/2012-04-23.parquet size: 13.1 MB rows: 983,743 symbols: 2,858
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-04-23 04:00:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.3932 | 20.3932 | 11200.0 |
| 2012-04-23 04:02:00 | AAPL | Stock | 20.3932 | 20.3932 | 20.3929 | 20.3929 | 14000.0 |
| 2012-04-23 04:03:00 | AAPL | Stock | 20.3929 | 20.3929 | 20.3929 | 20.3929 | 3108.0 |
| 2012-04-23 04:04:00 | AAPL | Stock | 20.3918 | 20.3918 | 20.3661 | 20.3661 | 8400.0 |
| 2012-04-23 04:05:00 | AAPL | Stock | 20.3664 | 20.3664 | 20.3664 | 20.3664 | 3360.0 |
| 2012-04-23 04:06:00 | AAPL | Stock | 20.3661 | 20.3661 | 20.3657 | 20.3657 | 5600.0 |
| 2012-04-23 04:08:00 | AAPL | Stock | 20.3575 | 20.3575 | 20.3575 | 20.3575 | 2800.0 |
| 2012-04-23 04:09:00 | AAPL | Stock | 20.3575 | 20.3575 | 20.2857 | 20.2857 | 84812.0 |
| 2012-04-23 04:10:00 | AAPL | Stock | 20.3039 | 20.3039 | 20.3039 | 20.3039 | 9380.0 |
| 2012-04-23 04:14:00 | AAPL | Stock | 20.3046 | 20.3046 | 20.3046 | 20.3046 | 2800.0 |
| 2012-04-23 04:21:00 | AAPL | Stock | 20.3568 | 20.3568 | 20.3568 | 20.3568 | 5600.0 |
| 2012-04-23 04:25:00 | AAPL | Stock | 20.3568 | 20.3568 | 20.3568 | 20.3568 | 14000.0 |
| 2012-04-23 04:33:00 | AAPL | Stock | 20.3532 | 20.3532 | 20.3532 | 20.3532 | 2800.0 |
| 2012-04-23 04:36:00 | AAPL | Stock | 20.3221 | 20.3221 | 20.3221 | 20.3221 | 2800.0 |
| 2012-04-23 04:46:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 8400.0 |
| 2012-04-23 05:06:00 | AAPL | Stock | 20.2904 | 20.2904 | 20.2893 | 20.2893 | 27692.0 |
| 2012-04-23 05:07:00 | AAPL | Stock | 20.2879 | 20.2879 | 20.2868 | 20.2868 | 16548.0 |
| 2012-04-23 05:12:00 | AAPL | Stock | 20.2679 | 20.2679 | 20.2679 | 20.2679 | 64484.0 |
| 2012-04-23 05:13:00 | AAPL | Stock | 20.2786 | 20.2786 | 20.2786 | 20.2786 | 14000.0 |
| 2012-04-23 05:14:00 | AAPL | Stock | 20.275 | 20.275 | 20.275 | 20.275 | 14000.0 |
| 2012-04-23 05:15:00 | AAPL | Stock | 20.275 | 20.275 | 20.2679 | 20.2679 | 36400.0 |
| 2012-04-23 05:16:00 | AAPL | Stock | 20.2679 | 20.2679 | 20.2679 | 20.2679 | 13776.0 |
| 2012-04-23 05:22:00 | AAPL | Stock | 20.2168 | 20.2168 | 20.2168 | 20.2168 | 2800.0 |
| 2012-04-23 05:24:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.1861 | 20.1861 | 33208.0 |
| 2012-04-23 05:25:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.2143 | 20.2143 | 11284.0 |
| 2012-04-23 05:28:00 | AAPL | Stock | 20.1875 | 20.1875 | 20.1875 | 20.1875 | 8400.0 |
| 2012-04-23 05:31:00 | AAPL | Stock | 20.1964 | 20.1964 | 20.1964 | 20.1964 | 11508.0 |
| 2012-04-23 05:32:00 | AAPL | Stock | 20.1964 | 20.1964 | 20.1964 | 20.1964 | 14000.0 |
| 2012-04-23 05:33:00 | AAPL | Stock | 20.1821 | 20.1821 | 20.1821 | 20.1821 | 2800.0 |
| 2012-04-23 05:34:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.2143 | 20.2143 | 9212.0 |
| 2012-04-23 05:35:00 | AAPL | Stock | 20.2143 | 20.2318 | 20.2143 | 20.2143 | 19516.0 |
| 2012-04-23 05:37:00 | AAPL | Stock | 20.2318 | 20.2318 | 20.2318 | 20.2318 | 2800.0 |
| 2012-04-23 05:38:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.2143 | 20.2143 | 12152.0 |
| 2012-04-23 05:48:00 | AAPL | Stock | 20.2136 | 20.2143 | 20.2136 | 20.2143 | 5600.0 |
| 2012-04-23 05:54:00 | AAPL | Stock | 20.2146 | 20.2146 | 20.2146 | 20.2146 | 14000.0 |
| 2012-04-23 05:57:00 | AAPL | Stock | 20.25 | 20.25 | 20.25 | 20.25 | 2800.0 |
| 2012-04-23 06:01:00 | AAPL | Stock | 20.2675 | 20.2675 | 20.2675 | 20.2675 | 11200.0 |
| 2012-04-23 06:02:00 | AAPL | Stock | 20.2675 | 20.2675 | 20.2568 | 20.2568 | 5600.0 |
| 2012-04-23 06:04:00 | AAPL | Stock | 20.2568 | 20.2568 | 20.2568 | 20.2568 | 2800.0 |
| 2012-04-23 06:11:00 | AAPL | Stock | 20.2411 | 20.2411 | 20.2411 | 20.2411 | 25760.0 |
| 2012-04-23 06:15:00 | AAPL | Stock | 20.2675 | 20.2675 | 20.2675 | 20.2675 | 14000.0 |
| 2012-04-23 06:16:00 | AAPL | Stock | 20.2679 | 20.2679 | 20.2675 | 20.2679 | 21308.0 |
| 2012-04-23 06:30:00 | AAPL | Stock | 20.2232 | 20.2232 | 20.2232 | 20.2232 | 5040.0 |
| 2012-04-23 06:32:00 | AAPL | Stock | 20.2143 | 20.2143 | 20.2143 | 20.2143 | 13720.0 |
| 2012-04-23 06:38:00 | AAPL | Stock | 20.2393 | 20.2393 | 20.2393 | 20.2393 | 5600.0 |
| 2012-04-23 06:45:00 | AAPL | Stock | 20.2482 | 20.2482 | 20.2482 | 20.2482 | 2800.0 |
| 2012-04-23 06:46:00 | AAPL | Stock | 20.2482 | 20.2482 | 20.2482 | 20.2482 | 2800.0 |
| 2012-04-23 06:52:00 | AAPL | Stock | 20.2479 | 20.2482 | 20.2479 | 20.2482 | 26320.0 |
| 2012-04-23 06:56:00 | AAPL | Stock | 20.25 | 20.25 | 20.25 | 20.25 | 2800.0 |
| 2012-04-23 06:58:00 | AAPL | Stock | 20.2582 | 20.2614 | 20.2582 | 20.2614 | 16800.0 |
> showing 50 of 983,743 rows — these rows as CSV