PREVIEW / stock_1min / 2000-03-23
file: by_date/stock_1min/2000/2000-03-23.parquet size: 2.4 MB rows: 208,998 symbols: 929
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 |
|---|---|---|---|---|---|---|---|
| 2000-03-23 09:30:00 | AAPL | Stock | 1.2679 | 1.2684 | 1.2645 | 1.2679 | 2307200.0 |
| 2000-03-23 09:31:00 | AAPL | Stock | 1.2662 | 1.2679 | 1.2634 | 1.2679 | 2710400.0 |
| 2000-03-23 09:32:00 | AAPL | Stock | 1.264 | 1.2701 | 1.2628 | 1.264 | 2094400.0 |
| 2000-03-23 09:33:00 | AAPL | Stock | 1.2673 | 1.2712 | 1.264 | 1.2701 | 1064000.0 |
| 2000-03-23 09:34:00 | AAPL | Stock | 1.264 | 1.2704 | 1.264 | 1.2701 | 1064000.0 |
| 2000-03-23 09:35:00 | AAPL | Stock | 1.2679 | 1.2706 | 1.2623 | 1.2623 | 1232000.0 |
| 2000-03-23 09:36:00 | AAPL | Stock | 1.2628 | 1.2768 | 1.2623 | 1.2701 | 3774400.0 |
| 2000-03-23 09:37:00 | AAPL | Stock | 1.2737 | 1.2773 | 1.2701 | 1.2768 | 3718400.0 |
| 2000-03-23 09:38:00 | AAPL | Stock | 1.2768 | 1.2813 | 1.2679 | 1.2807 | 2856000.0 |
| 2000-03-23 09:39:00 | AAPL | Stock | 1.2807 | 1.2818 | 1.2762 | 1.2779 | 2004800.0 |
| 2000-03-23 09:40:00 | AAPL | Stock | 1.2799 | 1.2835 | 1.2799 | 1.2807 | 828800.0 |
| 2000-03-23 09:41:00 | AAPL | Stock | 1.2813 | 1.2824 | 1.2779 | 1.2813 | 2822400.0 |
| 2000-03-23 09:42:00 | AAPL | Stock | 1.2824 | 1.2857 | 1.2801 | 1.2857 | 1803200.0 |
| 2000-03-23 09:43:00 | AAPL | Stock | 1.2857 | 1.2885 | 1.2857 | 1.2879 | 2027200.0 |
| 2000-03-23 09:44:00 | AAPL | Stock | 1.2877 | 1.2902 | 1.2857 | 1.2902 | 3684800.0 |
| 2000-03-23 09:45:00 | AAPL | Stock | 1.2902 | 1.2902 | 1.2857 | 1.2874 | 3360000.0 |
| 2000-03-23 09:46:00 | AAPL | Stock | 1.2885 | 1.2891 | 1.279 | 1.2807 | 1948800.0 |
| 2000-03-23 09:47:00 | AAPL | Stock | 1.2801 | 1.2871 | 1.2796 | 1.2871 | 4401600.0 |
| 2000-03-23 09:48:00 | AAPL | Stock | 1.2863 | 1.2924 | 1.2857 | 1.2885 | 1164800.0 |
| 2000-03-23 09:49:00 | AAPL | Stock | 1.2902 | 1.2913 | 1.2879 | 1.291 | 705600.0 |
| 2000-03-23 09:50:00 | AAPL | Stock | 1.2913 | 1.2991 | 1.2902 | 1.2991 | 2587200.0 |
| 2000-03-23 09:51:00 | AAPL | Stock | 1.3002 | 1.3058 | 1.2946 | 1.3039 | 4737600.0 |
| 2000-03-23 09:52:00 | AAPL | Stock | 1.3047 | 1.308 | 1.2946 | 1.3075 | 3304000.0 |
| 2000-03-23 09:53:00 | AAPL | Stock | 1.3047 | 1.3069 | 1.3002 | 1.3002 | 1176000.0 |
| 2000-03-23 09:54:00 | AAPL | Stock | 1.3008 | 1.3025 | 1.3002 | 1.3013 | 1881600.0 |
| 2000-03-23 09:55:00 | AAPL | Stock | 1.3013 | 1.3013 | 1.2958 | 1.2963 | 1243200.0 |
| 2000-03-23 09:56:00 | AAPL | Stock | 1.2958 | 1.2958 | 1.2935 | 1.2941 | 3449600.0 |
| 2000-03-23 09:57:00 | AAPL | Stock | 1.2935 | 1.2958 | 1.2935 | 1.2958 | 2150400.0 |
| 2000-03-23 09:58:00 | AAPL | Stock | 1.2958 | 1.3036 | 1.2955 | 1.3022 | 2710400.0 |
| 2000-03-23 09:59:00 | AAPL | Stock | 1.3019 | 1.3036 | 1.2952 | 1.2952 | 1478400.0 |
| 2000-03-23 10:00:00 | AAPL | Stock | 1.2946 | 1.298 | 1.2935 | 1.2946 | 1747200.0 |
| 2000-03-23 10:01:00 | AAPL | Stock | 1.2946 | 1.2969 | 1.2935 | 1.2938 | 996800.0 |
| 2000-03-23 10:02:00 | AAPL | Stock | 1.2941 | 1.2969 | 1.2935 | 1.2963 | 660800.0 |
| 2000-03-23 10:03:00 | AAPL | Stock | 1.2958 | 1.2963 | 1.2935 | 1.2938 | 1321600.0 |
| 2000-03-23 10:04:00 | AAPL | Stock | 1.2935 | 1.2946 | 1.2935 | 1.2946 | 2217600.0 |
| 2000-03-23 10:05:00 | AAPL | Stock | 1.2924 | 1.2941 | 1.2924 | 1.293 | 795200.0 |
| 2000-03-23 10:06:00 | AAPL | Stock | 1.293 | 1.2969 | 1.2924 | 1.2969 | 694400.0 |
| 2000-03-23 10:07:00 | AAPL | Stock | 1.2969 | 1.303 | 1.2969 | 1.303 | 840000.0 |
| 2000-03-23 10:08:00 | AAPL | Stock | 1.3047 | 1.3047 | 1.2946 | 1.2952 | 1120000.0 |
| 2000-03-23 10:09:00 | AAPL | Stock | 1.2946 | 1.2983 | 1.2919 | 1.2958 | 15232000.0 |
| 2000-03-23 10:10:00 | AAPL | Stock | 1.2963 | 1.2969 | 1.2935 | 1.2935 | 1691200.0 |
| 2000-03-23 10:11:00 | AAPL | Stock | 1.2935 | 1.2946 | 1.2902 | 1.2924 | 1276800.0 |
| 2000-03-23 10:12:00 | AAPL | Stock | 1.2924 | 1.2946 | 1.2879 | 1.2879 | 3617600.0 |
| 2000-03-23 10:13:00 | AAPL | Stock | 1.2868 | 1.2879 | 1.2857 | 1.2857 | 3617600.0 |
| 2000-03-23 10:14:00 | AAPL | Stock | 1.2857 | 1.2885 | 1.2857 | 1.2868 | 2632000.0 |
| 2000-03-23 10:15:00 | AAPL | Stock | 1.2863 | 1.2902 | 1.2857 | 1.2868 | 4984000.0 |
| 2000-03-23 10:16:00 | AAPL | Stock | 1.2879 | 1.2913 | 1.2846 | 1.2902 | 7985600.0 |
| 2000-03-23 10:17:00 | AAPL | Stock | 1.2885 | 1.2913 | 1.2868 | 1.2868 | 828800.0 |
| 2000-03-23 10:18:00 | AAPL | Stock | 1.2874 | 1.2885 | 1.2868 | 1.2868 | 1052800.0 |
| 2000-03-23 10:19:00 | AAPL | Stock | 1.2874 | 1.2913 | 1.2868 | 1.2913 | 1052800.0 |
> showing 50 of 208,998 rows — these rows as CSV