PREVIEW / stock_1hour / 2024-11-11
file: by_date/stock_1hour/2024/2024-11-11.parquet size: 1.5 MB rows: 64,297 symbols: 726
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-11-11 04:00:00 | AAPL | Stock | 227.21 | 227.26 | 226.0 | 226.45 | 24155.0 |
| 2024-11-11 05:00:00 | AAPL | Stock | 226.43 | 226.44 | 226.21 | 226.21 | 7656.0 |
| 2024-11-11 06:00:00 | AAPL | Stock | 226.18 | 226.22 | 226.1 | 226.22 | 3893.0 |
| 2024-11-11 07:00:00 | AAPL | Stock | 226.3 | 226.4 | 226.02 | 226.22 | 49874.0 |
| 2024-11-11 08:00:00 | AAPL | Stock | 226.3104 | 227.69 | 225.75 | 225.9 | 186782.0 |
| 2024-11-11 09:00:00 | AAPL | Stock | 225.9 | 226.06 | 222.77 | 222.9 | 5558819.0 |
| 2024-11-11 10:00:00 | AAPL | Stock | 222.9 | 223.72 | 222.74 | 222.75 | 4711661.0 |
| 2024-11-11 11:00:00 | AAPL | Stock | 222.755 | 223.35 | 222.66 | 222.78 | 3027524.0 |
| 2024-11-11 12:00:00 | AAPL | Stock | 222.78 | 222.88 | 221.7 | 221.86 | 3078246.0 |
| 2024-11-11 13:00:00 | AAPL | Stock | 221.86 | 222.99 | 221.5 | 222.9 | 2194927.0 |
| 2024-11-11 14:00:00 | AAPL | Stock | 222.9085 | 223.18 | 222.84 | 223.045 | 1559423.0 |
| 2024-11-11 15:00:00 | AAPL | Stock | 223.05 | 224.35 | 223.015 | 224.25 | 4056611.0 |
| 2024-11-11 16:00:00 | AAPL | Stock | 224.23 | 224.5 | 224.12 | 224.25 | 5064428.0 |
| 2024-11-11 17:00:00 | AAPL | Stock | 224.25 | 224.3 | 224.0127 | 224.03 | 32600.0 |
| 2024-11-11 18:00:00 | AAPL | Stock | 224.05 | 224.1475 | 223.9 | 224.11 | 16064.0 |
| 2024-11-11 19:00:00 | AAPL | Stock | 224.0001 | 224.04 | 223.45 | 223.77 | 25726.0 |
| 2024-11-11 04:00:00 | MSFT | Stock | 423.04 | 423.04 | 422.0 | 422.4 | 9484.0 |
| 2024-11-11 05:00:00 | MSFT | Stock | 422.34 | 422.34 | 421.9 | 421.99 | 7525.0 |
| 2024-11-11 06:00:00 | MSFT | Stock | 421.95 | 422.02 | 421.8 | 421.99 | 2897.0 |
| 2024-11-11 07:00:00 | MSFT | Stock | 422.13 | 423.34 | 422.02 | 423.25 | 13501.0 |
| 2024-11-11 08:00:00 | MSFT | Stock | 422.1 | 423.8 | 421.8683 | 422.9619 | 42027.0 |
| 2024-11-11 09:00:00 | MSFT | Stock | 423.01 | 424.81 | 421.88 | 422.94 | 1477513.0 |
| 2024-11-11 10:00:00 | MSFT | Stock | 422.99 | 423.155 | 419.3 | 419.31 | 1898460.0 |
| 2024-11-11 11:00:00 | MSFT | Stock | 419.34 | 419.41 | 416.0 | 418.7 | 1979923.0 |
| 2024-11-11 12:00:00 | MSFT | Stock | 418.7279 | 419.16 | 417.25 | 417.37 | 738059.0 |
| 2024-11-11 13:00:00 | MSFT | Stock | 417.33 | 419.92 | 416.69 | 419.3534 | 957677.0 |
| 2024-11-11 14:00:00 | MSFT | Stock | 419.34 | 419.64 | 418.93 | 419.25 | 569133.0 |
| 2024-11-11 15:00:00 | MSFT | Stock | 419.215 | 419.64 | 417.11 | 418.19 | 1449500.0 |
| 2024-11-11 16:00:00 | MSFT | Stock | 418.01 | 418.85 | 417.89 | 418.02 | 2879871.0 |
| 2024-11-11 17:00:00 | MSFT | Stock | 418.01 | 418.1668 | 418.0 | 418.02 | 4910.0 |
| 2024-11-11 18:00:00 | MSFT | Stock | 417.51 | 418.11 | 417.45 | 418.1001 | 5246.0 |
| 2024-11-11 19:00:00 | MSFT | Stock | 418.1 | 418.17 | 417.0 | 417.6 | 10946.0 |
| 2024-11-11 04:00:00 | NVDA | Stock | 148.5 | 148.67 | 146.81 | 147.12 | 650793.0 |
| 2024-11-11 05:00:00 | NVDA | Stock | 147.14 | 147.58 | 146.44 | 146.76 | 469686.0 |
| 2024-11-11 06:00:00 | NVDA | Stock | 146.78 | 147.42 | 146.67 | 147.34 | 284713.0 |
| 2024-11-11 07:00:00 | NVDA | Stock | 147.34 | 148.85 | 147.31 | 148.63 | 1317588.0 |
| 2024-11-11 08:00:00 | NVDA | Stock | 148.65 | 148.85 | 146.56 | 148.44 | 2369073.0 |
| 2024-11-11 09:00:00 | NVDA | Stock | 148.47 | 148.85 | 143.88 | 143.96 | 36338873.0 |
| 2024-11-11 10:00:00 | NVDA | Stock | 143.96 | 146.49 | 143.57 | 146.21 | 32966259.0 |
| 2024-11-11 11:00:00 | NVDA | Stock | 146.21 | 146.25 | 145.1 | 145.33 | 14789824.0 |
| 2024-11-11 12:00:00 | NVDA | Stock | 145.32 | 145.6 | 144.695 | 145.32 | 12819929.0 |
| 2024-11-11 13:00:00 | NVDA | Stock | 145.31 | 145.322 | 144.47 | 144.8716 | 11147230.0 |
| 2024-11-11 14:00:00 | NVDA | Stock | 144.88 | 145.29 | 144.63 | 145.06 | 9711077.0 |
| 2024-11-11 15:00:00 | NVDA | Stock | 145.055 | 145.9 | 144.885 | 145.28 | 17223806.0 |
| 2024-11-11 16:00:00 | NVDA | Stock | 145.28 | 145.42 | 145.0 | 145.28 | 14112946.0 |
| 2024-11-11 17:00:00 | NVDA | Stock | 145.28 | 145.42 | 145.25 | 145.31 | 413423.0 |
| 2024-11-11 18:00:00 | NVDA | Stock | 145.31 | 145.36 | 145.0 | 145.02 | 271143.0 |
| 2024-11-11 19:00:00 | NVDA | Stock | 145.01 | 145.03 | 144.75 | 144.76 | 337530.0 |
| 2024-11-11 04:00:00 | AMZN | Stock | 208.76 | 209.11 | 208.66 | 208.84 | 19637.0 |
| 2024-11-11 05:00:00 | AMZN | Stock | 208.82 | 208.9 | 208.4 | 208.4 | 6020.0 |
> showing 50 of 64,297 rows — these rows as CSV