PREVIEW / stock_1min / 2010-11-11
file: by_date/stock_1min/2010/2010-11-11.parquet size: 12.8 MB rows: 965,993 symbols: 2,835
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-11 04:20:00 | AAPL | Stock | 11.25 | 11.25 | 11.25 | 11.25 | 2800.0 |
| 2010-11-11 04:28:00 | AAPL | Stock | 11.2607 | 11.2607 | 11.2607 | 11.2607 | 2800.0 |
| 2010-11-11 04:31:00 | AAPL | Stock | 11.2982 | 11.2982 | 11.2982 | 11.2982 | 2800.0 |
| 2010-11-11 05:27:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-11-11 05:35:00 | AAPL | Stock | 11.2893 | 11.2893 | 11.2893 | 11.2893 | 2800.0 |
| 2010-11-11 06:19:00 | AAPL | Stock | 11.2954 | 11.2954 | 11.2939 | 11.2939 | 5600.0 |
| 2010-11-11 06:20:00 | AAPL | Stock | 11.295 | 11.295 | 11.2911 | 11.2911 | 5600.0 |
| 2010-11-11 06:32:00 | AAPL | Stock | 11.2664 | 11.2664 | 11.2664 | 11.2664 | 2800.0 |
| 2010-11-11 06:39:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-11-11 07:01:00 | AAPL | Stock | 11.2782 | 11.2786 | 11.2782 | 11.2786 | 30800.0 |
| 2010-11-11 07:02:00 | AAPL | Stock | 11.2804 | 11.2814 | 11.2804 | 11.2814 | 5600.0 |
| 2010-11-11 07:03:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-11-11 07:08:00 | AAPL | Stock | 11.3179 | 11.3179 | 11.2929 | 11.2929 | 33600.0 |
| 2010-11-11 07:17:00 | AAPL | Stock | 11.2914 | 11.2914 | 11.2914 | 11.2914 | 2800.0 |
| 2010-11-11 07:21:00 | AAPL | Stock | 11.2857 | 11.2871 | 11.2857 | 11.2871 | 8400.0 |
| 2010-11-11 07:38:00 | AAPL | Stock | 11.2693 | 11.2693 | 11.2679 | 11.2679 | 16800.0 |
| 2010-11-11 07:41:00 | AAPL | Stock | 11.2668 | 11.2668 | 11.2668 | 11.2668 | 3388.0 |
| 2010-11-11 07:49:00 | AAPL | Stock | 11.27 | 11.27 | 11.2668 | 11.2679 | 36400.0 |
| 2010-11-11 07:50:00 | AAPL | Stock | 11.2636 | 11.2661 | 11.2636 | 11.2643 | 8400.0 |
| 2010-11-11 07:51:00 | AAPL | Stock | 11.2671 | 11.2671 | 11.26 | 11.26 | 11200.0 |
| 2010-11-11 07:52:00 | AAPL | Stock | 11.2589 | 11.2607 | 11.2589 | 11.2607 | 14000.0 |
| 2010-11-11 07:53:00 | AAPL | Stock | 11.2607 | 11.2679 | 11.2564 | 11.2564 | 29372.0 |
| 2010-11-11 07:54:00 | AAPL | Stock | 11.2554 | 11.2554 | 11.2554 | 11.2554 | 2800.0 |
| 2010-11-11 07:56:00 | AAPL | Stock | 11.2571 | 11.2571 | 11.2571 | 11.2571 | 7840.0 |
| 2010-11-11 08:00:00 | AAPL | Stock | 11.2607 | 11.2671 | 11.2571 | 11.2643 | 118524.0 |
| 2010-11-11 08:01:00 | AAPL | Stock | 11.2657 | 11.2661 | 11.2657 | 11.2661 | 11200.0 |
| 2010-11-11 08:02:00 | AAPL | Stock | 11.2593 | 11.2679 | 11.2593 | 11.2679 | 25200.0 |
| 2010-11-11 08:03:00 | AAPL | Stock | 11.2714 | 11.2807 | 11.2714 | 11.2807 | 8400.0 |
| 2010-11-11 08:04:00 | AAPL | Stock | 11.2739 | 11.2786 | 11.2686 | 11.2779 | 43960.0 |
| 2010-11-11 08:05:00 | AAPL | Stock | 11.2714 | 11.2714 | 11.2714 | 11.2714 | 11200.0 |
| 2010-11-11 08:06:00 | AAPL | Stock | 11.2768 | 11.2771 | 11.2768 | 11.2768 | 11200.0 |
| 2010-11-11 08:07:00 | AAPL | Stock | 11.2732 | 11.2732 | 11.2696 | 11.2696 | 8400.0 |
| 2010-11-11 08:10:00 | AAPL | Stock | 11.2754 | 11.2768 | 11.2746 | 11.2746 | 21560.0 |
| 2010-11-11 08:12:00 | AAPL | Stock | 11.2736 | 11.2736 | 11.2721 | 11.2721 | 8400.0 |
| 2010-11-11 08:13:00 | AAPL | Stock | 11.275 | 11.275 | 11.2714 | 11.2743 | 11200.0 |
| 2010-11-11 08:14:00 | AAPL | Stock | 11.2711 | 11.2768 | 11.2711 | 11.2768 | 48020.0 |
| 2010-11-11 08:15:00 | AAPL | Stock | 11.2814 | 11.2814 | 11.2814 | 11.2814 | 3360.0 |
| 2010-11-11 08:16:00 | AAPL | Stock | 11.2804 | 11.2857 | 11.2786 | 11.2857 | 73360.0 |
| 2010-11-11 08:17:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.285 | 11.2854 | 11200.0 |
| 2010-11-11 08:18:00 | AAPL | Stock | 11.2857 | 11.2907 | 11.2857 | 11.2861 | 23800.0 |
| 2010-11-11 08:19:00 | AAPL | Stock | 11.2882 | 11.2882 | 11.2882 | 11.2882 | 8400.0 |
| 2010-11-11 08:20:00 | AAPL | Stock | 11.2832 | 11.2832 | 11.2832 | 11.2832 | 3360.0 |
| 2010-11-11 08:21:00 | AAPL | Stock | 11.2907 | 11.2946 | 11.2818 | 11.2946 | 72100.0 |
| 2010-11-11 08:22:00 | AAPL | Stock | 11.2929 | 11.2946 | 11.2914 | 11.2914 | 64400.0 |
| 2010-11-11 08:23:00 | AAPL | Stock | 11.2936 | 11.2961 | 11.2829 | 11.2829 | 217980.0 |
| 2010-11-11 08:24:00 | AAPL | Stock | 11.2854 | 11.2857 | 11.2832 | 11.2857 | 44800.0 |
| 2010-11-11 08:25:00 | AAPL | Stock | 11.2857 | 11.2893 | 11.285 | 11.2871 | 65100.0 |
| 2010-11-11 08:26:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2789 | 11.2789 | 67200.0 |
| 2010-11-11 08:28:00 | AAPL | Stock | 11.2818 | 11.2836 | 11.2818 | 11.2818 | 16800.0 |
| 2010-11-11 08:29:00 | AAPL | Stock | 11.2804 | 11.2832 | 11.2804 | 11.2832 | 8960.0 |
> showing 50 of 965,993 rows — these rows as CSV