PREVIEW / stock_5min / 2012-06-01
file: by_date/stock_5min/2012/2012-06-01.parquet size: 5.0 MB rows: 335,282 symbols: 3,534
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-06-01 04:00:00 | AAPL | Stock | 20.5536 | 20.5536 | 20.55 | 20.55 | 8400.0 |
| 2012-06-01 04:05:00 | AAPL | Stock | 20.5464 | 20.5536 | 20.5464 | 20.5536 | 5600.0 |
| 2012-06-01 04:10:00 | AAPL | Stock | 20.5536 | 20.5536 | 20.55 | 20.55 | 8400.0 |
| 2012-06-01 04:15:00 | AAPL | Stock | 20.5536 | 20.5536 | 20.55 | 20.55 | 8400.0 |
| 2012-06-01 04:20:00 | AAPL | Stock | 20.5536 | 20.5536 | 20.5464 | 20.5464 | 14000.0 |
| 2012-06-01 04:40:00 | AAPL | Stock | 20.5143 | 20.5143 | 20.5143 | 20.5143 | 8400.0 |
| 2012-06-01 04:50:00 | AAPL | Stock | 20.5393 | 20.55 | 20.5146 | 20.5146 | 36400.0 |
| 2012-06-01 04:55:00 | AAPL | Stock | 20.5393 | 20.5393 | 20.5393 | 20.5393 | 14000.0 |
| 2012-06-01 05:00:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.5 | 20.5 | 38388.0 |
| 2012-06-01 05:05:00 | AAPL | Stock | 20.4929 | 20.4929 | 20.4929 | 20.4929 | 3108.0 |
| 2012-06-01 05:20:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4682 | 20.4821 | 8400.0 |
| 2012-06-01 05:35:00 | AAPL | Stock | 20.4682 | 20.4682 | 20.4682 | 20.4682 | 5600.0 |
| 2012-06-01 05:45:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4643 | 20.4643 | 2800.0 |
| 2012-06-01 06:25:00 | AAPL | Stock | 20.4329 | 20.4329 | 20.4286 | 20.4289 | 28000.0 |
| 2012-06-01 06:30:00 | AAPL | Stock | 20.4607 | 20.4607 | 20.4607 | 20.4607 | 2800.0 |
| 2012-06-01 06:50:00 | AAPL | Stock | 20.4304 | 20.4304 | 20.4286 | 20.4286 | 5600.0 |
| 2012-06-01 06:55:00 | AAPL | Stock | 20.4357 | 20.4357 | 20.4357 | 20.4357 | 2800.0 |
| 2012-06-01 07:00:00 | AAPL | Stock | 20.4357 | 20.4418 | 20.4018 | 20.4196 | 22400.0 |
| 2012-06-01 07:05:00 | AAPL | Stock | 20.4286 | 20.4436 | 20.4261 | 20.4436 | 28000.0 |
| 2012-06-01 07:10:00 | AAPL | Stock | 20.4429 | 20.4604 | 20.4379 | 20.4386 | 28588.0 |
| 2012-06-01 07:15:00 | AAPL | Stock | 20.4464 | 20.4729 | 20.4464 | 20.4607 | 53200.0 |
| 2012-06-01 07:20:00 | AAPL | Stock | 20.4579 | 20.4643 | 20.4579 | 20.4643 | 8400.0 |
| 2012-06-01 07:25:00 | AAPL | Stock | 20.4525 | 20.4739 | 20.4525 | 20.4643 | 72800.0 |
| 2012-06-01 07:30:00 | AAPL | Stock | 20.4625 | 20.4643 | 20.4479 | 20.4479 | 33600.0 |
| 2012-06-01 07:35:00 | AAPL | Stock | 20.4536 | 20.4536 | 20.4479 | 20.4479 | 39200.0 |
| 2012-06-01 07:40:00 | AAPL | Stock | 20.4486 | 20.4543 | 20.4357 | 20.4357 | 34188.0 |
| 2012-06-01 07:45:00 | AAPL | Stock | 20.44 | 20.4482 | 20.44 | 20.4482 | 5600.0 |
| 2012-06-01 07:50:00 | AAPL | Stock | 20.4536 | 20.4564 | 20.4504 | 20.4504 | 11200.0 |
| 2012-06-01 07:55:00 | AAPL | Stock | 20.4493 | 20.4511 | 20.4439 | 20.4511 | 39200.0 |
| 2012-06-01 08:00:00 | AAPL | Stock | 20.4268 | 20.4867 | 20.4107 | 20.44 | 261128.0 |
| 2012-06-01 08:05:00 | AAPL | Stock | 20.4404 | 20.4439 | 20.4304 | 20.4375 | 120400.0 |
| 2012-06-01 08:10:00 | AAPL | Stock | 20.4425 | 20.4536 | 20.4411 | 20.4536 | 108360.0 |
| 2012-06-01 08:15:00 | AAPL | Stock | 20.4514 | 20.4682 | 20.4464 | 20.4607 | 189000.0 |
| 2012-06-01 08:20:00 | AAPL | Stock | 20.4571 | 20.4636 | 20.4461 | 20.4604 | 209972.0 |
| 2012-06-01 08:25:00 | AAPL | Stock | 20.4593 | 20.4764 | 20.4561 | 20.4639 | 207200.0 |
| 2012-06-01 08:30:00 | AAPL | Stock | 20.4536 | 20.4554 | 20.295 | 20.36 | 2328732.0 |
| 2012-06-01 08:35:00 | AAPL | Stock | 20.3636 | 20.3643 | 20.3089 | 20.3321 | 960792.0 |
| 2012-06-01 08:40:00 | AAPL | Stock | 20.3393 | 20.3514 | 20.3307 | 20.3393 | 341012.0 |
| 2012-06-01 08:45:00 | AAPL | Stock | 20.3457 | 20.3479 | 20.2911 | 20.3107 | 778680.0 |
| 2012-06-01 08:50:00 | AAPL | Stock | 20.32 | 20.3393 | 20.3129 | 20.3393 | 373744.0 |
| 2012-06-01 08:55:00 | AAPL | Stock | 20.3393 | 20.3532 | 20.3357 | 20.3532 | 714028.0 |
| 2012-06-01 09:00:00 | AAPL | Stock | 20.3536 | 20.3689 | 20.3304 | 20.3375 | 610372.0 |
| 2012-06-01 09:05:00 | AAPL | Stock | 20.3389 | 20.3443 | 20.2961 | 20.2968 | 548940.0 |
| 2012-06-01 09:10:00 | AAPL | Stock | 20.2993 | 20.3139 | 20.2886 | 20.2886 | 564368.0 |
| 2012-06-01 09:15:00 | AAPL | Stock | 20.2886 | 20.29 | 20.2575 | 20.2657 | 1259664.0 |
| 2012-06-01 09:20:00 | AAPL | Stock | 20.2657 | 20.3443 | 20.2579 | 20.3218 | 1148728.0 |
| 2012-06-01 09:25:00 | AAPL | Stock | 20.3393 | 20.3661 | 20.305 | 20.3254 | 1411256.0 |
| 2012-06-01 09:30:00 | AAPL | Stock | 20.3214 | 20.4029 | 20.2857 | 20.3989 | 19836656.0 |
| 2012-06-01 09:35:00 | AAPL | Stock | 20.3957 | 20.4071 | 20.3339 | 20.3723 | 15268540.0 |
| 2012-06-01 09:40:00 | AAPL | Stock | 20.3721 | 20.3725 | 20.3254 | 20.3539 | 9306836.0 |
> showing 50 of 335,282 rows — these rows as CSV