PREVIEW / stock_1min / 2011-10-20
file: by_date/stock_1min/2011/2011-10-20.parquet size: 12.8 MB rows: 961,899 symbols: 2,817
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-10-20 04:17:00 | AAPL | Stock | 14.2586 | 14.2586 | 14.2586 | 14.2586 | 5600.0 |
| 2011-10-20 04:19:00 | AAPL | Stock | 14.25 | 14.25 | 14.25 | 14.25 | 8400.0 |
| 2011-10-20 04:20:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2679 | 14.2679 | 5600.0 |
| 2011-10-20 04:30:00 | AAPL | Stock | 14.3093 | 14.3093 | 14.3093 | 14.3093 | 2800.0 |
| 2011-10-20 04:35:00 | AAPL | Stock | 14.3193 | 14.3214 | 14.3193 | 14.3214 | 8400.0 |
| 2011-10-20 04:37:00 | AAPL | Stock | 14.3246 | 14.3246 | 14.3246 | 14.3246 | 22400.0 |
| 2011-10-20 04:38:00 | AAPL | Stock | 14.3307 | 14.3307 | 14.3307 | 14.3307 | 2800.0 |
| 2011-10-20 05:30:00 | AAPL | Stock | 14.3561 | 14.3561 | 14.3561 | 14.3561 | 30800.0 |
| 2011-10-20 05:31:00 | AAPL | Stock | 14.3561 | 14.3561 | 14.3561 | 14.3561 | 36400.0 |
| 2011-10-20 05:33:00 | AAPL | Stock | 14.3561 | 14.3561 | 14.3561 | 14.3561 | 5600.0 |
| 2011-10-20 05:39:00 | AAPL | Stock | 14.3561 | 14.3561 | 14.3457 | 14.3457 | 28000.0 |
| 2011-10-20 05:41:00 | AAPL | Stock | 14.3457 | 14.3457 | 14.3457 | 14.3457 | 2800.0 |
| 2011-10-20 05:45:00 | AAPL | Stock | 14.3432 | 14.3432 | 14.3432 | 14.3432 | 2800.0 |
| 2011-10-20 05:46:00 | AAPL | Stock | 14.3482 | 14.3482 | 14.3482 | 14.3482 | 2800.0 |
| 2011-10-20 05:48:00 | AAPL | Stock | 14.3246 | 14.3246 | 14.3246 | 14.3246 | 2800.0 |
| 2011-10-20 05:50:00 | AAPL | Stock | 14.3521 | 14.3521 | 14.3521 | 14.3521 | 2800.0 |
| 2011-10-20 05:52:00 | AAPL | Stock | 14.3307 | 14.3307 | 14.3307 | 14.3307 | 2800.0 |
| 2011-10-20 05:53:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 5600.0 |
| 2011-10-20 05:55:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 2800.0 |
| 2011-10-20 05:59:00 | AAPL | Stock | 14.3143 | 14.3143 | 14.3143 | 14.3143 | 14000.0 |
| 2011-10-20 06:01:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 2800.0 |
| 2011-10-20 06:02:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 5600.0 |
| 2011-10-20 06:05:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 2800.0 |
| 2011-10-20 06:06:00 | AAPL | Stock | 14.3143 | 14.3179 | 14.3143 | 14.3179 | 5600.0 |
| 2011-10-20 06:07:00 | AAPL | Stock | 14.3179 | 14.3179 | 14.3179 | 14.3179 | 2800.0 |
| 2011-10-20 06:08:00 | AAPL | Stock | 14.3179 | 14.3179 | 14.3179 | 14.3179 | 2800.0 |
| 2011-10-20 06:58:00 | AAPL | Stock | 14.3107 | 14.3118 | 14.3107 | 14.3118 | 14000.0 |
| 2011-10-20 07:02:00 | AAPL | Stock | 14.3036 | 14.3036 | 14.3036 | 14.3036 | 2800.0 |
| 2011-10-20 07:07:00 | AAPL | Stock | 14.2857 | 14.2857 | 14.2821 | 14.2821 | 17080.0 |
| 2011-10-20 07:10:00 | AAPL | Stock | 14.2746 | 14.2746 | 14.2746 | 14.2746 | 14000.0 |
| 2011-10-20 07:13:00 | AAPL | Stock | 14.2993 | 14.2993 | 14.2857 | 14.2857 | 7028.0 |
| 2011-10-20 07:15:00 | AAPL | Stock | 14.2679 | 14.2679 | 14.2679 | 14.2679 | 3920.0 |
| 2011-10-20 07:16:00 | AAPL | Stock | 14.2714 | 14.2964 | 14.2714 | 14.2964 | 28476.0 |
| 2011-10-20 07:19:00 | AAPL | Stock | 14.285 | 14.285 | 14.285 | 14.285 | 2800.0 |
| 2011-10-20 07:22:00 | AAPL | Stock | 14.2589 | 14.2589 | 14.2579 | 14.2579 | 5600.0 |
| 2011-10-20 07:24:00 | AAPL | Stock | 14.2682 | 14.2682 | 14.2682 | 14.2682 | 5600.0 |
| 2011-10-20 07:32:00 | AAPL | Stock | 14.2857 | 14.2857 | 14.2857 | 14.2857 | 2800.0 |
| 2011-10-20 07:34:00 | AAPL | Stock | 14.2982 | 14.3107 | 14.2861 | 14.3107 | 19600.0 |
| 2011-10-20 07:35:00 | AAPL | Stock | 14.3039 | 14.3179 | 14.3036 | 14.3179 | 28000.0 |
| 2011-10-20 07:36:00 | AAPL | Stock | 14.3114 | 14.3114 | 14.3114 | 14.3114 | 5600.0 |
| 2011-10-20 07:37:00 | AAPL | Stock | 14.3129 | 14.3129 | 14.3129 | 14.3129 | 2800.0 |
| 2011-10-20 07:38:00 | AAPL | Stock | 14.3029 | 14.3029 | 14.3029 | 14.3029 | 2800.0 |
| 2011-10-20 07:40:00 | AAPL | Stock | 14.2929 | 14.2929 | 14.2929 | 14.2929 | 2800.0 |
| 2011-10-20 07:44:00 | AAPL | Stock | 14.2993 | 14.2993 | 14.2993 | 14.2993 | 5600.0 |
| 2011-10-20 07:45:00 | AAPL | Stock | 14.2964 | 14.2989 | 14.2964 | 14.2989 | 5600.0 |
| 2011-10-20 07:46:00 | AAPL | Stock | 14.29 | 14.29 | 14.29 | 14.29 | 5600.0 |
| 2011-10-20 07:48:00 | AAPL | Stock | 14.3 | 14.3 | 14.3 | 14.3 | 5600.0 |
| 2011-10-20 07:49:00 | AAPL | Stock | 14.3036 | 14.3036 | 14.3036 | 14.3036 | 5600.0 |
| 2011-10-20 07:50:00 | AAPL | Stock | 14.3029 | 14.3029 | 14.3029 | 14.3029 | 2800.0 |
| 2011-10-20 07:51:00 | AAPL | Stock | 14.3 | 14.3 | 14.3 | 14.3 | 2800.0 |
> showing 50 of 961,899 rows — these rows as CSV