PREVIEW / stock_1hour / 2025-05-23
file: by_date/stock_1hour/2025/2025-05-23.parquet size: 1.4 MB rows: 60,922 symbols: 406
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-23 04:00:00 | AAPL | Stock | 201.74 | 202.0 | 201.61 | 201.7 | 14234.0 |
| 2025-05-23 05:00:00 | AAPL | Stock | 201.67 | 201.7 | 201.0 | 201.48 | 11962.0 |
| 2025-05-23 06:00:00 | AAPL | Stock | 201.5 | 201.57 | 201.2 | 201.4 | 13595.0 |
| 2025-05-23 07:00:00 | AAPL | Stock | 201.42 | 201.58 | 193.23 | 194.8 | 1343053.0 |
| 2025-05-23 08:00:00 | AAPL | Stock | 193.68 | 201.7 | 193.13 | 194.87 | 1735245.0 |
| 2025-05-23 09:00:00 | AAPL | Stock | 194.9 | 197.0999 | 193.2 | 196.37 | 12982398.0 |
| 2025-05-23 10:00:00 | AAPL | Stock | 196.34 | 197.7 | 195.69 | 195.9301 | 8600842.0 |
| 2025-05-23 11:00:00 | AAPL | Stock | 195.94 | 197.125 | 195.8 | 196.2001 | 4733905.0 |
| 2025-05-23 12:00:00 | AAPL | Stock | 196.2 | 196.67 | 195.635 | 196.1 | 4784289.0 |
| 2025-05-23 13:00:00 | AAPL | Stock | 196.1 | 196.6724 | 195.58 | 195.98 | 4821749.0 |
| 2025-05-23 14:00:00 | AAPL | Stock | 195.97 | 196.53 | 195.0 | 195.525 | 4943262.0 |
| 2025-05-23 15:00:00 | AAPL | Stock | 195.52 | 195.97 | 195.01 | 195.34 | 8989431.0 |
| 2025-05-23 16:00:00 | AAPL | Stock | 195.27 | 195.75 | 195.16 | 195.29 | 6412226.0 |
| 2025-05-23 17:00:00 | AAPL | Stock | 195.25 | 195.6 | 195.1 | 195.5 | 57516.0 |
| 2025-05-23 18:00:00 | AAPL | Stock | 195.45 | 195.52 | 195.33 | 195.4893 | 36258.0 |
| 2025-05-23 19:00:00 | AAPL | Stock | 195.47 | 195.98 | 195.4 | 195.85 | 49496.0 |
| 2025-05-23 04:00:00 | MSFT | Stock | 454.64 | 454.84 | 453.65 | 453.9 | 4121.0 |
| 2025-05-23 05:00:00 | MSFT | Stock | 453.4 | 453.44 | 452.0 | 452.86 | 1284.0 |
| 2025-05-23 06:00:00 | MSFT | Stock | 453.35 | 453.35 | 453.18 | 453.24 | 974.0 |
| 2025-05-23 07:00:00 | MSFT | Stock | 453.56 | 454.1 | 449.02 | 449.5 | 27054.0 |
| 2025-05-23 08:00:00 | MSFT | Stock | 453.95 | 454.86 | 448.5002 | 449.48 | 86222.0 |
| 2025-05-23 09:00:00 | MSFT | Stock | 449.22 | 451.79 | 448.91 | 449.785 | 1506508.0 |
| 2025-05-23 10:00:00 | MSFT | Stock | 449.73 | 452.36 | 449.5001 | 450.315 | 1156958.0 |
| 2025-05-23 11:00:00 | MSFT | Stock | 450.37 | 451.82 | 449.9605 | 450.36 | 746049.0 |
| 2025-05-23 12:00:00 | MSFT | Stock | 450.39 | 452.05 | 450.03 | 451.37 | 743791.0 |
| 2025-05-23 13:00:00 | MSFT | Stock | 451.38 | 453.69 | 450.976 | 453.145 | 773247.0 |
| 2025-05-23 14:00:00 | MSFT | Stock | 453.1378 | 453.49 | 451.83 | 452.065 | 577465.0 |
| 2025-05-23 15:00:00 | MSFT | Stock | 452.07 | 452.65 | 450.0 | 450.19 | 1563657.0 |
| 2025-05-23 16:00:00 | MSFT | Stock | 450.18 | 451.3844 | 449.5 | 450.23 | 2580038.0 |
| 2025-05-23 17:00:00 | MSFT | Stock | 450.33 | 450.4888 | 450.05 | 450.21 | 4943.0 |
| 2025-05-23 18:00:00 | MSFT | Stock | 450.0505 | 450.4592 | 450.05 | 450.05 | 1304.0 |
| 2025-05-23 19:00:00 | MSFT | Stock | 450.05 | 450.5 | 450.01 | 450.5 | 2662.0 |
| 2025-05-23 04:00:00 | NVDA | Stock | 133.1 | 133.27 | 132.89 | 133.03 | 212428.0 |
| 2025-05-23 05:00:00 | NVDA | Stock | 133.01 | 133.1 | 132.31 | 132.9 | 382449.0 |
| 2025-05-23 06:00:00 | NVDA | Stock | 132.88 | 133.1 | 132.78 | 133.08 | 125850.0 |
| 2025-05-23 07:00:00 | NVDA | Stock | 133.07 | 133.17 | 130.33 | 130.43 | 1564987.0 |
| 2025-05-23 08:00:00 | NVDA | Stock | 133.03 | 133.24 | 127.8 | 129.22 | 7544416.0 |
| 2025-05-23 09:00:00 | NVDA | Stock | 129.24 | 130.99 | 128.9501 | 130.31 | 26601348.0 |
| 2025-05-23 10:00:00 | NVDA | Stock | 130.32 | 131.38 | 130.24 | 131.2011 | 26570992.0 |
| 2025-05-23 11:00:00 | NVDA | Stock | 131.21 | 131.48 | 130.19 | 130.695 | 18566841.0 |
| 2025-05-23 12:00:00 | NVDA | Stock | 130.695 | 131.29 | 130.63 | 131.0518 | 13909734.0 |
| 2025-05-23 13:00:00 | NVDA | Stock | 131.06 | 132.099 | 130.93 | 131.895 | 16105194.0 |
| 2025-05-23 14:00:00 | NVDA | Stock | 131.891 | 132.68 | 131.585 | 131.87 | 18446704.0 |
| 2025-05-23 15:00:00 | NVDA | Stock | 131.86 | 132.14 | 131.14 | 131.31 | 23806686.0 |
| 2025-05-23 16:00:00 | NVDA | Stock | 131.3 | 131.4 | 130.97 | 131.26 | 10914232.0 |
| 2025-05-23 17:00:00 | NVDA | Stock | 131.27 | 131.29 | 131.16 | 131.2 | 208348.0 |
| 2025-05-23 18:00:00 | NVDA | Stock | 131.2 | 131.23 | 131.15 | 131.18 | 161186.0 |
| 2025-05-23 19:00:00 | NVDA | Stock | 131.18 | 131.25 | 131.15 | 131.17 | 254066.0 |
| 2025-05-23 04:00:00 | AMZN | Stock | 203.37 | 203.56 | 203.02 | 203.02 | 8182.0 |
| 2025-05-23 05:00:00 | AMZN | Stock | 203.0 | 203.3 | 202.51 | 203.0 | 7116.0 |
> showing 50 of 60,922 rows — these rows as CSV