PREVIEW / stock_1hour / 2024-07-23
file: by_date/stock_1hour/2024/2024-07-23.parquet size: 1.3 MB rows: 59,109 symbols: 909
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-23 04:00:00 | AAPL | Stock | 224.24 | 224.24 | 223.1 | 223.38 | 15203.0 |
| 2024-07-23 05:00:00 | AAPL | Stock | 223.3 | 223.83 | 223.3 | 223.81 | 8350.0 |
| 2024-07-23 06:00:00 | AAPL | Stock | 223.7 | 223.79 | 223.45 | 223.54 | 8951.0 |
| 2024-07-23 07:00:00 | AAPL | Stock | 223.82 | 224.67 | 223.82 | 224.28 | 16305.0 |
| 2024-07-23 08:00:00 | AAPL | Stock | 224.07 | 224.5 | 223.38 | 223.8 | 71468.0 |
| 2024-07-23 09:00:00 | AAPL | Stock | 223.78 | 224.69 | 222.68 | 224.15 | 3768189.0 |
| 2024-07-23 10:00:00 | AAPL | Stock | 224.175 | 225.14 | 223.98 | 224.65 | 3358506.0 |
| 2024-07-23 11:00:00 | AAPL | Stock | 224.67 | 226.94 | 224.55 | 226.61 | 4810222.0 |
| 2024-07-23 12:00:00 | AAPL | Stock | 226.63 | 226.6499 | 225.08 | 225.254 | 2190513.0 |
| 2024-07-23 13:00:00 | AAPL | Stock | 225.26 | 225.38 | 224.55 | 225.008 | 2263599.0 |
| 2024-07-23 14:00:00 | AAPL | Stock | 225.0 | 225.04 | 224.328 | 224.78 | 2068045.0 |
| 2024-07-23 15:00:00 | AAPL | Stock | 224.78 | 225.28 | 224.32 | 224.98 | 4435422.0 |
| 2024-07-23 16:00:00 | AAPL | Stock | 224.97 | 225.2392 | 224.51 | 224.93 | 4768529.0 |
| 2024-07-23 17:00:00 | AAPL | Stock | 224.98 | 225.01 | 224.51 | 224.5626 | 195009.0 |
| 2024-07-23 18:00:00 | AAPL | Stock | 224.56 | 224.95 | 224.1927 | 224.76 | 52714.0 |
| 2024-07-23 19:00:00 | AAPL | Stock | 224.6 | 224.83 | 224.2781 | 224.2781 | 37630.0 |
| 2024-07-23 04:00:00 | MSFT | Stock | 442.8 | 442.8 | 440.88 | 441.96 | 3546.0 |
| 2024-07-23 05:00:00 | MSFT | Stock | 442.78 | 443.89 | 442.78 | 443.68 | 1200.0 |
| 2024-07-23 06:00:00 | MSFT | Stock | 444.02 | 444.51 | 444.0 | 444.22 | 2299.0 |
| 2024-07-23 07:00:00 | MSFT | Stock | 444.07 | 444.44 | 444.0 | 444.0 | 7951.0 |
| 2024-07-23 08:00:00 | MSFT | Stock | 444.29 | 444.48 | 441.41 | 444.0 | 17526.0 |
| 2024-07-23 09:00:00 | MSFT | Stock | 444.18 | 447.8 | 443.23 | 445.95 | 1175223.0 |
| 2024-07-23 10:00:00 | MSFT | Stock | 446.0 | 446.92 | 444.18 | 445.76 | 864620.0 |
| 2024-07-23 11:00:00 | MSFT | Stock | 445.74 | 448.39 | 445.74 | 446.87 | 756697.0 |
| 2024-07-23 12:00:00 | MSFT | Stock | 446.8 | 446.8 | 443.8 | 444.46 | 618271.0 |
| 2024-07-23 13:00:00 | MSFT | Stock | 444.45 | 444.97 | 443.48 | 444.82 | 524741.0 |
| 2024-07-23 14:00:00 | MSFT | Stock | 444.83 | 445.36 | 443.88 | 444.32 | 447550.0 |
| 2024-07-23 15:00:00 | MSFT | Stock | 444.32 | 444.92 | 443.1 | 444.81 | 1093550.0 |
| 2024-07-23 16:00:00 | MSFT | Stock | 444.85 | 447.3 | 443.06 | 446.24 | 2994568.0 |
| 2024-07-23 17:00:00 | MSFT | Stock | 446.09 | 446.09 | 444.0 | 444.0 | 29345.0 |
| 2024-07-23 18:00:00 | MSFT | Stock | 443.85 | 444.77 | 443.4 | 443.7742 | 14706.0 |
| 2024-07-23 19:00:00 | MSFT | Stock | 444.47 | 444.68 | 443.71 | 443.71 | 4043.0 |
| 2024-07-23 04:00:00 | NVDA | Stock | 122.45 | 122.95 | 121.85 | 122.3 | 323613.0 |
| 2024-07-23 05:00:00 | NVDA | Stock | 122.3 | 123.0 | 122.3 | 122.75 | 195207.0 |
| 2024-07-23 06:00:00 | NVDA | Stock | 122.75 | 123.03 | 122.56 | 122.76 | 118727.0 |
| 2024-07-23 07:00:00 | NVDA | Stock | 122.76 | 123.84 | 122.68 | 123.4 | 773672.0 |
| 2024-07-23 08:00:00 | NVDA | Stock | 122.97 | 123.84 | 122.1095 | 123.1397 | 1923263.0 |
| 2024-07-23 09:00:00 | NVDA | Stock | 123.07 | 124.69 | 122.51 | 124.152 | 24059817.0 |
| 2024-07-23 10:00:00 | NVDA | Stock | 124.17 | 124.33 | 122.9 | 123.305 | 27117692.0 |
| 2024-07-23 11:00:00 | NVDA | Stock | 123.3 | 124.43 | 123.0101 | 123.43 | 20379932.0 |
| 2024-07-23 12:00:00 | NVDA | Stock | 123.41 | 123.88 | 122.51 | 122.871 | 16596991.0 |
| 2024-07-23 13:00:00 | NVDA | Stock | 122.87 | 123.13 | 122.43 | 122.915 | 12944859.0 |
| 2024-07-23 14:00:00 | NVDA | Stock | 122.915 | 123.01 | 122.1 | 122.54 | 11939537.0 |
| 2024-07-23 15:00:00 | NVDA | Stock | 122.535 | 123.05 | 122.22 | 122.43 | 17642883.0 |
| 2024-07-23 16:00:00 | NVDA | Stock | 122.59 | 123.38 | 122.23 | 123.13 | 15692744.0 |
| 2024-07-23 17:00:00 | NVDA | Stock | 123.13 | 123.32 | 120.84 | 120.95 | 2035537.0 |
| 2024-07-23 18:00:00 | NVDA | Stock | 120.92 | 121.29 | 120.08 | 120.73 | 1327022.0 |
| 2024-07-23 19:00:00 | NVDA | Stock | 120.75 | 121.05 | 120.5 | 120.61 | 643433.0 |
| 2024-07-23 04:00:00 | AMZN | Stock | 182.86 | 183.05 | 182.25 | 182.83 | 27002.0 |
| 2024-07-23 05:00:00 | AMZN | Stock | 182.88 | 183.14 | 182.87 | 183.14 | 3318.0 |
> showing 50 of 59,109 rows — these rows as CSV