PREVIEW / stock_1hour / 2025-04-24
file: by_date/stock_1hour/2025/2025-04-24.parquet size: 1.4 MB rows: 61,918 symbols: 429
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-04-24 04:00:00 | AAPL | Stock | 203.87 | 203.87 | 201.68 | 201.95 | 20110.0 |
| 2025-04-24 05:00:00 | AAPL | Stock | 201.98 | 202.6 | 201.78 | 202.38 | 12054.0 |
| 2025-04-24 06:00:00 | AAPL | Stock | 202.6 | 204.37 | 202.3 | 204.04 | 54961.0 |
| 2025-04-24 07:00:00 | AAPL | Stock | 204.11 | 204.43 | 203.25 | 203.67 | 54152.0 |
| 2025-04-24 08:00:00 | AAPL | Stock | 203.99 | 204.71 | 202.54 | 204.23 | 136366.0 |
| 2025-04-24 09:00:00 | AAPL | Stock | 204.45 | 205.64 | 202.94 | 205.59 | 3932151.0 |
| 2025-04-24 10:00:00 | AAPL | Stock | 205.57 | 206.66 | 205.2201 | 205.955 | 4056521.0 |
| 2025-04-24 11:00:00 | AAPL | Stock | 205.96 | 206.715 | 205.48 | 206.095 | 2819083.0 |
| 2025-04-24 12:00:00 | AAPL | Stock | 206.11 | 206.77 | 205.65 | 206.54 | 1861891.0 |
| 2025-04-24 13:00:00 | AAPL | Stock | 206.54 | 207.48 | 206.09 | 207.45 | 2065846.0 |
| 2025-04-24 14:00:00 | AAPL | Stock | 207.44 | 208.1 | 207.0575 | 207.86 | 2189038.0 |
| 2025-04-24 15:00:00 | AAPL | Stock | 207.85 | 208.8299 | 207.03 | 208.2 | 5089236.0 |
| 2025-04-24 16:00:00 | AAPL | Stock | 208.21 | 208.91 | 208.21 | 208.689 | 12381704.0 |
| 2025-04-24 17:00:00 | AAPL | Stock | 208.64 | 208.77 | 208.54 | 208.5401 | 48101.0 |
| 2025-04-24 18:00:00 | AAPL | Stock | 208.56 | 208.56 | 207.56 | 208.02 | 46056.0 |
| 2025-04-24 19:00:00 | AAPL | Stock | 207.96 | 208.5 | 207.42 | 207.9991 | 36378.0 |
| 2025-04-24 04:00:00 | MSFT | Stock | 373.69 | 373.69 | 372.1 | 372.58 | 3683.0 |
| 2025-04-24 05:00:00 | MSFT | Stock | 372.67 | 374.24 | 372.4 | 373.86 | 2415.0 |
| 2025-04-24 06:00:00 | MSFT | Stock | 373.81 | 376.09 | 373.46 | 375.79 | 5455.0 |
| 2025-04-24 07:00:00 | MSFT | Stock | 375.37 | 375.39 | 373.65 | 374.41 | 4178.0 |
| 2025-04-24 08:00:00 | MSFT | Stock | 375.37 | 376.02 | 373.21 | 375.35 | 18085.0 |
| 2025-04-24 09:00:00 | MSFT | Stock | 375.6 | 381.52 | 375.0 | 381.48 | 1189319.0 |
| 2025-04-24 10:00:00 | MSFT | Stock | 381.39 | 384.46 | 380.96 | 383.165 | 1383762.0 |
| 2025-04-24 11:00:00 | MSFT | Stock | 383.18 | 384.51 | 382.56 | 383.33 | 844933.0 |
| 2025-04-24 12:00:00 | MSFT | Stock | 383.325 | 385.16 | 382.7381 | 384.73 | 942291.0 |
| 2025-04-24 13:00:00 | MSFT | Stock | 384.71 | 385.88 | 383.7 | 385.72 | 760103.0 |
| 2025-04-24 14:00:00 | MSFT | Stock | 385.67 | 387.59 | 385.29 | 386.99 | 936936.0 |
| 2025-04-24 15:00:00 | MSFT | Stock | 387.01 | 388.45 | 385.77 | 387.27 | 2455718.0 |
| 2025-04-24 16:00:00 | MSFT | Stock | 387.11 | 388.98 | 386.54 | 387.5 | 6167849.0 |
| 2025-04-24 17:00:00 | MSFT | Stock | 387.99 | 389.74 | 387.2417 | 389.35 | 33654.0 |
| 2025-04-24 18:00:00 | MSFT | Stock | 389.0 | 389.0 | 387.2 | 388.8 | 9528.0 |
| 2025-04-24 19:00:00 | MSFT | Stock | 388.99 | 389.0 | 387.38 | 387.63 | 11794.0 |
| 2025-04-24 04:00:00 | NVDA | Stock | 101.5 | 101.91 | 100.61 | 100.94 | 633244.0 |
| 2025-04-24 05:00:00 | NVDA | Stock | 100.95 | 101.99 | 100.92 | 101.9 | 519397.0 |
| 2025-04-24 06:00:00 | NVDA | Stock | 101.92 | 103.03 | 101.8 | 102.76 | 938781.0 |
| 2025-04-24 07:00:00 | NVDA | Stock | 102.76 | 102.82 | 102.31 | 102.69 | 720013.0 |
| 2025-04-24 08:00:00 | NVDA | Stock | 102.54 | 103.61 | 100.7271 | 103.59 | 2644957.0 |
| 2025-04-24 09:00:00 | NVDA | Stock | 103.58 | 105.15 | 103.11 | 104.9487 | 26375286.0 |
| 2025-04-24 10:00:00 | NVDA | Stock | 104.945 | 105.59 | 104.46 | 104.85 | 29923612.0 |
| 2025-04-24 11:00:00 | NVDA | Stock | 104.85 | 105.99 | 104.76 | 105.2987 | 23312931.0 |
| 2025-04-24 12:00:00 | NVDA | Stock | 105.3 | 106.27 | 105.0379 | 106.155 | 19675648.0 |
| 2025-04-24 13:00:00 | NVDA | Stock | 106.155 | 106.46 | 105.86 | 106.26 | 16642396.0 |
| 2025-04-24 14:00:00 | NVDA | Stock | 106.255 | 106.5 | 106.09 | 106.1683 | 13366305.0 |
| 2025-04-24 15:00:00 | NVDA | Stock | 106.16 | 106.54 | 105.51 | 106.38 | 26139669.0 |
| 2025-04-24 16:00:00 | NVDA | Stock | 106.37 | 106.6 | 106.0 | 106.15 | 27158443.0 |
| 2025-04-24 17:00:00 | NVDA | Stock | 106.1018 | 106.99 | 106.1 | 106.99 | 932560.0 |
| 2025-04-24 18:00:00 | NVDA | Stock | 106.99 | 106.99 | 106.55 | 106.92 | 616159.0 |
| 2025-04-24 19:00:00 | NVDA | Stock | 106.92 | 107.9 | 106.85 | 107.72 | 1146287.0 |
| 2025-04-24 04:00:00 | AMZN | Stock | 181.12 | 181.2 | 178.31 | 178.6 | 34191.0 |
| 2025-04-24 05:00:00 | AMZN | Stock | 178.79 | 179.4 | 178.56 | 179.16 | 16711.0 |
> showing 50 of 61,918 rows — these rows as CSV