PREVIEW / stock_5min / 2006-03-02
file: by_date/stock_5min/2006/2006-03-02.parquet size: 3.0 MB rows: 220,758 symbols: 2,193
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-03-02 06:20:00 | AAPL | Stock | 2.4643 | 2.4643 | 2.4643 | 2.4643 | 28000.0 |
| 2006-03-02 07:00:00 | AAPL | Stock | 2.475 | 2.475 | 2.475 | 2.475 | 56000.0 |
| 2006-03-02 07:05:00 | AAPL | Stock | 2.4714 | 2.4714 | 2.4714 | 2.4714 | 28000.0 |
| 2006-03-02 07:20:00 | AAPL | Stock | 2.4639 | 2.4643 | 2.4639 | 2.4643 | 56280.0 |
| 2006-03-02 07:30:00 | AAPL | Stock | 2.4661 | 2.4661 | 2.4661 | 2.4661 | 2800.0 |
| 2006-03-02 08:00:00 | AAPL | Stock | 2.4821 | 2.4821 | 2.4714 | 2.4732 | 347620.0 |
| 2006-03-02 08:05:00 | AAPL | Stock | 2.4729 | 2.4732 | 2.4729 | 2.4729 | 203700.0 |
| 2006-03-02 08:10:00 | AAPL | Stock | 2.47 | 2.4729 | 2.4696 | 2.4729 | 76300.0 |
| 2006-03-02 08:15:00 | AAPL | Stock | 2.4729 | 2.4729 | 2.4729 | 2.4729 | 17500.0 |
| 2006-03-02 08:20:00 | AAPL | Stock | 2.4725 | 2.4732 | 2.4725 | 2.4729 | 32480.0 |
| 2006-03-02 08:30:00 | AAPL | Stock | 2.4704 | 2.4704 | 2.4682 | 2.4682 | 26040.0 |
| 2006-03-02 08:35:00 | AAPL | Stock | 2.4682 | 2.4682 | 2.4682 | 2.4682 | 40600.0 |
| 2006-03-02 08:40:00 | AAPL | Stock | 2.4682 | 2.4682 | 2.4682 | 2.4682 | 25200.0 |
| 2006-03-02 08:45:00 | AAPL | Stock | 2.4679 | 2.4679 | 2.4643 | 2.4643 | 188748.0 |
| 2006-03-02 08:50:00 | AAPL | Stock | 2.4643 | 2.4661 | 2.4596 | 2.4643 | 141400.0 |
| 2006-03-02 08:55:00 | AAPL | Stock | 2.4643 | 2.4661 | 2.4643 | 2.4643 | 89040.0 |
| 2006-03-02 09:00:00 | AAPL | Stock | 2.4643 | 2.4643 | 2.4625 | 2.4625 | 148400.0 |
| 2006-03-02 09:05:00 | AAPL | Stock | 2.4611 | 2.4643 | 2.4611 | 2.4643 | 98000.0 |
| 2006-03-02 09:10:00 | AAPL | Stock | 2.4611 | 2.4611 | 2.4589 | 2.4589 | 159600.0 |
| 2006-03-02 09:15:00 | AAPL | Stock | 2.4586 | 2.4607 | 2.4582 | 2.4607 | 42000.0 |
| 2006-03-02 09:20:00 | AAPL | Stock | 2.4607 | 2.4614 | 2.4582 | 2.4593 | 110040.0 |
| 2006-03-02 09:25:00 | AAPL | Stock | 2.4607 | 2.4661 | 2.4607 | 2.4643 | 386736.0 |
| 2006-03-02 09:30:00 | AAPL | Stock | 2.4637 | 2.4729 | 2.4575 | 2.4718 | 18347140.0 |
| 2006-03-02 09:35:00 | AAPL | Stock | 2.4725 | 2.4954 | 2.4721 | 2.4893 | 26681396.0 |
| 2006-03-02 09:40:00 | AAPL | Stock | 2.49 | 2.49 | 2.4736 | 2.4814 | 15329076.0 |
| 2006-03-02 09:45:00 | AAPL | Stock | 2.4818 | 2.4875 | 2.4793 | 2.4846 | 11825800.0 |
| 2006-03-02 09:50:00 | AAPL | Stock | 2.4843 | 2.4904 | 2.4804 | 2.4821 | 10601136.0 |
| 2006-03-02 09:55:00 | AAPL | Stock | 2.4818 | 2.4836 | 2.4725 | 2.4786 | 13914824.0 |
| 2006-03-02 10:00:00 | AAPL | Stock | 2.4786 | 2.4889 | 2.4768 | 2.485 | 11836692.0 |
| 2006-03-02 10:05:00 | AAPL | Stock | 2.485 | 2.4861 | 2.4786 | 2.4839 | 7732620.0 |
| 2006-03-02 10:10:00 | AAPL | Stock | 2.4829 | 2.4857 | 2.4768 | 2.4782 | 7332556.0 |
| 2006-03-02 10:15:00 | AAPL | Stock | 2.4782 | 2.4825 | 2.4754 | 2.4775 | 7804860.0 |
| 2006-03-02 10:20:00 | AAPL | Stock | 2.4775 | 2.4825 | 2.4736 | 2.4779 | 8803032.0 |
| 2006-03-02 10:25:00 | AAPL | Stock | 2.4789 | 2.4789 | 2.4593 | 2.4643 | 23485784.0 |
| 2006-03-02 10:30:00 | AAPL | Stock | 2.4643 | 2.4654 | 2.4525 | 2.4561 | 15345568.0 |
| 2006-03-02 10:35:00 | AAPL | Stock | 2.4564 | 2.465 | 2.4564 | 2.4632 | 8470840.0 |
| 2006-03-02 10:40:00 | AAPL | Stock | 2.4632 | 2.4761 | 2.4614 | 2.4714 | 11516792.0 |
| 2006-03-02 10:45:00 | AAPL | Stock | 2.4714 | 2.4718 | 2.4664 | 2.4707 | 6504792.0 |
| 2006-03-02 10:50:00 | AAPL | Stock | 2.4704 | 2.4779 | 2.4689 | 2.4761 | 6703760.0 |
| 2006-03-02 10:55:00 | AAPL | Stock | 2.4764 | 2.4779 | 2.4732 | 2.4754 | 7963060.0 |
| 2006-03-02 11:00:00 | AAPL | Stock | 2.4754 | 2.4864 | 2.475 | 2.4846 | 10373300.0 |
| 2006-03-02 11:05:00 | AAPL | Stock | 2.4846 | 2.4893 | 2.4843 | 2.4854 | 8890924.0 |
| 2006-03-02 11:10:00 | AAPL | Stock | 2.4854 | 2.4875 | 2.4786 | 2.4829 | 7202076.0 |
| 2006-03-02 11:15:00 | AAPL | Stock | 2.4825 | 2.4835 | 2.4764 | 2.4768 | 7955976.0 |
| 2006-03-02 11:20:00 | AAPL | Stock | 2.4768 | 2.4786 | 2.4736 | 2.475 | 7399196.0 |
| 2006-03-02 11:25:00 | AAPL | Stock | 2.475 | 2.4786 | 2.475 | 2.4768 | 5358892.0 |
| 2006-03-02 11:30:00 | AAPL | Stock | 2.4764 | 2.4807 | 2.4745 | 2.4793 | 8016036.0 |
| 2006-03-02 11:35:00 | AAPL | Stock | 2.4782 | 2.4814 | 2.4775 | 2.4775 | 3362744.0 |
| 2006-03-02 11:40:00 | AAPL | Stock | 2.4771 | 2.4793 | 2.4757 | 2.4771 | 4375084.0 |
| 2006-03-02 11:45:00 | AAPL | Stock | 2.4775 | 2.4786 | 2.4714 | 2.4714 | 7552328.0 |
> showing 50 of 220,758 rows — these rows as CSV