PREVIEW / stock_1hour / 2025-04-09
file: by_date/stock_1hour/2025/2025-04-09.parquet size: 1.5 MB rows: 65,969 symbols: 452
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-09 04:00:00 | AAPL | Stock | 172.1 | 177.09 | 172.1 | 175.7 | 347956.0 |
| 2025-04-09 05:00:00 | AAPL | Stock | 175.74 | 176.4 | 174.43 | 175.3 | 120822.0 |
| 2025-04-09 06:00:00 | AAPL | Stock | 175.29 | 177.14 | 173.95 | 176.02 | 162882.0 |
| 2025-04-09 07:00:00 | AAPL | Stock | 176.07 | 176.37 | 168.38 | 168.8 | 877980.0 |
| 2025-04-09 08:00:00 | AAPL | Stock | 173.8 | 176.065 | 168.0 | 172.0 | 1115526.0 |
| 2025-04-09 09:00:00 | AAPL | Stock | 172.03 | 178.9 | 171.49 | 177.385 | 14390548.0 |
| 2025-04-09 10:00:00 | AAPL | Stock | 177.4 | 180.42 | 176.72 | 177.72 | 13789500.0 |
| 2025-04-09 11:00:00 | AAPL | Stock | 177.7 | 180.53 | 177.595 | 178.73 | 10098914.0 |
| 2025-04-09 12:00:00 | AAPL | Stock | 178.71 | 181.36 | 177.875 | 181.07 | 7059924.0 |
| 2025-04-09 13:00:00 | AAPL | Stock | 181.1 | 194.8699 | 179.3 | 193.105 | 22925317.0 |
| 2025-04-09 14:00:00 | AAPL | Stock | 193.1 | 194.6499 | 184.18 | 184.9 | 17903750.0 |
| 2025-04-09 15:00:00 | AAPL | Stock | 184.9 | 200.61 | 183.87 | 198.85 | 31199232.0 |
| 2025-04-09 16:00:00 | AAPL | Stock | 198.89 | 199.03 | 197.47 | 198.5 | 20576556.0 |
| 2025-04-09 17:00:00 | AAPL | Stock | 198.4985 | 199.4 | 196.49 | 196.66 | 376493.0 |
| 2025-04-09 18:00:00 | AAPL | Stock | 196.7 | 197.71 | 196.33 | 197.48 | 155696.0 |
| 2025-04-09 19:00:00 | AAPL | Stock | 197.4779 | 197.9999 | 196.56 | 197.7118 | 134868.0 |
| 2025-04-09 04:00:00 | MSFT | Stock | 355.23 | 357.01 | 352.37 | 355.94 | 13912.0 |
| 2025-04-09 05:00:00 | MSFT | Stock | 356.31 | 356.63 | 354.27 | 354.6 | 11197.0 |
| 2025-04-09 06:00:00 | MSFT | Stock | 354.47 | 356.36 | 351.8 | 355.62 | 11480.0 |
| 2025-04-09 07:00:00 | MSFT | Stock | 353.88 | 353.88 | 348.41 | 350.38 | 44324.0 |
| 2025-04-09 08:00:00 | MSFT | Stock | 351.57 | 359.36 | 346.75 | 352.4 | 96792.0 |
| 2025-04-09 09:00:00 | MSFT | Stock | 354.21 | 361.87 | 351.75 | 360.908 | 2604979.0 |
| 2025-04-09 10:00:00 | MSFT | Stock | 360.85 | 363.12 | 357.37 | 357.6951 | 2113620.0 |
| 2025-04-09 11:00:00 | MSFT | Stock | 357.715 | 362.9 | 357.53 | 360.9701 | 1886959.0 |
| 2025-04-09 12:00:00 | MSFT | Stock | 361.04 | 366.5 | 360.27 | 365.94 | 1760868.0 |
| 2025-04-09 13:00:00 | MSFT | Stock | 365.94 | 387.07 | 362.86 | 383.98 | 6389433.0 |
| 2025-04-09 14:00:00 | MSFT | Stock | 384.09 | 386.0499 | 381.4025 | 382.82 | 3672874.0 |
| 2025-04-09 15:00:00 | MSFT | Stock | 382.9 | 393.225 | 382.09 | 390.43 | 5493869.0 |
| 2025-04-09 16:00:00 | MSFT | Stock | 390.12 | 392.0 | 388.41 | 391.0 | 9921924.0 |
| 2025-04-09 17:00:00 | MSFT | Stock | 390.9891 | 392.0 | 390.49 | 390.49 | 39478.0 |
| 2025-04-09 18:00:00 | MSFT | Stock | 390.79 | 392.97 | 390.0 | 391.75 | 26409.0 |
| 2025-04-09 19:00:00 | MSFT | Stock | 392.0 | 392.88 | 390.6201 | 391.1 | 15309.0 |
| 2025-04-09 04:00:00 | NVDA | Stock | 99.5 | 101.16 | 95.51 | 99.39 | 2947637.0 |
| 2025-04-09 05:00:00 | NVDA | Stock | 99.49 | 100.16 | 98.35 | 98.8 | 1305843.0 |
| 2025-04-09 06:00:00 | NVDA | Stock | 98.84 | 99.15 | 97.38 | 98.15 | 1062967.0 |
| 2025-04-09 07:00:00 | NVDA | Stock | 98.18 | 98.31 | 94.6 | 95.77 | 3716323.0 |
| 2025-04-09 08:00:00 | NVDA | Stock | 97.53 | 99.92 | 93.25 | 97.8009 | 8225752.0 |
| 2025-04-09 09:00:00 | NVDA | Stock | 97.82 | 100.4399 | 97.5301 | 99.775 | 46535240.0 |
| 2025-04-09 10:00:00 | NVDA | Stock | 99.79 | 101.18 | 97.84 | 97.85 | 52561556.0 |
| 2025-04-09 11:00:00 | NVDA | Stock | 97.875 | 99.87 | 97.72 | 98.56 | 33147308.0 |
| 2025-04-09 12:00:00 | NVDA | Stock | 98.57 | 101.3 | 98.12 | 100.6692 | 36280815.0 |
| 2025-04-09 13:00:00 | NVDA | Stock | 100.66 | 110.42 | 100.26 | 110.1284 | 102733322.0 |
| 2025-04-09 14:00:00 | NVDA | Stock | 110.125 | 112.99 | 109.566 | 111.07 | 79764762.0 |
| 2025-04-09 15:00:00 | NVDA | Stock | 111.08 | 115.1 | 110.37 | 114.25 | 90984312.0 |
| 2025-04-09 16:00:00 | NVDA | Stock | 114.22 | 114.6 | 113.15 | 114.0 | 55503913.0 |
| 2025-04-09 17:00:00 | NVDA | Stock | 114.01 | 114.25 | 112.29 | 112.7815 | 2243208.0 |
| 2025-04-09 18:00:00 | NVDA | Stock | 112.86 | 113.6 | 112.4 | 113.57 | 1401032.0 |
| 2025-04-09 19:00:00 | NVDA | Stock | 113.57 | 113.69 | 112.22 | 112.589 | 1507650.0 |
| 2025-04-09 04:00:00 | AMZN | Stock | 172.75 | 173.99 | 170.0 | 172.6 | 102952.0 |
| 2025-04-09 05:00:00 | AMZN | Stock | 172.83 | 172.98 | 170.74 | 171.35 | 49960.0 |
> showing 50 of 65,969 rows — these rows as CSV