PREVIEW / stock_5min / 2010-03-03
file: by_date/stock_5min/2010/2010-03-03.parquet size: 4.7 MB rows: 328,158 symbols: 3,470
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-03-03 04:30:00 | AAPL | Stock | 7.445 | 7.445 | 7.445 | 7.445 | 2800.0 |
| 2010-03-03 05:20:00 | AAPL | Stock | 7.4436 | 7.4436 | 7.4436 | 7.4436 | 5600.0 |
| 2010-03-03 07:05:00 | AAPL | Stock | 7.4589 | 7.4589 | 7.4589 | 7.4589 | 2800.0 |
| 2010-03-03 07:30:00 | AAPL | Stock | 7.4464 | 7.4464 | 7.4464 | 7.4464 | 30800.0 |
| 2010-03-03 07:35:00 | AAPL | Stock | 7.4436 | 7.4436 | 7.4357 | 7.4357 | 64400.0 |
| 2010-03-03 07:40:00 | AAPL | Stock | 7.4339 | 7.4339 | 7.4339 | 7.4339 | 5600.0 |
| 2010-03-03 07:55:00 | AAPL | Stock | 7.4339 | 7.4339 | 7.4339 | 7.4339 | 2800.0 |
| 2010-03-03 08:00:00 | AAPL | Stock | 7.4421 | 7.4421 | 7.4321 | 7.4375 | 91700.0 |
| 2010-03-03 08:05:00 | AAPL | Stock | 7.4375 | 7.4375 | 7.4321 | 7.4343 | 101976.0 |
| 2010-03-03 08:10:00 | AAPL | Stock | 7.4375 | 7.4411 | 7.4364 | 7.4364 | 63700.0 |
| 2010-03-03 08:15:00 | AAPL | Stock | 7.4411 | 7.4529 | 7.4411 | 7.45 | 243880.0 |
| 2010-03-03 08:20:00 | AAPL | Stock | 7.4464 | 7.4482 | 7.4429 | 7.4464 | 81172.0 |
| 2010-03-03 08:25:00 | AAPL | Stock | 7.4491 | 7.4568 | 7.4482 | 7.4568 | 72128.0 |
| 2010-03-03 08:30:00 | AAPL | Stock | 7.4571 | 7.4571 | 7.4536 | 7.4554 | 99260.0 |
| 2010-03-03 08:35:00 | AAPL | Stock | 7.4536 | 7.4614 | 7.4536 | 7.4593 | 143164.0 |
| 2010-03-03 08:40:00 | AAPL | Stock | 7.4605 | 7.4782 | 7.4605 | 7.4771 | 368228.0 |
| 2010-03-03 08:45:00 | AAPL | Stock | 7.475 | 7.4768 | 7.4696 | 7.4729 | 176820.0 |
| 2010-03-03 08:50:00 | AAPL | Stock | 7.4732 | 7.4732 | 7.4646 | 7.4714 | 99988.0 |
| 2010-03-03 08:55:00 | AAPL | Stock | 7.4732 | 7.475 | 7.4675 | 7.4709 | 118580.0 |
| 2010-03-03 09:00:00 | AAPL | Stock | 7.4661 | 7.4704 | 7.465 | 7.47 | 86884.0 |
| 2010-03-03 09:05:00 | AAPL | Stock | 7.4679 | 7.4714 | 7.4664 | 7.4689 | 121100.0 |
| 2010-03-03 09:10:00 | AAPL | Stock | 7.4679 | 7.4679 | 7.4661 | 7.4679 | 65800.0 |
| 2010-03-03 09:15:00 | AAPL | Stock | 7.4664 | 7.4679 | 7.4664 | 7.4679 | 30632.0 |
| 2010-03-03 09:20:00 | AAPL | Stock | 7.4668 | 7.4668 | 7.4575 | 7.4607 | 189000.0 |
| 2010-03-03 09:25:00 | AAPL | Stock | 7.4589 | 7.4689 | 7.4421 | 7.4689 | 198324.0 |
| 2010-03-03 09:30:00 | AAPL | Stock | 7.4621 | 7.4725 | 7.4375 | 7.44 | 11462640.0 |
| 2010-03-03 09:35:00 | AAPL | Stock | 7.4389 | 7.4464 | 7.4329 | 7.4421 | 7137452.0 |
| 2010-03-03 09:40:00 | AAPL | Stock | 7.4414 | 7.4456 | 7.4264 | 7.445 | 8082956.0 |
| 2010-03-03 09:45:00 | AAPL | Stock | 7.4446 | 7.4679 | 7.4418 | 7.4639 | 12164432.0 |
| 2010-03-03 09:50:00 | AAPL | Stock | 7.4643 | 7.4821 | 7.4636 | 7.4779 | 11867604.0 |
| 2010-03-03 09:55:00 | AAPL | Stock | 7.4768 | 7.48 | 7.4696 | 7.4761 | 6570032.0 |
| 2010-03-03 10:00:00 | AAPL | Stock | 7.4761 | 7.4889 | 7.4596 | 7.4632 | 12847856.0 |
| 2010-03-03 10:05:00 | AAPL | Stock | 7.4632 | 7.4636 | 7.4482 | 7.4482 | 8486828.0 |
| 2010-03-03 10:10:00 | AAPL | Stock | 7.4482 | 7.4671 | 7.4479 | 7.4657 | 7580636.0 |
| 2010-03-03 10:15:00 | AAPL | Stock | 7.4671 | 7.4793 | 7.4654 | 7.4782 | 6965448.0 |
| 2010-03-03 10:20:00 | AAPL | Stock | 7.4786 | 7.4836 | 7.4736 | 7.4764 | 6301148.0 |
| 2010-03-03 10:25:00 | AAPL | Stock | 7.4761 | 7.4807 | 7.4686 | 7.4686 | 5540724.0 |
| 2010-03-03 10:30:00 | AAPL | Stock | 7.4686 | 7.4786 | 7.4629 | 7.4779 | 4823280.0 |
| 2010-03-03 10:35:00 | AAPL | Stock | 7.4768 | 7.4829 | 7.4746 | 7.4786 | 4851196.0 |
| 2010-03-03 10:40:00 | AAPL | Stock | 7.4786 | 7.4814 | 7.4682 | 7.4739 | 3987676.0 |
| 2010-03-03 10:45:00 | AAPL | Stock | 7.4743 | 7.4814 | 7.4718 | 7.4811 | 2809296.0 |
| 2010-03-03 10:50:00 | AAPL | Stock | 7.4804 | 7.485 | 7.4761 | 7.4825 | 4593400.0 |
| 2010-03-03 10:55:00 | AAPL | Stock | 7.4832 | 7.4954 | 7.4825 | 7.4868 | 7798812.0 |
| 2010-03-03 11:00:00 | AAPL | Stock | 7.4879 | 7.4904 | 7.4814 | 7.4825 | 5071668.0 |
| 2010-03-03 11:05:00 | AAPL | Stock | 7.4836 | 7.4871 | 7.4786 | 7.4786 | 4566464.0 |
| 2010-03-03 11:10:00 | AAPL | Stock | 7.4789 | 7.4821 | 7.4714 | 7.4769 | 5733112.0 |
| 2010-03-03 11:15:00 | AAPL | Stock | 7.4775 | 7.485 | 7.4754 | 7.4832 | 3291344.0 |
| 2010-03-03 11:20:00 | AAPL | Stock | 7.4836 | 7.4857 | 7.4786 | 7.485 | 3835244.0 |
| 2010-03-03 11:25:00 | AAPL | Stock | 7.4854 | 7.4911 | 7.4843 | 7.4904 | 4901064.0 |
| 2010-03-03 11:30:00 | AAPL | Stock | 7.4906 | 7.4943 | 7.4896 | 7.4932 | 6462932.0 |
> showing 50 of 328,158 rows — these rows as CSV