PREVIEW / stock_1hour / 2024-05-03
file: by_date/stock_1hour/2024/2024-05-03.parquet size: 1.3 MB rows: 57,984 symbols: 979
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-03 04:00:00 | AAPL | Stock | 183.1 | 183.33 | 182.41 | 183.2 | 165737.0 |
| 2024-05-03 05:00:00 | AAPL | Stock | 183.2 | 183.46 | 183.11 | 183.13 | 44756.0 |
| 2024-05-03 06:00:00 | AAPL | Stock | 183.14 | 183.98 | 183.09 | 183.71 | 135993.0 |
| 2024-05-03 07:00:00 | AAPL | Stock | 183.71 | 184.06 | 183.16 | 183.59 | 308728.0 |
| 2024-05-03 08:00:00 | AAPL | Stock | 183.6 | 186.3 | 181.71 | 185.3 | 2569004.0 |
| 2024-05-03 09:00:00 | AAPL | Stock | 185.3 | 187.04 | 183.5 | 184.115 | 30227926.0 |
| 2024-05-03 10:00:00 | AAPL | Stock | 184.15 | 184.99 | 182.66 | 184.79 | 21054016.0 |
| 2024-05-03 11:00:00 | AAPL | Stock | 184.78 | 184.99 | 183.92 | 184.595 | 12201125.0 |
| 2024-05-03 12:00:00 | AAPL | Stock | 184.59 | 184.9415 | 184.13 | 184.755 | 7991923.0 |
| 2024-05-03 13:00:00 | AAPL | Stock | 184.76 | 185.5 | 184.59 | 185.055 | 11206455.0 |
| 2024-05-03 14:00:00 | AAPL | Stock | 185.045 | 185.99 | 185.04 | 185.355 | 10157531.0 |
| 2024-05-03 15:00:00 | AAPL | Stock | 185.355 | 185.36 | 183.05 | 183.39 | 19119556.0 |
| 2024-05-03 16:00:00 | AAPL | Stock | 183.36 | 184.0 | 183.08 | 183.82 | 11144214.0 |
| 2024-05-03 17:00:00 | AAPL | Stock | 183.82 | 183.99 | 183.38 | 183.85 | 175821.0 |
| 2024-05-03 18:00:00 | AAPL | Stock | 183.9 | 183.92 | 183.81 | 183.91 | 30661.0 |
| 2024-05-03 19:00:00 | AAPL | Stock | 183.9 | 183.92 | 183.49 | 183.78 | 58157.0 |
| 2024-05-03 04:00:00 | MSFT | Stock | 398.99 | 399.1 | 398.67 | 398.67 | 2946.0 |
| 2024-05-03 05:00:00 | MSFT | Stock | 398.89 | 399.2 | 398.79 | 399.1 | 1476.0 |
| 2024-05-03 06:00:00 | MSFT | Stock | 399.45 | 399.7 | 399.15 | 399.5 | 3083.0 |
| 2024-05-03 07:00:00 | MSFT | Stock | 399.35 | 399.37 | 398.56 | 398.6 | 11382.0 |
| 2024-05-03 08:00:00 | MSFT | Stock | 399.05 | 403.45 | 398.56 | 402.0 | 62243.0 |
| 2024-05-03 09:00:00 | MSFT | Stock | 402.05 | 406.16 | 401.86 | 405.7 | 2130807.0 |
| 2024-05-03 10:00:00 | MSFT | Stock | 405.72 | 406.58 | 403.68 | 405.44 | 1829175.0 |
| 2024-05-03 11:00:00 | MSFT | Stock | 405.46 | 406.68 | 404.74 | 406.03 | 980073.0 |
| 2024-05-03 12:00:00 | MSFT | Stock | 406.08 | 406.61 | 405.54 | 405.85 | 592806.0 |
| 2024-05-03 13:00:00 | MSFT | Stock | 405.87 | 406.31 | 405.58 | 405.97 | 583327.0 |
| 2024-05-03 14:00:00 | MSFT | Stock | 405.97 | 406.58 | 405.91 | 406.18 | 527768.0 |
| 2024-05-03 15:00:00 | MSFT | Stock | 406.1863 | 407.15 | 406.03 | 406.84 | 1620848.0 |
| 2024-05-03 16:00:00 | MSFT | Stock | 406.66 | 406.98 | 406.63 | 406.93 | 3814052.0 |
| 2024-05-03 17:00:00 | MSFT | Stock | 406.92 | 407.0 | 406.66 | 407.0 | 10501.0 |
| 2024-05-03 18:00:00 | MSFT | Stock | 407.0 | 407.28 | 406.93 | 407.28 | 3212.0 |
| 2024-05-03 19:00:00 | MSFT | Stock | 407.28 | 407.32 | 407.0 | 407.19 | 5421.0 |
| 2024-05-03 04:00:00 | NVDA | Stock | 86.337 | 86.45 | 86.1 | 86.3 | 59160.0 |
| 2024-05-03 05:00:00 | NVDA | Stock | 86.292 | 86.292 | 86.225 | 86.225 | 5710.0 |
| 2024-05-03 06:00:00 | NVDA | Stock | 86.377 | 86.38 | 86.295 | 86.347 | 22010.0 |
| 2024-05-03 07:00:00 | NVDA | Stock | 86.35 | 86.533 | 86.062 | 86.08 | 485710.0 |
| 2024-05-03 08:00:00 | NVDA | Stock | 86.4 | 87.6628 | 85.917 | 87.457 | 5892390.0 |
| 2024-05-03 09:00:00 | NVDA | Stock | 87.45 | 88.865 | 87.04 | 88.6692 | 54638600.0 |
| 2024-05-03 10:00:00 | NVDA | Stock | 88.684 | 88.9475 | 87.288 | 87.893 | 61496070.0 |
| 2024-05-03 11:00:00 | NVDA | Stock | 87.88 | 88.5575 | 87.526 | 88.433 | 35010640.0 |
| 2024-05-03 12:00:00 | NVDA | Stock | 88.457 | 88.792 | 88.312 | 88.571 | 26258950.0 |
| 2024-05-03 13:00:00 | NVDA | Stock | 88.596 | 89.11 | 88.53 | 88.709 | 31917090.0 |
| 2024-05-03 14:00:00 | NVDA | Stock | 88.726 | 89.281 | 88.714 | 88.814 | 29392590.0 |
| 2024-05-03 15:00:00 | NVDA | Stock | 88.834 | 88.95 | 88.597 | 88.787 | 33734430.0 |
| 2024-05-03 16:00:00 | NVDA | Stock | 88.789 | 88.8719 | 88.669 | 88.74 | 15036440.0 |
| 2024-05-03 17:00:00 | NVDA | Stock | 88.736 | 88.789 | 88.62 | 88.634 | 321730.0 |
| 2024-05-03 18:00:00 | NVDA | Stock | 88.63 | 88.68 | 88.62 | 88.671 | 79060.0 |
| 2024-05-03 19:00:00 | NVDA | Stock | 88.68 | 88.693 | 88.572 | 88.622 | 371370.0 |
| 2024-05-03 04:00:00 | AMZN | Stock | 183.98 | 184.72 | 183.92 | 184.7 | 9608.0 |
| 2024-05-03 05:00:00 | AMZN | Stock | 184.69 | 184.69 | 184.21 | 184.44 | 12365.0 |
> showing 50 of 57,984 rows — these rows as CSV