PREVIEW / stock_5min / 2013-12-24
file: by_date/stock_5min/2013/2013-12-24.parquet size: 3.2 MB rows: 200,481 symbols: 3,461
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-24 04:10:00 | AAPL | Stock | 20.37 | 20.37 | 20.37 | 20.37 | 2800.0 |
| 2013-12-24 05:00:00 | AAPL | Stock | 20.3854 | 20.4064 | 20.3854 | 20.4064 | 36400.0 |
| 2013-12-24 05:15:00 | AAPL | Stock | 20.4 | 20.4 | 20.4 | 20.4 | 2800.0 |
| 2013-12-24 05:45:00 | AAPL | Stock | 20.435 | 20.435 | 20.435 | 20.435 | 2800.0 |
| 2013-12-24 06:00:00 | AAPL | Stock | 20.435 | 20.435 | 20.435 | 20.435 | 2800.0 |
| 2013-12-24 06:10:00 | AAPL | Stock | 20.4286 | 20.4286 | 20.4286 | 20.4286 | 2800.0 |
| 2013-12-24 06:15:00 | AAPL | Stock | 20.4039 | 20.4039 | 20.3929 | 20.3929 | 6524.0 |
| 2013-12-24 06:30:00 | AAPL | Stock | 20.4286 | 20.4286 | 20.4286 | 20.4286 | 2800.0 |
| 2013-12-24 06:55:00 | AAPL | Stock | 20.4264 | 20.4264 | 20.4261 | 20.4261 | 5600.0 |
| 2013-12-24 07:00:00 | AAPL | Stock | 20.4246 | 20.4246 | 20.4236 | 20.4236 | 14000.0 |
| 2013-12-24 07:05:00 | AAPL | Stock | 20.3929 | 20.3982 | 20.3929 | 20.3982 | 58296.0 |
| 2013-12-24 07:10:00 | AAPL | Stock | 20.3929 | 20.3936 | 20.3929 | 20.3929 | 56000.0 |
| 2013-12-24 07:15:00 | AAPL | Stock | 20.3771 | 20.3771 | 20.3661 | 20.3661 | 28700.0 |
| 2013-12-24 07:25:00 | AAPL | Stock | 20.3679 | 20.3679 | 20.3329 | 20.3329 | 22400.0 |
| 2013-12-24 07:30:00 | AAPL | Stock | 20.3429 | 20.3429 | 20.3429 | 20.3429 | 5544.0 |
| 2013-12-24 07:35:00 | AAPL | Stock | 20.3571 | 20.375 | 20.3571 | 20.375 | 42000.0 |
| 2013-12-24 07:50:00 | AAPL | Stock | 20.3729 | 20.3739 | 20.3729 | 20.3729 | 12432.0 |
| 2013-12-24 07:55:00 | AAPL | Stock | 20.3679 | 20.3743 | 20.3571 | 20.3571 | 44520.0 |
| 2013-12-24 08:00:00 | AAPL | Stock | 20.3446 | 20.4257 | 20.3393 | 20.3532 | 326536.0 |
| 2013-12-24 08:05:00 | AAPL | Stock | 20.3397 | 20.3468 | 20.3293 | 20.3393 | 70700.0 |
| 2013-12-24 08:10:00 | AAPL | Stock | 20.3375 | 20.3375 | 20.3279 | 20.3279 | 5600.0 |
| 2013-12-24 08:15:00 | AAPL | Stock | 20.3375 | 20.3396 | 20.3375 | 20.3393 | 24080.0 |
| 2013-12-24 08:20:00 | AAPL | Stock | 20.3393 | 20.345 | 20.3379 | 20.3379 | 16800.0 |
| 2013-12-24 08:25:00 | AAPL | Stock | 20.3411 | 20.3411 | 20.3293 | 20.3357 | 38752.0 |
| 2013-12-24 08:30:00 | AAPL | Stock | 20.3367 | 20.3367 | 20.3304 | 20.3354 | 21616.0 |
| 2013-12-24 08:35:00 | AAPL | Stock | 20.3357 | 20.3389 | 20.3304 | 20.3304 | 69972.0 |
| 2013-12-24 08:40:00 | AAPL | Stock | 20.3257 | 20.3414 | 20.3257 | 20.3414 | 57400.0 |
| 2013-12-24 08:45:00 | AAPL | Stock | 20.3443 | 20.3443 | 20.3389 | 20.3425 | 70896.0 |
| 2013-12-24 08:50:00 | AAPL | Stock | 20.3397 | 20.3429 | 20.3382 | 20.3429 | 47152.0 |
| 2013-12-24 08:55:00 | AAPL | Stock | 20.3446 | 20.3568 | 20.3393 | 20.3489 | 144200.0 |
| 2013-12-24 09:00:00 | AAPL | Stock | 20.3518 | 20.3525 | 20.35 | 20.35 | 25592.0 |
| 2013-12-24 09:05:00 | AAPL | Stock | 20.35 | 20.3535 | 20.3432 | 20.35 | 70084.0 |
| 2013-12-24 09:10:00 | AAPL | Stock | 20.3439 | 20.3704 | 20.3432 | 20.37 | 292852.0 |
| 2013-12-24 09:15:00 | AAPL | Stock | 20.3607 | 20.3739 | 20.3607 | 20.3643 | 177268.0 |
| 2013-12-24 09:20:00 | AAPL | Stock | 20.3596 | 20.3643 | 20.35 | 20.3571 | 112812.0 |
| 2013-12-24 09:25:00 | AAPL | Stock | 20.3518 | 20.3561 | 20.3346 | 20.3489 | 180628.0 |
| 2013-12-24 09:30:00 | AAPL | Stock | 20.3521 | 20.4171 | 20.3307 | 20.3843 | 13987904.0 |
| 2013-12-24 09:35:00 | AAPL | Stock | 20.386 | 20.4243 | 20.3393 | 20.3411 | 8975484.0 |
| 2013-12-24 09:40:00 | AAPL | Stock | 20.3461 | 20.3607 | 20.2786 | 20.3336 | 11550420.0 |
| 2013-12-24 09:45:00 | AAPL | Stock | 20.332 | 20.3482 | 20.3121 | 20.3306 | 3662344.0 |
| 2013-12-24 09:50:00 | AAPL | Stock | 20.3307 | 20.3454 | 20.3143 | 20.3439 | 2958340.0 |
| 2013-12-24 09:55:00 | AAPL | Stock | 20.3393 | 20.3771 | 20.3336 | 20.3651 | 6299468.0 |
| 2013-12-24 10:00:00 | AAPL | Stock | 20.3636 | 20.3693 | 20.34 | 20.3618 | 3598140.0 |
| 2013-12-24 10:05:00 | AAPL | Stock | 20.3643 | 20.3725 | 20.3221 | 20.3393 | 3375876.0 |
| 2013-12-24 10:10:00 | AAPL | Stock | 20.3386 | 20.3536 | 20.3218 | 20.3316 | 10480680.0 |
| 2013-12-24 10:15:00 | AAPL | Stock | 20.3339 | 20.3464 | 20.3321 | 20.3321 | 2548644.0 |
| 2013-12-24 10:20:00 | AAPL | Stock | 20.3314 | 20.3366 | 20.3068 | 20.316 | 3131324.0 |
| 2013-12-24 10:25:00 | AAPL | Stock | 20.3146 | 20.3161 | 20.2925 | 20.2945 | 2953328.0 |
| 2013-12-24 10:30:00 | AAPL | Stock | 20.2945 | 20.2961 | 20.2621 | 20.2642 | 4735220.0 |
| 2013-12-24 10:35:00 | AAPL | Stock | 20.2629 | 20.2679 | 20.2518 | 20.2618 | 3609396.0 |
> showing 50 of 200,481 rows — these rows as CSV