PREVIEW / stock_1hour / 2024-10-31
file: by_date/stock_1hour/2024/2024-10-31.parquet size: 1.4 MB rows: 60,216 symbols: 735
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-10-31 04:00:00 | AAPL | Stock | 230.13 | 230.78 | 229.18 | 229.67 | 17552.0 |
| 2024-10-31 05:00:00 | AAPL | Stock | 229.6 | 229.6 | 229.23 | 229.23 | 7616.0 |
| 2024-10-31 06:00:00 | AAPL | Stock | 229.26 | 229.57 | 229.24 | 229.55 | 7254.0 |
| 2024-10-31 07:00:00 | AAPL | Stock | 229.56 | 229.8 | 229.25 | 229.73 | 38316.0 |
| 2024-10-31 08:00:00 | AAPL | Stock | 229.57 | 230.92 | 229.2 | 229.92 | 161007.0 |
| 2024-10-31 09:00:00 | AAPL | Stock | 229.88 | 229.92 | 228.1994 | 229.2082 | 3806115.0 |
| 2024-10-31 10:00:00 | AAPL | Stock | 229.2 | 229.26 | 227.41 | 227.71 | 3878126.0 |
| 2024-10-31 11:00:00 | AAPL | Stock | 227.68 | 227.76 | 226.4 | 227.055 | 3755960.0 |
| 2024-10-31 12:00:00 | AAPL | Stock | 227.03 | 227.99 | 226.89 | 227.73 | 2582303.0 |
| 2024-10-31 13:00:00 | AAPL | Stock | 227.735 | 228.18 | 226.88 | 226.9 | 2960617.0 |
| 2024-10-31 14:00:00 | AAPL | Stock | 226.9 | 227.25 | 226.695 | 227.07 | 2846775.0 |
| 2024-10-31 15:00:00 | AAPL | Stock | 227.08 | 227.78 | 225.37 | 225.39 | 7738522.0 |
| 2024-10-31 16:00:00 | AAPL | Stock | 225.39 | 229.88 | 220.5 | 223.5 | 16898792.0 |
| 2024-10-31 17:00:00 | AAPL | Stock | 223.49 | 225.91 | 220.0 | 221.26 | 1988188.0 |
| 2024-10-31 18:00:00 | AAPL | Stock | 221.395 | 222.9 | 220.8 | 222.4 | 290690.0 |
| 2024-10-31 19:00:00 | AAPL | Stock | 222.4 | 222.61 | 221.61 | 221.71 | 117300.0 |
| 2024-10-31 04:00:00 | MSFT | Stock | 414.6 | 418.25 | 413.42 | 416.5 | 84006.0 |
| 2024-10-31 05:00:00 | MSFT | Stock | 416.5 | 417.9 | 415.35 | 415.35 | 25705.0 |
| 2024-10-31 06:00:00 | MSFT | Stock | 415.5 | 417.44 | 415.02 | 416.09 | 49917.0 |
| 2024-10-31 07:00:00 | MSFT | Stock | 416.35 | 418.68 | 415.23 | 418.68 | 146909.0 |
| 2024-10-31 08:00:00 | MSFT | Stock | 416.74 | 419.7 | 413.0 | 415.99 | 436539.0 |
| 2024-10-31 09:00:00 | MSFT | Stock | 416.0 | 418.0 | 408.24 | 410.83 | 7755473.0 |
| 2024-10-31 10:00:00 | MSFT | Stock | 410.82 | 412.28 | 406.3 | 407.67 | 5401942.0 |
| 2024-10-31 11:00:00 | MSFT | Stock | 407.71 | 409.15 | 406.55 | 408.468 | 2991226.0 |
| 2024-10-31 12:00:00 | MSFT | Stock | 408.44 | 410.9 | 408.0 | 409.62 | 3023830.0 |
| 2024-10-31 13:00:00 | MSFT | Stock | 409.62 | 409.95 | 408.01 | 408.105 | 1711164.0 |
| 2024-10-31 14:00:00 | MSFT | Stock | 408.12 | 409.7214 | 407.85 | 408.91 | 1914839.0 |
| 2024-10-31 15:00:00 | MSFT | Stock | 408.96 | 411.22 | 406.3 | 406.31 | 4744065.0 |
| 2024-10-31 16:00:00 | MSFT | Stock | 406.37 | 408.3626 | 406.3 | 408.2 | 8454462.0 |
| 2024-10-31 17:00:00 | MSFT | Stock | 408.3 | 409.8 | 408.0 | 409.8 | 43202.0 |
| 2024-10-31 18:00:00 | MSFT | Stock | 409.7913 | 409.88 | 409.35 | 409.5 | 30791.0 |
| 2024-10-31 19:00:00 | MSFT | Stock | 409.5 | 409.5 | 408.2077 | 408.9661 | 28404.0 |
| 2024-10-31 04:00:00 | NVDA | Stock | 136.4 | 137.51 | 136.35 | 137.37 | 498666.0 |
| 2024-10-31 05:00:00 | NVDA | Stock | 137.31 | 137.45 | 137.18 | 137.28 | 130271.0 |
| 2024-10-31 06:00:00 | NVDA | Stock | 137.29 | 137.4 | 137.04 | 137.36 | 159345.0 |
| 2024-10-31 07:00:00 | NVDA | Stock | 137.37 | 138.33 | 137.1 | 138.2 | 740365.0 |
| 2024-10-31 08:00:00 | NVDA | Stock | 137.31 | 138.987 | 136.0 | 137.58 | 1781251.0 |
| 2024-10-31 09:00:00 | NVDA | Stock | 137.57 | 137.79 | 132.7 | 132.9808 | 42180145.0 |
| 2024-10-31 10:00:00 | NVDA | Stock | 132.98 | 134.75 | 132.3701 | 133.31 | 42029326.0 |
| 2024-10-31 11:00:00 | NVDA | Stock | 133.305 | 133.99 | 132.3 | 133.1579 | 26213403.0 |
| 2024-10-31 12:00:00 | NVDA | Stock | 133.1507 | 133.7099 | 132.79 | 133.3209 | 16040166.0 |
| 2024-10-31 13:00:00 | NVDA | Stock | 133.3295 | 133.84 | 132.79 | 132.97 | 14169300.0 |
| 2024-10-31 14:00:00 | NVDA | Stock | 132.97 | 133.09 | 132.1106 | 132.7301 | 17823409.0 |
| 2024-10-31 15:00:00 | NVDA | Stock | 132.73 | 134.71 | 132.41 | 132.57 | 36511315.0 |
| 2024-10-31 16:00:00 | NVDA | Stock | 132.55 | 133.63 | 132.37 | 133.2282 | 32307660.0 |
| 2024-10-31 17:00:00 | NVDA | Stock | 133.2 | 134.55 | 133.2 | 134.4 | 1179028.0 |
| 2024-10-31 18:00:00 | NVDA | Stock | 134.3901 | 134.48 | 134.1 | 134.14 | 537836.0 |
| 2024-10-31 19:00:00 | NVDA | Stock | 134.2 | 134.42 | 134.12 | 134.4101 | 375455.0 |
| 2024-10-31 04:00:00 | AMZN | Stock | 189.79 | 190.93 | 189.79 | 190.49 | 41403.0 |
| 2024-10-31 05:00:00 | AMZN | Stock | 190.31 | 190.74 | 190.14 | 190.55 | 9455.0 |
> showing 50 of 60,216 rows — these rows as CSV