PREVIEW / stock_1min / 2008-04-15
file: by_date/stock_1min/2008/2008-04-15.parquet size: 11.7 MB rows: 957,055 symbols: 2,684
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-15 05:29:00 | AAPL | Stock | 5.2675 | 5.2675 | 5.2661 | 5.2661 | 10948.0 |
| 2008-04-15 06:10:00 | AAPL | Stock | 5.2693 | 5.2714 | 5.2693 | 5.2714 | 5600.0 |
| 2008-04-15 06:50:00 | AAPL | Stock | 5.2575 | 5.2575 | 5.2575 | 5.2575 | 11200.0 |
| 2008-04-15 06:53:00 | AAPL | Stock | 5.2575 | 5.2575 | 5.2571 | 5.2571 | 16800.0 |
| 2008-04-15 06:54:00 | AAPL | Stock | 5.2571 | 5.2571 | 5.2546 | 5.2546 | 19600.0 |
| 2008-04-15 07:06:00 | AAPL | Stock | 5.2671 | 5.2671 | 5.2671 | 5.2671 | 14000.0 |
| 2008-04-15 07:20:00 | AAPL | Stock | 5.2679 | 5.2679 | 5.2679 | 5.2679 | 2800.0 |
| 2008-04-15 07:26:00 | AAPL | Stock | 5.2611 | 5.2611 | 5.2607 | 5.2607 | 13636.0 |
| 2008-04-15 07:28:00 | AAPL | Stock | 5.2614 | 5.2614 | 5.2614 | 5.2614 | 2800.0 |
| 2008-04-15 07:36:00 | AAPL | Stock | 5.2675 | 5.2679 | 5.2675 | 5.2679 | 16800.0 |
| 2008-04-15 07:37:00 | AAPL | Stock | 5.2679 | 5.2679 | 5.2679 | 5.2679 | 44800.0 |
| 2008-04-15 07:38:00 | AAPL | Stock | 5.2679 | 5.2679 | 5.2679 | 5.2679 | 9520.0 |
| 2008-04-15 07:46:00 | AAPL | Stock | 5.2686 | 5.2686 | 5.2671 | 5.2671 | 19600.0 |
| 2008-04-15 07:50:00 | AAPL | Stock | 5.2696 | 5.2704 | 5.2696 | 5.2704 | 14000.0 |
| 2008-04-15 07:53:00 | AAPL | Stock | 5.2704 | 5.2704 | 5.2704 | 5.2704 | 11200.0 |
| 2008-04-15 07:54:00 | AAPL | Stock | 5.2754 | 5.2754 | 5.2754 | 5.2754 | 9800.0 |
| 2008-04-15 07:57:00 | AAPL | Stock | 5.2771 | 5.2771 | 5.2771 | 5.2771 | 22400.0 |
| 2008-04-15 08:00:00 | AAPL | Stock | 5.2771 | 5.2914 | 5.2771 | 5.2907 | 35560.0 |
| 2008-04-15 08:01:00 | AAPL | Stock | 5.2857 | 5.2857 | 5.2804 | 5.2804 | 5600.0 |
| 2008-04-15 08:02:00 | AAPL | Stock | 5.2807 | 5.2836 | 5.2807 | 5.2836 | 117880.0 |
| 2008-04-15 08:04:00 | AAPL | Stock | 5.2811 | 5.2939 | 5.2811 | 5.2939 | 30800.0 |
| 2008-04-15 08:05:00 | AAPL | Stock | 5.2825 | 5.2875 | 5.2814 | 5.2857 | 25200.0 |
| 2008-04-15 08:06:00 | AAPL | Stock | 5.2857 | 5.2857 | 5.2846 | 5.2857 | 22400.0 |
| 2008-04-15 08:07:00 | AAPL | Stock | 5.2818 | 5.2818 | 5.2818 | 5.2818 | 11200.0 |
| 2008-04-15 08:08:00 | AAPL | Stock | 5.2839 | 5.2857 | 5.2839 | 5.2857 | 120400.0 |
| 2008-04-15 08:10:00 | AAPL | Stock | 5.2839 | 5.2857 | 5.2829 | 5.2857 | 64400.0 |
| 2008-04-15 08:11:00 | AAPL | Stock | 5.2829 | 5.2832 | 5.2829 | 5.2832 | 11200.0 |
| 2008-04-15 08:12:00 | AAPL | Stock | 5.2843 | 5.2843 | 5.2825 | 5.2825 | 14364.0 |
| 2008-04-15 08:13:00 | AAPL | Stock | 5.2825 | 5.2843 | 5.2814 | 5.2814 | 66220.0 |
| 2008-04-15 08:14:00 | AAPL | Stock | 5.2814 | 5.2814 | 5.2814 | 5.2814 | 28000.0 |
| 2008-04-15 08:15:00 | AAPL | Stock | 5.2814 | 5.2814 | 5.2793 | 5.2793 | 17920.0 |
| 2008-04-15 08:16:00 | AAPL | Stock | 5.2804 | 5.2804 | 5.2786 | 5.2786 | 11200.0 |
| 2008-04-15 08:17:00 | AAPL | Stock | 5.2804 | 5.2857 | 5.2804 | 5.2857 | 43652.0 |
| 2008-04-15 08:18:00 | AAPL | Stock | 5.2921 | 5.2921 | 5.2893 | 5.2921 | 40404.0 |
| 2008-04-15 08:19:00 | AAPL | Stock | 5.2904 | 5.2904 | 5.2893 | 5.2893 | 19600.0 |
| 2008-04-15 08:20:00 | AAPL | Stock | 5.2932 | 5.2946 | 5.2893 | 5.2946 | 59584.0 |
| 2008-04-15 08:21:00 | AAPL | Stock | 5.2943 | 5.2946 | 5.2943 | 5.2946 | 28000.0 |
| 2008-04-15 08:22:00 | AAPL | Stock | 5.2929 | 5.2946 | 5.2929 | 5.2946 | 26320.0 |
| 2008-04-15 08:23:00 | AAPL | Stock | 5.2929 | 5.2946 | 5.2929 | 5.2946 | 44800.0 |
| 2008-04-15 08:25:00 | AAPL | Stock | 5.2918 | 5.2946 | 5.2918 | 5.2946 | 5600.0 |
| 2008-04-15 08:26:00 | AAPL | Stock | 5.2946 | 5.2946 | 5.2946 | 5.2946 | 2800.0 |
| 2008-04-15 08:28:00 | AAPL | Stock | 5.2936 | 5.2943 | 5.2914 | 5.2943 | 31192.0 |
| 2008-04-15 08:29:00 | AAPL | Stock | 5.2921 | 5.2932 | 5.2921 | 5.2925 | 17220.0 |
| 2008-04-15 08:30:00 | AAPL | Stock | 5.2929 | 5.2929 | 5.2757 | 5.2889 | 258216.0 |
| 2008-04-15 08:31:00 | AAPL | Stock | 5.2889 | 5.3 | 5.2886 | 5.3 | 102200.0 |
| 2008-04-15 08:32:00 | AAPL | Stock | 5.2982 | 5.3079 | 5.2982 | 5.3075 | 125496.0 |
| 2008-04-15 08:33:00 | AAPL | Stock | 5.3096 | 5.3232 | 5.3096 | 5.3214 | 191240.0 |
| 2008-04-15 08:34:00 | AAPL | Stock | 5.3214 | 5.33 | 5.3207 | 5.325 | 391020.0 |
| 2008-04-15 08:35:00 | AAPL | Stock | 5.3232 | 5.325 | 5.3214 | 5.3246 | 246120.0 |
| 2008-04-15 08:36:00 | AAPL | Stock | 5.3254 | 5.3254 | 5.3232 | 5.325 | 43176.0 |
> showing 50 of 957,055 rows — these rows as CSV