PREVIEW / stock_1hour / 2024-12-02
file: by_date/stock_1hour/2024/2024-12-02.parquet size: 1.4 MB rows: 63,815 symbols: 697
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 |
|---|---|---|---|---|---|---|---|
| 2024-12-02 04:00:00 | AAPL | Stock | 237.1 | 237.19 | 236.86 | 237.17 | 8758.0 |
| 2024-12-02 05:00:00 | AAPL | Stock | 237.15 | 237.23 | 237.12 | 237.17 | 5020.0 |
| 2024-12-02 06:00:00 | AAPL | Stock | 237.19 | 237.29 | 237.15 | 237.18 | 8430.0 |
| 2024-12-02 07:00:00 | AAPL | Stock | 237.25 | 238.0 | 237.05 | 237.42 | 69044.0 |
| 2024-12-02 08:00:00 | AAPL | Stock | 237.75 | 237.95 | 236.0 | 237.244 | 93798.0 |
| 2024-12-02 09:00:00 | AAPL | Stock | 237.28 | 239.6 | 236.78 | 239.305 | 4783726.0 |
| 2024-12-02 10:00:00 | AAPL | Stock | 239.28 | 240.79 | 238.96 | 240.09 | 5815060.0 |
| 2024-12-02 11:00:00 | AAPL | Stock | 240.09 | 240.24 | 239.36 | 239.9558 | 2859787.0 |
| 2024-12-02 12:00:00 | AAPL | Stock | 239.95 | 240.2 | 239.51 | 239.5101 | 1809802.0 |
| 2024-12-02 13:00:00 | AAPL | Stock | 239.51 | 239.72 | 239.03 | 239.1488 | 1931714.0 |
| 2024-12-02 14:00:00 | AAPL | Stock | 239.1401 | 239.67 | 239.03 | 239.64 | 1623421.0 |
| 2024-12-02 15:00:00 | AAPL | Stock | 239.64 | 239.94 | 239.04 | 239.6 | 4034190.0 |
| 2024-12-02 16:00:00 | AAPL | Stock | 239.6 | 239.98 | 239.59 | 239.88 | 6995948.0 |
| 2024-12-02 17:00:00 | AAPL | Stock | 239.84 | 239.94 | 239.7009 | 239.7245 | 11024.0 |
| 2024-12-02 18:00:00 | AAPL | Stock | 239.704 | 239.82 | 239.6301 | 239.75 | 9611.0 |
| 2024-12-02 19:00:00 | AAPL | Stock | 239.72 | 239.8 | 239.65 | 239.68 | 3727.0 |
| 2024-12-02 04:00:00 | MSFT | Stock | 422.61 | 422.61 | 421.09 | 421.4 | 10841.0 |
| 2024-12-02 05:00:00 | MSFT | Stock | 421.21 | 421.59 | 420.87 | 421.59 | 2792.0 |
| 2024-12-02 06:00:00 | MSFT | Stock | 421.66 | 421.75 | 421.65 | 421.75 | 5923.0 |
| 2024-12-02 07:00:00 | MSFT | Stock | 421.72 | 423.03 | 421.72 | 422.97 | 6738.0 |
| 2024-12-02 08:00:00 | MSFT | Stock | 422.4 | 422.93 | 421.73 | 422.2 | 38049.0 |
| 2024-12-02 09:00:00 | MSFT | Stock | 422.34 | 427.1 | 421.31 | 426.17 | 1325234.0 |
| 2024-12-02 10:00:00 | MSFT | Stock | 426.19 | 433.0 | 425.98 | 431.195 | 2202465.0 |
| 2024-12-02 11:00:00 | MSFT | Stock | 431.14 | 431.8774 | 429.76 | 431.2834 | 911583.0 |
| 2024-12-02 12:00:00 | MSFT | Stock | 431.32 | 431.77 | 430.58 | 431.0 | 677931.0 |
| 2024-12-02 13:00:00 | MSFT | Stock | 431.0 | 431.335 | 430.245 | 431.3299 | 523936.0 |
| 2024-12-02 14:00:00 | MSFT | Stock | 431.33 | 431.82 | 431.0 | 431.2403 | 670657.0 |
| 2024-12-02 15:00:00 | MSFT | Stock | 431.24 | 431.94 | 430.05 | 430.97 | 1433055.0 |
| 2024-12-02 16:00:00 | MSFT | Stock | 430.98 | 431.45 | 430.23 | 430.98 | 3539225.0 |
| 2024-12-02 17:00:00 | MSFT | Stock | 430.9692 | 430.98 | 430.6 | 430.6 | 18303.0 |
| 2024-12-02 18:00:00 | MSFT | Stock | 430.6 | 430.98 | 430.55 | 430.81 | 5749.0 |
| 2024-12-02 19:00:00 | MSFT | Stock | 430.9582 | 430.96 | 430.56 | 430.86 | 5905.0 |
| 2024-12-02 04:00:00 | NVDA | Stock | 138.1 | 138.25 | 136.37 | 136.47 | 647325.0 |
| 2024-12-02 05:00:00 | NVDA | Stock | 136.5 | 136.73 | 135.71 | 136.46 | 397496.0 |
| 2024-12-02 06:00:00 | NVDA | Stock | 136.46 | 136.97 | 136.32 | 136.87 | 223474.0 |
| 2024-12-02 07:00:00 | NVDA | Stock | 136.88 | 137.74 | 136.81 | 137.47 | 697598.0 |
| 2024-12-02 08:00:00 | NVDA | Stock | 136.91 | 138.45 | 135.99 | 137.84 | 1987300.0 |
| 2024-12-02 09:00:00 | NVDA | Stock | 137.83 | 140.45 | 137.83 | 139.82 | 27814533.0 |
| 2024-12-02 10:00:00 | NVDA | Stock | 139.88 | 140.37 | 138.3 | 138.5399 | 25038368.0 |
| 2024-12-02 11:00:00 | NVDA | Stock | 138.55 | 139.54 | 138.525 | 139.2699 | 13179244.0 |
| 2024-12-02 12:00:00 | NVDA | Stock | 139.25 | 139.6499 | 138.76 | 138.7687 | 10541149.0 |
| 2024-12-02 13:00:00 | NVDA | Stock | 138.76 | 138.89 | 137.94 | 138.5837 | 13375542.0 |
| 2024-12-02 14:00:00 | NVDA | Stock | 138.595 | 138.595 | 137.825 | 138.57 | 10188996.0 |
| 2024-12-02 15:00:00 | NVDA | Stock | 138.56 | 139.0 | 137.89 | 138.63 | 16123687.0 |
| 2024-12-02 16:00:00 | NVDA | Stock | 138.63 | 138.75 | 138.3 | 138.5 | 14804469.0 |
| 2024-12-02 17:00:00 | NVDA | Stock | 138.48 | 138.5293 | 138.36 | 138.38 | 175440.0 |
| 2024-12-02 18:00:00 | NVDA | Stock | 138.38 | 138.48 | 138.35 | 138.44 | 144861.0 |
| 2024-12-02 19:00:00 | NVDA | Stock | 138.42 | 138.44 | 138.04 | 138.1 | 280634.0 |
| 2024-12-02 04:00:00 | AMZN | Stock | 208.5 | 208.9 | 208.19 | 208.75 | 15167.0 |
| 2024-12-02 05:00:00 | AMZN | Stock | 208.71 | 208.99 | 208.47 | 208.73 | 12619.0 |
> showing 50 of 63,815 rows — these rows as CSV