PREVIEW / stock_1min / 2004-04-14
file: by_date/stock_1min/2004/2004-04-14.parquet size: 5.6 MB rows: 466,048 symbols: 1,448
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:03:00 | AAPL | Stock | 0.4793 | 0.4793 | 0.4793 | 0.4793 | 5600.0 |
| 2004-04-14 08:43:00 | AAPL | Stock | 0.4777 | 0.4777 | 0.4777 | 0.4777 | 22736.0 |
| 2004-04-14 08:44:00 | AAPL | Stock | 0.4766 | 0.4766 | 0.4766 | 0.4766 | 28000.0 |
| 2004-04-14 08:48: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 | 28000.0 |
| 2004-04-14 08:53:00 | AAPL | Stock | 0.4766 | 0.4766 | 0.4766 | 0.4766 | 5600.0 |
| 2004-04-14 08:54:00 | AAPL | Stock | 0.4766 | 0.4766 | 0.4766 | 0.4766 | 50400.0 |
| 2004-04-14 08:56:00 | AAPL | Stock | 0.4766 | 0.4766 | 0.4766 | 0.4766 | 28000.0 |
| 2004-04-14 08:58:00 | AAPL | Stock | 0.4766 | 0.4766 | 0.4766 | 0.4766 | 83664.0 |
| 2004-04-14 09:00:00 | AAPL | Stock | 0.4766 | 0.4766 | 0.4766 | 0.4766 | 5600.0 |
| 2004-04-14 09:12:00 | AAPL | Stock | 0.477 | 0.477 | 0.4766 | 0.4766 | 125440.0 |
| 2004-04-14 09:24:00 | AAPL | Stock | 0.4768 | 0.4768 | 0.4768 | 0.4768 | 61600.0 |
| 2004-04-14 09:27:00 | AAPL | Stock | 0.4752 | 0.4752 | 0.4748 | 0.4748 | 95200.0 |
| 2004-04-14 09:28:00 | AAPL | Stock | 0.4739 | 0.4748 | 0.4739 | 0.4743 | 190400.0 |
| 2004-04-14 09:29:00 | AAPL | Stock | 0.4761 | 0.4795 | 0.4761 | 0.4788 | 171360.0 |
| 2004-04-14 09:30:00 | AAPL | Stock | 0.4775 | 0.478 | 0.4761 | 0.4761 | 721000.0 |
| 2004-04-14 09:31:00 | AAPL | Stock | 0.4775 | 0.4777 | 0.4768 | 0.4773 | 262640.0 |
| 2004-04-14 09:32:00 | AAPL | Stock | 0.4773 | 0.4786 | 0.4773 | 0.4786 | 532000.0 |
| 2004-04-14 09:33:00 | AAPL | Stock | 0.4791 | 0.4798 | 0.4791 | 0.4798 | 78400.0 |
| 2004-04-14 09:34:00 | AAPL | Stock | 0.4795 | 0.4802 | 0.4788 | 0.4791 | 226240.0 |
| 2004-04-14 09:35:00 | AAPL | Stock | 0.478 | 0.478 | 0.4766 | 0.477 | 2245600.0 |
| 2004-04-14 09:36:00 | AAPL | Stock | 0.4779 | 0.4796 | 0.4779 | 0.4788 | 184800.0 |
| 2004-04-14 09:37:00 | AAPL | Stock | 0.4789 | 0.4795 | 0.4788 | 0.4795 | 479920.0 |
| 2004-04-14 09:38:00 | AAPL | Stock | 0.4795 | 0.4796 | 0.4795 | 0.4795 | 906976.0 |
| 2004-04-14 09:39:00 | AAPL | Stock | 0.4795 | 0.4805 | 0.4791 | 0.4805 | 271600.0 |
| 2004-04-14 09:40:00 | AAPL | Stock | 0.4805 | 0.4805 | 0.4798 | 0.4804 | 696360.0 |
| 2004-04-14 09:41:00 | AAPL | Stock | 0.4799 | 0.4805 | 0.4798 | 0.4802 | 305200.0 |
| 2004-04-14 09:42:00 | AAPL | Stock | 0.4805 | 0.4811 | 0.4802 | 0.4807 | 2497600.0 |
| 2004-04-14 09:43:00 | AAPL | Stock | 0.4807 | 0.4816 | 0.4807 | 0.4814 | 324800.0 |
| 2004-04-14 09:44:00 | AAPL | Stock | 0.4816 | 0.4816 | 0.4813 | 0.4816 | 174048.0 |
| 2004-04-14 09:45:00 | AAPL | Stock | 0.4813 | 0.4813 | 0.4782 | 0.4784 | 1386560.0 |
| 2004-04-14 09:46:00 | AAPL | Stock | 0.4786 | 0.4798 | 0.4786 | 0.4798 | 56000.0 |
| 2004-04-14 09:47:00 | AAPL | Stock | 0.4795 | 0.4796 | 0.4786 | 0.4786 | 247520.0 |
| 2004-04-14 09:48:00 | AAPL | Stock | 0.4786 | 0.4795 | 0.478 | 0.4784 | 643440.0 |
| 2004-04-14 09:49:00 | AAPL | Stock | 0.4782 | 0.4782 | 0.4773 | 0.4779 | 1115184.0 |
| 2004-04-14 09:50:00 | AAPL | Stock | 0.4777 | 0.4779 | 0.4775 | 0.4779 | 136584.0 |
| 2004-04-14 09:51:00 | AAPL | Stock | 0.4779 | 0.4798 | 0.4779 | 0.4798 | 432712.0 |
| 2004-04-14 09:52:00 | AAPL | Stock | 0.4789 | 0.4791 | 0.4788 | 0.4788 | 168000.0 |
| 2004-04-14 09:53:00 | AAPL | Stock | 0.4786 | 0.4786 | 0.4782 | 0.4782 | 67200.0 |
| 2004-04-14 09:54:00 | AAPL | Stock | 0.4786 | 0.4789 | 0.4779 | 0.4784 | 2203600.0 |
| 2004-04-14 09:55:00 | AAPL | Stock | 0.4786 | 0.4788 | 0.4784 | 0.4784 | 929600.0 |
| 2004-04-14 09:56:00 | AAPL | Stock | 0.4777 | 0.4789 | 0.4777 | 0.4786 | 67200.0 |
| 2004-04-14 09:57:00 | AAPL | Stock | 0.4788 | 0.4788 | 0.4784 | 0.4786 | 191632.0 |
| 2004-04-14 09:58:00 | AAPL | Stock | 0.4782 | 0.4782 | 0.4773 | 0.4778 | 299600.0 |
| 2004-04-14 09:59:00 | AAPL | Stock | 0.4773 | 0.4777 | 0.4771 | 0.4775 | 422520.0 |
| 2004-04-14 10:00:00 | AAPL | Stock | 0.4773 | 0.4773 | 0.4768 | 0.4773 | 711760.0 |
| 2004-04-14 10:01:00 | AAPL | Stock | 0.4775 | 0.4777 | 0.4773 | 0.4773 | 1178128.0 |
| 2004-04-14 10:02:00 | AAPL | Stock | 0.4771 | 0.4773 | 0.4764 | 0.4768 | 1155000.0 |
| 2004-04-14 10:03:00 | AAPL | Stock | 0.4768 | 0.4771 | 0.4768 | 0.4771 | 509600.0 |
| 2004-04-14 10:04:00 | AAPL | Stock | 0.4771 | 0.4773 | 0.477 | 0.4771 | 408352.0 |
> showing 50 of 466,048 rows — these rows as CSV