PREVIEW / stock_1hour / 2024-08-15
file: by_date/stock_1hour/2024/2024-08-15.parquet size: 1.3 MB rows: 59,180 symbols: 841
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-08-15 04:00:00 | AAPL | Stock | 222.34 | 222.71 | 221.88 | 222.22 | 8341.0 |
| 2024-08-15 05:00:00 | AAPL | Stock | 222.21 | 222.48 | 222.21 | 222.44 | 4882.0 |
| 2024-08-15 06:00:00 | AAPL | Stock | 222.46 | 222.48 | 221.84 | 221.84 | 5830.0 |
| 2024-08-15 07:00:00 | AAPL | Stock | 221.91 | 222.37 | 221.76 | 222.28 | 16754.0 |
| 2024-08-15 08:00:00 | AAPL | Stock | 221.94 | 223.71 | 221.78 | 223.43 | 191077.0 |
| 2024-08-15 09:00:00 | AAPL | Stock | 223.53 | 224.87 | 222.76 | 224.43 | 4731002.0 |
| 2024-08-15 10:00:00 | AAPL | Stock | 224.4201 | 225.35 | 223.95 | 224.45 | 5277506.0 |
| 2024-08-15 11:00:00 | AAPL | Stock | 224.44 | 224.815 | 223.84 | 224.65 | 2890075.0 |
| 2024-08-15 12:00:00 | AAPL | Stock | 224.65 | 225.02 | 224.35 | 224.57 | 2167545.0 |
| 2024-08-15 13:00:00 | AAPL | Stock | 224.5601 | 224.87 | 224.245 | 224.6761 | 1586543.0 |
| 2024-08-15 14:00:00 | AAPL | Stock | 224.6801 | 225.19 | 224.62 | 225.11 | 1853022.0 |
| 2024-08-15 15:00:00 | AAPL | Stock | 225.11 | 225.33 | 223.845 | 224.71 | 5181482.0 |
| 2024-08-15 16:00:00 | AAPL | Stock | 224.71 | 224.98 | 224.25 | 224.78 | 10496877.0 |
| 2024-08-15 17:00:00 | AAPL | Stock | 224.8 | 224.9 | 224.61 | 224.8199 | 34170.0 |
| 2024-08-15 18:00:00 | AAPL | Stock | 224.83 | 225.41 | 224.82 | 225.39 | 29157.0 |
| 2024-08-15 19:00:00 | AAPL | Stock | 225.38 | 225.55 | 225.15 | 225.3901 | 28289.0 |
| 2024-08-15 04:00:00 | MSFT | Stock | 418.1 | 418.1 | 417.05 | 417.44 | 2489.0 |
| 2024-08-15 05:00:00 | MSFT | Stock | 417.5 | 417.8 | 417.5 | 417.8 | 3111.0 |
| 2024-08-15 06:00:00 | MSFT | Stock | 417.8 | 417.92 | 417.13 | 417.13 | 2031.0 |
| 2024-08-15 07:00:00 | MSFT | Stock | 417.1 | 418.19 | 417.01 | 418.08 | 4694.0 |
| 2024-08-15 08:00:00 | MSFT | Stock | 417.3 | 420.5 | 417.11 | 419.74 | 55812.0 |
| 2024-08-15 09:00:00 | MSFT | Stock | 419.7 | 420.78 | 417.66 | 420.63 | 1295517.0 |
| 2024-08-15 10:00:00 | MSFT | Stock | 420.58 | 420.936 | 418.2 | 418.4675 | 1290102.0 |
| 2024-08-15 11:00:00 | MSFT | Stock | 418.48 | 420.0699 | 417.95 | 419.735 | 1162906.0 |
| 2024-08-15 12:00:00 | MSFT | Stock | 419.715 | 420.55 | 418.82 | 418.93 | 716029.0 |
| 2024-08-15 13:00:00 | MSFT | Stock | 418.92 | 419.86 | 418.54 | 419.849 | 643238.0 |
| 2024-08-15 14:00:00 | MSFT | Stock | 419.85 | 420.26 | 419.47 | 419.94 | 633197.0 |
| 2024-08-15 15:00:00 | MSFT | Stock | 419.92 | 421.11 | 419.11 | 421.1 | 1670791.0 |
| 2024-08-15 16:00:00 | MSFT | Stock | 421.05 | 421.24 | 420.26 | 420.45 | 5206254.0 |
| 2024-08-15 17:00:00 | MSFT | Stock | 420.5 | 420.5691 | 420.0 | 420.4 | 9495.0 |
| 2024-08-15 18:00:00 | MSFT | Stock | 420.59 | 421.47 | 420.4 | 421.47 | 3893.0 |
| 2024-08-15 19:00:00 | MSFT | Stock | 421.1 | 422.35 | 421.03 | 421.49 | 10008.0 |
| 2024-08-15 04:00:00 | NVDA | Stock | 118.1 | 118.37 | 117.02 | 117.3 | 518526.0 |
| 2024-08-15 05:00:00 | NVDA | Stock | 117.33 | 117.91 | 117.31 | 117.71 | 257202.0 |
| 2024-08-15 06:00:00 | NVDA | Stock | 117.71 | 117.81 | 117.16 | 117.2 | 213301.0 |
| 2024-08-15 07:00:00 | NVDA | Stock | 117.16 | 117.86 | 116.98 | 117.2 | 903756.0 |
| 2024-08-15 08:00:00 | NVDA | Stock | 117.26 | 119.55 | 116.95 | 119.02 | 5918616.0 |
| 2024-08-15 09:00:00 | NVDA | Stock | 119.04 | 120.55 | 117.47 | 120.54 | 49446850.0 |
| 2024-08-15 10:00:00 | NVDA | Stock | 120.53 | 121.9799 | 119.6501 | 121.5503 | 55956645.0 |
| 2024-08-15 11:00:00 | NVDA | Stock | 121.55 | 122.49 | 121.435 | 121.88 | 36436900.0 |
| 2024-08-15 12:00:00 | NVDA | Stock | 121.885 | 122.49 | 121.77 | 122.095 | 24075110.0 |
| 2024-08-15 13:00:00 | NVDA | Stock | 122.09 | 122.95 | 121.84 | 122.9301 | 22528918.0 |
| 2024-08-15 14:00:00 | NVDA | Stock | 122.94 | 123.24 | 122.42 | 122.886 | 26652860.0 |
| 2024-08-15 15:00:00 | NVDA | Stock | 122.886 | 122.97 | 122.1 | 122.9413 | 33557169.0 |
| 2024-08-15 16:00:00 | NVDA | Stock | 122.86 | 122.915 | 122.38 | 122.44 | 26873382.0 |
| 2024-08-15 17:00:00 | NVDA | Stock | 122.4109 | 122.86 | 121.46 | 122.43 | 1859168.0 |
| 2024-08-15 18:00:00 | NVDA | Stock | 122.44 | 122.68 | 122.36 | 122.68 | 483272.0 |
| 2024-08-15 19:00:00 | NVDA | Stock | 122.679 | 123.0 | 122.65 | 122.95 | 961218.0 |
| 2024-08-15 04:00:00 | AMZN | Stock | 170.71 | 170.83 | 170.15 | 170.31 | 10339.0 |
| 2024-08-15 05:00:00 | AMZN | Stock | 170.44 | 170.59 | 170.44 | 170.59 | 600.0 |
> showing 50 of 59,180 rows — these rows as CSV