PREVIEW / stock_1min / 2010-11-10
file: by_date/stock_1min/2010/2010-11-10.parquet size: 13.2 MB rows: 993,390 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 |
|---|---|---|---|---|---|---|---|
| 2010-11-10 05:13:00 | AAPL | Stock | 11.3018 | 11.3018 | 11.3018 | 11.3018 | 5600.0 |
| 2010-11-10 05:15:00 | AAPL | Stock | 11.305 | 11.305 | 11.305 | 11.305 | 2800.0 |
| 2010-11-10 05:17:00 | AAPL | Stock | 11.3196 | 11.3196 | 11.3196 | 11.3196 | 2800.0 |
| 2010-11-10 05:19:00 | AAPL | Stock | 11.3196 | 11.3368 | 11.3196 | 11.3368 | 5600.0 |
| 2010-11-10 05:40:00 | AAPL | Stock | 11.3036 | 11.3036 | 11.3036 | 11.3036 | 2800.0 |
| 2010-11-10 06:04:00 | AAPL | Stock | 11.3025 | 11.305 | 11.3025 | 11.305 | 8400.0 |
| 2010-11-10 06:08:00 | AAPL | Stock | 11.3189 | 11.3189 | 11.3189 | 11.3189 | 14000.0 |
| 2010-11-10 06:10:00 | AAPL | Stock | 11.3082 | 11.3082 | 11.3082 | 11.3082 | 28000.0 |
| 2010-11-10 06:17:00 | AAPL | Stock | 11.3082 | 11.3082 | 11.3082 | 11.3082 | 2800.0 |
| 2010-11-10 06:24:00 | AAPL | Stock | 11.3082 | 11.3082 | 11.3082 | 11.3082 | 2800.0 |
| 2010-11-10 06:25:00 | AAPL | Stock | 11.3054 | 11.3054 | 11.3054 | 11.3054 | 5600.0 |
| 2010-11-10 06:37:00 | AAPL | Stock | 11.3054 | 11.3189 | 11.3054 | 11.3189 | 8400.0 |
| 2010-11-10 06:48:00 | AAPL | Stock | 11.3189 | 11.3189 | 11.3189 | 11.3189 | 13916.0 |
| 2010-11-10 06:59:00 | AAPL | Stock | 11.3114 | 11.3114 | 11.3114 | 11.3114 | 2800.0 |
| 2010-11-10 07:00:00 | AAPL | Stock | 11.3054 | 11.3054 | 11.3054 | 11.3054 | 2800.0 |
| 2010-11-10 07:01:00 | AAPL | Stock | 11.315 | 11.315 | 11.315 | 11.315 | 2800.0 |
| 2010-11-10 07:02:00 | AAPL | Stock | 11.3189 | 11.3189 | 11.3189 | 11.3189 | 2800.0 |
| 2010-11-10 07:03:00 | AAPL | Stock | 11.3425 | 11.3425 | 11.3425 | 11.3425 | 14000.0 |
| 2010-11-10 07:05:00 | AAPL | Stock | 11.34 | 11.3404 | 11.34 | 11.3404 | 21840.0 |
| 2010-11-10 07:07:00 | AAPL | Stock | 11.34 | 11.34 | 11.34 | 11.34 | 2800.0 |
| 2010-11-10 07:13:00 | AAPL | Stock | 11.3114 | 11.3114 | 11.3114 | 11.3114 | 2800.0 |
| 2010-11-10 07:18:00 | AAPL | Stock | 11.3118 | 11.3118 | 11.3118 | 11.3118 | 2800.0 |
| 2010-11-10 07:21:00 | AAPL | Stock | 11.3118 | 11.3118 | 11.3118 | 11.3118 | 7168.0 |
| 2010-11-10 07:23:00 | AAPL | Stock | 11.3125 | 11.3196 | 11.3071 | 11.3196 | 26040.0 |
| 2010-11-10 07:24:00 | AAPL | Stock | 11.3071 | 11.3071 | 11.3054 | 11.3054 | 19992.0 |
| 2010-11-10 07:27:00 | AAPL | Stock | 11.3025 | 11.3025 | 11.3025 | 11.3025 | 7700.0 |
| 2010-11-10 07:31:00 | AAPL | Stock | 11.3182 | 11.3182 | 11.3036 | 11.3036 | 8400.0 |
| 2010-11-10 07:41:00 | AAPL | Stock | 11.3 | 11.3 | 11.2864 | 11.2864 | 25200.0 |
| 2010-11-10 07:52:00 | AAPL | Stock | 11.2825 | 11.2843 | 11.2825 | 11.2843 | 8400.0 |
| 2010-11-10 07:53:00 | AAPL | Stock | 11.2793 | 11.28 | 11.2793 | 11.2793 | 40600.0 |
| 2010-11-10 07:54:00 | AAPL | Stock | 11.2804 | 11.2804 | 11.2793 | 11.2793 | 40600.0 |
| 2010-11-10 07:55:00 | AAPL | Stock | 11.2793 | 11.3032 | 11.2793 | 11.3032 | 28000.0 |
| 2010-11-10 07:57:00 | AAPL | Stock | 11.2993 | 11.2993 | 11.2993 | 11.2993 | 2800.0 |
| 2010-11-10 08:00:00 | AAPL | Stock | 11.2857 | 11.2946 | 11.2857 | 11.2946 | 136332.0 |
| 2010-11-10 08:01:00 | AAPL | Stock | 11.2929 | 11.2939 | 11.2929 | 11.2939 | 41776.0 |
| 2010-11-10 08:02:00 | AAPL | Stock | 11.2925 | 11.2946 | 11.2925 | 11.2925 | 144368.0 |
| 2010-11-10 08:03:00 | AAPL | Stock | 11.2946 | 11.2946 | 11.2911 | 11.2911 | 12600.0 |
| 2010-11-10 08:04:00 | AAPL | Stock | 11.2939 | 11.2939 | 11.2939 | 11.2939 | 25760.0 |
| 2010-11-10 08:05:00 | AAPL | Stock | 11.2943 | 11.2946 | 11.2929 | 11.2929 | 53200.0 |
| 2010-11-10 08:06:00 | AAPL | Stock | 11.2914 | 11.2946 | 11.2911 | 11.2943 | 42000.0 |
| 2010-11-10 08:07:00 | AAPL | Stock | 11.2943 | 11.2943 | 11.2936 | 11.2936 | 30100.0 |
| 2010-11-10 08:08:00 | AAPL | Stock | 11.2932 | 11.2932 | 11.2929 | 11.2929 | 16800.0 |
| 2010-11-10 08:09:00 | AAPL | Stock | 11.2925 | 11.2925 | 11.2857 | 11.2857 | 61600.0 |
| 2010-11-10 08:10:00 | AAPL | Stock | 11.2857 | 11.2868 | 11.2786 | 11.2821 | 119700.0 |
| 2010-11-10 08:12:00 | AAPL | Stock | 11.2804 | 11.2804 | 11.2804 | 11.2804 | 2800.0 |
| 2010-11-10 08:13:00 | AAPL | Stock | 11.2786 | 11.2786 | 11.2786 | 11.2786 | 5600.0 |
| 2010-11-10 08:14:00 | AAPL | Stock | 11.2786 | 11.2786 | 11.2786 | 11.2786 | 14000.0 |
| 2010-11-10 08:15:00 | AAPL | Stock | 11.28 | 11.2946 | 11.28 | 11.2871 | 33348.0 |
| 2010-11-10 08:17:00 | AAPL | Stock | 11.2893 | 11.2939 | 11.2893 | 11.2929 | 49700.0 |
| 2010-11-10 08:18:00 | AAPL | Stock | 11.2943 | 11.3032 | 11.2943 | 11.3032 | 150528.0 |
> showing 50 of 993,390 rows — these rows as CSV