PREVIEW / stock_5min / 2010-04-01
file: by_date/stock_5min/2010/2010-04-01.parquet size: 4.8 MB rows: 333,532 symbols: 3,466
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-04-01 05:00:00 | AAPL | Stock | 8.4021 | 8.4021 | 8.4021 | 8.4021 | 2800.0 |
| 2010-04-01 05:10:00 | AAPL | Stock | 8.4018 | 8.4018 | 8.4018 | 8.4018 | 2800.0 |
| 2010-04-01 05:15:00 | AAPL | Stock | 8.4071 | 8.4071 | 8.4071 | 8.4071 | 2800.0 |
| 2010-04-01 05:20:00 | AAPL | Stock | 8.4275 | 8.4275 | 8.4275 | 8.4275 | 14000.0 |
| 2010-04-01 05:35:00 | AAPL | Stock | 8.4121 | 8.4121 | 8.4121 | 8.4121 | 2800.0 |
| 2010-04-01 05:50:00 | AAPL | Stock | 8.4332 | 8.4368 | 8.4332 | 8.4368 | 28000.0 |
| 2010-04-01 06:25:00 | AAPL | Stock | 8.4354 | 8.4354 | 8.4354 | 8.4354 | 2800.0 |
| 2010-04-01 06:50:00 | AAPL | Stock | 8.435 | 8.435 | 8.435 | 8.435 | 28000.0 |
| 2010-04-01 06:55:00 | AAPL | Stock | 8.4357 | 8.4357 | 8.4357 | 8.4357 | 5600.0 |
| 2010-04-01 07:00:00 | AAPL | Stock | 8.425 | 8.4364 | 8.4236 | 8.4364 | 53200.0 |
| 2010-04-01 07:05:00 | AAPL | Stock | 8.4264 | 8.4318 | 8.4261 | 8.4318 | 11200.0 |
| 2010-04-01 07:10:00 | AAPL | Stock | 8.4179 | 8.4179 | 8.4143 | 8.4143 | 19600.0 |
| 2010-04-01 07:25:00 | AAPL | Stock | 8.43 | 8.43 | 8.43 | 8.43 | 2800.0 |
| 2010-04-01 07:30:00 | AAPL | Stock | 8.4286 | 8.4318 | 8.4286 | 8.4318 | 74900.0 |
| 2010-04-01 07:35:00 | AAPL | Stock | 8.4336 | 8.4454 | 8.4321 | 8.4454 | 44800.0 |
| 2010-04-01 07:40:00 | AAPL | Stock | 8.4454 | 8.4604 | 8.4454 | 8.4571 | 110600.0 |
| 2010-04-01 07:45:00 | AAPL | Stock | 8.4596 | 8.4614 | 8.4596 | 8.4614 | 56364.0 |
| 2010-04-01 07:50:00 | AAPL | Stock | 8.4543 | 8.4614 | 8.4543 | 8.4614 | 16800.0 |
| 2010-04-01 07:55:00 | AAPL | Stock | 8.4561 | 8.4564 | 8.4543 | 8.4543 | 17360.0 |
| 2010-04-01 08:00:00 | AAPL | Stock | 8.46 | 8.4614 | 8.4375 | 8.4396 | 347228.0 |
| 2010-04-01 08:05:00 | AAPL | Stock | 8.4411 | 8.4482 | 8.4404 | 8.4457 | 137816.0 |
| 2010-04-01 08:10:00 | AAPL | Stock | 8.4446 | 8.4607 | 8.4443 | 8.4554 | 285880.0 |
| 2010-04-01 08:15:00 | AAPL | Stock | 8.4554 | 8.4554 | 8.4429 | 8.4429 | 377356.0 |
| 2010-04-01 08:20:00 | AAPL | Stock | 8.4436 | 8.4493 | 8.3929 | 8.4457 | 1731436.0 |
| 2010-04-01 08:25:00 | AAPL | Stock | 8.4464 | 8.4536 | 8.4454 | 8.4536 | 255024.0 |
| 2010-04-01 08:30:00 | AAPL | Stock | 8.4532 | 8.4639 | 8.4532 | 8.4596 | 563304.0 |
| 2010-04-01 08:35:00 | AAPL | Stock | 8.4564 | 8.4696 | 8.4564 | 8.4679 | 798252.0 |
| 2010-04-01 08:40:00 | AAPL | Stock | 8.4693 | 8.4704 | 8.4643 | 8.4696 | 349160.0 |
| 2010-04-01 08:45:00 | AAPL | Stock | 8.4721 | 8.4743 | 8.3929 | 8.4693 | 172396.0 |
| 2010-04-01 08:50:00 | AAPL | Stock | 8.4689 | 8.47 | 8.3929 | 8.465 | 412188.0 |
| 2010-04-01 08:55:00 | AAPL | Stock | 8.4646 | 8.4689 | 8.4643 | 8.4675 | 100968.0 |
| 2010-04-01 09:00:00 | AAPL | Stock | 8.4661 | 8.4679 | 8.4654 | 8.4671 | 91616.0 |
| 2010-04-01 09:05:00 | AAPL | Stock | 8.4671 | 8.4689 | 8.4071 | 8.4689 | 271292.0 |
| 2010-04-01 09:10:00 | AAPL | Stock | 8.4689 | 8.4696 | 8.4668 | 8.4675 | 302932.0 |
| 2010-04-01 09:15:00 | AAPL | Stock | 8.4661 | 8.4679 | 8.4643 | 8.4646 | 75600.0 |
| 2010-04-01 09:20:00 | AAPL | Stock | 8.465 | 8.465 | 8.4611 | 8.4614 | 88200.0 |
| 2010-04-01 09:25:00 | AAPL | Stock | 8.4614 | 8.4821 | 8.4607 | 8.4814 | 745388.0 |
| 2010-04-01 09:30:00 | AAPL | Stock | 8.4796 | 8.5061 | 8.4643 | 8.4968 | 37716616.0 |
| 2010-04-01 09:35:00 | AAPL | Stock | 8.4968 | 8.5261 | 8.4961 | 8.5107 | 25025028.0 |
| 2010-04-01 09:40:00 | AAPL | Stock | 8.5086 | 8.525 | 8.5011 | 8.5107 | 15907388.0 |
| 2010-04-01 09:45:00 | AAPL | Stock | 8.5121 | 8.5242 | 8.5 | 8.5011 | 11515000.0 |
| 2010-04-01 09:50:00 | AAPL | Stock | 8.5 | 8.5046 | 8.4871 | 8.4954 | 13756064.0 |
| 2010-04-01 09:55:00 | AAPL | Stock | 8.4956 | 8.5132 | 8.4921 | 8.5021 | 10555524.0 |
| 2010-04-01 10:00:00 | AAPL | Stock | 8.5018 | 8.5107 | 8.5004 | 8.5043 | 11267900.0 |
| 2010-04-01 10:05:00 | AAPL | Stock | 8.5068 | 8.5086 | 8.4786 | 8.4839 | 11195744.0 |
| 2010-04-01 10:10:00 | AAPL | Stock | 8.4839 | 8.4936 | 8.4821 | 8.4875 | 7340312.0 |
| 2010-04-01 10:15:00 | AAPL | Stock | 8.4875 | 8.4929 | 8.474 | 8.4757 | 7354536.0 |
| 2010-04-01 10:20:00 | AAPL | Stock | 8.4764 | 8.4789 | 8.4586 | 8.4682 | 10356444.0 |
| 2010-04-01 10:25:00 | AAPL | Stock | 8.4682 | 8.4786 | 8.465 | 8.4786 | 4606448.0 |
| 2010-04-01 10:30:00 | AAPL | Stock | 8.4786 | 8.4854 | 8.4739 | 8.4743 | 5287212.0 |
> showing 50 of 333,532 rows — these rows as CSV