PREVIEW / stock_1hour / 2024-11-29
file: by_date/stock_1hour/2024/2024-11-29.parquet size: 1.0 MB rows: 43,096 symbols: 682
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-29 04:00:00 | AAPL | Stock | 235.37 | 235.37 | 234.96 | 235.07 | 4635.0 |
| 2024-11-29 05:00:00 | AAPL | Stock | 234.94 | 235.0 | 234.78 | 234.8 | 2652.0 |
| 2024-11-29 06:00:00 | AAPL | Stock | 234.63 | 234.63 | 234.4 | 234.42 | 4265.0 |
| 2024-11-29 07:00:00 | AAPL | Stock | 234.41 | 234.8 | 234.4 | 234.58 | 17381.0 |
| 2024-11-29 08:00:00 | AAPL | Stock | 234.56 | 235.49 | 234.3 | 234.31 | 63051.0 |
| 2024-11-29 09:00:00 | AAPL | Stock | 234.39 | 235.69 | 233.97 | 235.64 | 2823842.0 |
| 2024-11-29 10:00:00 | AAPL | Stock | 235.63 | 235.89 | 235.14 | 235.81 | 2592120.0 |
| 2024-11-29 11:00:00 | AAPL | Stock | 235.82 | 237.14 | 235.75 | 237.06 | 3354360.0 |
| 2024-11-29 12:00:00 | AAPL | Stock | 237.06 | 237.81 | 236.36 | 237.34 | 5017818.0 |
| 2024-11-29 13:00:00 | AAPL | Stock | 237.33 | 237.9 | 237.29 | 237.52 | 6491105.0 |
| 2024-11-29 14:00:00 | AAPL | Stock | 237.49 | 237.57 | 237.33 | 237.41 | 47570.0 |
| 2024-11-29 15:00:00 | AAPL | Stock | 237.4 | 237.5 | 237.22 | 237.5 | 28267.0 |
| 2024-11-29 16:00:00 | AAPL | Stock | 237.4 | 237.5 | 237.32 | 237.4897 | 27449.0 |
| 2024-11-29 04:00:00 | MSFT | Stock | 421.63 | 421.63 | 420.22 | 420.67 | 7796.0 |
| 2024-11-29 05:00:00 | MSFT | Stock | 421.0 | 421.0 | 420.9 | 420.9 | 2869.0 |
| 2024-11-29 06:00:00 | MSFT | Stock | 420.64 | 420.84 | 420.41 | 420.5 | 1594.0 |
| 2024-11-29 07:00:00 | MSFT | Stock | 420.6 | 421.75 | 420.6 | 420.83 | 21771.0 |
| 2024-11-29 08:00:00 | MSFT | Stock | 420.8241 | 422.25 | 420.5 | 420.9995 | 19177.0 |
| 2024-11-29 09:00:00 | MSFT | Stock | 421.18 | 422.1352 | 417.8 | 419.94 | 2068109.0 |
| 2024-11-29 10:00:00 | MSFT | Stock | 419.92 | 422.86 | 418.82 | 421.97 | 1496705.0 |
| 2024-11-29 11:00:00 | MSFT | Stock | 421.93 | 423.96 | 421.93 | 423.89 | 902873.0 |
| 2024-11-29 12:00:00 | MSFT | Stock | 423.83 | 424.8849 | 423.36 | 423.46 | 1675554.0 |
| 2024-11-29 13:00:00 | MSFT | Stock | 423.46 | 424.38 | 423.17 | 423.17 | 3074368.0 |
| 2024-11-29 14:00:00 | MSFT | Stock | 423.27 | 423.46 | 423.0 | 423.08 | 4186.0 |
| 2024-11-29 15:00:00 | MSFT | Stock | 423.2 | 423.3129 | 423.0 | 423.0 | 2401.0 |
| 2024-11-29 16:00:00 | MSFT | Stock | 423.0 | 423.1 | 422.75 | 423.1 | 1517.0 |
| 2024-11-29 04:00:00 | NVDA | Stock | 137.6 | 137.95 | 137.01 | 137.45 | 337728.0 |
| 2024-11-29 05:00:00 | NVDA | Stock | 137.45 | 137.7 | 137.24 | 137.54 | 154949.0 |
| 2024-11-29 06:00:00 | NVDA | Stock | 137.59 | 137.8 | 137.31 | 137.34 | 148116.0 |
| 2024-11-29 07:00:00 | NVDA | Stock | 137.33 | 137.45 | 136.6 | 136.95 | 612554.0 |
| 2024-11-29 08:00:00 | NVDA | Stock | 137.34 | 137.85 | 136.27 | 136.603 | 1723204.0 |
| 2024-11-29 09:00:00 | NVDA | Stock | 136.63 | 138.49 | 136.05 | 138.47 | 23531754.0 |
| 2024-11-29 10:00:00 | NVDA | Stock | 138.475 | 139.35 | 138.0 | 138.3899 | 31640241.0 |
| 2024-11-29 11:00:00 | NVDA | Stock | 138.385 | 139.0192 | 138.13 | 138.9 | 17462909.0 |
| 2024-11-29 12:00:00 | NVDA | Stock | 138.89 | 139.08 | 138.24 | 138.28 | 21030730.0 |
| 2024-11-29 13:00:00 | NVDA | Stock | 138.28 | 138.38 | 138.0 | 138.26 | 15427147.0 |
| 2024-11-29 14:00:00 | NVDA | Stock | 138.23 | 138.3 | 138.0999 | 138.19 | 206007.0 |
| 2024-11-29 15:00:00 | NVDA | Stock | 138.19 | 138.22 | 138.0 | 138.12 | 183878.0 |
| 2024-11-29 16:00:00 | NVDA | Stock | 138.1697 | 138.2 | 138.06 | 138.14 | 203834.0 |
| 2024-11-29 04:00:00 | AMZN | Stock | 207.05 | 207.54 | 207.04 | 207.36 | 8278.0 |
| 2024-11-29 05:00:00 | AMZN | Stock | 207.14 | 207.43 | 207.0 | 207.01 | 10444.0 |
| 2024-11-29 06:00:00 | AMZN | Stock | 207.03 | 207.25 | 206.97 | 207.25 | 2242.0 |
| 2024-11-29 07:00:00 | AMZN | Stock | 207.15 | 207.16 | 206.55 | 206.7 | 21440.0 |
| 2024-11-29 08:00:00 | AMZN | Stock | 206.7 | 207.33 | 206.37 | 206.79 | 120892.0 |
| 2024-11-29 09:00:00 | AMZN | Stock | 206.79 | 207.25 | 204.59 | 206.0299 | 3278898.0 |
| 2024-11-29 10:00:00 | AMZN | Stock | 206.005 | 206.36 | 205.4801 | 205.9 | 2513958.0 |
| 2024-11-29 11:00:00 | AMZN | Stock | 205.91 | 206.73 | 205.56 | 206.47 | 2020222.0 |
| 2024-11-29 12:00:00 | AMZN | Stock | 206.455 | 208.2 | 206.28 | 207.91 | 3662334.0 |
| 2024-11-29 13:00:00 | AMZN | Stock | 207.89 | 208.16 | 207.47 | 207.8 | 4085314.0 |
| 2024-11-29 14:00:00 | AMZN | Stock | 207.85 | 208.12 | 207.75 | 208.05 | 30866.0 |
> showing 50 of 43,096 rows — these rows as CSV