PREVIEW / stock_1min / 2013-10-02
file: by_date/stock_1min/2013/2013-10-02.parquet size: 13.8 MB rows: 1,015,607 symbols: 2,863
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 |
|---|---|---|---|---|---|---|---|
| 2013-10-02 04:00:00 | AAPL | Stock | 17.3357 | 17.3357 | 17.3214 | 17.3214 | 31920.0 |
| 2013-10-02 04:13:00 | AAPL | Stock | 17.3132 | 17.3132 | 17.3132 | 17.3132 | 2800.0 |
| 2013-10-02 04:29:00 | AAPL | Stock | 17.2929 | 17.2929 | 17.2929 | 17.2929 | 5600.0 |
| 2013-10-02 04:30:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 2800.0 |
| 2013-10-02 04:32:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 2800.0 |
| 2013-10-02 04:38:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 2800.0 |
| 2013-10-02 05:23:00 | AAPL | Stock | 17.2964 | 17.2964 | 17.2964 | 17.2964 | 5600.0 |
| 2013-10-02 05:24:00 | AAPL | Stock | 17.2954 | 17.2954 | 17.2954 | 17.2954 | 11200.0 |
| 2013-10-02 05:45:00 | AAPL | Stock | 17.3036 | 17.3071 | 17.3036 | 17.3071 | 35000.0 |
| 2013-10-02 05:54:00 | AAPL | Stock | 17.2925 | 17.2925 | 17.2925 | 17.2925 | 2800.0 |
| 2013-10-02 06:19:00 | AAPL | Stock | 17.2932 | 17.2964 | 17.2932 | 17.2964 | 6440.0 |
| 2013-10-02 06:23:00 | AAPL | Stock | 17.3004 | 17.3004 | 17.295 | 17.295 | 8400.0 |
| 2013-10-02 06:30:00 | AAPL | Stock | 17.2946 | 17.2946 | 17.2857 | 17.2857 | 20720.0 |
| 2013-10-02 06:33:00 | AAPL | Stock | 17.2932 | 17.2946 | 17.2932 | 17.2946 | 33600.0 |
| 2013-10-02 06:37:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 4396.0 |
| 2013-10-02 06:48:00 | AAPL | Stock | 17.3211 | 17.3211 | 17.3211 | 17.3211 | 2800.0 |
| 2013-10-02 06:50:00 | AAPL | Stock | 17.3214 | 17.3214 | 17.3214 | 17.3214 | 5012.0 |
| 2013-10-02 06:52:00 | AAPL | Stock | 17.3304 | 17.3304 | 17.3304 | 17.3304 | 5600.0 |
| 2013-10-02 06:56:00 | AAPL | Stock | 17.3568 | 17.3575 | 17.3429 | 17.35 | 42000.0 |
| 2013-10-02 06:57:00 | AAPL | Stock | 17.3436 | 17.3436 | 17.3354 | 17.3354 | 30800.0 |
| 2013-10-02 06:58:00 | AAPL | Stock | 17.3164 | 17.3218 | 17.3107 | 17.3218 | 43400.0 |
| 2013-10-02 06:59:00 | AAPL | Stock | 17.3214 | 17.3214 | 17.3214 | 17.3214 | 10388.0 |
| 2013-10-02 07:00:00 | AAPL | Stock | 17.3304 | 17.3304 | 17.3161 | 17.3214 | 25004.0 |
| 2013-10-02 07:01:00 | AAPL | Stock | 17.3279 | 17.3286 | 17.3279 | 17.3286 | 9520.0 |
| 2013-10-02 07:02:00 | AAPL | Stock | 17.325 | 17.325 | 17.325 | 17.325 | 3780.0 |
| 2013-10-02 07:04:00 | AAPL | Stock | 17.3314 | 17.3321 | 17.3314 | 17.3321 | 19600.0 |
| 2013-10-02 07:05:00 | AAPL | Stock | 17.3389 | 17.3389 | 17.3329 | 17.3329 | 5600.0 |
| 2013-10-02 07:07:00 | AAPL | Stock | 17.3411 | 17.35 | 17.3339 | 17.3393 | 113372.0 |
| 2013-10-02 07:09:00 | AAPL | Stock | 17.3429 | 17.3429 | 17.3429 | 17.3429 | 2800.0 |
| 2013-10-02 07:10:00 | AAPL | Stock | 17.3429 | 17.3429 | 17.3429 | 17.3429 | 5600.0 |
| 2013-10-02 07:11:00 | AAPL | Stock | 17.3396 | 17.3396 | 17.3396 | 17.3396 | 2800.0 |
| 2013-10-02 07:14:00 | AAPL | Stock | 17.3393 | 17.3711 | 17.3389 | 17.3711 | 89600.0 |
| 2013-10-02 07:15:00 | AAPL | Stock | 17.3693 | 17.3693 | 17.3571 | 17.3571 | 11200.0 |
| 2013-10-02 07:17:00 | AAPL | Stock | 17.3679 | 17.3679 | 17.3679 | 17.3679 | 30800.0 |
| 2013-10-02 07:18:00 | AAPL | Stock | 17.3607 | 17.3607 | 17.3536 | 17.3536 | 14000.0 |
| 2013-10-02 07:19:00 | AAPL | Stock | 17.3536 | 17.3536 | 17.3536 | 17.3536 | 2800.0 |
| 2013-10-02 07:20:00 | AAPL | Stock | 17.3536 | 17.3571 | 17.3454 | 17.3571 | 66556.0 |
| 2013-10-02 07:21:00 | AAPL | Stock | 17.3554 | 17.3554 | 17.3554 | 17.3554 | 20720.0 |
| 2013-10-02 07:22:00 | AAPL | Stock | 17.3643 | 17.3707 | 17.3643 | 17.3707 | 8400.0 |
| 2013-10-02 07:23:00 | AAPL | Stock | 17.3707 | 17.3839 | 17.3664 | 17.3664 | 36400.0 |
| 2013-10-02 07:25:00 | AAPL | Stock | 17.3707 | 17.3707 | 17.3661 | 17.3664 | 70000.0 |
| 2013-10-02 07:26:00 | AAPL | Stock | 17.3679 | 17.3679 | 17.3679 | 17.3679 | 2800.0 |
| 2013-10-02 07:27:00 | AAPL | Stock | 17.3746 | 17.3754 | 17.3746 | 17.3746 | 15680.0 |
| 2013-10-02 07:28:00 | AAPL | Stock | 17.3846 | 17.3857 | 17.3846 | 17.3857 | 8680.0 |
| 2013-10-02 07:29:00 | AAPL | Stock | 17.3929 | 17.3961 | 17.3929 | 17.3929 | 29680.0 |
| 2013-10-02 07:30:00 | AAPL | Stock | 17.4004 | 17.4004 | 17.4004 | 17.4004 | 2800.0 |
| 2013-10-02 07:31:00 | AAPL | Stock | 17.3982 | 17.3982 | 17.3982 | 17.3982 | 2800.0 |
| 2013-10-02 07:32:00 | AAPL | Stock | 17.3946 | 17.3946 | 17.3946 | 17.3946 | 4872.0 |
| 2013-10-02 07:35:00 | AAPL | Stock | 17.4036 | 17.4096 | 17.4036 | 17.4096 | 50400.0 |
| 2013-10-02 07:36:00 | AAPL | Stock | 17.4336 | 17.4336 | 17.4336 | 17.4336 | 5600.0 |
> showing 50 of 1,015,607 rows — these rows as CSV