PREVIEW / stock_1hour / 2024-05-24
file: by_date/stock_1hour/2024/2024-05-24.parquet size: 1.3 MB rows: 57,674 symbols: 946
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-24 04:00:00 | AAPL | Stock | 187.9 | 188.65 | 187.58 | 188.4 | 31254.0 |
| 2024-05-24 05:00:00 | AAPL | Stock | 188.36 | 188.36 | 188.07 | 188.07 | 5583.0 |
| 2024-05-24 06:00:00 | AAPL | Stock | 188.18 | 188.4 | 188.18 | 188.35 | 5411.0 |
| 2024-05-24 07:00:00 | AAPL | Stock | 188.35 | 188.4 | 187.94 | 188.01 | 26988.0 |
| 2024-05-24 08:00:00 | AAPL | Stock | 188.25 | 188.4 | 186.88 | 188.2 | 130214.0 |
| 2024-05-24 09:00:00 | AAPL | Stock | 188.23 | 189.1858 | 188.0404 | 188.75 | 4701581.0 |
| 2024-05-24 10:00:00 | AAPL | Stock | 188.75 | 189.75 | 188.67 | 189.7401 | 4347885.0 |
| 2024-05-24 11:00:00 | AAPL | Stock | 189.75 | 190.29 | 189.65 | 190.175 | 3610974.0 |
| 2024-05-24 12:00:00 | AAPL | Stock | 190.175 | 190.58 | 190.16 | 190.355 | 2619582.0 |
| 2024-05-24 13:00:00 | AAPL | Stock | 190.36 | 190.56 | 190.06 | 190.075 | 2054163.0 |
| 2024-05-24 14:00:00 | AAPL | Stock | 190.075 | 190.465 | 190.055 | 190.21 | 2209189.0 |
| 2024-05-24 15:00:00 | AAPL | Stock | 190.2 | 190.29 | 189.82 | 190.0 | 4175304.0 |
| 2024-05-24 16:00:00 | AAPL | Stock | 190.02 | 190.03 | 189.95 | 190.0 | 5778033.0 |
| 2024-05-24 17:00:00 | AAPL | Stock | 189.99 | 190.04 | 189.98 | 189.99 | 11638.0 |
| 2024-05-24 18:00:00 | AAPL | Stock | 190.0 | 190.09 | 189.95 | 190.09 | 14854.0 |
| 2024-05-24 19:00:00 | AAPL | Stock | 190.1 | 190.1 | 189.91 | 189.95 | 8304.0 |
| 2024-05-24 04:00:00 | MSFT | Stock | 427.16 | 428.52 | 427.16 | 428.31 | 2485.0 |
| 2024-05-24 05:00:00 | MSFT | Stock | 428.19 | 428.19 | 427.75 | 427.75 | 1092.0 |
| 2024-05-24 06:00:00 | MSFT | Stock | 427.92 | 428.08 | 427.92 | 428.08 | 579.0 |
| 2024-05-24 07:00:00 | MSFT | Stock | 428.44 | 428.44 | 427.8 | 428.26 | 3953.0 |
| 2024-05-24 08:00:00 | MSFT | Stock | 428.385 | 428.44 | 426.5 | 427.7 | 24304.0 |
| 2024-05-24 09:00:00 | MSFT | Stock | 427.95 | 428.2423 | 424.41 | 425.51 | 1193265.0 |
| 2024-05-24 10:00:00 | MSFT | Stock | 425.51 | 428.16 | 425.3601 | 427.939 | 990321.0 |
| 2024-05-24 11:00:00 | MSFT | Stock | 427.95 | 429.97 | 427.95 | 429.78 | 739572.0 |
| 2024-05-24 12:00:00 | MSFT | Stock | 429.74 | 430.3321 | 429.35 | 429.7328 | 453631.0 |
| 2024-05-24 13:00:00 | MSFT | Stock | 429.73 | 430.52 | 429.62 | 430.4 | 407083.0 |
| 2024-05-24 14:00:00 | MSFT | Stock | 430.39 | 431.055 | 429.73 | 429.73 | 539291.0 |
| 2024-05-24 15:00:00 | MSFT | Stock | 429.71 | 430.4403 | 429.16 | 430.13 | 971322.0 |
| 2024-05-24 16:00:00 | MSFT | Stock | 430.16 | 430.47 | 429.9401 | 429.95 | 2036945.0 |
| 2024-05-24 17:00:00 | MSFT | Stock | 430.05 | 430.15 | 429.95 | 430.001 | 7672.0 |
| 2024-05-24 18:00:00 | MSFT | Stock | 430.0045 | 430.12 | 430.0 | 430.07 | 742.0 |
| 2024-05-24 19:00:00 | MSFT | Stock | 430.01 | 430.3 | 430.0 | 430.3 | 1844.0 |
| 2024-05-24 04:00:00 | NVDA | Stock | 102.588 | 104.432 | 102.565 | 104.012 | 471190.0 |
| 2024-05-24 05:00:00 | NVDA | Stock | 104.0 | 104.404 | 103.84 | 103.964 | 237360.0 |
| 2024-05-24 06:00:00 | NVDA | Stock | 103.954 | 104.44 | 103.954 | 104.297 | 202110.0 |
| 2024-05-24 07:00:00 | NVDA | Stock | 104.22 | 105.292 | 104.2 | 105.08 | 1742730.0 |
| 2024-05-24 08:00:00 | NVDA | Stock | 104.3 | 105.2787 | 102.588 | 104.755 | 3369640.0 |
| 2024-05-24 09:00:00 | NVDA | Stock | 104.75 | 105.0 | 103.0 | 104.337 | 57154170.0 |
| 2024-05-24 10:00:00 | NVDA | Stock | 104.369 | 104.864 | 103.511 | 104.7454 | 46948400.0 |
| 2024-05-24 11:00:00 | NVDA | Stock | 104.7586 | 104.993 | 104.0622 | 104.382 | 32349280.0 |
| 2024-05-24 12:00:00 | NVDA | Stock | 104.388 | 104.995 | 104.183 | 104.7594 | 22377380.0 |
| 2024-05-24 13:00:00 | NVDA | Stock | 104.768 | 105.353 | 104.51 | 105.191 | 26817310.0 |
| 2024-05-24 14:00:00 | NVDA | Stock | 105.189 | 105.789 | 105.151 | 105.409 | 30291390.0 |
| 2024-05-24 15:00:00 | NVDA | Stock | 105.4 | 106.475 | 105.122 | 106.438 | 46362700.0 |
| 2024-05-24 16:00:00 | NVDA | Stock | 106.469 | 106.725 | 106.36 | 106.512 | 18871020.0 |
| 2024-05-24 17:00:00 | NVDA | Stock | 106.51 | 106.5844 | 106.449 | 106.508 | 1385850.0 |
| 2024-05-24 18:00:00 | NVDA | Stock | 106.49 | 106.9 | 106.49 | 106.842 | 1039350.0 |
| 2024-05-24 19:00:00 | NVDA | Stock | 106.845 | 107.0 | 106.8 | 106.9 | 1024680.0 |
| 2024-05-24 04:00:00 | AMZN | Stock | 180.37 | 181.8 | 180.37 | 181.8 | 3130.0 |
| 2024-05-24 05:00:00 | AMZN | Stock | 181.75 | 181.75 | 181.45 | 181.72 | 1080.0 |
> showing 50 of 57,674 rows — these rows as CSV