PREVIEW / stock_5min / 2012-02-27
file: by_date/stock_5min/2012/2012-02-27.parquet size: 4.8 MB rows: 325,637 symbols: 3,532
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-02-27 04:10:00 | AAPL | Stock | 18.5804 | 18.5804 | 18.5804 | 18.5804 | 11200.0 |
| 2012-02-27 04:15:00 | AAPL | Stock | 18.5804 | 18.5804 | 18.5804 | 18.5804 | 19600.0 |
| 2012-02-27 04:20:00 | AAPL | Stock | 18.5804 | 18.5804 | 18.5804 | 18.5804 | 2800.0 |
| 2012-02-27 05:15:00 | AAPL | Stock | 18.5804 | 18.5804 | 18.5804 | 18.5804 | 5600.0 |
| 2012-02-27 05:30:00 | AAPL | Stock | 18.565 | 18.565 | 18.565 | 18.565 | 2800.0 |
| 2012-02-27 05:35:00 | AAPL | Stock | 18.565 | 18.565 | 18.565 | 18.565 | 5600.0 |
| 2012-02-27 05:40:00 | AAPL | Stock | 18.5571 | 18.5571 | 18.5571 | 18.5571 | 2800.0 |
| 2012-02-27 06:20:00 | AAPL | Stock | 18.565 | 18.565 | 18.565 | 18.565 | 5572.0 |
| 2012-02-27 06:25:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2012-02-27 06:40:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 8708.0 |
| 2012-02-27 06:55:00 | AAPL | Stock | 18.5579 | 18.5579 | 18.5571 | 18.5571 | 14000.0 |
| 2012-02-27 07:05:00 | AAPL | Stock | 18.5675 | 18.5675 | 18.5675 | 18.5675 | 2800.0 |
| 2012-02-27 07:10:00 | AAPL | Stock | 18.5761 | 18.6032 | 18.5739 | 18.5739 | 53508.0 |
| 2012-02-27 07:15:00 | AAPL | Stock | 18.5779 | 18.5789 | 18.5779 | 18.5789 | 11200.0 |
| 2012-02-27 07:20:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 9520.0 |
| 2012-02-27 07:25:00 | AAPL | Stock | 18.5732 | 18.5732 | 18.5575 | 18.5643 | 33712.0 |
| 2012-02-27 07:30:00 | AAPL | Stock | 18.5643 | 18.5643 | 18.5643 | 18.5643 | 8400.0 |
| 2012-02-27 07:35:00 | AAPL | Stock | 18.5679 | 18.5732 | 18.5679 | 18.5732 | 5600.0 |
| 2012-02-27 07:40:00 | AAPL | Stock | 18.5732 | 18.5754 | 18.5732 | 18.5754 | 16800.0 |
| 2012-02-27 07:45:00 | AAPL | Stock | 18.5714 | 18.575 | 18.5682 | 18.5696 | 67592.0 |
| 2012-02-27 07:50:00 | AAPL | Stock | 18.5643 | 18.5696 | 18.5571 | 18.5696 | 38724.0 |
| 2012-02-27 07:55:00 | AAPL | Stock | 18.5711 | 18.5711 | 18.5571 | 18.5711 | 69076.0 |
| 2012-02-27 08:00:00 | AAPL | Stock | 18.5714 | 18.6036 | 18.5714 | 18.5911 | 329700.0 |
| 2012-02-27 08:05:00 | AAPL | Stock | 18.5896 | 18.6 | 18.5893 | 18.5936 | 176932.0 |
| 2012-02-27 08:10:00 | AAPL | Stock | 18.5946 | 18.5957 | 18.5807 | 18.5882 | 242928.0 |
| 2012-02-27 08:15:00 | AAPL | Stock | 18.5836 | 18.5982 | 18.5818 | 18.5879 | 92400.0 |
| 2012-02-27 08:20:00 | AAPL | Stock | 18.5914 | 18.5946 | 18.5818 | 18.5889 | 91420.0 |
| 2012-02-27 08:25:00 | AAPL | Stock | 18.5904 | 18.6179 | 18.5904 | 18.6179 | 416220.0 |
| 2012-02-27 08:30:00 | AAPL | Stock | 18.6146 | 18.6361 | 18.6143 | 18.6289 | 361424.0 |
| 2012-02-27 08:35:00 | AAPL | Stock | 18.6307 | 18.6318 | 18.6114 | 18.6218 | 420140.0 |
| 2012-02-27 08:40:00 | AAPL | Stock | 18.6214 | 18.6261 | 18.6107 | 18.6261 | 129276.0 |
| 2012-02-27 08:45:00 | AAPL | Stock | 18.6232 | 18.6318 | 18.6232 | 18.6318 | 115220.0 |
| 2012-02-27 08:50:00 | AAPL | Stock | 18.6321 | 18.6321 | 18.6186 | 18.6229 | 208768.0 |
| 2012-02-27 08:55:00 | AAPL | Stock | 18.625 | 18.6279 | 18.62 | 18.6268 | 81116.0 |
| 2012-02-27 09:00:00 | AAPL | Stock | 18.6318 | 18.6364 | 18.6293 | 18.6329 | 195720.0 |
| 2012-02-27 09:05:00 | AAPL | Stock | 18.6361 | 18.6536 | 18.6346 | 18.6461 | 343952.0 |
| 2012-02-27 09:10:00 | AAPL | Stock | 18.6468 | 18.6489 | 18.6304 | 18.6343 | 305592.0 |
| 2012-02-27 09:15:00 | AAPL | Stock | 18.635 | 18.6364 | 18.6154 | 18.6157 | 137508.0 |
| 2012-02-27 09:20:00 | AAPL | Stock | 18.6207 | 18.625 | 18.6107 | 18.6143 | 207648.0 |
| 2012-02-27 09:25:00 | AAPL | Stock | 18.6136 | 18.6207 | 18.6071 | 18.6207 | 223776.0 |
| 2012-02-27 09:30:00 | AAPL | Stock | 18.6182 | 18.6493 | 18.575 | 18.6071 | 16188368.0 |
| 2012-02-27 09:35:00 | AAPL | Stock | 18.6071 | 18.6193 | 18.5832 | 18.5914 | 9393636.0 |
| 2012-02-27 09:40:00 | AAPL | Stock | 18.5923 | 18.5929 | 18.4521 | 18.4796 | 25366180.0 |
| 2012-02-27 09:45:00 | AAPL | Stock | 18.4786 | 18.4943 | 18.4386 | 18.4823 | 15324260.0 |
| 2012-02-27 09:50:00 | AAPL | Stock | 18.4836 | 18.5179 | 18.4718 | 18.5171 | 11894372.0 |
| 2012-02-27 09:55:00 | AAPL | Stock | 18.5175 | 18.5335 | 18.5029 | 18.5204 | 9041396.0 |
| 2012-02-27 10:00:00 | AAPL | Stock | 18.5179 | 18.5439 | 18.5014 | 18.5179 | 6981184.0 |
| 2012-02-27 10:05:00 | AAPL | Stock | 18.5207 | 18.5625 | 18.5164 | 18.5561 | 8826132.0 |
| 2012-02-27 10:10:00 | AAPL | Stock | 18.5565 | 18.58 | 18.5468 | 18.5654 | 9190720.0 |
| 2012-02-27 10:15:00 | AAPL | Stock | 18.5646 | 18.5732 | 18.5539 | 18.57 | 6278300.0 |
> showing 50 of 325,637 rows — these rows as CSV