PREVIEW / stock_1hour / 2024-11-14
file: by_date/stock_1hour/2024/2024-11-14.parquet size: 1.4 MB rows: 62,394 symbols: 703
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-14 04:00:00 | AAPL | Stock | 224.85 | 224.85 | 224.18 | 224.22 | 12728.0 |
| 2024-11-14 05:00:00 | AAPL | Stock | 224.23 | 224.51 | 224.23 | 224.42 | 5945.0 |
| 2024-11-14 06:00:00 | AAPL | Stock | 224.51 | 224.88 | 224.42 | 224.6 | 10707.0 |
| 2024-11-14 07:00:00 | AAPL | Stock | 224.8 | 225.06 | 224.61 | 224.7 | 16142.0 |
| 2024-11-14 08:00:00 | AAPL | Stock | 225.0 | 225.0999 | 224.22 | 224.75 | 64629.0 |
| 2024-11-14 09:00:00 | AAPL | Stock | 224.75 | 226.48 | 224.51 | 225.7215 | 3379865.0 |
| 2024-11-14 10:00:00 | AAPL | Stock | 225.72 | 227.03 | 225.05 | 226.53 | 4141113.0 |
| 2024-11-14 11:00:00 | AAPL | Stock | 226.52 | 227.09 | 226.35 | 226.7401 | 2194876.0 |
| 2024-11-14 12:00:00 | AAPL | Stock | 226.75 | 228.23 | 226.5122 | 227.925 | 2901707.0 |
| 2024-11-14 13:00:00 | AAPL | Stock | 227.925 | 228.71 | 227.83 | 228.06 | 2440465.0 |
| 2024-11-14 14:00:00 | AAPL | Stock | 228.05 | 228.87 | 228.03 | 228.27 | 2315954.0 |
| 2024-11-14 15:00:00 | AAPL | Stock | 228.275 | 228.38 | 226.98 | 228.19 | 5034309.0 |
| 2024-11-14 16:00:00 | AAPL | Stock | 228.19 | 228.25 | 227.51 | 227.81 | 7858215.0 |
| 2024-11-14 17:00:00 | AAPL | Stock | 227.81 | 228.22 | 227.6044 | 227.8219 | 34740.0 |
| 2024-11-14 18:00:00 | AAPL | Stock | 227.71 | 227.78 | 227.5 | 227.5 | 20609.0 |
| 2024-11-14 19:00:00 | AAPL | Stock | 227.47 | 227.58 | 227.36 | 227.42 | 19743.0 |
| 2024-11-14 04:00:00 | MSFT | Stock | 425.22 | 425.51 | 424.5 | 424.8 | 2095.0 |
| 2024-11-14 05:00:00 | MSFT | Stock | 424.83 | 424.99 | 424.79 | 424.82 | 4046.0 |
| 2024-11-14 06:00:00 | MSFT | Stock | 425.03 | 425.12 | 424.82 | 424.99 | 3853.0 |
| 2024-11-14 07:00:00 | MSFT | Stock | 424.9 | 425.05 | 424.64 | 424.64 | 4785.0 |
| 2024-11-14 08:00:00 | MSFT | Stock | 424.79 | 425.09 | 423.7 | 424.29 | 17341.0 |
| 2024-11-14 09:00:00 | MSFT | Stock | 424.13 | 428.03 | 423.67 | 425.39 | 1688305.0 |
| 2024-11-14 10:00:00 | MSFT | Stock | 425.375 | 427.31 | 423.75 | 425.91 | 1366258.0 |
| 2024-11-14 11:00:00 | MSFT | Stock | 425.83 | 427.565 | 424.55 | 427.04 | 1331181.0 |
| 2024-11-14 12:00:00 | MSFT | Stock | 427.07 | 428.17 | 420.0 | 423.7323 | 2788167.0 |
| 2024-11-14 13:00:00 | MSFT | Stock | 423.59 | 427.26 | 422.175 | 426.14 | 1340744.0 |
| 2024-11-14 14:00:00 | MSFT | Stock | 426.12 | 427.7 | 426.08 | 427.635 | 763863.0 |
| 2024-11-14 15:00:00 | MSFT | Stock | 427.61 | 427.73 | 425.845 | 426.73 | 1767621.0 |
| 2024-11-14 16:00:00 | MSFT | Stock | 426.67 | 427.63 | 426.22 | 426.47 | 5410515.0 |
| 2024-11-14 17:00:00 | MSFT | Stock | 426.53 | 426.89 | 426.15 | 426.43 | 17942.0 |
| 2024-11-14 18:00:00 | MSFT | Stock | 426.18 | 426.25 | 425.7851 | 425.82 | 8039.0 |
| 2024-11-14 19:00:00 | MSFT | Stock | 425.94 | 426.2 | 425.94 | 426.2 | 7412.0 |
| 2024-11-14 04:00:00 | NVDA | Stock | 146.9 | 147.45 | 146.5 | 147.16 | 223386.0 |
| 2024-11-14 05:00:00 | NVDA | Stock | 147.16 | 147.64 | 147.13 | 147.35 | 221093.0 |
| 2024-11-14 06:00:00 | NVDA | Stock | 147.38 | 147.49 | 147.25 | 147.42 | 134477.0 |
| 2024-11-14 07:00:00 | NVDA | Stock | 147.41 | 147.73 | 147.12 | 147.57 | 665717.0 |
| 2024-11-14 08:00:00 | NVDA | Stock | 147.35 | 147.74 | 146.13 | 147.06 | 1841022.0 |
| 2024-11-14 09:00:00 | NVDA | Stock | 147.06 | 147.77 | 145.55 | 147.59 | 25012466.0 |
| 2024-11-14 10:00:00 | NVDA | Stock | 147.58 | 148.86 | 147.33 | 148.3563 | 32012225.0 |
| 2024-11-14 11:00:00 | NVDA | Stock | 148.3592 | 149.0 | 148.33 | 148.43 | 18475817.0 |
| 2024-11-14 12:00:00 | NVDA | Stock | 148.435 | 148.68 | 147.27 | 147.6779 | 16326841.0 |
| 2024-11-14 13:00:00 | NVDA | Stock | 147.67 | 147.8 | 146.53 | 146.615 | 12317514.0 |
| 2024-11-14 14:00:00 | NVDA | Stock | 146.615 | 147.22 | 146.47 | 146.895 | 12269680.0 |
| 2024-11-14 15:00:00 | NVDA | Stock | 146.8907 | 146.9 | 145.76 | 146.8 | 22623818.0 |
| 2024-11-14 16:00:00 | NVDA | Stock | 146.82 | 146.93 | 146.31 | 146.7 | 11832210.0 |
| 2024-11-14 17:00:00 | NVDA | Stock | 146.7 | 146.76 | 146.35 | 146.51 | 456744.0 |
| 2024-11-14 18:00:00 | NVDA | Stock | 146.49 | 146.5 | 146.22 | 146.4486 | 252922.0 |
| 2024-11-14 19:00:00 | NVDA | Stock | 146.45 | 146.52 | 146.2 | 146.3181 | 287131.0 |
| 2024-11-14 04:00:00 | AMZN | Stock | 214.13 | 215.26 | 214.1 | 214.94 | 14527.0 |
| 2024-11-14 05:00:00 | AMZN | Stock | 214.93 | 215.46 | 214.51 | 215.15 | 23341.0 |
> showing 50 of 62,394 rows — these rows as CSV