PREVIEW / stock_1hour / 2024-07-09
file: by_date/stock_1hour/2024/2024-07-09.parquet size: 1.3 MB rows: 57,911 symbols: 904
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-07-09 04:00:00 | AAPL | Stock | 228.27 | 228.27 | 227.43 | 227.55 | 18567.0 |
| 2024-07-09 05:00:00 | AAPL | Stock | 227.74 | 227.83 | 227.38 | 227.47 | 11116.0 |
| 2024-07-09 06:00:00 | AAPL | Stock | 227.63 | 227.74 | 227.57 | 227.74 | 3217.0 |
| 2024-07-09 07:00:00 | AAPL | Stock | 227.74 | 228.0 | 227.5 | 227.53 | 30757.0 |
| 2024-07-09 08:00:00 | AAPL | Stock | 227.75 | 228.75 | 227.46 | 228.3002 | 161200.0 |
| 2024-07-09 09:00:00 | AAPL | Stock | 228.3 | 228.36 | 226.3721 | 228.175 | 5708280.0 |
| 2024-07-09 10:00:00 | AAPL | Stock | 228.175 | 229.4 | 227.3 | 228.42 | 8800573.0 |
| 2024-07-09 11:00:00 | AAPL | Stock | 228.43 | 228.4691 | 227.465 | 228.2001 | 3707008.0 |
| 2024-07-09 12:00:00 | AAPL | Stock | 228.21 | 228.54 | 227.71 | 228.5101 | 3083919.0 |
| 2024-07-09 13:00:00 | AAPL | Stock | 228.525 | 228.7254 | 227.85 | 228.1 | 2600049.0 |
| 2024-07-09 14:00:00 | AAPL | Stock | 228.1 | 228.535 | 227.88 | 228.29 | 2731521.0 |
| 2024-07-09 15:00:00 | AAPL | Stock | 228.28 | 228.78 | 228.16 | 228.7 | 5453637.0 |
| 2024-07-09 16:00:00 | AAPL | Stock | 228.68 | 228.78 | 228.62 | 228.62 | 5889666.0 |
| 2024-07-09 17:00:00 | AAPL | Stock | 228.6196 | 228.73 | 228.42 | 228.68 | 32079.0 |
| 2024-07-09 18:00:00 | AAPL | Stock | 228.68 | 228.99 | 228.6285 | 228.9365 | 52829.0 |
| 2024-07-09 19:00:00 | AAPL | Stock | 228.95 | 229.0 | 228.85 | 229.0 | 30573.0 |
| 2024-07-09 04:00:00 | MSFT | Stock | 466.12 | 467.56 | 466.12 | 467.17 | 656.0 |
| 2024-07-09 05:00:00 | MSFT | Stock | 467.02 | 467.33 | 467.02 | 467.33 | 200.0 |
| 2024-07-09 06:00:00 | MSFT | Stock | 467.23 | 467.29 | 467.21 | 467.26 | 1328.0 |
| 2024-07-09 07:00:00 | MSFT | Stock | 467.29 | 467.59 | 467.13 | 467.3 | 3887.0 |
| 2024-07-09 08:00:00 | MSFT | Stock | 467.2891 | 468.2 | 466.73 | 466.88 | 18501.0 |
| 2024-07-09 09:00:00 | MSFT | Stock | 466.82 | 467.35 | 463.82 | 464.62 | 1457788.0 |
| 2024-07-09 10:00:00 | MSFT | Stock | 464.62 | 464.9 | 463.42 | 463.55 | 1369883.0 |
| 2024-07-09 11:00:00 | MSFT | Stock | 463.5525 | 464.06 | 461.41 | 461.745 | 1099090.0 |
| 2024-07-09 12:00:00 | MSFT | Stock | 461.76 | 462.17 | 459.31 | 460.01 | 1335401.0 |
| 2024-07-09 13:00:00 | MSFT | Stock | 460.015 | 460.42 | 459.36 | 460.275 | 914421.0 |
| 2024-07-09 14:00:00 | MSFT | Stock | 460.2805 | 460.45 | 458.91 | 459.385 | 1036140.0 |
| 2024-07-09 15:00:00 | MSFT | Stock | 459.395 | 460.052 | 458.0 | 459.53 | 2010974.0 |
| 2024-07-09 16:00:00 | MSFT | Stock | 459.54 | 460.4 | 459.54 | 460.24 | 2789557.0 |
| 2024-07-09 17:00:00 | MSFT | Stock | 460.2 | 460.37 | 460.1304 | 460.34 | 3972.0 |
| 2024-07-09 18:00:00 | MSFT | Stock | 460.4 | 460.45 | 460.18 | 460.4 | 1924.0 |
| 2024-07-09 19:00:00 | MSFT | Stock | 460.45 | 460.45 | 460.05 | 460.1 | 7858.0 |
| 2024-07-09 04:00:00 | NVDA | Stock | 128.79 | 129.46 | 128.73 | 129.36 | 286699.0 |
| 2024-07-09 05:00:00 | NVDA | Stock | 129.37 | 129.85 | 129.32 | 129.55 | 221970.0 |
| 2024-07-09 06:00:00 | NVDA | Stock | 129.56 | 129.85 | 129.4 | 129.77 | 227706.0 |
| 2024-07-09 07:00:00 | NVDA | Stock | 129.76 | 130.45 | 129.5 | 130.05 | 1416906.0 |
| 2024-07-09 08:00:00 | NVDA | Stock | 129.91 | 130.45 | 128.5 | 130.18 | 2824483.0 |
| 2024-07-09 09:00:00 | NVDA | Stock | 130.18 | 132.79 | 130.16 | 132.4306 | 46444735.0 |
| 2024-07-09 10:00:00 | NVDA | Stock | 132.445 | 133.82 | 131.82 | 132.18 | 54753540.0 |
| 2024-07-09 11:00:00 | NVDA | Stock | 132.17 | 132.5 | 130.88 | 131.4198 | 28369493.0 |
| 2024-07-09 12:00:00 | NVDA | Stock | 131.42 | 131.69 | 128.65 | 130.1997 | 33518134.0 |
| 2024-07-09 13:00:00 | NVDA | Stock | 130.19 | 130.57 | 129.414 | 130.2 | 21736624.0 |
| 2024-07-09 14:00:00 | NVDA | Stock | 130.19 | 131.15 | 129.93 | 131.1099 | 17697275.0 |
| 2024-07-09 15:00:00 | NVDA | Stock | 131.1001 | 131.59 | 130.5 | 131.41 | 27175095.0 |
| 2024-07-09 16:00:00 | NVDA | Stock | 131.43 | 131.6 | 131.07 | 131.42 | 15368285.0 |
| 2024-07-09 17:00:00 | NVDA | Stock | 131.42 | 131.75 | 131.28 | 131.62 | 598661.0 |
| 2024-07-09 18:00:00 | NVDA | Stock | 131.61 | 132.3 | 131.59 | 132.19 | 994956.0 |
| 2024-07-09 19:00:00 | NVDA | Stock | 132.21 | 132.3299 | 132.1 | 132.21 | 680529.0 |
| 2024-07-09 04:00:00 | AMZN | Stock | 199.62 | 199.78 | 199.62 | 199.77 | 4472.0 |
| 2024-07-09 05:00:00 | AMZN | Stock | 199.69 | 199.8 | 199.69 | 199.8 | 2804.0 |
> showing 50 of 57,911 rows — these rows as CSV