PREVIEW / stock_5min / 2010-12-16
file: by_date/stock_5min/2010/2010-12-16.parquet size: 4.9 MB rows: 335,793 symbols: 3,537
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-16 04:55:00 | AAPL | Stock | 11.4579 | 11.4579 | 11.4579 | 11.4579 | 13384.0 |
| 2010-12-16 05:00:00 | AAPL | Stock | 11.4325 | 11.4325 | 11.4325 | 11.4325 | 2800.0 |
| 2010-12-16 05:10:00 | AAPL | Stock | 11.4504 | 11.4607 | 11.4504 | 11.4607 | 8400.0 |
| 2010-12-16 05:15:00 | AAPL | Stock | 11.4614 | 11.4614 | 11.4614 | 11.4614 | 5600.0 |
| 2010-12-16 05:30:00 | AAPL | Stock | 11.4643 | 11.4643 | 11.4643 | 11.4643 | 2800.0 |
| 2010-12-16 05:35:00 | AAPL | Stock | 11.4643 | 11.4643 | 11.4643 | 11.4643 | 11200.0 |
| 2010-12-16 06:00:00 | AAPL | Stock | 11.4682 | 11.4682 | 11.4682 | 11.4682 | 2800.0 |
| 2010-12-16 06:20:00 | AAPL | Stock | 11.4643 | 11.4643 | 11.4643 | 11.4643 | 2800.0 |
| 2010-12-16 06:25:00 | AAPL | Stock | 11.4839 | 11.4839 | 11.4839 | 11.4839 | 2800.0 |
| 2010-12-16 06:50:00 | AAPL | Stock | 11.5171 | 11.5171 | 11.5171 | 11.5171 | 4200.0 |
| 2010-12-16 07:00:00 | AAPL | Stock | 11.4989 | 11.5125 | 11.4989 | 11.5125 | 35000.0 |
| 2010-12-16 07:05:00 | AAPL | Stock | 11.5068 | 11.5068 | 11.5068 | 11.5068 | 5600.0 |
| 2010-12-16 07:10:00 | AAPL | Stock | 11.5036 | 11.5036 | 11.4964 | 11.4964 | 28000.0 |
| 2010-12-16 07:15:00 | AAPL | Stock | 11.4964 | 11.4964 | 11.4957 | 11.4957 | 6888.0 |
| 2010-12-16 07:20:00 | AAPL | Stock | 11.4964 | 11.5014 | 11.4964 | 11.4968 | 14000.0 |
| 2010-12-16 07:25:00 | AAPL | Stock | 11.5018 | 11.5032 | 11.5018 | 11.5018 | 39200.0 |
| 2010-12-16 07:30:00 | AAPL | Stock | 11.5036 | 11.5161 | 11.5036 | 11.5075 | 151340.0 |
| 2010-12-16 07:35:00 | AAPL | Stock | 11.5079 | 11.5121 | 11.5079 | 11.5107 | 30800.0 |
| 2010-12-16 07:40:00 | AAPL | Stock | 11.5054 | 11.5054 | 11.5036 | 11.5036 | 33600.0 |
| 2010-12-16 07:45:00 | AAPL | Stock | 11.5018 | 11.5018 | 11.4918 | 11.4918 | 11200.0 |
| 2010-12-16 07:50:00 | AAPL | Stock | 11.4893 | 11.4993 | 11.4864 | 11.4929 | 238000.0 |
| 2010-12-16 07:55:00 | AAPL | Stock | 11.4932 | 11.5054 | 11.4932 | 11.5054 | 71960.0 |
| 2010-12-16 08:00:00 | AAPL | Stock | 11.5018 | 11.5036 | 11.4825 | 11.4907 | 336532.0 |
| 2010-12-16 08:05:00 | AAPL | Stock | 11.4857 | 11.4889 | 11.4821 | 11.4857 | 163660.0 |
| 2010-12-16 08:10:00 | AAPL | Stock | 11.4857 | 11.4857 | 11.4643 | 11.4657 | 201880.0 |
| 2010-12-16 08:15:00 | AAPL | Stock | 11.4668 | 11.4675 | 11.4564 | 11.4671 | 165424.0 |
| 2010-12-16 08:20:00 | AAPL | Stock | 11.4675 | 11.4839 | 11.4675 | 11.4839 | 332220.0 |
| 2010-12-16 08:25:00 | AAPL | Stock | 11.48 | 11.48 | 11.4775 | 11.4793 | 84644.0 |
| 2010-12-16 08:30:00 | AAPL | Stock | 11.4768 | 11.4811 | 11.475 | 11.4804 | 84168.0 |
| 2010-12-16 08:35:00 | AAPL | Stock | 11.4768 | 11.4893 | 11.4768 | 11.4796 | 236936.0 |
| 2010-12-16 08:40:00 | AAPL | Stock | 11.4771 | 11.4843 | 11.4754 | 11.4804 | 137200.0 |
| 2010-12-16 08:45:00 | AAPL | Stock | 11.4854 | 11.49 | 11.4807 | 11.4889 | 457380.0 |
| 2010-12-16 08:50:00 | AAPL | Stock | 11.4886 | 11.5 | 11.4886 | 11.5 | 351008.0 |
| 2010-12-16 08:55:00 | AAPL | Stock | 11.4975 | 11.5018 | 11.4918 | 11.4918 | 284620.0 |
| 2010-12-16 09:00:00 | AAPL | Stock | 11.4918 | 11.4946 | 11.4879 | 11.4879 | 87080.0 |
| 2010-12-16 09:05:00 | AAPL | Stock | 11.4875 | 11.4882 | 11.4786 | 11.4818 | 201460.0 |
| 2010-12-16 09:10:00 | AAPL | Stock | 11.4782 | 11.4804 | 11.4711 | 11.4711 | 79800.0 |
| 2010-12-16 09:15:00 | AAPL | Stock | 11.4757 | 11.4779 | 11.4714 | 11.4779 | 47600.0 |
| 2010-12-16 09:20:00 | AAPL | Stock | 11.4775 | 11.4779 | 11.4643 | 11.4693 | 166040.0 |
| 2010-12-16 09:25:00 | AAPL | Stock | 11.4696 | 11.4714 | 11.4643 | 11.4661 | 372092.0 |
| 2010-12-16 09:30:00 | AAPL | Stock | 11.4654 | 11.4821 | 11.4429 | 11.4589 | 12320840.0 |
| 2010-12-16 09:35:00 | AAPL | Stock | 11.4582 | 11.4796 | 11.4475 | 11.4643 | 10246180.0 |
| 2010-12-16 09:40:00 | AAPL | Stock | 11.4622 | 11.48 | 11.4607 | 11.4743 | 5461708.0 |
| 2010-12-16 09:45:00 | AAPL | Stock | 11.4743 | 11.4786 | 11.4643 | 11.4671 | 5357856.0 |
| 2010-12-16 09:50:00 | AAPL | Stock | 11.465 | 11.4675 | 11.4496 | 11.4563 | 4789792.0 |
| 2010-12-16 09:55:00 | AAPL | Stock | 11.4557 | 11.4675 | 11.4321 | 11.4325 | 6066032.0 |
| 2010-12-16 10:00:00 | AAPL | Stock | 11.4325 | 11.4693 | 11.4325 | 11.4686 | 9577400.0 |
| 2010-12-16 10:05:00 | AAPL | Stock | 11.4689 | 11.4704 | 11.4518 | 11.4554 | 4082484.0 |
| 2010-12-16 10:10:00 | AAPL | Stock | 11.4568 | 11.4621 | 11.4507 | 11.4601 | 4311748.0 |
| 2010-12-16 10:15:00 | AAPL | Stock | 11.4593 | 11.4618 | 11.4451 | 11.4564 | 3789856.0 |
> showing 50 of 335,793 rows — these rows as CSV