PREVIEW / stock_1min / 2009-11-19
file: by_date/stock_1min/2009/2009-11-19.parquet size: 12.6 MB rows: 956,552 symbols: 2,765
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-19 05:31:00 | AAPL | Stock | 7.3232 | 7.3232 | 7.3232 | 7.3232 | 13888.0 |
| 2009-11-19 06:41:00 | AAPL | Stock | 7.3171 | 7.3171 | 7.3171 | 7.3171 | 2800.0 |
| 2009-11-19 06:44:00 | AAPL | Stock | 7.3171 | 7.3171 | 7.3171 | 7.3171 | 4200.0 |
| 2009-11-19 06:47:00 | AAPL | Stock | 7.3089 | 7.3089 | 7.3089 | 7.3089 | 20468.0 |
| 2009-11-19 07:04:00 | AAPL | Stock | 7.3089 | 7.3089 | 7.3089 | 7.3089 | 4200.0 |
| 2009-11-19 07:07:00 | AAPL | Stock | 7.3036 | 7.3036 | 7.2975 | 7.2975 | 7000.0 |
| 2009-11-19 07:17:00 | AAPL | Stock | 7.3011 | 7.3011 | 7.3011 | 7.3011 | 5600.0 |
| 2009-11-19 07:20:00 | AAPL | Stock | 7.2968 | 7.2968 | 7.2968 | 7.2968 | 5600.0 |
| 2009-11-19 07:21:00 | AAPL | Stock | 7.2925 | 7.2925 | 7.2925 | 7.2925 | 4788.0 |
| 2009-11-19 07:23:00 | AAPL | Stock | 7.2896 | 7.2896 | 7.2896 | 7.2896 | 7000.0 |
| 2009-11-19 07:29:00 | AAPL | Stock | 7.2879 | 7.2879 | 7.2857 | 7.2857 | 81200.0 |
| 2009-11-19 07:30:00 | AAPL | Stock | 7.2893 | 7.2893 | 7.2893 | 7.2893 | 2800.0 |
| 2009-11-19 07:31:00 | AAPL | Stock | 7.2954 | 7.2954 | 7.2954 | 7.2954 | 5600.0 |
| 2009-11-19 07:35:00 | AAPL | Stock | 7.2786 | 7.2836 | 7.2786 | 7.2836 | 36400.0 |
| 2009-11-19 07:39:00 | AAPL | Stock | 7.2736 | 7.2736 | 7.2714 | 7.2714 | 30800.0 |
| 2009-11-19 07:41:00 | AAPL | Stock | 7.2714 | 7.2857 | 7.2714 | 7.2857 | 76860.0 |
| 2009-11-19 07:47:00 | AAPL | Stock | 7.2854 | 7.2857 | 7.2854 | 7.2857 | 5600.0 |
| 2009-11-19 07:49:00 | AAPL | Stock | 7.2854 | 7.2875 | 7.2854 | 7.2875 | 36400.0 |
| 2009-11-19 07:50:00 | AAPL | Stock | 7.2871 | 7.2871 | 7.2871 | 7.2871 | 5600.0 |
| 2009-11-19 07:53:00 | AAPL | Stock | 7.2875 | 7.2875 | 7.2875 | 7.2875 | 8400.0 |
| 2009-11-19 07:54:00 | AAPL | Stock | 7.2875 | 7.2875 | 7.2875 | 7.2875 | 8736.0 |
| 2009-11-19 07:55:00 | AAPL | Stock | 7.2871 | 7.2932 | 7.2871 | 7.2932 | 30800.0 |
| 2009-11-19 07:56:00 | AAPL | Stock | 7.2882 | 7.2882 | 7.2843 | 7.2843 | 61796.0 |
| 2009-11-19 07:58:00 | AAPL | Stock | 7.2854 | 7.2854 | 7.2854 | 7.2854 | 8652.0 |
| 2009-11-19 07:59:00 | AAPL | Stock | 7.285 | 7.2854 | 7.285 | 7.285 | 11200.0 |
| 2009-11-19 08:00:00 | AAPL | Stock | 7.285 | 7.2946 | 7.2719 | 7.2857 | 169092.0 |
| 2009-11-19 08:01:00 | AAPL | Stock | 7.2857 | 7.2857 | 7.2857 | 7.2857 | 25032.0 |
| 2009-11-19 08:02:00 | AAPL | Stock | 7.2918 | 7.2929 | 7.2864 | 7.2929 | 19600.0 |
| 2009-11-19 08:03:00 | AAPL | Stock | 7.2929 | 7.2929 | 7.2864 | 7.2929 | 28840.0 |
| 2009-11-19 08:05:00 | AAPL | Stock | 7.2943 | 7.2943 | 7.2929 | 7.2929 | 30800.0 |
| 2009-11-19 08:06:00 | AAPL | Stock | 7.2889 | 7.2911 | 7.2875 | 7.2893 | 44408.0 |
| 2009-11-19 08:07:00 | AAPL | Stock | 7.2875 | 7.2875 | 7.2857 | 7.2864 | 81928.0 |
| 2009-11-19 08:08:00 | AAPL | Stock | 7.2864 | 7.2936 | 7.2857 | 7.2936 | 26992.0 |
| 2009-11-19 08:09:00 | AAPL | Stock | 7.2907 | 7.2936 | 7.2907 | 7.2936 | 58996.0 |
| 2009-11-19 08:10:00 | AAPL | Stock | 7.2936 | 7.2936 | 7.2936 | 7.2936 | 3640.0 |
| 2009-11-19 08:11:00 | AAPL | Stock | 7.2871 | 7.2871 | 7.2857 | 7.2857 | 18508.0 |
| 2009-11-19 08:12:00 | AAPL | Stock | 7.2875 | 7.2875 | 7.2875 | 7.2875 | 3640.0 |
| 2009-11-19 08:13:00 | AAPL | Stock | 7.2911 | 7.2911 | 7.2864 | 7.2875 | 8400.0 |
| 2009-11-19 08:14:00 | AAPL | Stock | 7.2893 | 7.2893 | 7.2893 | 7.2893 | 16660.0 |
| 2009-11-19 08:16:00 | AAPL | Stock | 7.2877 | 7.2879 | 7.2875 | 7.2879 | 19600.0 |
| 2009-11-19 08:17:00 | AAPL | Stock | 7.2911 | 7.2925 | 7.2911 | 7.2911 | 12600.0 |
| 2009-11-19 08:19:00 | AAPL | Stock | 7.2929 | 7.2964 | 7.2929 | 7.2964 | 159712.0 |
| 2009-11-19 08:20:00 | AAPL | Stock | 7.2964 | 7.2979 | 7.2964 | 7.2979 | 8400.0 |
| 2009-11-19 08:21:00 | AAPL | Stock | 7.2975 | 7.2975 | 7.2929 | 7.2929 | 70560.0 |
| 2009-11-19 08:24:00 | AAPL | Stock | 7.2964 | 7.2964 | 7.2964 | 7.2964 | 8400.0 |
| 2009-11-19 08:25:00 | AAPL | Stock | 7.2961 | 7.2964 | 7.2961 | 7.2964 | 23912.0 |
| 2009-11-19 08:26:00 | AAPL | Stock | 7.2964 | 7.2964 | 7.2964 | 7.2964 | 3584.0 |
| 2009-11-19 08:28:00 | AAPL | Stock | 7.2936 | 7.2936 | 7.2936 | 7.2936 | 2800.0 |
| 2009-11-19 08:29:00 | AAPL | Stock | 7.2946 | 7.2982 | 7.2946 | 7.2982 | 5600.0 |
| 2009-11-19 08:30:00 | AAPL | Stock | 7.2946 | 7.2982 | 7.2932 | 7.2932 | 53200.0 |
> showing 50 of 956,552 rows — these rows as CSV