PREVIEW / stock_1hour / 2025-01-15
file: by_date/stock_1hour/2025/2025-01-15.parquet size: 1.5 MB rows: 64,459 symbols: 591
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-01-15 04:00:00 | AAPL | Stock | 233.79 | 233.99 | 233.65 | 233.78 | 1488.0 |
| 2025-01-15 05:00:00 | AAPL | Stock | 233.67 | 233.91 | 233.63 | 233.91 | 3956.0 |
| 2025-01-15 06:00:00 | AAPL | Stock | 233.94 | 234.6 | 233.94 | 234.51 | 7511.0 |
| 2025-01-15 07:00:00 | AAPL | Stock | 234.42 | 234.51 | 233.75 | 233.75 | 20595.0 |
| 2025-01-15 08:00:00 | AAPL | Stock | 234.3172 | 236.38 | 233.4 | 235.2 | 215163.0 |
| 2025-01-15 09:00:00 | AAPL | Stock | 235.2499 | 238.121 | 234.11 | 237.35 | 4229678.0 |
| 2025-01-15 10:00:00 | AAPL | Stock | 237.37 | 238.39 | 237.36 | 237.975 | 3798575.0 |
| 2025-01-15 11:00:00 | AAPL | Stock | 237.965 | 238.54 | 236.5024 | 236.775 | 2728702.0 |
| 2025-01-15 12:00:00 | AAPL | Stock | 236.78 | 237.74 | 236.67 | 237.19 | 1928796.0 |
| 2025-01-15 13:00:00 | AAPL | Stock | 237.2 | 237.7247 | 236.97 | 237.58 | 1459492.0 |
| 2025-01-15 14:00:00 | AAPL | Stock | 237.58 | 238.0342 | 237.43 | 237.81 | 1558588.0 |
| 2025-01-15 15:00:00 | AAPL | Stock | 237.83 | 238.96 | 237.35 | 237.88 | 4885606.0 |
| 2025-01-15 16:00:00 | AAPL | Stock | 237.84 | 238.09 | 237.7 | 237.95 | 9576973.0 |
| 2025-01-15 17:00:00 | AAPL | Stock | 238.0 | 238.3581 | 237.94 | 238.2548 | 11562.0 |
| 2025-01-15 18:00:00 | AAPL | Stock | 238.06 | 238.48 | 238.0 | 238.2735 | 13026.0 |
| 2025-01-15 19:00:00 | AAPL | Stock | 238.41 | 238.71 | 238.3 | 238.5993 | 24236.0 |
| 2025-01-15 04:00:00 | MSFT | Stock | 416.16 | 416.74 | 415.69 | 416.28 | 1300.0 |
| 2025-01-15 05:00:00 | MSFT | Stock | 416.3 | 416.3 | 416.3 | 416.3 | 100.0 |
| 2025-01-15 06:00:00 | MSFT | Stock | 416.13 | 416.91 | 415.77 | 416.91 | 2319.0 |
| 2025-01-15 07:00:00 | MSFT | Stock | 416.59 | 416.89 | 416.36 | 416.7 | 6351.0 |
| 2025-01-15 08:00:00 | MSFT | Stock | 416.68 | 422.0 | 416.0 | 421.15 | 96158.0 |
| 2025-01-15 09:00:00 | MSFT | Stock | 421.1 | 425.3199 | 418.265 | 423.9999 | 1978232.0 |
| 2025-01-15 10:00:00 | MSFT | Stock | 423.875 | 425.605 | 423.68 | 424.805 | 1227131.0 |
| 2025-01-15 11:00:00 | MSFT | Stock | 424.81 | 427.42 | 424.6501 | 424.9 | 1188363.0 |
| 2025-01-15 12:00:00 | MSFT | Stock | 424.87 | 426.4499 | 424.37 | 424.7499 | 749980.0 |
| 2025-01-15 13:00:00 | MSFT | Stock | 424.69 | 426.35 | 424.6 | 425.8538 | 555053.0 |
| 2025-01-15 14:00:00 | MSFT | Stock | 425.855 | 427.33 | 425.8 | 427.27 | 633303.0 |
| 2025-01-15 15:00:00 | MSFT | Stock | 427.3 | 428.15 | 426.09 | 426.26 | 1971468.0 |
| 2025-01-15 16:00:00 | MSFT | Stock | 426.31 | 426.75 | 425.7625 | 426.5778 | 5060001.0 |
| 2025-01-15 17:00:00 | MSFT | Stock | 426.45 | 426.9 | 426.37 | 426.5053 | 4503.0 |
| 2025-01-15 18:00:00 | MSFT | Stock | 426.58 | 427.5 | 426.31 | 427.26 | 4407.0 |
| 2025-01-15 19:00:00 | MSFT | Stock | 426.7422 | 427.48 | 426.7422 | 427.22 | 2745.0 |
| 2025-01-15 04:00:00 | NVDA | Stock | 131.2 | 131.7 | 130.81 | 131.58 | 198860.0 |
| 2025-01-15 05:00:00 | NVDA | Stock | 131.59 | 131.59 | 131.06 | 131.4 | 116589.0 |
| 2025-01-15 06:00:00 | NVDA | Stock | 131.42 | 132.09 | 131.4 | 131.78 | 340307.0 |
| 2025-01-15 07:00:00 | NVDA | Stock | 131.77 | 132.29 | 131.77 | 132.12 | 519679.0 |
| 2025-01-15 08:00:00 | NVDA | Stock | 131.77 | 134.7 | 131.03 | 133.59 | 4024314.0 |
| 2025-01-15 09:00:00 | NVDA | Stock | 133.58 | 134.09 | 131.29 | 133.6 | 26818795.0 |
| 2025-01-15 10:00:00 | NVDA | Stock | 133.6 | 135.59 | 133.57 | 134.82 | 27315706.0 |
| 2025-01-15 11:00:00 | NVDA | Stock | 134.81 | 135.46 | 133.49 | 133.88 | 20413499.0 |
| 2025-01-15 12:00:00 | NVDA | Stock | 133.88 | 135.47 | 133.76 | 135.08 | 14599585.0 |
| 2025-01-15 13:00:00 | NVDA | Stock | 135.08 | 135.7499 | 135.07 | 135.51 | 12164081.0 |
| 2025-01-15 14:00:00 | NVDA | Stock | 135.51 | 136.0 | 135.26 | 135.7599 | 11972622.0 |
| 2025-01-15 15:00:00 | NVDA | Stock | 135.755 | 136.45 | 135.4529 | 136.19 | 18895886.0 |
| 2025-01-15 16:00:00 | NVDA | Stock | 136.2 | 136.31 | 134.7707 | 135.92 | 19753272.0 |
| 2025-01-15 17:00:00 | NVDA | Stock | 135.92 | 136.24 | 135.92 | 136.17 | 258373.0 |
| 2025-01-15 18:00:00 | NVDA | Stock | 136.16 | 136.28 | 136.0 | 136.07 | 306821.0 |
| 2025-01-15 19:00:00 | NVDA | Stock | 136.0959 | 136.3995 | 136.0871 | 136.2203 | 288692.0 |
| 2025-01-15 04:00:00 | AMZN | Stock | 218.3 | 218.41 | 218.2 | 218.4 | 3766.0 |
| 2025-01-15 05:00:00 | AMZN | Stock | 218.02 | 218.35 | 217.65 | 218.35 | 5842.0 |
> showing 50 of 64,459 rows — these rows as CSV