PREVIEW / stock_1hour / 2024-11-15
file: by_date/stock_1hour/2024/2024-11-15.parquet size: 1.4 MB rows: 60,954 symbols: 710
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-11-15 04:00:00 | AAPL | Stock | 226.9 | 226.9 | 225.6 | 225.99 | 31612.0 |
| 2024-11-15 05:00:00 | AAPL | Stock | 226.05 | 226.05 | 225.73 | 225.95 | 10296.0 |
| 2024-11-15 06:00:00 | AAPL | Stock | 225.99 | 226.48 | 225.98 | 226.26 | 13853.0 |
| 2024-11-15 07:00:00 | AAPL | Stock | 226.41 | 226.73 | 226.25 | 226.72 | 27500.0 |
| 2024-11-15 08:00:00 | AAPL | Stock | 226.4 | 228.22 | 225.799 | 226.0902 | 92618.0 |
| 2024-11-15 09:00:00 | AAPL | Stock | 226.05 | 226.92 | 224.85 | 225.07 | 6992365.0 |
| 2024-11-15 10:00:00 | AAPL | Stock | 225.065 | 225.3 | 224.44 | 224.62 | 3464407.0 |
| 2024-11-15 11:00:00 | AAPL | Stock | 224.63 | 225.48 | 224.46 | 225.1 | 2304826.0 |
| 2024-11-15 12:00:00 | AAPL | Stock | 225.1 | 225.18 | 224.27 | 224.73 | 1928988.0 |
| 2024-11-15 13:00:00 | AAPL | Stock | 224.735 | 224.95 | 224.45 | 224.665 | 1635138.0 |
| 2024-11-15 14:00:00 | AAPL | Stock | 224.67 | 224.96 | 224.3 | 224.825 | 1603142.0 |
| 2024-11-15 15:00:00 | AAPL | Stock | 224.825 | 225.31 | 224.5699 | 224.92 | 4287845.0 |
| 2024-11-15 16:00:00 | AAPL | Stock | 224.92 | 225.2005 | 224.92 | 225.01 | 9684266.0 |
| 2024-11-15 17:00:00 | AAPL | Stock | 225.02 | 225.1 | 225.0 | 225.1 | 578084.0 |
| 2024-11-15 18:00:00 | AAPL | Stock | 225.07 | 225.2 | 225.03 | 225.03 | 6959.0 |
| 2024-11-15 19:00:00 | AAPL | Stock | 225.04 | 225.26 | 225.03 | 225.26 | 7249.0 |
| 2024-11-15 04:00:00 | MSFT | Stock | 423.77 | 423.81 | 423.57 | 423.57 | 3536.0 |
| 2024-11-15 05:00:00 | MSFT | Stock | 423.63 | 423.63 | 422.7 | 423.0 | 2439.0 |
| 2024-11-15 06:00:00 | MSFT | Stock | 422.94 | 424.03 | 422.94 | 423.87 | 4195.0 |
| 2024-11-15 07:00:00 | MSFT | Stock | 423.82 | 424.8 | 423.82 | 424.65 | 7836.0 |
| 2024-11-15 08:00:00 | MSFT | Stock | 424.1986 | 426.89 | 423.2 | 423.3901 | 23721.0 |
| 2024-11-15 09:00:00 | MSFT | Stock | 423.4104 | 423.6 | 418.21 | 419.065 | 3316719.0 |
| 2024-11-15 10:00:00 | MSFT | Stock | 419.075 | 419.3 | 416.24 | 416.69 | 1813404.0 |
| 2024-11-15 11:00:00 | MSFT | Stock | 416.65 | 417.175 | 414.39 | 414.85 | 1051204.0 |
| 2024-11-15 12:00:00 | MSFT | Stock | 414.9 | 415.25 | 413.64 | 414.755 | 958529.0 |
| 2024-11-15 13:00:00 | MSFT | Stock | 414.765 | 415.4099 | 414.31 | 414.6481 | 840972.0 |
| 2024-11-15 14:00:00 | MSFT | Stock | 414.6401 | 415.4 | 413.84 | 414.0567 | 1046024.0 |
| 2024-11-15 15:00:00 | MSFT | Stock | 414.065 | 415.82 | 414.0564 | 414.81 | 2428009.0 |
| 2024-11-15 16:00:00 | MSFT | Stock | 415.0 | 415.65 | 414.5 | 415.0076 | 4875721.0 |
| 2024-11-15 17:00:00 | MSFT | Stock | 415.1 | 415.1 | 414.8374 | 415.0 | 10416.0 |
| 2024-11-15 18:00:00 | MSFT | Stock | 414.7669 | 415.0 | 414.7669 | 414.9 | 2307.0 |
| 2024-11-15 19:00:00 | MSFT | Stock | 414.94 | 415.0 | 414.9 | 414.9999 | 2415.0 |
| 2024-11-15 04:00:00 | NVDA | Stock | 145.83 | 146.32 | 145.55 | 145.94 | 342905.0 |
| 2024-11-15 05:00:00 | NVDA | Stock | 145.92 | 146.15 | 145.8 | 145.86 | 234249.0 |
| 2024-11-15 06:00:00 | NVDA | Stock | 145.87 | 146.62 | 145.84 | 146.37 | 265979.0 |
| 2024-11-15 07:00:00 | NVDA | Stock | 146.36 | 146.49 | 145.86 | 146.07 | 585909.0 |
| 2024-11-15 08:00:00 | NVDA | Stock | 146.2 | 146.76 | 145.03 | 145.28 | 2035952.0 |
| 2024-11-15 09:00:00 | NVDA | Stock | 145.28 | 145.72 | 143.2716 | 143.81 | 33312621.0 |
| 2024-11-15 10:00:00 | NVDA | Stock | 143.85 | 144.3 | 141.81 | 143.1821 | 33145047.0 |
| 2024-11-15 11:00:00 | NVDA | Stock | 143.1899 | 143.53 | 141.3 | 141.4123 | 21870075.0 |
| 2024-11-15 12:00:00 | NVDA | Stock | 141.42 | 142.19 | 140.84 | 141.735 | 20828618.0 |
| 2024-11-15 13:00:00 | NVDA | Stock | 141.735 | 141.79 | 140.35 | 140.565 | 18125481.0 |
| 2024-11-15 14:00:00 | NVDA | Stock | 140.57 | 141.55 | 140.08 | 141.32 | 20299556.0 |
| 2024-11-15 15:00:00 | NVDA | Stock | 141.325 | 142.34 | 141.27 | 141.9703 | 29227249.0 |
| 2024-11-15 16:00:00 | NVDA | Stock | 141.88 | 142.4901 | 141.83 | 142.05 | 20826630.0 |
| 2024-11-15 17:00:00 | NVDA | Stock | 142.04 | 142.21 | 141.95 | 142.17 | 415486.0 |
| 2024-11-15 18:00:00 | NVDA | Stock | 142.1699 | 142.41 | 142.15 | 142.32 | 277704.0 |
| 2024-11-15 19:00:00 | NVDA | Stock | 142.3007 | 142.7 | 142.3 | 142.6999 | 384548.0 |
| 2024-11-15 04:00:00 | AMZN | Stock | 210.8 | 210.8 | 209.78 | 209.97 | 17676.0 |
| 2024-11-15 05:00:00 | AMZN | Stock | 209.98 | 210.12 | 209.73 | 210.12 | 5613.0 |
> showing 50 of 60,954 rows — these rows as CSV