PREVIEW / stock_1hour / 2002-11-19
file: by_date/stock_1hour/2002/2002-11-19.parquet size: 409 KB rows: 19,658 symbols: 1,502
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 |
|---|---|---|---|---|---|---|---|
| 2002-11-19 08:00:00 | AAPL | Stock | 0.2786 | 0.2786 | 0.2786 | 0.2786 | 39200.0 |
| 2002-11-19 09:00:00 | AAPL | Stock | 0.2795 | 0.2813 | 0.2761 | 0.2777 | 28606144.0 |
| 2002-11-19 10:00:00 | AAPL | Stock | 0.2779 | 0.2807 | 0.2743 | 0.2743 | 25360328.0 |
| 2002-11-19 11:00:00 | AAPL | Stock | 0.2743 | 0.2759 | 0.2732 | 0.2739 | 14675528.0 |
| 2002-11-19 12:00:00 | AAPL | Stock | 0.2745 | 0.277 | 0.2739 | 0.2766 | 15056048.0 |
| 2002-11-19 13:00:00 | AAPL | Stock | 0.2766 | 0.2807 | 0.2741 | 0.2757 | 22889944.0 |
| 2002-11-19 14:00:00 | AAPL | Stock | 0.2755 | 0.2757 | 0.2714 | 0.2723 | 26288640.0 |
| 2002-11-19 15:00:00 | AAPL | Stock | 0.2721 | 0.2736 | 0.268 | 0.2727 | 47780096.0 |
| 2002-11-19 16:00:00 | AAPL | Stock | 0.2727 | 0.2739 | 0.2721 | 0.2726 | 7298200.0 |
| 2002-11-19 17:00:00 | AAPL | Stock | 0.2734 | 0.2734 | 0.2727 | 0.2727 | 2620800.0 |
| 2002-11-19 08:00:00 | MSFT | Stock | 27.855 | 27.925 | 27.775 | 27.85 | 90376.0 |
| 2002-11-19 09:00:00 | MSFT | Stock | 27.85 | 27.925 | 27.405 | 27.43 | 12132946.0 |
| 2002-11-19 10:00:00 | MSFT | Stock | 27.44 | 27.57 | 27.25 | 27.425 | 14425072.0 |
| 2002-11-19 11:00:00 | MSFT | Stock | 27.43 | 27.475 | 27.323 | 27.335 | 7704322.0 |
| 2002-11-19 12:00:00 | MSFT | Stock | 27.335 | 27.625 | 27.32 | 27.56 | 7894034.0 |
| 2002-11-19 13:00:00 | MSFT | Stock | 27.575 | 27.741 | 27.57 | 27.625 | 9062872.0 |
| 2002-11-19 14:00:00 | MSFT | Stock | 27.625 | 27.645 | 27.325 | 27.385 | 9298254.0 |
| 2002-11-19 15:00:00 | MSFT | Stock | 27.3805 | 27.44 | 27.155 | 27.43 | 11802136.0 |
| 2002-11-19 16:00:00 | MSFT | Stock | 27.435 | 27.55 | 27.405 | 27.495 | 1444968.0 |
| 2002-11-19 17:00:00 | MSFT | Stock | 27.5 | 27.555 | 27.415 | 27.415 | 322976.0 |
| 2002-11-19 18:00:00 | MSFT | Stock | 27.465 | 27.465 | 27.43 | 27.43 | 11000.0 |
| 2002-11-19 08:00:00 | NVDA | Stock | 0.1167 | 0.1167 | 0.115 | 0.1154 | 1187400.0 |
| 2002-11-19 09:00:00 | NVDA | Stock | 0.1152 | 0.124 | 0.1145 | 0.1199 | 443419560.0 |
| 2002-11-19 10:00:00 | NVDA | Stock | 0.1202 | 0.1221 | 0.1187 | 0.1213 | 388156320.0 |
| 2002-11-19 11:00:00 | NVDA | Stock | 0.1214 | 0.1236 | 0.1212 | 0.1225 | 222701280.0 |
| 2002-11-19 12:00:00 | NVDA | Stock | 0.1224 | 0.1228 | 0.1206 | 0.1222 | 153174240.0 |
| 2002-11-19 13:00:00 | NVDA | Stock | 0.1223 | 0.1232 | 0.1212 | 0.1217 | 129016200.0 |
| 2002-11-19 14:00:00 | NVDA | Stock | 0.1217 | 0.1221 | 0.1192 | 0.1194 | 150225600.0 |
| 2002-11-19 15:00:00 | NVDA | Stock | 0.1194 | 0.1199 | 0.1164 | 0.1182 | 279996720.0 |
| 2002-11-19 16:00:00 | NVDA | Stock | 0.1182 | 0.119 | 0.1178 | 0.1181 | 26969400.0 |
| 2002-11-19 17:00:00 | NVDA | Stock | 0.1186 | 0.1186 | 0.1181 | 0.1183 | 11454000.0 |
| 2002-11-19 18:00:00 | NVDA | Stock | 0.1183 | 0.1186 | 0.1182 | 0.1186 | 596160.0 |
| 2002-11-19 08:00:00 | AMZN | Stock | 1.105 | 1.126 | 1.0825 | 1.0915 | 2533080.0 |
| 2002-11-19 09:00:00 | AMZN | Stock | 1.095 | 1.1195 | 1.078 | 1.084 | 44680880.0 |
| 2002-11-19 10:00:00 | AMZN | Stock | 1.0842 | 1.0883 | 1.07 | 1.081 | 49341240.0 |
| 2002-11-19 11:00:00 | AMZN | Stock | 1.081 | 1.0875 | 1.066 | 1.068 | 23931160.0 |
| 2002-11-19 12:00:00 | AMZN | Stock | 1.068 | 1.0785 | 1.063 | 1.0715 | 23841400.0 |
| 2002-11-19 13:00:00 | AMZN | Stock | 1.0715 | 1.0805 | 1.07 | 1.0765 | 22283940.0 |
| 2002-11-19 14:00:00 | AMZN | Stock | 1.0765 | 1.0795 | 1.068 | 1.068 | 20275320.0 |
| 2002-11-19 15:00:00 | AMZN | Stock | 1.068 | 1.0715 | 1.0615 | 1.0649 | 38123540.0 |
| 2002-11-19 16:00:00 | AMZN | Stock | 1.0645 | 1.0725 | 1.0625 | 1.0725 | 4899800.0 |
| 2002-11-19 17:00:00 | AMZN | Stock | 1.0655 | 1.069 | 1.0645 | 1.0645 | 588800.0 |
| 2002-11-19 18:00:00 | AMZN | Stock | 1.0635 | 1.0635 | 1.0635 | 1.0635 | 40000.0 |
| 2002-11-19 09:00:00 | CL | Stock | 26.2 | 26.55 | 26.2 | 26.545 | 351800.0 |
| 2002-11-19 10:00:00 | CL | Stock | 26.55 | 26.72 | 26.495 | 26.5 | 466000.0 |
| 2002-11-19 11:00:00 | CL | Stock | 26.5 | 26.59 | 26.49 | 26.525 | 373000.0 |
| 2002-11-19 12:00:00 | CL | Stock | 26.525 | 26.665 | 26.495 | 26.63 | 253200.0 |
| 2002-11-19 13:00:00 | CL | Stock | 26.63 | 26.65 | 26.465 | 26.52 | 350600.0 |
| 2002-11-19 14:00:00 | CL | Stock | 26.52 | 26.575 | 26.38 | 26.39 | 418200.0 |
| 2002-11-19 15:00:00 | CL | Stock | 26.385 | 26.43 | 26.305 | 26.4 | 614400.0 |
> showing 50 of 19,658 rows — these rows as CSV