PREVIEW / stock_1hour / 2025-05-05
file: by_date/stock_1hour/2025/2025-05-05.parquet size: 1.4 MB rows: 62,130 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-05 04:00:00 | AAPL | Stock | 205.0 | 205.0 | 203.33 | 203.5 | 36935.0 |
| 2025-05-05 05:00:00 | AAPL | Stock | 203.51 | 203.8 | 203.5 | 203.73 | 20236.0 |
| 2025-05-05 06:00:00 | AAPL | Stock | 203.71 | 203.76 | 203.0 | 203.25 | 37099.0 |
| 2025-05-05 07:00:00 | AAPL | Stock | 203.25 | 203.44 | 202.79 | 203.19 | 67301.0 |
| 2025-05-05 08:00:00 | AAPL | Stock | 203.25 | 204.3419 | 202.77 | 203.28 | 188433.0 |
| 2025-05-05 09:00:00 | AAPL | Stock | 203.26 | 204.1 | 199.5 | 199.725 | 7219888.0 |
| 2025-05-05 10:00:00 | AAPL | Stock | 199.76 | 200.34 | 198.21 | 198.9335 | 8088019.0 |
| 2025-05-05 11:00:00 | AAPL | Stock | 198.91 | 199.65 | 198.5 | 199.275 | 5090662.0 |
| 2025-05-05 12:00:00 | AAPL | Stock | 199.275 | 200.04 | 199.1 | 199.8911 | 3937078.0 |
| 2025-05-05 13:00:00 | AAPL | Stock | 199.88 | 200.64 | 199.6701 | 200.37 | 3537649.0 |
| 2025-05-05 14:00:00 | AAPL | Stock | 200.37 | 201.16 | 200.16 | 200.53 | 3295137.0 |
| 2025-05-05 15:00:00 | AAPL | Stock | 200.52 | 200.52 | 198.512 | 198.77 | 7338075.0 |
| 2025-05-05 16:00:00 | AAPL | Stock | 198.76 | 198.99 | 198.56 | 198.97 | 8023230.0 |
| 2025-05-05 17:00:00 | AAPL | Stock | 198.98 | 199.05 | 198.56 | 198.66 | 82961.0 |
| 2025-05-05 18:00:00 | AAPL | Stock | 198.69 | 198.86 | 198.5732 | 198.61 | 33633.0 |
| 2025-05-05 19:00:00 | AAPL | Stock | 198.56 | 198.89 | 198.56 | 198.6 | 47207.0 |
| 2025-05-05 04:00:00 | MSFT | Stock | 432.88 | 432.88 | 430.02 | 430.69 | 10344.0 |
| 2025-05-05 05:00:00 | MSFT | Stock | 430.88 | 431.28 | 430.6 | 431.17 | 6268.0 |
| 2025-05-05 06:00:00 | MSFT | Stock | 431.56 | 431.9 | 431.2 | 431.85 | 5921.0 |
| 2025-05-05 07:00:00 | MSFT | Stock | 431.75 | 432.8 | 431.4 | 431.99 | 20341.0 |
| 2025-05-05 08:00:00 | MSFT | Stock | 431.86 | 433.0 | 429.92 | 431.0 | 79173.0 |
| 2025-05-05 09:00:00 | MSFT | Stock | 430.8 | 436.5799 | 430.75 | 436.19 | 1493796.0 |
| 2025-05-05 10:00:00 | MSFT | Stock | 436.19 | 437.44 | 434.47 | 437.425 | 1290705.0 |
| 2025-05-05 11:00:00 | MSFT | Stock | 437.3925 | 438.06 | 436.09 | 437.475 | 917527.0 |
| 2025-05-05 12:00:00 | MSFT | Stock | 437.4995 | 439.5 | 437.21 | 439.025 | 1017939.0 |
| 2025-05-05 13:00:00 | MSFT | Stock | 439.0 | 439.39 | 437.91 | 437.955 | 896242.0 |
| 2025-05-05 14:00:00 | MSFT | Stock | 437.97 | 438.74 | 437.69 | 438.14 | 777585.0 |
| 2025-05-05 15:00:00 | MSFT | Stock | 438.16 | 438.17 | 434.97 | 436.02 | 1673163.0 |
| 2025-05-05 16:00:00 | MSFT | Stock | 436.17 | 436.17 | 434.17 | 434.87 | 3319461.0 |
| 2025-05-05 17:00:00 | MSFT | Stock | 434.86 | 435.48 | 434.5 | 435.4 | 4028.0 |
| 2025-05-05 18:00:00 | MSFT | Stock | 435.54 | 435.7998 | 435.3501 | 435.42 | 3925.0 |
| 2025-05-05 19:00:00 | MSFT | Stock | 435.9 | 436.17 | 435.49 | 435.69 | 7313.0 |
| 2025-05-05 04:00:00 | NVDA | Stock | 113.9 | 113.91 | 112.61 | 112.8 | 396149.0 |
| 2025-05-05 05:00:00 | NVDA | Stock | 112.81 | 113.27 | 112.46 | 113.0 | 353137.0 |
| 2025-05-05 06:00:00 | NVDA | Stock | 113.0 | 113.1 | 112.66 | 112.98 | 205289.0 |
| 2025-05-05 07:00:00 | NVDA | Stock | 112.98 | 113.2 | 112.82 | 112.92 | 430454.0 |
| 2025-05-05 08:00:00 | NVDA | Stock | 112.9 | 114.1 | 112.66 | 113.0 | 1280354.0 |
| 2025-05-05 09:00:00 | NVDA | Stock | 112.98 | 114.38 | 112.76 | 113.7465 | 18088709.0 |
| 2025-05-05 10:00:00 | NVDA | Stock | 113.76 | 114.2 | 112.66 | 113.56 | 21279385.0 |
| 2025-05-05 11:00:00 | NVDA | Stock | 113.57 | 114.12 | 113.4 | 113.565 | 13844041.0 |
| 2025-05-05 12:00:00 | NVDA | Stock | 113.565 | 114.06 | 113.56 | 114.0193 | 8762731.0 |
| 2025-05-05 13:00:00 | NVDA | Stock | 114.015 | 114.37 | 113.87 | 114.26 | 8478363.0 |
| 2025-05-05 14:00:00 | NVDA | Stock | 114.27 | 114.665 | 114.13 | 114.18 | 8737013.0 |
| 2025-05-05 15:00:00 | NVDA | Stock | 114.17 | 114.62 | 113.67 | 113.81 | 14956152.0 |
| 2025-05-05 16:00:00 | NVDA | Stock | 113.82 | 113.86 | 113.11 | 113.59 | 15376360.0 |
| 2025-05-05 17:00:00 | NVDA | Stock | 113.6008 | 113.82 | 113.35 | 113.51 | 315857.0 |
| 2025-05-05 18:00:00 | NVDA | Stock | 113.5 | 113.54 | 113.25 | 113.31 | 146395.0 |
| 2025-05-05 19:00:00 | NVDA | Stock | 113.3 | 113.82 | 113.25 | 113.25 | 177813.0 |
| 2025-05-05 04:00:00 | AMZN | Stock | 189.24 | 189.52 | 187.16 | 187.42 | 55259.0 |
| 2025-05-05 05:00:00 | AMZN | Stock | 187.35 | 187.4 | 187.12 | 187.21 | 33422.0 |
> showing 50 of 62,130 rows — these rows as CSV