PREVIEW / stock_1hour / 2000-02-17
file: by_date/stock_1hour/2000/2000-02-17.parquet size: 286 KB rows: 14,523 symbols: 1,134
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 |
|---|---|---|---|---|---|---|---|
| 2000-02-17 09:00:00 | AAPL | Stock | 1.0285 | 1.0313 | 1.0134 | 1.0165 | 47936000.0 |
| 2000-02-17 10:00:00 | AAPL | Stock | 1.0165 | 1.0246 | 1.01 | 1.0229 | 63504000.0 |
| 2000-02-17 11:00:00 | AAPL | Stock | 1.0229 | 1.0246 | 1.0156 | 1.0179 | 40275200.0 |
| 2000-02-17 12:00:00 | AAPL | Stock | 1.0179 | 1.0234 | 1.0162 | 1.0223 | 17953600.0 |
| 2000-02-17 13:00:00 | AAPL | Stock | 1.0223 | 1.0268 | 1.0195 | 1.0234 | 45236800.0 |
| 2000-02-17 14:00:00 | AAPL | Stock | 1.0234 | 1.029 | 1.0234 | 1.0268 | 26846400.0 |
| 2000-02-17 15:00:00 | AAPL | Stock | 1.0268 | 1.0268 | 1.0201 | 1.0257 | 30408000.0 |
| 2000-02-17 16:00:00 | AAPL | Stock | 1.0251 | 1.0257 | 1.0218 | 1.0257 | 212800.0 |
| 2000-02-17 09:00:00 | MSFT | Stock | 49.25 | 49.8438 | 49.2188 | 49.4688 | 8094800.0 |
| 2000-02-17 10:00:00 | MSFT | Stock | 49.4688 | 49.5 | 48.5625 | 48.9062 | 21081200.0 |
| 2000-02-17 11:00:00 | MSFT | Stock | 48.9062 | 49.0312 | 48.625 | 49.0 | 8719600.0 |
| 2000-02-17 12:00:00 | MSFT | Stock | 48.9062 | 49.125 | 48.7812 | 48.875 | 7660000.0 |
| 2000-02-17 13:00:00 | MSFT | Stock | 48.9062 | 49.3125 | 48.8125 | 49.2188 | 11027000.0 |
| 2000-02-17 14:00:00 | MSFT | Stock | 49.25 | 49.6562 | 49.1562 | 49.4375 | 9876800.0 |
| 2000-02-17 15:00:00 | MSFT | Stock | 49.4375 | 49.8438 | 49.0 | 49.8125 | 9457600.0 |
| 2000-02-17 16:00:00 | MSFT | Stock | 49.7812 | 49.8438 | 49.7812 | 49.8125 | 298000.0 |
| 2000-02-17 09:00:00 | NVDA | Stock | 0.1214 | 0.124 | 0.1195 | 0.1218 | 84768000.0 |
| 2000-02-17 10:00:00 | NVDA | Stock | 0.1216 | 0.1247 | 0.1216 | 0.124 | 82992000.0 |
| 2000-02-17 11:00:00 | NVDA | Stock | 0.1237 | 0.1247 | 0.1237 | 0.124 | 31824000.0 |
| 2000-02-17 12:00:00 | NVDA | Stock | 0.124 | 0.124 | 0.1224 | 0.1229 | 48768000.0 |
| 2000-02-17 13:00:00 | NVDA | Stock | 0.1229 | 0.1238 | 0.1227 | 0.1232 | 37296000.0 |
| 2000-02-17 14:00:00 | NVDA | Stock | 0.1233 | 0.1247 | 0.1229 | 0.1247 | 117792000.0 |
| 2000-02-17 15:00:00 | NVDA | Stock | 0.1247 | 0.1266 | 0.1238 | 0.1262 | 97776000.0 |
| 2000-02-17 16:00:00 | NVDA | Stock | 0.1258 | 0.1258 | 0.1258 | 0.1258 | 192000.0 |
| 2000-02-17 09:00:00 | AMZN | Stock | 3.5625 | 3.5656 | 3.4875 | 3.5125 | 15862000.0 |
| 2000-02-17 10:00:00 | AMZN | Stock | 3.5125 | 3.5125 | 3.4188 | 3.425 | 22988000.0 |
| 2000-02-17 11:00:00 | AMZN | Stock | 3.4344 | 3.4562 | 3.4062 | 3.4219 | 17716000.0 |
| 2000-02-17 12:00:00 | AMZN | Stock | 3.4219 | 3.45 | 3.4062 | 3.45 | 13974000.0 |
| 2000-02-17 13:00:00 | AMZN | Stock | 3.45 | 3.5344 | 3.4375 | 3.4406 | 22092000.0 |
| 2000-02-17 14:00:00 | AMZN | Stock | 3.4406 | 3.4688 | 3.4094 | 3.4312 | 8678000.0 |
| 2000-02-17 15:00:00 | AMZN | Stock | 3.4312 | 3.4875 | 3.4 | 3.4469 | 16188000.0 |
| 2000-02-17 16:00:00 | AMZN | Stock | 3.4469 | 3.4562 | 3.4375 | 3.45 | 388000.0 |
| 2000-02-17 09:00:00 | CL | Stock | 27.8125 | 28.0 | 27.75 | 27.9375 | 181400.0 |
| 2000-02-17 10:00:00 | CL | Stock | 27.9375 | 27.9375 | 27.0625 | 27.125 | 622800.0 |
| 2000-02-17 11:00:00 | CL | Stock | 27.125 | 27.5 | 26.8438 | 27.0625 | 436000.0 |
| 2000-02-17 12:00:00 | CL | Stock | 27.0938 | 27.375 | 27.0938 | 27.3438 | 177600.0 |
| 2000-02-17 13:00:00 | CL | Stock | 27.375 | 27.4688 | 27.1875 | 27.2188 | 294000.0 |
| 2000-02-17 14:00:00 | CL | Stock | 27.1562 | 27.2812 | 26.875 | 26.9688 | 543400.0 |
| 2000-02-17 15:00:00 | CL | Stock | 26.9688 | 27.0625 | 26.75 | 26.9688 | 341400.0 |
| 2000-02-17 16:00:00 | CL | Stock | 26.9062 | 26.9688 | 26.9062 | 26.9688 | 71200.0 |
> showing 40 of 14,523 rows — these rows as CSV