PREVIEW / stock_1min / 2013-02-06
file: by_date/stock_1min/2013/2013-02-06.parquet size: 12.9 MB rows: 950,377 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 |
|---|---|---|---|---|---|---|---|
| 2013-02-06 04:35:00 | AAPL | Stock | 16.3754 | 16.3754 | 16.375 | 16.375 | 5600.0 |
| 2013-02-06 05:07:00 | AAPL | Stock | 16.3307 | 16.3311 | 16.3304 | 16.3304 | 25200.0 |
| 2013-02-06 05:08:00 | AAPL | Stock | 16.3 | 16.3 | 16.3 | 16.3 | 5600.0 |
| 2013-02-06 05:10:00 | AAPL | Stock | 16.2979 | 16.2979 | 16.2979 | 16.2979 | 25200.0 |
| 2013-02-06 05:11:00 | AAPL | Stock | 16.2864 | 16.2864 | 16.2864 | 16.2864 | 5460.0 |
| 2013-02-06 05:12:00 | AAPL | Stock | 16.2864 | 16.2864 | 16.2864 | 16.2864 | 22400.0 |
| 2013-02-06 05:14:00 | AAPL | Stock | 16.2714 | 16.2714 | 16.2714 | 16.2714 | 2800.0 |
| 2013-02-06 05:24:00 | AAPL | Stock | 16.2779 | 16.2779 | 16.2779 | 16.2779 | 2800.0 |
| 2013-02-06 05:25:00 | AAPL | Stock | 16.2775 | 16.2775 | 16.2775 | 16.2775 | 3360.0 |
| 2013-02-06 05:29:00 | AAPL | Stock | 16.265 | 16.265 | 16.2643 | 16.2643 | 19600.0 |
| 2013-02-06 05:45:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2857 | 16.2857 | 2800.0 |
| 2013-02-06 06:00:00 | AAPL | Stock | 16.2964 | 16.2964 | 16.2964 | 16.2964 | 4200.0 |
| 2013-02-06 06:10:00 | AAPL | Stock | 16.3032 | 16.3032 | 16.3032 | 16.3032 | 10640.0 |
| 2013-02-06 06:11:00 | AAPL | Stock | 16.3071 | 16.3071 | 16.3071 | 16.3071 | 2800.0 |
| 2013-02-06 06:12:00 | AAPL | Stock | 16.3089 | 16.3089 | 16.3089 | 16.3089 | 2800.0 |
| 2013-02-06 06:24:00 | AAPL | Stock | 16.3214 | 16.3307 | 16.3214 | 16.3307 | 8400.0 |
| 2013-02-06 06:28:00 | AAPL | Stock | 16.3536 | 16.3536 | 16.3536 | 16.3536 | 15400.0 |
| 2013-02-06 06:29:00 | AAPL | Stock | 16.3536 | 16.3536 | 16.3536 | 16.3536 | 2800.0 |
| 2013-02-06 06:31:00 | AAPL | Stock | 16.3536 | 16.3536 | 16.3536 | 16.3536 | 2800.0 |
| 2013-02-06 06:33:00 | AAPL | Stock | 16.3432 | 16.3432 | 16.3432 | 16.3432 | 2800.0 |
| 2013-02-06 06:38:00 | AAPL | Stock | 16.3393 | 16.3393 | 16.3393 | 16.3393 | 2800.0 |
| 2013-02-06 06:43:00 | AAPL | Stock | 16.3307 | 16.3307 | 16.3214 | 16.3214 | 5600.0 |
| 2013-02-06 06:44:00 | AAPL | Stock | 16.325 | 16.325 | 16.325 | 16.325 | 2800.0 |
| 2013-02-06 06:48:00 | AAPL | Stock | 16.3354 | 16.3354 | 16.3354 | 16.3354 | 4256.0 |
| 2013-02-06 06:57:00 | AAPL | Stock | 16.325 | 16.325 | 16.325 | 16.325 | 5600.0 |
| 2013-02-06 07:00:00 | AAPL | Stock | 16.3214 | 16.3214 | 16.3214 | 16.3214 | 8400.0 |
| 2013-02-06 07:01:00 | AAPL | Stock | 16.3304 | 16.3304 | 16.3304 | 16.3304 | 14000.0 |
| 2013-02-06 07:03:00 | AAPL | Stock | 16.3357 | 16.3357 | 16.3357 | 16.3357 | 2800.0 |
| 2013-02-06 07:04:00 | AAPL | Stock | 16.3332 | 16.3332 | 16.3332 | 16.3332 | 2800.0 |
| 2013-02-06 07:07:00 | AAPL | Stock | 16.3304 | 16.3346 | 16.3304 | 16.3346 | 30800.0 |
| 2013-02-06 07:08:00 | AAPL | Stock | 16.3393 | 16.3393 | 16.3393 | 16.3393 | 2800.0 |
| 2013-02-06 07:11:00 | AAPL | Stock | 16.3425 | 16.3425 | 16.3425 | 16.3425 | 2800.0 |
| 2013-02-06 07:12:00 | AAPL | Stock | 16.3425 | 16.3461 | 16.3425 | 16.3425 | 11200.0 |
| 2013-02-06 07:14:00 | AAPL | Stock | 16.3279 | 16.3279 | 16.3279 | 16.3279 | 5600.0 |
| 2013-02-06 07:17:00 | AAPL | Stock | 16.3214 | 16.3214 | 16.3214 | 16.3214 | 8288.0 |
| 2013-02-06 07:18:00 | AAPL | Stock | 16.3214 | 16.3214 | 16.3025 | 16.3036 | 25200.0 |
| 2013-02-06 07:21:00 | AAPL | Stock | 16.3036 | 16.3036 | 16.3036 | 16.3036 | 13944.0 |
| 2013-02-06 07:22:00 | AAPL | Stock | 16.3036 | 16.3036 | 16.3036 | 16.3036 | 8400.0 |
| 2013-02-06 07:23:00 | AAPL | Stock | 16.3071 | 16.3071 | 16.2893 | 16.2893 | 12208.0 |
| 2013-02-06 07:24:00 | AAPL | Stock | 16.2893 | 16.3082 | 16.2893 | 16.3082 | 7336.0 |
| 2013-02-06 07:25:00 | AAPL | Stock | 16.3004 | 16.3004 | 16.3 | 16.3 | 14000.0 |
| 2013-02-06 07:26:00 | AAPL | Stock | 16.2893 | 16.2896 | 16.2854 | 16.2896 | 53200.0 |
| 2013-02-06 07:27:00 | AAPL | Stock | 16.2896 | 16.2896 | 16.2818 | 16.2818 | 11200.0 |
| 2013-02-06 07:28:00 | AAPL | Stock | 16.2911 | 16.2911 | 16.2911 | 16.2911 | 2800.0 |
| 2013-02-06 07:29:00 | AAPL | Stock | 16.2864 | 16.2864 | 16.2854 | 16.2857 | 30128.0 |
| 2013-02-06 07:30:00 | AAPL | Stock | 16.2896 | 16.2896 | 16.2896 | 16.2896 | 2800.0 |
| 2013-02-06 07:32:00 | AAPL | Stock | 16.2861 | 16.2861 | 16.2861 | 16.2861 | 2800.0 |
| 2013-02-06 07:34:00 | AAPL | Stock | 16.2946 | 16.2964 | 16.2929 | 16.2964 | 8960.0 |
| 2013-02-06 07:35:00 | AAPL | Stock | 16.3004 | 16.3036 | 16.3004 | 16.3036 | 11368.0 |
| 2013-02-06 07:36:00 | AAPL | Stock | 16.2946 | 16.2946 | 16.2946 | 16.2946 | 2800.0 |
> showing 50 of 950,377 rows — these rows as CSV