PREVIEW / stock_1hour / 2024-05-22
file: by_date/stock_1hour/2024/2024-05-22.parquet size: 1.3 MB rows: 59,148 symbols: 976
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-05-22 04:00:00 | AAPL | Stock | 192.42 | 192.42 | 192.01 | 192.01 | 12180.0 |
| 2024-05-22 05:00:00 | AAPL | Stock | 192.04 | 192.05 | 191.73 | 191.81 | 4767.0 |
| 2024-05-22 06:00:00 | AAPL | Stock | 191.9 | 191.9 | 191.73 | 191.77 | 1844.0 |
| 2024-05-22 07:00:00 | AAPL | Stock | 191.83 | 192.57 | 191.83 | 192.17 | 26149.0 |
| 2024-05-22 08:00:00 | AAPL | Stock | 191.87 | 192.59 | 191.8057 | 192.1 | 38656.0 |
| 2024-05-22 09:00:00 | AAPL | Stock | 192.08 | 192.79 | 191.95 | 192.47 | 3132502.0 |
| 2024-05-22 10:00:00 | AAPL | Stock | 192.44 | 192.8231 | 192.08 | 192.08 | 3150202.0 |
| 2024-05-22 11:00:00 | AAPL | Stock | 192.0801 | 192.3 | 191.66 | 191.829 | 3125482.0 |
| 2024-05-22 12:00:00 | AAPL | Stock | 191.83 | 191.87 | 191.155 | 191.3 | 2085123.0 |
| 2024-05-22 13:00:00 | AAPL | Stock | 191.3085 | 191.4829 | 190.72 | 190.855 | 2551140.0 |
| 2024-05-22 14:00:00 | AAPL | Stock | 190.85 | 190.8985 | 190.27 | 190.81 | 2763636.0 |
| 2024-05-22 15:00:00 | AAPL | Stock | 190.815 | 191.305 | 190.38 | 190.98 | 4696682.0 |
| 2024-05-22 16:00:00 | AAPL | Stock | 191.02 | 191.3 | 190.32 | 190.5 | 5667210.0 |
| 2024-05-22 17:00:00 | AAPL | Stock | 190.52 | 190.75 | 190.28 | 190.69 | 62645.0 |
| 2024-05-22 18:00:00 | AAPL | Stock | 190.69 | 190.9 | 190.5403 | 190.61 | 37405.0 |
| 2024-05-22 19:00:00 | AAPL | Stock | 190.61 | 190.69 | 190.36 | 190.46 | 23612.0 |
| 2024-05-22 04:00:00 | MSFT | Stock | 429.39 | 430.1 | 429.39 | 430.0 | 1315.0 |
| 2024-05-22 05:00:00 | MSFT | Stock | 430.51 | 430.55 | 430.4 | 430.4 | 633.0 |
| 2024-05-22 06:00:00 | MSFT | Stock | 430.28 | 430.3 | 429.97 | 430.0 | 3302.0 |
| 2024-05-22 07:00:00 | MSFT | Stock | 430.3 | 430.36 | 429.6 | 429.6 | 4110.0 |
| 2024-05-22 08:00:00 | MSFT | Stock | 430.29 | 430.5581 | 428.5 | 429.75 | 35805.0 |
| 2024-05-22 09:00:00 | MSFT | Stock | 429.7 | 432.2864 | 429.54 | 431.17 | 1354807.0 |
| 2024-05-22 10:00:00 | MSFT | Stock | 431.165 | 432.41 | 430.76 | 430.82 | 1161858.0 |
| 2024-05-22 11:00:00 | MSFT | Stock | 430.86 | 431.8286 | 430.07 | 430.5381 | 669385.0 |
| 2024-05-22 12:00:00 | MSFT | Stock | 430.525 | 431.095 | 429.39 | 429.7404 | 578112.0 |
| 2024-05-22 13:00:00 | MSFT | Stock | 429.8 | 430.7427 | 429.0201 | 429.6096 | 563371.0 |
| 2024-05-22 14:00:00 | MSFT | Stock | 429.57 | 429.57 | 427.602 | 428.11 | 842674.0 |
| 2024-05-22 15:00:00 | MSFT | Stock | 428.09 | 430.64 | 427.13 | 430.55 | 1843339.0 |
| 2024-05-22 16:00:00 | MSFT | Stock | 430.52 | 431.49 | 428.77 | 430.99 | 3242521.0 |
| 2024-05-22 17:00:00 | MSFT | Stock | 430.82 | 431.4 | 430.4941 | 431.3735 | 35155.0 |
| 2024-05-22 18:00:00 | MSFT | Stock | 431.17 | 431.49 | 430.81 | 430.82 | 15505.0 |
| 2024-05-22 19:00:00 | MSFT | Stock | 430.82 | 431.4 | 430.62 | 431.18 | 22178.0 |
| 2024-05-22 04:00:00 | NVDA | Stock | 95.371 | 95.386 | 95.065 | 95.065 | 129720.0 |
| 2024-05-22 05:00:00 | NVDA | Stock | 95.05 | 95.06 | 94.725 | 94.862 | 178920.0 |
| 2024-05-22 06:00:00 | NVDA | Stock | 94.857 | 95.067 | 94.825 | 95.025 | 125630.0 |
| 2024-05-22 07:00:00 | NVDA | Stock | 95.05 | 95.5 | 94.997 | 95.34 | 974930.0 |
| 2024-05-22 08:00:00 | NVDA | Stock | 95.1 | 95.9 | 94.9456 | 95.8245 | 2197630.0 |
| 2024-05-22 09:00:00 | NVDA | Stock | 95.8002 | 96.02 | 94.072 | 94.751 | 53302740.0 |
| 2024-05-22 10:00:00 | NVDA | Stock | 94.77 | 95.1809 | 94.301 | 94.8062 | 37258120.0 |
| 2024-05-22 11:00:00 | NVDA | Stock | 94.811 | 95.039 | 94.44 | 94.711 | 23399110.0 |
| 2024-05-22 12:00:00 | NVDA | Stock | 94.709 | 95.18 | 94.6171 | 94.875 | 25338630.0 |
| 2024-05-22 13:00:00 | NVDA | Stock | 94.881 | 95.013 | 93.65 | 94.057 | 34867620.0 |
| 2024-05-22 14:00:00 | NVDA | Stock | 94.041 | 94.398 | 93.249 | 93.9551 | 42848680.0 |
| 2024-05-22 15:00:00 | NVDA | Stock | 93.9525 | 94.96 | 93.49 | 94.87 | 54413190.0 |
| 2024-05-22 16:00:00 | NVDA | Stock | 94.95 | 99.792 | 91.9 | 98.725 | 52763380.0 |
| 2024-05-22 17:00:00 | NVDA | Stock | 98.775 | 102.344 | 94.95 | 100.842 | 29345990.0 |
| 2024-05-22 18:00:00 | NVDA | Stock | 100.842 | 101.1 | 99.8 | 100.798 | 6651170.0 |
| 2024-05-22 19:00:00 | NVDA | Stock | 100.743 | 100.8 | 100.4 | 100.7 | 2705730.0 |
| 2024-05-22 04:00:00 | AMZN | Stock | 183.15 | 183.15 | 182.9 | 182.9 | 2085.0 |
| 2024-05-22 05:00:00 | AMZN | Stock | 182.91 | 183.07 | 182.91 | 183.07 | 1350.0 |
> showing 50 of 59,148 rows — these rows as CSV