PREVIEW / stock_1hour / 2025-05-20
file: by_date/stock_1hour/2025/2025-05-20.parquet size: 1.4 MB rows: 60,753 symbols: 411
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-20 04:00:00 | AAPL | Stock | 208.88 | 208.88 | 207.63 | 207.92 | 14412.0 |
| 2025-05-20 05:00:00 | AAPL | Stock | 207.91 | 208.03 | 207.86 | 207.98 | 12407.0 |
| 2025-05-20 06:00:00 | AAPL | Stock | 207.89 | 208.15 | 207.85 | 208.13 | 9540.0 |
| 2025-05-20 07:00:00 | AAPL | Stock | 208.16 | 208.3 | 207.84 | 208.15 | 27610.0 |
| 2025-05-20 08:00:00 | AAPL | Stock | 208.15 | 208.5 | 207.22 | 207.65 | 125133.0 |
| 2025-05-20 09:00:00 | AAPL | Stock | 207.7 | 208.3 | 206.47 | 207.51 | 4063017.0 |
| 2025-05-20 10:00:00 | AAPL | Stock | 207.48 | 208.47 | 207.09 | 207.59 | 3401047.0 |
| 2025-05-20 11:00:00 | AAPL | Stock | 207.58 | 208.43 | 207.0 | 207.915 | 3338566.0 |
| 2025-05-20 12:00:00 | AAPL | Stock | 207.91 | 208.08 | 207.4 | 207.61 | 2019106.0 |
| 2025-05-20 13:00:00 | AAPL | Stock | 207.61 | 207.74 | 206.685 | 206.8486 | 2551189.0 |
| 2025-05-20 14:00:00 | AAPL | Stock | 206.84 | 206.855 | 205.21 | 205.33 | 3786175.0 |
| 2025-05-20 15:00:00 | AAPL | Stock | 205.35 | 206.94 | 205.03 | 206.87 | 4569631.0 |
| 2025-05-20 16:00:00 | AAPL | Stock | 206.86 | 206.9 | 206.45 | 206.4617 | 5570392.0 |
| 2025-05-20 17:00:00 | AAPL | Stock | 206.59 | 206.59 | 206.1 | 206.47 | 19164.0 |
| 2025-05-20 18:00:00 | AAPL | Stock | 206.47 | 206.86 | 206.0 | 206.39 | 18997.0 |
| 2025-05-20 19:00:00 | AAPL | Stock | 206.45 | 206.7 | 206.08 | 206.6237 | 23121.0 |
| 2025-05-20 04:00:00 | MSFT | Stock | 456.94 | 457.0 | 456.43 | 456.87 | 3210.0 |
| 2025-05-20 05:00:00 | MSFT | Stock | 456.61 | 456.89 | 456.61 | 456.7 | 2056.0 |
| 2025-05-20 06:00:00 | MSFT | Stock | 457.17 | 457.21 | 456.74 | 456.74 | 1568.0 |
| 2025-05-20 07:00:00 | MSFT | Stock | 457.48 | 458.85 | 457.48 | 458.49 | 10598.0 |
| 2025-05-20 08:00:00 | MSFT | Stock | 458.3 | 458.87 | 455.76 | 457.24 | 25665.0 |
| 2025-05-20 09:00:00 | MSFT | Stock | 457.4 | 458.23 | 454.35 | 455.03 | 1211360.0 |
| 2025-05-20 10:00:00 | MSFT | Stock | 455.06 | 456.35 | 454.3201 | 455.5789 | 873902.0 |
| 2025-05-20 11:00:00 | MSFT | Stock | 455.525 | 456.73 | 455.235 | 455.99 | 668369.0 |
| 2025-05-20 12:00:00 | MSFT | Stock | 455.985 | 457.28 | 455.7401 | 456.81 | 627629.0 |
| 2025-05-20 13:00:00 | MSFT | Stock | 456.81 | 457.56 | 456.38 | 456.765 | 666085.0 |
| 2025-05-20 14:00:00 | MSFT | Stock | 456.74 | 456.78 | 455.01 | 455.67 | 734222.0 |
| 2025-05-20 15:00:00 | MSFT | Stock | 455.64 | 458.34 | 455.05 | 458.32 | 1492314.0 |
| 2025-05-20 16:00:00 | MSFT | Stock | 458.17 | 458.4 | 457.2 | 457.5 | 2729395.0 |
| 2025-05-20 17:00:00 | MSFT | Stock | 457.5 | 457.5 | 457.2 | 457.5 | 680.0 |
| 2025-05-20 18:00:00 | MSFT | Stock | 457.0 | 458.17 | 456.0 | 458.17 | 3833.0 |
| 2025-05-20 19:00:00 | MSFT | Stock | 457.6 | 457.9373 | 456.6944 | 457.2462 | 1761.0 |
| 2025-05-20 04:00:00 | NVDA | Stock | 135.01 | 135.25 | 134.8 | 134.98 | 355308.0 |
| 2025-05-20 05:00:00 | NVDA | Stock | 134.99 | 135.16 | 134.91 | 135.02 | 151512.0 |
| 2025-05-20 06:00:00 | NVDA | Stock | 135.03 | 135.33 | 134.96 | 135.28 | 227493.0 |
| 2025-05-20 07:00:00 | NVDA | Stock | 135.29 | 135.42 | 134.9 | 135.01 | 552583.0 |
| 2025-05-20 08:00:00 | NVDA | Stock | 135.28 | 135.57 | 134.6 | 134.68 | 1727343.0 |
| 2025-05-20 09:00:00 | NVDA | Stock | 134.67 | 134.83 | 132.75 | 133.085 | 24314681.0 |
| 2025-05-20 10:00:00 | NVDA | Stock | 133.08 | 133.92 | 132.62 | 133.645 | 24060326.0 |
| 2025-05-20 11:00:00 | NVDA | Stock | 133.645 | 134.26 | 133.3 | 134.135 | 15261318.0 |
| 2025-05-20 12:00:00 | NVDA | Stock | 134.13 | 134.43 | 133.725 | 134.155 | 11020104.0 |
| 2025-05-20 13:00:00 | NVDA | Stock | 134.155 | 134.44 | 133.82 | 134.005 | 11029731.0 |
| 2025-05-20 14:00:00 | NVDA | Stock | 134.0 | 134.24 | 133.37 | 133.6399 | 12899538.0 |
| 2025-05-20 15:00:00 | NVDA | Stock | 133.63 | 134.46 | 133.03 | 134.38 | 20241882.0 |
| 2025-05-20 16:00:00 | NVDA | Stock | 134.39 | 135.25 | 134.11 | 134.6 | 11570039.0 |
| 2025-05-20 17:00:00 | NVDA | Stock | 134.6401 | 134.65 | 134.25 | 134.29 | 351431.0 |
| 2025-05-20 18:00:00 | NVDA | Stock | 134.3179 | 134.33 | 133.7 | 133.96 | 466004.0 |
| 2025-05-20 19:00:00 | NVDA | Stock | 133.95 | 134.3 | 133.9201 | 134.0 | 342894.0 |
| 2025-05-20 04:00:00 | AMZN | Stock | 205.55 | 205.55 | 204.88 | 205.16 | 14949.0 |
| 2025-05-20 05:00:00 | AMZN | Stock | 205.19 | 205.46 | 205.01 | 205.11 | 1952.0 |
> showing 50 of 60,753 rows — these rows as CSV