PREVIEW / stock_1hour / 2025-04-16
file: by_date/stock_1hour/2025/2025-04-16.parquet size: 1.4 MB rows: 61,009 symbols: 428
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-16 04:00:00 | AAPL | Stock | 198.8 | 202.46 | 197.03 | 200.3 | 90370.0 |
| 2025-04-16 05:00:00 | AAPL | Stock | 200.5 | 200.86 | 199.81 | 199.81 | 17991.0 |
| 2025-04-16 06:00:00 | AAPL | Stock | 199.94 | 200.6 | 199.94 | 200.31 | 16990.0 |
| 2025-04-16 07:00:00 | AAPL | Stock | 200.39 | 200.65 | 199.86 | 200.14 | 50695.0 |
| 2025-04-16 08:00:00 | AAPL | Stock | 200.34 | 200.62 | 197.58 | 199.4 | 195787.0 |
| 2025-04-16 09:00:00 | AAPL | Stock | 199.33 | 200.7 | 196.27 | 196.56 | 6828974.0 |
| 2025-04-16 10:00:00 | AAPL | Stock | 196.55 | 198.45 | 196.0 | 197.58 | 6229378.0 |
| 2025-04-16 11:00:00 | AAPL | Stock | 197.58 | 199.0 | 196.71 | 196.75 | 3730077.0 |
| 2025-04-16 12:00:00 | AAPL | Stock | 196.755 | 197.36 | 196.3905 | 197.2127 | 2654343.0 |
| 2025-04-16 13:00:00 | AAPL | Stock | 197.225 | 197.92 | 193.92 | 193.985 | 4991350.0 |
| 2025-04-16 14:00:00 | AAPL | Stock | 193.985 | 195.4 | 193.3 | 193.34 | 4106411.0 |
| 2025-04-16 15:00:00 | AAPL | Stock | 193.33 | 194.8635 | 192.37 | 194.3 | 7649927.0 |
| 2025-04-16 16:00:00 | AAPL | Stock | 194.3 | 195.13 | 194.02 | 194.56 | 9180955.0 |
| 2025-04-16 17:00:00 | AAPL | Stock | 194.45 | 195.14 | 194.27 | 194.99 | 53564.0 |
| 2025-04-16 18:00:00 | AAPL | Stock | 194.87 | 195.15 | 194.6 | 194.8033 | 14582.0 |
| 2025-04-16 19:00:00 | AAPL | Stock | 194.97 | 195.19 | 194.51 | 194.94 | 28054.0 |
| 2025-04-16 04:00:00 | MSFT | Stock | 381.04 | 385.0 | 380.23 | 383.33 | 3710.0 |
| 2025-04-16 05:00:00 | MSFT | Stock | 383.74 | 384.16 | 382.98 | 383.62 | 4954.0 |
| 2025-04-16 06:00:00 | MSFT | Stock | 383.29 | 383.62 | 382.57 | 382.61 | 2241.0 |
| 2025-04-16 07:00:00 | MSFT | Stock | 382.12 | 383.0 | 381.79 | 382.7 | 2656.0 |
| 2025-04-16 08:00:00 | MSFT | Stock | 383.0 | 384.17 | 379.44 | 381.15 | 23606.0 |
| 2025-04-16 09:00:00 | MSFT | Stock | 381.0 | 382.0 | 376.05 | 376.16 | 1695622.0 |
| 2025-04-16 10:00:00 | MSFT | Stock | 376.2 | 379.31 | 375.9 | 378.39 | 1098546.0 |
| 2025-04-16 11:00:00 | MSFT | Stock | 378.435 | 380.11 | 376.61 | 376.74 | 1032972.0 |
| 2025-04-16 12:00:00 | MSFT | Stock | 376.74 | 377.79 | 376.43 | 377.295 | 708260.0 |
| 2025-04-16 13:00:00 | MSFT | Stock | 377.24 | 377.68 | 372.0 | 372.28 | 1399443.0 |
| 2025-04-16 14:00:00 | MSFT | Stock | 372.23 | 373.87 | 370.46 | 370.57 | 1252867.0 |
| 2025-04-16 15:00:00 | MSFT | Stock | 370.57 | 372.35 | 368.0 | 371.61 | 3411894.0 |
| 2025-04-16 16:00:00 | MSFT | Stock | 371.61 | 372.97 | 371.0 | 371.88 | 4454795.0 |
| 2025-04-16 17:00:00 | MSFT | Stock | 371.8445 | 372.15 | 371.59 | 372.15 | 6275.0 |
| 2025-04-16 18:00:00 | MSFT | Stock | 372.04 | 372.46 | 372.0 | 372.46 | 2752.0 |
| 2025-04-16 19:00:00 | MSFT | Stock | 372.5 | 372.79 | 371.02 | 372.0 | 4062.0 |
| 2025-04-16 04:00:00 | NVDA | Stock | 105.25 | 107.38 | 104.21 | 106.24 | 2680021.0 |
| 2025-04-16 05:00:00 | NVDA | Stock | 106.26 | 106.59 | 105.46 | 105.7 | 1923902.0 |
| 2025-04-16 06:00:00 | NVDA | Stock | 105.7 | 105.97 | 105.41 | 105.79 | 502937.0 |
| 2025-04-16 07:00:00 | NVDA | Stock | 105.79 | 105.81 | 104.58 | 104.92 | 2167453.0 |
| 2025-04-16 08:00:00 | NVDA | Stock | 105.29 | 107.25 | 103.52 | 104.6499 | 5628118.0 |
| 2025-04-16 09:00:00 | NVDA | Stock | 104.62 | 106.79 | 104.14 | 105.225 | 48581719.0 |
| 2025-04-16 10:00:00 | NVDA | Stock | 105.22 | 105.75 | 104.07 | 104.3599 | 45435314.0 |
| 2025-04-16 11:00:00 | NVDA | Stock | 104.355 | 105.44 | 103.8 | 104.4182 | 33356502.0 |
| 2025-04-16 12:00:00 | NVDA | Stock | 104.415 | 104.48 | 103.56 | 103.645 | 26077498.0 |
| 2025-04-16 13:00:00 | NVDA | Stock | 103.65 | 104.0 | 101.88 | 102.015 | 36549298.0 |
| 2025-04-16 14:00:00 | NVDA | Stock | 102.015 | 102.74 | 100.45 | 101.045 | 42949145.0 |
| 2025-04-16 15:00:00 | NVDA | Stock | 101.05 | 104.55 | 100.67 | 104.5 | 57501846.0 |
| 2025-04-16 16:00:00 | NVDA | Stock | 104.5 | 104.55 | 103.0 | 103.05 | 33143943.0 |
| 2025-04-16 17:00:00 | NVDA | Stock | 103.051 | 103.78 | 103.03 | 103.5999 | 816610.0 |
| 2025-04-16 18:00:00 | NVDA | Stock | 103.6 | 104.05 | 103.51 | 103.92 | 625916.0 |
| 2025-04-16 19:00:00 | NVDA | Stock | 103.91 | 103.93 | 103.25 | 103.3805 | 504102.0 |
| 2025-04-16 04:00:00 | AMZN | Stock | 176.59 | 180.13 | 175.61 | 178.26 | 53006.0 |
| 2025-04-16 05:00:00 | AMZN | Stock | 178.5 | 178.56 | 177.8 | 177.8 | 21811.0 |
> showing 50 of 61,009 rows — these rows as CSV