PREVIEW / stock_5min / 2005-12-02
file: by_date/stock_5min/2005/2005-12-02.parquet size: 2.8 MB rows: 208,144 symbols: 2,134
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-12-02 07:50:00 | AAPL | Stock | 2.5571 | 2.5571 | 2.5571 | 2.5571 | 2800.0 |
| 2005-12-02 07:55:00 | AAPL | Stock | 2.5607 | 2.5679 | 2.5607 | 2.5661 | 72548.0 |
| 2005-12-02 08:00:00 | AAPL | Stock | 2.5657 | 2.5714 | 2.5657 | 2.5657 | 393008.0 |
| 2005-12-02 08:05:00 | AAPL | Stock | 2.5646 | 2.5857 | 2.5618 | 2.5771 | 1145928.0 |
| 2005-12-02 08:10:00 | AAPL | Stock | 2.5771 | 2.5964 | 2.5736 | 2.5825 | 519792.0 |
| 2005-12-02 08:15:00 | AAPL | Stock | 2.5818 | 2.5961 | 2.5818 | 2.5961 | 1008056.0 |
| 2005-12-02 08:20:00 | AAPL | Stock | 2.5929 | 2.5946 | 2.5911 | 2.5929 | 292824.0 |
| 2005-12-02 08:25:00 | AAPL | Stock | 2.5914 | 2.5921 | 2.5825 | 2.5857 | 494116.0 |
| 2005-12-02 08:30:00 | AAPL | Stock | 2.5839 | 2.5882 | 2.5768 | 2.5875 | 1061788.0 |
| 2005-12-02 08:35:00 | AAPL | Stock | 2.5857 | 2.5875 | 2.5821 | 2.5839 | 585732.0 |
| 2005-12-02 08:40:00 | AAPL | Stock | 2.5854 | 2.5857 | 2.5804 | 2.5832 | 345436.0 |
| 2005-12-02 08:45:00 | AAPL | Stock | 2.5832 | 2.5875 | 2.5811 | 2.5839 | 231000.0 |
| 2005-12-02 08:50:00 | AAPL | Stock | 2.5839 | 2.5839 | 2.5821 | 2.5825 | 104412.0 |
| 2005-12-02 08:55:00 | AAPL | Stock | 2.5821 | 2.5829 | 2.5804 | 2.5804 | 323960.0 |
| 2005-12-02 09:00:00 | AAPL | Stock | 2.5804 | 2.5839 | 2.5789 | 2.5821 | 316624.0 |
| 2005-12-02 09:05:00 | AAPL | Stock | 2.5825 | 2.5893 | 2.5821 | 2.5832 | 789320.0 |
| 2005-12-02 09:10:00 | AAPL | Stock | 2.5843 | 2.5857 | 2.5821 | 2.5857 | 404740.0 |
| 2005-12-02 09:15:00 | AAPL | Stock | 2.5839 | 2.5843 | 2.5836 | 2.5836 | 56420.0 |
| 2005-12-02 09:20:00 | AAPL | Stock | 2.5836 | 2.5836 | 2.575 | 2.5768 | 391356.0 |
| 2005-12-02 09:25:00 | AAPL | Stock | 2.5768 | 2.5886 | 2.5732 | 2.5789 | 3011092.0 |
| 2005-12-02 09:30:00 | AAPL | Stock | 2.5811 | 2.59 | 2.5636 | 2.5732 | 42552972.0 |
| 2005-12-02 09:35:00 | AAPL | Stock | 2.5736 | 2.5789 | 2.5668 | 2.5686 | 20176800.0 |
| 2005-12-02 09:40:00 | AAPL | Stock | 2.5686 | 2.5704 | 2.555 | 2.5607 | 28582092.0 |
| 2005-12-02 09:45:00 | AAPL | Stock | 2.5607 | 2.5693 | 2.5536 | 2.5536 | 24635408.0 |
| 2005-12-02 09:50:00 | AAPL | Stock | 2.5539 | 2.5618 | 2.545 | 2.5611 | 27079808.0 |
| 2005-12-02 09:55:00 | AAPL | Stock | 2.5614 | 2.5711 | 2.5579 | 2.5682 | 18215204.0 |
| 2005-12-02 10:00:00 | AAPL | Stock | 2.5682 | 2.5854 | 2.5675 | 2.5782 | 23923592.0 |
| 2005-12-02 10:05:00 | AAPL | Stock | 2.5782 | 2.5893 | 2.5739 | 2.5775 | 20325396.0 |
| 2005-12-02 10:10:00 | AAPL | Stock | 2.5771 | 2.5771 | 2.5646 | 2.5721 | 23804704.0 |
| 2005-12-02 10:15:00 | AAPL | Stock | 2.5718 | 2.5725 | 2.5482 | 2.5532 | 26876640.0 |
| 2005-12-02 10:20:00 | AAPL | Stock | 2.5536 | 2.5754 | 2.55 | 2.5586 | 23478812.0 |
| 2005-12-02 10:25:00 | AAPL | Stock | 2.5582 | 2.5607 | 2.55 | 2.5543 | 18577860.0 |
| 2005-12-02 10:30:00 | AAPL | Stock | 2.5543 | 2.5586 | 2.5482 | 2.5518 | 19226200.0 |
| 2005-12-02 10:35:00 | AAPL | Stock | 2.5518 | 2.5518 | 2.5336 | 2.5404 | 31464552.0 |
| 2005-12-02 10:40:00 | AAPL | Stock | 2.5404 | 2.5457 | 2.5361 | 2.5457 | 14924868.0 |
| 2005-12-02 10:45:00 | AAPL | Stock | 2.5457 | 2.5457 | 2.5389 | 2.5396 | 15288084.0 |
| 2005-12-02 10:50:00 | AAPL | Stock | 2.54 | 2.5439 | 2.5375 | 2.5396 | 11614988.0 |
| 2005-12-02 10:55:00 | AAPL | Stock | 2.5396 | 2.5405 | 2.525 | 2.5296 | 23246748.0 |
| 2005-12-02 11:00:00 | AAPL | Stock | 2.5296 | 2.535 | 2.5257 | 2.5332 | 7967400.0 |
| 2005-12-02 11:05:00 | AAPL | Stock | 2.5325 | 2.5411 | 2.53 | 2.5396 | 8003660.0 |
| 2005-12-02 11:10:00 | AAPL | Stock | 2.5393 | 2.5404 | 2.5332 | 2.535 | 6535676.0 |
| 2005-12-02 11:15:00 | AAPL | Stock | 2.5346 | 2.5468 | 2.5339 | 2.5464 | 7599676.0 |
| 2005-12-02 11:20:00 | AAPL | Stock | 2.5468 | 2.55 | 2.5429 | 2.5486 | 7331576.0 |
| 2005-12-02 11:25:00 | AAPL | Stock | 2.5496 | 2.5529 | 2.5389 | 2.5435 | 12508104.0 |
| 2005-12-02 11:30:00 | AAPL | Stock | 2.5436 | 2.5521 | 2.5404 | 2.55 | 7553756.0 |
| 2005-12-02 11:35:00 | AAPL | Stock | 2.5504 | 2.5507 | 2.5411 | 2.5453 | 5474588.0 |
| 2005-12-02 11:40:00 | AAPL | Stock | 2.5446 | 2.5471 | 2.5425 | 2.5468 | 4013212.0 |
| 2005-12-02 11:45:00 | AAPL | Stock | 2.5464 | 2.5582 | 2.5464 | 2.5575 | 9446640.0 |
| 2005-12-02 11:50:00 | AAPL | Stock | 2.5579 | 2.5582 | 2.5507 | 2.5564 | 6739404.0 |
| 2005-12-02 11:55:00 | AAPL | Stock | 2.5564 | 2.5611 | 2.5532 | 2.56 | 10346308.0 |
> showing 50 of 208,144 rows — these rows as CSV