PREVIEW / stock_1hour / 2024-08-22
file: by_date/stock_1hour/2024/2024-08-22.parquet size: 1.3 MB rows: 57,545 symbols: 846
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-22 04:00:00 | AAPL | Stock | 226.2 | 226.61 | 226.2 | 226.45 | 5890.0 |
| 2024-08-22 05:00:00 | AAPL | Stock | 226.57 | 226.59 | 226.4 | 226.4 | 1737.0 |
| 2024-08-22 06:00:00 | AAPL | Stock | 226.46 | 227.57 | 226.45 | 227.57 | 7937.0 |
| 2024-08-22 07:00:00 | AAPL | Stock | 227.12 | 227.75 | 224.8 | 227.74 | 61699.0 |
| 2024-08-22 08:00:00 | AAPL | Stock | 226.44 | 227.8 | 226.1 | 227.5202 | 95603.0 |
| 2024-08-22 09:00:00 | AAPL | Stock | 227.57 | 228.34 | 226.69 | 227.93 | 4263730.0 |
| 2024-08-22 10:00:00 | AAPL | Stock | 227.96 | 228.29 | 226.37 | 226.785 | 3410848.0 |
| 2024-08-22 11:00:00 | AAPL | Stock | 226.785 | 227.21 | 224.92 | 225.51 | 3010510.0 |
| 2024-08-22 12:00:00 | AAPL | Stock | 225.51 | 226.61 | 225.32 | 225.505 | 1977860.0 |
| 2024-08-22 13:00:00 | AAPL | Stock | 225.51 | 225.82 | 224.01 | 224.39 | 2989208.0 |
| 2024-08-22 14:00:00 | AAPL | Stock | 224.4 | 224.93 | 223.9 | 224.4 | 1954302.0 |
| 2024-08-22 15:00:00 | AAPL | Stock | 224.4 | 224.95 | 224.03 | 224.53 | 4709172.0 |
| 2024-08-22 16:00:00 | AAPL | Stock | 224.54 | 224.98 | 224.53 | 224.83 | 5430901.0 |
| 2024-08-22 17:00:00 | AAPL | Stock | 224.85 | 225.08 | 224.53 | 225.08 | 221987.0 |
| 2024-08-22 18:00:00 | AAPL | Stock | 225.08 | 225.19 | 224.95 | 225.05 | 7789.0 |
| 2024-08-22 19:00:00 | AAPL | Stock | 225.04 | 225.1099 | 224.94 | 225.0011 | 13696.0 |
| 2024-08-22 04:00:00 | MSFT | Stock | 423.82 | 424.25 | 423.8 | 424.07 | 946.0 |
| 2024-08-22 05:00:00 | MSFT | Stock | 424.07 | 424.07 | 423.63 | 423.64 | 1467.0 |
| 2024-08-22 06:00:00 | MSFT | Stock | 423.96 | 424.26 | 423.96 | 424.16 | 519.0 |
| 2024-08-22 07:00:00 | MSFT | Stock | 424.14 | 424.54 | 423.91 | 424.2 | 15665.0 |
| 2024-08-22 08:00:00 | MSFT | Stock | 424.1 | 424.5936 | 423.2 | 424.2 | 23085.0 |
| 2024-08-22 09:00:00 | MSFT | Stock | 424.2 | 426.7899 | 423.3 | 425.545 | 1267034.0 |
| 2024-08-22 10:00:00 | MSFT | Stock | 425.56 | 425.93 | 421.4 | 421.51 | 1055849.0 |
| 2024-08-22 11:00:00 | MSFT | Stock | 421.52 | 422.195 | 417.6 | 418.0499 | 1252927.0 |
| 2024-08-22 12:00:00 | MSFT | Stock | 418.01 | 420.21 | 416.95 | 417.07 | 760706.0 |
| 2024-08-22 13:00:00 | MSFT | Stock | 417.068 | 417.49 | 414.64 | 415.03 | 859060.0 |
| 2024-08-22 14:00:00 | MSFT | Stock | 415.01 | 416.66 | 414.83 | 415.4025 | 727217.0 |
| 2024-08-22 15:00:00 | MSFT | Stock | 415.49 | 416.5 | 414.61 | 415.62 | 2151340.0 |
| 2024-08-22 16:00:00 | MSFT | Stock | 415.72 | 416.04 | 415.28 | 415.89 | 4430344.0 |
| 2024-08-22 17:00:00 | MSFT | Stock | 415.98 | 416.31 | 415.55 | 416.31 | 16238.0 |
| 2024-08-22 18:00:00 | MSFT | Stock | 416.33 | 416.8346 | 416.15 | 416.69 | 3960.0 |
| 2024-08-22 19:00:00 | MSFT | Stock | 416.615 | 416.69 | 416.3215 | 416.69 | 922.0 |
| 2024-08-22 04:00:00 | NVDA | Stock | 128.5 | 128.67 | 127.9 | 128.62 | 205765.0 |
| 2024-08-22 05:00:00 | NVDA | Stock | 128.63 | 128.98 | 128.58 | 128.67 | 148398.0 |
| 2024-08-22 06:00:00 | NVDA | Stock | 128.69 | 129.39 | 128.66 | 129.36 | 260519.0 |
| 2024-08-22 07:00:00 | NVDA | Stock | 129.36 | 130.85 | 129.22 | 130.07 | 2255104.0 |
| 2024-08-22 08:00:00 | NVDA | Stock | 130.07 | 131.0 | 128.1 | 129.87 | 4188692.0 |
| 2024-08-22 09:00:00 | NVDA | Stock | 129.87 | 130.75 | 129.25 | 129.89 | 41277477.0 |
| 2024-08-22 10:00:00 | NVDA | Stock | 129.91 | 129.98 | 127.9 | 128.36 | 47773935.0 |
| 2024-08-22 11:00:00 | NVDA | Stock | 128.36 | 129.03 | 124.43 | 125.61 | 52828890.0 |
| 2024-08-22 12:00:00 | NVDA | Stock | 125.6 | 126.9025 | 125.27 | 125.71 | 38869045.0 |
| 2024-08-22 13:00:00 | NVDA | Stock | 125.725 | 126.37 | 123.8 | 124.3769 | 36266183.0 |
| 2024-08-22 14:00:00 | NVDA | Stock | 124.39 | 125.155 | 123.825 | 124.12 | 29491550.0 |
| 2024-08-22 15:00:00 | NVDA | Stock | 124.12 | 125.0 | 123.1 | 123.83 | 52182645.0 |
| 2024-08-22 16:00:00 | NVDA | Stock | 123.9 | 127.0 | 123.64 | 124.33 | 24341882.0 |
| 2024-08-22 17:00:00 | NVDA | Stock | 124.38 | 124.59 | 123.74 | 124.58 | 925289.0 |
| 2024-08-22 18:00:00 | NVDA | Stock | 124.59 | 124.59 | 124.31 | 124.53 | 469271.0 |
| 2024-08-22 19:00:00 | NVDA | Stock | 124.511 | 124.57 | 124.43 | 124.53 | 511089.0 |
| 2024-08-22 04:00:00 | AMZN | Stock | 180.2 | 180.28 | 179.92 | 180.22 | 4825.0 |
| 2024-08-22 05:00:00 | AMZN | Stock | 180.34 | 180.34 | 180.24 | 180.34 | 2645.0 |
> showing 50 of 57,545 rows — these rows as CSV