PREVIEW / stock_1hour / 2024-11-20
file: by_date/stock_1hour/2024/2024-11-20.parquet size: 1.4 MB rows: 61,228 symbols: 702
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-20 04:00:00 | AAPL | Stock | 227.83 | 228.25 | 227.76 | 227.76 | 10363.0 |
| 2024-11-20 05:00:00 | AAPL | Stock | 227.79 | 228.01 | 227.5 | 227.63 | 4661.0 |
| 2024-11-20 06:00:00 | AAPL | Stock | 227.78 | 227.85 | 227.64 | 227.71 | 7997.0 |
| 2024-11-20 07:00:00 | AAPL | Stock | 227.76 | 228.47 | 227.76 | 228.47 | 27738.0 |
| 2024-11-20 08:00:00 | AAPL | Stock | 227.88 | 228.71 | 227.66 | 228.18 | 72486.0 |
| 2024-11-20 09:00:00 | AAPL | Stock | 228.1 | 229.93 | 227.37 | 227.63 | 3401589.0 |
| 2024-11-20 10:00:00 | AAPL | Stock | 227.63 | 228.02 | 226.36 | 226.94 | 2855068.0 |
| 2024-11-20 11:00:00 | AAPL | Stock | 226.95 | 227.7 | 225.89 | 227.48 | 2437991.0 |
| 2024-11-20 12:00:00 | AAPL | Stock | 227.47 | 227.59 | 226.59 | 226.89 | 1279674.0 |
| 2024-11-20 13:00:00 | AAPL | Stock | 226.88 | 227.14 | 226.38 | 226.9163 | 1235400.0 |
| 2024-11-20 14:00:00 | AAPL | Stock | 226.91 | 227.46 | 226.61 | 227.4 | 1169670.0 |
| 2024-11-20 15:00:00 | AAPL | Stock | 227.4 | 229.0 | 227.22 | 229.0 | 3908938.0 |
| 2024-11-20 16:00:00 | AAPL | Stock | 229.0 | 229.15 | 228.0 | 228.94 | 7779976.0 |
| 2024-11-20 17:00:00 | AAPL | Stock | 228.85 | 228.86 | 228.32 | 228.55 | 22198.0 |
| 2024-11-20 18:00:00 | AAPL | Stock | 228.3297 | 228.8299 | 228.1348 | 228.71 | 26052.0 |
| 2024-11-20 19:00:00 | AAPL | Stock | 228.67 | 228.79 | 228.24 | 228.24 | 30289.0 |
| 2024-11-20 04:00:00 | MSFT | Stock | 418.06 | 418.77 | 417.99 | 418.49 | 3765.0 |
| 2024-11-20 05:00:00 | MSFT | Stock | 418.4 | 419.0 | 418.28 | 418.85 | 3482.0 |
| 2024-11-20 06:00:00 | MSFT | Stock | 419.03 | 420.8 | 419.03 | 420.8 | 8063.0 |
| 2024-11-20 07:00:00 | MSFT | Stock | 420.45 | 420.45 | 419.6 | 420.0 | 11119.0 |
| 2024-11-20 08:00:00 | MSFT | Stock | 419.6 | 420.32 | 418.0 | 419.3527 | 35282.0 |
| 2024-11-20 09:00:00 | MSFT | Stock | 419.55 | 419.55 | 412.88 | 413.295 | 1258173.0 |
| 2024-11-20 10:00:00 | MSFT | Stock | 413.3104 | 413.8899 | 410.58 | 413.11 | 1520894.0 |
| 2024-11-20 11:00:00 | MSFT | Stock | 413.125 | 416.23 | 412.35 | 415.68 | 790707.0 |
| 2024-11-20 12:00:00 | MSFT | Stock | 415.68 | 415.96 | 413.29 | 413.92 | 479511.0 |
| 2024-11-20 13:00:00 | MSFT | Stock | 413.9186 | 414.39 | 413.1903 | 414.195 | 506485.0 |
| 2024-11-20 14:00:00 | MSFT | Stock | 414.14 | 414.16 | 413.04 | 413.85 | 616491.0 |
| 2024-11-20 15:00:00 | MSFT | Stock | 413.8 | 416.28 | 413.31 | 415.37 | 1532240.0 |
| 2024-11-20 16:00:00 | MSFT | Stock | 415.49 | 416.4 | 414.5206 | 416.0 | 4468583.0 |
| 2024-11-20 17:00:00 | MSFT | Stock | 416.1199 | 417.0 | 415.49 | 416.36 | 46254.0 |
| 2024-11-20 18:00:00 | MSFT | Stock | 416.0 | 416.75 | 415.01 | 416.5 | 9638.0 |
| 2024-11-20 19:00:00 | MSFT | Stock | 416.1 | 416.428 | 415.0 | 415.0 | 6170.0 |
| 2024-11-20 04:00:00 | NVDA | Stock | 147.7 | 147.92 | 146.35 | 146.8 | 580659.0 |
| 2024-11-20 05:00:00 | NVDA | Stock | 146.72 | 147.43 | 146.47 | 147.31 | 296779.0 |
| 2024-11-20 06:00:00 | NVDA | Stock | 147.31 | 147.5 | 147.08 | 147.47 | 271851.0 |
| 2024-11-20 07:00:00 | NVDA | Stock | 147.48 | 148.08 | 147.22 | 147.88 | 1438026.0 |
| 2024-11-20 08:00:00 | NVDA | Stock | 147.49 | 148.0798 | 146.5095 | 147.72 | 2361425.0 |
| 2024-11-20 09:00:00 | NVDA | Stock | 147.72 | 147.78 | 144.15 | 144.17 | 34208334.0 |
| 2024-11-20 10:00:00 | NVDA | Stock | 144.17 | 146.0221 | 142.73 | 145.85 | 40551462.0 |
| 2024-11-20 11:00:00 | NVDA | Stock | 145.85 | 146.59 | 144.2 | 145.715 | 29721174.0 |
| 2024-11-20 12:00:00 | NVDA | Stock | 145.7 | 145.9401 | 144.5 | 144.8262 | 18465715.0 |
| 2024-11-20 13:00:00 | NVDA | Stock | 144.83 | 145.13 | 144.08 | 144.4199 | 15346535.0 |
| 2024-11-20 14:00:00 | NVDA | Stock | 144.4 | 144.57 | 143.24 | 144.3 | 21337254.0 |
| 2024-11-20 15:00:00 | NVDA | Stock | 144.3036 | 146.16 | 143.88 | 145.93 | 36954959.0 |
| 2024-11-20 16:00:00 | NVDA | Stock | 145.92 | 146.3 | 137.92 | 144.94 | 43701351.0 |
| 2024-11-20 17:00:00 | NVDA | Stock | 144.93 | 145.86 | 142.39 | 144.1 | 11965209.0 |
| 2024-11-20 18:00:00 | NVDA | Stock | 144.1 | 144.51 | 143.3 | 143.55 | 3175119.0 |
| 2024-11-20 19:00:00 | NVDA | Stock | 143.52 | 143.58 | 142.13 | 142.2014 | 2209990.0 |
| 2024-11-20 04:00:00 | AMZN | Stock | 205.0 | 205.0 | 204.26 | 204.4 | 14453.0 |
| 2024-11-20 05:00:00 | AMZN | Stock | 204.4 | 204.55 | 204.3 | 204.43 | 5020.0 |
> showing 50 of 61,228 rows — these rows as CSV