PREVIEW / stock_1hour / 2000-06-02
file: by_date/stock_1hour/2000/2000-06-02.parquet size: 301 KB rows: 15,582 symbols: 1,176
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-06-02 08:00:00 | AAPL | Stock | 0.7969 | 0.8292 | 0.7969 | 0.817 | 1422400.0 |
| 2000-06-02 09:00:00 | AAPL | Stock | 0.8214 | 0.8906 | 0.8214 | 0.8571 | 131387200.0 |
| 2000-06-02 10:00:00 | AAPL | Stock | 0.8571 | 0.8661 | 0.8449 | 0.8544 | 101628800.0 |
| 2000-06-02 11:00:00 | AAPL | Stock | 0.8544 | 0.8605 | 0.8415 | 0.8415 | 120512000.0 |
| 2000-06-02 12:00:00 | AAPL | Stock | 0.8421 | 0.8426 | 0.808 | 0.8181 | 134803200.0 |
| 2000-06-02 13:00:00 | AAPL | Stock | 0.8181 | 0.822 | 0.808 | 0.8147 | 106556800.0 |
| 2000-06-02 14:00:00 | AAPL | Stock | 0.8147 | 0.8237 | 0.7997 | 0.8153 | 70548800.0 |
| 2000-06-02 15:00:00 | AAPL | Stock | 0.8156 | 0.8281 | 0.8058 | 0.8259 | 89387200.0 |
| 2000-06-02 16:00:00 | AAPL | Stock | 0.8237 | 0.8404 | 0.8214 | 0.8214 | 8724800.0 |
| 2000-06-02 17:00:00 | AAPL | Stock | 0.8214 | 0.8214 | 0.8164 | 0.8164 | 291200.0 |
| 2000-06-02 08:00:00 | MSFT | Stock | 32.5625 | 32.875 | 32.2656 | 32.8125 | 1613000.0 |
| 2000-06-02 09:00:00 | MSFT | Stock | 32.8125 | 33.375 | 32.6875 | 32.75 | 16092200.0 |
| 2000-06-02 10:00:00 | MSFT | Stock | 32.7188 | 33.0938 | 32.5 | 33.0 | 13699000.0 |
| 2000-06-02 11:00:00 | MSFT | Stock | 33.0 | 33.2188 | 32.9062 | 33.0938 | 6940000.0 |
| 2000-06-02 12:00:00 | MSFT | Stock | 33.0938 | 33.1875 | 32.875 | 32.9375 | 6037000.0 |
| 2000-06-02 13:00:00 | MSFT | Stock | 32.9062 | 33.0312 | 32.625 | 32.6875 | 8512800.0 |
| 2000-06-02 14:00:00 | MSFT | Stock | 32.6875 | 33.0938 | 32.5625 | 33.0312 | 11745200.0 |
| 2000-06-02 15:00:00 | MSFT | Stock | 33.0 | 33.1875 | 32.9375 | 33.1875 | 11447400.0 |
| 2000-06-02 16:00:00 | MSFT | Stock | 33.1875 | 33.2969 | 32.75 | 33.125 | 2099800.0 |
| 2000-06-02 17:00:00 | MSFT | Stock | 33.125 | 33.1875 | 32.7188 | 33.1562 | 18800.0 |
| 2000-06-02 18:00:00 | MSFT | Stock | 33.1562 | 33.1562 | 33.1562 | 33.1562 | 1400.0 |
| 2000-06-02 08:00:00 | NVDA | Stock | 0.2479 | 0.2542 | 0.2479 | 0.25 | 528000.0 |
| 2000-06-02 09:00:00 | NVDA | Stock | 0.2505 | 0.2667 | 0.2479 | 0.2634 | 102384000.0 |
| 2000-06-02 10:00:00 | NVDA | Stock | 0.2626 | 0.2646 | 0.2611 | 0.2625 | 82752000.0 |
| 2000-06-02 11:00:00 | NVDA | Stock | 0.2629 | 0.263 | 0.2591 | 0.2611 | 59184000.0 |
| 2000-06-02 12:00:00 | NVDA | Stock | 0.2611 | 0.2632 | 0.2591 | 0.2596 | 54288000.0 |
| 2000-06-02 13:00:00 | NVDA | Stock | 0.2591 | 0.2654 | 0.2591 | 0.2654 | 50544000.0 |
| 2000-06-02 14:00:00 | NVDA | Stock | 0.2646 | 0.2745 | 0.2638 | 0.2732 | 81600000.0 |
| 2000-06-02 15:00:00 | NVDA | Stock | 0.2732 | 0.2771 | 0.2708 | 0.275 | 132624000.0 |
| 2000-06-02 16:00:00 | NVDA | Stock | 0.275 | 0.275 | 0.2708 | 0.275 | 8448000.0 |
| 2000-06-02 17:00:00 | NVDA | Stock | 0.275 | 0.275 | 0.275 | 0.275 | 240000.0 |
| 2000-06-02 18:00:00 | NVDA | Stock | 0.275 | 0.275 | 0.275 | 0.275 | 96000.0 |
| 2000-06-02 08:00:00 | AMZN | Stock | 2.4875 | 2.7 | 2.4875 | 2.5969 | 1436000.0 |
| 2000-06-02 09:00:00 | AMZN | Stock | 2.6375 | 2.7156 | 2.5844 | 2.6813 | 27920000.0 |
| 2000-06-02 10:00:00 | AMZN | Stock | 2.6813 | 2.7375 | 2.6719 | 2.6969 | 24276000.0 |
| 2000-06-02 11:00:00 | AMZN | Stock | 2.6969 | 2.7312 | 2.6906 | 2.7 | 16110000.0 |
| 2000-06-02 12:00:00 | AMZN | Stock | 2.7031 | 2.7063 | 2.675 | 2.6969 | 10118000.0 |
| 2000-06-02 13:00:00 | AMZN | Stock | 2.7 | 2.7125 | 2.6719 | 2.675 | 11992000.0 |
| 2000-06-02 14:00:00 | AMZN | Stock | 2.675 | 2.7875 | 2.6719 | 2.7781 | 21110000.0 |
| 2000-06-02 15:00:00 | AMZN | Stock | 2.775 | 2.9062 | 2.75 | 2.8969 | 43798000.0 |
| 2000-06-02 16:00:00 | AMZN | Stock | 2.8969 | 2.8969 | 2.8375 | 2.8938 | 5590000.0 |
| 2000-06-02 17:00:00 | AMZN | Stock | 2.8531 | 2.8938 | 2.8375 | 2.8375 | 30000.0 |
| 2000-06-02 18:00:00 | AMZN | Stock | 2.825 | 2.825 | 2.8094 | 2.8219 | 34000.0 |
| 2000-06-02 09:00:00 | CL | Stock | 27.125 | 27.1562 | 26.9688 | 27.0625 | 428600.0 |
| 2000-06-02 10:00:00 | CL | Stock | 27.0625 | 27.1875 | 27.0 | 27.0938 | 597200.0 |
| 2000-06-02 11:00:00 | CL | Stock | 27.0 | 27.125 | 27.0 | 27.0938 | 171800.0 |
| 2000-06-02 12:00:00 | CL | Stock | 27.0938 | 27.125 | 27.0 | 27.0625 | 146000.0 |
| 2000-06-02 13:00:00 | CL | Stock | 27.0625 | 27.125 | 27.0 | 27.0938 | 332800.0 |
| 2000-06-02 14:00:00 | CL | Stock | 27.0938 | 27.25 | 27.0312 | 27.0938 | 229400.0 |
| 2000-06-02 15:00:00 | CL | Stock | 27.125 | 27.4375 | 27.125 | 27.375 | 612200.0 |
> showing 50 of 15,582 rows — these rows as CSV