PREVIEW / stock_1hour / 2024-12-03
file: by_date/stock_1hour/2024/2024-12-03.parquet size: 1.4 MB rows: 62,309 symbols: 692
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-12-03 04:00:00 | AAPL | Stock | 240.0 | 240.02 | 239.8 | 239.98 | 15218.0 |
| 2024-12-03 05:00:00 | AAPL | Stock | 239.97 | 240.11 | 239.81 | 239.81 | 6022.0 |
| 2024-12-03 06:00:00 | AAPL | Stock | 239.8 | 240.13 | 239.72 | 240.13 | 7477.0 |
| 2024-12-03 07:00:00 | AAPL | Stock | 240.15 | 240.19 | 239.96 | 240.15 | 14391.0 |
| 2024-12-03 08:00:00 | AAPL | Stock | 240.04 | 240.35 | 238.992 | 240.1795 | 78145.0 |
| 2024-12-03 09:00:00 | AAPL | Stock | 240.15 | 240.92 | 238.9 | 240.89 | 3792372.0 |
| 2024-12-03 10:00:00 | AAPL | Stock | 240.86 | 241.3699 | 240.36 | 241.1905 | 4006183.0 |
| 2024-12-03 11:00:00 | AAPL | Stock | 241.19 | 241.54 | 240.81 | 241.41 | 2657026.0 |
| 2024-12-03 12:00:00 | AAPL | Stock | 241.41 | 241.7 | 241.14 | 241.6686 | 1912826.0 |
| 2024-12-03 13:00:00 | AAPL | Stock | 241.6601 | 241.8255 | 241.32 | 241.725 | 1756189.0 |
| 2024-12-03 14:00:00 | AAPL | Stock | 241.725 | 242.46 | 241.67 | 242.38 | 3038223.0 |
| 2024-12-03 15:00:00 | AAPL | Stock | 242.38 | 242.76 | 241.84 | 242.63 | 4154142.0 |
| 2024-12-03 16:00:00 | AAPL | Stock | 242.65 | 242.96 | 242.4 | 242.85 | 6845930.0 |
| 2024-12-03 17:00:00 | AAPL | Stock | 242.88 | 242.9 | 242.69 | 242.81 | 13726.0 |
| 2024-12-03 18:00:00 | AAPL | Stock | 242.8 | 243.0 | 242.65 | 242.8007 | 21892.0 |
| 2024-12-03 19:00:00 | AAPL | Stock | 242.8166 | 243.0 | 242.73 | 243.0 | 17374.0 |
| 2024-12-03 04:00:00 | MSFT | Stock | 431.2 | 431.72 | 431.0 | 431.31 | 3499.0 |
| 2024-12-03 05:00:00 | MSFT | Stock | 431.02 | 431.02 | 431.02 | 431.02 | 220.0 |
| 2024-12-03 06:00:00 | MSFT | Stock | 431.0 | 431.0 | 429.55 | 429.55 | 2873.0 |
| 2024-12-03 07:00:00 | MSFT | Stock | 430.38 | 430.45 | 429.64 | 429.64 | 6559.0 |
| 2024-12-03 08:00:00 | MSFT | Stock | 430.4 | 431.2 | 429.3192 | 429.35 | 28793.0 |
| 2024-12-03 09:00:00 | MSFT | Stock | 429.51 | 431.37 | 428.5 | 431.2161 | 1361923.0 |
| 2024-12-03 10:00:00 | MSFT | Stock | 431.275 | 432.47 | 429.51 | 430.74 | 1169719.0 |
| 2024-12-03 11:00:00 | MSFT | Stock | 430.715 | 431.9899 | 430.11 | 430.58 | 771839.0 |
| 2024-12-03 12:00:00 | MSFT | Stock | 430.53 | 430.88 | 429.5806 | 430.38 | 606267.0 |
| 2024-12-03 13:00:00 | MSFT | Stock | 430.34 | 430.69 | 429.59 | 430.09 | 553798.0 |
| 2024-12-03 14:00:00 | MSFT | Stock | 430.075 | 430.5 | 427.74 | 430.19 | 955157.0 |
| 2024-12-03 15:00:00 | MSFT | Stock | 430.18 | 431.5 | 430.03 | 431.14 | 1402595.0 |
| 2024-12-03 16:00:00 | MSFT | Stock | 431.2 | 432.15 | 430.861 | 432.0 | 3287313.0 |
| 2024-12-03 17:00:00 | MSFT | Stock | 432.0 | 432.05 | 431.8 | 431.91 | 2795.0 |
| 2024-12-03 18:00:00 | MSFT | Stock | 431.86 | 432.35 | 431.55 | 431.837 | 6764.0 |
| 2024-12-03 19:00:00 | MSFT | Stock | 431.8 | 432.06 | 431.51 | 431.6 | 6740.0 |
| 2024-12-03 04:00:00 | NVDA | Stock | 138.4 | 138.79 | 138.17 | 138.45 | 193614.0 |
| 2024-12-03 05:00:00 | NVDA | Stock | 138.43 | 138.68 | 138.27 | 138.34 | 125737.0 |
| 2024-12-03 06:00:00 | NVDA | Stock | 138.34 | 138.68 | 138.25 | 138.6 | 127358.0 |
| 2024-12-03 07:00:00 | NVDA | Stock | 138.6 | 138.93 | 138.3 | 138.83 | 389779.0 |
| 2024-12-03 08:00:00 | NVDA | Stock | 138.52 | 139.12 | 138.13 | 138.68 | 1145981.0 |
| 2024-12-03 09:00:00 | NVDA | Stock | 138.69 | 140.54 | 137.8 | 139.4899 | 24412922.0 |
| 2024-12-03 10:00:00 | NVDA | Stock | 139.49 | 139.54 | 138.1 | 138.7501 | 22488742.0 |
| 2024-12-03 11:00:00 | NVDA | Stock | 138.75 | 139.45 | 138.57 | 138.6809 | 14759908.0 |
| 2024-12-03 12:00:00 | NVDA | Stock | 138.69 | 139.16 | 138.495 | 139.0902 | 10416446.0 |
| 2024-12-03 13:00:00 | NVDA | Stock | 139.1 | 139.44 | 138.92 | 139.2252 | 9484429.0 |
| 2024-12-03 14:00:00 | NVDA | Stock | 139.22 | 139.86 | 139.06 | 139.815 | 9764506.0 |
| 2024-12-03 15:00:00 | NVDA | Stock | 139.81 | 140.28 | 139.72 | 140.25 | 19577894.0 |
| 2024-12-03 16:00:00 | NVDA | Stock | 140.26 | 140.77 | 139.7172 | 140.51 | 19286471.0 |
| 2024-12-03 17:00:00 | NVDA | Stock | 140.51 | 140.6311 | 140.41 | 140.56 | 317984.0 |
| 2024-12-03 18:00:00 | NVDA | Stock | 140.54 | 140.73 | 140.41 | 140.7 | 291632.0 |
| 2024-12-03 19:00:00 | NVDA | Stock | 140.72 | 140.8398 | 140.61 | 140.77 | 318072.0 |
| 2024-12-03 04:00:00 | AMZN | Stock | 211.05 | 211.1 | 210.76 | 210.9 | 5534.0 |
| 2024-12-03 05:00:00 | AMZN | Stock | 210.9 | 211.17 | 210.88 | 210.9 | 5966.0 |
> showing 50 of 62,309 rows — these rows as CSV