PREVIEW / stock_1hour / 2024-02-07
file: by_date/stock_1hour/2024/2024-02-07.parquet size: 1.3 MB rows: 59,263 symbols: 1,161
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-02-07 04:00:00 | AAPL | Stock | 189.36 | 189.8 | 189.25 | 189.6 | 20960.0 |
| 2024-02-07 05:00:00 | AAPL | Stock | 189.71 | 189.71 | 189.31 | 189.31 | 4610.0 |
| 2024-02-07 06:00:00 | AAPL | Stock | 189.38 | 189.65 | 189.38 | 189.64 | 6151.0 |
| 2024-02-07 07:00:00 | AAPL | Stock | 189.61 | 190.0 | 189.58 | 189.96 | 33660.0 |
| 2024-02-07 08:00:00 | AAPL | Stock | 189.63 | 190.39 | 189.36 | 190.129 | 143122.0 |
| 2024-02-07 09:00:00 | AAPL | Stock | 190.15 | 191.05 | 188.8408 | 189.005 | 6123403.0 |
| 2024-02-07 10:00:00 | AAPL | Stock | 189.005 | 190.4 | 188.61 | 189.66 | 7155165.0 |
| 2024-02-07 11:00:00 | AAPL | Stock | 189.66 | 189.72 | 188.806 | 189.135 | 4698768.0 |
| 2024-02-07 12:00:00 | AAPL | Stock | 189.14 | 189.22 | 188.65 | 188.9964 | 3398938.0 |
| 2024-02-07 13:00:00 | AAPL | Stock | 189.0 | 189.295 | 188.73 | 189.1999 | 3221869.0 |
| 2024-02-07 14:00:00 | AAPL | Stock | 189.2 | 189.41 | 188.89 | 189.26 | 2963524.0 |
| 2024-02-07 15:00:00 | AAPL | Stock | 189.265 | 189.42 | 188.935 | 189.41 | 6670712.0 |
| 2024-02-07 16:00:00 | AAPL | Stock | 189.41 | 189.55 | 189.21 | 189.38 | 7210719.0 |
| 2024-02-07 17:00:00 | AAPL | Stock | 189.38 | 189.81 | 189.22 | 189.36 | 47845.0 |
| 2024-02-07 18:00:00 | AAPL | Stock | 189.24 | 189.39 | 189.22 | 189.34 | 13727.0 |
| 2024-02-07 19:00:00 | AAPL | Stock | 189.26 | 189.41 | 189.22 | 189.37 | 12272.0 |
| 2024-02-07 04:00:00 | MSFT | Stock | 405.09 | 405.7 | 405.09 | 405.66 | 1908.0 |
| 2024-02-07 05:00:00 | MSFT | Stock | 405.66 | 406.06 | 405.66 | 405.85 | 2047.0 |
| 2024-02-07 06:00:00 | MSFT | Stock | 405.97 | 406.58 | 405.95 | 406.36 | 2189.0 |
| 2024-02-07 07:00:00 | MSFT | Stock | 406.15 | 406.74 | 406.0 | 406.74 | 6271.0 |
| 2024-02-07 08:00:00 | MSFT | Stock | 406.18 | 407.9139 | 405.0 | 407.0 | 51625.0 |
| 2024-02-07 09:00:00 | MSFT | Stock | 407.39 | 409.93 | 407.27 | 409.16 | 2343160.0 |
| 2024-02-07 10:00:00 | MSFT | Stock | 409.13 | 412.4299 | 408.8 | 411.23 | 2438868.0 |
| 2024-02-07 11:00:00 | MSFT | Stock | 411.27 | 412.02 | 410.7 | 411.7 | 980792.0 |
| 2024-02-07 12:00:00 | MSFT | Stock | 411.705 | 412.4 | 411.18 | 412.0 | 856649.0 |
| 2024-02-07 13:00:00 | MSFT | Stock | 412.02 | 413.16 | 411.49 | 413.072 | 927597.0 |
| 2024-02-07 14:00:00 | MSFT | Stock | 413.07 | 413.14 | 412.421 | 412.92 | 870847.0 |
| 2024-02-07 15:00:00 | MSFT | Stock | 412.91 | 414.3 | 412.66 | 414.06 | 2212553.0 |
| 2024-02-07 16:00:00 | MSFT | Stock | 414.05 | 414.66 | 414.02 | 414.28 | 3568768.0 |
| 2024-02-07 17:00:00 | MSFT | Stock | 414.27 | 414.75 | 414.05 | 414.65 | 15918.0 |
| 2024-02-07 18:00:00 | MSFT | Stock | 414.57 | 414.6 | 414.06 | 414.4 | 9006.0 |
| 2024-02-07 19:00:00 | MSFT | Stock | 414.4 | 414.5 | 414.15 | 414.17 | 6578.0 |
| 2024-02-07 04:00:00 | NVDA | Stock | 67.8 | 68.07 | 67.475 | 67.61 | 247420.0 |
| 2024-02-07 05:00:00 | NVDA | Stock | 67.76 | 68.434 | 67.76 | 68.265 | 345850.0 |
| 2024-02-07 06:00:00 | NVDA | Stock | 68.23 | 68.369 | 68.151 | 68.151 | 190020.0 |
| 2024-02-07 07:00:00 | NVDA | Stock | 68.151 | 68.168 | 67.59 | 67.9 | 1429270.0 |
| 2024-02-07 08:00:00 | NVDA | Stock | 68.039 | 68.2 | 67.532 | 68.0687 | 2964980.0 |
| 2024-02-07 09:00:00 | NVDA | Stock | 68.0687 | 69.14 | 67.6 | 68.762 | 62300810.0 |
| 2024-02-07 10:00:00 | NVDA | Stock | 68.783 | 69.499 | 68.46 | 68.87 | 74951750.0 |
| 2024-02-07 11:00:00 | NVDA | Stock | 68.8554 | 69.347 | 68.62 | 69.2388 | 42242670.0 |
| 2024-02-07 12:00:00 | NVDA | Stock | 69.235 | 69.398 | 68.913 | 69.314 | 30899610.0 |
| 2024-02-07 13:00:00 | NVDA | Stock | 69.319 | 69.575 | 69.092 | 69.525 | 33378310.0 |
| 2024-02-07 14:00:00 | NVDA | Stock | 69.516 | 69.82 | 69.281 | 69.8145 | 31487440.0 |
| 2024-02-07 15:00:00 | NVDA | Stock | 69.81 | 70.22 | 69.716 | 70.123 | 63741830.0 |
| 2024-02-07 16:00:00 | NVDA | Stock | 70.123 | 70.75 | 70.09 | 70.56 | 21993940.0 |
| 2024-02-07 17:00:00 | NVDA | Stock | 70.5759 | 70.971 | 70.099 | 70.6 | 2504960.0 |
| 2024-02-07 18:00:00 | NVDA | Stock | 70.625 | 70.665 | 70.16 | 70.44 | 1775750.0 |
| 2024-02-07 19:00:00 | NVDA | Stock | 70.44 | 70.56 | 70.4 | 70.533 | 964250.0 |
| 2024-02-07 04:00:00 | AMZN | Stock | 168.79 | 168.82 | 168.59 | 168.77 | 1909.0 |
| 2024-02-07 05:00:00 | AMZN | Stock | 168.82 | 168.99 | 168.77 | 168.77 | 3281.0 |
> showing 50 of 59,263 rows — these rows as CSV