PREVIEW / stock_5min / 2012-12-21
file: by_date/stock_5min/2012/2012-12-21.parquet size: 5.2 MB rows: 350,629 symbols: 3,513
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 |
|---|---|---|---|---|---|---|---|
| 2012-12-21 04:00:00 | AAPL | Stock | 18.5071 | 18.5071 | 18.3386 | 18.3571 | 29848.0 |
| 2012-12-21 04:05:00 | AAPL | Stock | 18.35 | 18.35 | 18.34 | 18.34 | 9520.0 |
| 2012-12-21 04:10:00 | AAPL | Stock | 18.3554 | 18.3575 | 18.3554 | 18.3575 | 5600.0 |
| 2012-12-21 04:15:00 | AAPL | Stock | 18.3575 | 18.3575 | 18.3575 | 18.3575 | 11200.0 |
| 2012-12-21 04:25:00 | AAPL | Stock | 18.3707 | 18.3707 | 18.3707 | 18.3707 | 4900.0 |
| 2012-12-21 04:30:00 | AAPL | Stock | 18.3579 | 18.3579 | 18.3464 | 18.3482 | 19292.0 |
| 2012-12-21 04:35:00 | AAPL | Stock | 18.3446 | 18.3446 | 18.3311 | 18.3311 | 33600.0 |
| 2012-12-21 04:40:00 | AAPL | Stock | 18.3214 | 18.3286 | 18.2968 | 18.2968 | 110852.0 |
| 2012-12-21 04:45:00 | AAPL | Stock | 18.29 | 18.3114 | 18.2768 | 18.2768 | 320124.0 |
| 2012-12-21 04:50:00 | AAPL | Stock | 18.2857 | 18.2857 | 18.2857 | 18.2857 | 2800.0 |
| 2012-12-21 04:55:00 | AAPL | Stock | 18.2929 | 18.2929 | 18.2857 | 18.2857 | 69720.0 |
| 2012-12-21 05:00:00 | AAPL | Stock | 18.26 | 18.2625 | 18.26 | 18.2625 | 90300.0 |
| 2012-12-21 05:10:00 | AAPL | Stock | 18.2893 | 18.2893 | 18.2893 | 18.2893 | 2800.0 |
| 2012-12-21 05:15:00 | AAPL | Stock | 18.3 | 18.3 | 18.3 | 18.3 | 2800.0 |
| 2012-12-21 05:25:00 | AAPL | Stock | 18.2857 | 18.2857 | 18.2679 | 18.2829 | 30744.0 |
| 2012-12-21 05:35:00 | AAPL | Stock | 18.2864 | 18.2864 | 18.2864 | 18.2864 | 14000.0 |
| 2012-12-21 05:40:00 | AAPL | Stock | 18.2868 | 18.2868 | 18.2868 | 18.2868 | 14840.0 |
| 2012-12-21 05:50:00 | AAPL | Stock | 18.2861 | 18.2871 | 18.2854 | 18.2871 | 19488.0 |
| 2012-12-21 05:55:00 | AAPL | Stock | 18.2886 | 18.3036 | 18.2886 | 18.2964 | 11200.0 |
| 2012-12-21 06:00:00 | AAPL | Stock | 18.3075 | 18.3089 | 18.3075 | 18.3089 | 8400.0 |
| 2012-12-21 06:05:00 | AAPL | Stock | 18.3214 | 18.3214 | 18.3214 | 18.3214 | 6832.0 |
| 2012-12-21 06:15:00 | AAPL | Stock | 18.3164 | 18.3754 | 18.3164 | 18.3754 | 22400.0 |
| 2012-12-21 06:20:00 | AAPL | Stock | 18.3914 | 18.3914 | 18.3914 | 18.3914 | 2800.0 |
| 2012-12-21 06:25:00 | AAPL | Stock | 18.3879 | 18.3921 | 18.3589 | 18.3807 | 30800.0 |
| 2012-12-21 06:50:00 | AAPL | Stock | 18.3811 | 18.3893 | 18.3811 | 18.3893 | 5600.0 |
| 2012-12-21 06:55:00 | AAPL | Stock | 18.3568 | 18.3875 | 18.3568 | 18.3875 | 16800.0 |
| 2012-12-21 07:00:00 | AAPL | Stock | 18.3393 | 18.3568 | 18.2414 | 18.2414 | 154784.0 |
| 2012-12-21 07:05:00 | AAPL | Stock | 18.25 | 18.2511 | 18.2321 | 18.2446 | 452004.0 |
| 2012-12-21 07:10:00 | AAPL | Stock | 18.25 | 18.2679 | 18.25 | 18.2589 | 168448.0 |
| 2012-12-21 07:15:00 | AAPL | Stock | 18.2614 | 18.2786 | 18.2571 | 18.2786 | 137200.0 |
| 2012-12-21 07:20:00 | AAPL | Stock | 18.2821 | 18.3129 | 18.2821 | 18.3089 | 56000.0 |
| 2012-12-21 07:25:00 | AAPL | Stock | 18.3161 | 18.3304 | 18.3107 | 18.3282 | 65716.0 |
| 2012-12-21 07:30:00 | AAPL | Stock | 18.3143 | 18.3186 | 18.3082 | 18.3175 | 54908.0 |
| 2012-12-21 07:35:00 | AAPL | Stock | 18.3171 | 18.3304 | 18.3161 | 18.325 | 39200.0 |
| 2012-12-21 07:40:00 | AAPL | Stock | 18.3279 | 18.3321 | 18.3214 | 18.3304 | 125160.0 |
| 2012-12-21 07:45:00 | AAPL | Stock | 18.3304 | 18.3746 | 18.3304 | 18.3418 | 172312.0 |
| 2012-12-21 07:50:00 | AAPL | Stock | 18.3464 | 18.3464 | 18.3304 | 18.3304 | 151116.0 |
| 2012-12-21 07:55:00 | AAPL | Stock | 18.3418 | 18.3418 | 18.32 | 18.3214 | 78008.0 |
| 2012-12-21 08:00:00 | AAPL | Stock | 18.3214 | 18.375 | 18.2357 | 18.2986 | 739788.0 |
| 2012-12-21 08:05:00 | AAPL | Stock | 18.3025 | 18.3461 | 18.3025 | 18.3214 | 308308.0 |
| 2012-12-21 08:10:00 | AAPL | Stock | 18.3207 | 18.3207 | 18.275 | 18.2857 | 722596.0 |
| 2012-12-21 08:15:00 | AAPL | Stock | 18.285 | 18.2857 | 18.2575 | 18.2618 | 337120.0 |
| 2012-12-21 08:20:00 | AAPL | Stock | 18.2589 | 18.2668 | 18.2354 | 18.2434 | 573552.0 |
| 2012-12-21 08:25:00 | AAPL | Stock | 18.2468 | 18.2621 | 18.2357 | 18.2457 | 505876.0 |
| 2012-12-21 08:30:00 | AAPL | Stock | 18.2425 | 18.2486 | 18.2261 | 18.2446 | 495684.0 |
| 2012-12-21 08:35:00 | AAPL | Stock | 18.2461 | 18.2857 | 18.2461 | 18.28 | 469868.0 |
| 2012-12-21 08:40:00 | AAPL | Stock | 18.2843 | 18.3079 | 18.2554 | 18.2661 | 627760.0 |
| 2012-12-21 08:45:00 | AAPL | Stock | 18.2618 | 18.2679 | 18.2432 | 18.2571 | 151900.0 |
| 2012-12-21 08:50:00 | AAPL | Stock | 18.2671 | 18.3661 | 18.2668 | 18.33 | 1267504.0 |
| 2012-12-21 08:55:00 | AAPL | Stock | 18.3254 | 18.3343 | 18.2789 | 18.2946 | 274400.0 |
> showing 50 of 350,629 rows — these rows as CSV