PREVIEW / stock_5min / 2013-03-25
file: by_date/stock_5min/2013/2013-03-25.parquet size: 5.0 MB rows: 331,663 symbols: 3,481
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-03-25 04:00:00 | AAPL | Stock | 16.6071 | 16.6429 | 16.5943 | 16.6429 | 25116.0 |
| 2013-03-25 04:55:00 | AAPL | Stock | 16.5857 | 16.5857 | 16.5857 | 16.5857 | 2800.0 |
| 2013-03-25 05:00:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 8400.0 |
| 2013-03-25 05:15:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 19600.0 |
| 2013-03-25 05:20:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 8400.0 |
| 2013-03-25 05:35:00 | AAPL | Stock | 16.6746 | 16.6746 | 16.6746 | 16.6746 | 2884.0 |
| 2013-03-25 05:55:00 | AAPL | Stock | 16.675 | 16.675 | 16.675 | 16.675 | 12432.0 |
| 2013-03-25 06:00:00 | AAPL | Stock | 16.675 | 16.675 | 16.675 | 16.675 | 14000.0 |
| 2013-03-25 06:05:00 | AAPL | Stock | 16.6786 | 16.6786 | 16.6539 | 16.6546 | 58324.0 |
| 2013-03-25 06:15:00 | AAPL | Stock | 16.6521 | 16.6521 | 16.6521 | 16.6521 | 2800.0 |
| 2013-03-25 06:25:00 | AAPL | Stock | 16.6429 | 16.6429 | 16.6429 | 16.6429 | 2800.0 |
| 2013-03-25 06:30:00 | AAPL | Stock | 16.6429 | 16.6429 | 16.625 | 16.625 | 72324.0 |
| 2013-03-25 06:35:00 | AAPL | Stock | 16.625 | 16.625 | 16.625 | 16.625 | 16800.0 |
| 2013-03-25 06:40:00 | AAPL | Stock | 16.6379 | 16.6518 | 16.6161 | 16.6161 | 25928.0 |
| 2013-03-25 06:45:00 | AAPL | Stock | 16.6071 | 16.6429 | 16.6071 | 16.6429 | 57120.0 |
| 2013-03-25 06:50:00 | AAPL | Stock | 16.6211 | 16.6246 | 16.5468 | 16.595 | 39704.0 |
| 2013-03-25 06:55:00 | AAPL | Stock | 16.6018 | 16.6171 | 16.6018 | 16.6171 | 11200.0 |
| 2013-03-25 07:00:00 | AAPL | Stock | 16.5946 | 16.6054 | 16.5579 | 16.5993 | 91476.0 |
| 2013-03-25 07:05:00 | AAPL | Stock | 16.5825 | 16.5975 | 16.5804 | 16.5893 | 44800.0 |
| 2013-03-25 07:10:00 | AAPL | Stock | 16.5893 | 16.5982 | 16.5861 | 16.5896 | 116760.0 |
| 2013-03-25 07:15:00 | AAPL | Stock | 16.5907 | 16.5982 | 16.5896 | 16.5896 | 51996.0 |
| 2013-03-25 07:20:00 | AAPL | Stock | 16.5896 | 16.5896 | 16.5832 | 16.5896 | 19600.0 |
| 2013-03-25 07:25:00 | AAPL | Stock | 16.5861 | 16.59 | 16.5832 | 16.59 | 63952.0 |
| 2013-03-25 07:30:00 | AAPL | Stock | 16.5921 | 16.6032 | 16.5921 | 16.6 | 144704.0 |
| 2013-03-25 07:35:00 | AAPL | Stock | 16.5964 | 16.6314 | 16.5964 | 16.6314 | 345800.0 |
| 2013-03-25 07:40:00 | AAPL | Stock | 16.6354 | 16.6518 | 16.6314 | 16.6343 | 435204.0 |
| 2013-03-25 07:45:00 | AAPL | Stock | 16.6407 | 16.6429 | 16.6393 | 16.6411 | 37576.0 |
| 2013-03-25 07:50:00 | AAPL | Stock | 16.6371 | 16.6375 | 16.6364 | 16.6375 | 34636.0 |
| 2013-03-25 07:55:00 | AAPL | Stock | 16.635 | 16.6404 | 16.6296 | 16.6389 | 136696.0 |
| 2013-03-25 08:00:00 | AAPL | Stock | 16.6386 | 16.6429 | 16.4286 | 16.6193 | 579936.0 |
| 2013-03-25 08:05:00 | AAPL | Stock | 16.6175 | 16.6339 | 16.6175 | 16.6321 | 198296.0 |
| 2013-03-25 08:10:00 | AAPL | Stock | 16.63 | 16.6307 | 16.6179 | 16.6254 | 216552.0 |
| 2013-03-25 08:15:00 | AAPL | Stock | 16.6336 | 16.6346 | 16.6254 | 16.6268 | 110096.0 |
| 2013-03-25 08:20:00 | AAPL | Stock | 16.6311 | 16.6411 | 16.6304 | 16.6364 | 258692.0 |
| 2013-03-25 08:25:00 | AAPL | Stock | 16.6371 | 16.6407 | 16.6304 | 16.6407 | 183708.0 |
| 2013-03-25 08:30:00 | AAPL | Stock | 16.6411 | 16.6414 | 16.6254 | 16.6336 | 283388.0 |
| 2013-03-25 08:35:00 | AAPL | Stock | 16.6286 | 16.6321 | 16.6268 | 16.6321 | 85120.0 |
| 2013-03-25 08:40:00 | AAPL | Stock | 16.6304 | 16.6321 | 16.5893 | 16.5893 | 1178828.0 |
| 2013-03-25 08:45:00 | AAPL | Stock | 16.5875 | 16.5929 | 16.5786 | 16.5868 | 444052.0 |
| 2013-03-25 08:50:00 | AAPL | Stock | 16.5857 | 16.5896 | 16.5714 | 16.5714 | 269248.0 |
| 2013-03-25 08:55:00 | AAPL | Stock | 16.5714 | 16.5768 | 16.5536 | 16.5571 | 387212.0 |
| 2013-03-25 09:00:00 | AAPL | Stock | 16.5621 | 16.5639 | 16.5404 | 16.5629 | 479248.0 |
| 2013-03-25 09:05:00 | AAPL | Stock | 16.5575 | 16.5639 | 16.5389 | 16.545 | 228676.0 |
| 2013-03-25 09:10:00 | AAPL | Stock | 16.5432 | 16.5489 | 16.5321 | 16.5489 | 317632.0 |
| 2013-03-25 09:15:00 | AAPL | Stock | 16.5475 | 16.5743 | 16.5475 | 16.5604 | 460684.0 |
| 2013-03-25 09:20:00 | AAPL | Stock | 16.5679 | 16.5786 | 16.5536 | 16.57 | 474404.0 |
| 2013-03-25 09:25:00 | AAPL | Stock | 16.5696 | 16.6029 | 16.5696 | 16.5929 | 1665188.0 |
| 2013-03-25 09:30:00 | AAPL | Stock | 16.5918 | 16.6204 | 16.5718 | 16.6029 | 25629912.0 |
| 2013-03-25 09:35:00 | AAPL | Stock | 16.6069 | 16.6768 | 16.5979 | 16.6746 | 16970940.0 |
| 2013-03-25 09:40:00 | AAPL | Stock | 16.6754 | 16.7036 | 16.6496 | 16.7007 | 13155688.0 |
> showing 50 of 331,663 rows — these rows as CSV