PREVIEW / stock_1hour / 2025-01-30
file: by_date/stock_1hour/2025/2025-01-30.parquet size: 1.4 MB rows: 63,177 symbols: 568
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-30 04:00:00 | AAPL | Stock | 239.63 | 239.92 | 238.92 | 238.97 | 11510.0 |
| 2025-01-30 05:00:00 | AAPL | Stock | 238.94 | 239.2 | 238.8 | 238.88 | 14565.0 |
| 2025-01-30 06:00:00 | AAPL | Stock | 238.97 | 239.62 | 238.89 | 239.35 | 13454.0 |
| 2025-01-30 07:00:00 | AAPL | Stock | 239.15 | 239.15 | 238.09 | 238.7 | 26310.0 |
| 2025-01-30 08:00:00 | AAPL | Stock | 238.45 | 240.16 | 238.05 | 238.95 | 299084.0 |
| 2025-01-30 09:00:00 | AAPL | Stock | 239.0 | 240.79 | 237.16 | 239.46 | 4384760.0 |
| 2025-01-30 10:00:00 | AAPL | Stock | 239.46 | 239.46 | 238.06 | 238.06 | 3460824.0 |
| 2025-01-30 11:00:00 | AAPL | Stock | 238.09 | 238.84 | 237.21 | 238.78 | 3076134.0 |
| 2025-01-30 12:00:00 | AAPL | Stock | 238.8 | 238.88 | 237.81 | 238.395 | 2189171.0 |
| 2025-01-30 13:00:00 | AAPL | Stock | 238.39 | 239.67 | 238.29 | 239.645 | 2089561.0 |
| 2025-01-30 14:00:00 | AAPL | Stock | 239.649 | 239.87 | 238.931 | 239.861 | 2872780.0 |
| 2025-01-30 15:00:00 | AAPL | Stock | 239.865 | 240.06 | 237.24 | 237.56 | 7394767.0 |
| 2025-01-30 16:00:00 | AAPL | Stock | 237.52 | 245.44 | 233.51 | 233.99 | 8154624.0 |
| 2025-01-30 17:00:00 | AAPL | Stock | 234.0 | 248.35 | 232.97 | 245.03 | 4295943.0 |
| 2025-01-30 18:00:00 | AAPL | Stock | 245.0146 | 246.2 | 243.5109 | 245.0 | 701595.0 |
| 2025-01-30 19:00:00 | AAPL | Stock | 244.95 | 245.0 | 244.1 | 244.75 | 230547.0 |
| 2025-01-30 04:00:00 | MSFT | Stock | 425.85 | 427.59 | 424.52 | 425.45 | 85935.0 |
| 2025-01-30 05:00:00 | MSFT | Stock | 425.46 | 426.61 | 423.85 | 425.91 | 30938.0 |
| 2025-01-30 06:00:00 | MSFT | Stock | 425.72 | 426.15 | 424.32 | 424.32 | 58925.0 |
| 2025-01-30 07:00:00 | MSFT | Stock | 424.3 | 425.0 | 422.01 | 424.15 | 139141.0 |
| 2025-01-30 08:00:00 | MSFT | Stock | 423.9 | 427.1 | 421.5001 | 422.63 | 395990.0 |
| 2025-01-30 09:00:00 | MSFT | Stock | 422.76 | 423.16 | 414.74 | 421.72 | 8141986.0 |
| 2025-01-30 10:00:00 | MSFT | Stock | 421.71 | 421.74 | 413.94 | 415.25 | 6549067.0 |
| 2025-01-30 11:00:00 | MSFT | Stock | 415.18 | 416.55 | 413.16 | 416.33 | 3683974.0 |
| 2025-01-30 12:00:00 | MSFT | Stock | 416.34 | 417.09 | 414.33 | 414.5 | 2691686.0 |
| 2025-01-30 13:00:00 | MSFT | Stock | 414.505 | 416.455 | 414.25 | 415.035 | 2181381.0 |
| 2025-01-30 14:00:00 | MSFT | Stock | 415.04 | 415.75 | 414.51 | 415.6912 | 2209961.0 |
| 2025-01-30 15:00:00 | MSFT | Stock | 415.705 | 417.04 | 414.0701 | 414.87 | 5836018.0 |
| 2025-01-30 16:00:00 | MSFT | Stock | 414.86 | 416.63 | 414.8145 | 416.47 | 4547055.0 |
| 2025-01-30 17:00:00 | MSFT | Stock | 416.61 | 418.0 | 415.4 | 417.94 | 92878.0 |
| 2025-01-30 18:00:00 | MSFT | Stock | 417.9701 | 417.98 | 417.1072 | 417.95 | 72211.0 |
| 2025-01-30 19:00:00 | MSFT | Stock | 417.9 | 418.46 | 417.9 | 418.12 | 78130.0 |
| 2025-01-30 04:00:00 | NVDA | Stock | 123.3 | 124.68 | 123.3 | 123.51 | 926153.0 |
| 2025-01-30 05:00:00 | NVDA | Stock | 123.45 | 123.72 | 122.0 | 122.33 | 724655.0 |
| 2025-01-30 06:00:00 | NVDA | Stock | 122.34 | 123.28 | 122.01 | 122.88 | 605214.0 |
| 2025-01-30 07:00:00 | NVDA | Stock | 122.89 | 123.5 | 122.63 | 123.0 | 1022240.0 |
| 2025-01-30 08:00:00 | NVDA | Stock | 123.08 | 124.6729 | 122.0104 | 123.3498 | 4313973.0 |
| 2025-01-30 09:00:00 | NVDA | Stock | 123.321 | 124.15 | 121.25 | 122.165 | 36241732.0 |
| 2025-01-30 10:00:00 | NVDA | Stock | 122.18 | 122.3 | 118.51 | 118.56 | 60831889.0 |
| 2025-01-30 11:00:00 | NVDA | Stock | 118.56 | 120.89 | 118.1 | 120.585 | 41951487.0 |
| 2025-01-30 12:00:00 | NVDA | Stock | 120.58 | 120.585 | 119.1 | 120.005 | 23154151.0 |
| 2025-01-30 13:00:00 | NVDA | Stock | 120.005 | 120.23 | 119.26 | 120.13 | 20517365.0 |
| 2025-01-30 14:00:00 | NVDA | Stock | 120.14 | 122.48 | 120.0 | 122.2837 | 34669654.0 |
| 2025-01-30 15:00:00 | NVDA | Stock | 122.27 | 125.0 | 121.87 | 124.91 | 60872800.0 |
| 2025-01-30 16:00:00 | NVDA | Stock | 124.925 | 125.06 | 122.6205 | 123.05 | 44549485.0 |
| 2025-01-30 17:00:00 | NVDA | Stock | 123.06 | 123.7 | 122.85 | 123.2607 | 1422132.0 |
| 2025-01-30 18:00:00 | NVDA | Stock | 123.29 | 123.568 | 123.08 | 123.37 | 708559.0 |
| 2025-01-30 19:00:00 | NVDA | Stock | 123.3798 | 123.56 | 123.1806 | 123.2291 | 648555.0 |
| 2025-01-30 04:00:00 | AMZN | Stock | 237.09 | 237.45 | 236.5 | 236.89 | 28840.0 |
| 2025-01-30 05:00:00 | AMZN | Stock | 236.82 | 237.46 | 236.66 | 236.94 | 19701.0 |
> showing 50 of 63,177 rows — these rows as CSV