PREVIEW / stock_1min / 2013-07-31
file: by_date/stock_1min/2013/2013-07-31.parquet size: 13.9 MB rows: 1,011,593 symbols: 2,850
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-07-31 04:00:00 | AAPL | Stock | 16.2096 | 16.2121 | 16.2096 | 16.2121 | 5600.0 |
| 2013-07-31 05:03:00 | AAPL | Stock | 16.2404 | 16.2404 | 16.2404 | 16.2404 | 2800.0 |
| 2013-07-31 05:04:00 | AAPL | Stock | 16.2404 | 16.2454 | 16.2404 | 16.2454 | 9520.0 |
| 2013-07-31 05:24:00 | AAPL | Stock | 16.2518 | 16.2518 | 16.2518 | 16.2518 | 11200.0 |
| 2013-07-31 06:21:00 | AAPL | Stock | 16.2571 | 16.2571 | 16.2571 | 16.2571 | 30800.0 |
| 2013-07-31 07:00:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 8400.0 |
| 2013-07-31 07:01:00 | AAPL | Stock | 16.2286 | 16.2286 | 16.2286 | 16.2286 | 5600.0 |
| 2013-07-31 07:04:00 | AAPL | Stock | 16.2479 | 16.2479 | 16.2479 | 16.2479 | 2800.0 |
| 2013-07-31 07:08:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 15792.0 |
| 2013-07-31 07:13:00 | AAPL | Stock | 16.2589 | 16.2589 | 16.2589 | 16.2589 | 4760.0 |
| 2013-07-31 07:20:00 | AAPL | Stock | 16.2618 | 16.2618 | 16.2618 | 16.2618 | 2800.0 |
| 2013-07-31 07:23:00 | AAPL | Stock | 16.275 | 16.2882 | 16.275 | 16.2882 | 11200.0 |
| 2013-07-31 07:25:00 | AAPL | Stock | 16.295 | 16.3036 | 16.2896 | 16.2964 | 16800.0 |
| 2013-07-31 07:26:00 | AAPL | Stock | 16.3036 | 16.3036 | 16.2857 | 16.3032 | 47600.0 |
| 2013-07-31 07:27:00 | AAPL | Stock | 16.2946 | 16.2946 | 16.2854 | 16.2857 | 84000.0 |
| 2013-07-31 07:28:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2857 | 16.2857 | 16800.0 |
| 2013-07-31 07:29:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2857 | 16.2857 | 28000.0 |
| 2013-07-31 07:30:00 | AAPL | Stock | 16.2857 | 16.2857 | 16.2857 | 16.2857 | 2800.0 |
| 2013-07-31 07:31:00 | AAPL | Stock | 16.2786 | 16.2786 | 16.2786 | 16.2786 | 5600.0 |
| 2013-07-31 07:32:00 | AAPL | Stock | 16.2786 | 16.2786 | 16.275 | 16.275 | 8400.0 |
| 2013-07-31 07:33:00 | AAPL | Stock | 16.275 | 16.275 | 16.275 | 16.275 | 8400.0 |
| 2013-07-31 07:34:00 | AAPL | Stock | 16.2796 | 16.2796 | 16.2796 | 16.2796 | 2800.0 |
| 2013-07-31 07:35:00 | AAPL | Stock | 16.275 | 16.275 | 16.275 | 16.275 | 4200.0 |
| 2013-07-31 07:39:00 | AAPL | Stock | 16.2732 | 16.2732 | 16.2729 | 16.2729 | 5600.0 |
| 2013-07-31 07:40:00 | AAPL | Stock | 16.2679 | 16.2679 | 16.2679 | 16.2679 | 2800.0 |
| 2013-07-31 07:41:00 | AAPL | Stock | 16.2679 | 16.2679 | 16.2679 | 16.2679 | 2800.0 |
| 2013-07-31 07:47:00 | AAPL | Stock | 16.2721 | 16.2729 | 16.2721 | 16.2729 | 9800.0 |
| 2013-07-31 07:54:00 | AAPL | Stock | 16.2686 | 16.2686 | 16.2686 | 16.2686 | 2800.0 |
| 2013-07-31 07:57:00 | AAPL | Stock | 16.2757 | 16.2764 | 16.2757 | 16.2764 | 14000.0 |
| 2013-07-31 08:00:00 | AAPL | Stock | 16.2754 | 16.2796 | 16.2446 | 16.2768 | 106092.0 |
| 2013-07-31 08:01:00 | AAPL | Stock | 16.2614 | 16.2714 | 16.2614 | 16.2714 | 31360.0 |
| 2013-07-31 08:02:00 | AAPL | Stock | 16.2679 | 16.2679 | 16.2679 | 16.2679 | 4200.0 |
| 2013-07-31 08:03:00 | AAPL | Stock | 16.2739 | 16.2761 | 16.2679 | 16.2679 | 89012.0 |
| 2013-07-31 08:04:00 | AAPL | Stock | 16.2746 | 16.2746 | 16.1071 | 16.1071 | 28280.0 |
| 2013-07-31 08:05:00 | AAPL | Stock | 16.2679 | 16.2679 | 16.2679 | 16.2679 | 20048.0 |
| 2013-07-31 08:06:00 | AAPL | Stock | 16.2607 | 16.2639 | 16.2607 | 16.2607 | 9856.0 |
| 2013-07-31 08:07:00 | AAPL | Stock | 16.2643 | 16.275 | 16.2643 | 16.275 | 72660.0 |
| 2013-07-31 08:08:00 | AAPL | Stock | 16.2686 | 16.2768 | 16.2686 | 16.2768 | 14000.0 |
| 2013-07-31 08:09:00 | AAPL | Stock | 16.2786 | 16.2786 | 16.2679 | 16.2679 | 29400.0 |
| 2013-07-31 08:13:00 | AAPL | Stock | 16.2768 | 16.2821 | 16.2768 | 16.2821 | 23800.0 |
| 2013-07-31 08:14:00 | AAPL | Stock | 16.2821 | 16.2821 | 16.2768 | 16.2768 | 16800.0 |
| 2013-07-31 08:15:00 | AAPL | Stock | 16.2786 | 16.2786 | 16.275 | 16.2786 | 69048.0 |
| 2013-07-31 08:16:00 | AAPL | Stock | 16.2761 | 16.2761 | 16.2679 | 16.2679 | 53200.0 |
| 2013-07-31 08:17:00 | AAPL | Stock | 16.2686 | 16.2686 | 16.2636 | 16.265 | 102620.0 |
| 2013-07-31 08:18:00 | AAPL | Stock | 16.2714 | 16.2721 | 16.2714 | 16.2721 | 12600.0 |
| 2013-07-31 08:19:00 | AAPL | Stock | 16.2671 | 16.2729 | 16.2668 | 16.2729 | 87388.0 |
| 2013-07-31 08:20:00 | AAPL | Stock | 16.2704 | 16.2754 | 16.2704 | 16.2714 | 49784.0 |
| 2013-07-31 08:21:00 | AAPL | Stock | 16.2561 | 16.2689 | 16.2518 | 16.2689 | 44800.0 |
| 2013-07-31 08:22:00 | AAPL | Stock | 16.2679 | 16.2679 | 16.2575 | 16.2575 | 28000.0 |
| 2013-07-31 08:23:00 | AAPL | Stock | 16.2514 | 16.2536 | 16.2464 | 16.25 | 55664.0 |
> showing 50 of 1,011,593 rows — these rows as CSV