PREVIEW / stock_1hour / 2000-12-20
file: by_date/stock_1hour/2000/2000-12-20.parquet size: 321 KB rows: 16,839 symbols: 1,262
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-12-20 08:00:00 | AAPL | Stock | 0.2455 | 0.2511 | 0.2455 | 0.2455 | 532000.0 |
| 2000-12-20 09:00:00 | AAPL | Stock | 0.2489 | 0.2533 | 0.2433 | 0.25 | 57338400.0 |
| 2000-12-20 10:00:00 | AAPL | Stock | 0.25 | 0.2556 | 0.2467 | 0.25 | 88698400.0 |
| 2000-12-20 11:00:00 | AAPL | Stock | 0.2511 | 0.2545 | 0.25 | 0.2511 | 63655200.0 |
| 2000-12-20 12:00:00 | AAPL | Stock | 0.2511 | 0.2545 | 0.2511 | 0.2522 | 82135200.0 |
| 2000-12-20 13:00:00 | AAPL | Stock | 0.2522 | 0.2556 | 0.2511 | 0.2533 | 61874400.0 |
| 2000-12-20 14:00:00 | AAPL | Stock | 0.2533 | 0.2612 | 0.2533 | 0.2545 | 67939200.0 |
| 2000-12-20 15:00:00 | AAPL | Stock | 0.2533 | 0.2567 | 0.2511 | 0.2556 | 89538400.0 |
| 2000-12-20 16:00:00 | AAPL | Stock | 0.2567 | 0.2578 | 0.2522 | 0.2567 | 12174400.0 |
| 2000-12-20 17:00:00 | AAPL | Stock | 0.2567 | 0.2567 | 0.2522 | 0.2522 | 1164800.0 |
| 2000-12-20 08:00:00 | MSFT | Stock | 22.375 | 22.4219 | 21.125 | 21.6875 | 85200.0 |
| 2000-12-20 09:00:00 | MSFT | Stock | 21.75 | 22.4062 | 21.2812 | 21.875 | 24772000.0 |
| 2000-12-20 10:00:00 | MSFT | Stock | 21.8438 | 21.9062 | 21.3438 | 21.6875 | 23667800.0 |
| 2000-12-20 11:00:00 | MSFT | Stock | 21.6875 | 21.75 | 21.375 | 21.5312 | 15716800.0 |
| 2000-12-20 12:00:00 | MSFT | Stock | 21.5625 | 21.5938 | 21.1562 | 21.1562 | 12562600.0 |
| 2000-12-20 13:00:00 | MSFT | Stock | 21.1562 | 21.25 | 20.9688 | 21.0938 | 16613000.0 |
| 2000-12-20 14:00:00 | MSFT | Stock | 21.125 | 21.4062 | 20.9375 | 21.0625 | 13875400.0 |
| 2000-12-20 15:00:00 | MSFT | Stock | 21.0312 | 21.1875 | 20.6875 | 20.7188 | 25515000.0 |
| 2000-12-20 16:00:00 | MSFT | Stock | 20.7188 | 21.9219 | 20.6875 | 20.8438 | 2178600.0 |
| 2000-12-20 17:00:00 | MSFT | Stock | 20.75 | 20.9375 | 20.75 | 20.8438 | 229200.0 |
| 2000-12-20 18:00:00 | MSFT | Stock | 20.8125 | 20.8438 | 20.75 | 20.8438 | 10200.0 |
| 2000-12-20 09:00:00 | NVDA | Stock | 0.1417 | 0.149 | 0.1401 | 0.1471 | 125160000.0 |
| 2000-12-20 10:00:00 | NVDA | Stock | 0.1471 | 0.162 | 0.1464 | 0.1552 | 140544000.0 |
| 2000-12-20 11:00:00 | NVDA | Stock | 0.1551 | 0.1563 | 0.149 | 0.1495 | 79704000.0 |
| 2000-12-20 12:00:00 | NVDA | Stock | 0.1495 | 0.15 | 0.1438 | 0.1445 | 86712000.0 |
| 2000-12-20 13:00:00 | NVDA | Stock | 0.1445 | 0.1469 | 0.1409 | 0.1411 | 76656000.0 |
| 2000-12-20 14:00:00 | NVDA | Stock | 0.1406 | 0.1409 | 0.1271 | 0.1302 | 214896000.0 |
| 2000-12-20 15:00:00 | NVDA | Stock | 0.1305 | 0.1354 | 0.1255 | 0.1328 | 272040000.0 |
| 2000-12-20 16:00:00 | NVDA | Stock | 0.1328 | 0.1342 | 0.1318 | 0.1333 | 3264000.0 |
| 2000-12-20 08:00:00 | AMZN | Stock | 0.8938 | 0.8938 | 0.8375 | 0.8625 | 346000.0 |
| 2000-12-20 09:00:00 | AMZN | Stock | 0.85 | 0.8812 | 0.7812 | 0.8344 | 47954000.0 |
| 2000-12-20 10:00:00 | AMZN | Stock | 0.8312 | 0.8938 | 0.8156 | 0.875 | 60872000.0 |
| 2000-12-20 11:00:00 | AMZN | Stock | 0.875 | 0.8938 | 0.8625 | 0.8719 | 39652000.0 |
| 2000-12-20 12:00:00 | AMZN | Stock | 0.8688 | 0.8719 | 0.8375 | 0.8406 | 47334000.0 |
| 2000-12-20 13:00:00 | AMZN | Stock | 0.8375 | 0.85 | 0.8219 | 0.825 | 58152000.0 |
| 2000-12-20 14:00:00 | AMZN | Stock | 0.825 | 0.8438 | 0.8031 | 0.8062 | 44752000.0 |
| 2000-12-20 15:00:00 | AMZN | Stock | 0.8062 | 0.8406 | 0.7875 | 0.8312 | 74526000.0 |
| 2000-12-20 16:00:00 | AMZN | Stock | 0.8312 | 0.8562 | 0.8125 | 0.8344 | 10858000.0 |
| 2000-12-20 17:00:00 | AMZN | Stock | 0.8344 | 0.8344 | 0.8125 | 0.8125 | 212000.0 |
| 2000-12-20 18:00:00 | AMZN | Stock | 0.8312 | 0.8375 | 0.8312 | 0.8375 | 14000.0 |
| 2000-12-20 09:00:00 | CL | Stock | 29.375 | 29.9 | 29.375 | 29.88 | 232400.0 |
| 2000-12-20 10:00:00 | CL | Stock | 29.88 | 30.0 | 29.7 | 29.795 | 279400.0 |
| 2000-12-20 11:00:00 | CL | Stock | 29.81 | 29.875 | 29.7 | 29.8 | 194600.0 |
| 2000-12-20 12:00:00 | CL | Stock | 29.8 | 29.875 | 29.505 | 29.65 | 303400.0 |
| 2000-12-20 13:00:00 | CL | Stock | 29.635 | 29.775 | 29.51 | 29.665 | 170800.0 |
| 2000-12-20 14:00:00 | CL | Stock | 29.665 | 29.975 | 29.625 | 29.83 | 261600.0 |
| 2000-12-20 15:00:00 | CL | Stock | 29.83 | 29.9 | 29.595 | 29.65 | 711400.0 |
| 2000-12-20 16:00:00 | CL | Stock | 29.655 | 29.715 | 29.655 | 29.715 | 88000.0 |
> showing 48 of 16,839 rows — these rows as CSV