PREVIEW / stock_1hour / 2024-04-19
file: by_date/stock_1hour/2024/2024-04-19.parquet size: 1.3 MB rows: 58,007 symbols: 992
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-04-19 04:00:00 | AAPL | Stock | 165.18 | 166.7 | 164.72 | 166.24 | 33744.0 |
| 2024-04-19 05:00:00 | AAPL | Stock | 166.29 | 166.71 | 166.29 | 166.5 | 7143.0 |
| 2024-04-19 06:00:00 | AAPL | Stock | 166.42 | 167.88 | 166.42 | 167.19 | 36514.0 |
| 2024-04-19 07:00:00 | AAPL | Stock | 167.02 | 167.29 | 166.9 | 167.04 | 36124.0 |
| 2024-04-19 08:00:00 | AAPL | Stock | 166.9 | 167.41 | 165.24 | 166.86 | 112196.0 |
| 2024-04-19 09:00:00 | AAPL | Stock | 166.86 | 167.0 | 165.22 | 165.3663 | 8639768.0 |
| 2024-04-19 10:00:00 | AAPL | Stock | 165.365 | 165.66 | 164.82 | 165.61 | 7482856.0 |
| 2024-04-19 11:00:00 | AAPL | Stock | 165.565 | 165.61 | 164.35 | 164.375 | 4923292.0 |
| 2024-04-19 12:00:00 | AAPL | Stock | 164.37 | 165.3 | 164.075 | 165.2088 | 5787602.0 |
| 2024-04-19 13:00:00 | AAPL | Stock | 165.2 | 165.4996 | 164.84 | 165.25 | 3853497.0 |
| 2024-04-19 14:00:00 | AAPL | Stock | 165.25 | 165.67 | 164.52 | 164.965 | 4781175.0 |
| 2024-04-19 15:00:00 | AAPL | Stock | 164.96 | 165.24 | 164.79 | 164.93 | 8663422.0 |
| 2024-04-19 16:00:00 | AAPL | Stock | 165.0 | 165.1 | 164.8 | 164.98 | 11013945.0 |
| 2024-04-19 17:00:00 | AAPL | Stock | 164.99 | 165.0 | 164.8 | 164.8206 | 31348.0 |
| 2024-04-19 18:00:00 | AAPL | Stock | 164.85 | 165.0 | 164.57 | 164.65 | 29944.0 |
| 2024-04-19 19:00:00 | AAPL | Stock | 164.66 | 164.67 | 164.32 | 164.4 | 26758.0 |
| 2024-04-19 04:00:00 | MSFT | Stock | 400.98 | 403.04 | 400.98 | 402.15 | 12265.0 |
| 2024-04-19 05:00:00 | MSFT | Stock | 402.01 | 403.0 | 401.9 | 402.68 | 4496.0 |
| 2024-04-19 06:00:00 | MSFT | Stock | 402.68 | 402.7 | 401.6 | 402.15 | 6136.0 |
| 2024-04-19 07:00:00 | MSFT | Stock | 402.65 | 403.76 | 401.86 | 403.44 | 18281.0 |
| 2024-04-19 08:00:00 | MSFT | Stock | 402.2 | 405.35 | 396.0 | 405.1992 | 45760.0 |
| 2024-04-19 09:00:00 | MSFT | Stock | 405.15 | 405.48 | 402.15 | 402.34 | 2666658.0 |
| 2024-04-19 10:00:00 | MSFT | Stock | 402.315 | 403.055 | 399.39 | 402.38 | 1994938.0 |
| 2024-04-19 11:00:00 | MSFT | Stock | 402.3 | 402.81 | 400.41 | 400.47 | 956709.0 |
| 2024-04-19 12:00:00 | MSFT | Stock | 400.45 | 401.14 | 398.061 | 399.79 | 1399854.0 |
| 2024-04-19 13:00:00 | MSFT | Stock | 399.75 | 402.15 | 399.07 | 401.12 | 886730.0 |
| 2024-04-19 14:00:00 | MSFT | Stock | 401.12 | 401.455 | 398.44 | 399.5 | 1161079.0 |
| 2024-04-19 15:00:00 | MSFT | Stock | 399.46 | 399.86 | 397.77 | 399.11 | 2638693.0 |
| 2024-04-19 16:00:00 | MSFT | Stock | 399.12 | 399.27 | 397.85 | 398.05 | 4366896.0 |
| 2024-04-19 17:00:00 | MSFT | Stock | 397.9 | 398.0548 | 397.15 | 397.3 | 12407.0 |
| 2024-04-19 18:00:00 | MSFT | Stock | 397.39 | 399.12 | 397.08 | 397.32 | 86375.0 |
| 2024-04-19 19:00:00 | MSFT | Stock | 397.2 | 397.55 | 397.0 | 397.0 | 8153.0 |
| 2024-04-19 04:00:00 | NVDA | Stock | 83.222 | 84.0 | 82.8 | 83.75 | 555340.0 |
| 2024-04-19 05:00:00 | NVDA | Stock | 83.71 | 84.0 | 83.673 | 83.86 | 72010.0 |
| 2024-04-19 06:00:00 | NVDA | Stock | 83.88 | 84.165 | 83.805 | 84.039 | 131260.0 |
| 2024-04-19 07:00:00 | NVDA | Stock | 84.0 | 85.046 | 83.735 | 85.046 | 1281340.0 |
| 2024-04-19 08:00:00 | NVDA | Stock | 84.05 | 85.05 | 82.2 | 84.561 | 2344960.0 |
| 2024-04-19 09:00:00 | NVDA | Stock | 84.58 | 84.672 | 83.027 | 83.908 | 54334890.0 |
| 2024-04-19 10:00:00 | NVDA | Stock | 83.911 | 84.011 | 81.28 | 82.368 | 87953880.0 |
| 2024-04-19 11:00:00 | NVDA | Stock | 82.352 | 82.565 | 81.268 | 81.3494 | 46535900.0 |
| 2024-04-19 12:00:00 | NVDA | Stock | 81.338 | 81.597 | 80.208 | 81.0717 | 66102840.0 |
| 2024-04-19 13:00:00 | NVDA | Stock | 81.071 | 81.409 | 79.3 | 79.564 | 60561110.0 |
| 2024-04-19 14:00:00 | NVDA | Stock | 79.566 | 79.693 | 76.666 | 77.121 | 129487830.0 |
| 2024-04-19 15:00:00 | NVDA | Stock | 77.114 | 77.598 | 75.606 | 76.215 | 136331220.0 |
| 2024-04-19 16:00:00 | NVDA | Stock | 76.175 | 76.794 | 75.632 | 76.65 | 31917080.0 |
| 2024-04-19 17:00:00 | NVDA | Stock | 76.649 | 76.72 | 76.0 | 76.0725 | 1263880.0 |
| 2024-04-19 18:00:00 | NVDA | Stock | 76.1 | 76.374 | 76.06 | 76.15 | 784540.0 |
| 2024-04-19 19:00:00 | NVDA | Stock | 76.138 | 76.198 | 75.82 | 75.964 | 1109690.0 |
| 2024-04-19 04:00:00 | AMZN | Stock | 177.0 | 177.9 | 175.91 | 177.5 | 38399.0 |
| 2024-04-19 05:00:00 | AMZN | Stock | 177.46 | 178.22 | 177.46 | 178.22 | 9318.0 |
> showing 50 of 58,007 rows — these rows as CSV