PREVIEW / stock_1hour / 2000-02-24
file: by_date/stock_1hour/2000/2000-02-24.parquet size: 287 KB rows: 14,507 symbols: 1,141
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-24 09:00:00 | AAPL | Stock | 1.0474 | 1.0636 | 1.0424 | 1.0592 | 34876800.0 |
| 2000-02-24 10:00:00 | AAPL | Stock | 1.0592 | 1.0625 | 1.0223 | 1.0223 | 64467200.0 |
| 2000-02-24 11:00:00 | AAPL | Stock | 1.0223 | 1.0396 | 1.0089 | 1.0357 | 57825600.0 |
| 2000-02-24 12:00:00 | AAPL | Stock | 1.0329 | 1.0385 | 1.01 | 1.0167 | 28336000.0 |
| 2000-02-24 13:00:00 | AAPL | Stock | 1.0167 | 1.0268 | 1.0112 | 1.019 | 20328000.0 |
| 2000-02-24 14:00:00 | AAPL | Stock | 1.0179 | 1.019 | 0.9978 | 1.0089 | 58352000.0 |
| 2000-02-24 15:00:00 | AAPL | Stock | 1.0084 | 1.0313 | 1.0064 | 1.029 | 84044800.0 |
| 2000-02-24 16:00:00 | AAPL | Stock | 1.0285 | 1.0285 | 1.0234 | 1.0285 | 571200.0 |
| 2000-02-24 09:00:00 | MSFT | Stock | 47.125 | 47.5625 | 46.9062 | 47.375 | 5995000.0 |
| 2000-02-24 10:00:00 | MSFT | Stock | 47.4375 | 47.9375 | 46.4062 | 46.4062 | 16742400.0 |
| 2000-02-24 11:00:00 | MSFT | Stock | 46.4062 | 46.9375 | 46.2812 | 46.7188 | 7775200.0 |
| 2000-02-24 12:00:00 | MSFT | Stock | 46.7188 | 47.0469 | 46.4062 | 46.7812 | 6841400.0 |
| 2000-02-24 13:00:00 | MSFT | Stock | 46.8125 | 47.0312 | 46.375 | 46.4062 | 5748800.0 |
| 2000-02-24 14:00:00 | MSFT | Stock | 46.4062 | 46.9062 | 46.0 | 46.875 | 10306400.0 |
| 2000-02-24 15:00:00 | MSFT | Stock | 46.8906 | 47.5312 | 46.7188 | 47.4062 | 10729600.0 |
| 2000-02-24 16:00:00 | MSFT | Stock | 47.4062 | 47.4062 | 47.1562 | 47.3438 | 15200.0 |
| 2000-02-24 09:00:00 | NVDA | Stock | 0.138 | 0.1389 | 0.1367 | 0.138 | 17904000.0 |
| 2000-02-24 10:00:00 | NVDA | Stock | 0.1385 | 0.1388 | 0.1363 | 0.1371 | 44928000.0 |
| 2000-02-24 11:00:00 | NVDA | Stock | 0.1363 | 0.1365 | 0.1339 | 0.1355 | 34848000.0 |
| 2000-02-24 12:00:00 | NVDA | Stock | 0.1357 | 0.1362 | 0.1354 | 0.1359 | 15696000.0 |
| 2000-02-24 13:00:00 | NVDA | Stock | 0.1354 | 0.1378 | 0.1346 | 0.1363 | 42288000.0 |
| 2000-02-24 14:00:00 | NVDA | Stock | 0.1357 | 0.1362 | 0.1302 | 0.1305 | 45360000.0 |
| 2000-02-24 15:00:00 | NVDA | Stock | 0.1306 | 0.137 | 0.1306 | 0.1359 | 40800000.0 |
| 2000-02-24 09:00:00 | AMZN | Stock | 3.5281 | 3.5688 | 3.3812 | 3.4203 | 19126000.0 |
| 2000-02-24 10:00:00 | AMZN | Stock | 3.4172 | 3.45 | 3.2875 | 3.2906 | 25660000.0 |
| 2000-02-24 11:00:00 | AMZN | Stock | 3.2875 | 3.3812 | 3.2812 | 3.3781 | 17206000.0 |
| 2000-02-24 12:00:00 | AMZN | Stock | 3.3781 | 3.4094 | 3.3344 | 3.3625 | 9448000.0 |
| 2000-02-24 13:00:00 | AMZN | Stock | 3.3656 | 3.4125 | 3.35 | 3.3531 | 8508000.0 |
| 2000-02-24 14:00:00 | AMZN | Stock | 3.3531 | 3.375 | 3.3094 | 3.375 | 11944000.0 |
| 2000-02-24 15:00:00 | AMZN | Stock | 3.375 | 3.45 | 3.3625 | 3.4219 | 20278000.0 |
| 2000-02-24 16:00:00 | AMZN | Stock | 3.4188 | 3.425 | 3.4188 | 3.4219 | 140000.0 |
| 2000-02-24 09:00:00 | CL | Stock | 25.375 | 25.8125 | 24.9375 | 24.9375 | 463000.0 |
| 2000-02-24 10:00:00 | CL | Stock | 24.9062 | 25.0 | 24.0312 | 24.0312 | 779400.0 |
| 2000-02-24 11:00:00 | CL | Stock | 24.0 | 24.4375 | 23.9375 | 24.25 | 836800.0 |
| 2000-02-24 12:00:00 | CL | Stock | 24.25 | 24.9688 | 24.25 | 24.875 | 516000.0 |
| 2000-02-24 13:00:00 | CL | Stock | 24.8438 | 25.0 | 24.625 | 24.625 | 453800.0 |
| 2000-02-24 14:00:00 | CL | Stock | 24.5625 | 24.625 | 23.9375 | 24.3125 | 830600.0 |
| 2000-02-24 15:00:00 | CL | Stock | 24.2812 | 25.0625 | 24.125 | 24.5312 | 851800.0 |
| 2000-02-24 16:00:00 | CL | Stock | 24.5625 | 24.5625 | 24.5312 | 24.5312 | 198200.0 |
> showing 39 of 14,507 rows — these rows as CSV