PREVIEW / stock_1hour / 2025-03-20
file: by_date/stock_1hour/2025/2025-03-20.parquet size: 1.4 MB rows: 60,972 symbols: 482
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-03-20 04:00:00 | AAPL | Stock | 216.24 | 216.36 | 215.8 | 216.05 | 19595.0 |
| 2025-03-20 05:00:00 | AAPL | Stock | 215.93 | 216.24 | 215.28 | 215.41 | 4453.0 |
| 2025-03-20 06:00:00 | AAPL | Stock | 215.5 | 215.5 | 213.86 | 214.41 | 30860.0 |
| 2025-03-20 07:00:00 | AAPL | Stock | 214.44 | 214.88 | 214.18 | 214.86 | 22061.0 |
| 2025-03-20 08:00:00 | AAPL | Stock | 214.34 | 216.45 | 214.1908 | 214.74 | 116694.0 |
| 2025-03-20 09:00:00 | AAPL | Stock | 214.67 | 215.49 | 212.9 | 215.49 | 3175308.0 |
| 2025-03-20 10:00:00 | AAPL | Stock | 215.485 | 217.4899 | 215.39 | 216.145 | 4494085.0 |
| 2025-03-20 11:00:00 | AAPL | Stock | 216.17 | 216.53 | 215.425 | 215.5963 | 2704828.0 |
| 2025-03-20 12:00:00 | AAPL | Stock | 215.589 | 216.44 | 213.0 | 213.54 | 4515368.0 |
| 2025-03-20 13:00:00 | AAPL | Stock | 213.53 | 214.02 | 213.1 | 213.4 | 2503446.0 |
| 2025-03-20 14:00:00 | AAPL | Stock | 213.43 | 213.83 | 212.22 | 212.3694 | 3252889.0 |
| 2025-03-20 15:00:00 | AAPL | Stock | 212.35 | 214.76 | 212.34 | 214.15 | 5653784.0 |
| 2025-03-20 16:00:00 | AAPL | Stock | 214.1 | 214.35 | 213.67 | 214.0603 | 12251170.0 |
| 2025-03-20 17:00:00 | AAPL | Stock | 214.06 | 214.1 | 213.9 | 213.91 | 10292.0 |
| 2025-03-20 18:00:00 | AAPL | Stock | 213.8523 | 213.99 | 213.7067 | 213.8799 | 15907.0 |
| 2025-03-20 19:00:00 | AAPL | Stock | 213.85 | 213.88 | 213.65 | 213.7 | 14044.0 |
| 2025-03-20 04:00:00 | MSFT | Stock | 389.45 | 389.9 | 388.68 | 389.78 | 4962.0 |
| 2025-03-20 05:00:00 | MSFT | Stock | 389.76 | 389.77 | 388.02 | 388.02 | 6726.0 |
| 2025-03-20 06:00:00 | MSFT | Stock | 388.0 | 388.0 | 384.11 | 385.8 | 11332.0 |
| 2025-03-20 07:00:00 | MSFT | Stock | 385.62 | 387.0 | 385.29 | 386.55 | 15364.0 |
| 2025-03-20 08:00:00 | MSFT | Stock | 386.16 | 390.0 | 384.14 | 386.8 | 26350.0 |
| 2025-03-20 09:00:00 | MSFT | Stock | 386.65 | 386.87 | 383.28 | 386.73 | 1027182.0 |
| 2025-03-20 10:00:00 | MSFT | Stock | 386.71 | 391.785 | 386.62 | 389.49 | 1254330.0 |
| 2025-03-20 11:00:00 | MSFT | Stock | 389.5 | 389.67 | 387.5543 | 387.655 | 885696.0 |
| 2025-03-20 12:00:00 | MSFT | Stock | 387.62 | 388.85 | 386.3825 | 386.535 | 852253.0 |
| 2025-03-20 13:00:00 | MSFT | Stock | 386.4928 | 387.4 | 385.545 | 385.96 | 773546.0 |
| 2025-03-20 14:00:00 | MSFT | Stock | 385.98 | 386.74 | 384.61 | 385.8 | 801103.0 |
| 2025-03-20 15:00:00 | MSFT | Stock | 385.8 | 388.14 | 385.64 | 386.81 | 1829680.0 |
| 2025-03-20 16:00:00 | MSFT | Stock | 386.8 | 387.55 | 386.1522 | 387.0 | 4935102.0 |
| 2025-03-20 17:00:00 | MSFT | Stock | 387.1458 | 387.1458 | 386.8 | 387.0 | 1357.0 |
| 2025-03-20 18:00:00 | MSFT | Stock | 387.12 | 387.19 | 387.12 | 387.19 | 200.0 |
| 2025-03-20 19:00:00 | MSFT | Stock | 386.85 | 386.99 | 386.5 | 386.99 | 1681.0 |
| 2025-03-20 04:00:00 | NVDA | Stock | 119.1 | 119.55 | 118.9 | 119.23 | 378320.0 |
| 2025-03-20 05:00:00 | NVDA | Stock | 119.23 | 119.28 | 117.53 | 118.09 | 625934.0 |
| 2025-03-20 06:00:00 | NVDA | Stock | 118.03 | 118.04 | 116.03 | 117.03 | 1168253.0 |
| 2025-03-20 07:00:00 | NVDA | Stock | 117.04 | 117.4 | 116.38 | 117.23 | 1137876.0 |
| 2025-03-20 08:00:00 | NVDA | Stock | 117.16 | 119.56 | 116.22 | 117.15 | 2330845.0 |
| 2025-03-20 09:00:00 | NVDA | Stock | 117.1 | 119.45 | 116.4 | 118.415 | 29234913.0 |
| 2025-03-20 10:00:00 | NVDA | Stock | 118.42 | 119.58 | 118.16 | 119.105 | 29475769.0 |
| 2025-03-20 11:00:00 | NVDA | Stock | 119.105 | 120.2 | 118.9 | 119.41 | 27722290.0 |
| 2025-03-20 12:00:00 | NVDA | Stock | 119.41 | 119.83 | 117.82 | 118.065 | 23898381.0 |
| 2025-03-20 13:00:00 | NVDA | Stock | 118.06 | 118.7 | 117.84 | 118.34 | 17447326.0 |
| 2025-03-20 14:00:00 | NVDA | Stock | 118.33 | 119.07 | 117.74 | 118.01 | 21357996.0 |
| 2025-03-20 15:00:00 | NVDA | Stock | 118.0 | 118.92 | 117.95 | 118.465 | 23651988.0 |
| 2025-03-20 16:00:00 | NVDA | Stock | 118.465 | 118.88 | 118.23 | 118.62 | 27945581.0 |
| 2025-03-20 17:00:00 | NVDA | Stock | 118.6105 | 118.74 | 118.4 | 118.56 | 253177.0 |
| 2025-03-20 18:00:00 | NVDA | Stock | 118.58 | 118.59 | 118.32 | 118.4 | 216882.0 |
| 2025-03-20 19:00:00 | NVDA | Stock | 118.4 | 118.4386 | 118.1201 | 118.17 | 309221.0 |
| 2025-03-20 04:00:00 | AMZN | Stock | 196.5 | 197.11 | 196.15 | 196.62 | 19489.0 |
| 2025-03-20 05:00:00 | AMZN | Stock | 196.62 | 196.71 | 195.57 | 195.65 | 44683.0 |
> showing 50 of 60,972 rows — these rows as CSV