PREVIEW / stock_5min / 2004-04-14
file: by_date/stock_5min/2004/2004-04-14.parquet size: 2.4 MB rows: 172,852 symbols: 1,757
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-04-14 08:00:00 | AAPL | Stock | 0.4793 | 0.4793 | 0.4793 | 0.4793 | 5600.0 |
| 2004-04-14 08:40:00 | AAPL | Stock | 0.4777 | 0.4777 | 0.4766 | 0.4766 | 50736.0 |
| 2004-04-14 08:45:00 | AAPL | Stock | 0.4766 | 0.4766 | 0.4766 | 0.4766 | 28000.0 |
| 2004-04-14 08:50:00 | AAPL | Stock | 0.4766 | 0.4766 | 0.4766 | 0.4766 | 84000.0 |
| 2004-04-14 08:55:00 | AAPL | Stock | 0.4766 | 0.4766 | 0.4766 | 0.4766 | 111664.0 |
| 2004-04-14 09:00:00 | AAPL | Stock | 0.4766 | 0.4766 | 0.4766 | 0.4766 | 5600.0 |
| 2004-04-14 09:10:00 | AAPL | Stock | 0.477 | 0.477 | 0.4766 | 0.4766 | 125440.0 |
| 2004-04-14 09:20:00 | AAPL | Stock | 0.4768 | 0.4768 | 0.4768 | 0.4768 | 61600.0 |
| 2004-04-14 09:25:00 | AAPL | Stock | 0.4752 | 0.4795 | 0.4739 | 0.4788 | 456960.0 |
| 2004-04-14 09:30:00 | AAPL | Stock | 0.4775 | 0.4802 | 0.4761 | 0.4791 | 1820280.0 |
| 2004-04-14 09:35:00 | AAPL | Stock | 0.478 | 0.4805 | 0.4766 | 0.4805 | 4088896.0 |
| 2004-04-14 09:40:00 | AAPL | Stock | 0.4805 | 0.4816 | 0.4798 | 0.4816 | 3998008.0 |
| 2004-04-14 09:45:00 | AAPL | Stock | 0.4813 | 0.4813 | 0.4773 | 0.4779 | 3448704.0 |
| 2004-04-14 09:50:00 | AAPL | Stock | 0.4777 | 0.4798 | 0.4775 | 0.4784 | 3008096.0 |
| 2004-04-14 09:55:00 | AAPL | Stock | 0.4786 | 0.4789 | 0.4771 | 0.4775 | 1910552.0 |
| 2004-04-14 10:00:00 | AAPL | Stock | 0.4773 | 0.4777 | 0.4764 | 0.4771 | 3962840.0 |
| 2004-04-14 10:05:00 | AAPL | Stock | 0.4773 | 0.4779 | 0.4773 | 0.4775 | 2903488.0 |
| 2004-04-14 10:10:00 | AAPL | Stock | 0.478 | 0.4793 | 0.4778 | 0.4786 | 3325560.0 |
| 2004-04-14 10:15:00 | AAPL | Stock | 0.4786 | 0.4796 | 0.4779 | 0.4779 | 1566488.0 |
| 2004-04-14 10:20:00 | AAPL | Stock | 0.4779 | 0.4786 | 0.4779 | 0.4784 | 7200200.0 |
| 2004-04-14 10:25:00 | AAPL | Stock | 0.4786 | 0.4821 | 0.4782 | 0.4821 | 2558752.0 |
| 2004-04-14 10:30:00 | AAPL | Stock | 0.4821 | 0.483 | 0.4813 | 0.4827 | 2175712.0 |
| 2004-04-14 10:35:00 | AAPL | Stock | 0.4827 | 0.483 | 0.4813 | 0.4813 | 6159664.0 |
| 2004-04-14 10:40:00 | AAPL | Stock | 0.4813 | 0.4821 | 0.4807 | 0.4818 | 1349152.0 |
| 2004-04-14 10:45:00 | AAPL | Stock | 0.482 | 0.4821 | 0.4818 | 0.4821 | 898520.0 |
| 2004-04-14 10:50:00 | AAPL | Stock | 0.4821 | 0.4821 | 0.482 | 0.4821 | 1682240.0 |
| 2004-04-14 10:55:00 | AAPL | Stock | 0.4821 | 0.4825 | 0.4816 | 0.4821 | 4185216.0 |
| 2004-04-14 11:00:00 | AAPL | Stock | 0.482 | 0.4829 | 0.4813 | 0.4814 | 4532080.0 |
| 2004-04-14 11:05:00 | AAPL | Stock | 0.4814 | 0.4834 | 0.4814 | 0.4832 | 5640488.0 |
| 2004-04-14 11:10:00 | AAPL | Stock | 0.483 | 0.483 | 0.4823 | 0.4825 | 1034320.0 |
| 2004-04-14 11:15:00 | AAPL | Stock | 0.4825 | 0.4825 | 0.4813 | 0.4816 | 1354192.0 |
| 2004-04-14 11:20:00 | AAPL | Stock | 0.4818 | 0.4827 | 0.4818 | 0.4823 | 1427608.0 |
| 2004-04-14 11:25:00 | AAPL | Stock | 0.4825 | 0.4829 | 0.4816 | 0.482 | 2787064.0 |
| 2004-04-14 11:30:00 | AAPL | Stock | 0.482 | 0.4821 | 0.4818 | 0.482 | 2622256.0 |
| 2004-04-14 11:35:00 | AAPL | Stock | 0.482 | 0.4821 | 0.4807 | 0.4809 | 2585912.0 |
| 2004-04-14 11:40:00 | AAPL | Stock | 0.4807 | 0.4809 | 0.4791 | 0.4796 | 2453584.0 |
| 2004-04-14 11:45:00 | AAPL | Stock | 0.4796 | 0.4798 | 0.4791 | 0.4796 | 1572424.0 |
| 2004-04-14 11:50:00 | AAPL | Stock | 0.4795 | 0.4798 | 0.4795 | 0.4795 | 488320.0 |
| 2004-04-14 11:55:00 | AAPL | Stock | 0.4795 | 0.4796 | 0.4791 | 0.4796 | 1454376.0 |
| 2004-04-14 12:00:00 | AAPL | Stock | 0.4796 | 0.4804 | 0.4795 | 0.4801 | 8564696.0 |
| 2004-04-14 12:05:00 | AAPL | Stock | 0.48 | 0.4818 | 0.4798 | 0.4807 | 1755096.0 |
| 2004-04-14 12:10:00 | AAPL | Stock | 0.4807 | 0.4807 | 0.48 | 0.4802 | 1553552.0 |
| 2004-04-14 12:15:00 | AAPL | Stock | 0.4802 | 0.4807 | 0.48 | 0.4804 | 2552536.0 |
| 2004-04-14 12:20:00 | AAPL | Stock | 0.4804 | 0.4814 | 0.4804 | 0.4811 | 1607872.0 |
| 2004-04-14 12:25:00 | AAPL | Stock | 0.4811 | 0.4816 | 0.4807 | 0.4813 | 5638248.0 |
| 2004-04-14 12:30:00 | AAPL | Stock | 0.4811 | 0.4814 | 0.4809 | 0.4809 | 1242920.0 |
| 2004-04-14 12:35:00 | AAPL | Stock | 0.4807 | 0.4807 | 0.4791 | 0.4791 | 1052800.0 |
| 2004-04-14 12:40:00 | AAPL | Stock | 0.4791 | 0.4791 | 0.4764 | 0.4766 | 4638032.0 |
| 2004-04-14 12:45:00 | AAPL | Stock | 0.4764 | 0.4775 | 0.4764 | 0.4768 | 3535000.0 |
| 2004-04-14 12:50:00 | AAPL | Stock | 0.4768 | 0.4777 | 0.4768 | 0.4775 | 2366560.0 |
> showing 50 of 172,852 rows — these rows as CSV