PREVIEW / stock_1hour / 2000-03-15
file: by_date/stock_1hour/2000/2000-03-15.parquet size: 284 KB rows: 14,053 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-15 09:00:00 | AAPL | Stock | 1.0324 | 1.0525 | 1.019 | 1.0491 | 82051200.0 |
| 2000-03-15 10:00:00 | AAPL | Stock | 1.0513 | 1.0737 | 1.0497 | 1.0592 | 112313600.0 |
| 2000-03-15 11:00:00 | AAPL | Stock | 1.0592 | 1.067 | 1.0502 | 1.0614 | 38908800.0 |
| 2000-03-15 12:00:00 | AAPL | Stock | 1.0614 | 1.0658 | 1.0413 | 1.0474 | 33555200.0 |
| 2000-03-15 13:00:00 | AAPL | Stock | 1.048 | 1.0709 | 1.0469 | 1.0664 | 34585600.0 |
| 2000-03-15 14:00:00 | AAPL | Stock | 1.0664 | 1.0709 | 1.0552 | 1.0558 | 34081600.0 |
| 2000-03-15 15:00:00 | AAPL | Stock | 1.0586 | 1.0642 | 1.0313 | 1.0357 | 71377600.0 |
| 2000-03-15 16:00:00 | AAPL | Stock | 1.0374 | 1.0391 | 1.0368 | 1.0379 | 1388800.0 |
| 2000-03-15 09:00:00 | MSFT | Stock | 47.2812 | 48.0 | 46.9375 | 47.9375 | 7302800.0 |
| 2000-03-15 10:00:00 | MSFT | Stock | 47.9062 | 48.3125 | 47.75 | 47.875 | 7932600.0 |
| 2000-03-15 11:00:00 | MSFT | Stock | 47.8438 | 48.3125 | 47.6875 | 48.2812 | 9057600.0 |
| 2000-03-15 12:00:00 | MSFT | Stock | 48.25 | 48.3125 | 47.4688 | 47.6875 | 6223200.0 |
| 2000-03-15 13:00:00 | MSFT | Stock | 47.7188 | 47.9688 | 47.5312 | 47.8438 | 5228600.0 |
| 2000-03-15 14:00:00 | MSFT | Stock | 47.875 | 48.2188 | 47.5625 | 47.6875 | 5811000.0 |
| 2000-03-15 15:00:00 | MSFT | Stock | 47.6875 | 48.25 | 47.5938 | 47.6875 | 6344600.0 |
| 2000-03-15 16:00:00 | MSFT | Stock | 47.6875 | 47.75 | 47.5938 | 47.6875 | 1236800.0 |
| 2000-03-15 09:00:00 | NVDA | Stock | 0.2459 | 0.2522 | 0.2167 | 0.2208 | 221904000.0 |
| 2000-03-15 10:00:00 | NVDA | Stock | 0.2194 | 0.2435 | 0.2125 | 0.2336 | 205200000.0 |
| 2000-03-15 11:00:00 | NVDA | Stock | 0.2354 | 0.2376 | 0.2279 | 0.2333 | 95136000.0 |
| 2000-03-15 12:00:00 | NVDA | Stock | 0.2333 | 0.2342 | 0.2182 | 0.2198 | 84048000.0 |
| 2000-03-15 13:00:00 | NVDA | Stock | 0.2198 | 0.2276 | 0.2198 | 0.2245 | 64656000.0 |
| 2000-03-15 14:00:00 | NVDA | Stock | 0.225 | 0.2286 | 0.224 | 0.2255 | 58944000.0 |
| 2000-03-15 09:00:00 | AMZN | Stock | 3.2375 | 3.2438 | 3.1719 | 3.2312 | 10692000.0 |
| 2000-03-15 10:00:00 | AMZN | Stock | 3.2312 | 3.2562 | 3.175 | 3.2 | 16412000.0 |
| 2000-03-15 11:00:00 | AMZN | Stock | 3.2031 | 3.2063 | 3.1562 | 3.1844 | 18206000.0 |
| 2000-03-15 12:00:00 | AMZN | Stock | 3.1813 | 3.1875 | 3.1062 | 3.1688 | 13786000.0 |
| 2000-03-15 13:00:00 | AMZN | Stock | 3.1656 | 3.2281 | 3.1594 | 3.1938 | 10710000.0 |
| 2000-03-15 14:00:00 | AMZN | Stock | 3.2031 | 3.225 | 3.125 | 3.1406 | 13610000.0 |
| 2000-03-15 15:00:00 | AMZN | Stock | 3.1406 | 3.1469 | 3.1 | 3.1406 | 26352000.0 |
| 2000-03-15 16:00:00 | AMZN | Stock | 3.1312 | 3.2031 | 3.1125 | 3.2 | 1896000.0 |
| 2000-03-15 09:00:00 | CL | Stock | 21.9375 | 22.25 | 21.875 | 22.0938 | 515000.0 |
| 2000-03-15 10:00:00 | CL | Stock | 22.125 | 22.4375 | 21.9688 | 22.3125 | 735400.0 |
| 2000-03-15 11:00:00 | CL | Stock | 22.3438 | 23.25 | 22.1875 | 23.25 | 673600.0 |
| 2000-03-15 12:00:00 | CL | Stock | 23.25 | 23.8125 | 23.25 | 23.7812 | 1184800.0 |
| 2000-03-15 13:00:00 | CL | Stock | 23.7812 | 23.9375 | 23.75 | 23.8438 | 744800.0 |
| 2000-03-15 14:00:00 | CL | Stock | 23.7812 | 25.25 | 23.625 | 25.0625 | 1658600.0 |
| 2000-03-15 15:00:00 | CL | Stock | 25.0625 | 27.0 | 25.0625 | 25.875 | 5685400.0 |
| 2000-03-15 16:00:00 | CL | Stock | 25.9062 | 25.9062 | 25.875 | 25.9062 | 458600.0 |
| 2000-03-15 17:00:00 | CL | Stock | 25.9062 | 25.9062 | 25.9062 | 25.9062 | 800.0 |
> showing 39 of 14,053 rows — these rows as CSV