PREVIEW / stock_1hour / 2003-04-28
file: by_date/stock_1hour/2003/2003-04-28.parquet size: 427 KB rows: 21,477 symbols: 1,579
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 |
|---|---|---|---|---|---|---|---|
| 2003-04-28 08:00:00 | AAPL | Stock | 0.2393 | 0.2402 | 0.2393 | 0.2402 | 123200.0 |
| 2003-04-28 09:00:00 | AAPL | Stock | 0.241 | 0.2491 | 0.2397 | 0.2486 | 64862448.0 |
| 2003-04-28 10:00:00 | AAPL | Stock | 0.2486 | 0.2493 | 0.2463 | 0.2479 | 83517672.0 |
| 2003-04-28 11:00:00 | AAPL | Stock | 0.2479 | 0.2484 | 0.2439 | 0.2441 | 54427520.0 |
| 2003-04-28 12:00:00 | AAPL | Stock | 0.2441 | 0.2452 | 0.2411 | 0.245 | 84054880.0 |
| 2003-04-28 13:00:00 | AAPL | Stock | 0.245 | 0.2452 | 0.2438 | 0.2446 | 54777800.0 |
| 2003-04-28 14:00:00 | AAPL | Stock | 0.2446 | 0.247 | 0.2441 | 0.2454 | 112561120.0 |
| 2003-04-28 15:00:00 | AAPL | Stock | 0.2454 | 0.2489 | 0.2448 | 0.2475 | 123001144.0 |
| 2003-04-28 16:00:00 | AAPL | Stock | 0.2475 | 0.248 | 0.2467 | 0.2475 | 11729200.0 |
| 2003-04-28 17:00:00 | AAPL | Stock | 0.2475 | 0.2482 | 0.2473 | 0.2482 | 576800.0 |
| 2003-04-28 18:00:00 | AAPL | Stock | 0.2482 | 0.2482 | 0.2482 | 0.2482 | 61600.0 |
| 2003-04-28 08:00:00 | MSFT | Stock | 25.35 | 27.0 | 25.32 | 25.41 | 78600.0 |
| 2003-04-28 09:00:00 | MSFT | Stock | 25.41 | 25.524 | 25.32 | 25.51 | 7042649.0 |
| 2003-04-28 10:00:00 | MSFT | Stock | 25.51 | 25.72 | 25.45 | 25.6898 | 8680340.0 |
| 2003-04-28 11:00:00 | MSFT | Stock | 25.689 | 25.77 | 25.68 | 25.74 | 7642763.0 |
| 2003-04-28 12:00:00 | MSFT | Stock | 25.74 | 25.87 | 25.72 | 25.84 | 6961757.0 |
| 2003-04-28 13:00:00 | MSFT | Stock | 25.84 | 25.85 | 25.7 | 25.799 | 4555623.0 |
| 2003-04-28 14:00:00 | MSFT | Stock | 25.7969 | 25.94 | 25.77 | 25.85 | 6072757.0 |
| 2003-04-28 15:00:00 | MSFT | Stock | 25.85 | 25.89 | 25.72 | 25.75 | 8048619.0 |
| 2003-04-28 16:00:00 | MSFT | Stock | 25.78 | 25.9017 | 25.65 | 25.72 | 1334631.0 |
| 2003-04-28 17:00:00 | MSFT | Stock | 25.72 | 25.786 | 25.7 | 25.7 | 40901.0 |
| 2003-04-28 18:00:00 | MSFT | Stock | 25.7 | 25.719 | 25.679 | 25.7 | 3417.0 |
| 2003-04-28 08:00:00 | NVDA | Stock | 0.1139 | 0.114 | 0.1139 | 0.114 | 792000.0 |
| 2003-04-28 09:00:00 | NVDA | Stock | 0.1134 | 0.1156 | 0.1129 | 0.1154 | 88452480.0 |
| 2003-04-28 10:00:00 | NVDA | Stock | 0.1153 | 0.1168 | 0.1153 | 0.1167 | 99391560.0 |
| 2003-04-28 11:00:00 | NVDA | Stock | 0.1167 | 0.1184 | 0.1166 | 0.1172 | 139109880.0 |
| 2003-04-28 12:00:00 | NVDA | Stock | 0.1172 | 0.1172 | 0.1159 | 0.1163 | 88088640.0 |
| 2003-04-28 13:00:00 | NVDA | Stock | 0.1163 | 0.1172 | 0.1158 | 0.1172 | 75229200.0 |
| 2003-04-28 14:00:00 | NVDA | Stock | 0.1172 | 0.1178 | 0.1163 | 0.1165 | 62290200.0 |
| 2003-04-28 15:00:00 | NVDA | Stock | 0.1165 | 0.117 | 0.116 | 0.1163 | 56971920.0 |
| 2003-04-28 16:00:00 | NVDA | Stock | 0.1163 | 0.1163 | 0.116 | 0.1162 | 4836120.0 |
| 2003-04-28 17:00:00 | NVDA | Stock | 0.1162 | 0.1163 | 0.1162 | 0.1163 | 1020000.0 |
| 2003-04-28 08:00:00 | AMZN | Stock | 1.44 | 1.4525 | 1.4375 | 1.4495 | 698000.0 |
| 2003-04-28 09:00:00 | AMZN | Stock | 1.4475 | 1.487 | 1.4305 | 1.4424 | 48877920.0 |
| 2003-04-28 10:00:00 | AMZN | Stock | 1.443 | 1.447 | 1.4335 | 1.4365 | 53454540.0 |
| 2003-04-28 11:00:00 | AMZN | Stock | 1.436 | 1.4392 | 1.434 | 1.436 | 24918660.0 |
| 2003-04-28 12:00:00 | AMZN | Stock | 1.4355 | 1.4465 | 1.434 | 1.4465 | 23336340.0 |
| 2003-04-28 13:00:00 | AMZN | Stock | 1.4465 | 1.4595 | 1.4425 | 1.4545 | 46857400.0 |
| 2003-04-28 14:00:00 | AMZN | Stock | 1.4555 | 1.459 | 1.448 | 1.4495 | 28356840.0 |
| 2003-04-28 15:00:00 | AMZN | Stock | 1.4495 | 1.4585 | 1.4485 | 1.4565 | 27736700.0 |
| 2003-04-28 16:00:00 | AMZN | Stock | 1.457 | 1.458 | 1.4525 | 1.4555 | 3551900.0 |
| 2003-04-28 17:00:00 | AMZN | Stock | 1.4565 | 1.4595 | 1.455 | 1.4595 | 496000.0 |
| 2003-04-28 18:00:00 | AMZN | Stock | 1.4585 | 1.46 | 1.4585 | 1.46 | 272000.0 |
| 2003-04-28 09:00:00 | CL | Stock | 28.36 | 28.595 | 28.28 | 28.575 | 313800.0 |
| 2003-04-28 10:00:00 | CL | Stock | 28.575 | 28.805 | 28.56 | 28.79 | 439600.0 |
| 2003-04-28 11:00:00 | CL | Stock | 28.79 | 28.83 | 28.73 | 28.75 | 239600.0 |
| 2003-04-28 12:00:00 | CL | Stock | 28.745 | 28.745 | 28.625 | 28.725 | 272400.0 |
| 2003-04-28 13:00:00 | CL | Stock | 28.735 | 28.74 | 28.625 | 28.705 | 185000.0 |
| 2003-04-28 14:00:00 | CL | Stock | 28.705 | 28.8 | 28.665 | 28.8 | 236200.0 |
| 2003-04-28 15:00:00 | CL | Stock | 28.8 | 28.82 | 28.675 | 28.71 | 423400.0 |
> showing 50 of 21,477 rows — these rows as CSV