PREVIEW / stock_1hour / 2003-04-30
file: by_date/stock_1hour/2003/2003-04-30.parquet size: 443 KB rows: 21,825 symbols: 1,575
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-30 08:00:00 | AAPL | Stock | 0.2491 | 0.2491 | 0.2482 | 0.2482 | 84000.0 |
| 2003-04-30 09:00:00 | AAPL | Stock | 0.2482 | 0.2518 | 0.2473 | 0.2516 | 61498024.0 |
| 2003-04-30 10:00:00 | AAPL | Stock | 0.2514 | 0.2554 | 0.25 | 0.2552 | 82675544.0 |
| 2003-04-30 11:00:00 | AAPL | Stock | 0.2552 | 0.2561 | 0.2523 | 0.2525 | 40651016.0 |
| 2003-04-30 12:00:00 | AAPL | Stock | 0.2525 | 0.2532 | 0.2521 | 0.2527 | 49053368.0 |
| 2003-04-30 13:00:00 | AAPL | Stock | 0.2525 | 0.2545 | 0.2513 | 0.2534 | 39374720.0 |
| 2003-04-30 14:00:00 | AAPL | Stock | 0.2532 | 0.2559 | 0.253 | 0.2548 | 56579992.0 |
| 2003-04-30 15:00:00 | AAPL | Stock | 0.2546 | 0.2563 | 0.2521 | 0.2527 | 66850672.0 |
| 2003-04-30 16:00:00 | AAPL | Stock | 0.2536 | 0.2643 | 0.2525 | 0.2536 | 11004056.0 |
| 2003-04-30 17:00:00 | AAPL | Stock | 0.2536 | 0.2541 | 0.2536 | 0.2539 | 1579200.0 |
| 2003-04-30 08:00:00 | MSFT | Stock | 25.81 | 25.86 | 25.7 | 25.73 | 60580.0 |
| 2003-04-30 09:00:00 | MSFT | Stock | 25.8 | 25.82 | 25.25 | 25.77 | 5449678.0 |
| 2003-04-30 10:00:00 | MSFT | Stock | 25.78 | 25.8 | 25.55 | 25.77 | 9498694.0 |
| 2003-04-30 11:00:00 | MSFT | Stock | 25.76 | 25.88 | 25.61 | 25.66 | 6505081.0 |
| 2003-04-30 12:00:00 | MSFT | Stock | 25.66 | 25.73 | 25.6 | 25.69 | 3073301.0 |
| 2003-04-30 13:00:00 | MSFT | Stock | 25.69 | 25.7834 | 25.64 | 25.7 | 3029581.0 |
| 2003-04-30 14:00:00 | MSFT | Stock | 25.7 | 25.825 | 25.66 | 25.71 | 4738027.0 |
| 2003-04-30 15:00:00 | MSFT | Stock | 25.72 | 25.822 | 25.55 | 25.56 | 10155563.0 |
| 2003-04-30 16:00:00 | MSFT | Stock | 25.56 | 25.7159 | 25.55 | 25.58 | 4557226.0 |
| 2003-04-30 17:00:00 | MSFT | Stock | 25.596 | 25.7145 | 25.52 | 25.58 | 915250.0 |
| 2003-04-30 18:00:00 | MSFT | Stock | 25.58 | 25.59 | 25.56 | 25.58 | 5900.0 |
| 2003-04-30 08:00:00 | NVDA | Stock | 0.1196 | 0.1196 | 0.1191 | 0.1192 | 703800.0 |
| 2003-04-30 09:00:00 | NVDA | Stock | 0.1197 | 0.1225 | 0.1187 | 0.1213 | 105203520.0 |
| 2003-04-30 10:00:00 | NVDA | Stock | 0.1213 | 0.1214 | 0.1195 | 0.1202 | 87455040.0 |
| 2003-04-30 11:00:00 | NVDA | Stock | 0.1202 | 0.1212 | 0.1192 | 0.1194 | 67662840.0 |
| 2003-04-30 12:00:00 | NVDA | Stock | 0.1195 | 0.1206 | 0.1189 | 0.1203 | 40800000.0 |
| 2003-04-30 13:00:00 | NVDA | Stock | 0.1203 | 0.121 | 0.1202 | 0.1205 | 34208280.0 |
| 2003-04-30 14:00:00 | NVDA | Stock | 0.1205 | 0.1209 | 0.1204 | 0.1207 | 20266800.0 |
| 2003-04-30 15:00:00 | NVDA | Stock | 0.1207 | 0.121 | 0.1187 | 0.1189 | 61884840.0 |
| 2003-04-30 16:00:00 | NVDA | Stock | 0.1189 | 0.1194 | 0.1188 | 0.1189 | 6900000.0 |
| 2003-04-30 17:00:00 | NVDA | Stock | 0.1189 | 0.1194 | 0.1189 | 0.1194 | 756000.0 |
| 2003-04-30 18:00:00 | NVDA | Stock | 0.119 | 0.1193 | 0.119 | 0.1193 | 360000.0 |
| 2003-04-30 08:00:00 | AMZN | Stock | 1.44 | 1.4448 | 1.43 | 1.435 | 462000.0 |
| 2003-04-30 09:00:00 | AMZN | Stock | 1.435 | 1.45 | 1.4285 | 1.4415 | 36279280.0 |
| 2003-04-30 10:00:00 | AMZN | Stock | 1.4415 | 1.4425 | 1.43 | 1.437 | 32612620.0 |
| 2003-04-30 11:00:00 | AMZN | Stock | 1.437 | 1.4376 | 1.422 | 1.4265 | 24351040.0 |
| 2003-04-30 12:00:00 | AMZN | Stock | 1.4245 | 1.4275 | 1.419 | 1.422 | 16460500.0 |
| 2003-04-30 13:00:00 | AMZN | Stock | 1.4215 | 1.436 | 1.42 | 1.4325 | 13084960.0 |
| 2003-04-30 14:00:00 | AMZN | Stock | 1.432 | 1.4385 | 1.4255 | 1.431 | 14270920.0 |
| 2003-04-30 15:00:00 | AMZN | Stock | 1.4305 | 1.4425 | 1.4295 | 1.4325 | 30530380.0 |
| 2003-04-30 16:00:00 | AMZN | Stock | 1.4326 | 1.4375 | 1.4325 | 1.4335 | 2670080.0 |
| 2003-04-30 17:00:00 | AMZN | Stock | 1.437 | 1.438 | 1.4325 | 1.433 | 575480.0 |
| 2003-04-30 09:00:00 | CL | Stock | 28.755 | 28.755 | 28.625 | 28.675 | 324800.0 |
| 2003-04-30 10:00:00 | CL | Stock | 28.675 | 28.725 | 28.5 | 28.725 | 653000.0 |
| 2003-04-30 11:00:00 | CL | Stock | 28.725 | 28.825 | 28.61 | 28.64 | 430400.0 |
| 2003-04-30 12:00:00 | CL | Stock | 28.645 | 28.65 | 28.535 | 28.605 | 368800.0 |
| 2003-04-30 13:00:00 | CL | Stock | 28.61 | 28.715 | 28.595 | 28.66 | 226000.0 |
| 2003-04-30 14:00:00 | CL | Stock | 28.655 | 28.665 | 28.575 | 28.59 | 312200.0 |
| 2003-04-30 15:00:00 | CL | Stock | 28.59 | 28.67 | 28.56 | 28.605 | 734400.0 |
| 2003-04-30 16:00:00 | CL | Stock | 28.605 | 28.605 | 28.58 | 28.585 | 334000.0 |
> showing 50 of 21,825 rows — these rows as CSV