PREVIEW / stock_1min / 2011-01-26
file: by_date/stock_1min/2011/2011-01-26.parquet size: 13.4 MB rows: 998,702 symbols: 2,853
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-26 04:00:00 | AAPL | Stock | 12.2457 | 12.2796 | 12.2457 | 12.2796 | 7700.0 |
| 2011-01-26 04:05:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 2800.0 |
| 2011-01-26 04:12:00 | AAPL | Stock | 12.2507 | 12.2507 | 12.2507 | 12.2507 | 2800.0 |
| 2011-01-26 04:47:00 | AAPL | Stock | 12.2804 | 12.2804 | 12.2804 | 12.2804 | 2800.0 |
| 2011-01-26 04:53:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 2800.0 |
| 2011-01-26 04:54:00 | AAPL | Stock | 12.3161 | 12.3161 | 12.3161 | 12.3161 | 11200.0 |
| 2011-01-26 04:56:00 | AAPL | Stock | 12.2957 | 12.3 | 12.2957 | 12.3 | 5600.0 |
| 2011-01-26 04:58:00 | AAPL | Stock | 12.3071 | 12.3071 | 12.3071 | 12.3071 | 2800.0 |
| 2011-01-26 05:00:00 | AAPL | Stock | 12.3079 | 12.3079 | 12.3075 | 12.3075 | 11200.0 |
| 2011-01-26 05:01:00 | AAPL | Stock | 12.3075 | 12.3075 | 12.3075 | 12.3075 | 14000.0 |
| 2011-01-26 05:02:00 | AAPL | Stock | 12.3079 | 12.3079 | 12.3079 | 12.3079 | 14000.0 |
| 2011-01-26 05:20:00 | AAPL | Stock | 12.2893 | 12.2893 | 12.2893 | 12.2893 | 2800.0 |
| 2011-01-26 05:26:00 | AAPL | Stock | 12.3025 | 12.3025 | 12.3025 | 12.3025 | 2800.0 |
| 2011-01-26 05:27:00 | AAPL | Stock | 12.3071 | 12.3071 | 12.3071 | 12.3071 | 2800.0 |
| 2011-01-26 05:29:00 | AAPL | Stock | 12.3036 | 12.3071 | 12.3036 | 12.3071 | 16800.0 |
| 2011-01-26 05:31:00 | AAPL | Stock | 12.3079 | 12.3079 | 12.3079 | 12.3079 | 2800.0 |
| 2011-01-26 05:42:00 | AAPL | Stock | 12.3146 | 12.3146 | 12.3146 | 12.3146 | 4060.0 |
| 2011-01-26 05:50:00 | AAPL | Stock | 12.3161 | 12.3161 | 12.3161 | 12.3161 | 8400.0 |
| 2011-01-26 06:02:00 | AAPL | Stock | 12.3125 | 12.3125 | 12.3125 | 12.3125 | 2800.0 |
| 2011-01-26 06:11:00 | AAPL | Stock | 12.3129 | 12.3129 | 12.3129 | 12.3129 | 2800.0 |
| 2011-01-26 06:23:00 | AAPL | Stock | 12.3036 | 12.3036 | 12.3036 | 12.3036 | 5600.0 |
| 2011-01-26 06:29:00 | AAPL | Stock | 12.3036 | 12.3036 | 12.3036 | 12.3036 | 8400.0 |
| 2011-01-26 06:47:00 | AAPL | Stock | 12.3036 | 12.3036 | 12.3036 | 12.3036 | 2800.0 |
| 2011-01-26 06:49:00 | AAPL | Stock | 12.3036 | 12.3036 | 12.3036 | 12.3036 | 4200.0 |
| 2011-01-26 06:52:00 | AAPL | Stock | 12.3 | 12.3 | 12.3 | 12.3 | 8400.0 |
| 2011-01-26 06:55:00 | AAPL | Stock | 12.3 | 12.3 | 12.3 | 12.3 | 4200.0 |
| 2011-01-26 07:00:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 2800.0 |
| 2011-01-26 07:01:00 | AAPL | Stock | 12.2857 | 12.3 | 12.2857 | 12.3 | 40320.0 |
| 2011-01-26 07:02:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 2800.0 |
| 2011-01-26 07:05:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.285 | 12.2857 | 14000.0 |
| 2011-01-26 07:06:00 | AAPL | Stock | 12.2975 | 12.2975 | 12.2975 | 12.2975 | 7000.0 |
| 2011-01-26 07:07:00 | AAPL | Stock | 12.2961 | 12.2961 | 12.2961 | 12.2961 | 8400.0 |
| 2011-01-26 07:09:00 | AAPL | Stock | 12.2807 | 12.2857 | 12.2807 | 12.2857 | 19600.0 |
| 2011-01-26 07:10:00 | AAPL | Stock | 12.2768 | 12.2771 | 12.2607 | 12.2607 | 39200.0 |
| 2011-01-26 07:11:00 | AAPL | Stock | 12.2743 | 12.2743 | 12.2743 | 12.2743 | 2800.0 |
| 2011-01-26 07:12:00 | AAPL | Stock | 12.275 | 12.2768 | 12.275 | 12.2768 | 29120.0 |
| 2011-01-26 07:14:00 | AAPL | Stock | 12.2696 | 12.2696 | 12.2696 | 12.2696 | 2800.0 |
| 2011-01-26 07:17:00 | AAPL | Stock | 12.2796 | 12.2804 | 12.2796 | 12.2804 | 5600.0 |
| 2011-01-26 07:22:00 | AAPL | Stock | 12.2786 | 12.2786 | 12.2786 | 12.2786 | 6300.0 |
| 2011-01-26 07:23:00 | AAPL | Stock | 12.2796 | 12.2796 | 12.2796 | 12.2796 | 25340.0 |
| 2011-01-26 07:28:00 | AAPL | Stock | 12.2757 | 12.2757 | 12.275 | 12.275 | 11060.0 |
| 2011-01-26 07:31:00 | AAPL | Stock | 12.2757 | 12.2757 | 12.2757 | 12.2757 | 2800.0 |
| 2011-01-26 07:33:00 | AAPL | Stock | 12.2789 | 12.2829 | 12.2789 | 12.2829 | 16660.0 |
| 2011-01-26 07:38:00 | AAPL | Stock | 12.2768 | 12.2768 | 12.2768 | 12.2768 | 2800.0 |
| 2011-01-26 07:39:00 | AAPL | Stock | 12.2768 | 12.2768 | 12.2768 | 12.2768 | 5600.0 |
| 2011-01-26 07:40:00 | AAPL | Stock | 12.2768 | 12.2768 | 12.2768 | 12.2768 | 11200.0 |
| 2011-01-26 07:44:00 | AAPL | Stock | 12.2768 | 12.2768 | 12.2768 | 12.2768 | 2800.0 |
| 2011-01-26 07:49:00 | AAPL | Stock | 12.2768 | 12.2768 | 12.2768 | 12.2768 | 8120.0 |
| 2011-01-26 07:50:00 | AAPL | Stock | 12.2768 | 12.2768 | 12.2768 | 12.2768 | 8400.0 |
| 2011-01-26 07:51:00 | AAPL | Stock | 12.2729 | 12.2761 | 12.2729 | 12.2761 | 8400.0 |
> showing 50 of 998,702 rows — these rows as CSV