PREVIEW / stock_1hour / 2000-02-23
file: by_date/stock_1hour/2000/2000-02-23.parquet size: 283 KB rows: 14,504 symbols: 1,137
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-23 09:00:00 | AAPL | Stock | 1.0109 | 1.0234 | 0.9911 | 1.0078 | 34753600.0 |
| 2000-02-23 10:00:00 | AAPL | Stock | 1.0078 | 1.0307 | 1.0022 | 1.0212 | 46614400.0 |
| 2000-02-23 11:00:00 | AAPL | Stock | 1.0212 | 1.0301 | 1.0156 | 1.0268 | 39356800.0 |
| 2000-02-23 12:00:00 | AAPL | Stock | 1.0279 | 1.0301 | 1.0212 | 1.0273 | 34888000.0 |
| 2000-02-23 13:00:00 | AAPL | Stock | 1.0279 | 1.058 | 1.0268 | 1.0575 | 100811200.0 |
| 2000-02-23 14:00:00 | AAPL | Stock | 1.0569 | 1.0625 | 1.0485 | 1.0491 | 66460800.0 |
| 2000-02-23 15:00:00 | AAPL | Stock | 1.0497 | 1.0592 | 1.0324 | 1.0379 | 82017600.0 |
| 2000-02-23 16:00:00 | AAPL | Stock | 1.0374 | 1.0379 | 1.0374 | 1.0379 | 660800.0 |
| 2000-02-23 09:00:00 | MSFT | Stock | 46.75 | 47.3125 | 46.5938 | 46.75 | 6921200.0 |
| 2000-02-23 10:00:00 | MSFT | Stock | 46.7188 | 47.0312 | 46.4688 | 46.6562 | 7267400.0 |
| 2000-02-23 11:00:00 | MSFT | Stock | 46.6875 | 46.75 | 46.0312 | 46.4688 | 8459400.0 |
| 2000-02-23 12:00:00 | MSFT | Stock | 46.5312 | 47.0312 | 46.4688 | 46.875 | 7370600.0 |
| 2000-02-23 13:00:00 | MSFT | Stock | 46.875 | 47.7812 | 46.875 | 47.5625 | 13473600.0 |
| 2000-02-23 14:00:00 | MSFT | Stock | 47.5625 | 47.5625 | 47.0 | 47.2812 | 10249200.0 |
| 2000-02-23 15:00:00 | MSFT | Stock | 47.3125 | 47.625 | 47.0 | 47.1562 | 17792200.0 |
| 2000-02-23 16:00:00 | MSFT | Stock | 47.1562 | 47.1562 | 47.0625 | 47.125 | 167000.0 |
| 2000-02-23 09:00:00 | NVDA | Stock | 0.1349 | 0.1354 | 0.1332 | 0.1354 | 69696000.0 |
| 2000-02-23 10:00:00 | NVDA | Stock | 0.1349 | 0.1355 | 0.1339 | 0.1354 | 46608000.0 |
| 2000-02-23 11:00:00 | NVDA | Stock | 0.1341 | 0.1354 | 0.1341 | 0.1346 | 28992000.0 |
| 2000-02-23 12:00:00 | NVDA | Stock | 0.1345 | 0.1357 | 0.1345 | 0.1357 | 15120000.0 |
| 2000-02-23 13:00:00 | NVDA | Stock | 0.1354 | 0.1387 | 0.1345 | 0.1355 | 143904000.0 |
| 2000-02-23 14:00:00 | NVDA | Stock | 0.1359 | 0.1372 | 0.1355 | 0.1371 | 68784000.0 |
| 2000-02-23 15:00:00 | NVDA | Stock | 0.137 | 0.138 | 0.1367 | 0.1372 | 100176000.0 |
| 2000-02-23 09:00:00 | AMZN | Stock | 3.2438 | 3.3375 | 3.2344 | 3.3375 | 19730000.0 |
| 2000-02-23 10:00:00 | AMZN | Stock | 3.3312 | 3.4125 | 3.2969 | 3.3969 | 31532000.0 |
| 2000-02-23 11:00:00 | AMZN | Stock | 3.3938 | 3.425 | 3.3562 | 3.375 | 12714000.0 |
| 2000-02-23 12:00:00 | AMZN | Stock | 3.375 | 3.4 | 3.375 | 3.3969 | 9618000.0 |
| 2000-02-23 13:00:00 | AMZN | Stock | 3.4 | 3.4875 | 3.3938 | 3.475 | 18418000.0 |
| 2000-02-23 14:00:00 | AMZN | Stock | 3.475 | 3.575 | 3.4656 | 3.5531 | 36684000.0 |
| 2000-02-23 15:00:00 | AMZN | Stock | 3.5531 | 3.5875 | 3.5062 | 3.525 | 35914000.0 |
| 2000-02-23 16:00:00 | AMZN | Stock | 3.5188 | 3.5312 | 3.5188 | 3.5219 | 194000.0 |
| 2000-02-23 09:00:00 | CL | Stock | 25.9375 | 25.9688 | 25.7188 | 25.875 | 215400.0 |
| 2000-02-23 10:00:00 | CL | Stock | 25.9062 | 25.9688 | 25.5312 | 25.625 | 374400.0 |
| 2000-02-23 11:00:00 | CL | Stock | 25.5938 | 25.6875 | 25.4688 | 25.5 | 495400.0 |
| 2000-02-23 12:00:00 | CL | Stock | 25.5312 | 25.5938 | 25.5 | 25.5 | 414800.0 |
| 2000-02-23 13:00:00 | CL | Stock | 25.5312 | 25.6875 | 25.5 | 25.6875 | 379000.0 |
| 2000-02-23 14:00:00 | CL | Stock | 25.6875 | 25.8438 | 25.6875 | 25.75 | 346200.0 |
| 2000-02-23 15:00:00 | CL | Stock | 25.7812 | 25.9688 | 25.6875 | 25.6875 | 697600.0 |
| 2000-02-23 16:00:00 | CL | Stock | 25.7188 | 25.7188 | 25.6875 | 25.6875 | 129800.0 |
> showing 39 of 14,504 rows — these rows as CSV