PREVIEW / stock_5min / 2012-11-01
file: by_date/stock_5min/2012/2012-11-01.parquet size: 4.8 MB rows: 319,613 symbols: 3,479
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-11-01 05:55:00 | AAPL | Stock | 21.25 | 21.25 | 21.25 | 21.25 | 4144.0 |
| 2012-11-01 06:20:00 | AAPL | Stock | 21.2404 | 21.2411 | 21.2404 | 21.2411 | 5936.0 |
| 2012-11-01 07:05:00 | AAPL | Stock | 21.2854 | 21.2854 | 21.2854 | 21.2854 | 2800.0 |
| 2012-11-01 07:10:00 | AAPL | Stock | 21.2843 | 21.2857 | 21.2679 | 21.2679 | 30492.0 |
| 2012-11-01 07:20:00 | AAPL | Stock | 21.2964 | 21.3 | 21.2964 | 21.3 | 5600.0 |
| 2012-11-01 07:35:00 | AAPL | Stock | 21.3032 | 21.3036 | 21.3032 | 21.3036 | 19124.0 |
| 2012-11-01 07:45:00 | AAPL | Stock | 21.325 | 21.3304 | 21.325 | 21.3304 | 16800.0 |
| 2012-11-01 07:55:00 | AAPL | Stock | 21.3207 | 21.3207 | 21.3207 | 21.3207 | 2800.0 |
| 2012-11-01 08:00:00 | AAPL | Stock | 21.3161 | 21.3211 | 21.2686 | 21.275 | 56644.0 |
| 2012-11-01 08:05:00 | AAPL | Stock | 21.2821 | 21.2993 | 21.2732 | 21.2929 | 78988.0 |
| 2012-11-01 08:10:00 | AAPL | Stock | 21.2986 | 21.3004 | 21.2964 | 21.3004 | 21000.0 |
| 2012-11-01 08:15:00 | AAPL | Stock | 21.2929 | 21.3336 | 21.2929 | 21.3168 | 186816.0 |
| 2012-11-01 08:20:00 | AAPL | Stock | 21.3168 | 21.3343 | 21.3168 | 21.3211 | 136976.0 |
| 2012-11-01 08:25:00 | AAPL | Stock | 21.3168 | 21.3168 | 21.3168 | 21.3168 | 11200.0 |
| 2012-11-01 08:30:00 | AAPL | Stock | 21.3211 | 21.3425 | 21.3082 | 21.3425 | 164108.0 |
| 2012-11-01 08:35:00 | AAPL | Stock | 21.3386 | 21.3464 | 21.3386 | 21.3393 | 60984.0 |
| 2012-11-01 08:40:00 | AAPL | Stock | 21.3375 | 21.3518 | 21.3375 | 21.3446 | 100660.0 |
| 2012-11-01 08:45:00 | AAPL | Stock | 21.3439 | 21.3446 | 21.2536 | 21.3429 | 209664.0 |
| 2012-11-01 08:50:00 | AAPL | Stock | 21.3425 | 21.3504 | 21.3418 | 21.3504 | 135324.0 |
| 2012-11-01 08:55:00 | AAPL | Stock | 21.3525 | 21.3571 | 21.3446 | 21.3571 | 135604.0 |
| 2012-11-01 09:00:00 | AAPL | Stock | 21.3579 | 21.3986 | 21.3579 | 21.3861 | 379316.0 |
| 2012-11-01 09:05:00 | AAPL | Stock | 21.3875 | 21.4107 | 21.3857 | 21.3982 | 343980.0 |
| 2012-11-01 09:10:00 | AAPL | Stock | 21.4064 | 21.4107 | 21.3943 | 21.3982 | 128240.0 |
| 2012-11-01 09:15:00 | AAPL | Stock | 21.405 | 21.4089 | 21.3929 | 21.3929 | 100520.0 |
| 2012-11-01 09:20:00 | AAPL | Stock | 21.3929 | 21.3961 | 21.3857 | 21.3925 | 47040.0 |
| 2012-11-01 09:25:00 | AAPL | Stock | 21.395 | 21.3986 | 21.3579 | 21.3714 | 188860.0 |
| 2012-11-01 09:30:00 | AAPL | Stock | 21.3618 | 21.4211 | 21.2775 | 21.3314 | 12911612.0 |
| 2012-11-01 09:35:00 | AAPL | Stock | 21.33 | 21.3696 | 21.2604 | 21.2757 | 8711444.0 |
| 2012-11-01 09:40:00 | AAPL | Stock | 21.2757 | 21.3014 | 21.2204 | 21.2415 | 7875280.0 |
| 2012-11-01 09:45:00 | AAPL | Stock | 21.2461 | 21.3529 | 21.2411 | 21.3232 | 7770336.0 |
| 2012-11-01 09:50:00 | AAPL | Stock | 21.3306 | 21.3306 | 21.2418 | 21.2482 | 6646752.0 |
| 2012-11-01 09:55:00 | AAPL | Stock | 21.2489 | 21.3104 | 21.2411 | 21.2625 | 6829760.0 |
| 2012-11-01 10:00:00 | AAPL | Stock | 21.2714 | 21.3417 | 21.2582 | 21.3075 | 9498216.0 |
| 2012-11-01 10:05:00 | AAPL | Stock | 21.3143 | 21.3714 | 21.2964 | 21.3546 | 6453860.0 |
| 2012-11-01 10:10:00 | AAPL | Stock | 21.355 | 21.3714 | 21.3357 | 21.3526 | 4105248.0 |
| 2012-11-01 10:15:00 | AAPL | Stock | 21.3511 | 21.4093 | 21.3393 | 21.3925 | 6190212.0 |
| 2012-11-01 10:20:00 | AAPL | Stock | 21.3896 | 21.4196 | 21.3832 | 21.3895 | 4307464.0 |
| 2012-11-01 10:25:00 | AAPL | Stock | 21.3929 | 21.4286 | 21.3857 | 21.3971 | 6587504.0 |
| 2012-11-01 10:30:00 | AAPL | Stock | 21.3911 | 21.3996 | 21.3507 | 21.3643 | 5896576.0 |
| 2012-11-01 10:35:00 | AAPL | Stock | 21.3629 | 21.3904 | 21.345 | 21.3482 | 3255364.0 |
| 2012-11-01 10:40:00 | AAPL | Stock | 21.3546 | 21.3843 | 21.3429 | 21.3793 | 2674476.0 |
| 2012-11-01 10:45:00 | AAPL | Stock | 21.3796 | 21.4482 | 21.3771 | 21.4421 | 8488144.0 |
| 2012-11-01 10:50:00 | AAPL | Stock | 21.4361 | 21.465 | 21.4293 | 21.4571 | 6693792.0 |
| 2012-11-01 10:55:00 | AAPL | Stock | 21.4568 | 21.5161 | 21.4446 | 21.4971 | 8832572.0 |
| 2012-11-01 11:00:00 | AAPL | Stock | 21.4975 | 21.5357 | 21.4829 | 21.4829 | 6724760.0 |
| 2012-11-01 11:05:00 | AAPL | Stock | 21.4829 | 21.5107 | 21.4732 | 21.5107 | 3674020.0 |
| 2012-11-01 11:10:00 | AAPL | Stock | 21.5107 | 21.535 | 21.4821 | 21.495 | 5943728.0 |
| 2012-11-01 11:15:00 | AAPL | Stock | 21.4934 | 21.5071 | 21.4607 | 21.4646 | 3548384.0 |
| 2012-11-01 11:20:00 | AAPL | Stock | 21.4611 | 21.4643 | 21.4321 | 21.4454 | 5262516.0 |
| 2012-11-01 11:25:00 | AAPL | Stock | 21.4439 | 21.4626 | 21.4404 | 21.4586 | 3405640.0 |
> showing 50 of 319,613 rows — these rows as CSV