PREVIEW / stock_1hour / 2024-01-04
file: by_date/stock_1hour/2024/2024-01-04.parquet size: 1.3 MB rows: 59,573 symbols: 1,206
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-01-04 04:00:00 | AAPL | Stock | 183.3 | 183.3 | 182.7 | 183.09 | 49017.0 |
| 2024-01-04 05:00:00 | AAPL | Stock | 183.01 | 183.08 | 182.55 | 182.75 | 15614.0 |
| 2024-01-04 06:00:00 | AAPL | Stock | 182.77 | 183.14 | 182.67 | 182.67 | 17848.0 |
| 2024-01-04 07:00:00 | AAPL | Stock | 182.75 | 183.25 | 182.66 | 182.66 | 56755.0 |
| 2024-01-04 08:00:00 | AAPL | Stock | 182.83 | 184.94 | 181.88 | 181.98 | 396267.0 |
| 2024-01-04 09:00:00 | AAPL | Stock | 181.96 | 183.0872 | 181.2276 | 181.4801 | 8258175.0 |
| 2024-01-04 10:00:00 | AAPL | Stock | 181.48 | 182.1438 | 180.88 | 181.49 | 9982123.0 |
| 2024-01-04 11:00:00 | AAPL | Stock | 181.49 | 182.44 | 181.32 | 181.44 | 6507628.0 |
| 2024-01-04 12:00:00 | AAPL | Stock | 181.44 | 182.39 | 181.43 | 182.235 | 4465060.0 |
| 2024-01-04 13:00:00 | AAPL | Stock | 182.23 | 183.07 | 182.17 | 182.75 | 4108178.0 |
| 2024-01-04 14:00:00 | AAPL | Stock | 182.75 | 182.96 | 182.265 | 182.3 | 3685241.0 |
| 2024-01-04 15:00:00 | AAPL | Stock | 182.31 | 182.5499 | 181.43 | 181.92 | 8800150.0 |
| 2024-01-04 16:00:00 | AAPL | Stock | 181.92 | 182.0899 | 181.64 | 181.83 | 7840227.0 |
| 2024-01-04 17:00:00 | AAPL | Stock | 181.82 | 181.91 | 181.69 | 181.9 | 34261.0 |
| 2024-01-04 18:00:00 | AAPL | Stock | 181.91 | 182.1 | 181.86 | 181.88 | 26203.0 |
| 2024-01-04 19:00:00 | AAPL | Stock | 181.88 | 181.99 | 181.83 | 181.9101 | 22485.0 |
| 2024-01-04 04:00:00 | MSFT | Stock | 371.09 | 371.2 | 371.05 | 371.16 | 533.0 |
| 2024-01-04 05:00:00 | MSFT | Stock | 371.2 | 371.43 | 371.0 | 371.41 | 1221.0 |
| 2024-01-04 06:00:00 | MSFT | Stock | 371.49 | 371.59 | 371.49 | 371.58 | 456.0 |
| 2024-01-04 07:00:00 | MSFT | Stock | 371.31 | 371.86 | 371.15 | 371.86 | 6096.0 |
| 2024-01-04 08:00:00 | MSFT | Stock | 371.7 | 371.99 | 370.44 | 370.69 | 44271.0 |
| 2024-01-04 09:00:00 | MSFT | Stock | 370.5899 | 372.64 | 370.3 | 371.54 | 1429366.0 |
| 2024-01-04 10:00:00 | MSFT | Stock | 371.525 | 372.47 | 371.06 | 371.76 | 1431316.0 |
| 2024-01-04 11:00:00 | MSFT | Stock | 371.77 | 373.1 | 371.0 | 371.02 | 1416911.0 |
| 2024-01-04 12:00:00 | MSFT | Stock | 371.03 | 371.46 | 369.92 | 370.365 | 1067855.0 |
| 2024-01-04 13:00:00 | MSFT | Stock | 370.36 | 370.76 | 370.1787 | 370.3 | 658913.0 |
| 2024-01-04 14:00:00 | MSFT | Stock | 370.2805 | 370.7722 | 369.16 | 369.27 | 1196409.0 |
| 2024-01-04 15:00:00 | MSFT | Stock | 369.28 | 369.31 | 367.17 | 367.95 | 3140757.0 |
| 2024-01-04 16:00:00 | MSFT | Stock | 367.94 | 367.9725 | 367.5 | 367.66 | 4031700.0 |
| 2024-01-04 17:00:00 | MSFT | Stock | 367.75 | 368.25 | 367.75 | 368.1 | 11979.0 |
| 2024-01-04 18:00:00 | MSFT | Stock | 368.25 | 368.82 | 368.25 | 368.4901 | 9067.0 |
| 2024-01-04 19:00:00 | MSFT | Stock | 368.68 | 368.82 | 368.4501 | 368.65 | 6066.0 |
| 2024-01-04 04:00:00 | NVDA | Stock | 47.787 | 47.917 | 47.749 | 47.88 | 39630.0 |
| 2024-01-04 05:00:00 | NVDA | Stock | 47.869 | 47.92 | 47.869 | 47.887 | 23560.0 |
| 2024-01-04 06:00:00 | NVDA | Stock | 47.924 | 47.935 | 47.73 | 47.73 | 55630.0 |
| 2024-01-04 07:00:00 | NVDA | Stock | 47.797 | 47.8 | 47.555 | 47.711 | 331530.0 |
| 2024-01-04 08:00:00 | NVDA | Stock | 47.725 | 47.82 | 47.569 | 47.689 | 1102630.0 |
| 2024-01-04 09:00:00 | NVDA | Stock | 47.686 | 48.064 | 47.58 | 47.645 | 35906550.0 |
| 2024-01-04 10:00:00 | NVDA | Stock | 47.632 | 48.137 | 47.508 | 48.035 | 43736230.0 |
| 2024-01-04 11:00:00 | NVDA | Stock | 48.045 | 48.5 | 48.037 | 48.303 | 45523250.0 |
| 2024-01-04 12:00:00 | NVDA | Stock | 48.3 | 48.36 | 48.053 | 48.2075 | 22184480.0 |
| 2024-01-04 13:00:00 | NVDA | Stock | 48.205 | 48.392 | 48.1612 | 48.3161 | 16891450.0 |
| 2024-01-04 14:00:00 | NVDA | Stock | 48.311 | 48.363 | 48.089 | 48.22 | 18836550.0 |
| 2024-01-04 15:00:00 | NVDA | Stock | 48.23 | 48.355 | 47.98 | 47.994 | 32440780.0 |
| 2024-01-04 16:00:00 | NVDA | Stock | 47.995 | 48.045 | 47.965 | 47.966 | 18428420.0 |
| 2024-01-04 17:00:00 | NVDA | Stock | 47.9798 | 47.998 | 47.965 | 47.994 | 117380.0 |
| 2024-01-04 18:00:00 | NVDA | Stock | 47.995 | 48.094 | 47.995 | 48.075 | 183820.0 |
| 2024-01-04 19:00:00 | NVDA | Stock | 48.075 | 48.178 | 48.07 | 48.125 | 260070.0 |
| 2024-01-04 04:00:00 | AMZN | Stock | 148.98 | 149.2 | 148.98 | 149.11 | 3907.0 |
| 2024-01-04 05:00:00 | AMZN | Stock | 149.18 | 149.24 | 148.9 | 148.95 | 13792.0 |
> showing 50 of 59,573 rows — these rows as CSV