PREVIEW / stock_1hour / 2000-08-31
file: by_date/stock_1hour/2000/2000-08-31.parquet size: 318 KB rows: 16,298 symbols: 1,230
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-08-31 08:00:00 | AAPL | Stock | 1.0625 | 1.0625 | 1.0603 | 1.0625 | 168000.0 |
| 2000-08-31 09:00:00 | AAPL | Stock | 1.0491 | 1.0658 | 1.0491 | 1.0636 | 21459200.0 |
| 2000-08-31 10:00:00 | AAPL | Stock | 1.0636 | 1.0714 | 1.058 | 1.0636 | 42996800.0 |
| 2000-08-31 11:00:00 | AAPL | Stock | 1.0636 | 1.0725 | 1.0625 | 1.0714 | 68824000.0 |
| 2000-08-31 12:00:00 | AAPL | Stock | 1.0714 | 1.0804 | 1.0703 | 1.0753 | 81541600.0 |
| 2000-08-31 13:00:00 | AAPL | Stock | 1.0753 | 1.0915 | 1.0753 | 1.0859 | 57920800.0 |
| 2000-08-31 14:00:00 | AAPL | Stock | 1.0859 | 1.0982 | 1.0848 | 1.0871 | 66544800.0 |
| 2000-08-31 15:00:00 | AAPL | Stock | 1.0859 | 1.0904 | 1.0826 | 1.0893 | 43730400.0 |
| 2000-08-31 16:00:00 | AAPL | Stock | 1.0882 | 1.0938 | 1.067 | 1.0882 | 21274400.0 |
| 2000-08-31 17:00:00 | AAPL | Stock | 1.0826 | 1.0893 | 1.0826 | 1.0893 | 1674400.0 |
| 2000-08-31 18:00:00 | AAPL | Stock | 1.0938 | 1.0938 | 1.0893 | 1.0893 | 22400.0 |
| 2000-08-31 08:00:00 | MSFT | Stock | 34.9844 | 35.75 | 34.625 | 35.5312 | 263800.0 |
| 2000-08-31 09:00:00 | MSFT | Stock | 35.5312 | 35.6562 | 35.0938 | 35.5312 | 13156600.0 |
| 2000-08-31 10:00:00 | MSFT | Stock | 35.5312 | 35.6562 | 35.4688 | 35.4688 | 7845400.0 |
| 2000-08-31 11:00:00 | MSFT | Stock | 35.4688 | 35.5625 | 35.4688 | 35.5312 | 7836400.0 |
| 2000-08-31 12:00:00 | MSFT | Stock | 35.5312 | 35.6562 | 35.4688 | 35.5625 | 7343800.0 |
| 2000-08-31 13:00:00 | MSFT | Stock | 35.5625 | 35.5938 | 35.4375 | 35.5 | 8025800.0 |
| 2000-08-31 14:00:00 | MSFT | Stock | 35.5 | 35.5312 | 35.3125 | 35.3438 | 8506600.0 |
| 2000-08-31 15:00:00 | MSFT | Stock | 35.3125 | 35.3438 | 34.875 | 34.9062 | 14119400.0 |
| 2000-08-31 16:00:00 | MSFT | Stock | 34.9375 | 35.5625 | 34.8125 | 34.9062 | 3897400.0 |
| 2000-08-31 17:00:00 | MSFT | Stock | 34.9062 | 34.9688 | 34.9062 | 34.9688 | 614200.0 |
| 2000-08-31 18:00:00 | MSFT | Stock | 34.9062 | 35.0 | 34.875 | 35.0 | 6000.0 |
| 2000-08-31 08:00:00 | NVDA | Stock | 0.3292 | 0.3292 | 0.3292 | 0.3292 | 48000.0 |
| 2000-08-31 09:00:00 | NVDA | Stock | 0.3302 | 0.3333 | 0.3255 | 0.3326 | 41952000.0 |
| 2000-08-31 10:00:00 | NVDA | Stock | 0.3326 | 0.3438 | 0.3307 | 0.3362 | 142824000.0 |
| 2000-08-31 11:00:00 | NVDA | Stock | 0.3375 | 0.3396 | 0.3302 | 0.3333 | 34944000.0 |
| 2000-08-31 12:00:00 | NVDA | Stock | 0.332 | 0.3333 | 0.3294 | 0.3331 | 28152000.0 |
| 2000-08-31 13:00:00 | NVDA | Stock | 0.3331 | 0.3344 | 0.3315 | 0.3333 | 14400000.0 |
| 2000-08-31 14:00:00 | NVDA | Stock | 0.3333 | 0.3339 | 0.3255 | 0.3271 | 35856000.0 |
| 2000-08-31 15:00:00 | NVDA | Stock | 0.3284 | 0.332 | 0.3284 | 0.331 | 81240000.0 |
| 2000-08-31 16:00:00 | NVDA | Stock | 0.3313 | 0.3313 | 0.3297 | 0.3299 | 5208000.0 |
| 2000-08-31 17:00:00 | NVDA | Stock | 0.3307 | 0.3307 | 0.3307 | 0.3307 | 144000.0 |
| 2000-08-31 08:00:00 | AMZN | Stock | 2.15 | 2.1625 | 2.1375 | 2.1375 | 68000.0 |
| 2000-08-31 09:00:00 | AMZN | Stock | 2.1375 | 2.1594 | 2.1156 | 2.1188 | 15130000.0 |
| 2000-08-31 10:00:00 | AMZN | Stock | 2.1125 | 2.1312 | 2.0813 | 2.1 | 17478000.0 |
| 2000-08-31 11:00:00 | AMZN | Stock | 2.0969 | 2.1344 | 2.0938 | 2.1281 | 10588000.0 |
| 2000-08-31 12:00:00 | AMZN | Stock | 2.125 | 2.1375 | 2.1094 | 2.1094 | 5560000.0 |
| 2000-08-31 13:00:00 | AMZN | Stock | 2.1094 | 2.1219 | 2.0875 | 2.0969 | 10198000.0 |
| 2000-08-31 14:00:00 | AMZN | Stock | 2.0938 | 2.1062 | 2.0875 | 2.0906 | 10930000.0 |
| 2000-08-31 15:00:00 | AMZN | Stock | 2.0906 | 2.1094 | 2.0719 | 2.0781 | 14308000.0 |
| 2000-08-31 16:00:00 | AMZN | Stock | 2.075 | 2.1078 | 2.0562 | 2.0875 | 5154000.0 |
| 2000-08-31 17:00:00 | AMZN | Stock | 2.075 | 2.0969 | 2.0688 | 2.0813 | 212000.0 |
| 2000-08-31 18:00:00 | AMZN | Stock | 2.0813 | 2.0813 | 2.0813 | 2.0813 | 16000.0 |
| 2000-08-31 09:00:00 | CL | Stock | 25.8125 | 26.0 | 25.7812 | 25.9688 | 342000.0 |
| 2000-08-31 10:00:00 | CL | Stock | 26.0 | 26.0938 | 25.6875 | 25.6875 | 452800.0 |
| 2000-08-31 11:00:00 | CL | Stock | 25.7188 | 25.875 | 25.6875 | 25.75 | 250400.0 |
| 2000-08-31 12:00:00 | CL | Stock | 25.75 | 25.7812 | 25.6875 | 25.6875 | 163600.0 |
| 2000-08-31 13:00:00 | CL | Stock | 25.6875 | 25.7188 | 25.5312 | 25.6875 | 280200.0 |
| 2000-08-31 14:00:00 | CL | Stock | 25.6875 | 25.6875 | 25.375 | 25.5938 | 331600.0 |
| 2000-08-31 15:00:00 | CL | Stock | 25.5625 | 25.5625 | 25.4375 | 25.4688 | 336800.0 |
> showing 50 of 16,298 rows — these rows as CSV