PREVIEW / stock_5min / 2006-05-09
file: by_date/stock_5min/2006/2006-05-09.parquet size: 3.0 MB rows: 225,798 symbols: 2,264
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-09 07:40:00 | AAPL | Stock | 2.5607 | 2.5679 | 2.5607 | 2.5679 | 5600.0 |
| 2006-05-09 07:45:00 | AAPL | Stock | 2.5714 | 2.5714 | 2.5714 | 2.5714 | 29400.0 |
| 2006-05-09 07:50:00 | AAPL | Stock | 2.575 | 2.575 | 2.575 | 2.575 | 7000.0 |
| 2006-05-09 08:00:00 | AAPL | Stock | 2.575 | 2.575 | 2.5546 | 2.5664 | 566216.0 |
| 2006-05-09 08:05:00 | AAPL | Stock | 2.5589 | 2.5639 | 2.5589 | 2.5625 | 179200.0 |
| 2006-05-09 08:10:00 | AAPL | Stock | 2.5625 | 2.5643 | 2.5625 | 2.5643 | 14000.0 |
| 2006-05-09 08:15:00 | AAPL | Stock | 2.5625 | 2.5625 | 2.5586 | 2.5607 | 71400.0 |
| 2006-05-09 08:20:00 | AAPL | Stock | 2.5607 | 2.5621 | 2.5582 | 2.5621 | 99400.0 |
| 2006-05-09 08:25:00 | AAPL | Stock | 2.5593 | 2.5621 | 2.5593 | 2.5607 | 14000.0 |
| 2006-05-09 08:35:00 | AAPL | Stock | 2.5604 | 2.5604 | 2.56 | 2.56 | 19600.0 |
| 2006-05-09 08:40:00 | AAPL | Stock | 2.5586 | 2.5621 | 2.5586 | 2.5621 | 44800.0 |
| 2006-05-09 08:45:00 | AAPL | Stock | 2.5621 | 2.5625 | 2.5607 | 2.5607 | 85400.0 |
| 2006-05-09 08:50:00 | AAPL | Stock | 2.5607 | 2.5625 | 2.5607 | 2.5607 | 151200.0 |
| 2006-05-09 08:55:00 | AAPL | Stock | 2.5621 | 2.5664 | 2.5621 | 2.5664 | 148456.0 |
| 2006-05-09 09:00:00 | AAPL | Stock | 2.5654 | 2.575 | 2.565 | 2.575 | 686000.0 |
| 2006-05-09 09:05:00 | AAPL | Stock | 2.575 | 2.575 | 2.5696 | 2.5725 | 532280.0 |
| 2006-05-09 09:10:00 | AAPL | Stock | 2.5725 | 2.5725 | 2.57 | 2.5711 | 411880.0 |
| 2006-05-09 09:20:00 | AAPL | Stock | 2.5689 | 2.5696 | 2.5661 | 2.5671 | 47600.0 |
| 2006-05-09 09:25:00 | AAPL | Stock | 2.5664 | 2.5675 | 2.5614 | 2.565 | 477540.0 |
| 2006-05-09 09:30:00 | AAPL | Stock | 2.5652 | 2.5686 | 2.5525 | 2.5618 | 20633508.0 |
| 2006-05-09 09:35:00 | AAPL | Stock | 2.5615 | 2.5668 | 2.5586 | 2.5643 | 10245760.0 |
| 2006-05-09 09:40:00 | AAPL | Stock | 2.5621 | 2.5757 | 2.5618 | 2.5736 | 11557140.0 |
| 2006-05-09 09:45:00 | AAPL | Stock | 2.5736 | 2.5875 | 2.5732 | 2.5871 | 14825636.0 |
| 2006-05-09 09:50:00 | AAPL | Stock | 2.5871 | 2.5914 | 2.5761 | 2.5825 | 16162468.0 |
| 2006-05-09 09:55:00 | AAPL | Stock | 2.5821 | 2.5832 | 2.5739 | 2.5746 | 7445256.0 |
| 2006-05-09 10:00:00 | AAPL | Stock | 2.5754 | 2.5775 | 2.5707 | 2.5732 | 11810400.0 |
| 2006-05-09 10:05:00 | AAPL | Stock | 2.5732 | 2.5768 | 2.5696 | 2.5757 | 6640424.0 |
| 2006-05-09 10:10:00 | AAPL | Stock | 2.5757 | 2.5811 | 2.5732 | 2.5775 | 8842456.0 |
| 2006-05-09 10:15:00 | AAPL | Stock | 2.5782 | 2.5782 | 2.5714 | 2.5735 | 6225884.0 |
| 2006-05-09 10:20:00 | AAPL | Stock | 2.5736 | 2.5764 | 2.5654 | 2.5661 | 7994476.0 |
| 2006-05-09 10:25:00 | AAPL | Stock | 2.5661 | 2.5693 | 2.5618 | 2.5654 | 11348260.0 |
| 2006-05-09 10:30:00 | AAPL | Stock | 2.5654 | 2.5707 | 2.5639 | 2.5646 | 5828704.0 |
| 2006-05-09 10:35:00 | AAPL | Stock | 2.565 | 2.5657 | 2.5604 | 2.5611 | 6466264.0 |
| 2006-05-09 10:40:00 | AAPL | Stock | 2.5611 | 2.5654 | 2.5571 | 2.5614 | 10385956.0 |
| 2006-05-09 10:45:00 | AAPL | Stock | 2.5614 | 2.5614 | 2.5568 | 2.5579 | 7063224.0 |
| 2006-05-09 10:50:00 | AAPL | Stock | 2.5579 | 2.5611 | 2.5546 | 2.5597 | 7740908.0 |
| 2006-05-09 10:55:00 | AAPL | Stock | 2.5596 | 2.56 | 2.5564 | 2.5564 | 3285492.0 |
| 2006-05-09 11:00:00 | AAPL | Stock | 2.5568 | 2.5639 | 2.5564 | 2.5607 | 5371604.0 |
| 2006-05-09 11:05:00 | AAPL | Stock | 2.5604 | 2.5711 | 2.5604 | 2.5711 | 5434324.0 |
| 2006-05-09 11:10:00 | AAPL | Stock | 2.5711 | 2.5729 | 2.5554 | 2.5657 | 7565180.0 |
| 2006-05-09 11:15:00 | AAPL | Stock | 2.5657 | 2.5675 | 2.5575 | 2.56 | 6544944.0 |
| 2006-05-09 11:20:00 | AAPL | Stock | 2.56 | 2.5614 | 2.5554 | 2.5589 | 7300944.0 |
| 2006-05-09 11:25:00 | AAPL | Stock | 2.5589 | 2.5596 | 2.5554 | 2.5593 | 5414836.0 |
| 2006-05-09 11:30:00 | AAPL | Stock | 2.5596 | 2.5625 | 2.5586 | 2.5596 | 4028360.0 |
| 2006-05-09 11:35:00 | AAPL | Stock | 2.5596 | 2.5621 | 2.5579 | 2.5618 | 3723412.0 |
| 2006-05-09 11:40:00 | AAPL | Stock | 2.5621 | 2.5621 | 2.555 | 2.5554 | 5111596.0 |
| 2006-05-09 11:45:00 | AAPL | Stock | 2.5554 | 2.5564 | 2.5475 | 2.5497 | 13685896.0 |
| 2006-05-09 11:50:00 | AAPL | Stock | 2.5504 | 2.5539 | 2.5482 | 2.5532 | 4604516.0 |
| 2006-05-09 11:55:00 | AAPL | Stock | 2.5532 | 2.5546 | 2.5518 | 2.5546 | 3285464.0 |
| 2006-05-09 12:00:00 | AAPL | Stock | 2.5543 | 2.5554 | 2.5507 | 2.5532 | 3069136.0 |
> showing 50 of 225,798 rows — these rows as CSV