PREVIEW / stock_1min / 2008-09-15
file: by_date/stock_1min/2008/2008-09-15.parquet size: 12.7 MB rows: 1,011,649 symbols: 2,713
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-15 04:15:00 | AAPL | Stock | 5.25 | 5.25 | 5.1786 | 5.1786 | 7000.0 |
| 2008-09-15 04:29:00 | AAPL | Stock | 5.1786 | 5.1786 | 5.1786 | 5.1786 | 5600.0 |
| 2008-09-15 04:40:00 | AAPL | Stock | 5.1429 | 5.1429 | 5.1429 | 5.1429 | 2800.0 |
| 2008-09-15 05:27:00 | AAPL | Stock | 5.1104 | 5.1104 | 5.1104 | 5.1104 | 5600.0 |
| 2008-09-15 05:28:00 | AAPL | Stock | 5.1104 | 5.1104 | 5.1096 | 5.1104 | 28000.0 |
| 2008-09-15 05:29:00 | AAPL | Stock | 5.1071 | 5.1071 | 5.1071 | 5.1071 | 11200.0 |
| 2008-09-15 05:31:00 | AAPL | Stock | 5.1107 | 5.1107 | 5.1107 | 5.1107 | 12880.0 |
| 2008-09-15 06:29:00 | AAPL | Stock | 5.1071 | 5.1071 | 5.1071 | 5.1071 | 2800.0 |
| 2008-09-15 06:32:00 | AAPL | Stock | 5.1071 | 5.1071 | 5.1071 | 5.1071 | 16800.0 |
| 2008-09-15 06:33:00 | AAPL | Stock | 5.1418 | 5.1429 | 5.1418 | 5.1429 | 57680.0 |
| 2008-09-15 06:34:00 | AAPL | Stock | 5.1429 | 5.1429 | 5.1429 | 5.1429 | 2800.0 |
| 2008-09-15 06:38:00 | AAPL | Stock | 5.1429 | 5.1429 | 5.1429 | 5.1429 | 2800.0 |
| 2008-09-15 06:39:00 | AAPL | Stock | 5.1429 | 5.1429 | 5.1429 | 5.1429 | 14000.0 |
| 2008-09-15 06:40:00 | AAPL | Stock | 5.125 | 5.125 | 5.125 | 5.125 | 8400.0 |
| 2008-09-15 07:00:00 | AAPL | Stock | 5.1075 | 5.1096 | 5.1075 | 5.1075 | 32480.0 |
| 2008-09-15 07:01:00 | AAPL | Stock | 5.1075 | 5.1075 | 5.1075 | 5.1075 | 7980.0 |
| 2008-09-15 07:08:00 | AAPL | Stock | 5.1089 | 5.1089 | 5.1089 | 5.1089 | 4900.0 |
| 2008-09-15 07:14:00 | AAPL | Stock | 5.1075 | 5.1075 | 5.1075 | 5.1075 | 8400.0 |
| 2008-09-15 07:15:00 | AAPL | Stock | 5.1075 | 5.1161 | 5.1071 | 5.1075 | 109004.0 |
| 2008-09-15 07:16:00 | AAPL | Stock | 5.1075 | 5.1075 | 5.1071 | 5.1071 | 39200.0 |
| 2008-09-15 07:17:00 | AAPL | Stock | 5.1071 | 5.1089 | 5.1071 | 5.1071 | 106120.0 |
| 2008-09-15 07:18:00 | AAPL | Stock | 5.1089 | 5.1089 | 5.1089 | 5.1089 | 22400.0 |
| 2008-09-15 07:22:00 | AAPL | Stock | 5.1161 | 5.1161 | 5.1161 | 5.1161 | 16800.0 |
| 2008-09-15 07:27:00 | AAPL | Stock | 5.1107 | 5.1107 | 5.1107 | 5.1107 | 7168.0 |
| 2008-09-15 07:28:00 | AAPL | Stock | 5.1139 | 5.1143 | 5.1 | 5.1071 | 37352.0 |
| 2008-09-15 07:29:00 | AAPL | Stock | 5.1068 | 5.1068 | 5.0982 | 5.0982 | 17080.0 |
| 2008-09-15 07:30:00 | AAPL | Stock | 5.0946 | 5.0946 | 5.0714 | 5.075 | 244720.0 |
| 2008-09-15 07:32:00 | AAPL | Stock | 5.0714 | 5.0714 | 5.0714 | 5.0714 | 2800.0 |
| 2008-09-15 07:36:00 | AAPL | Stock | 5.0893 | 5.0893 | 5.0893 | 5.0893 | 15820.0 |
| 2008-09-15 07:37:00 | AAPL | Stock | 5.085 | 5.0893 | 5.085 | 5.085 | 97216.0 |
| 2008-09-15 07:38:00 | AAPL | Stock | 5.085 | 5.085 | 5.0714 | 5.0714 | 175672.0 |
| 2008-09-15 07:39:00 | AAPL | Stock | 5.0836 | 5.0836 | 5.0811 | 5.0811 | 19600.0 |
| 2008-09-15 07:40:00 | AAPL | Stock | 5.0846 | 5.0846 | 5.0846 | 5.0846 | 26376.0 |
| 2008-09-15 07:43:00 | AAPL | Stock | 5.0964 | 5.0964 | 5.0964 | 5.0964 | 5600.0 |
| 2008-09-15 07:45:00 | AAPL | Stock | 5.1071 | 5.1071 | 5.1071 | 5.1071 | 14000.0 |
| 2008-09-15 07:46:00 | AAPL | Stock | 5.0854 | 5.0911 | 5.0714 | 5.0714 | 167860.0 |
| 2008-09-15 07:48:00 | AAPL | Stock | 5.0914 | 5.0914 | 5.0914 | 5.0914 | 22428.0 |
| 2008-09-15 07:51:00 | AAPL | Stock | 5.0925 | 5.1071 | 5.0714 | 5.1071 | 233240.0 |
| 2008-09-15 07:52:00 | AAPL | Stock | 5.1071 | 5.1071 | 5.1071 | 5.1071 | 2800.0 |
| 2008-09-15 07:54:00 | AAPL | Stock | 5.0921 | 5.0921 | 5.0921 | 5.0921 | 2800.0 |
| 2008-09-15 07:55:00 | AAPL | Stock | 5.0943 | 5.0943 | 5.0939 | 5.0939 | 8400.0 |
| 2008-09-15 07:58:00 | AAPL | Stock | 5.0943 | 5.0943 | 5.0921 | 5.0929 | 95200.0 |
| 2008-09-15 08:00:00 | AAPL | Stock | 5.0921 | 5.1036 | 5.0732 | 5.0754 | 201796.0 |
| 2008-09-15 08:01:00 | AAPL | Stock | 5.0754 | 5.0796 | 5.0357 | 5.0643 | 224252.0 |
| 2008-09-15 08:02:00 | AAPL | Stock | 5.0368 | 5.0446 | 5.0075 | 5.0357 | 231700.0 |
| 2008-09-15 08:03:00 | AAPL | Stock | 5.0536 | 5.0671 | 5.0046 | 5.05 | 393540.0 |
| 2008-09-15 08:04:00 | AAPL | Stock | 5.05 | 5.0636 | 5.0439 | 5.0536 | 67200.0 |
| 2008-09-15 08:05:00 | AAPL | Stock | 5.0604 | 5.0607 | 5.0454 | 5.0536 | 70280.0 |
| 2008-09-15 08:06:00 | AAPL | Stock | 5.0621 | 5.0621 | 5.0436 | 5.0446 | 156800.0 |
| 2008-09-15 08:07:00 | AAPL | Stock | 5.0382 | 5.0382 | 5.0179 | 5.0179 | 301840.0 |
> showing 50 of 1,011,649 rows — these rows as CSV