PREVIEW / stock_1hour / 2024-01-26
file: by_date/stock_1hour/2024/2024-01-26.parquet size: 1.3 MB rows: 57,877 symbols: 1,165
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-01-26 04:00:00 | AAPL | Stock | 193.31 | 193.91 | 193.07 | 193.9 | 18875.0 |
| 2024-01-26 05:00:00 | AAPL | Stock | 193.9 | 194.17 | 193.9 | 194.0 | 14664.0 |
| 2024-01-26 06:00:00 | AAPL | Stock | 194.02 | 194.35 | 193.79 | 194.35 | 16288.0 |
| 2024-01-26 07:00:00 | AAPL | Stock | 194.35 | 194.7 | 194.2 | 194.5 | 35709.0 |
| 2024-01-26 08:00:00 | AAPL | Stock | 194.37 | 194.8599 | 193.0 | 194.38 | 185604.0 |
| 2024-01-26 09:00:00 | AAPL | Stock | 194.28 | 194.65 | 193.75 | 194.615 | 4071437.0 |
| 2024-01-26 10:00:00 | AAPL | Stock | 194.64 | 194.76 | 194.19 | 194.525 | 4062962.0 |
| 2024-01-26 11:00:00 | AAPL | Stock | 194.52 | 194.57 | 193.91 | 194.0401 | 3052845.0 |
| 2024-01-26 12:00:00 | AAPL | Stock | 194.04 | 194.08 | 192.46 | 192.4678 | 4384385.0 |
| 2024-01-26 13:00:00 | AAPL | Stock | 192.46 | 192.76 | 192.27 | 192.451 | 3325729.0 |
| 2024-01-26 14:00:00 | AAPL | Stock | 192.455 | 192.97 | 192.34 | 192.91 | 2592959.0 |
| 2024-01-26 15:00:00 | AAPL | Stock | 192.92 | 192.975 | 191.94 | 192.42 | 7410408.0 |
| 2024-01-26 16:00:00 | AAPL | Stock | 192.42 | 192.45 | 192.02 | 192.29 | 7005209.0 |
| 2024-01-26 17:00:00 | AAPL | Stock | 192.28 | 192.3 | 192.18 | 192.24 | 36178.0 |
| 2024-01-26 18:00:00 | AAPL | Stock | 192.21 | 192.2731 | 192.1 | 192.1001 | 21498.0 |
| 2024-01-26 19:00:00 | AAPL | Stock | 192.19 | 192.31 | 192.15 | 192.28 | 19020.0 |
| 2024-01-26 04:00:00 | MSFT | Stock | 401.12 | 403.28 | 401.12 | 403.14 | 3699.0 |
| 2024-01-26 05:00:00 | MSFT | Stock | 403.39 | 403.5 | 403.02 | 403.05 | 2401.0 |
| 2024-01-26 06:00:00 | MSFT | Stock | 403.0 | 404.43 | 403.0 | 404.43 | 6112.0 |
| 2024-01-26 07:00:00 | MSFT | Stock | 404.03 | 404.66 | 403.92 | 403.98 | 8531.0 |
| 2024-01-26 08:00:00 | MSFT | Stock | 404.3 | 404.7 | 401.65 | 403.95 | 39303.0 |
| 2024-01-26 09:00:00 | MSFT | Stock | 403.85 | 404.6 | 402.95 | 403.88 | 1589705.0 |
| 2024-01-26 10:00:00 | MSFT | Stock | 403.84 | 405.75 | 403.03 | 405.13 | 1733041.0 |
| 2024-01-26 11:00:00 | MSFT | Stock | 405.116 | 406.01 | 404.4479 | 405.67 | 1180992.0 |
| 2024-01-26 12:00:00 | MSFT | Stock | 405.68 | 406.17 | 402.69 | 403.3167 | 1148418.0 |
| 2024-01-26 13:00:00 | MSFT | Stock | 403.3 | 403.69 | 402.43 | 402.98 | 935382.0 |
| 2024-01-26 14:00:00 | MSFT | Stock | 402.98 | 404.05 | 402.8 | 403.73 | 906661.0 |
| 2024-01-26 15:00:00 | MSFT | Stock | 403.75 | 404.35 | 402.97 | 403.99 | 1517438.0 |
| 2024-01-26 16:00:00 | MSFT | Stock | 403.94 | 404.01 | 403.11 | 403.3 | 3081214.0 |
| 2024-01-26 17:00:00 | MSFT | Stock | 403.15 | 403.87 | 403.12 | 403.85 | 7383.0 |
| 2024-01-26 18:00:00 | MSFT | Stock | 403.85 | 404.3 | 403.85 | 404.115 | 7447.0 |
| 2024-01-26 19:00:00 | MSFT | Stock | 404.11 | 404.15 | 403.98 | 404.15 | 3557.0 |
| 2024-01-26 04:00:00 | NVDA | Stock | 60.434 | 60.812 | 60.189 | 60.8 | 390280.0 |
| 2024-01-26 05:00:00 | NVDA | Stock | 60.83 | 61.04 | 60.734 | 60.83 | 314350.0 |
| 2024-01-26 06:00:00 | NVDA | Stock | 60.864 | 61.019 | 60.78 | 60.957 | 136730.0 |
| 2024-01-26 07:00:00 | NVDA | Stock | 60.939 | 61.29 | 60.906 | 61.111 | 1041680.0 |
| 2024-01-26 08:00:00 | NVDA | Stock | 60.95 | 61.49 | 60.145 | 61.409 | 3393910.0 |
| 2024-01-26 09:00:00 | NVDA | Stock | 61.37 | 61.384 | 60.573 | 61.0387 | 53353360.0 |
| 2024-01-26 10:00:00 | NVDA | Stock | 61.051 | 61.783 | 60.731 | 61.694 | 62119270.0 |
| 2024-01-26 11:00:00 | NVDA | Stock | 61.691 | 61.748 | 61.121 | 61.3925 | 37546390.0 |
| 2024-01-26 12:00:00 | NVDA | Stock | 61.3915 | 61.563 | 60.841 | 61.066 | 35401050.0 |
| 2024-01-26 13:00:00 | NVDA | Stock | 61.0675 | 61.181 | 60.743 | 60.94 | 25679410.0 |
| 2024-01-26 14:00:00 | NVDA | Stock | 60.938 | 61.4 | 60.901 | 61.337 | 29941420.0 |
| 2024-01-26 15:00:00 | NVDA | Stock | 61.33 | 61.347 | 60.9219 | 61.03 | 29526780.0 |
| 2024-01-26 16:00:00 | NVDA | Stock | 61.031 | 61.033 | 60.968 | 61.0064 | 13433740.0 |
| 2024-01-26 17:00:00 | NVDA | Stock | 61.0 | 61.044 | 60.995 | 61.03 | 261420.0 |
| 2024-01-26 18:00:00 | NVDA | Stock | 61.016 | 61.035 | 60.985 | 61.008 | 205930.0 |
| 2024-01-26 19:00:00 | NVDA | Stock | 61.007 | 61.04 | 60.986 | 61.026 | 207730.0 |
| 2024-01-26 04:00:00 | AMZN | Stock | 156.6 | 157.06 | 156.56 | 157.06 | 9056.0 |
| 2024-01-26 05:00:00 | AMZN | Stock | 157.11 | 157.39 | 157.02 | 157.02 | 8848.0 |
> showing 50 of 57,877 rows — these rows as CSV