PREVIEW / stock_1min / 2011-12-23
file: by_date/stock_1min/2011/2011-12-23.parquet size: 11.4 MB rows: 850,850 symbols: 2,895
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-23 04:08:00 | AAPL | Stock | 14.2657 | 14.2657 | 14.2657 | 14.2657 | 5600.0 |
| 2011-12-23 04:26:00 | AAPL | Stock | 14.2657 | 14.2657 | 14.2657 | 14.2657 | 3080.0 |
| 2011-12-23 04:58:00 | AAPL | Stock | 14.2411 | 14.2411 | 14.2411 | 14.2411 | 2800.0 |
| 2011-12-23 05:22:00 | AAPL | Stock | 14.25 | 14.25 | 14.25 | 14.25 | 2800.0 |
| 2011-12-23 05:28:00 | AAPL | Stock | 14.2457 | 14.2457 | 14.2457 | 14.2457 | 2800.0 |
| 2011-12-23 05:34:00 | AAPL | Stock | 14.2457 | 14.2457 | 14.2457 | 14.2457 | 5600.0 |
| 2011-12-23 07:06:00 | AAPL | Stock | 14.2614 | 14.2614 | 14.2614 | 14.2614 | 2800.0 |
| 2011-12-23 07:09:00 | AAPL | Stock | 14.2607 | 14.2607 | 14.2607 | 14.2607 | 3220.0 |
| 2011-12-23 07:11:00 | AAPL | Stock | 14.2639 | 14.2643 | 14.2639 | 14.2643 | 5600.0 |
| 2011-12-23 07:16:00 | AAPL | Stock | 14.2657 | 14.2675 | 14.2657 | 14.2675 | 41720.0 |
| 2011-12-23 07:17:00 | AAPL | Stock | 14.2675 | 14.2675 | 14.2675 | 14.2675 | 2800.0 |
| 2011-12-23 07:18:00 | AAPL | Stock | 14.2675 | 14.2675 | 14.2675 | 14.2675 | 5600.0 |
| 2011-12-23 07:21:00 | AAPL | Stock | 14.2675 | 14.2675 | 14.2675 | 14.2675 | 11480.0 |
| 2011-12-23 07:24:00 | AAPL | Stock | 14.2732 | 14.2732 | 14.2732 | 14.2732 | 8400.0 |
| 2011-12-23 07:25:00 | AAPL | Stock | 14.2754 | 14.2754 | 14.275 | 14.275 | 14000.0 |
| 2011-12-23 07:26:00 | AAPL | Stock | 14.2729 | 14.2754 | 14.2714 | 14.2754 | 9800.0 |
| 2011-12-23 07:27:00 | AAPL | Stock | 14.2714 | 14.2889 | 14.2714 | 14.2889 | 89460.0 |
| 2011-12-23 07:28:00 | AAPL | Stock | 14.2832 | 14.2832 | 14.2832 | 14.2832 | 5600.0 |
| 2011-12-23 07:29:00 | AAPL | Stock | 14.2843 | 14.2886 | 14.2804 | 14.2804 | 124208.0 |
| 2011-12-23 07:31:00 | AAPL | Stock | 14.2768 | 14.2768 | 14.2768 | 14.2768 | 3360.0 |
| 2011-12-23 07:34:00 | AAPL | Stock | 14.2786 | 14.2786 | 14.2786 | 14.2786 | 2800.0 |
| 2011-12-23 07:38:00 | AAPL | Stock | 14.2768 | 14.2768 | 14.275 | 14.275 | 5600.0 |
| 2011-12-23 07:39:00 | AAPL | Stock | 14.275 | 14.275 | 14.275 | 14.275 | 19152.0 |
| 2011-12-23 07:41:00 | AAPL | Stock | 14.2714 | 14.275 | 14.2714 | 14.275 | 27440.0 |
| 2011-12-23 07:48:00 | AAPL | Stock | 14.2818 | 14.2818 | 14.2818 | 14.2818 | 2800.0 |
| 2011-12-23 07:49:00 | AAPL | Stock | 14.2814 | 14.2818 | 14.2814 | 14.2818 | 28000.0 |
| 2011-12-23 07:52:00 | AAPL | Stock | 14.2818 | 14.2846 | 14.2818 | 14.2846 | 27720.0 |
| 2011-12-23 07:54:00 | AAPL | Stock | 14.2846 | 14.2846 | 14.2846 | 14.2846 | 5600.0 |
| 2011-12-23 07:55:00 | AAPL | Stock | 14.2854 | 14.2854 | 14.2854 | 14.2854 | 2800.0 |
| 2011-12-23 07:56:00 | AAPL | Stock | 14.285 | 14.285 | 14.285 | 14.285 | 2800.0 |
| 2011-12-23 07:58:00 | AAPL | Stock | 14.2854 | 14.2854 | 14.2854 | 14.2854 | 2800.0 |
| 2011-12-23 08:00:00 | AAPL | Stock | 14.2736 | 14.2786 | 14.2736 | 14.2736 | 55580.0 |
| 2011-12-23 08:01:00 | AAPL | Stock | 14.28 | 14.2807 | 14.28 | 14.2807 | 54460.0 |
| 2011-12-23 08:02:00 | AAPL | Stock | 14.2804 | 14.2854 | 14.2804 | 14.2854 | 205660.0 |
| 2011-12-23 08:03:00 | AAPL | Stock | 14.2854 | 14.2889 | 14.2854 | 14.2889 | 156576.0 |
| 2011-12-23 08:04:00 | AAPL | Stock | 14.2893 | 14.2904 | 14.2857 | 14.2857 | 61600.0 |
| 2011-12-23 08:05:00 | AAPL | Stock | 14.2861 | 14.2896 | 14.2861 | 14.2875 | 36400.0 |
| 2011-12-23 08:06:00 | AAPL | Stock | 14.2879 | 14.2879 | 14.285 | 14.285 | 116760.0 |
| 2011-12-23 08:07:00 | AAPL | Stock | 14.2857 | 14.2896 | 14.2857 | 14.2864 | 57400.0 |
| 2011-12-23 08:08:00 | AAPL | Stock | 14.2864 | 14.2868 | 14.2857 | 14.2868 | 12572.0 |
| 2011-12-23 08:09:00 | AAPL | Stock | 14.2857 | 14.2871 | 14.2857 | 14.2871 | 15400.0 |
| 2011-12-23 08:10:00 | AAPL | Stock | 14.2871 | 14.2875 | 14.2871 | 14.2871 | 14000.0 |
| 2011-12-23 08:11:00 | AAPL | Stock | 14.2875 | 14.2904 | 14.2875 | 14.2896 | 47600.0 |
| 2011-12-23 08:12:00 | AAPL | Stock | 14.2896 | 14.2929 | 14.2896 | 14.2929 | 111720.0 |
| 2011-12-23 08:13:00 | AAPL | Stock | 14.2904 | 14.2939 | 14.2904 | 14.2929 | 44660.0 |
| 2011-12-23 08:14:00 | AAPL | Stock | 14.2957 | 14.3004 | 14.2957 | 14.2964 | 106568.0 |
| 2011-12-23 08:16:00 | AAPL | Stock | 14.2993 | 14.3004 | 14.2968 | 14.2968 | 88312.0 |
| 2011-12-23 08:17:00 | AAPL | Stock | 14.2936 | 14.2982 | 14.2936 | 14.2982 | 12600.0 |
| 2011-12-23 08:18:00 | AAPL | Stock | 14.2996 | 14.3 | 14.2968 | 14.2971 | 78400.0 |
| 2011-12-23 08:19:00 | AAPL | Stock | 14.2964 | 14.2982 | 14.2964 | 14.2982 | 66500.0 |
> showing 50 of 850,850 rows — these rows as CSV