PREVIEW / stock_1hour / 2024-10-21
file: by_date/stock_1hour/2024/2024-10-21.parquet size: 1.4 MB rows: 61,127 symbols: 736
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-21 04:00:00 | AAPL | Stock | 234.8 | 234.8 | 233.75 | 234.4 | 18710.0 |
| 2024-10-21 05:00:00 | AAPL | Stock | 234.42 | 234.53 | 234.0 | 234.03 | 10266.0 |
| 2024-10-21 06:00:00 | AAPL | Stock | 234.02 | 234.25 | 233.3 | 233.52 | 21431.0 |
| 2024-10-21 07:00:00 | AAPL | Stock | 233.52 | 233.94 | 233.3 | 233.75 | 29427.0 |
| 2024-10-21 08:00:00 | AAPL | Stock | 233.79 | 234.87 | 233.4999 | 233.85 | 104349.0 |
| 2024-10-21 09:00:00 | AAPL | Stock | 233.85 | 235.5 | 233.5 | 235.1703 | 2965701.0 |
| 2024-10-21 10:00:00 | AAPL | Stock | 235.175 | 236.09 | 234.955 | 235.88 | 3226225.0 |
| 2024-10-21 11:00:00 | AAPL | Stock | 235.88 | 236.4591 | 235.17 | 236.24 | 2437637.0 |
| 2024-10-21 12:00:00 | AAPL | Stock | 236.23 | 236.61 | 235.94 | 236.51 | 1717975.0 |
| 2024-10-21 13:00:00 | AAPL | Stock | 236.51 | 236.85 | 236.2 | 236.67 | 1468109.0 |
| 2024-10-21 14:00:00 | AAPL | Stock | 236.69 | 236.81 | 235.93 | 235.985 | 1464175.0 |
| 2024-10-21 15:00:00 | AAPL | Stock | 235.99 | 236.58 | 235.8275 | 236.58 | 3018367.0 |
| 2024-10-21 16:00:00 | AAPL | Stock | 236.46 | 236.81 | 236.2 | 236.55 | 6454283.0 |
| 2024-10-21 17:00:00 | AAPL | Stock | 236.57 | 236.62 | 236.48 | 236.6 | 173069.0 |
| 2024-10-21 18:00:00 | AAPL | Stock | 236.6 | 236.61 | 236.49 | 236.49 | 10024.0 |
| 2024-10-21 19:00:00 | AAPL | Stock | 236.56 | 236.6 | 236.24 | 236.57 | 13667.0 |
| 2024-10-21 04:00:00 | MSFT | Stock | 417.5 | 417.69 | 417.37 | 417.48 | 2367.0 |
| 2024-10-21 05:00:00 | MSFT | Stock | 417.48 | 417.48 | 416.6 | 416.86 | 5759.0 |
| 2024-10-21 06:00:00 | MSFT | Stock | 416.91 | 417.13 | 416.5 | 416.52 | 2040.0 |
| 2024-10-21 07:00:00 | MSFT | Stock | 416.71 | 416.71 | 415.95 | 416.26 | 8981.0 |
| 2024-10-21 08:00:00 | MSFT | Stock | 416.7 | 418.53 | 415.8 | 417.05 | 34674.0 |
| 2024-10-21 09:00:00 | MSFT | Stock | 416.95 | 418.1 | 415.4 | 416.88 | 1112548.0 |
| 2024-10-21 10:00:00 | MSFT | Stock | 416.905 | 417.79 | 414.58 | 415.0 | 1257672.0 |
| 2024-10-21 11:00:00 | MSFT | Stock | 415.005 | 415.43 | 413.7501 | 415.11 | 916562.0 |
| 2024-10-21 12:00:00 | MSFT | Stock | 415.1 | 416.25 | 414.66 | 415.8432 | 500594.0 |
| 2024-10-21 13:00:00 | MSFT | Stock | 415.83 | 416.855 | 415.721 | 416.8 | 477922.0 |
| 2024-10-21 14:00:00 | MSFT | Stock | 416.85 | 417.3343 | 416.62 | 416.92 | 466977.0 |
| 2024-10-21 15:00:00 | MSFT | Stock | 416.965 | 418.96 | 416.75 | 418.8 | 1194646.0 |
| 2024-10-21 16:00:00 | MSFT | Stock | 418.78 | 419.6 | 418.77 | 419.07 | 2858771.0 |
| 2024-10-21 17:00:00 | MSFT | Stock | 419.0 | 419.03 | 418.78 | 419.0063 | 28517.0 |
| 2024-10-21 18:00:00 | MSFT | Stock | 418.9 | 419.16 | 418.7 | 418.7 | 3129.0 |
| 2024-10-21 19:00:00 | MSFT | Stock | 418.79 | 418.8 | 418.51 | 418.73 | 4286.0 |
| 2024-10-21 04:00:00 | NVDA | Stock | 138.43 | 138.86 | 137.5 | 138.74 | 286019.0 |
| 2024-10-21 05:00:00 | NVDA | Stock | 138.73 | 138.75 | 138.15 | 138.27 | 184818.0 |
| 2024-10-21 06:00:00 | NVDA | Stock | 138.22 | 138.77 | 137.95 | 138.04 | 315899.0 |
| 2024-10-21 07:00:00 | NVDA | Stock | 138.05 | 138.19 | 136.74 | 137.09 | 1238416.0 |
| 2024-10-21 08:00:00 | NVDA | Stock | 138.02 | 138.7836 | 136.8908 | 137.64 | 1942854.0 |
| 2024-10-21 09:00:00 | NVDA | Stock | 137.65 | 141.49 | 137.63 | 141.1739 | 45425052.0 |
| 2024-10-21 10:00:00 | NVDA | Stock | 141.185 | 141.8 | 139.94 | 140.8292 | 41637483.0 |
| 2024-10-21 11:00:00 | NVDA | Stock | 140.83 | 141.355 | 140.0 | 141.28 | 25234177.0 |
| 2024-10-21 12:00:00 | NVDA | Stock | 141.27 | 141.55 | 140.685 | 141.26 | 15947271.0 |
| 2024-10-21 13:00:00 | NVDA | Stock | 141.255 | 142.44 | 141.18 | 142.307 | 24717714.0 |
| 2024-10-21 14:00:00 | NVDA | Stock | 142.3 | 142.46 | 141.78 | 142.0642 | 18256636.0 |
| 2024-10-21 15:00:00 | NVDA | Stock | 142.07 | 143.71 | 141.8 | 143.7 | 36701681.0 |
| 2024-10-21 16:00:00 | NVDA | Stock | 143.7 | 144.4 | 141.2432 | 144.19 | 22263833.0 |
| 2024-10-21 17:00:00 | NVDA | Stock | 144.1903 | 144.25 | 143.71 | 144.22 | 794791.0 |
| 2024-10-21 18:00:00 | NVDA | Stock | 144.21 | 144.3 | 144.05 | 144.12 | 593931.0 |
| 2024-10-21 19:00:00 | NVDA | Stock | 144.12 | 144.5 | 144.01 | 144.4999 | 1020596.0 |
| 2024-10-21 04:00:00 | AMZN | Stock | 188.6 | 188.6 | 188.3 | 188.45 | 4424.0 |
| 2024-10-21 05:00:00 | AMZN | Stock | 188.44 | 188.5 | 188.32 | 188.4 | 14240.0 |
> showing 50 of 61,127 rows — these rows as CSV