PREVIEW / stock_1hour / 2023-01-20
file: by_date/stock_1hour/2023/2023-01-20.parquet size: 1.4 MB rows: 61,141 symbols: 1,936
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 |
|---|---|---|---|---|---|---|---|
| 2023-01-20 04:00:00 | AAPL | Stock | 135.6 | 135.63 | 135.24 | 135.24 | 31297.0 |
| 2023-01-20 05:00:00 | AAPL | Stock | 135.25 | 135.4 | 135.18 | 135.4 | 9560.0 |
| 2023-01-20 06:00:00 | AAPL | Stock | 135.44 | 135.56 | 135.13 | 135.27 | 13321.0 |
| 2023-01-20 07:00:00 | AAPL | Stock | 135.36 | 136.29 | 135.36 | 136.17 | 77322.0 |
| 2023-01-20 08:00:00 | AAPL | Stock | 135.85 | 136.29 | 134.932 | 135.46 | 270223.0 |
| 2023-01-20 09:00:00 | AAPL | Stock | 135.48 | 136.0 | 134.22 | 134.6012 | 11788126.0 |
| 2023-01-20 10:00:00 | AAPL | Stock | 134.61 | 135.4897 | 134.32 | 135.01 | 8220254.0 |
| 2023-01-20 11:00:00 | AAPL | Stock | 135.02 | 135.6718 | 135.0 | 135.3063 | 6223834.0 |
| 2023-01-20 12:00:00 | AAPL | Stock | 135.31 | 135.95 | 135.305 | 135.77 | 4088230.0 |
| 2023-01-20 13:00:00 | AAPL | Stock | 135.7689 | 136.85 | 135.38 | 136.8301 | 6459982.0 |
| 2023-01-20 14:00:00 | AAPL | Stock | 136.84 | 137.28 | 136.64 | 137.17 | 5476578.0 |
| 2023-01-20 15:00:00 | AAPL | Stock | 137.17 | 138.02 | 137.1342 | 137.84 | 12625302.0 |
| 2023-01-20 16:00:00 | AAPL | Stock | 137.86 | 137.98 | 136.55 | 137.9 | 16252066.0 |
| 2023-01-20 17:00:00 | AAPL | Stock | 137.89 | 137.93 | 137.8216 | 137.88 | 63245.0 |
| 2023-01-20 18:00:00 | AAPL | Stock | 137.86 | 137.93 | 137.8 | 137.9 | 66474.0 |
| 2023-01-20 19:00:00 | AAPL | Stock | 137.91 | 138.18 | 137.91 | 138.1 | 83148.0 |
| 2023-01-20 04:00:00 | MSFT | Stock | 232.46 | 232.48 | 232.03 | 232.31 | 4053.0 |
| 2023-01-20 05:00:00 | MSFT | Stock | 232.21 | 233.0 | 232.21 | 232.85 | 1536.0 |
| 2023-01-20 06:00:00 | MSFT | Stock | 232.71 | 232.84 | 232.25 | 232.42 | 7036.0 |
| 2023-01-20 07:00:00 | MSFT | Stock | 232.7 | 233.2 | 232.37 | 232.92 | 8694.0 |
| 2023-01-20 08:00:00 | MSFT | Stock | 232.6 | 233.28 | 231.351 | 232.8 | 105162.0 |
| 2023-01-20 09:00:00 | MSFT | Stock | 232.83 | 236.96 | 232.65 | 235.6942 | 6569378.0 |
| 2023-01-20 10:00:00 | MSFT | Stock | 235.68 | 236.74 | 235.14 | 236.09 | 2329382.0 |
| 2023-01-20 11:00:00 | MSFT | Stock | 236.11 | 238.6662 | 236.01 | 238.531 | 2168434.0 |
| 2023-01-20 12:00:00 | MSFT | Stock | 238.52 | 238.84 | 238.117 | 238.31 | 1319731.0 |
| 2023-01-20 13:00:00 | MSFT | Stock | 238.32 | 239.59 | 237.57 | 239.49 | 1364949.0 |
| 2023-01-20 14:00:00 | MSFT | Stock | 239.51 | 239.8 | 239.09 | 239.53 | 1543305.0 |
| 2023-01-20 15:00:00 | MSFT | Stock | 239.545 | 240.74 | 239.475 | 240.15 | 5514958.0 |
| 2023-01-20 16:00:00 | MSFT | Stock | 240.22 | 240.7 | 240.11 | 240.68 | 6327089.0 |
| 2023-01-20 17:00:00 | MSFT | Stock | 240.6 | 240.6 | 240.2354 | 240.28 | 22465.0 |
| 2023-01-20 18:00:00 | MSFT | Stock | 240.27 | 240.3 | 240.22 | 240.2399 | 49347.0 |
| 2023-01-20 19:00:00 | MSFT | Stock | 240.24 | 240.5 | 240.24 | 240.4 | 16448.0 |
| 2023-01-20 04:00:00 | NVDA | Stock | 16.857 | 16.921 | 16.814 | 16.871 | 39170.0 |
| 2023-01-20 05:00:00 | NVDA | Stock | 16.872 | 16.896 | 16.87 | 16.896 | 32590.0 |
| 2023-01-20 06:00:00 | NVDA | Stock | 16.895 | 16.898 | 16.857 | 16.861 | 28310.0 |
| 2023-01-20 07:00:00 | NVDA | Stock | 16.889 | 16.974 | 16.885 | 16.968 | 93400.0 |
| 2023-01-20 08:00:00 | NVDA | Stock | 16.875 | 16.985 | 16.87 | 16.966 | 797080.0 |
| 2023-01-20 09:00:00 | NVDA | Stock | 16.955 | 17.07 | 16.847 | 16.9735 | 48204970.0 |
| 2023-01-20 10:00:00 | NVDA | Stock | 16.976 | 17.098 | 16.825 | 16.919 | 57018420.0 |
| 2023-01-20 11:00:00 | NVDA | Stock | 16.9204 | 17.3728 | 16.9132 | 17.3244 | 63841680.0 |
| 2023-01-20 12:00:00 | NVDA | Stock | 17.322 | 17.599 | 17.3215 | 17.477 | 64204670.0 |
| 2023-01-20 13:00:00 | NVDA | Stock | 17.4765 | 17.65 | 17.4223 | 17.634 | 52876390.0 |
| 2023-01-20 14:00:00 | NVDA | Stock | 17.633 | 17.78 | 17.6152 | 17.775 | 52776470.0 |
| 2023-01-20 15:00:00 | NVDA | Stock | 17.776 | 17.856 | 17.73 | 17.842 | 77949290.0 |
| 2023-01-20 16:00:00 | NVDA | Stock | 17.8465 | 17.864 | 17.807 | 17.852 | 36471930.0 |
| 2023-01-20 17:00:00 | NVDA | Stock | 17.851 | 17.878 | 17.85 | 17.875 | 402120.0 |
| 2023-01-20 18:00:00 | NVDA | Stock | 17.839 | 17.886 | 17.839 | 17.886 | 1527160.0 |
| 2023-01-20 19:00:00 | NVDA | Stock | 17.888 | 17.98 | 17.888 | 17.975 | 434340.0 |
| 2023-01-20 04:00:00 | AMZN | Stock | 94.2 | 94.39 | 94.02 | 94.12 | 20361.0 |
| 2023-01-20 05:00:00 | AMZN | Stock | 94.1 | 94.19 | 93.99 | 94.05 | 9430.0 |
> showing 50 of 61,141 rows — these rows as CSV