PREVIEW / stock_5min / 2005-07-28
file: by_date/stock_5min/2005/2005-07-28.parquet size: 2.8 MB rows: 201,274 symbols: 2,052
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-07-28 08:00:00 | AAPL | Stock | 1.5714 | 1.5714 | 1.5714 | 1.5714 | 6440.0 |
| 2005-07-28 08:05:00 | AAPL | Stock | 1.5718 | 1.5718 | 1.5718 | 1.5718 | 11900.0 |
| 2005-07-28 08:10:00 | AAPL | Stock | 1.5732 | 1.5732 | 1.5732 | 1.5732 | 28000.0 |
| 2005-07-28 08:15:00 | AAPL | Stock | 1.5714 | 1.5732 | 1.5714 | 1.5732 | 89544.0 |
| 2005-07-28 08:20:00 | AAPL | Stock | 1.5732 | 1.5732 | 1.5725 | 1.5732 | 72800.0 |
| 2005-07-28 08:25:00 | AAPL | Stock | 1.5732 | 1.5804 | 1.5732 | 1.5786 | 55440.0 |
| 2005-07-28 08:40:00 | AAPL | Stock | 1.5736 | 1.5739 | 1.5736 | 1.5736 | 16800.0 |
| 2005-07-28 08:45:00 | AAPL | Stock | 1.5739 | 1.5739 | 1.5739 | 1.5739 | 3780.0 |
| 2005-07-28 08:50:00 | AAPL | Stock | 1.575 | 1.575 | 1.5739 | 1.5739 | 5600.0 |
| 2005-07-28 08:55:00 | AAPL | Stock | 1.5739 | 1.5739 | 1.5736 | 1.5736 | 81200.0 |
| 2005-07-28 09:00:00 | AAPL | Stock | 1.5739 | 1.5739 | 1.5721 | 1.5725 | 61992.0 |
| 2005-07-28 09:05:00 | AAPL | Stock | 1.5714 | 1.5725 | 1.5707 | 1.5707 | 47572.0 |
| 2005-07-28 09:10:00 | AAPL | Stock | 1.5725 | 1.5725 | 1.5725 | 1.5725 | 5600.0 |
| 2005-07-28 09:15:00 | AAPL | Stock | 1.5714 | 1.5714 | 1.5714 | 1.5714 | 2800.0 |
| 2005-07-28 09:20:00 | AAPL | Stock | 1.5704 | 1.5704 | 1.57 | 1.57 | 50400.0 |
| 2005-07-28 09:25:00 | AAPL | Stock | 1.5707 | 1.5707 | 1.5668 | 1.5668 | 180600.0 |
| 2005-07-28 09:30:00 | AAPL | Stock | 1.5661 | 1.5714 | 1.5629 | 1.5704 | 9085104.0 |
| 2005-07-28 09:35:00 | AAPL | Stock | 1.5704 | 1.5711 | 1.5646 | 1.5675 | 3869236.0 |
| 2005-07-28 09:40:00 | AAPL | Stock | 1.5675 | 1.5704 | 1.5664 | 1.5686 | 3817072.0 |
| 2005-07-28 09:45:00 | AAPL | Stock | 1.5682 | 1.5686 | 1.5496 | 1.5561 | 11876060.0 |
| 2005-07-28 09:50:00 | AAPL | Stock | 1.5557 | 1.5568 | 1.5514 | 1.555 | 8739892.0 |
| 2005-07-28 09:55:00 | AAPL | Stock | 1.5546 | 1.5614 | 1.5543 | 1.5568 | 8731492.0 |
| 2005-07-28 10:00:00 | AAPL | Stock | 1.5568 | 1.5571 | 1.55 | 1.5546 | 10439688.0 |
| 2005-07-28 10:05:00 | AAPL | Stock | 1.5539 | 1.5554 | 1.5464 | 1.5507 | 8027180.0 |
| 2005-07-28 10:10:00 | AAPL | Stock | 1.5504 | 1.5571 | 1.5475 | 1.5568 | 5065872.0 |
| 2005-07-28 10:15:00 | AAPL | Stock | 1.5568 | 1.5589 | 1.5518 | 1.5546 | 6531056.0 |
| 2005-07-28 10:20:00 | AAPL | Stock | 1.5543 | 1.5571 | 1.5464 | 1.5486 | 4892832.0 |
| 2005-07-28 10:25:00 | AAPL | Stock | 1.5486 | 1.5521 | 1.5468 | 1.55 | 4945220.0 |
| 2005-07-28 10:30:00 | AAPL | Stock | 1.5504 | 1.5514 | 1.5471 | 1.5496 | 4176424.0 |
| 2005-07-28 10:35:00 | AAPL | Stock | 1.5496 | 1.5521 | 1.5489 | 1.5514 | 4206468.0 |
| 2005-07-28 10:40:00 | AAPL | Stock | 1.5511 | 1.555 | 1.5486 | 1.5532 | 3378004.0 |
| 2005-07-28 10:45:00 | AAPL | Stock | 1.5532 | 1.555 | 1.5518 | 1.5532 | 2284492.0 |
| 2005-07-28 10:50:00 | AAPL | Stock | 1.5532 | 1.5543 | 1.553 | 1.5536 | 1390760.0 |
| 2005-07-28 10:55:00 | AAPL | Stock | 1.5539 | 1.5539 | 1.5518 | 1.5536 | 1583540.0 |
| 2005-07-28 11:00:00 | AAPL | Stock | 1.5536 | 1.5557 | 1.5521 | 1.5536 | 2429504.0 |
| 2005-07-28 11:05:00 | AAPL | Stock | 1.5536 | 1.5571 | 1.5532 | 1.5568 | 2928604.0 |
| 2005-07-28 11:10:00 | AAPL | Stock | 1.5564 | 1.5586 | 1.5546 | 1.5586 | 1671180.0 |
| 2005-07-28 11:15:00 | AAPL | Stock | 1.5579 | 1.56 | 1.5543 | 1.5557 | 3103184.0 |
| 2005-07-28 11:20:00 | AAPL | Stock | 1.5561 | 1.5575 | 1.5539 | 1.5557 | 2033080.0 |
| 2005-07-28 11:25:00 | AAPL | Stock | 1.5554 | 1.5571 | 1.5536 | 1.5561 | 1814008.0 |
| 2005-07-28 11:30:00 | AAPL | Stock | 1.5561 | 1.5575 | 1.555 | 1.5571 | 1705564.0 |
| 2005-07-28 11:35:00 | AAPL | Stock | 1.5571 | 1.5589 | 1.5546 | 1.5586 | 4237352.0 |
| 2005-07-28 11:40:00 | AAPL | Stock | 1.5586 | 1.5679 | 1.5586 | 1.5654 | 7775068.0 |
| 2005-07-28 11:45:00 | AAPL | Stock | 1.5654 | 1.5675 | 1.5629 | 1.5671 | 3239824.0 |
| 2005-07-28 11:50:00 | AAPL | Stock | 1.5668 | 1.5671 | 1.5639 | 1.5654 | 2452156.0 |
| 2005-07-28 11:55:00 | AAPL | Stock | 1.5654 | 1.5654 | 1.5643 | 1.5643 | 2007488.0 |
| 2005-07-28 12:00:00 | AAPL | Stock | 1.5643 | 1.5664 | 1.5607 | 1.5611 | 3130932.0 |
| 2005-07-28 12:05:00 | AAPL | Stock | 1.5607 | 1.5611 | 1.5571 | 1.5575 | 3119228.0 |
| 2005-07-28 12:10:00 | AAPL | Stock | 1.5579 | 1.5614 | 1.5575 | 1.5614 | 1402576.0 |
| 2005-07-28 12:15:00 | AAPL | Stock | 1.5611 | 1.5625 | 1.5596 | 1.5596 | 1154972.0 |
> showing 50 of 201,274 rows — these rows as CSV