PREVIEW / stock_5min / 2010-03-30
file: by_date/stock_5min/2010/2010-03-30.parquet size: 4.7 MB rows: 325,459 symbols: 3,486
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-30 04:15:00 | AAPL | Stock | 8.4625 | 8.4625 | 8.4625 | 8.4625 | 2800.0 |
| 2010-03-30 04:20:00 | AAPL | Stock | 8.4579 | 8.4579 | 8.4579 | 8.4579 | 2800.0 |
| 2010-03-30 04:45:00 | AAPL | Stock | 8.4643 | 8.4643 | 8.4643 | 8.4643 | 5600.0 |
| 2010-03-30 04:50:00 | AAPL | Stock | 8.4611 | 8.4611 | 8.4611 | 8.4611 | 2800.0 |
| 2010-03-30 05:40:00 | AAPL | Stock | 8.4721 | 8.4721 | 8.4721 | 8.4721 | 14000.0 |
| 2010-03-30 06:00:00 | AAPL | Stock | 8.4643 | 8.4643 | 8.4643 | 8.4643 | 2800.0 |
| 2010-03-30 06:10:00 | AAPL | Stock | 8.4643 | 8.4643 | 8.4643 | 8.4643 | 9800.0 |
| 2010-03-30 06:20:00 | AAPL | Stock | 8.4646 | 8.4725 | 8.4646 | 8.4725 | 5600.0 |
| 2010-03-30 06:25:00 | AAPL | Stock | 8.4743 | 8.4743 | 8.4743 | 8.4743 | 2800.0 |
| 2010-03-30 06:35:00 | AAPL | Stock | 8.4707 | 8.4707 | 8.4707 | 8.4707 | 14000.0 |
| 2010-03-30 06:55:00 | AAPL | Stock | 8.4682 | 8.4682 | 8.4682 | 8.4682 | 5600.0 |
| 2010-03-30 07:00:00 | AAPL | Stock | 8.4679 | 8.4704 | 8.4614 | 8.4643 | 219380.0 |
| 2010-03-30 07:05:00 | AAPL | Stock | 8.4611 | 8.4611 | 8.4554 | 8.4607 | 19600.0 |
| 2010-03-30 07:10:00 | AAPL | Stock | 8.4604 | 8.4604 | 8.4604 | 8.4604 | 2800.0 |
| 2010-03-30 07:15:00 | AAPL | Stock | 8.4607 | 8.4607 | 8.4607 | 8.4607 | 11536.0 |
| 2010-03-30 07:20:00 | AAPL | Stock | 8.4643 | 8.4643 | 8.4643 | 8.4643 | 14000.0 |
| 2010-03-30 07:25:00 | AAPL | Stock | 8.4754 | 8.4893 | 8.4754 | 8.4893 | 39648.0 |
| 2010-03-30 07:30:00 | AAPL | Stock | 8.4893 | 8.4893 | 8.4754 | 8.4786 | 43400.0 |
| 2010-03-30 07:35:00 | AAPL | Stock | 8.4786 | 8.4871 | 8.4786 | 8.4871 | 39004.0 |
| 2010-03-30 07:40:00 | AAPL | Stock | 8.4718 | 8.4746 | 8.4643 | 8.4643 | 76972.0 |
| 2010-03-30 07:45:00 | AAPL | Stock | 8.4639 | 8.4639 | 8.4482 | 8.4536 | 386708.0 |
| 2010-03-30 07:50:00 | AAPL | Stock | 8.4539 | 8.4607 | 8.4361 | 8.4571 | 420112.0 |
| 2010-03-30 07:55:00 | AAPL | Stock | 8.4482 | 8.4629 | 8.4482 | 8.4518 | 107072.0 |
| 2010-03-30 08:00:00 | AAPL | Stock | 8.4643 | 8.4911 | 8.4554 | 8.4864 | 2417548.0 |
| 2010-03-30 08:05:00 | AAPL | Stock | 8.4832 | 8.4832 | 8.4696 | 8.4782 | 598528.0 |
| 2010-03-30 08:10:00 | AAPL | Stock | 8.4782 | 8.4821 | 8.4736 | 8.475 | 736428.0 |
| 2010-03-30 08:15:00 | AAPL | Stock | 8.4764 | 8.4871 | 8.4757 | 8.4857 | 610932.0 |
| 2010-03-30 08:20:00 | AAPL | Stock | 8.4861 | 8.4875 | 8.4654 | 8.4711 | 1192940.0 |
| 2010-03-30 08:25:00 | AAPL | Stock | 8.4711 | 8.475 | 8.4693 | 8.4743 | 584024.0 |
| 2010-03-30 08:30:00 | AAPL | Stock | 8.4739 | 8.4807 | 8.4564 | 8.4764 | 528052.0 |
| 2010-03-30 08:35:00 | AAPL | Stock | 8.4768 | 8.4775 | 8.4714 | 8.4746 | 730576.0 |
| 2010-03-30 08:40:00 | AAPL | Stock | 8.475 | 8.4761 | 8.4689 | 8.475 | 319956.0 |
| 2010-03-30 08:45:00 | AAPL | Stock | 8.4736 | 8.4779 | 8.4732 | 8.4757 | 527156.0 |
| 2010-03-30 08:50:00 | AAPL | Stock | 8.475 | 8.4779 | 8.4704 | 8.4714 | 536032.0 |
| 2010-03-30 08:55:00 | AAPL | Stock | 8.4725 | 8.4746 | 8.4682 | 8.4696 | 680344.0 |
| 2010-03-30 09:00:00 | AAPL | Stock | 8.4682 | 8.4696 | 8.4343 | 8.4486 | 3893288.0 |
| 2010-03-30 09:05:00 | AAPL | Stock | 8.4468 | 8.4511 | 8.435 | 8.4411 | 1426040.0 |
| 2010-03-30 09:10:00 | AAPL | Stock | 8.4425 | 8.4429 | 8.4275 | 8.4379 | 2045932.0 |
| 2010-03-30 09:15:00 | AAPL | Stock | 8.44 | 8.4429 | 8.4339 | 8.4375 | 410872.0 |
| 2010-03-30 09:20:00 | AAPL | Stock | 8.4375 | 8.4375 | 8.4196 | 8.4239 | 982744.0 |
| 2010-03-30 09:25:00 | AAPL | Stock | 8.4239 | 8.4629 | 8.4214 | 8.4514 | 1712928.0 |
| 2010-03-30 09:30:00 | AAPL | Stock | 8.4501 | 8.4629 | 8.4243 | 8.4611 | 37635976.0 |
| 2010-03-30 09:35:00 | AAPL | Stock | 8.4611 | 8.4711 | 8.4268 | 8.4361 | 31816596.0 |
| 2010-03-30 09:40:00 | AAPL | Stock | 8.4364 | 8.4554 | 8.435 | 8.4509 | 15932896.0 |
| 2010-03-30 09:45:00 | AAPL | Stock | 8.45 | 8.4814 | 8.4468 | 8.4793 | 20425132.0 |
| 2010-03-30 09:50:00 | AAPL | Stock | 8.4796 | 8.48 | 8.4611 | 8.47 | 20980848.0 |
| 2010-03-30 09:55:00 | AAPL | Stock | 8.4696 | 8.4729 | 8.4511 | 8.4579 | 11051124.0 |
| 2010-03-30 10:00:00 | AAPL | Stock | 8.4582 | 8.4596 | 8.4464 | 8.4546 | 16865520.0 |
| 2010-03-30 10:05:00 | AAPL | Stock | 8.4546 | 8.4671 | 8.4529 | 8.4654 | 7440944.0 |
| 2010-03-30 10:10:00 | AAPL | Stock | 8.465 | 8.4661 | 8.4518 | 8.4528 | 6079976.0 |
> showing 50 of 325,459 rows — these rows as CSV