PREVIEW / stock_1hour / 2002-12-05
file: by_date/stock_1hour/2002/2002-12-05.parquet size: 410 KB rows: 19,459 symbols: 1,516
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-12-05 08:00:00 | AAPL | Stock | 0.2679 | 0.2709 | 0.2675 | 0.2709 | 151200.0 |
| 2002-12-05 09:00:00 | AAPL | Stock | 0.2698 | 0.2698 | 0.2625 | 0.2646 | 30033248.0 |
| 2002-12-05 10:00:00 | AAPL | Stock | 0.2648 | 0.2668 | 0.2616 | 0.2638 | 38324216.0 |
| 2002-12-05 11:00:00 | AAPL | Stock | 0.2638 | 0.2639 | 0.2605 | 0.2623 | 31146528.0 |
| 2002-12-05 12:00:00 | AAPL | Stock | 0.2621 | 0.263 | 0.2613 | 0.2618 | 22411032.0 |
| 2002-12-05 13:00:00 | AAPL | Stock | 0.2618 | 0.2629 | 0.2613 | 0.2618 | 20455344.0 |
| 2002-12-05 14:00:00 | AAPL | Stock | 0.2618 | 0.2668 | 0.2607 | 0.2614 | 33191144.0 |
| 2002-12-05 15:00:00 | AAPL | Stock | 0.2614 | 0.2625 | 0.2595 | 0.2614 | 45053848.0 |
| 2002-12-05 16:00:00 | AAPL | Stock | 0.2613 | 0.267 | 0.2604 | 0.2613 | 7263200.0 |
| 2002-12-05 17:00:00 | AAPL | Stock | 0.2613 | 0.2625 | 0.2613 | 0.2613 | 3029600.0 |
| 2002-12-05 08:00:00 | MSFT | Stock | 28.475 | 28.65 | 28.275 | 28.5 | 129798.0 |
| 2002-12-05 09:00:00 | MSFT | Stock | 28.475 | 28.65 | 28.27 | 28.285 | 10268158.0 |
| 2002-12-05 10:00:00 | MSFT | Stock | 28.2895 | 28.37 | 28.05 | 28.135 | 12223492.0 |
| 2002-12-05 11:00:00 | MSFT | Stock | 28.13 | 28.135 | 27.805 | 27.9605 | 10883520.0 |
| 2002-12-05 12:00:00 | MSFT | Stock | 27.96 | 27.985 | 27.835 | 27.8745 | 5327310.0 |
| 2002-12-05 13:00:00 | MSFT | Stock | 27.867 | 27.965 | 27.76 | 27.965 | 5393212.0 |
| 2002-12-05 14:00:00 | MSFT | Stock | 27.9595 | 28.105 | 27.905 | 27.935 | 7361800.0 |
| 2002-12-05 15:00:00 | MSFT | Stock | 27.9355 | 27.945 | 27.65 | 27.66 | 10573820.0 |
| 2002-12-05 16:00:00 | MSFT | Stock | 27.68 | 28.03 | 27.65 | 27.675 | 1541968.0 |
| 2002-12-05 17:00:00 | MSFT | Stock | 27.715 | 27.75 | 27.5 | 27.68 | 770756.0 |
| 2002-12-05 18:00:00 | MSFT | Stock | 27.6 | 27.655 | 27.55 | 27.655 | 15176.0 |
| 2002-12-05 08:00:00 | NVDA | Stock | 0.1192 | 0.1225 | 0.1165 | 0.1212 | 28646760.0 |
| 2002-12-05 09:00:00 | NVDA | Stock | 0.1212 | 0.1248 | 0.1187 | 0.1193 | 319633320.0 |
| 2002-12-05 10:00:00 | NVDA | Stock | 0.1193 | 0.1212 | 0.1187 | 0.1201 | 199123200.0 |
| 2002-12-05 11:00:00 | NVDA | Stock | 0.1197 | 0.1199 | 0.1147 | 0.1172 | 363194400.0 |
| 2002-12-05 12:00:00 | NVDA | Stock | 0.1172 | 0.1187 | 0.1162 | 0.1176 | 118186320.0 |
| 2002-12-05 13:00:00 | NVDA | Stock | 0.1176 | 0.1202 | 0.1173 | 0.1191 | 131029080.0 |
| 2002-12-05 14:00:00 | NVDA | Stock | 0.1191 | 0.1212 | 0.1185 | 0.1192 | 133977720.0 |
| 2002-12-05 15:00:00 | NVDA | Stock | 0.1192 | 0.1196 | 0.1168 | 0.1176 | 183427560.0 |
| 2002-12-05 16:00:00 | NVDA | Stock | 0.1178 | 0.1198 | 0.1176 | 0.1186 | 10624320.0 |
| 2002-12-05 17:00:00 | NVDA | Stock | 0.1189 | 0.1193 | 0.1176 | 0.1176 | 6815040.0 |
| 2002-12-05 18:00:00 | NVDA | Stock | 0.1175 | 0.1187 | 0.1172 | 0.1177 | 1292880.0 |
| 2002-12-05 08:00:00 | AMZN | Stock | 1.1815 | 1.185 | 1.17 | 1.185 | 130000.0 |
| 2002-12-05 09:00:00 | AMZN | Stock | 1.1795 | 1.1865 | 1.15 | 1.154 | 18096060.0 |
| 2002-12-05 10:00:00 | AMZN | Stock | 1.154 | 1.162 | 1.1226 | 1.1235 | 34733020.0 |
| 2002-12-05 11:00:00 | AMZN | Stock | 1.1235 | 1.14 | 1.11 | 1.14 | 60307600.0 |
| 2002-12-05 12:00:00 | AMZN | Stock | 1.1375 | 1.138 | 1.126 | 1.1265 | 12671460.0 |
| 2002-12-05 13:00:00 | AMZN | Stock | 1.126 | 1.131 | 1.12 | 1.129 | 15762480.0 |
| 2002-12-05 14:00:00 | AMZN | Stock | 1.129 | 1.136 | 1.123 | 1.125 | 13213320.0 |
| 2002-12-05 15:00:00 | AMZN | Stock | 1.125 | 1.1335 | 1.122 | 1.129 | 32884320.0 |
| 2002-12-05 16:00:00 | AMZN | Stock | 1.1286 | 1.1335 | 1.1255 | 1.1325 | 6422380.0 |
| 2002-12-05 17:00:00 | AMZN | Stock | 1.129 | 1.1325 | 1.129 | 1.131 | 931380.0 |
| 2002-12-05 18:00:00 | AMZN | Stock | 1.129 | 1.129 | 1.129 | 1.129 | 16000.0 |
| 2002-12-05 09:00:00 | CL | Stock | 26.56 | 26.825 | 26.555 | 26.565 | 351000.0 |
| 2002-12-05 10:00:00 | CL | Stock | 26.565 | 26.575 | 26.355 | 26.455 | 711600.0 |
| 2002-12-05 11:00:00 | CL | Stock | 26.455 | 26.54 | 26.415 | 26.425 | 474600.0 |
| 2002-12-05 12:00:00 | CL | Stock | 26.42 | 26.505 | 26.305 | 26.325 | 294800.0 |
| 2002-12-05 13:00:00 | CL | Stock | 26.325 | 26.475 | 26.31 | 26.415 | 333000.0 |
| 2002-12-05 14:00:00 | CL | Stock | 26.41 | 26.5 | 26.35 | 26.375 | 414400.0 |
| 2002-12-05 15:00:00 | CL | Stock | 26.375 | 26.415 | 26.275 | 26.285 | 550000.0 |
> showing 50 of 19,459 rows — these rows as CSV