PREVIEW / stock_1hour / 2000-03-10
file: by_date/stock_1hour/2000/2000-03-10.parquet size: 287 KB rows: 14,525 symbols: 1,148
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-03-10 09:00:00 | AAPL | Stock | 1.0865 | 1.1049 | 1.0804 | 1.1002 | 33880000.0 |
| 2000-03-10 10:00:00 | AAPL | Stock | 1.1038 | 1.1183 | 1.0982 | 1.1122 | 46379200.0 |
| 2000-03-10 11:00:00 | AAPL | Stock | 1.1116 | 1.1228 | 1.1004 | 1.1032 | 35918400.0 |
| 2000-03-10 12:00:00 | AAPL | Stock | 1.1032 | 1.1183 | 1.1004 | 1.1172 | 23072000.0 |
| 2000-03-10 13:00:00 | AAPL | Stock | 1.1177 | 1.1295 | 1.1144 | 1.1289 | 30564800.0 |
| 2000-03-10 14:00:00 | AAPL | Stock | 1.1295 | 1.1423 | 1.1239 | 1.1244 | 37340800.0 |
| 2000-03-10 15:00:00 | AAPL | Stock | 1.1244 | 1.1395 | 1.1127 | 1.1189 | 27384000.0 |
| 2000-03-10 16:00:00 | AAPL | Stock | 1.1189 | 1.1228 | 1.1189 | 1.1228 | 1332800.0 |
| 2000-03-10 09:00:00 | MSFT | Stock | 49.7812 | 51.0938 | 49.75 | 51.0625 | 16151800.0 |
| 2000-03-10 10:00:00 | MSFT | Stock | 51.0312 | 51.25 | 50.4375 | 51.1562 | 17773800.0 |
| 2000-03-10 11:00:00 | MSFT | Stock | 51.1875 | 51.25 | 49.9688 | 50.1875 | 13489800.0 |
| 2000-03-10 12:00:00 | MSFT | Stock | 50.25 | 50.6875 | 49.9375 | 50.625 | 8904200.0 |
| 2000-03-10 13:00:00 | MSFT | Stock | 50.625 | 51.0 | 50.4688 | 50.9688 | 7647600.0 |
| 2000-03-10 14:00:00 | MSFT | Stock | 50.9688 | 51.0312 | 50.625 | 50.625 | 7382000.0 |
| 2000-03-10 15:00:00 | MSFT | Stock | 50.625 | 50.9688 | 50.0 | 50.5 | 9882400.0 |
| 2000-03-10 16:00:00 | MSFT | Stock | 50.4688 | 50.5 | 50.4688 | 50.5 | 77000.0 |
| 2000-03-10 09:00:00 | NVDA | Stock | 0.2198 | 0.2458 | 0.2182 | 0.2333 | 197232000.0 |
| 2000-03-10 10:00:00 | NVDA | Stock | 0.2324 | 0.2393 | 0.2305 | 0.2385 | 185856000.0 |
| 2000-03-10 11:00:00 | NVDA | Stock | 0.2392 | 0.2396 | 0.2303 | 0.2328 | 118752000.0 |
| 2000-03-10 12:00:00 | NVDA | Stock | 0.2328 | 0.25 | 0.2316 | 0.2448 | 149184000.0 |
| 2000-03-10 13:00:00 | NVDA | Stock | 0.2432 | 0.2518 | 0.2396 | 0.2461 | 164688000.0 |
| 2000-03-10 14:00:00 | NVDA | Stock | 0.25 | 0.3021 | 0.246 | 0.2763 | 827088000.0 |
| 2000-03-10 15:00:00 | NVDA | Stock | 0.2763 | 0.2771 | 0.244 | 0.2456 | 415008000.0 |
| 2000-03-10 16:00:00 | NVDA | Stock | 0.2456 | 0.2458 | 0.2456 | 0.2458 | 1344000.0 |
| 2000-03-10 09:00:00 | AMZN | Stock | 3.3625 | 3.4266 | 3.35 | 3.375 | 8366000.0 |
| 2000-03-10 10:00:00 | AMZN | Stock | 3.375 | 3.4 | 3.2969 | 3.3 | 15772000.0 |
| 2000-03-10 11:00:00 | AMZN | Stock | 3.3031 | 3.3375 | 3.2625 | 3.2906 | 14706000.0 |
| 2000-03-10 12:00:00 | AMZN | Stock | 3.2875 | 3.3188 | 3.25 | 3.3125 | 9606000.0 |
| 2000-03-10 13:00:00 | AMZN | Stock | 3.3094 | 3.3688 | 3.3031 | 3.3469 | 6186000.0 |
| 2000-03-10 14:00:00 | AMZN | Stock | 3.35 | 3.3625 | 3.3 | 3.3156 | 5218000.0 |
| 2000-03-10 15:00:00 | AMZN | Stock | 3.3188 | 3.3625 | 3.3156 | 3.3438 | 9722000.0 |
| 2000-03-10 16:00:00 | AMZN | Stock | 3.3469 | 3.3469 | 3.3438 | 3.3438 | 152000.0 |
| 2000-03-10 09:00:00 | CL | Stock | 22.0 | 22.0 | 21.4375 | 21.625 | 914800.0 |
| 2000-03-10 10:00:00 | CL | Stock | 21.625 | 21.625 | 20.5 | 21.0938 | 2111400.0 |
| 2000-03-10 11:00:00 | CL | Stock | 21.0938 | 21.0938 | 20.4375 | 20.6875 | 1306000.0 |
| 2000-03-10 12:00:00 | CL | Stock | 20.6875 | 21.125 | 20.6875 | 21.0625 | 667600.0 |
| 2000-03-10 13:00:00 | CL | Stock | 21.0625 | 21.125 | 20.8125 | 20.875 | 967400.0 |
| 2000-03-10 14:00:00 | CL | Stock | 20.8125 | 21.0625 | 20.8125 | 20.9375 | 684800.0 |
| 2000-03-10 15:00:00 | CL | Stock | 20.9688 | 21.875 | 20.9688 | 21.4062 | 1205200.0 |
| 2000-03-10 16:00:00 | CL | Stock | 21.4062 | 21.4062 | 21.375 | 21.375 | 78600.0 |
| 2000-03-10 17:00:00 | CL | Stock | 21.375 | 21.375 | 21.375 | 21.375 | 200.0 |
> showing 41 of 14,525 rows — these rows as CSV