PREVIEW / stock_5min / 2000-03-23
file: by_date/stock_5min/2000/2000-03-23.parquet size: 1.2 MB rows: 88,494 symbols: 1,148
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.2712 | 1.2628 | 1.2701 | 9240000.0 |
| 2000-03-23 09:35:00 | AAPL | Stock | 1.2679 | 1.2818 | 1.2623 | 1.2779 | 13585600.0 |
| 2000-03-23 09:40:00 | AAPL | Stock | 1.2799 | 1.2902 | 1.2779 | 1.2902 | 11166400.0 |
| 2000-03-23 09:45:00 | AAPL | Stock | 1.2902 | 1.2924 | 1.279 | 1.291 | 11580800.0 |
| 2000-03-23 09:50:00 | AAPL | Stock | 1.2913 | 1.308 | 1.2902 | 1.3013 | 13686400.0 |
| 2000-03-23 09:55:00 | AAPL | Stock | 1.3013 | 1.3036 | 1.2935 | 1.2952 | 11032000.0 |
| 2000-03-23 10:00:00 | AAPL | Stock | 1.2946 | 1.298 | 1.2935 | 1.2946 | 6944000.0 |
| 2000-03-23 10:05:00 | AAPL | Stock | 1.2924 | 1.3047 | 1.2919 | 1.2958 | 18681600.0 |
| 2000-03-23 10:10:00 | AAPL | Stock | 1.2963 | 1.2969 | 1.2857 | 1.2868 | 12835200.0 |
| 2000-03-23 10:15:00 | AAPL | Stock | 1.2863 | 1.2913 | 1.2846 | 1.2913 | 15904000.0 |
| 2000-03-23 10:20:00 | AAPL | Stock | 1.2913 | 1.3019 | 1.2868 | 1.2935 | 7056000.0 |
| 2000-03-23 10:25:00 | AAPL | Stock | 1.2924 | 1.2924 | 1.2874 | 1.2896 | 6350400.0 |
| 2000-03-23 10:30:00 | AAPL | Stock | 1.2874 | 1.2885 | 1.2801 | 1.2885 | 6932800.0 |
| 2000-03-23 10:35:00 | AAPL | Stock | 1.2885 | 1.2896 | 1.2868 | 1.2868 | 2721600.0 |
| 2000-03-23 10:40:00 | AAPL | Stock | 1.2874 | 1.2902 | 1.2868 | 1.2902 | 2139200.0 |
| 2000-03-23 10:45:00 | AAPL | Stock | 1.2885 | 1.2924 | 1.2868 | 1.2921 | 3248000.0 |
| 2000-03-23 10:50:00 | AAPL | Stock | 1.2924 | 1.2946 | 1.2863 | 1.2891 | 1915200.0 |
| 2000-03-23 10:55:00 | AAPL | Stock | 1.2888 | 1.2888 | 1.2801 | 1.2801 | 5902400.0 |
| 2000-03-23 11:00:00 | AAPL | Stock | 1.2813 | 1.2818 | 1.2746 | 1.2757 | 10830400.0 |
| 2000-03-23 11:05:00 | AAPL | Stock | 1.2768 | 1.2779 | 1.2734 | 1.2746 | 3998400.0 |
| 2000-03-23 11:10:00 | AAPL | Stock | 1.2746 | 1.2768 | 1.2684 | 1.272 | 9531200.0 |
| 2000-03-23 11:15:00 | AAPL | Stock | 1.272 | 1.279 | 1.272 | 1.2779 | 2228800.0 |
| 2000-03-23 11:20:00 | AAPL | Stock | 1.2779 | 1.2857 | 1.2779 | 1.2852 | 4088000.0 |
| 2000-03-23 11:25:00 | AAPL | Stock | 1.2857 | 1.2896 | 1.2852 | 1.2896 | 5700800.0 |
| 2000-03-23 11:30:00 | AAPL | Stock | 1.2885 | 1.2969 | 1.2879 | 1.2879 | 8176000.0 |
| 2000-03-23 11:35:00 | AAPL | Stock | 1.2879 | 1.2891 | 1.2868 | 1.2885 | 2206400.0 |
| 2000-03-23 11:40:00 | AAPL | Stock | 1.2879 | 1.2946 | 1.2874 | 1.2913 | 3875200.0 |
| 2000-03-23 11:45:00 | AAPL | Stock | 1.2907 | 1.2924 | 1.2863 | 1.2868 | 4233600.0 |
| 2000-03-23 11:50:00 | AAPL | Stock | 1.2877 | 1.2907 | 1.2877 | 1.2902 | 1736000.0 |
| 2000-03-23 11:55:00 | AAPL | Stock | 1.2902 | 1.2941 | 1.2874 | 1.2941 | 4323200.0 |
| 2000-03-23 12:00:00 | AAPL | Stock | 1.2941 | 1.2941 | 1.2902 | 1.2907 | 2777600.0 |
| 2000-03-23 12:05:00 | AAPL | Stock | 1.2902 | 1.2907 | 1.2863 | 1.2896 | 5040000.0 |
| 2000-03-23 12:10:00 | AAPL | Stock | 1.2907 | 1.2935 | 1.2896 | 1.2935 | 2464000.0 |
| 2000-03-23 12:15:00 | AAPL | Stock | 1.2907 | 1.2907 | 1.2863 | 1.2874 | 5880000.0 |
| 2000-03-23 12:20:00 | AAPL | Stock | 1.2868 | 1.2874 | 1.2846 | 1.2846 | 2956800.0 |
| 2000-03-23 12:25:00 | AAPL | Stock | 1.2846 | 1.2852 | 1.2835 | 1.2846 | 2284800.0 |
| 2000-03-23 12:30:00 | AAPL | Stock | 1.2846 | 1.2857 | 1.2801 | 1.2807 | 17136000.0 |
| 2000-03-23 12:35:00 | AAPL | Stock | 1.2801 | 1.2846 | 1.2801 | 1.2846 | 3113600.0 |
| 2000-03-23 12:40:00 | AAPL | Stock | 1.284 | 1.2868 | 1.2835 | 1.2846 | 7560000.0 |
| 2000-03-23 12:45:00 | AAPL | Stock | 1.2846 | 1.2891 | 1.2846 | 1.2891 | 3718400.0 |
| 2000-03-23 12:50:00 | AAPL | Stock | 1.2874 | 1.2885 | 1.2857 | 1.286 | 2363200.0 |
| 2000-03-23 12:55:00 | AAPL | Stock | 1.2863 | 1.2896 | 1.2863 | 1.2863 | 1097600.0 |
| 2000-03-23 13:00:00 | AAPL | Stock | 1.2874 | 1.2896 | 1.2868 | 1.2885 | 3158400.0 |
| 2000-03-23 13:05:00 | AAPL | Stock | 1.2885 | 1.2941 | 1.2879 | 1.2941 | 6496000.0 |
| 2000-03-23 13:10:00 | AAPL | Stock | 1.2941 | 1.2946 | 1.2913 | 1.2919 | 1355200.0 |
| 2000-03-23 13:15:00 | AAPL | Stock | 1.2913 | 1.2919 | 1.2913 | 1.2919 | 1209600.0 |
| 2000-03-23 13:20:00 | AAPL | Stock | 1.2919 | 1.2946 | 1.2913 | 1.293 | 3292800.0 |
| 2000-03-23 13:25:00 | AAPL | Stock | 1.2913 | 1.2935 | 1.2896 | 1.2902 | 4256000.0 |
| 2000-03-23 13:30:00 | AAPL | Stock | 1.2913 | 1.2919 | 1.2902 | 1.2902 | 1265600.0 |
| 2000-03-23 13:35:00 | AAPL | Stock | 1.2902 | 1.293 | 1.2902 | 1.291 | 1590400.0 |
> showing 50 of 88,494 rows — these rows as CSV