PREVIEW / stock_1hour / 2024-10-29
file: by_date/stock_1hour/2024/2024-10-29.parquet size: 1.4 MB rows: 60,924 symbols: 746
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-10-29 04:00:00 | AAPL | Stock | 232.7 | 233.2 | 232.29 | 232.98 | 16323.0 |
| 2024-10-29 05:00:00 | AAPL | Stock | 233.11 | 233.11 | 232.5 | 232.68 | 9923.0 |
| 2024-10-29 06:00:00 | AAPL | Stock | 232.69 | 232.69 | 232.42 | 232.6 | 8895.0 |
| 2024-10-29 07:00:00 | AAPL | Stock | 232.58 | 232.69 | 231.76 | 232.27 | 42727.0 |
| 2024-10-29 08:00:00 | AAPL | Stock | 232.35 | 233.17 | 231.6 | 232.25 | 95632.0 |
| 2024-10-29 09:00:00 | AAPL | Stock | 232.36 | 233.95 | 232.01 | 233.605 | 3047544.0 |
| 2024-10-29 10:00:00 | AAPL | Stock | 233.6 | 234.07 | 233.03 | 233.49 | 3110025.0 |
| 2024-10-29 11:00:00 | AAPL | Stock | 233.505 | 233.63 | 233.0201 | 233.34 | 1781545.0 |
| 2024-10-29 12:00:00 | AAPL | Stock | 233.35 | 233.98 | 233.01 | 233.9501 | 1908069.0 |
| 2024-10-29 13:00:00 | AAPL | Stock | 233.95 | 234.21 | 233.77 | 233.82 | 1303440.0 |
| 2024-10-29 14:00:00 | AAPL | Stock | 233.815 | 234.19 | 233.76 | 234.09 | 1382325.0 |
| 2024-10-29 15:00:00 | AAPL | Stock | 234.095 | 234.325 | 233.54 | 233.75 | 3422765.0 |
| 2024-10-29 16:00:00 | AAPL | Stock | 233.78 | 233.78 | 231.76 | 232.51 | 6128725.0 |
| 2024-10-29 17:00:00 | AAPL | Stock | 232.51 | 233.67 | 232.39 | 232.46 | 162789.0 |
| 2024-10-29 18:00:00 | AAPL | Stock | 232.4 | 232.89 | 232.4 | 232.83 | 34390.0 |
| 2024-10-29 19:00:00 | AAPL | Stock | 232.8 | 233.19 | 232.61 | 232.93 | 35121.0 |
| 2024-10-29 04:00:00 | MSFT | Stock | 427.4 | 427.97 | 427.11 | 427.82 | 4259.0 |
| 2024-10-29 05:00:00 | MSFT | Stock | 427.72 | 428.0 | 427.71 | 427.98 | 2786.0 |
| 2024-10-29 06:00:00 | MSFT | Stock | 427.9 | 427.9 | 427.51 | 427.61 | 2010.0 |
| 2024-10-29 07:00:00 | MSFT | Stock | 427.3 | 427.3 | 425.4 | 425.9 | 14225.0 |
| 2024-10-29 08:00:00 | MSFT | Stock | 425.5 | 427.5 | 425.4 | 425.94 | 26898.0 |
| 2024-10-29 09:00:00 | MSFT | Stock | 425.9 | 428.54 | 425.8001 | 427.795 | 941805.0 |
| 2024-10-29 10:00:00 | MSFT | Stock | 427.835 | 429.41 | 427.16 | 429.16 | 1103836.0 |
| 2024-10-29 11:00:00 | MSFT | Stock | 429.13 | 430.35 | 428.54 | 430.18 | 930760.0 |
| 2024-10-29 12:00:00 | MSFT | Stock | 430.22 | 431.45 | 429.56 | 431.23 | 728580.0 |
| 2024-10-29 13:00:00 | MSFT | Stock | 431.24 | 432.23 | 430.73 | 431.2 | 739539.0 |
| 2024-10-29 14:00:00 | MSFT | Stock | 431.25 | 432.69 | 431.181 | 432.18 | 660978.0 |
| 2024-10-29 15:00:00 | MSFT | Stock | 432.19 | 433.17 | 431.67 | 431.96 | 1605262.0 |
| 2024-10-29 16:00:00 | MSFT | Stock | 431.96 | 435.6 | 431.95 | 435.35 | 4627575.0 |
| 2024-10-29 17:00:00 | MSFT | Stock | 435.3 | 436.35 | 431.95 | 436.0 | 123770.0 |
| 2024-10-29 18:00:00 | MSFT | Stock | 436.0 | 436.85 | 436.0 | 436.5 | 16515.0 |
| 2024-10-29 19:00:00 | MSFT | Stock | 436.5 | 437.03 | 436.0 | 437.03 | 19118.0 |
| 2024-10-29 04:00:00 | NVDA | Stock | 140.6 | 140.75 | 139.6 | 139.99 | 354820.0 |
| 2024-10-29 05:00:00 | NVDA | Stock | 139.99 | 140.0 | 139.55 | 139.76 | 200836.0 |
| 2024-10-29 06:00:00 | NVDA | Stock | 139.75 | 140.25 | 139.67 | 140.18 | 135875.0 |
| 2024-10-29 07:00:00 | NVDA | Stock | 140.14 | 140.35 | 139.85 | 140.02 | 466103.0 |
| 2024-10-29 08:00:00 | NVDA | Stock | 140.1 | 140.68 | 139.6024 | 139.78 | 1017460.0 |
| 2024-10-29 09:00:00 | NVDA | Stock | 139.79 | 140.73 | 138.9 | 140.4848 | 23010961.0 |
| 2024-10-29 10:00:00 | NVDA | Stock | 140.47 | 141.05 | 139.92 | 140.9188 | 22008341.0 |
| 2024-10-29 11:00:00 | NVDA | Stock | 140.915 | 141.85 | 140.36 | 141.69 | 16483100.0 |
| 2024-10-29 12:00:00 | NVDA | Stock | 141.685 | 142.0 | 141.1979 | 141.385 | 15074577.0 |
| 2024-10-29 13:00:00 | NVDA | Stock | 141.3808 | 141.85 | 141.31 | 141.365 | 10506359.0 |
| 2024-10-29 14:00:00 | NVDA | Stock | 141.37 | 141.97 | 141.25 | 141.7392 | 10364708.0 |
| 2024-10-29 15:00:00 | NVDA | Stock | 141.73 | 142.2598 | 141.02 | 141.28 | 19433723.0 |
| 2024-10-29 16:00:00 | NVDA | Stock | 141.2982 | 141.5 | 140.3 | 140.8 | 14165950.0 |
| 2024-10-29 17:00:00 | NVDA | Stock | 140.77 | 141.25 | 140.6112 | 140.9013 | 1764506.0 |
| 2024-10-29 18:00:00 | NVDA | Stock | 140.9001 | 141.36 | 140.82 | 141.2602 | 358678.0 |
| 2024-10-29 19:00:00 | NVDA | Stock | 141.27 | 141.39 | 141.01 | 141.3899 | 332703.0 |
| 2024-10-29 04:00:00 | AMZN | Stock | 188.67 | 188.86 | 188.5 | 188.61 | 15114.0 |
| 2024-10-29 05:00:00 | AMZN | Stock | 188.61 | 188.79 | 188.58 | 188.58 | 5540.0 |
> showing 50 of 60,924 rows — these rows as CSV