PREVIEW / stock_5min / 2005-04-11
file: by_date/stock_5min/2005/2005-04-11.parquet size: 2.6 MB rows: 191,744 symbols: 1,960
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-11 07:30:00 | AAPL | Stock | 1.5661 | 1.5661 | 1.5643 | 1.5643 | 84000.0 |
| 2005-04-11 07:55:00 | AAPL | Stock | 1.5661 | 1.5661 | 1.5661 | 1.5661 | 2800.0 |
| 2005-04-11 08:00:00 | AAPL | Stock | 1.5707 | 1.5871 | 1.5643 | 1.5775 | 967456.0 |
| 2005-04-11 08:05:00 | AAPL | Stock | 1.5786 | 1.5804 | 1.5746 | 1.575 | 554120.0 |
| 2005-04-11 08:10:00 | AAPL | Stock | 1.5736 | 1.5811 | 1.5736 | 1.5796 | 427280.0 |
| 2005-04-11 08:15:00 | AAPL | Stock | 1.5782 | 1.5786 | 1.5754 | 1.5782 | 238280.0 |
| 2005-04-11 08:20:00 | AAPL | Stock | 1.5775 | 1.5775 | 1.5736 | 1.5736 | 86240.0 |
| 2005-04-11 08:25:00 | AAPL | Stock | 1.5761 | 1.5839 | 1.5761 | 1.5821 | 581448.0 |
| 2005-04-11 08:30:00 | AAPL | Stock | 1.5821 | 1.5821 | 1.5811 | 1.5818 | 753200.0 |
| 2005-04-11 08:35:00 | AAPL | Stock | 1.5818 | 1.5821 | 1.5804 | 1.5821 | 903000.0 |
| 2005-04-11 08:40:00 | AAPL | Stock | 1.5821 | 1.5821 | 1.58 | 1.5804 | 302904.0 |
| 2005-04-11 08:45:00 | AAPL | Stock | 1.5786 | 1.5793 | 1.575 | 1.5761 | 171472.0 |
| 2005-04-11 08:50:00 | AAPL | Stock | 1.5761 | 1.5761 | 1.5718 | 1.5746 | 479808.0 |
| 2005-04-11 08:55:00 | AAPL | Stock | 1.5746 | 1.5786 | 1.5746 | 1.5782 | 96208.0 |
| 2005-04-11 09:00:00 | AAPL | Stock | 1.5786 | 1.5821 | 1.5771 | 1.5779 | 254800.0 |
| 2005-04-11 09:05:00 | AAPL | Stock | 1.5786 | 1.5793 | 1.5771 | 1.5771 | 285208.0 |
| 2005-04-11 09:10:00 | AAPL | Stock | 1.5764 | 1.5768 | 1.5746 | 1.575 | 353528.0 |
| 2005-04-11 09:15:00 | AAPL | Stock | 1.5768 | 1.5775 | 1.5754 | 1.5764 | 99176.0 |
| 2005-04-11 09:20:00 | AAPL | Stock | 1.5782 | 1.5786 | 1.5768 | 1.5775 | 352800.0 |
| 2005-04-11 09:25:00 | AAPL | Stock | 1.5761 | 1.5807 | 1.5761 | 1.58 | 2388960.0 |
| 2005-04-11 09:30:00 | AAPL | Stock | 1.5768 | 1.5804 | 1.5668 | 1.5725 | 27621216.0 |
| 2005-04-11 09:35:00 | AAPL | Stock | 1.5721 | 1.5729 | 1.5625 | 1.5625 | 29640912.0 |
| 2005-04-11 09:40:00 | AAPL | Stock | 1.5625 | 1.5632 | 1.5511 | 1.5525 | 29249584.0 |
| 2005-04-11 09:45:00 | AAPL | Stock | 1.5529 | 1.5618 | 1.5518 | 1.5604 | 20390132.0 |
| 2005-04-11 09:50:00 | AAPL | Stock | 1.56 | 1.5643 | 1.555 | 1.5571 | 15686048.0 |
| 2005-04-11 09:55:00 | AAPL | Stock | 1.5568 | 1.5571 | 1.5543 | 1.5546 | 6131608.0 |
| 2005-04-11 10:00:00 | AAPL | Stock | 1.5543 | 1.5571 | 1.5514 | 1.5518 | 13470744.0 |
| 2005-04-11 10:05:00 | AAPL | Stock | 1.5514 | 1.5536 | 1.5407 | 1.5446 | 19390364.0 |
| 2005-04-11 10:10:00 | AAPL | Stock | 1.5446 | 1.58 | 1.5443 | 1.5493 | 9854068.0 |
| 2005-04-11 10:15:00 | AAPL | Stock | 1.5493 | 1.5507 | 1.5421 | 1.5425 | 8222760.0 |
| 2005-04-11 10:20:00 | AAPL | Stock | 1.5421 | 1.55 | 1.5421 | 1.5486 | 11010048.0 |
| 2005-04-11 10:25:00 | AAPL | Stock | 1.5486 | 1.5496 | 1.5432 | 1.5446 | 6985384.0 |
| 2005-04-11 10:30:00 | AAPL | Stock | 1.5446 | 1.5464 | 1.5429 | 1.5461 | 8400560.0 |
| 2005-04-11 10:35:00 | AAPL | Stock | 1.5461 | 1.5464 | 1.5361 | 1.5368 | 14000756.0 |
| 2005-04-11 10:40:00 | AAPL | Stock | 1.5368 | 1.5368 | 1.5271 | 1.5271 | 31079440.0 |
| 2005-04-11 10:45:00 | AAPL | Stock | 1.5275 | 1.5314 | 1.5236 | 1.5243 | 24910788.0 |
| 2005-04-11 10:50:00 | AAPL | Stock | 1.5243 | 1.53 | 1.5204 | 1.5257 | 19331620.0 |
| 2005-04-11 10:55:00 | AAPL | Stock | 1.5254 | 1.5286 | 1.5189 | 1.5193 | 14268492.0 |
| 2005-04-11 11:00:00 | AAPL | Stock | 1.5196 | 1.5218 | 1.5182 | 1.5214 | 11683168.0 |
| 2005-04-11 11:05:00 | AAPL | Stock | 1.5211 | 1.5264 | 1.5204 | 1.5236 | 12198256.0 |
| 2005-04-11 11:10:00 | AAPL | Stock | 1.5236 | 1.525 | 1.5232 | 1.5236 | 8700972.0 |
| 2005-04-11 11:15:00 | AAPL | Stock | 1.5236 | 1.5239 | 1.5175 | 1.5193 | 9946804.0 |
| 2005-04-11 11:20:00 | AAPL | Stock | 1.5193 | 1.5243 | 1.5186 | 1.5225 | 6999804.0 |
| 2005-04-11 11:25:00 | AAPL | Stock | 1.5225 | 1.5236 | 1.5189 | 1.5189 | 6793696.0 |
| 2005-04-11 11:30:00 | AAPL | Stock | 1.5189 | 1.5214 | 1.515 | 1.5193 | 13089020.0 |
| 2005-04-11 11:35:00 | AAPL | Stock | 1.5193 | 1.5207 | 1.5125 | 1.5129 | 13034896.0 |
| 2005-04-11 11:40:00 | AAPL | Stock | 1.5125 | 1.5179 | 1.5125 | 1.5177 | 9915444.0 |
| 2005-04-11 11:45:00 | AAPL | Stock | 1.5179 | 1.5179 | 1.5136 | 1.5168 | 6597752.0 |
| 2005-04-11 11:50:00 | AAPL | Stock | 1.5168 | 1.5221 | 1.5168 | 1.5214 | 6753432.0 |
| 2005-04-11 11:55:00 | AAPL | Stock | 1.5214 | 1.525 | 1.5196 | 1.52 | 6531056.0 |
> showing 50 of 191,744 rows — these rows as CSV