PREVIEW / stock_1hour / 2025-05-07
file: by_date/stock_1hour/2025/2025-05-07.parquet size: 1.4 MB rows: 61,061 symbols: 419
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-07 04:00:00 | AAPL | Stock | 201.45 | 201.45 | 200.2 | 200.5 | 31596.0 |
| 2025-05-07 05:00:00 | AAPL | Stock | 200.77 | 200.8 | 200.16 | 200.39 | 24221.0 |
| 2025-05-07 06:00:00 | AAPL | Stock | 200.2 | 200.68 | 200.12 | 200.5 | 18290.0 |
| 2025-05-07 07:00:00 | AAPL | Stock | 200.59 | 201.05 | 200.4 | 200.6 | 41360.0 |
| 2025-05-07 08:00:00 | AAPL | Stock | 200.41 | 201.0199 | 199.8 | 200.0499 | 189689.0 |
| 2025-05-07 09:00:00 | AAPL | Stock | 200.0 | 200.23 | 197.35 | 197.805 | 4350429.0 |
| 2025-05-07 10:00:00 | AAPL | Stock | 197.805 | 199.44 | 197.44 | 197.47 | 3860231.0 |
| 2025-05-07 11:00:00 | AAPL | Stock | 197.48 | 197.51 | 193.25 | 195.105 | 10662440.0 |
| 2025-05-07 12:00:00 | AAPL | Stock | 195.1 | 195.78 | 194.51 | 195.621 | 4032702.0 |
| 2025-05-07 13:00:00 | AAPL | Stock | 195.615 | 195.76 | 194.23 | 194.66 | 2845516.0 |
| 2025-05-07 14:00:00 | AAPL | Stock | 194.615 | 195.71 | 193.3 | 195.44 | 4066133.0 |
| 2025-05-07 15:00:00 | AAPL | Stock | 195.44 | 197.4699 | 194.12 | 196.22 | 6385081.0 |
| 2025-05-07 16:00:00 | AAPL | Stock | 196.25 | 196.62 | 195.75 | 196.52 | 14208413.0 |
| 2025-05-07 17:00:00 | AAPL | Stock | 196.58 | 196.5898 | 196.2 | 196.2499 | 70669.0 |
| 2025-05-07 18:00:00 | AAPL | Stock | 196.2 | 196.39 | 196.06 | 196.1232 | 31708.0 |
| 2025-05-07 19:00:00 | AAPL | Stock | 196.1206 | 196.4971 | 196.1206 | 196.45 | 37726.0 |
| 2025-05-07 04:00:00 | MSFT | Stock | 435.79 | 435.98 | 433.97 | 434.38 | 6104.0 |
| 2025-05-07 05:00:00 | MSFT | Stock | 434.72 | 434.8 | 433.94 | 434.47 | 5064.0 |
| 2025-05-07 06:00:00 | MSFT | Stock | 434.25 | 434.94 | 434.0 | 434.42 | 6384.0 |
| 2025-05-07 07:00:00 | MSFT | Stock | 434.6 | 435.71 | 434.5 | 434.89 | 5174.0 |
| 2025-05-07 08:00:00 | MSFT | Stock | 435.46 | 435.74 | 433.22 | 433.6 | 23925.0 |
| 2025-05-07 09:00:00 | MSFT | Stock | 433.5 | 435.07 | 432.33 | 434.6 | 1576205.0 |
| 2025-05-07 10:00:00 | MSFT | Stock | 434.68 | 435.71 | 431.1103 | 432.005 | 1322687.0 |
| 2025-05-07 11:00:00 | MSFT | Stock | 432.015 | 434.54 | 431.27 | 433.735 | 1301857.0 |
| 2025-05-07 12:00:00 | MSFT | Stock | 433.68 | 436.08 | 433.31 | 435.86 | 643679.0 |
| 2025-05-07 13:00:00 | MSFT | Stock | 435.92 | 436.19 | 433.9076 | 434.65 | 549451.0 |
| 2025-05-07 14:00:00 | MSFT | Stock | 434.62 | 436.25 | 432.15 | 436.125 | 895307.0 |
| 2025-05-07 15:00:00 | MSFT | Stock | 436.125 | 438.12 | 433.0 | 433.49 | 1833579.0 |
| 2025-05-07 16:00:00 | MSFT | Stock | 433.22 | 435.7553 | 433.22 | 434.6 | 7461801.0 |
| 2025-05-07 17:00:00 | MSFT | Stock | 434.6 | 435.4213 | 433.35 | 434.29 | 26293.0 |
| 2025-05-07 18:00:00 | MSFT | Stock | 434.29 | 434.65 | 433.8 | 433.8 | 1379.0 |
| 2025-05-07 19:00:00 | MSFT | Stock | 434.81 | 435.1 | 434.26 | 435.1 | 2193.0 |
| 2025-05-07 04:00:00 | NVDA | Stock | 113.92 | 114.93 | 113.64 | 114.12 | 291249.0 |
| 2025-05-07 05:00:00 | NVDA | Stock | 114.13 | 114.21 | 113.8 | 113.98 | 139031.0 |
| 2025-05-07 06:00:00 | NVDA | Stock | 113.9 | 114.13 | 113.72 | 113.96 | 187523.0 |
| 2025-05-07 07:00:00 | NVDA | Stock | 113.95 | 114.35 | 113.92 | 114.11 | 405926.0 |
| 2025-05-07 08:00:00 | NVDA | Stock | 114.0 | 114.46 | 113.6 | 113.76 | 1268514.0 |
| 2025-05-07 09:00:00 | NVDA | Stock | 113.75 | 113.75 | 112.615 | 113.26 | 19391793.0 |
| 2025-05-07 10:00:00 | NVDA | Stock | 113.27 | 113.67 | 112.95 | 113.1803 | 16890633.0 |
| 2025-05-07 11:00:00 | NVDA | Stock | 113.18 | 114.22 | 112.9301 | 114.01 | 14674271.0 |
| 2025-05-07 12:00:00 | NVDA | Stock | 114.0 | 114.1 | 113.5 | 113.9298 | 9173024.0 |
| 2025-05-07 13:00:00 | NVDA | Stock | 113.92 | 114.14 | 113.15 | 113.335 | 10494926.0 |
| 2025-05-07 14:00:00 | NVDA | Stock | 113.33 | 113.825 | 112.2818 | 113.76 | 19330917.0 |
| 2025-05-07 15:00:00 | NVDA | Stock | 113.75 | 117.68 | 113.15 | 117.015 | 63950947.0 |
| 2025-05-07 16:00:00 | NVDA | Stock | 117.0 | 117.25 | 116.3 | 116.4 | 19780395.0 |
| 2025-05-07 17:00:00 | NVDA | Stock | 116.38 | 116.7 | 116.1814 | 116.29 | 938704.0 |
| 2025-05-07 18:00:00 | NVDA | Stock | 116.3 | 116.54 | 116.14 | 116.37 | 463999.0 |
| 2025-05-07 19:00:00 | NVDA | Stock | 116.37 | 116.95 | 116.37 | 116.87 | 623877.0 |
| 2025-05-07 04:00:00 | AMZN | Stock | 187.25 | 187.44 | 186.7 | 187.11 | 20530.0 |
| 2025-05-07 05:00:00 | AMZN | Stock | 187.12 | 187.21 | 186.6 | 186.81 | 10778.0 |
> showing 50 of 61,061 rows — these rows as CSV