PREVIEW / stock_1hour / 2025-05-08
file: by_date/stock_1hour/2025/2025-05-08.parquet size: 1.4 MB rows: 63,124 symbols: 422
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 |
|---|---|---|---|---|---|---|---|
| 2025-05-08 04:00:00 | AAPL | Stock | 197.98 | 198.76 | 197.85 | 198.75 | 32419.0 |
| 2025-05-08 05:00:00 | AAPL | Stock | 198.73 | 198.99 | 198.49 | 198.8 | 33921.0 |
| 2025-05-08 06:00:00 | AAPL | Stock | 198.82 | 199.16 | 198.74 | 198.99 | 43551.0 |
| 2025-05-08 07:00:00 | AAPL | Stock | 198.97 | 199.0 | 197.91 | 198.31 | 98624.0 |
| 2025-05-08 08:00:00 | AAPL | Stock | 198.81 | 199.0 | 197.19 | 197.52 | 283199.0 |
| 2025-05-08 09:00:00 | AAPL | Stock | 197.598 | 198.13 | 196.08 | 196.15 | 3828558.0 |
| 2025-05-08 10:00:00 | AAPL | Stock | 196.17 | 197.2497 | 194.6796 | 196.62 | 5799520.0 |
| 2025-05-08 11:00:00 | AAPL | Stock | 196.58 | 199.75 | 196.41 | 199.34 | 5100923.0 |
| 2025-05-08 12:00:00 | AAPL | Stock | 199.34 | 200.05 | 199.0101 | 199.72 | 3295457.0 |
| 2025-05-08 13:00:00 | AAPL | Stock | 199.72 | 199.85 | 198.3033 | 198.3213 | 2378991.0 |
| 2025-05-08 14:00:00 | AAPL | Stock | 198.32 | 199.2593 | 198.08 | 198.62 | 2654140.0 |
| 2025-05-08 15:00:00 | AAPL | Stock | 198.62 | 199.688 | 197.164 | 197.4 | 5716144.0 |
| 2025-05-08 16:00:00 | AAPL | Stock | 197.49 | 197.73 | 197.2 | 197.29 | 8416588.0 |
| 2025-05-08 17:00:00 | AAPL | Stock | 197.3 | 197.6501 | 197.2 | 197.4994 | 37453.0 |
| 2025-05-08 18:00:00 | AAPL | Stock | 197.5 | 197.5 | 197.37 | 197.4982 | 24460.0 |
| 2025-05-08 19:00:00 | AAPL | Stock | 197.5 | 197.5981 | 197.3545 | 197.51 | 27294.0 |
| 2025-05-08 04:00:00 | MSFT | Stock | 437.65 | 438.15 | 437.03 | 437.5 | 14255.0 |
| 2025-05-08 05:00:00 | MSFT | Stock | 437.4 | 437.61 | 436.81 | 436.81 | 19256.0 |
| 2025-05-08 06:00:00 | MSFT | Stock | 436.68 | 437.5 | 436.5 | 437.5 | 7371.0 |
| 2025-05-08 07:00:00 | MSFT | Stock | 437.51 | 438.29 | 437.13 | 437.16 | 15968.0 |
| 2025-05-08 08:00:00 | MSFT | Stock | 437.45 | 438.2777 | 435.59 | 436.04 | 39880.0 |
| 2025-05-08 09:00:00 | MSFT | Stock | 436.2 | 441.1 | 436.0154 | 438.01 | 2007615.0 |
| 2025-05-08 10:00:00 | MSFT | Stock | 437.9701 | 438.665 | 435.66 | 437.0 | 974078.0 |
| 2025-05-08 11:00:00 | MSFT | Stock | 436.945 | 443.49 | 436.16 | 441.785 | 1785996.0 |
| 2025-05-08 12:00:00 | MSFT | Stock | 441.74 | 443.45 | 441.7 | 443.062 | 1076350.0 |
| 2025-05-08 13:00:00 | MSFT | Stock | 443.07 | 443.67 | 441.8 | 442.0 | 886975.0 |
| 2025-05-08 14:00:00 | MSFT | Stock | 442.04 | 443.375 | 441.92 | 442.08 | 674628.0 |
| 2025-05-08 15:00:00 | MSFT | Stock | 442.08 | 442.9 | 437.67 | 438.24 | 2167888.0 |
| 2025-05-08 16:00:00 | MSFT | Stock | 438.43 | 438.43 | 436.65 | 436.75 | 4638961.0 |
| 2025-05-08 17:00:00 | MSFT | Stock | 437.29 | 438.23 | 437.15 | 438.0645 | 6189.0 |
| 2025-05-08 18:00:00 | MSFT | Stock | 438.17 | 438.17 | 437.3801 | 438.15 | 3403.0 |
| 2025-05-08 19:00:00 | MSFT | Stock | 438.15 | 438.15 | 437.0 | 437.053 | 4800.0 |
| 2025-05-08 04:00:00 | NVDA | Stock | 119.4 | 119.55 | 118.77 | 119.2 | 790809.0 |
| 2025-05-08 05:00:00 | NVDA | Stock | 119.2 | 119.35 | 118.79 | 119.17 | 588083.0 |
| 2025-05-08 06:00:00 | NVDA | Stock | 119.19 | 119.42 | 118.81 | 119.02 | 602912.0 |
| 2025-05-08 07:00:00 | NVDA | Stock | 119.0 | 119.25 | 118.51 | 118.72 | 1001578.0 |
| 2025-05-08 08:00:00 | NVDA | Stock | 119.05 | 120.83 | 118.34 | 118.72 | 4300361.0 |
| 2025-05-08 09:00:00 | NVDA | Stock | 118.7201 | 119.0 | 116.49 | 117.44 | 29782658.0 |
| 2025-05-08 10:00:00 | NVDA | Stock | 117.44 | 117.64 | 115.85 | 116.145 | 27256595.0 |
| 2025-05-08 11:00:00 | NVDA | Stock | 116.145 | 118.38 | 115.99 | 117.9899 | 27369620.0 |
| 2025-05-08 12:00:00 | NVDA | Stock | 117.9807 | 118.45 | 117.73 | 118.175 | 15817358.0 |
| 2025-05-08 13:00:00 | NVDA | Stock | 118.1713 | 118.2001 | 117.53 | 117.865 | 11751649.0 |
| 2025-05-08 14:00:00 | NVDA | Stock | 117.875 | 118.38 | 117.81 | 118.02 | 11465078.0 |
| 2025-05-08 15:00:00 | NVDA | Stock | 118.01 | 118.68 | 117.295 | 117.37 | 21962697.0 |
| 2025-05-08 16:00:00 | NVDA | Stock | 117.37 | 117.45 | 116.7554 | 117.16 | 15437611.0 |
| 2025-05-08 17:00:00 | NVDA | Stock | 117.1891 | 117.4 | 117.1 | 117.33 | 315195.0 |
| 2025-05-08 18:00:00 | NVDA | Stock | 117.33 | 117.35 | 117.2 | 117.3 | 137899.0 |
| 2025-05-08 19:00:00 | NVDA | Stock | 117.3 | 117.33 | 117.0 | 117.0481 | 294729.0 |
| 2025-05-08 04:00:00 | AMZN | Stock | 191.25 | 191.99 | 191.03 | 191.89 | 33881.0 |
| 2025-05-08 05:00:00 | AMZN | Stock | 191.97 | 192.48 | 191.8 | 192.28 | 27437.0 |
> showing 50 of 63,124 rows — these rows as CSV