PREVIEW / stock_5min / 2014-06-03
file: by_date/stock_5min/2014/2014-06-03.parquet size: 5.4 MB rows: 364,295 symbols: 3,530
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-03 04:40:00 | AAPL | Stock | 22.3464 | 22.3464 | 22.3254 | 22.3254 | 8400.0 |
| 2014-06-03 04:50:00 | AAPL | Stock | 22.3232 | 22.3232 | 22.3232 | 22.3232 | 2800.0 |
| 2014-06-03 05:20:00 | AAPL | Stock | 22.3214 | 22.3214 | 22.3214 | 22.3214 | 5600.0 |
| 2014-06-03 05:30:00 | AAPL | Stock | 22.3214 | 22.3214 | 22.3214 | 22.3214 | 8400.0 |
| 2014-06-03 05:35:00 | AAPL | Stock | 22.3214 | 22.3214 | 22.3214 | 22.3214 | 2800.0 |
| 2014-06-03 05:45:00 | AAPL | Stock | 22.3361 | 22.3361 | 22.3361 | 22.3361 | 2828.0 |
| 2014-06-03 05:55:00 | AAPL | Stock | 22.3271 | 22.3271 | 22.3271 | 22.3271 | 2800.0 |
| 2014-06-03 06:10:00 | AAPL | Stock | 22.3325 | 22.3325 | 22.3325 | 22.3325 | 5600.0 |
| 2014-06-03 06:15:00 | AAPL | Stock | 22.3339 | 22.3339 | 22.3339 | 22.3339 | 5516.0 |
| 2014-06-03 06:25:00 | AAPL | Stock | 22.3304 | 22.3304 | 22.3304 | 22.3304 | 2800.0 |
| 2014-06-03 06:30:00 | AAPL | Stock | 22.3357 | 22.3357 | 22.3357 | 22.3357 | 7000.0 |
| 2014-06-03 06:45:00 | AAPL | Stock | 22.3539 | 22.3539 | 22.3539 | 22.3539 | 18648.0 |
| 2014-06-03 06:55:00 | AAPL | Stock | 22.3571 | 22.3571 | 22.3571 | 22.3571 | 2800.0 |
| 2014-06-03 07:00:00 | AAPL | Stock | 22.3571 | 22.3571 | 22.3357 | 22.3396 | 8400.0 |
| 2014-06-03 07:05:00 | AAPL | Stock | 22.3357 | 22.3393 | 22.3304 | 22.3304 | 17836.0 |
| 2014-06-03 07:10:00 | AAPL | Stock | 22.3321 | 22.3321 | 22.3321 | 22.3321 | 5600.0 |
| 2014-06-03 07:15:00 | AAPL | Stock | 22.3357 | 22.3361 | 22.3296 | 22.3361 | 36120.0 |
| 2014-06-03 07:20:00 | AAPL | Stock | 22.3393 | 22.3393 | 22.3393 | 22.3393 | 5600.0 |
| 2014-06-03 07:25:00 | AAPL | Stock | 22.345 | 22.3711 | 22.345 | 22.3643 | 93548.0 |
| 2014-06-03 07:30:00 | AAPL | Stock | 22.3571 | 22.3571 | 22.3571 | 22.3571 | 2800.0 |
| 2014-06-03 07:35:00 | AAPL | Stock | 22.3568 | 22.3568 | 22.34 | 22.3418 | 56280.0 |
| 2014-06-03 07:40:00 | AAPL | Stock | 22.3482 | 22.3482 | 22.3393 | 22.3421 | 25200.0 |
| 2014-06-03 07:45:00 | AAPL | Stock | 22.3564 | 22.3564 | 22.3429 | 22.3429 | 30800.0 |
| 2014-06-03 07:55:00 | AAPL | Stock | 22.35 | 22.35 | 22.35 | 22.35 | 2800.0 |
| 2014-06-03 08:00:00 | AAPL | Stock | 22.3554 | 22.3714 | 22.3325 | 22.3429 | 175840.0 |
| 2014-06-03 08:05:00 | AAPL | Stock | 22.3411 | 22.3411 | 22.3393 | 22.3393 | 16100.0 |
| 2014-06-03 08:10:00 | AAPL | Stock | 22.3446 | 22.3536 | 22.3414 | 22.3536 | 51884.0 |
| 2014-06-03 08:15:00 | AAPL | Stock | 22.3571 | 22.3696 | 22.3571 | 22.3696 | 30800.0 |
| 2014-06-03 08:20:00 | AAPL | Stock | 22.3746 | 22.3746 | 22.3571 | 22.3625 | 89740.0 |
| 2014-06-03 08:25:00 | AAPL | Stock | 22.3661 | 22.3679 | 22.3607 | 22.3679 | 70448.0 |
| 2014-06-03 08:30:00 | AAPL | Stock | 22.3611 | 22.3746 | 22.3607 | 22.3746 | 47600.0 |
| 2014-06-03 08:35:00 | AAPL | Stock | 22.3746 | 22.3836 | 22.3668 | 22.3836 | 75264.0 |
| 2014-06-03 08:40:00 | AAPL | Stock | 22.375 | 22.3846 | 22.3714 | 22.3714 | 42700.0 |
| 2014-06-03 08:45:00 | AAPL | Stock | 22.3693 | 22.3893 | 22.3689 | 22.3893 | 86968.0 |
| 2014-06-03 08:50:00 | AAPL | Stock | 22.3929 | 22.4286 | 22.3929 | 22.4286 | 183988.0 |
| 2014-06-03 08:55:00 | AAPL | Stock | 22.4111 | 22.4479 | 22.4111 | 22.4239 | 320740.0 |
| 2014-06-03 09:00:00 | AAPL | Stock | 22.4239 | 22.4357 | 22.4221 | 22.43 | 233240.0 |
| 2014-06-03 09:05:00 | AAPL | Stock | 22.4321 | 22.4561 | 22.4321 | 22.4411 | 149996.0 |
| 2014-06-03 09:10:00 | AAPL | Stock | 22.4375 | 22.4707 | 22.4371 | 22.4536 | 222628.0 |
| 2014-06-03 09:15:00 | AAPL | Stock | 22.4679 | 22.4679 | 22.4464 | 22.4464 | 166292.0 |
| 2014-06-03 09:20:00 | AAPL | Stock | 22.4482 | 22.4543 | 22.4446 | 22.4464 | 109676.0 |
| 2014-06-03 09:25:00 | AAPL | Stock | 22.4539 | 22.4654 | 22.4386 | 22.4439 | 287364.0 |
| 2014-06-03 09:30:00 | AAPL | Stock | 22.445 | 22.5707 | 22.4375 | 22.5102 | 12862752.0 |
| 2014-06-03 09:35:00 | AAPL | Stock | 22.5139 | 22.6 | 22.4779 | 22.5996 | 10444644.0 |
| 2014-06-03 09:40:00 | AAPL | Stock | 22.5955 | 22.7054 | 22.5954 | 22.6982 | 15026088.0 |
| 2014-06-03 09:45:00 | AAPL | Stock | 22.7011 | 22.7036 | 22.6561 | 22.6636 | 8711556.0 |
| 2014-06-03 09:50:00 | AAPL | Stock | 22.6692 | 22.78 | 22.6671 | 22.7575 | 13440448.0 |
| 2014-06-03 09:55:00 | AAPL | Stock | 22.7579 | 22.7629 | 22.7271 | 22.7551 | 5036724.0 |
| 2014-06-03 10:00:00 | AAPL | Stock | 22.7571 | 22.7628 | 22.7161 | 22.7214 | 5740728.0 |
| 2014-06-03 10:05:00 | AAPL | Stock | 22.7218 | 22.7757 | 22.7218 | 22.7529 | 5191956.0 |
> showing 50 of 364,295 rows — these rows as CSV