PREVIEW / stock_5min / 2009-05-21
file: by_date/stock_5min/2009/2009-05-21.parquet size: 4.6 MB rows: 318,806 symbols: 3,343
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-21 06:50:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4821 | 4.4821 | 5600.0 |
| 2009-05-21 07:05:00 | AAPL | Stock | 4.4757 | 4.4757 | 4.4757 | 4.4757 | 2800.0 |
| 2009-05-21 07:30:00 | AAPL | Stock | 4.4768 | 4.4768 | 4.4768 | 4.4768 | 5600.0 |
| 2009-05-21 07:40:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4821 | 4.4821 | 8400.0 |
| 2009-05-21 07:45:00 | AAPL | Stock | 4.4804 | 4.4821 | 4.4804 | 4.4821 | 8400.0 |
| 2009-05-21 07:50:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4821 | 4.4821 | 11200.0 |
| 2009-05-21 07:55:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4796 | 4.4796 | 30800.0 |
| 2009-05-21 08:00:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4714 | 4.4739 | 180852.0 |
| 2009-05-21 08:05:00 | AAPL | Stock | 4.4725 | 4.4725 | 4.4725 | 4.4725 | 2800.0 |
| 2009-05-21 08:10:00 | AAPL | Stock | 4.4725 | 4.4739 | 4.4725 | 4.4729 | 11200.0 |
| 2009-05-21 08:15:00 | AAPL | Stock | 4.475 | 4.4771 | 4.4746 | 4.4771 | 8400.0 |
| 2009-05-21 08:20:00 | AAPL | Stock | 4.4804 | 4.4804 | 4.4786 | 4.4786 | 25200.0 |
| 2009-05-21 08:30:00 | AAPL | Stock | 4.4786 | 4.4786 | 4.4593 | 4.4746 | 197848.0 |
| 2009-05-21 08:35:00 | AAPL | Stock | 4.4729 | 4.4732 | 4.4729 | 4.4732 | 95200.0 |
| 2009-05-21 08:45:00 | AAPL | Stock | 4.4732 | 4.4736 | 4.4732 | 4.4736 | 19600.0 |
| 2009-05-21 08:50:00 | AAPL | Stock | 4.4736 | 4.4736 | 4.4736 | 4.4736 | 12040.0 |
| 2009-05-21 08:55:00 | AAPL | Stock | 4.4696 | 4.4736 | 4.4679 | 4.4679 | 31668.0 |
| 2009-05-21 09:00:00 | AAPL | Stock | 4.4686 | 4.4729 | 4.4661 | 4.4661 | 56728.0 |
| 2009-05-21 09:05:00 | AAPL | Stock | 4.4657 | 4.4661 | 4.4607 | 4.4607 | 143360.0 |
| 2009-05-21 09:10:00 | AAPL | Stock | 4.4604 | 4.4604 | 4.4586 | 4.4604 | 93044.0 |
| 2009-05-21 09:15:00 | AAPL | Stock | 4.4611 | 4.4661 | 4.4607 | 4.4661 | 70420.0 |
| 2009-05-21 09:20:00 | AAPL | Stock | 4.4661 | 4.4671 | 4.4643 | 4.4654 | 33600.0 |
| 2009-05-21 09:25:00 | AAPL | Stock | 4.4718 | 4.4718 | 4.4604 | 4.4696 | 287420.0 |
| 2009-05-21 09:30:00 | AAPL | Stock | 4.4696 | 4.4729 | 4.4464 | 4.4682 | 13071800.0 |
| 2009-05-21 09:35:00 | AAPL | Stock | 4.4693 | 4.4921 | 4.4611 | 4.483 | 10584840.0 |
| 2009-05-21 09:40:00 | AAPL | Stock | 4.4829 | 4.5061 | 4.4739 | 4.5029 | 9638552.0 |
| 2009-05-21 09:45:00 | AAPL | Stock | 4.5029 | 4.5229 | 4.5004 | 4.5107 | 12258176.0 |
| 2009-05-21 09:50:00 | AAPL | Stock | 4.5114 | 4.5279 | 4.5107 | 4.5207 | 9079728.0 |
| 2009-05-21 09:55:00 | AAPL | Stock | 4.5207 | 4.525 | 4.5075 | 4.5093 | 6145888.0 |
| 2009-05-21 10:00:00 | AAPL | Stock | 4.508 | 4.5239 | 4.4889 | 4.4939 | 10862964.0 |
| 2009-05-21 10:05:00 | AAPL | Stock | 4.4936 | 4.5179 | 4.4936 | 4.515 | 6226836.0 |
| 2009-05-21 10:10:00 | AAPL | Stock | 4.515 | 4.5157 | 4.4793 | 4.4821 | 6703452.0 |
| 2009-05-21 10:15:00 | AAPL | Stock | 4.4821 | 4.4884 | 4.4632 | 4.4679 | 7637504.0 |
| 2009-05-21 10:20:00 | AAPL | Stock | 4.4679 | 4.4786 | 4.4575 | 4.4625 | 6654060.0 |
| 2009-05-21 10:25:00 | AAPL | Stock | 4.4642 | 4.4732 | 4.4642 | 4.4721 | 2830660.0 |
| 2009-05-21 10:30:00 | AAPL | Stock | 4.4711 | 4.4754 | 4.4643 | 4.4675 | 3285996.0 |
| 2009-05-21 10:35:00 | AAPL | Stock | 4.4682 | 4.4818 | 4.465 | 4.48 | 3572128.0 |
| 2009-05-21 10:40:00 | AAPL | Stock | 4.4801 | 4.4882 | 4.4757 | 4.4811 | 5778612.0 |
| 2009-05-21 10:45:00 | AAPL | Stock | 4.4804 | 4.4821 | 4.4643 | 4.4657 | 3327492.0 |
| 2009-05-21 10:50:00 | AAPL | Stock | 4.4657 | 4.4671 | 4.4571 | 4.4582 | 6047524.0 |
| 2009-05-21 10:55:00 | AAPL | Stock | 4.4589 | 4.4614 | 4.4446 | 4.445 | 7212632.0 |
| 2009-05-21 11:00:00 | AAPL | Stock | 4.445 | 4.4461 | 4.4107 | 4.4171 | 15334172.0 |
| 2009-05-21 11:05:00 | AAPL | Stock | 4.4166 | 4.4193 | 4.4071 | 4.4089 | 8404060.0 |
| 2009-05-21 11:10:00 | AAPL | Stock | 4.4079 | 4.4193 | 4.4071 | 4.4132 | 5937008.0 |
| 2009-05-21 11:15:00 | AAPL | Stock | 4.4132 | 4.4229 | 4.4114 | 4.42 | 4686472.0 |
| 2009-05-21 11:20:00 | AAPL | Stock | 4.42 | 4.42 | 4.4089 | 4.4103 | 5805604.0 |
| 2009-05-21 11:25:00 | AAPL | Stock | 4.41 | 4.4225 | 4.4046 | 4.4211 | 4253704.0 |
| 2009-05-21 11:30:00 | AAPL | Stock | 4.4204 | 4.4218 | 4.4168 | 4.4189 | 2567908.0 |
| 2009-05-21 11:35:00 | AAPL | Stock | 4.4196 | 4.4364 | 4.4193 | 4.4325 | 4452952.0 |
| 2009-05-21 11:40:00 | AAPL | Stock | 4.4332 | 4.4336 | 4.425 | 4.4261 | 2202676.0 |
> showing 50 of 318,806 rows — these rows as CSV