PREVIEW / stock_1hour / 2003-04-29
file: by_date/stock_1hour/2003/2003-04-29.parquet size: 418 KB rows: 20,682 symbols: 1,573
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-29 08:00:00 | AAPL | Stock | 0.2479 | 0.25 | 0.2479 | 0.2496 | 131600.0 |
| 2003-04-29 09:00:00 | AAPL | Stock | 0.2489 | 0.2509 | 0.2464 | 0.2468 | 82803000.0 |
| 2003-04-29 10:00:00 | AAPL | Stock | 0.2471 | 0.2495 | 0.2425 | 0.2439 | 72019472.0 |
| 2003-04-29 11:00:00 | AAPL | Stock | 0.2443 | 0.2459 | 0.2432 | 0.2454 | 29692152.0 |
| 2003-04-29 12:00:00 | AAPL | Stock | 0.2455 | 0.2486 | 0.2448 | 0.2477 | 58240896.0 |
| 2003-04-29 13:00:00 | AAPL | Stock | 0.2477 | 0.2493 | 0.2473 | 0.2488 | 43926176.0 |
| 2003-04-29 14:00:00 | AAPL | Stock | 0.2489 | 0.2516 | 0.2486 | 0.2516 | 42391720.0 |
| 2003-04-29 15:00:00 | AAPL | Stock | 0.2514 | 0.2529 | 0.2488 | 0.2511 | 86195256.0 |
| 2003-04-29 16:00:00 | AAPL | Stock | 0.2511 | 0.2516 | 0.2498 | 0.2511 | 5644352.0 |
| 2003-04-29 17:00:00 | AAPL | Stock | 0.2511 | 0.2511 | 0.2504 | 0.2504 | 67200.0 |
| 2003-04-29 08:00:00 | MSFT | Stock | 25.84 | 25.881 | 25.79 | 25.88 | 55530.0 |
| 2003-04-29 09:00:00 | MSFT | Stock | 25.879 | 26.11 | 25.86 | 26.06 | 9464336.0 |
| 2003-04-29 10:00:00 | MSFT | Stock | 26.08 | 26.25 | 25.7 | 25.75 | 15610688.0 |
| 2003-04-29 11:00:00 | MSFT | Stock | 25.75 | 25.92 | 25.68 | 25.89 | 6559964.0 |
| 2003-04-29 12:00:00 | MSFT | Stock | 25.88 | 25.91 | 25.77 | 25.84 | 4439194.0 |
| 2003-04-29 13:00:00 | MSFT | Stock | 25.836 | 25.91 | 25.72 | 25.79 | 4964475.0 |
| 2003-04-29 14:00:00 | MSFT | Stock | 25.79 | 25.88 | 25.76 | 25.87 | 5775123.0 |
| 2003-04-29 15:00:00 | MSFT | Stock | 25.87 | 26.05 | 25.78 | 25.8 | 11383996.0 |
| 2003-04-29 16:00:00 | MSFT | Stock | 25.8 | 25.8616 | 24.77 | 25.77 | 1774700.0 |
| 2003-04-29 17:00:00 | MSFT | Stock | 25.77 | 25.831 | 25.76 | 25.78 | 47876.0 |
| 2003-04-29 18:00:00 | MSFT | Stock | 25.78 | 25.81 | 25.78 | 25.81 | 11982.0 |
| 2003-04-29 08:00:00 | NVDA | Stock | 0.1167 | 0.1197 | 0.1167 | 0.1187 | 16758480.0 |
| 2003-04-29 09:00:00 | NVDA | Stock | 0.1187 | 0.1216 | 0.1175 | 0.1206 | 172475760.0 |
| 2003-04-29 10:00:00 | NVDA | Stock | 0.1206 | 0.1216 | 0.1187 | 0.1193 | 147141720.0 |
| 2003-04-29 11:00:00 | NVDA | Stock | 0.1195 | 0.1204 | 0.1192 | 0.1199 | 43073640.0 |
| 2003-04-29 12:00:00 | NVDA | Stock | 0.1198 | 0.1203 | 0.1192 | 0.1194 | 33562080.0 |
| 2003-04-29 13:00:00 | NVDA | Stock | 0.1194 | 0.1197 | 0.1183 | 0.1188 | 43608360.0 |
| 2003-04-29 14:00:00 | NVDA | Stock | 0.1189 | 0.1199 | 0.1188 | 0.1197 | 31009680.0 |
| 2003-04-29 15:00:00 | NVDA | Stock | 0.1197 | 0.1211 | 0.1195 | 0.1197 | 133341720.0 |
| 2003-04-29 16:00:00 | NVDA | Stock | 0.1199 | 0.1202 | 0.1192 | 0.1199 | 6641760.0 |
| 2003-04-29 17:00:00 | NVDA | Stock | 0.1199 | 0.1202 | 0.1199 | 0.1202 | 180000.0 |
| 2003-04-29 18:00:00 | NVDA | Stock | 0.1202 | 0.1202 | 0.1202 | 0.1202 | 144000.0 |
| 2003-04-29 08:00:00 | AMZN | Stock | 1.46 | 1.461 | 1.456 | 1.456 | 401300.0 |
| 2003-04-29 09:00:00 | AMZN | Stock | 1.4555 | 1.459 | 1.4305 | 1.4395 | 45799880.0 |
| 2003-04-29 10:00:00 | AMZN | Stock | 1.44 | 1.452 | 1.436 | 1.4375 | 46989980.0 |
| 2003-04-29 11:00:00 | AMZN | Stock | 1.4375 | 1.444 | 1.4335 | 1.4415 | 25325520.0 |
| 2003-04-29 12:00:00 | AMZN | Stock | 1.4405 | 1.446 | 1.4375 | 1.439 | 11915760.0 |
| 2003-04-29 13:00:00 | AMZN | Stock | 1.4385 | 1.442 | 1.4355 | 1.44 | 15305840.0 |
| 2003-04-29 14:00:00 | AMZN | Stock | 1.4415 | 1.446 | 1.4365 | 1.444 | 18118180.0 |
| 2003-04-29 15:00:00 | AMZN | Stock | 1.4435 | 1.45 | 1.4425 | 1.4449 | 30025340.0 |
| 2003-04-29 16:00:00 | AMZN | Stock | 1.4445 | 1.45 | 1.444 | 1.4465 | 2032240.0 |
| 2003-04-29 17:00:00 | AMZN | Stock | 1.445 | 1.4485 | 1.444 | 1.444 | 279000.0 |
| 2003-04-29 18:00:00 | AMZN | Stock | 1.444 | 1.4442 | 1.443 | 1.443 | 22000.0 |
| 2003-04-29 09:00:00 | CL | Stock | 28.625 | 28.645 | 28.52 | 28.56 | 332600.0 |
| 2003-04-29 10:00:00 | CL | Stock | 28.56 | 28.755 | 28.54 | 28.57 | 964000.0 |
| 2003-04-29 11:00:00 | CL | Stock | 28.575 | 28.605 | 28.53 | 28.575 | 316800.0 |
| 2003-04-29 12:00:00 | CL | Stock | 28.565 | 28.695 | 28.56 | 28.625 | 253400.0 |
| 2003-04-29 13:00:00 | CL | Stock | 28.63 | 28.715 | 28.61 | 28.675 | 557400.0 |
| 2003-04-29 14:00:00 | CL | Stock | 28.675 | 28.825 | 28.66 | 28.825 | 396000.0 |
| 2003-04-29 15:00:00 | CL | Stock | 28.825 | 28.865 | 28.775 | 28.775 | 423600.0 |
> showing 50 of 20,682 rows — these rows as CSV