PREVIEW / stock_1min / 2001-09-17
file: by_date/stock_1min/2001/2001-09-17.parquet size: 3.8 MB rows: 294,439 symbols: 1,102
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 |
|---|---|---|---|---|---|---|---|
| 2001-09-17 08:19:00 | AAPL | Stock | 0.2768 | 0.2768 | 0.2768 | 0.2768 | 5600.0 |
| 2001-09-17 08:21:00 | AAPL | Stock | 0.2991 | 0.3036 | 0.2991 | 0.3018 | 100800.0 |
| 2001-09-17 08:22:00 | AAPL | Stock | 0.3036 | 0.3125 | 0.3036 | 0.3125 | 22400.0 |
| 2001-09-17 08:23:00 | AAPL | Stock | 0.3071 | 0.3071 | 0.3071 | 0.3071 | 28000.0 |
| 2001-09-17 08:24:00 | AAPL | Stock | 0.3045 | 0.3045 | 0.3045 | 0.3045 | 22400.0 |
| 2001-09-17 08:25:00 | AAPL | Stock | 0.2946 | 0.2946 | 0.2946 | 0.2946 | 5600.0 |
| 2001-09-17 08:26:00 | AAPL | Stock | 0.3036 | 0.3036 | 0.3036 | 0.3036 | 16800.0 |
| 2001-09-17 08:34:00 | AAPL | Stock | 0.2991 | 0.2991 | 0.2991 | 0.2991 | 16800.0 |
| 2001-09-17 08:40:00 | AAPL | Stock | 0.2991 | 0.3018 | 0.2991 | 0.3018 | 56000.0 |
| 2001-09-17 08:43:00 | AAPL | Stock | 0.3 | 0.3018 | 0.3 | 0.3018 | 134400.0 |
| 2001-09-17 08:44:00 | AAPL | Stock | 0.3009 | 0.3009 | 0.3009 | 0.3009 | 179200.0 |
| 2001-09-17 08:45:00 | AAPL | Stock | 0.2946 | 0.2946 | 0.2946 | 0.2946 | 28000.0 |
| 2001-09-17 08:50:00 | AAPL | Stock | 0.3 | 0.3 | 0.3 | 0.3 | 50400.0 |
| 2001-09-17 09:04:00 | AAPL | Stock | 0.2911 | 0.2911 | 0.2911 | 0.2911 | 56000.0 |
| 2001-09-17 09:05:00 | AAPL | Stock | 0.2868 | 0.2868 | 0.2857 | 0.2857 | 554400.0 |
| 2001-09-17 09:06:00 | AAPL | Stock | 0.2911 | 0.2929 | 0.2902 | 0.2929 | 386400.0 |
| 2001-09-17 09:07:00 | AAPL | Stock | 0.2911 | 0.2911 | 0.2911 | 0.2911 | 257600.0 |
| 2001-09-17 09:09:00 | AAPL | Stock | 0.2929 | 0.2929 | 0.2929 | 0.2929 | 28000.0 |
| 2001-09-17 09:11:00 | AAPL | Stock | 0.2929 | 0.2929 | 0.2929 | 0.2929 | 67200.0 |
| 2001-09-17 09:16:00 | AAPL | Stock | 0.2929 | 0.2929 | 0.2902 | 0.2902 | 11200.0 |
| 2001-09-17 09:18:00 | AAPL | Stock | 0.2902 | 0.2902 | 0.2902 | 0.2902 | 28000.0 |
| 2001-09-17 09:20:00 | AAPL | Stock | 0.2902 | 0.2902 | 0.2902 | 0.2902 | 145600.0 |
| 2001-09-17 09:21:00 | AAPL | Stock | 0.2902 | 0.2902 | 0.2886 | 0.2886 | 151200.0 |
| 2001-09-17 09:22:00 | AAPL | Stock | 0.2902 | 0.2902 | 0.2886 | 0.2902 | 112000.0 |
| 2001-09-17 09:23:00 | AAPL | Stock | 0.2902 | 0.2902 | 0.2875 | 0.2875 | 61600.0 |
| 2001-09-17 09:24:00 | AAPL | Stock | 0.2902 | 0.2902 | 0.2891 | 0.2891 | 123200.0 |
| 2001-09-17 09:25:00 | AAPL | Stock | 0.2891 | 0.2946 | 0.2873 | 0.2891 | 582400.0 |
| 2001-09-17 09:26:00 | AAPL | Stock | 0.2877 | 0.2877 | 0.2866 | 0.2866 | 173600.0 |
| 2001-09-17 09:27:00 | AAPL | Stock | 0.2866 | 0.2866 | 0.2863 | 0.2863 | 196000.0 |
| 2001-09-17 09:28:00 | AAPL | Stock | 0.2875 | 0.2875 | 0.2857 | 0.2863 | 235200.0 |
| 2001-09-17 09:29:00 | AAPL | Stock | 0.2859 | 0.2861 | 0.2859 | 0.2861 | 403200.0 |
| 2001-09-17 09:30:00 | AAPL | Stock | 0.2857 | 0.2859 | 0.2825 | 0.2857 | 4810400.0 |
| 2001-09-17 09:31:00 | AAPL | Stock | 0.2848 | 0.2857 | 0.2814 | 0.2814 | 1271200.0 |
| 2001-09-17 09:32:00 | AAPL | Stock | 0.2814 | 0.2846 | 0.2813 | 0.2813 | 1668800.0 |
| 2001-09-17 09:33:00 | AAPL | Stock | 0.2814 | 0.2848 | 0.2813 | 0.2821 | 2139200.0 |
| 2001-09-17 09:34:00 | AAPL | Stock | 0.2821 | 0.2846 | 0.2821 | 0.2836 | 509600.0 |
| 2001-09-17 09:35:00 | AAPL | Stock | 0.2834 | 0.2866 | 0.282 | 0.2866 | 2777600.0 |
| 2001-09-17 09:36:00 | AAPL | Stock | 0.2866 | 0.2898 | 0.2821 | 0.2884 | 4513600.0 |
| 2001-09-17 09:37:00 | AAPL | Stock | 0.29 | 0.29 | 0.282 | 0.2889 | 442400.0 |
| 2001-09-17 09:38:00 | AAPL | Stock | 0.2873 | 0.2893 | 0.2866 | 0.2866 | 980000.0 |
| 2001-09-17 09:39:00 | AAPL | Stock | 0.2866 | 0.2891 | 0.2866 | 0.288 | 957600.0 |
| 2001-09-17 09:40:00 | AAPL | Stock | 0.2879 | 0.2879 | 0.2857 | 0.2857 | 1321600.0 |
| 2001-09-17 09:41:00 | AAPL | Stock | 0.2857 | 0.2893 | 0.2813 | 0.2839 | 1579200.0 |
| 2001-09-17 09:42:00 | AAPL | Stock | 0.2834 | 0.2875 | 0.2832 | 0.287 | 744800.0 |
| 2001-09-17 09:43:00 | AAPL | Stock | 0.2839 | 0.2884 | 0.2838 | 0.2875 | 1982400.0 |
| 2001-09-17 09:44:00 | AAPL | Stock | 0.2875 | 0.2893 | 0.2846 | 0.2857 | 806400.0 |
| 2001-09-17 09:45:00 | AAPL | Stock | 0.2875 | 0.2877 | 0.2841 | 0.2873 | 1002400.0 |
| 2001-09-17 09:46:00 | AAPL | Stock | 0.2875 | 0.2877 | 0.2839 | 0.2873 | 1164800.0 |
| 2001-09-17 09:47:00 | AAPL | Stock | 0.2863 | 0.2875 | 0.2863 | 0.2866 | 610400.0 |
| 2001-09-17 09:48:00 | AAPL | Stock | 0.2873 | 0.2884 | 0.2857 | 0.2884 | 1685600.0 |
> showing 50 of 294,439 rows — these rows as CSV