PREVIEW / stock_5min / 2013-05-07
file: by_date/stock_5min/2013/2013-05-07.parquet size: 5.1 MB rows: 335,988 symbols: 3,510
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-05-07 04:00:00 | AAPL | Stock | 16.5239 | 16.5239 | 16.5239 | 16.5239 | 16800.0 |
| 2013-05-07 04:10:00 | AAPL | Stock | 16.5179 | 16.5179 | 16.5179 | 16.5179 | 11508.0 |
| 2013-05-07 04:20:00 | AAPL | Stock | 16.5118 | 16.5118 | 16.5118 | 16.5118 | 2800.0 |
| 2013-05-07 04:25:00 | AAPL | Stock | 16.5118 | 16.5118 | 16.5118 | 16.5118 | 2800.0 |
| 2013-05-07 04:30:00 | AAPL | Stock | 16.5239 | 16.5239 | 16.5239 | 16.5239 | 5600.0 |
| 2013-05-07 04:35:00 | AAPL | Stock | 16.5175 | 16.5175 | 16.5175 | 16.5175 | 5236.0 |
| 2013-05-07 04:45:00 | AAPL | Stock | 16.5239 | 16.5239 | 16.4957 | 16.5071 | 13664.0 |
| 2013-05-07 05:25:00 | AAPL | Stock | 16.5139 | 16.5139 | 16.5139 | 16.5139 | 2800.0 |
| 2013-05-07 05:30:00 | AAPL | Stock | 16.5143 | 16.5168 | 16.5143 | 16.5168 | 8400.0 |
| 2013-05-07 06:10:00 | AAPL | Stock | 16.5232 | 16.5232 | 16.5232 | 16.5232 | 5600.0 |
| 2013-05-07 06:15:00 | AAPL | Stock | 16.52 | 16.5396 | 16.52 | 16.5396 | 6272.0 |
| 2013-05-07 06:20:00 | AAPL | Stock | 16.5475 | 16.5475 | 16.5475 | 16.5475 | 3780.0 |
| 2013-05-07 06:25:00 | AAPL | Stock | 16.5379 | 16.5379 | 16.5379 | 16.5379 | 2800.0 |
| 2013-05-07 06:30:00 | AAPL | Stock | 16.5443 | 16.5496 | 16.5443 | 16.5496 | 5600.0 |
| 2013-05-07 06:50:00 | AAPL | Stock | 16.5379 | 16.5379 | 16.5379 | 16.5379 | 2800.0 |
| 2013-05-07 06:55:00 | AAPL | Stock | 16.5232 | 16.5232 | 16.5232 | 16.5232 | 2800.0 |
| 2013-05-07 07:00:00 | AAPL | Stock | 16.5232 | 16.5518 | 16.5229 | 16.5518 | 103796.0 |
| 2013-05-07 07:05:00 | AAPL | Stock | 16.5629 | 16.575 | 16.5536 | 16.575 | 121520.0 |
| 2013-05-07 07:10:00 | AAPL | Stock | 16.5804 | 16.59 | 16.5804 | 16.5836 | 76860.0 |
| 2013-05-07 07:15:00 | AAPL | Stock | 16.5768 | 16.5964 | 16.5768 | 16.5893 | 48440.0 |
| 2013-05-07 07:20:00 | AAPL | Stock | 16.58 | 16.5964 | 16.58 | 16.5929 | 46312.0 |
| 2013-05-07 07:25:00 | AAPL | Stock | 16.5964 | 16.6071 | 16.5893 | 16.5964 | 57960.0 |
| 2013-05-07 07:30:00 | AAPL | Stock | 16.5954 | 16.5954 | 16.5643 | 16.5643 | 97776.0 |
| 2013-05-07 07:35:00 | AAPL | Stock | 16.5536 | 16.585 | 16.5536 | 16.5846 | 142520.0 |
| 2013-05-07 07:40:00 | AAPL | Stock | 16.5893 | 16.5907 | 16.5854 | 16.5854 | 37716.0 |
| 2013-05-07 07:45:00 | AAPL | Stock | 16.5854 | 16.5854 | 16.56 | 16.5754 | 86632.0 |
| 2013-05-07 07:50:00 | AAPL | Stock | 16.5714 | 16.5854 | 16.5632 | 16.5643 | 107492.0 |
| 2013-05-07 07:55:00 | AAPL | Stock | 16.5718 | 16.5721 | 16.5589 | 16.5689 | 145656.0 |
| 2013-05-07 08:00:00 | AAPL | Stock | 16.5671 | 16.6054 | 16.5218 | 16.5639 | 726040.0 |
| 2013-05-07 08:05:00 | AAPL | Stock | 16.5675 | 16.5857 | 16.5668 | 16.5771 | 250348.0 |
| 2013-05-07 08:10:00 | AAPL | Stock | 16.5804 | 16.5886 | 16.5714 | 16.5804 | 69244.0 |
| 2013-05-07 08:15:00 | AAPL | Stock | 16.5861 | 16.5996 | 16.5836 | 16.5907 | 272356.0 |
| 2013-05-07 08:20:00 | AAPL | Stock | 16.5893 | 16.5921 | 16.5821 | 16.5875 | 147224.0 |
| 2013-05-07 08:25:00 | AAPL | Stock | 16.5893 | 16.5911 | 16.5821 | 16.5857 | 177380.0 |
| 2013-05-07 08:30:00 | AAPL | Stock | 16.5861 | 16.6071 | 16.5846 | 16.6029 | 443744.0 |
| 2013-05-07 08:35:00 | AAPL | Stock | 16.6018 | 16.6175 | 16.6018 | 16.6068 | 383796.0 |
| 2013-05-07 08:40:00 | AAPL | Stock | 16.6064 | 16.6068 | 16.595 | 16.5975 | 165648.0 |
| 2013-05-07 08:45:00 | AAPL | Stock | 16.5982 | 16.6029 | 16.5886 | 16.595 | 476560.0 |
| 2013-05-07 08:50:00 | AAPL | Stock | 16.5975 | 16.5982 | 16.5875 | 16.5946 | 324576.0 |
| 2013-05-07 08:55:00 | AAPL | Stock | 16.595 | 16.6 | 16.5893 | 16.6 | 347116.0 |
| 2013-05-07 09:00:00 | AAPL | Stock | 16.6025 | 16.6136 | 16.5982 | 16.6136 | 355376.0 |
| 2013-05-07 09:05:00 | AAPL | Stock | 16.6132 | 16.6229 | 16.6125 | 16.6154 | 212968.0 |
| 2013-05-07 09:10:00 | AAPL | Stock | 16.6175 | 16.6229 | 16.6125 | 16.6179 | 215040.0 |
| 2013-05-07 09:15:00 | AAPL | Stock | 16.6175 | 16.6214 | 16.6021 | 16.6046 | 442652.0 |
| 2013-05-07 09:20:00 | AAPL | Stock | 16.6046 | 16.6046 | 16.595 | 16.6011 | 551852.0 |
| 2013-05-07 09:25:00 | AAPL | Stock | 16.6043 | 16.625 | 16.5946 | 16.6071 | 1469636.0 |
| 2013-05-07 09:30:00 | AAPL | Stock | 16.6071 | 16.6339 | 16.5525 | 16.5982 | 30449888.0 |
| 2013-05-07 09:35:00 | AAPL | Stock | 16.5986 | 16.6179 | 16.5314 | 16.5315 | 17092880.0 |
| 2013-05-07 09:40:00 | AAPL | Stock | 16.5329 | 16.5564 | 16.4839 | 16.4896 | 18250204.0 |
| 2013-05-07 09:45:00 | AAPL | Stock | 16.4933 | 16.5404 | 16.4896 | 16.5304 | 10687124.0 |
> showing 50 of 335,988 rows — these rows as CSV