PREVIEW / stock_1hour / 2000-08-15
file: by_date/stock_1hour/2000/2000-08-15.parquet size: 297 KB rows: 15,439 symbols: 1,216
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-15 08:00:00 | AAPL | Stock | 0.8438 | 0.8438 | 0.8393 | 0.8393 | 33600.0 |
| 2000-08-15 09:00:00 | AAPL | Stock | 0.8393 | 0.8438 | 0.8371 | 0.8382 | 10080000.0 |
| 2000-08-15 10:00:00 | AAPL | Stock | 0.8382 | 0.8516 | 0.8382 | 0.8415 | 20361600.0 |
| 2000-08-15 11:00:00 | AAPL | Stock | 0.8426 | 0.8449 | 0.8304 | 0.8421 | 13462400.0 |
| 2000-08-15 12:00:00 | AAPL | Stock | 0.8438 | 0.8449 | 0.8393 | 0.8426 | 7089600.0 |
| 2000-08-15 13:00:00 | AAPL | Stock | 0.8426 | 0.8482 | 0.8415 | 0.8438 | 8965600.0 |
| 2000-08-15 14:00:00 | AAPL | Stock | 0.8438 | 0.8516 | 0.8438 | 0.8493 | 25452000.0 |
| 2000-08-15 15:00:00 | AAPL | Stock | 0.8471 | 0.8493 | 0.8304 | 0.8337 | 25468800.0 |
| 2000-08-15 16:00:00 | AAPL | Stock | 0.8337 | 0.8348 | 0.8326 | 0.8337 | 2676800.0 |
| 2000-08-15 17:00:00 | AAPL | Stock | 0.8382 | 0.8382 | 0.8326 | 0.8326 | 28000.0 |
| 2000-08-15 08:00:00 | MSFT | Stock | 36.1094 | 36.125 | 35.8125 | 36.125 | 64400.0 |
| 2000-08-15 09:00:00 | MSFT | Stock | 36.1406 | 36.1562 | 35.7812 | 36.0312 | 4890800.0 |
| 2000-08-15 10:00:00 | MSFT | Stock | 36.0312 | 36.4688 | 35.9688 | 36.4688 | 11673800.0 |
| 2000-08-15 11:00:00 | MSFT | Stock | 36.4062 | 36.5 | 35.9531 | 36.0625 | 5318600.0 |
| 2000-08-15 12:00:00 | MSFT | Stock | 36.0312 | 36.1875 | 35.9688 | 36.0 | 4131800.0 |
| 2000-08-15 13:00:00 | MSFT | Stock | 36.0312 | 36.0938 | 35.875 | 35.9375 | 3413400.0 |
| 2000-08-15 14:00:00 | MSFT | Stock | 35.9375 | 36.1875 | 35.9375 | 36.1719 | 4169000.0 |
| 2000-08-15 15:00:00 | MSFT | Stock | 36.1875 | 36.1875 | 35.75 | 35.8125 | 5598200.0 |
| 2000-08-15 16:00:00 | MSFT | Stock | 35.8438 | 36.0 | 35.8125 | 35.875 | 1262800.0 |
| 2000-08-15 17:00:00 | MSFT | Stock | 35.875 | 35.875 | 35.75 | 35.875 | 2200.0 |
| 2000-08-15 18:00:00 | MSFT | Stock | 35.7812 | 35.9062 | 35.7812 | 35.9062 | 1400.0 |
| 2000-08-15 08:00:00 | NVDA | Stock | 0.271 | 0.271 | 0.271 | 0.271 | 5280000.0 |
| 2000-08-15 09:00:00 | NVDA | Stock | 0.2708 | 0.2813 | 0.2708 | 0.2797 | 30000000.0 |
| 2000-08-15 10:00:00 | NVDA | Stock | 0.2792 | 0.2885 | 0.276 | 0.2878 | 67920000.0 |
| 2000-08-15 11:00:00 | NVDA | Stock | 0.2878 | 0.2922 | 0.2862 | 0.2919 | 66672000.0 |
| 2000-08-15 12:00:00 | NVDA | Stock | 0.2919 | 0.2927 | 0.2906 | 0.2922 | 34320000.0 |
| 2000-08-15 13:00:00 | NVDA | Stock | 0.2917 | 0.2938 | 0.288 | 0.288 | 36432000.0 |
| 2000-08-15 14:00:00 | NVDA | Stock | 0.288 | 0.2982 | 0.288 | 0.297 | 85704000.0 |
| 2000-08-15 15:00:00 | NVDA | Stock | 0.2974 | 0.3021 | 0.2917 | 0.2969 | 110712000.0 |
| 2000-08-15 16:00:00 | NVDA | Stock | 0.2966 | 0.2974 | 0.2924 | 0.2924 | 3768000.0 |
| 2000-08-15 17:00:00 | NVDA | Stock | 0.2958 | 0.2962 | 0.2958 | 0.2962 | 48000.0 |
| 2000-08-15 18:00:00 | NVDA | Stock | 0.2979 | 0.2979 | 0.2979 | 0.2979 | 24000.0 |
| 2000-08-15 08:00:00 | AMZN | Stock | 1.7312 | 1.7375 | 1.7312 | 1.7312 | 26000.0 |
| 2000-08-15 09:00:00 | AMZN | Stock | 1.7328 | 1.85 | 1.7188 | 1.825 | 30034000.0 |
| 2000-08-15 10:00:00 | AMZN | Stock | 1.825 | 1.8625 | 1.825 | 1.8375 | 33706000.0 |
| 2000-08-15 11:00:00 | AMZN | Stock | 1.8406 | 1.8438 | 1.8281 | 1.8375 | 20314000.0 |
| 2000-08-15 12:00:00 | AMZN | Stock | 1.8344 | 1.85 | 1.8344 | 1.8375 | 7638000.0 |
| 2000-08-15 13:00:00 | AMZN | Stock | 1.8406 | 1.8531 | 1.8375 | 1.8469 | 12520000.0 |
| 2000-08-15 14:00:00 | AMZN | Stock | 1.85 | 1.9 | 1.8469 | 1.8938 | 22642000.0 |
| 2000-08-15 15:00:00 | AMZN | Stock | 1.8969 | 1.9156 | 1.8688 | 1.8781 | 39434000.0 |
| 2000-08-15 16:00:00 | AMZN | Stock | 1.8688 | 1.8812 | 1.825 | 1.825 | 1914000.0 |
| 2000-08-15 17:00:00 | AMZN | Stock | 1.8438 | 1.8938 | 1.8375 | 1.8469 | 68000.0 |
| 2000-08-15 18:00:00 | AMZN | Stock | 1.8375 | 1.8375 | 1.8375 | 1.8375 | 2000.0 |
| 2000-08-15 09:00:00 | CL | Stock | 27.0938 | 27.1875 | 26.9062 | 27.0938 | 226000.0 |
| 2000-08-15 10:00:00 | CL | Stock | 27.0312 | 27.125 | 27.0 | 27.0625 | 245000.0 |
| 2000-08-15 11:00:00 | CL | Stock | 27.0938 | 27.2812 | 27.0625 | 27.2188 | 220600.0 |
| 2000-08-15 12:00:00 | CL | Stock | 27.2812 | 27.3125 | 26.9688 | 26.9688 | 308200.0 |
| 2000-08-15 13:00:00 | CL | Stock | 27.0 | 27.1875 | 26.9375 | 27.1875 | 325400.0 |
| 2000-08-15 14:00:00 | CL | Stock | 27.2188 | 27.4375 | 27.125 | 27.1562 | 387000.0 |
| 2000-08-15 15:00:00 | CL | Stock | 27.125 | 27.125 | 26.9062 | 27.0312 | 540400.0 |
> showing 50 of 15,439 rows — these rows as CSV