PREVIEW / stock_1min / 2012-05-11
file: by_date/stock_1min/2012/2012-05-11.parquet size: 12.8 MB rows: 957,508 symbols: 2,842
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-05-11 04:35:00 | AAPL | Stock | 20.3093 | 20.3093 | 20.3093 | 20.3093 | 2800.0 |
| 2012-05-11 04:36:00 | AAPL | Stock | 20.3 | 20.3 | 20.3 | 20.3 | 8400.0 |
| 2012-05-11 04:40:00 | AAPL | Stock | 20.3093 | 20.3093 | 20.3093 | 20.3093 | 5600.0 |
| 2012-05-11 05:16:00 | AAPL | Stock | 20.3093 | 20.3093 | 20.3093 | 20.3093 | 5600.0 |
| 2012-05-11 06:08:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 8400.0 |
| 2012-05-11 06:12:00 | AAPL | Stock | 20.3036 | 20.3036 | 20.3036 | 20.3036 | 2800.0 |
| 2012-05-11 06:13:00 | AAPL | Stock | 20.3093 | 20.3093 | 20.3093 | 20.3093 | 2800.0 |
| 2012-05-11 06:15:00 | AAPL | Stock | 20.3093 | 20.3093 | 20.3093 | 20.3093 | 2800.0 |
| 2012-05-11 06:16:00 | AAPL | Stock | 20.3143 | 20.3143 | 20.3143 | 20.3143 | 20300.0 |
| 2012-05-11 06:17:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 28000.0 |
| 2012-05-11 06:21:00 | AAPL | Stock | 20.3143 | 20.3143 | 20.3143 | 20.3143 | 12880.0 |
| 2012-05-11 06:22:00 | AAPL | Stock | 20.33 | 20.33 | 20.33 | 20.33 | 2800.0 |
| 2012-05-11 06:23:00 | AAPL | Stock | 20.3304 | 20.3304 | 20.3304 | 20.3304 | 2800.0 |
| 2012-05-11 06:36:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 6160.0 |
| 2012-05-11 06:52:00 | AAPL | Stock | 20.2739 | 20.2739 | 20.2736 | 20.2736 | 11200.0 |
| 2012-05-11 06:53:00 | AAPL | Stock | 20.2407 | 20.2407 | 20.2407 | 20.2407 | 5600.0 |
| 2012-05-11 06:55:00 | AAPL | Stock | 20.2571 | 20.2571 | 20.2571 | 20.2571 | 5600.0 |
| 2012-05-11 06:56:00 | AAPL | Stock | 20.2721 | 20.2721 | 20.2721 | 20.2721 | 16800.0 |
| 2012-05-11 07:00:00 | AAPL | Stock | 20.2786 | 20.2786 | 20.2786 | 20.2786 | 2800.0 |
| 2012-05-11 07:01:00 | AAPL | Stock | 20.2786 | 20.2786 | 20.2786 | 20.2786 | 2800.0 |
| 2012-05-11 07:10:00 | AAPL | Stock | 20.2782 | 20.2782 | 20.2782 | 20.2782 | 2800.0 |
| 2012-05-11 07:19:00 | AAPL | Stock | 20.2596 | 20.26 | 20.25 | 20.25 | 65156.0 |
| 2012-05-11 07:20:00 | AAPL | Stock | 20.25 | 20.25 | 20.25 | 20.25 | 11200.0 |
| 2012-05-11 07:21:00 | AAPL | Stock | 20.2411 | 20.2411 | 20.2411 | 20.2411 | 2800.0 |
| 2012-05-11 07:22:00 | AAPL | Stock | 20.2489 | 20.2493 | 20.2375 | 20.2375 | 81340.0 |
| 2012-05-11 07:23:00 | AAPL | Stock | 20.2375 | 20.2375 | 20.2321 | 20.2321 | 8400.0 |
| 2012-05-11 07:25:00 | AAPL | Stock | 20.25 | 20.25 | 20.25 | 20.25 | 28000.0 |
| 2012-05-11 07:26:00 | AAPL | Stock | 20.25 | 20.25 | 20.2339 | 20.2339 | 31640.0 |
| 2012-05-11 07:27:00 | AAPL | Stock | 20.2486 | 20.2486 | 20.2486 | 20.2486 | 5600.0 |
| 2012-05-11 07:28:00 | AAPL | Stock | 20.2489 | 20.2489 | 20.2464 | 20.2475 | 56812.0 |
| 2012-05-11 07:29:00 | AAPL | Stock | 20.25 | 20.25 | 20.2429 | 20.2429 | 5600.0 |
| 2012-05-11 07:30:00 | AAPL | Stock | 20.2464 | 20.2464 | 20.2464 | 20.2464 | 11200.0 |
| 2012-05-11 07:31:00 | AAPL | Stock | 20.2464 | 20.2464 | 20.2421 | 20.2421 | 19600.0 |
| 2012-05-11 07:32:00 | AAPL | Stock | 20.2411 | 20.2464 | 20.2411 | 20.2464 | 56000.0 |
| 2012-05-11 07:33:00 | AAPL | Stock | 20.2461 | 20.2657 | 20.2461 | 20.2568 | 79688.0 |
| 2012-05-11 07:34:00 | AAPL | Stock | 20.2568 | 20.2679 | 20.2568 | 20.2679 | 21000.0 |
| 2012-05-11 07:35:00 | AAPL | Stock | 20.2621 | 20.2621 | 20.2539 | 20.2539 | 26880.0 |
| 2012-05-11 07:36:00 | AAPL | Stock | 20.2711 | 20.2914 | 20.2668 | 20.2914 | 84672.0 |
| 2012-05-11 07:37:00 | AAPL | Stock | 20.2857 | 20.2954 | 20.2857 | 20.295 | 14000.0 |
| 2012-05-11 07:39:00 | AAPL | Stock | 20.2743 | 20.2854 | 20.2743 | 20.2854 | 21588.0 |
| 2012-05-11 07:40:00 | AAPL | Stock | 20.2614 | 20.2782 | 20.2593 | 20.2782 | 41160.0 |
| 2012-05-11 07:41:00 | AAPL | Stock | 20.2679 | 20.2679 | 20.2679 | 20.2679 | 14000.0 |
| 2012-05-11 07:42:00 | AAPL | Stock | 20.2679 | 20.2679 | 20.2679 | 20.2679 | 11200.0 |
| 2012-05-11 07:43:00 | AAPL | Stock | 20.2554 | 20.2579 | 20.2554 | 20.2554 | 16380.0 |
| 2012-05-11 07:44:00 | AAPL | Stock | 20.2621 | 20.2621 | 20.2621 | 20.2621 | 2800.0 |
| 2012-05-11 07:45:00 | AAPL | Stock | 20.2636 | 20.2754 | 20.2589 | 20.2746 | 70280.0 |
| 2012-05-11 07:46:00 | AAPL | Stock | 20.2614 | 20.2643 | 20.2607 | 20.2643 | 32760.0 |
| 2012-05-11 07:48:00 | AAPL | Stock | 20.2643 | 20.2646 | 20.2529 | 20.2529 | 95200.0 |
| 2012-05-11 07:49:00 | AAPL | Stock | 20.2575 | 20.2575 | 20.2575 | 20.2575 | 2800.0 |
| 2012-05-11 07:51:00 | AAPL | Stock | 20.2575 | 20.2579 | 20.2575 | 20.2575 | 14000.0 |
> showing 50 of 957,508 rows — these rows as CSV