PREVIEW / stock_1hour / 2024-06-10
file: by_date/stock_1hour/2024/2024-06-10.parquet size: 1.3 MB rows: 59,346 symbols: 980
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-06-10 04:00:00 | AAPL | Stock | 197.0 | 197.8 | 197.0 | 197.39 | 37556.0 |
| 2024-06-10 05:00:00 | AAPL | Stock | 197.41 | 197.55 | 197.29 | 197.37 | 21151.0 |
| 2024-06-10 06:00:00 | AAPL | Stock | 197.37 | 197.5 | 197.14 | 197.42 | 28735.0 |
| 2024-06-10 07:00:00 | AAPL | Stock | 197.42 | 197.79 | 197.25 | 197.59 | 50567.0 |
| 2024-06-10 08:00:00 | AAPL | Stock | 197.32 | 198.32 | 197.21 | 197.55 | 321208.0 |
| 2024-06-10 09:00:00 | AAPL | Stock | 197.565 | 197.6469 | 195.12 | 195.409 | 7964254.0 |
| 2024-06-10 10:00:00 | AAPL | Stock | 195.42 | 195.74 | 194.83 | 195.385 | 6475862.0 |
| 2024-06-10 11:00:00 | AAPL | Stock | 195.38 | 195.7 | 195.07 | 195.23 | 4019292.0 |
| 2024-06-10 12:00:00 | AAPL | Stock | 195.235 | 196.21 | 195.08 | 195.62 | 5956735.0 |
| 2024-06-10 13:00:00 | AAPL | Stock | 195.61 | 196.385 | 193.4 | 194.95 | 11938294.0 |
| 2024-06-10 14:00:00 | AAPL | Stock | 194.95 | 196.45 | 192.15 | 193.16 | 21784430.0 |
| 2024-06-10 15:00:00 | AAPL | Stock | 193.16 | 194.17 | 192.29 | 193.13 | 13972165.0 |
| 2024-06-10 16:00:00 | AAPL | Stock | 193.12 | 193.21 | 192.2206 | 192.85 | 6303285.0 |
| 2024-06-10 17:00:00 | AAPL | Stock | 192.8916 | 193.12 | 192.22 | 192.33 | 245459.0 |
| 2024-06-10 18:00:00 | AAPL | Stock | 192.3 | 193.05 | 192.26 | 192.54 | 98141.0 |
| 2024-06-10 19:00:00 | AAPL | Stock | 192.55 | 192.79 | 192.22 | 192.33 | 115835.0 |
| 2024-06-10 04:00:00 | MSFT | Stock | 423.8 | 423.93 | 423.65 | 423.67 | 2434.0 |
| 2024-06-10 05:00:00 | MSFT | Stock | 423.45 | 423.81 | 423.41 | 423.8 | 576.0 |
| 2024-06-10 06:00:00 | MSFT | Stock | 424.19 | 424.21 | 424.19 | 424.21 | 218.0 |
| 2024-06-10 07:00:00 | MSFT | Stock | 423.91 | 424.45 | 423.91 | 424.45 | 1396.0 |
| 2024-06-10 08:00:00 | MSFT | Stock | 424.0 | 424.79 | 423.0 | 424.51 | 18022.0 |
| 2024-06-10 09:00:00 | MSFT | Stock | 424.5 | 427.8397 | 423.85 | 426.895 | 1180269.0 |
| 2024-06-10 10:00:00 | MSFT | Stock | 426.94 | 427.36 | 425.62 | 426.63 | 860463.0 |
| 2024-06-10 11:00:00 | MSFT | Stock | 426.58 | 427.67 | 426.24 | 426.88 | 562216.0 |
| 2024-06-10 12:00:00 | MSFT | Stock | 426.875 | 427.38 | 425.79 | 425.9 | 529741.0 |
| 2024-06-10 13:00:00 | MSFT | Stock | 425.88 | 426.94 | 425.48 | 426.72 | 552706.0 |
| 2024-06-10 14:00:00 | MSFT | Stock | 426.7299 | 427.41 | 426.06 | 427.4095 | 706741.0 |
| 2024-06-10 15:00:00 | MSFT | Stock | 427.39 | 428.08 | 426.51 | 427.87 | 1523580.0 |
| 2024-06-10 16:00:00 | MSFT | Stock | 427.98 | 427.99 | 427.33 | 427.42 | 2137073.0 |
| 2024-06-10 17:00:00 | MSFT | Stock | 427.3901 | 427.87 | 427.3048 | 427.38 | 287723.0 |
| 2024-06-10 18:00:00 | MSFT | Stock | 427.75 | 428.0 | 427.11 | 427.4267 | 5630.0 |
| 2024-06-10 19:00:00 | MSFT | Stock | 427.44 | 427.5016 | 426.85 | 427.17 | 5616.0 |
| 2024-06-10 04:00:00 | NVDA | Stock | 120.8 | 122.19 | 118.99 | 119.76 | 1045220.0 |
| 2024-06-10 05:00:00 | NVDA | Stock | 119.78 | 120.57 | 119.75 | 120.4 | 284042.0 |
| 2024-06-10 06:00:00 | NVDA | Stock | 120.3 | 121.0 | 120.3 | 120.78 | 526546.0 |
| 2024-06-10 07:00:00 | NVDA | Stock | 120.78 | 121.0 | 120.23 | 120.61 | 1287870.0 |
| 2024-06-10 08:00:00 | NVDA | Stock | 120.73 | 121.0 | 119.4363 | 119.93 | 3172778.0 |
| 2024-06-10 09:00:00 | NVDA | Stock | 119.9298 | 121.25 | 117.01 | 118.27 | 52150110.0 |
| 2024-06-10 10:00:00 | NVDA | Stock | 118.26 | 121.78 | 117.86 | 121.76 | 49513062.0 |
| 2024-06-10 11:00:00 | NVDA | Stock | 121.75 | 122.73 | 121.3903 | 121.9099 | 41151079.0 |
| 2024-06-10 12:00:00 | NVDA | Stock | 121.91 | 123.1 | 121.62 | 122.9971 | 26894475.0 |
| 2024-06-10 13:00:00 | NVDA | Stock | 123.0 | 123.0 | 121.81 | 122.57 | 22500814.0 |
| 2024-06-10 14:00:00 | NVDA | Stock | 122.566 | 122.64 | 120.53 | 120.98 | 29350544.0 |
| 2024-06-10 15:00:00 | NVDA | Stock | 120.9819 | 122.47 | 120.81 | 121.65 | 33509538.0 |
| 2024-06-10 16:00:00 | NVDA | Stock | 121.65 | 121.86 | 121.28 | 121.79 | 9780862.0 |
| 2024-06-10 17:00:00 | NVDA | Stock | 121.79 | 121.84 | 121.61 | 121.72 | 756688.0 |
| 2024-06-10 18:00:00 | NVDA | Stock | 121.71 | 121.8 | 121.61 | 121.75 | 307314.0 |
| 2024-06-10 19:00:00 | NVDA | Stock | 121.75 | 121.79 | 121.6 | 121.6005 | 369512.0 |
| 2024-06-10 04:00:00 | AMZN | Stock | 184.29 | 184.29 | 183.92 | 183.92 | 2431.0 |
| 2024-06-10 05:00:00 | AMZN | Stock | 183.89 | 183.92 | 183.8 | 183.92 | 2311.0 |
> showing 50 of 59,346 rows — these rows as CSV