PREVIEW / stock_5min / 2012-08-24
file: by_date/stock_5min/2012/2012-08-24.parquet size: 4.5 MB rows: 304,688 symbols: 3,445
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-08-24 04:00:00 | AAPL | Stock | 23.6786 | 23.6786 | 23.6786 | 23.6786 | 2800.0 |
| 2012-08-24 04:15:00 | AAPL | Stock | 23.5939 | 23.5939 | 23.5939 | 23.5939 | 8400.0 |
| 2012-08-24 06:15:00 | AAPL | Stock | 23.625 | 23.625 | 23.625 | 23.625 | 2800.0 |
| 2012-08-24 06:25:00 | AAPL | Stock | 23.6 | 23.6079 | 23.5929 | 23.6079 | 14000.0 |
| 2012-08-24 07:00:00 | AAPL | Stock | 23.625 | 23.625 | 23.6071 | 23.6071 | 43120.0 |
| 2012-08-24 07:05:00 | AAPL | Stock | 23.595 | 23.595 | 23.5929 | 23.5929 | 8680.0 |
| 2012-08-24 07:10:00 | AAPL | Stock | 23.6011 | 23.6011 | 23.6011 | 23.6011 | 2800.0 |
| 2012-08-24 07:15:00 | AAPL | Stock | 23.6293 | 23.6429 | 23.6293 | 23.6429 | 20160.0 |
| 2012-08-24 07:20:00 | AAPL | Stock | 23.6318 | 23.6318 | 23.5893 | 23.5893 | 19600.0 |
| 2012-08-24 07:25:00 | AAPL | Stock | 23.5843 | 23.5843 | 23.5361 | 23.5361 | 75544.0 |
| 2012-08-24 07:30:00 | AAPL | Stock | 23.525 | 23.5293 | 23.525 | 23.5293 | 8400.0 |
| 2012-08-24 07:35:00 | AAPL | Stock | 23.5461 | 23.5461 | 23.5461 | 23.5461 | 8400.0 |
| 2012-08-24 07:40:00 | AAPL | Stock | 23.5454 | 23.6071 | 23.5454 | 23.6071 | 63420.0 |
| 2012-08-24 07:45:00 | AAPL | Stock | 23.6068 | 23.6214 | 23.6068 | 23.6125 | 43148.0 |
| 2012-08-24 07:50:00 | AAPL | Stock | 23.6321 | 23.6393 | 23.6289 | 23.6393 | 26600.0 |
| 2012-08-24 07:55:00 | AAPL | Stock | 23.6525 | 23.6525 | 23.6289 | 23.6339 | 56616.0 |
| 2012-08-24 08:00:00 | AAPL | Stock | 23.6261 | 23.6429 | 23.5357 | 23.6 | 148624.0 |
| 2012-08-24 08:05:00 | AAPL | Stock | 23.6061 | 23.6061 | 23.5836 | 23.5929 | 63140.0 |
| 2012-08-24 08:10:00 | AAPL | Stock | 23.5964 | 23.6521 | 23.5964 | 23.6521 | 200564.0 |
| 2012-08-24 08:15:00 | AAPL | Stock | 23.6179 | 23.6521 | 23.6075 | 23.6179 | 48692.0 |
| 2012-08-24 08:20:00 | AAPL | Stock | 23.6232 | 23.6321 | 23.6221 | 23.625 | 39480.0 |
| 2012-08-24 08:25:00 | AAPL | Stock | 23.625 | 23.6314 | 23.6057 | 23.6057 | 201208.0 |
| 2012-08-24 08:30:00 | AAPL | Stock | 23.6004 | 23.6304 | 23.6 | 23.6304 | 278768.0 |
| 2012-08-24 08:35:00 | AAPL | Stock | 23.6286 | 23.6389 | 23.6121 | 23.6121 | 356300.0 |
| 2012-08-24 08:40:00 | AAPL | Stock | 23.6129 | 23.6229 | 23.5714 | 23.5814 | 764064.0 |
| 2012-08-24 08:45:00 | AAPL | Stock | 23.5939 | 23.5993 | 23.5807 | 23.5807 | 184296.0 |
| 2012-08-24 08:50:00 | AAPL | Stock | 23.5804 | 23.5804 | 23.5357 | 23.5357 | 247632.0 |
| 2012-08-24 08:55:00 | AAPL | Stock | 23.5357 | 23.5446 | 23.5296 | 23.5307 | 268352.0 |
| 2012-08-24 09:00:00 | AAPL | Stock | 23.5389 | 23.5446 | 23.5336 | 23.5429 | 158508.0 |
| 2012-08-24 09:05:00 | AAPL | Stock | 23.5429 | 23.5636 | 23.5429 | 23.5625 | 47824.0 |
| 2012-08-24 09:10:00 | AAPL | Stock | 23.5607 | 23.5796 | 23.5536 | 23.5786 | 147560.0 |
| 2012-08-24 09:15:00 | AAPL | Stock | 23.5721 | 23.5829 | 23.5679 | 23.5829 | 40880.0 |
| 2012-08-24 09:20:00 | AAPL | Stock | 23.5832 | 23.5875 | 23.5679 | 23.5679 | 288260.0 |
| 2012-08-24 09:25:00 | AAPL | Stock | 23.5714 | 23.5714 | 23.5518 | 23.5607 | 560840.0 |
| 2012-08-24 09:30:00 | AAPL | Stock | 23.5614 | 23.6139 | 23.5054 | 23.5214 | 18732560.0 |
| 2012-08-24 09:35:00 | AAPL | Stock | 23.5232 | 23.5357 | 23.4397 | 23.445 | 17300724.0 |
| 2012-08-24 09:40:00 | AAPL | Stock | 23.4421 | 23.4654 | 23.4125 | 23.4651 | 14271964.0 |
| 2012-08-24 09:45:00 | AAPL | Stock | 23.4627 | 23.5414 | 23.4607 | 23.5229 | 10569664.0 |
| 2012-08-24 09:50:00 | AAPL | Stock | 23.5289 | 23.56 | 23.5036 | 23.5161 | 7971404.0 |
| 2012-08-24 09:55:00 | AAPL | Stock | 23.5125 | 23.515 | 23.4693 | 23.4893 | 5613328.0 |
| 2012-08-24 10:00:00 | AAPL | Stock | 23.4896 | 23.5482 | 23.4804 | 23.5296 | 7241976.0 |
| 2012-08-24 10:05:00 | AAPL | Stock | 23.5339 | 23.5593 | 23.5218 | 23.5525 | 3757264.0 |
| 2012-08-24 10:10:00 | AAPL | Stock | 23.5561 | 23.5943 | 23.5357 | 23.5596 | 7662452.0 |
| 2012-08-24 10:15:00 | AAPL | Stock | 23.5624 | 23.5975 | 23.5589 | 23.5854 | 4801748.0 |
| 2012-08-24 10:20:00 | AAPL | Stock | 23.5854 | 23.6571 | 23.58 | 23.6254 | 9942212.0 |
| 2012-08-24 10:25:00 | AAPL | Stock | 23.6268 | 23.6896 | 23.6179 | 23.6763 | 8044428.0 |
| 2012-08-24 10:30:00 | AAPL | Stock | 23.6736 | 23.7021 | 23.6464 | 23.6936 | 6620124.0 |
| 2012-08-24 10:35:00 | AAPL | Stock | 23.696 | 23.7671 | 23.6825 | 23.7586 | 12827024.0 |
| 2012-08-24 10:40:00 | AAPL | Stock | 23.7583 | 23.7886 | 23.7454 | 23.7661 | 10792292.0 |
| 2012-08-24 10:45:00 | AAPL | Stock | 23.7696 | 23.77 | 23.7236 | 23.7311 | 5908308.0 |
> showing 50 of 304,688 rows — these rows as CSV