PREVIEW / stock_1hour / 2024-03-18
file: by_date/stock_1hour/2024/2024-03-18.parquet size: 1.4 MB rows: 60,778 symbols: 1,086
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-03-18 04:00:00 | AAPL | Stock | 173.4 | 174.0 | 173.27 | 173.75 | 28968.0 |
| 2024-03-18 05:00:00 | AAPL | Stock | 173.73 | 173.97 | 173.15 | 173.51 | 18246.0 |
| 2024-03-18 06:00:00 | AAPL | Stock | 173.27 | 173.86 | 173.03 | 173.11 | 37428.0 |
| 2024-03-18 07:00:00 | AAPL | Stock | 173.11 | 174.8 | 172.41 | 174.64 | 214482.0 |
| 2024-03-18 08:00:00 | AAPL | Stock | 173.1 | 175.19 | 172.41 | 174.68 | 575368.0 |
| 2024-03-18 09:00:00 | AAPL | Stock | 174.53 | 177.58 | 174.27 | 176.758 | 12964811.0 |
| 2024-03-18 10:00:00 | AAPL | Stock | 176.77 | 177.71 | 176.585 | 177.18 | 9054778.0 |
| 2024-03-18 11:00:00 | AAPL | Stock | 177.18 | 177.33 | 175.6115 | 175.64 | 5850002.0 |
| 2024-03-18 12:00:00 | AAPL | Stock | 175.64 | 175.65 | 175.075 | 175.08 | 4730934.0 |
| 2024-03-18 13:00:00 | AAPL | Stock | 175.08 | 175.45 | 174.74 | 175.116 | 4040910.0 |
| 2024-03-18 14:00:00 | AAPL | Stock | 175.12 | 175.54 | 174.82 | 174.975 | 3361415.0 |
| 2024-03-18 15:00:00 | AAPL | Stock | 174.975 | 175.176 | 173.52 | 173.7 | 7891771.0 |
| 2024-03-18 16:00:00 | AAPL | Stock | 173.79 | 173.79 | 173.0 | 173.26 | 12295965.0 |
| 2024-03-18 17:00:00 | AAPL | Stock | 173.231 | 174.1153 | 173.22 | 173.8 | 217107.0 |
| 2024-03-18 18:00:00 | AAPL | Stock | 173.8 | 173.9 | 173.4 | 173.5 | 55018.0 |
| 2024-03-18 19:00:00 | AAPL | Stock | 173.42 | 173.69 | 173.33 | 173.59 | 26010.0 |
| 2024-03-18 04:00:00 | MSFT | Stock | 417.49 | 418.22 | 416.09 | 416.83 | 9867.0 |
| 2024-03-18 05:00:00 | MSFT | Stock | 416.93 | 416.93 | 415.74 | 415.74 | 5449.0 |
| 2024-03-18 06:00:00 | MSFT | Stock | 415.81 | 417.0 | 415.77 | 417.0 | 3947.0 |
| 2024-03-18 07:00:00 | MSFT | Stock | 417.1 | 417.1 | 414.0 | 415.14 | 59640.0 |
| 2024-03-18 08:00:00 | MSFT | Stock | 414.5239 | 418.32 | 412.0 | 412.39 | 121944.0 |
| 2024-03-18 09:00:00 | MSFT | Stock | 412.7 | 419.54 | 412.4769 | 417.49 | 2169435.0 |
| 2024-03-18 10:00:00 | MSFT | Stock | 417.5 | 420.73 | 417.4 | 419.15 | 1825349.0 |
| 2024-03-18 11:00:00 | MSFT | Stock | 419.2 | 419.38 | 417.68 | 418.34 | 960251.0 |
| 2024-03-18 12:00:00 | MSFT | Stock | 418.38 | 419.56 | 417.88 | 417.955 | 862983.0 |
| 2024-03-18 13:00:00 | MSFT | Stock | 417.955 | 418.64 | 417.17 | 418.19 | 787362.0 |
| 2024-03-18 14:00:00 | MSFT | Stock | 418.17 | 419.36 | 418.02 | 418.75 | 636133.0 |
| 2024-03-18 15:00:00 | MSFT | Stock | 418.77 | 419.695 | 416.93 | 417.37 | 1753237.0 |
| 2024-03-18 16:00:00 | MSFT | Stock | 417.4 | 417.86 | 416.5 | 416.97 | 5627879.0 |
| 2024-03-18 17:00:00 | MSFT | Stock | 417.0 | 417.5 | 416.8526 | 417.24 | 18298.0 |
| 2024-03-18 18:00:00 | MSFT | Stock | 417.25 | 417.3044 | 416.1885 | 416.27 | 6914.0 |
| 2024-03-18 19:00:00 | MSFT | Stock | 416.16 | 417.27 | 416.16 | 417.2 | 3165.0 |
| 2024-03-18 04:00:00 | NVDA | Stock | 88.616 | 89.719 | 88.616 | 89.65 | 254000.0 |
| 2024-03-18 05:00:00 | NVDA | Stock | 89.649 | 89.845 | 89.635 | 89.845 | 126760.0 |
| 2024-03-18 06:00:00 | NVDA | Stock | 89.85 | 90.5 | 89.65 | 89.861 | 467810.0 |
| 2024-03-18 07:00:00 | NVDA | Stock | 89.885 | 90.4 | 89.65 | 90.344 | 2132100.0 |
| 2024-03-18 08:00:00 | NVDA | Stock | 89.775 | 90.48 | 89.3 | 90.342 | 4487920.0 |
| 2024-03-18 09:00:00 | NVDA | Stock | 90.342 | 92.405 | 90.1 | 90.8325 | 82590860.0 |
| 2024-03-18 10:00:00 | NVDA | Stock | 90.85 | 91.561 | 89.869 | 90.144 | 75984240.0 |
| 2024-03-18 11:00:00 | NVDA | Stock | 90.16 | 90.249 | 88.011 | 88.162 | 79975540.0 |
| 2024-03-18 12:00:00 | NVDA | Stock | 88.172 | 88.875 | 87.227 | 87.4177 | 49675520.0 |
| 2024-03-18 13:00:00 | NVDA | Stock | 87.446 | 88.65 | 87.085 | 88.362 | 51498470.0 |
| 2024-03-18 14:00:00 | NVDA | Stock | 88.352 | 89.055 | 87.963 | 88.671 | 46850440.0 |
| 2024-03-18 15:00:00 | NVDA | Stock | 88.657 | 88.994 | 88.292 | 88.46 | 48546960.0 |
| 2024-03-18 16:00:00 | NVDA | Stock | 88.455 | 89.45 | 87.37 | 88.2854 | 28481100.0 |
| 2024-03-18 17:00:00 | NVDA | Stock | 88.151 | 88.455 | 86.33 | 87.71 | 6120550.0 |
| 2024-03-18 18:00:00 | NVDA | Stock | 87.705 | 88.2 | 86.7 | 86.799 | 2920540.0 |
| 2024-03-18 19:00:00 | NVDA | Stock | 86.8 | 87.3 | 86.75 | 86.89 | 1906510.0 |
| 2024-03-18 04:00:00 | AMZN | Stock | 175.58 | 175.63 | 175.01 | 175.63 | 6975.0 |
| 2024-03-18 05:00:00 | AMZN | Stock | 175.6 | 176.0 | 174.73 | 175.48 | 9261.0 |
> showing 50 of 60,778 rows — these rows as CSV