PREVIEW / stock_5min / 2012-04-05
file: by_date/stock_5min/2012/2012-04-05.parquet size: 4.7 MB rows: 320,202 symbols: 3,484
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-04-05 04:00:00 | AAPL | Stock | 22.3136 | 22.35 | 22.3136 | 22.35 | 28000.0 |
| 2012-04-05 04:05:00 | AAPL | Stock | 22.3479 | 22.3482 | 22.3479 | 22.3482 | 5600.0 |
| 2012-04-05 04:10:00 | AAPL | Stock | 22.3464 | 22.3464 | 22.3464 | 22.3464 | 2800.0 |
| 2012-04-05 04:25:00 | AAPL | Stock | 22.3214 | 22.3214 | 22.3214 | 22.3214 | 16800.0 |
| 2012-04-05 05:00:00 | AAPL | Stock | 22.2996 | 22.3 | 22.2996 | 22.3 | 56000.0 |
| 2012-04-05 05:05:00 | AAPL | Stock | 22.3211 | 22.3286 | 22.3211 | 22.3286 | 28000.0 |
| 2012-04-05 05:10:00 | AAPL | Stock | 22.3214 | 22.3214 | 22.3214 | 22.3214 | 25200.0 |
| 2012-04-05 05:15:00 | AAPL | Stock | 22.3036 | 22.3036 | 22.3036 | 22.3036 | 8400.0 |
| 2012-04-05 05:25:00 | AAPL | Stock | 22.3 | 22.3 | 22.3 | 22.3 | 5600.0 |
| 2012-04-05 05:30:00 | AAPL | Stock | 22.3036 | 22.3036 | 22.2857 | 22.2857 | 45920.0 |
| 2012-04-05 05:35:00 | AAPL | Stock | 22.2857 | 22.2857 | 22.2768 | 22.2768 | 11200.0 |
| 2012-04-05 05:40:00 | AAPL | Stock | 22.25 | 22.25 | 22.25 | 22.25 | 2800.0 |
| 2012-04-05 06:00:00 | AAPL | Stock | 22.2168 | 22.2168 | 22.1618 | 22.1618 | 61600.0 |
| 2012-04-05 06:05:00 | AAPL | Stock | 22.1514 | 22.1964 | 22.1436 | 22.1964 | 21728.0 |
| 2012-04-05 06:20:00 | AAPL | Stock | 22.1875 | 22.1875 | 22.1875 | 22.1875 | 8400.0 |
| 2012-04-05 06:25:00 | AAPL | Stock | 22.1857 | 22.1929 | 22.1857 | 22.1911 | 70000.0 |
| 2012-04-05 06:30:00 | AAPL | Stock | 22.2139 | 22.2532 | 22.2139 | 22.2532 | 9156.0 |
| 2012-04-05 06:35:00 | AAPL | Stock | 22.2604 | 22.2604 | 22.2604 | 22.2604 | 2800.0 |
| 2012-04-05 06:45:00 | AAPL | Stock | 22.25 | 22.25 | 22.2146 | 22.2146 | 5600.0 |
| 2012-04-05 06:55:00 | AAPL | Stock | 22.2232 | 22.2286 | 22.2232 | 22.2286 | 11200.0 |
| 2012-04-05 07:00:00 | AAPL | Stock | 22.2464 | 22.2668 | 22.2464 | 22.2668 | 24024.0 |
| 2012-04-05 07:05:00 | AAPL | Stock | 22.2657 | 22.2846 | 22.2657 | 22.2754 | 59192.0 |
| 2012-04-05 07:10:00 | AAPL | Stock | 22.2839 | 22.2857 | 22.2768 | 22.2768 | 22652.0 |
| 2012-04-05 07:15:00 | AAPL | Stock | 22.2682 | 22.2961 | 22.2679 | 22.295 | 40600.0 |
| 2012-04-05 07:20:00 | AAPL | Stock | 22.2861 | 22.3011 | 22.2857 | 22.2893 | 15400.0 |
| 2012-04-05 07:25:00 | AAPL | Stock | 22.2943 | 22.3125 | 22.2943 | 22.2964 | 92204.0 |
| 2012-04-05 07:30:00 | AAPL | Stock | 22.29 | 22.2954 | 22.2857 | 22.2864 | 144284.0 |
| 2012-04-05 07:35:00 | AAPL | Stock | 22.2893 | 22.2893 | 22.2857 | 22.2864 | 87500.0 |
| 2012-04-05 07:40:00 | AAPL | Stock | 22.2861 | 22.2861 | 22.2536 | 22.2536 | 53200.0 |
| 2012-04-05 07:45:00 | AAPL | Stock | 22.2536 | 22.2768 | 22.2536 | 22.2768 | 37520.0 |
| 2012-04-05 07:50:00 | AAPL | Stock | 22.2764 | 22.2857 | 22.2679 | 22.2857 | 46732.0 |
| 2012-04-05 07:55:00 | AAPL | Stock | 22.2857 | 22.2857 | 22.2846 | 22.2857 | 14000.0 |
| 2012-04-05 08:00:00 | AAPL | Stock | 22.2786 | 22.3054 | 22.25 | 22.25 | 234920.0 |
| 2012-04-05 08:05:00 | AAPL | Stock | 22.2489 | 22.2629 | 22.2489 | 22.2539 | 84420.0 |
| 2012-04-05 08:10:00 | AAPL | Stock | 22.2536 | 22.2536 | 22.2161 | 22.2439 | 409724.0 |
| 2012-04-05 08:15:00 | AAPL | Stock | 22.2421 | 22.2496 | 22.2304 | 22.2368 | 437528.0 |
| 2012-04-05 08:20:00 | AAPL | Stock | 22.2393 | 22.2661 | 22.2364 | 22.2518 | 356720.0 |
| 2012-04-05 08:25:00 | AAPL | Stock | 22.2536 | 22.2939 | 22.2532 | 22.2857 | 701904.0 |
| 2012-04-05 08:30:00 | AAPL | Stock | 22.2857 | 22.3464 | 22.2857 | 22.3464 | 844116.0 |
| 2012-04-05 08:35:00 | AAPL | Stock | 22.3393 | 22.3571 | 22.3321 | 22.3357 | 1375780.0 |
| 2012-04-05 08:40:00 | AAPL | Stock | 22.3357 | 22.375 | 22.3357 | 22.3675 | 1211952.0 |
| 2012-04-05 08:45:00 | AAPL | Stock | 22.3704 | 22.4157 | 22.3668 | 22.4157 | 1474872.0 |
| 2012-04-05 08:50:00 | AAPL | Stock | 22.4125 | 22.4168 | 22.3993 | 22.4032 | 877520.0 |
| 2012-04-05 08:55:00 | AAPL | Stock | 22.4039 | 22.4186 | 22.3875 | 22.3964 | 568204.0 |
| 2012-04-05 09:00:00 | AAPL | Stock | 22.4 | 22.4032 | 22.3689 | 22.3857 | 492240.0 |
| 2012-04-05 09:05:00 | AAPL | Stock | 22.3886 | 22.3886 | 22.3675 | 22.3714 | 225512.0 |
| 2012-04-05 09:10:00 | AAPL | Stock | 22.3671 | 22.375 | 22.3529 | 22.3689 | 595028.0 |
| 2012-04-05 09:15:00 | AAPL | Stock | 22.3686 | 22.3689 | 22.3443 | 22.3571 | 597520.0 |
| 2012-04-05 09:20:00 | AAPL | Stock | 22.3554 | 22.3554 | 22.3364 | 22.3471 | 159292.0 |
| 2012-04-05 09:25:00 | AAPL | Stock | 22.35 | 22.4039 | 22.35 | 22.4039 | 686840.0 |
> showing 50 of 320,202 rows — these rows as CSV