PREVIEW / stock_5min / 2014-02-14
file: by_date/stock_5min/2014/2014-02-14.parquet size: 5.4 MB rows: 353,270 symbols: 3,536
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-14 04:05:00 | AAPL | Stock | 19.4432 | 19.4432 | 19.4432 | 19.4432 | 2800.0 |
| 2014-02-14 04:10:00 | AAPL | Stock | 19.4461 | 19.4461 | 19.4461 | 19.4461 | 2800.0 |
| 2014-02-14 06:40:00 | AAPL | Stock | 19.45 | 19.45 | 19.45 | 19.45 | 5600.0 |
| 2014-02-14 06:45:00 | AAPL | Stock | 19.4636 | 19.4636 | 19.4636 | 19.4636 | 2800.0 |
| 2014-02-14 06:50:00 | AAPL | Stock | 19.4711 | 19.4711 | 19.4711 | 19.4711 | 11200.0 |
| 2014-02-14 06:55:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 5600.0 |
| 2014-02-14 07:00:00 | AAPL | Stock | 19.4857 | 19.5357 | 19.4857 | 19.5357 | 38024.0 |
| 2014-02-14 07:05:00 | AAPL | Stock | 19.5357 | 19.5364 | 19.5261 | 19.5261 | 75712.0 |
| 2014-02-14 07:10:00 | AAPL | Stock | 19.52 | 19.52 | 19.4957 | 19.4957 | 49196.0 |
| 2014-02-14 07:20:00 | AAPL | Stock | 19.4993 | 19.5 | 19.4993 | 19.5 | 15400.0 |
| 2014-02-14 07:25:00 | AAPL | Stock | 19.4807 | 19.4807 | 19.4804 | 19.4804 | 5600.0 |
| 2014-02-14 07:30:00 | AAPL | Stock | 19.4807 | 19.4807 | 19.4807 | 19.4807 | 22876.0 |
| 2014-02-14 07:40:00 | AAPL | Stock | 19.4746 | 19.5 | 19.4746 | 19.5 | 66920.0 |
| 2014-02-14 07:45:00 | AAPL | Stock | 19.5071 | 19.5071 | 19.5 | 19.5071 | 40600.0 |
| 2014-02-14 07:50:00 | AAPL | Stock | 19.4982 | 19.4982 | 19.4929 | 19.4929 | 5600.0 |
| 2014-02-14 07:55:00 | AAPL | Stock | 19.4804 | 19.4839 | 19.4732 | 19.4839 | 30800.0 |
| 2014-02-14 08:00:00 | AAPL | Stock | 19.4793 | 19.5493 | 19.4664 | 19.4786 | 272888.0 |
| 2014-02-14 08:05:00 | AAPL | Stock | 19.4864 | 19.4996 | 19.4857 | 19.4929 | 110516.0 |
| 2014-02-14 08:10:00 | AAPL | Stock | 19.4932 | 19.4989 | 19.4932 | 19.4989 | 18564.0 |
| 2014-02-14 08:15:00 | AAPL | Stock | 19.4914 | 19.4979 | 19.4821 | 19.4911 | 88816.0 |
| 2014-02-14 08:20:00 | AAPL | Stock | 19.4821 | 19.4964 | 19.4789 | 19.4957 | 64260.0 |
| 2014-02-14 08:25:00 | AAPL | Stock | 19.4929 | 19.4943 | 19.4768 | 19.4821 | 86632.0 |
| 2014-02-14 08:30:00 | AAPL | Stock | 19.4821 | 19.4911 | 19.4818 | 19.4911 | 77168.0 |
| 2014-02-14 08:35:00 | AAPL | Stock | 19.4911 | 19.4911 | 19.4821 | 19.4825 | 58800.0 |
| 2014-02-14 08:40:00 | AAPL | Stock | 19.4907 | 19.4907 | 19.4771 | 19.4779 | 78400.0 |
| 2014-02-14 08:45:00 | AAPL | Stock | 19.475 | 19.4821 | 19.4739 | 19.4818 | 92400.0 |
| 2014-02-14 08:50:00 | AAPL | Stock | 19.4814 | 19.4814 | 19.47 | 19.4732 | 69720.0 |
| 2014-02-14 08:55:00 | AAPL | Stock | 19.4693 | 19.4736 | 19.4668 | 19.4668 | 46200.0 |
| 2014-02-14 09:05:00 | AAPL | Stock | 19.4679 | 19.4679 | 19.4679 | 19.4679 | 19040.0 |
| 2014-02-14 09:10:00 | AAPL | Stock | 19.4686 | 19.4761 | 19.4539 | 19.4571 | 98504.0 |
| 2014-02-14 09:15:00 | AAPL | Stock | 19.4621 | 19.4629 | 19.4286 | 19.4286 | 242620.0 |
| 2014-02-14 09:20:00 | AAPL | Stock | 19.4221 | 19.4386 | 19.4221 | 19.4318 | 152320.0 |
| 2014-02-14 09:25:00 | AAPL | Stock | 19.4582 | 19.4582 | 19.3589 | 19.37 | 686560.0 |
| 2014-02-14 09:30:00 | AAPL | Stock | 19.3889 | 19.4643 | 19.3682 | 19.4407 | 16450056.0 |
| 2014-02-14 09:35:00 | AAPL | Stock | 19.4408 | 19.4993 | 19.4296 | 19.4993 | 8641528.0 |
| 2014-02-14 09:40:00 | AAPL | Stock | 19.4989 | 19.4989 | 19.3857 | 19.4271 | 8387092.0 |
| 2014-02-14 09:45:00 | AAPL | Stock | 19.4254 | 19.4279 | 19.3782 | 19.3975 | 5285364.0 |
| 2014-02-14 09:50:00 | AAPL | Stock | 19.3982 | 19.4086 | 19.3611 | 19.4032 | 6681864.0 |
| 2014-02-14 09:55:00 | AAPL | Stock | 19.3989 | 19.4579 | 19.3971 | 19.4268 | 6559168.0 |
| 2014-02-14 10:00:00 | AAPL | Stock | 19.4311 | 19.4386 | 19.3889 | 19.3975 | 4056444.0 |
| 2014-02-14 10:05:00 | AAPL | Stock | 19.3975 | 19.4125 | 19.3779 | 19.4064 | 3282664.0 |
| 2014-02-14 10:10:00 | AAPL | Stock | 19.4064 | 19.4582 | 19.4064 | 19.445 | 4691372.0 |
| 2014-02-14 10:15:00 | AAPL | Stock | 19.4429 | 19.4586 | 19.4107 | 19.4232 | 2909004.0 |
| 2014-02-14 10:20:00 | AAPL | Stock | 19.4196 | 19.4525 | 19.4176 | 19.4329 | 1936984.0 |
| 2014-02-14 10:25:00 | AAPL | Stock | 19.43 | 19.4454 | 19.4196 | 19.42 | 2041676.0 |
| 2014-02-14 10:30:00 | AAPL | Stock | 19.4232 | 19.4336 | 19.4075 | 19.4139 | 2316440.0 |
| 2014-02-14 10:35:00 | AAPL | Stock | 19.4129 | 19.4139 | 19.3875 | 19.3897 | 3439688.0 |
| 2014-02-14 10:40:00 | AAPL | Stock | 19.3879 | 19.3929 | 19.3661 | 19.3786 | 7011564.0 |
| 2014-02-14 10:45:00 | AAPL | Stock | 19.3786 | 19.4018 | 19.3679 | 19.3764 | 3673264.0 |
| 2014-02-14 10:50:00 | AAPL | Stock | 19.375 | 19.3782 | 19.3289 | 19.3596 | 5633096.0 |
> showing 50 of 353,270 rows — these rows as CSV