PREVIEW / stock_5min / 2004-08-19
file: by_date/stock_5min/2004/2004-08-19.parquet size: 2.3 MB rows: 171,237 symbols: 1,823
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-19 08:55:00 | AAPL | Stock | 0.567 | 0.567 | 0.565 | 0.565 | 386400.0 |
| 2004-08-19 09:00:00 | AAPL | Stock | 0.565 | 0.565 | 0.565 | 0.565 | 5600.0 |
| 2004-08-19 09:25:00 | AAPL | Stock | 0.565 | 0.5664 | 0.5643 | 0.5645 | 158256.0 |
| 2004-08-19 09:30:00 | AAPL | Stock | 0.5627 | 0.5641 | 0.5625 | 0.5627 | 5215504.0 |
| 2004-08-19 09:35:00 | AAPL | Stock | 0.5625 | 0.5638 | 0.5598 | 0.562 | 6575240.0 |
| 2004-08-19 09:40:00 | AAPL | Stock | 0.5623 | 0.5648 | 0.5616 | 0.5645 | 5008528.0 |
| 2004-08-19 09:45:00 | AAPL | Stock | 0.5652 | 0.5659 | 0.5636 | 0.5646 | 2533944.0 |
| 2004-08-19 09:50:00 | AAPL | Stock | 0.565 | 0.5682 | 0.5646 | 0.567 | 3448368.0 |
| 2004-08-19 09:55:00 | AAPL | Stock | 0.567 | 0.5689 | 0.5666 | 0.5668 | 2982112.0 |
| 2004-08-19 10:00:00 | AAPL | Stock | 0.5668 | 0.567 | 0.5668 | 0.5668 | 2923648.0 |
| 2004-08-19 10:05:00 | AAPL | Stock | 0.5668 | 0.567 | 0.5625 | 0.5632 | 4670064.0 |
| 2004-08-19 10:10:00 | AAPL | Stock | 0.5632 | 0.5632 | 0.5616 | 0.5621 | 8605800.0 |
| 2004-08-19 10:15:00 | AAPL | Stock | 0.5621 | 0.5625 | 0.5573 | 0.5607 | 13231848.0 |
| 2004-08-19 10:20:00 | AAPL | Stock | 0.5604 | 0.5607 | 0.5582 | 0.5591 | 16475312.0 |
| 2004-08-19 10:25:00 | AAPL | Stock | 0.5586 | 0.5593 | 0.5577 | 0.558 | 12469016.0 |
| 2004-08-19 10:30:00 | AAPL | Stock | 0.558 | 0.5586 | 0.5568 | 0.557 | 8456448.0 |
| 2004-08-19 10:35:00 | AAPL | Stock | 0.5568 | 0.5584 | 0.5557 | 0.5563 | 8484504.0 |
| 2004-08-19 10:40:00 | AAPL | Stock | 0.5563 | 0.5573 | 0.5552 | 0.5568 | 8903496.0 |
| 2004-08-19 10:45:00 | AAPL | Stock | 0.5571 | 0.5573 | 0.557 | 0.557 | 2119320.0 |
| 2004-08-19 10:50:00 | AAPL | Stock | 0.5568 | 0.557 | 0.5554 | 0.5555 | 3074736.0 |
| 2004-08-19 10:55:00 | AAPL | Stock | 0.5557 | 0.5563 | 0.5557 | 0.5559 | 1622208.0 |
| 2004-08-19 11:00:00 | AAPL | Stock | 0.5563 | 0.5573 | 0.5561 | 0.5571 | 2510704.0 |
| 2004-08-19 11:05:00 | AAPL | Stock | 0.5571 | 0.5573 | 0.5564 | 0.5566 | 7086408.0 |
| 2004-08-19 11:10:00 | AAPL | Stock | 0.5566 | 0.557 | 0.5564 | 0.5566 | 2690296.0 |
| 2004-08-19 11:15:00 | AAPL | Stock | 0.5568 | 0.5571 | 0.5564 | 0.5566 | 2156000.0 |
| 2004-08-19 11:20:00 | AAPL | Stock | 0.5568 | 0.5571 | 0.5564 | 0.5566 | 2336320.0 |
| 2004-08-19 11:25:00 | AAPL | Stock | 0.5566 | 0.5568 | 0.5559 | 0.5564 | 1448328.0 |
| 2004-08-19 11:30:00 | AAPL | Stock | 0.5564 | 0.5571 | 0.5564 | 0.557 | 1566376.0 |
| 2004-08-19 11:35:00 | AAPL | Stock | 0.557 | 0.5575 | 0.5566 | 0.5571 | 2318568.0 |
| 2004-08-19 11:40:00 | AAPL | Stock | 0.5571 | 0.5577 | 0.5571 | 0.5571 | 1580936.0 |
| 2004-08-19 11:45:00 | AAPL | Stock | 0.5573 | 0.5588 | 0.5571 | 0.558 | 3993696.0 |
| 2004-08-19 11:50:00 | AAPL | Stock | 0.5582 | 0.5586 | 0.5571 | 0.5571 | 2019752.0 |
| 2004-08-19 11:55:00 | AAPL | Stock | 0.5575 | 0.5575 | 0.5559 | 0.5561 | 2680328.0 |
| 2004-08-19 12:00:00 | AAPL | Stock | 0.5563 | 0.5563 | 0.5557 | 0.5563 | 1007384.0 |
| 2004-08-19 12:05:00 | AAPL | Stock | 0.5563 | 0.5566 | 0.5559 | 0.5561 | 1544424.0 |
| 2004-08-19 12:10:00 | AAPL | Stock | 0.5557 | 0.5566 | 0.5555 | 0.5555 | 881776.0 |
| 2004-08-19 12:15:00 | AAPL | Stock | 0.5555 | 0.5561 | 0.5554 | 0.5554 | 1057000.0 |
| 2004-08-19 12:20:00 | AAPL | Stock | 0.5554 | 0.5557 | 0.5552 | 0.5554 | 1310904.0 |
| 2004-08-19 12:25:00 | AAPL | Stock | 0.5552 | 0.5554 | 0.5539 | 0.5541 | 3412696.0 |
| 2004-08-19 12:30:00 | AAPL | Stock | 0.5543 | 0.5564 | 0.5539 | 0.5564 | 1774472.0 |
| 2004-08-19 12:35:00 | AAPL | Stock | 0.5566 | 0.5566 | 0.5554 | 0.5559 | 960512.0 |
| 2004-08-19 12:40:00 | AAPL | Stock | 0.5561 | 0.557 | 0.5561 | 0.5566 | 1182104.0 |
| 2004-08-19 12:45:00 | AAPL | Stock | 0.5566 | 0.557 | 0.5557 | 0.5561 | 1148224.0 |
| 2004-08-19 12:50:00 | AAPL | Stock | 0.5563 | 0.5577 | 0.5559 | 0.5575 | 1059800.0 |
| 2004-08-19 12:55:00 | AAPL | Stock | 0.5579 | 0.5579 | 0.5563 | 0.5563 | 1142904.0 |
| 2004-08-19 13:00:00 | AAPL | Stock | 0.5561 | 0.5575 | 0.5557 | 0.5573 | 8076376.0 |
| 2004-08-19 13:05:00 | AAPL | Stock | 0.5577 | 0.5577 | 0.557 | 0.557 | 980112.0 |
| 2004-08-19 13:10:00 | AAPL | Stock | 0.557 | 0.5575 | 0.5568 | 0.5575 | 574560.0 |
| 2004-08-19 13:15:00 | AAPL | Stock | 0.5575 | 0.5577 | 0.5568 | 0.557 | 2530696.0 |
| 2004-08-19 13:20:00 | AAPL | Stock | 0.5568 | 0.5571 | 0.5564 | 0.5566 | 850752.0 |
> showing 50 of 171,237 rows — these rows as CSV