PREVIEW / stock_1hour / 2024-08-16
file: by_date/stock_1hour/2024/2024-08-16.parquet size: 1.3 MB rows: 58,083 symbols: 843
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-16 04:00:00 | AAPL | Stock | 225.61 | 225.63 | 225.3 | 225.3 | 18856.0 |
| 2024-08-16 05:00:00 | AAPL | Stock | 225.38 | 225.46 | 225.31 | 225.4 | 5913.0 |
| 2024-08-16 06:00:00 | AAPL | Stock | 225.37 | 225.42 | 225.0 | 225.2 | 7587.0 |
| 2024-08-16 07:00:00 | AAPL | Stock | 225.27 | 225.39 | 224.9 | 224.9 | 19902.0 |
| 2024-08-16 08:00:00 | AAPL | Stock | 224.9 | 225.64 | 223.52 | 224.04 | 139779.0 |
| 2024-08-16 09:00:00 | AAPL | Stock | 223.9994 | 224.9 | 223.04 | 224.115 | 5338239.0 |
| 2024-08-16 10:00:00 | AAPL | Stock | 224.08 | 225.03 | 223.9661 | 224.16 | 3123255.0 |
| 2024-08-16 11:00:00 | AAPL | Stock | 224.15 | 226.04 | 223.995 | 225.915 | 3637015.0 |
| 2024-08-16 12:00:00 | AAPL | Stock | 225.91 | 226.8271 | 225.78 | 226.6073 | 3506396.0 |
| 2024-08-16 13:00:00 | AAPL | Stock | 226.61 | 226.67 | 225.96 | 226.14 | 1872240.0 |
| 2024-08-16 14:00:00 | AAPL | Stock | 226.14 | 226.18 | 225.63 | 226.13 | 1589544.0 |
| 2024-08-16 15:00:00 | AAPL | Stock | 226.124 | 226.21 | 225.54 | 226.1 | 3464354.0 |
| 2024-08-16 16:00:00 | AAPL | Stock | 226.07 | 226.21 | 226.05 | 226.15 | 5843169.0 |
| 2024-08-16 17:00:00 | AAPL | Stock | 226.15 | 226.25 | 226.05 | 226.22 | 262569.0 |
| 2024-08-16 18:00:00 | AAPL | Stock | 226.22 | 226.22 | 225.9807 | 226.0 | 23705.0 |
| 2024-08-16 19:00:00 | AAPL | Stock | 226.02 | 226.02 | 225.6 | 225.95 | 17861.0 |
| 2024-08-16 04:00:00 | MSFT | Stock | 422.02 | 423.08 | 422.02 | 422.57 | 5192.0 |
| 2024-08-16 05:00:00 | MSFT | Stock | 422.65 | 422.83 | 422.58 | 422.7 | 1948.0 |
| 2024-08-16 06:00:00 | MSFT | Stock | 422.52 | 422.52 | 421.74 | 421.74 | 4303.0 |
| 2024-08-16 07:00:00 | MSFT | Stock | 421.74 | 421.74 | 420.5 | 420.5 | 10802.0 |
| 2024-08-16 08:00:00 | MSFT | Stock | 421.5 | 422.2462 | 419.01 | 419.846 | 39349.0 |
| 2024-08-16 09:00:00 | MSFT | Stock | 419.8 | 421.84 | 417.3 | 417.8 | 2427008.0 |
| 2024-08-16 10:00:00 | MSFT | Stock | 417.79 | 418.98 | 417.43 | 417.79 | 1299983.0 |
| 2024-08-16 11:00:00 | MSFT | Stock | 417.79 | 418.95 | 417.31 | 418.59 | 836996.0 |
| 2024-08-16 12:00:00 | MSFT | Stock | 418.5 | 419.65 | 418.2232 | 419.555 | 643207.0 |
| 2024-08-16 13:00:00 | MSFT | Stock | 419.56 | 419.68 | 418.52 | 419.08 | 515874.0 |
| 2024-08-16 14:00:00 | MSFT | Stock | 419.08 | 419.14 | 418.41 | 418.94 | 587066.0 |
| 2024-08-16 15:00:00 | MSFT | Stock | 418.9268 | 419.2375 | 418.31 | 418.54 | 1107618.0 |
| 2024-08-16 16:00:00 | MSFT | Stock | 418.47 | 418.59 | 418.0 | 418.1016 | 3511682.0 |
| 2024-08-16 17:00:00 | MSFT | Stock | 418.14 | 418.19 | 418.0 | 418.1 | 2884.0 |
| 2024-08-16 18:00:00 | MSFT | Stock | 418.1 | 418.19 | 417.9989 | 417.9992 | 4092.0 |
| 2024-08-16 19:00:00 | MSFT | Stock | 417.99 | 418.0 | 417.75 | 417.75 | 6553.0 |
| 2024-08-16 04:00:00 | NVDA | Stock | 123.6 | 123.84 | 123.06 | 123.51 | 660897.0 |
| 2024-08-16 05:00:00 | NVDA | Stock | 123.49 | 123.8 | 123.44 | 123.6 | 269012.0 |
| 2024-08-16 06:00:00 | NVDA | Stock | 123.59 | 123.6 | 123.2 | 123.48 | 311017.0 |
| 2024-08-16 07:00:00 | NVDA | Stock | 123.48 | 123.66 | 122.95 | 122.98 | 1185039.0 |
| 2024-08-16 08:00:00 | NVDA | Stock | 123.0 | 124.01 | 120.43 | 121.48 | 7149455.0 |
| 2024-08-16 09:00:00 | NVDA | Stock | 121.48 | 123.9 | 121.08 | 122.88 | 45701191.0 |
| 2024-08-16 10:00:00 | NVDA | Stock | 122.85 | 125.0 | 122.33 | 122.95 | 62050479.0 |
| 2024-08-16 11:00:00 | NVDA | Stock | 122.96 | 123.66 | 122.49 | 123.48 | 31804753.0 |
| 2024-08-16 12:00:00 | NVDA | Stock | 123.48 | 124.5699 | 123.18 | 124.4342 | 24294205.0 |
| 2024-08-16 13:00:00 | NVDA | Stock | 124.4325 | 124.755 | 124.14 | 124.515 | 20809838.0 |
| 2024-08-16 14:00:00 | NVDA | Stock | 124.52 | 124.7 | 124.03 | 124.5799 | 18386259.0 |
| 2024-08-16 15:00:00 | NVDA | Stock | 124.56 | 124.6 | 123.85 | 124.58 | 27267591.0 |
| 2024-08-16 16:00:00 | NVDA | Stock | 124.57 | 124.58 | 121.15 | 124.45 | 15270935.0 |
| 2024-08-16 17:00:00 | NVDA | Stock | 124.44 | 124.58 | 124.35 | 124.41 | 306271.0 |
| 2024-08-16 18:00:00 | NVDA | Stock | 124.4 | 124.44 | 124.34 | 124.34 | 202987.0 |
| 2024-08-16 19:00:00 | NVDA | Stock | 124.35 | 124.35 | 124.16 | 124.23 | 496040.0 |
| 2024-08-16 04:00:00 | AMZN | Stock | 178.15 | 178.67 | 177.73 | 178.67 | 21607.0 |
| 2024-08-16 05:00:00 | AMZN | Stock | 178.62 | 178.84 | 178.48 | 178.48 | 14700.0 |
> showing 50 of 58,083 rows — these rows as CSV