PREVIEW / stock_1hour / 2003-03-26
file: by_date/stock_1hour/2003/2003-03-26.parquet size: 420 KB rows: 20,890 symbols: 1,552
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-03-26 08:00:00 | AAPL | Stock | 0.2666 | 0.2666 | 0.2598 | 0.2598 | 16800.0 |
| 2003-03-26 09:00:00 | AAPL | Stock | 0.2607 | 0.2607 | 0.2545 | 0.2571 | 29124368.0 |
| 2003-03-26 10:00:00 | AAPL | Stock | 0.2571 | 0.2586 | 0.2555 | 0.2571 | 29015672.0 |
| 2003-03-26 11:00:00 | AAPL | Stock | 0.257 | 0.2579 | 0.2563 | 0.2577 | 23353120.0 |
| 2003-03-26 12:00:00 | AAPL | Stock | 0.2577 | 0.2591 | 0.2563 | 0.2566 | 13513808.0 |
| 2003-03-26 13:00:00 | AAPL | Stock | 0.2566 | 0.2575 | 0.2559 | 0.2562 | 25391016.0 |
| 2003-03-26 14:00:00 | AAPL | Stock | 0.2563 | 0.2596 | 0.2554 | 0.2591 | 16950808.0 |
| 2003-03-26 15:00:00 | AAPL | Stock | 0.259 | 0.2596 | 0.2579 | 0.2579 | 17127320.0 |
| 2003-03-26 16:00:00 | AAPL | Stock | 0.2584 | 0.2598 | 0.2566 | 0.2575 | 5710936.0 |
| 2003-03-26 17:00:00 | AAPL | Stock | 0.2573 | 0.2573 | 0.2573 | 0.2573 | 2598400.0 |
| 2003-03-26 08:00:00 | MSFT | Stock | 25.63 | 25.85 | 25.499 | 25.53 | 119562.0 |
| 2003-03-26 09:00:00 | MSFT | Stock | 25.531 | 25.54 | 25.26 | 25.45 | 6349274.0 |
| 2003-03-26 10:00:00 | MSFT | Stock | 25.45 | 25.59 | 25.26 | 25.331 | 8637571.0 |
| 2003-03-26 11:00:00 | MSFT | Stock | 25.33 | 25.5 | 25.263 | 25.45 | 5398477.0 |
| 2003-03-26 12:00:00 | MSFT | Stock | 25.452 | 25.611 | 25.4 | 25.4511 | 5006254.0 |
| 2003-03-26 13:00:00 | MSFT | Stock | 25.46 | 25.529 | 25.28 | 25.31 | 4563604.0 |
| 2003-03-26 14:00:00 | MSFT | Stock | 25.31 | 25.61 | 25.24 | 25.608 | 6951287.0 |
| 2003-03-26 15:00:00 | MSFT | Stock | 25.6 | 25.62 | 25.27 | 25.27 | 8037055.0 |
| 2003-03-26 16:00:00 | MSFT | Stock | 25.28 | 25.49 | 25.17 | 25.19 | 1620051.0 |
| 2003-03-26 17:00:00 | MSFT | Stock | 25.19 | 25.3278 | 25.19 | 25.21 | 94450.0 |
| 2003-03-26 18:00:00 | MSFT | Stock | 25.199 | 25.2 | 25.18 | 25.2 | 12090.0 |
| 2003-03-26 08:00:00 | NVDA | Stock | 0.1206 | 0.122 | 0.1193 | 0.1196 | 16584000.0 |
| 2003-03-26 09:00:00 | NVDA | Stock | 0.1196 | 0.1207 | 0.1185 | 0.12 | 261494160.0 |
| 2003-03-26 10:00:00 | NVDA | Stock | 0.12 | 0.1212 | 0.12 | 0.1202 | 172737360.0 |
| 2003-03-26 11:00:00 | NVDA | Stock | 0.1202 | 0.1207 | 0.1195 | 0.1206 | 122048880.0 |
| 2003-03-26 12:00:00 | NVDA | Stock | 0.1206 | 0.1221 | 0.1205 | 0.1212 | 129081360.0 |
| 2003-03-26 13:00:00 | NVDA | Stock | 0.1212 | 0.1215 | 0.1201 | 0.1203 | 88597560.0 |
| 2003-03-26 14:00:00 | NVDA | Stock | 0.1203 | 0.1213 | 0.1197 | 0.1212 | 103511160.0 |
| 2003-03-26 15:00:00 | NVDA | Stock | 0.1212 | 0.1213 | 0.1196 | 0.12 | 125971560.0 |
| 2003-03-26 16:00:00 | NVDA | Stock | 0.1199 | 0.1206 | 0.1197 | 0.1202 | 5635560.0 |
| 2003-03-26 17:00:00 | NVDA | Stock | 0.1202 | 0.1202 | 0.1197 | 0.1197 | 624000.0 |
| 2003-03-26 18:00:00 | NVDA | Stock | 0.1198 | 0.1198 | 0.1198 | 0.1198 | 180000.0 |
| 2003-03-26 08:00:00 | AMZN | Stock | 1.3495 | 1.3495 | 1.34 | 1.34 | 108700.0 |
| 2003-03-26 09:00:00 | AMZN | Stock | 1.3465 | 1.351 | 1.3355 | 1.3415 | 13561440.0 |
| 2003-03-26 10:00:00 | AMZN | Stock | 1.344 | 1.3515 | 1.3405 | 1.3465 | 11154480.0 |
| 2003-03-26 11:00:00 | AMZN | Stock | 1.3464 | 1.3675 | 1.3445 | 1.3665 | 15543820.0 |
| 2003-03-26 12:00:00 | AMZN | Stock | 1.366 | 1.374 | 1.3605 | 1.3625 | 15906840.0 |
| 2003-03-26 13:00:00 | AMZN | Stock | 1.3625 | 1.379 | 1.361 | 1.371 | 18136600.0 |
| 2003-03-26 14:00:00 | AMZN | Stock | 1.371 | 1.3915 | 1.368 | 1.3915 | 26521200.0 |
| 2003-03-26 15:00:00 | AMZN | Stock | 1.3906 | 1.3935 | 1.3835 | 1.3875 | 32169420.0 |
| 2003-03-26 16:00:00 | AMZN | Stock | 1.387 | 1.3895 | 1.385 | 1.3855 | 1869800.0 |
| 2003-03-26 17:00:00 | AMZN | Stock | 1.384 | 1.388 | 1.3825 | 1.3874 | 2374200.0 |
| 2003-03-26 18:00:00 | AMZN | Stock | 1.385 | 1.385 | 1.385 | 1.385 | 5000.0 |
| 2003-03-26 09:00:00 | CL | Stock | 26.75 | 27.0 | 26.75 | 26.95 | 368600.0 |
| 2003-03-26 10:00:00 | CL | Stock | 26.95 | 27.025 | 26.71 | 26.79 | 424000.0 |
| 2003-03-26 11:00:00 | CL | Stock | 26.795 | 26.85 | 26.695 | 26.84 | 325400.0 |
| 2003-03-26 12:00:00 | CL | Stock | 26.85 | 26.895 | 26.775 | 26.84 | 292400.0 |
| 2003-03-26 13:00:00 | CL | Stock | 26.84 | 26.98 | 26.78 | 26.785 | 190800.0 |
| 2003-03-26 14:00:00 | CL | Stock | 26.79 | 27.025 | 26.725 | 27.015 | 301800.0 |
| 2003-03-26 15:00:00 | CL | Stock | 27.02 | 27.04 | 26.845 | 26.9 | 334000.0 |
> showing 50 of 20,890 rows — these rows as CSV