PREVIEW / stock_5min / 2011-09-28
file: by_date/stock_5min/2011/2011-09-28.parquet size: 4.8 MB rows: 325,701 symbols: 3,483
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-09-28 04:00:00 | AAPL | Stock | 14.2664 | 14.3021 | 14.2664 | 14.3021 | 16520.0 |
| 2011-09-28 04:10:00 | AAPL | Stock | 14.3929 | 14.3929 | 14.3929 | 14.3929 | 2800.0 |
| 2011-09-28 04:15:00 | AAPL | Stock | 14.3925 | 14.3925 | 14.3925 | 14.3925 | 8400.0 |
| 2011-09-28 04:25:00 | AAPL | Stock | 14.3393 | 14.3393 | 14.3393 | 14.3393 | 2800.0 |
| 2011-09-28 04:30:00 | AAPL | Stock | 14.3214 | 14.3214 | 14.3214 | 14.3214 | 13972.0 |
| 2011-09-28 05:00:00 | AAPL | Stock | 14.3357 | 14.3357 | 14.3336 | 14.3336 | 5600.0 |
| 2011-09-28 05:25:00 | AAPL | Stock | 14.35 | 14.35 | 14.35 | 14.35 | 2800.0 |
| 2011-09-28 05:55:00 | AAPL | Stock | 14.3893 | 14.3971 | 14.3893 | 14.3971 | 16800.0 |
| 2011-09-28 06:15:00 | AAPL | Stock | 14.3782 | 14.3782 | 14.3782 | 14.3782 | 8400.0 |
| 2011-09-28 06:20:00 | AAPL | Stock | 14.3929 | 14.3929 | 14.3929 | 14.3929 | 26936.0 |
| 2011-09-28 06:25:00 | AAPL | Stock | 14.4075 | 14.4157 | 14.4075 | 14.4157 | 28000.0 |
| 2011-09-28 06:30:00 | AAPL | Stock | 14.3929 | 14.3929 | 14.3825 | 14.3929 | 16800.0 |
| 2011-09-28 06:35:00 | AAPL | Stock | 14.41 | 14.41 | 14.41 | 14.41 | 2800.0 |
| 2011-09-28 06:40:00 | AAPL | Stock | 14.3929 | 14.3929 | 14.3929 | 14.3929 | 2800.0 |
| 2011-09-28 06:50:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.4104 | 14.4104 | 5600.0 |
| 2011-09-28 07:00:00 | AAPL | Stock | 14.4107 | 14.4107 | 14.375 | 14.375 | 105560.0 |
| 2011-09-28 07:05:00 | AAPL | Stock | 14.3857 | 14.3857 | 14.375 | 14.375 | 23296.0 |
| 2011-09-28 07:10:00 | AAPL | Stock | 14.3714 | 14.3714 | 14.3636 | 14.3636 | 37520.0 |
| 2011-09-28 07:15:00 | AAPL | Stock | 14.3575 | 14.3575 | 14.3411 | 14.3411 | 65100.0 |
| 2011-09-28 07:20:00 | AAPL | Stock | 14.3354 | 14.3393 | 14.3214 | 14.3389 | 65240.0 |
| 2011-09-28 07:25:00 | AAPL | Stock | 14.3389 | 14.3393 | 14.3343 | 14.3393 | 61292.0 |
| 2011-09-28 07:30:00 | AAPL | Stock | 14.3343 | 14.3343 | 14.3136 | 14.3207 | 44800.0 |
| 2011-09-28 07:35:00 | AAPL | Stock | 14.3207 | 14.3214 | 14.3057 | 14.3057 | 192780.0 |
| 2011-09-28 07:40:00 | AAPL | Stock | 14.3054 | 14.3196 | 14.2971 | 14.3196 | 109144.0 |
| 2011-09-28 07:45:00 | AAPL | Stock | 14.3118 | 14.3118 | 14.2857 | 14.2857 | 28000.0 |
| 2011-09-28 07:50:00 | AAPL | Stock | 14.2821 | 14.3214 | 14.2786 | 14.3214 | 164836.0 |
| 2011-09-28 07:55:00 | AAPL | Stock | 14.3079 | 14.3139 | 14.2964 | 14.2964 | 22400.0 |
| 2011-09-28 08:00:00 | AAPL | Stock | 14.2904 | 14.325 | 14.2857 | 14.3032 | 217308.0 |
| 2011-09-28 08:05:00 | AAPL | Stock | 14.3021 | 14.3071 | 14.2689 | 14.2786 | 384944.0 |
| 2011-09-28 08:10:00 | AAPL | Stock | 14.2846 | 14.2857 | 14.2521 | 14.2525 | 234052.0 |
| 2011-09-28 08:15:00 | AAPL | Stock | 14.2629 | 14.2821 | 14.2554 | 14.2811 | 231980.0 |
| 2011-09-28 08:20:00 | AAPL | Stock | 14.2821 | 14.2821 | 14.2711 | 14.275 | 305788.0 |
| 2011-09-28 08:25:00 | AAPL | Stock | 14.275 | 14.2829 | 14.2668 | 14.2771 | 127400.0 |
| 2011-09-28 08:30:00 | AAPL | Stock | 14.2775 | 14.3025 | 14.2407 | 14.2407 | 576828.0 |
| 2011-09-28 08:35:00 | AAPL | Stock | 14.2404 | 14.2593 | 14.23 | 14.2307 | 452312.0 |
| 2011-09-28 08:40:00 | AAPL | Stock | 14.2457 | 14.2593 | 14.2282 | 14.2543 | 342468.0 |
| 2011-09-28 08:45:00 | AAPL | Stock | 14.2507 | 14.2532 | 14.2325 | 14.2325 | 244412.0 |
| 2011-09-28 08:50:00 | AAPL | Stock | 14.2329 | 14.2607 | 14.2289 | 14.2607 | 179032.0 |
| 2011-09-28 08:55:00 | AAPL | Stock | 14.2675 | 14.2821 | 14.2568 | 14.2729 | 716856.0 |
| 2011-09-28 09:00:00 | AAPL | Stock | 14.2689 | 14.2857 | 14.2668 | 14.2786 | 655172.0 |
| 2011-09-28 09:05:00 | AAPL | Stock | 14.2839 | 14.3075 | 14.2807 | 14.3054 | 377860.0 |
| 2011-09-28 09:10:00 | AAPL | Stock | 14.3093 | 14.3304 | 14.3071 | 14.3204 | 1050252.0 |
| 2011-09-28 09:15:00 | AAPL | Stock | 14.3125 | 14.3154 | 14.2982 | 14.3068 | 119868.0 |
| 2011-09-28 09:20:00 | AAPL | Stock | 14.3054 | 14.3114 | 14.2907 | 14.2914 | 64596.0 |
| 2011-09-28 09:25:00 | AAPL | Stock | 14.2921 | 14.3057 | 14.2882 | 14.2882 | 285740.0 |
| 2011-09-28 09:30:00 | AAPL | Stock | 14.2921 | 14.3179 | 14.2028 | 14.2832 | 27603576.0 |
| 2011-09-28 09:35:00 | AAPL | Stock | 14.2832 | 14.3661 | 14.2707 | 14.3566 | 15628788.0 |
| 2011-09-28 09:40:00 | AAPL | Stock | 14.3593 | 14.4107 | 14.3293 | 14.405 | 14072660.0 |
| 2011-09-28 09:45:00 | AAPL | Stock | 14.4061 | 14.4087 | 14.3471 | 14.371 | 10749424.0 |
| 2011-09-28 09:50:00 | AAPL | Stock | 14.3693 | 14.4193 | 14.3529 | 14.3764 | 11644248.0 |
> showing 50 of 325,701 rows — these rows as CSV