PREVIEW / stock_1min / 2010-11-29
file: by_date/stock_1min/2010/2010-11-29.parquet size: 12.8 MB rows: 971,096 symbols: 2,852
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-29 04:00:00 | AAPL | Stock | 11.2964 | 11.2964 | 11.2964 | 11.2964 | 5600.0 |
| 2010-11-29 04:01:00 | AAPL | Stock | 11.3036 | 11.3529 | 11.3036 | 11.3529 | 17360.0 |
| 2010-11-29 04:31:00 | AAPL | Stock | 11.3404 | 11.3404 | 11.3404 | 11.3404 | 2800.0 |
| 2010-11-29 04:37:00 | AAPL | Stock | 11.3214 | 11.3214 | 11.3214 | 11.3214 | 2800.0 |
| 2010-11-29 04:40:00 | AAPL | Stock | 11.3196 | 11.3196 | 11.3196 | 11.3196 | 5600.0 |
| 2010-11-29 04:41:00 | AAPL | Stock | 11.3125 | 11.3125 | 11.3125 | 11.3125 | 5600.0 |
| 2010-11-29 04:46:00 | AAPL | Stock | 11.3214 | 11.3214 | 11.3214 | 11.3214 | 2800.0 |
| 2010-11-29 04:52:00 | AAPL | Stock | 11.3304 | 11.3304 | 11.3304 | 11.3304 | 2800.0 |
| 2010-11-29 05:07:00 | AAPL | Stock | 11.31 | 11.31 | 11.31 | 11.31 | 2800.0 |
| 2010-11-29 05:08:00 | AAPL | Stock | 11.3036 | 11.3036 | 11.3036 | 11.3036 | 2800.0 |
| 2010-11-29 05:17:00 | AAPL | Stock | 11.3018 | 11.3018 | 11.3018 | 11.3018 | 2800.0 |
| 2010-11-29 05:32:00 | AAPL | Stock | 11.3082 | 11.3082 | 11.3082 | 11.3082 | 2800.0 |
| 2010-11-29 05:47:00 | AAPL | Stock | 11.2868 | 11.2868 | 11.2868 | 11.2868 | 2800.0 |
| 2010-11-29 05:54:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-11-29 05:56:00 | AAPL | Stock | 11.28 | 11.28 | 11.28 | 11.28 | 5600.0 |
| 2010-11-29 06:07:00 | AAPL | Stock | 11.28 | 11.28 | 11.2768 | 11.2768 | 5600.0 |
| 2010-11-29 06:08:00 | AAPL | Stock | 11.2839 | 11.2839 | 11.2839 | 11.2839 | 2800.0 |
| 2010-11-29 06:37:00 | AAPL | Stock | 11.2868 | 11.2868 | 11.2868 | 11.2868 | 14000.0 |
| 2010-11-29 06:38:00 | AAPL | Stock | 11.295 | 11.295 | 11.295 | 11.295 | 2800.0 |
| 2010-11-29 06:53:00 | AAPL | Stock | 11.2946 | 11.2946 | 11.2946 | 11.2946 | 5600.0 |
| 2010-11-29 06:56:00 | AAPL | Stock | 11.2964 | 11.2964 | 11.2964 | 11.2964 | 5600.0 |
| 2010-11-29 07:00:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-11-29 07:03:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 2800.0 |
| 2010-11-29 07:05:00 | AAPL | Stock | 11.2964 | 11.2964 | 11.2964 | 11.2964 | 2800.0 |
| 2010-11-29 07:07:00 | AAPL | Stock | 11.2964 | 11.3018 | 11.2957 | 11.2957 | 41440.0 |
| 2010-11-29 07:08:00 | AAPL | Stock | 11.2979 | 11.2979 | 11.2979 | 11.2979 | 8400.0 |
| 2010-11-29 07:10:00 | AAPL | Stock | 11.2907 | 11.2907 | 11.2907 | 11.2907 | 2800.0 |
| 2010-11-29 07:11:00 | AAPL | Stock | 11.2964 | 11.3018 | 11.2964 | 11.3018 | 73080.0 |
| 2010-11-29 07:12:00 | AAPL | Stock | 11.2964 | 11.2964 | 11.2964 | 11.2964 | 11200.0 |
| 2010-11-29 07:14:00 | AAPL | Stock | 11.2964 | 11.2964 | 11.2936 | 11.2936 | 16800.0 |
| 2010-11-29 07:17:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2839 | 11.2839 | 44800.0 |
| 2010-11-29 07:20:00 | AAPL | Stock | 11.2804 | 11.2804 | 11.2786 | 11.2786 | 19600.0 |
| 2010-11-29 07:22:00 | AAPL | Stock | 11.2825 | 11.2893 | 11.2825 | 11.2893 | 50400.0 |
| 2010-11-29 07:23:00 | AAPL | Stock | 11.2893 | 11.2939 | 11.2893 | 11.2929 | 114380.0 |
| 2010-11-29 07:24:00 | AAPL | Stock | 11.2893 | 11.2964 | 11.2857 | 11.2936 | 109200.0 |
| 2010-11-29 07:25:00 | AAPL | Stock | 11.2946 | 11.2946 | 11.2857 | 11.2857 | 117600.0 |
| 2010-11-29 07:26:00 | AAPL | Stock | 11.2893 | 11.2893 | 11.2732 | 11.2782 | 19600.0 |
| 2010-11-29 07:28:00 | AAPL | Stock | 11.2857 | 11.2875 | 11.2857 | 11.2875 | 11200.0 |
| 2010-11-29 07:30:00 | AAPL | Stock | 11.2857 | 11.2857 | 11.2857 | 11.2857 | 3360.0 |
| 2010-11-29 07:32:00 | AAPL | Stock | 11.2793 | 11.2793 | 11.2732 | 11.2732 | 16800.0 |
| 2010-11-29 07:33:00 | AAPL | Stock | 11.275 | 11.275 | 11.2732 | 11.2732 | 25200.0 |
| 2010-11-29 07:36:00 | AAPL | Stock | 11.2714 | 11.2714 | 11.2675 | 11.2675 | 30800.0 |
| 2010-11-29 07:37:00 | AAPL | Stock | 11.2582 | 11.2671 | 11.2582 | 11.2582 | 8400.0 |
| 2010-11-29 07:42:00 | AAPL | Stock | 11.2582 | 11.2582 | 11.2582 | 11.2582 | 2800.0 |
| 2010-11-29 07:47:00 | AAPL | Stock | 11.265 | 11.2686 | 11.2507 | 11.2507 | 11200.0 |
| 2010-11-29 07:50:00 | AAPL | Stock | 11.2686 | 11.2768 | 11.2686 | 11.2764 | 22400.0 |
| 2010-11-29 07:51:00 | AAPL | Stock | 11.2757 | 11.2829 | 11.2754 | 11.2829 | 54600.0 |
| 2010-11-29 07:52:00 | AAPL | Stock | 11.2829 | 11.2829 | 11.2775 | 11.2811 | 19600.0 |
| 2010-11-29 07:53:00 | AAPL | Stock | 11.2818 | 11.2821 | 11.2811 | 11.2811 | 30800.0 |
| 2010-11-29 07:55:00 | AAPL | Stock | 11.2786 | 11.2786 | 11.2786 | 11.2786 | 2800.0 |
> showing 50 of 971,096 rows — these rows as CSV