PREVIEW / stock_1min / 2014-04-29
file: by_date/stock_1min/2014/2014-04-29.parquet size: 14.4 MB rows: 1,060,367 symbols: 2,878
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-29 04:00:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2857 | 21.2857 | 5600.0 |
| 2014-04-29 04:05:00 | AAPL | Stock | 21.2536 | 21.2536 | 21.2536 | 21.2536 | 2800.0 |
| 2014-04-29 04:33:00 | AAPL | Stock | 21.2621 | 21.2621 | 21.2621 | 21.2621 | 3780.0 |
| 2014-04-29 05:20:00 | AAPL | Stock | 21.2668 | 21.2668 | 21.25 | 21.25 | 5600.0 |
| 2014-04-29 05:43:00 | AAPL | Stock | 21.2668 | 21.2668 | 21.2668 | 21.2668 | 11200.0 |
| 2014-04-29 05:55:00 | AAPL | Stock | 21.2821 | 21.2821 | 21.2821 | 21.2821 | 5600.0 |
| 2014-04-29 06:02:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2857 | 21.2857 | 2800.0 |
| 2014-04-29 06:11:00 | AAPL | Stock | 21.2964 | 21.2964 | 21.2964 | 21.2964 | 2800.0 |
| 2014-04-29 06:23:00 | AAPL | Stock | 21.2964 | 21.2964 | 21.2957 | 21.2957 | 17052.0 |
| 2014-04-29 06:37:00 | AAPL | Stock | 21.2964 | 21.2964 | 21.2964 | 21.2964 | 2800.0 |
| 2014-04-29 06:45:00 | AAPL | Stock | 21.2821 | 21.2821 | 21.2821 | 21.2821 | 26600.0 |
| 2014-04-29 06:52:00 | AAPL | Stock | 21.3025 | 21.3025 | 21.3025 | 21.3025 | 2800.0 |
| 2014-04-29 07:00:00 | AAPL | Stock | 21.2732 | 21.2732 | 21.2732 | 21.2732 | 2800.0 |
| 2014-04-29 07:01:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2857 | 21.2857 | 11732.0 |
| 2014-04-29 07:04:00 | AAPL | Stock | 21.3 | 21.3004 | 21.3 | 21.3004 | 14420.0 |
| 2014-04-29 07:06:00 | AAPL | Stock | 21.2964 | 21.3064 | 21.2964 | 21.3 | 21812.0 |
| 2014-04-29 07:10:00 | AAPL | Stock | 21.2964 | 21.3064 | 21.2961 | 21.2964 | 30800.0 |
| 2014-04-29 07:13:00 | AAPL | Stock | 21.2964 | 21.2964 | 21.2964 | 21.2964 | 2800.0 |
| 2014-04-29 07:15:00 | AAPL | Stock | 21.3004 | 21.3004 | 21.2964 | 21.2964 | 5600.0 |
| 2014-04-29 07:19:00 | AAPL | Stock | 21.2964 | 21.2964 | 21.2964 | 21.2964 | 2800.0 |
| 2014-04-29 07:21:00 | AAPL | Stock | 21.2882 | 21.2882 | 21.2875 | 21.2882 | 8400.0 |
| 2014-04-29 07:22:00 | AAPL | Stock | 21.2861 | 21.2861 | 21.2861 | 21.2861 | 2800.0 |
| 2014-04-29 07:23:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2857 | 21.2857 | 3640.0 |
| 2014-04-29 07:29:00 | AAPL | Stock | 21.2804 | 21.2857 | 21.2804 | 21.2857 | 8400.0 |
| 2014-04-29 07:30:00 | AAPL | Stock | 21.2779 | 21.2857 | 21.2779 | 21.2857 | 11200.0 |
| 2014-04-29 07:32:00 | AAPL | Stock | 21.2821 | 21.2821 | 21.2821 | 21.2821 | 2800.0 |
| 2014-04-29 07:33:00 | AAPL | Stock | 21.2821 | 21.285 | 21.2821 | 21.285 | 5600.0 |
| 2014-04-29 07:34:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2854 | 21.2857 | 14000.0 |
| 2014-04-29 07:35:00 | AAPL | Stock | 21.2857 | 21.2857 | 21.2725 | 21.2725 | 43932.0 |
| 2014-04-29 07:36:00 | AAPL | Stock | 21.2771 | 21.2854 | 21.2714 | 21.2714 | 86044.0 |
| 2014-04-29 07:37:00 | AAPL | Stock | 21.2746 | 21.2761 | 21.2743 | 21.2743 | 14000.0 |
| 2014-04-29 07:38:00 | AAPL | Stock | 21.2639 | 21.2746 | 21.2639 | 21.2746 | 5600.0 |
| 2014-04-29 07:39:00 | AAPL | Stock | 21.2732 | 21.2732 | 21.2732 | 21.2732 | 8400.0 |
| 2014-04-29 07:40:00 | AAPL | Stock | 21.2764 | 21.2964 | 21.2764 | 21.2964 | 71232.0 |
| 2014-04-29 07:41:00 | AAPL | Stock | 21.3061 | 21.3061 | 21.3061 | 21.3061 | 8400.0 |
| 2014-04-29 07:42:00 | AAPL | Stock | 21.3064 | 21.3143 | 21.3064 | 21.3143 | 23800.0 |
| 2014-04-29 07:43:00 | AAPL | Stock | 21.3139 | 21.3139 | 21.3139 | 21.3139 | 2800.0 |
| 2014-04-29 07:44:00 | AAPL | Stock | 21.3136 | 21.3136 | 21.3132 | 21.3136 | 17024.0 |
| 2014-04-29 07:45:00 | AAPL | Stock | 21.3143 | 21.3386 | 21.3143 | 21.3386 | 118188.0 |
| 2014-04-29 07:46:00 | AAPL | Stock | 21.3239 | 21.3239 | 21.3036 | 21.3036 | 119560.0 |
| 2014-04-29 07:47:00 | AAPL | Stock | 21.3204 | 21.3204 | 21.3204 | 21.3204 | 4760.0 |
| 2014-04-29 07:48:00 | AAPL | Stock | 21.3071 | 21.3071 | 21.2889 | 21.2889 | 8400.0 |
| 2014-04-29 07:49:00 | AAPL | Stock | 21.3011 | 21.3011 | 21.2875 | 21.2875 | 16800.0 |
| 2014-04-29 07:51:00 | AAPL | Stock | 21.3061 | 21.3061 | 21.3061 | 21.3061 | 9520.0 |
| 2014-04-29 07:52:00 | AAPL | Stock | 21.3057 | 21.3071 | 21.305 | 21.305 | 18200.0 |
| 2014-04-29 07:53:00 | AAPL | Stock | 21.3157 | 21.3157 | 21.3036 | 21.3036 | 24080.0 |
| 2014-04-29 07:55:00 | AAPL | Stock | 21.3036 | 21.3036 | 21.295 | 21.3036 | 30520.0 |
| 2014-04-29 07:56:00 | AAPL | Stock | 21.3071 | 21.3071 | 21.3036 | 21.3039 | 19600.0 |
| 2014-04-29 07:57:00 | AAPL | Stock | 21.3071 | 21.3071 | 21.3071 | 21.3071 | 14000.0 |
| 2014-04-29 07:58:00 | AAPL | Stock | 21.3071 | 21.3175 | 21.3071 | 21.3175 | 22400.0 |
> showing 50 of 1,060,367 rows — these rows as CSV