PREVIEW / stock_5min / 2012-03-19
file: by_date/stock_5min/2012/2012-03-19.parquet size: 5.0 MB rows: 335,922 symbols: 3,539
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-03-19 04:00:00 | AAPL | Stock | 21.625 | 21.625 | 21.2321 | 21.3393 | 99176.0 |
| 2012-03-19 04:05:00 | AAPL | Stock | 21.3425 | 21.5 | 21.3425 | 21.4286 | 155736.0 |
| 2012-03-19 04:10:00 | AAPL | Stock | 21.4325 | 21.5357 | 21.4018 | 21.4018 | 218540.0 |
| 2012-03-19 04:15:00 | AAPL | Stock | 21.4286 | 21.4464 | 21.4161 | 21.4286 | 162232.0 |
| 2012-03-19 04:20:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.425 | 21.4286 | 106092.0 |
| 2012-03-19 04:25:00 | AAPL | Stock | 21.425 | 21.4286 | 21.4107 | 21.4107 | 54600.0 |
| 2012-03-19 04:30:00 | AAPL | Stock | 21.4107 | 21.4282 | 21.4071 | 21.4282 | 51800.0 |
| 2012-03-19 04:35:00 | AAPL | Stock | 21.4286 | 21.4286 | 21.4036 | 21.4036 | 80388.0 |
| 2012-03-19 04:40:00 | AAPL | Stock | 21.425 | 21.4286 | 21.425 | 21.4286 | 11200.0 |
| 2012-03-19 04:45:00 | AAPL | Stock | 21.4286 | 21.4375 | 21.4046 | 21.4375 | 44800.0 |
| 2012-03-19 04:50:00 | AAPL | Stock | 21.4375 | 21.4375 | 21.4354 | 21.4354 | 25200.0 |
| 2012-03-19 04:55:00 | AAPL | Stock | 21.4375 | 21.4375 | 21.4339 | 21.4375 | 76776.0 |
| 2012-03-19 05:00:00 | AAPL | Stock | 21.4604 | 21.4625 | 21.4604 | 21.4625 | 14028.0 |
| 2012-03-19 05:05:00 | AAPL | Stock | 21.4429 | 21.4432 | 21.4429 | 21.4429 | 26600.0 |
| 2012-03-19 05:10:00 | AAPL | Stock | 21.4339 | 21.4425 | 21.4321 | 21.4321 | 64400.0 |
| 2012-03-19 05:15:00 | AAPL | Stock | 21.4357 | 21.4607 | 21.4343 | 21.4364 | 39200.0 |
| 2012-03-19 05:20:00 | AAPL | Stock | 21.4571 | 21.4643 | 21.4536 | 21.4643 | 62300.0 |
| 2012-03-19 05:25:00 | AAPL | Stock | 21.4643 | 21.4786 | 21.4518 | 21.4643 | 44464.0 |
| 2012-03-19 05:30:00 | AAPL | Stock | 21.4643 | 21.4643 | 21.45 | 21.4625 | 45920.0 |
| 2012-03-19 05:35:00 | AAPL | Stock | 21.45 | 21.4532 | 21.4286 | 21.4286 | 52808.0 |
| 2012-03-19 05:40:00 | AAPL | Stock | 21.4425 | 21.4429 | 21.4382 | 21.4429 | 22988.0 |
| 2012-03-19 05:45:00 | AAPL | Stock | 21.4464 | 21.4571 | 21.4464 | 21.4486 | 15176.0 |
| 2012-03-19 05:50:00 | AAPL | Stock | 21.4468 | 21.4468 | 21.4468 | 21.4468 | 12600.0 |
| 2012-03-19 05:55:00 | AAPL | Stock | 21.4643 | 21.4643 | 21.4636 | 21.4636 | 36568.0 |
| 2012-03-19 06:00:00 | AAPL | Stock | 21.4643 | 21.4714 | 21.4643 | 21.4643 | 29232.0 |
| 2012-03-19 06:05:00 | AAPL | Stock | 21.4643 | 21.475 | 21.4643 | 21.475 | 8400.0 |
| 2012-03-19 06:10:00 | AAPL | Stock | 21.4732 | 21.5 | 21.4732 | 21.5 | 49000.0 |
| 2012-03-19 06:15:00 | AAPL | Stock | 21.5 | 21.5 | 21.5 | 21.5 | 11200.0 |
| 2012-03-19 06:20:00 | AAPL | Stock | 21.4925 | 21.5357 | 21.4925 | 21.5268 | 44800.0 |
| 2012-03-19 06:30:00 | AAPL | Stock | 21.5357 | 21.5446 | 21.4911 | 21.5357 | 162764.0 |
| 2012-03-19 06:35:00 | AAPL | Stock | 21.5361 | 21.5361 | 21.5361 | 21.5361 | 5600.0 |
| 2012-03-19 06:40:00 | AAPL | Stock | 21.5443 | 21.5714 | 21.5443 | 21.5446 | 132748.0 |
| 2012-03-19 06:45:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.5536 | 21.5536 | 27972.0 |
| 2012-03-19 06:50:00 | AAPL | Stock | 21.5571 | 21.5714 | 21.5536 | 21.5714 | 34916.0 |
| 2012-03-19 06:55:00 | AAPL | Stock | 21.5714 | 21.5714 | 21.4911 | 21.4911 | 129192.0 |
| 2012-03-19 07:00:00 | AAPL | Stock | 21.5536 | 21.6539 | 21.5286 | 21.6286 | 737800.0 |
| 2012-03-19 07:05:00 | AAPL | Stock | 21.6282 | 21.6532 | 21.6107 | 21.6218 | 556416.0 |
| 2012-03-19 07:10:00 | AAPL | Stock | 21.6125 | 21.6321 | 21.595 | 21.6321 | 398748.0 |
| 2012-03-19 07:15:00 | AAPL | Stock | 21.6254 | 21.7068 | 21.6254 | 21.6875 | 1389080.0 |
| 2012-03-19 07:20:00 | AAPL | Stock | 21.7018 | 21.7275 | 21.6436 | 21.6786 | 963088.0 |
| 2012-03-19 07:25:00 | AAPL | Stock | 21.6786 | 21.6786 | 21.5929 | 21.6071 | 584388.0 |
| 2012-03-19 07:30:00 | AAPL | Stock | 21.6068 | 21.6068 | 21.475 | 21.5039 | 1149848.0 |
| 2012-03-19 07:35:00 | AAPL | Stock | 21.5264 | 21.5314 | 21.4696 | 21.4929 | 500668.0 |
| 2012-03-19 07:40:00 | AAPL | Stock | 21.4971 | 21.5 | 21.4375 | 21.4643 | 679588.0 |
| 2012-03-19 07:45:00 | AAPL | Stock | 21.4571 | 21.4643 | 21.4393 | 21.45 | 1247680.0 |
| 2012-03-19 07:50:00 | AAPL | Stock | 21.4568 | 21.4632 | 21.4375 | 21.4375 | 690676.0 |
| 2012-03-19 07:55:00 | AAPL | Stock | 21.4393 | 21.4454 | 21.39 | 21.39 | 695912.0 |
| 2012-03-19 08:00:00 | AAPL | Stock | 21.3929 | 21.6072 | 21.2665 | 21.4614 | 4093964.0 |
| 2012-03-19 08:05:00 | AAPL | Stock | 21.52 | 21.5321 | 21.4768 | 21.4914 | 1376424.0 |
| 2012-03-19 08:10:00 | AAPL | Stock | 21.4921 | 21.5136 | 21.4179 | 21.4289 | 1787268.0 |
> showing 50 of 335,922 rows — these rows as CSV