PREVIEW / stock_5min / 2013-11-07
file: by_date/stock_5min/2013/2013-11-07.parquet size: 5.4 MB rows: 352,840 symbols: 3,525
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-11-07 05:50:00 | AAPL | Stock | 18.5386 | 18.5386 | 18.5386 | 18.5386 | 2800.0 |
| 2013-11-07 06:20:00 | AAPL | Stock | 18.5368 | 18.5368 | 18.5368 | 18.5368 | 2800.0 |
| 2013-11-07 06:40:00 | AAPL | Stock | 18.5271 | 18.5271 | 18.5271 | 18.5271 | 2800.0 |
| 2013-11-07 07:00:00 | AAPL | Stock | 18.5571 | 18.6061 | 18.5536 | 18.5536 | 105532.0 |
| 2013-11-07 07:15:00 | AAPL | Stock | 18.5536 | 18.5536 | 18.5536 | 18.5536 | 8400.0 |
| 2013-11-07 07:30:00 | AAPL | Stock | 18.5854 | 18.5854 | 18.5854 | 18.5854 | 2800.0 |
| 2013-11-07 07:35:00 | AAPL | Stock | 18.5857 | 18.5961 | 18.5857 | 18.5961 | 14196.0 |
| 2013-11-07 07:40:00 | AAPL | Stock | 18.5761 | 18.5761 | 18.5714 | 18.5714 | 22820.0 |
| 2013-11-07 07:45:00 | AAPL | Stock | 18.5714 | 18.6107 | 18.5579 | 18.5579 | 93800.0 |
| 2013-11-07 07:50:00 | AAPL | Stock | 18.6068 | 18.6386 | 18.6068 | 18.635 | 42000.0 |
| 2013-11-07 07:55:00 | AAPL | Stock | 18.6389 | 18.6393 | 18.6075 | 18.6304 | 85400.0 |
| 2013-11-07 08:00:00 | AAPL | Stock | 18.62 | 18.6389 | 18.5536 | 18.6339 | 273560.0 |
| 2013-11-07 08:05:00 | AAPL | Stock | 18.6325 | 18.6386 | 18.6214 | 18.6214 | 86408.0 |
| 2013-11-07 08:10:00 | AAPL | Stock | 18.6182 | 18.6229 | 18.6161 | 18.6229 | 26600.0 |
| 2013-11-07 08:15:00 | AAPL | Stock | 18.6239 | 18.6429 | 18.6239 | 18.6425 | 163464.0 |
| 2013-11-07 08:20:00 | AAPL | Stock | 18.6261 | 18.6361 | 18.6214 | 18.6346 | 56140.0 |
| 2013-11-07 08:25:00 | AAPL | Stock | 18.6321 | 18.6321 | 18.6175 | 18.6211 | 86100.0 |
| 2013-11-07 08:30:00 | AAPL | Stock | 18.6211 | 18.6518 | 18.6075 | 18.6518 | 539168.0 |
| 2013-11-07 08:35:00 | AAPL | Stock | 18.6429 | 18.6432 | 18.6279 | 18.6389 | 171080.0 |
| 2013-11-07 08:40:00 | AAPL | Stock | 18.6339 | 18.6339 | 18.6071 | 18.6071 | 89600.0 |
| 2013-11-07 08:45:00 | AAPL | Stock | 18.6071 | 18.6161 | 18.6 | 18.6129 | 128604.0 |
| 2013-11-07 08:50:00 | AAPL | Stock | 18.61 | 18.6214 | 18.5954 | 18.5964 | 134456.0 |
| 2013-11-07 08:55:00 | AAPL | Stock | 18.5911 | 18.6032 | 18.5911 | 18.6032 | 46200.0 |
| 2013-11-07 09:00:00 | AAPL | Stock | 18.5932 | 18.6139 | 18.5932 | 18.6107 | 147252.0 |
| 2013-11-07 09:05:00 | AAPL | Stock | 18.6079 | 18.6079 | 18.595 | 18.6025 | 55720.0 |
| 2013-11-07 09:10:00 | AAPL | Stock | 18.6029 | 18.6036 | 18.5932 | 18.6029 | 72800.0 |
| 2013-11-07 09:15:00 | AAPL | Stock | 18.5975 | 18.6043 | 18.5975 | 18.5986 | 114884.0 |
| 2013-11-07 09:20:00 | AAPL | Stock | 18.5925 | 18.5968 | 18.5796 | 18.5796 | 43988.0 |
| 2013-11-07 09:25:00 | AAPL | Stock | 18.58 | 18.5893 | 18.5436 | 18.5636 | 261184.0 |
| 2013-11-07 09:30:00 | AAPL | Stock | 18.5564 | 18.6239 | 18.5396 | 18.5899 | 12258652.0 |
| 2013-11-07 09:35:00 | AAPL | Stock | 18.5839 | 18.6321 | 18.5593 | 18.6214 | 5115264.0 |
| 2013-11-07 09:40:00 | AAPL | Stock | 18.6214 | 18.6786 | 18.6204 | 18.6725 | 8292424.0 |
| 2013-11-07 09:45:00 | AAPL | Stock | 18.6729 | 18.6854 | 18.6557 | 18.6618 | 5797204.0 |
| 2013-11-07 09:50:00 | AAPL | Stock | 18.6675 | 18.6675 | 18.5982 | 18.64 | 6521872.0 |
| 2013-11-07 09:55:00 | AAPL | Stock | 18.6364 | 18.6461 | 18.6093 | 18.6261 | 2964304.0 |
| 2013-11-07 10:00:00 | AAPL | Stock | 18.6314 | 18.6329 | 18.5779 | 18.5918 | 3675700.0 |
| 2013-11-07 10:05:00 | AAPL | Stock | 18.5889 | 18.6043 | 18.5732 | 18.5789 | 6019804.0 |
| 2013-11-07 10:10:00 | AAPL | Stock | 18.5871 | 18.5875 | 18.5186 | 18.541 | 8223152.0 |
| 2013-11-07 10:15:00 | AAPL | Stock | 18.5396 | 18.5618 | 18.5011 | 18.5186 | 3972388.0 |
| 2013-11-07 10:20:00 | AAPL | Stock | 18.5179 | 18.5457 | 18.4932 | 18.5346 | 7827652.0 |
| 2013-11-07 10:25:00 | AAPL | Stock | 18.5375 | 18.56 | 18.5293 | 18.5293 | 3080280.0 |
| 2013-11-07 10:30:00 | AAPL | Stock | 18.5296 | 18.5493 | 18.4964 | 18.5034 | 3010168.0 |
| 2013-11-07 10:35:00 | AAPL | Stock | 18.5025 | 18.5062 | 18.4768 | 18.4868 | 4783072.0 |
| 2013-11-07 10:40:00 | AAPL | Stock | 18.4876 | 18.5268 | 18.4863 | 18.5257 | 4817764.0 |
| 2013-11-07 10:45:00 | AAPL | Stock | 18.5268 | 18.5589 | 18.5186 | 18.5394 | 3361624.0 |
| 2013-11-07 10:50:00 | AAPL | Stock | 18.5282 | 18.5864 | 18.5282 | 18.5814 | 4567640.0 |
| 2013-11-07 10:55:00 | AAPL | Stock | 18.5823 | 18.5857 | 18.5136 | 18.5221 | 2543632.0 |
| 2013-11-07 11:00:00 | AAPL | Stock | 18.5218 | 18.5264 | 18.4882 | 18.525 | 2766288.0 |
| 2013-11-07 11:05:00 | AAPL | Stock | 18.5204 | 18.5464 | 18.5204 | 18.5251 | 2598512.0 |
| 2013-11-07 11:10:00 | AAPL | Stock | 18.5279 | 18.5404 | 18.5046 | 18.5136 | 4167576.0 |
> showing 50 of 352,840 rows — these rows as CSV