PREVIEW / stock_1hour / 2024-01-03
file: by_date/stock_1hour/2024/2024-01-03.parquet size: 1.4 MB rows: 60,281 symbols: 1,183
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-03 04:00:00 | AAPL | Stock | 185.0 | 185.0 | 184.72 | 184.72 | 12700.0 |
| 2024-01-03 05:00:00 | AAPL | Stock | 184.67 | 184.83 | 184.67 | 184.73 | 10678.0 |
| 2024-01-03 06:00:00 | AAPL | Stock | 184.8 | 185.0 | 184.66 | 185.0 | 10965.0 |
| 2024-01-03 07:00:00 | AAPL | Stock | 184.95 | 184.99 | 184.31 | 184.31 | 48315.0 |
| 2024-01-03 08:00:00 | AAPL | Stock | 184.975 | 185.64 | 184.19 | 184.65 | 154970.0 |
| 2024-01-03 09:00:00 | AAPL | Stock | 184.68 | 185.88 | 183.5 | 184.7701 | 7975469.0 |
| 2024-01-03 10:00:00 | AAPL | Stock | 184.77 | 185.29 | 183.45 | 183.86 | 7833848.0 |
| 2024-01-03 11:00:00 | AAPL | Stock | 183.855 | 184.38 | 183.49 | 183.51 | 4901893.0 |
| 2024-01-03 12:00:00 | AAPL | Stock | 183.505 | 184.37 | 183.43 | 184.335 | 3716674.0 |
| 2024-01-03 13:00:00 | AAPL | Stock | 184.33 | 184.56 | 184.18 | 184.37 | 3020728.0 |
| 2024-01-03 14:00:00 | AAPL | Stock | 184.36 | 184.94 | 183.805 | 184.6499 | 4063216.0 |
| 2024-01-03 15:00:00 | AAPL | Stock | 184.65 | 184.71 | 183.75 | 184.24 | 6053967.0 |
| 2024-01-03 16:00:00 | AAPL | Stock | 184.25 | 184.33 | 184.03 | 184.2 | 8191830.0 |
| 2024-01-03 17:00:00 | AAPL | Stock | 184.18 | 184.25 | 184.0201 | 184.13 | 70949.0 |
| 2024-01-03 18:00:00 | AAPL | Stock | 184.18 | 184.3 | 184.17 | 184.29 | 21154.0 |
| 2024-01-03 19:00:00 | AAPL | Stock | 184.2 | 184.3 | 184.0 | 184.3 | 17799.0 |
| 2024-01-03 04:00:00 | MSFT | Stock | 369.49 | 369.61 | 367.14 | 367.63 | 10143.0 |
| 2024-01-03 05:00:00 | MSFT | Stock | 367.6 | 368.49 | 367.6 | 368.42 | 2616.0 |
| 2024-01-03 06:00:00 | MSFT | Stock | 368.3 | 368.31 | 367.44 | 367.6 | 1631.0 |
| 2024-01-03 07:00:00 | MSFT | Stock | 367.71 | 368.03 | 367.25 | 367.59 | 8476.0 |
| 2024-01-03 08:00:00 | MSFT | Stock | 370.87 | 370.87 | 367.25 | 367.9403 | 42773.0 |
| 2024-01-03 09:00:00 | MSFT | Stock | 367.99 | 373.25 | 367.18 | 372.07 | 2393861.0 |
| 2024-01-03 10:00:00 | MSFT | Stock | 372.06 | 373.2562 | 371.07 | 372.29 | 1899068.0 |
| 2024-01-03 11:00:00 | MSFT | Stock | 372.31 | 372.8299 | 370.56 | 370.7993 | 1318969.0 |
| 2024-01-03 12:00:00 | MSFT | Stock | 370.8 | 372.44 | 370.7247 | 372.42 | 884857.0 |
| 2024-01-03 13:00:00 | MSFT | Stock | 372.3888 | 372.67 | 371.02 | 371.548 | 728011.0 |
| 2024-01-03 14:00:00 | MSFT | Stock | 371.4995 | 372.29 | 370.44 | 371.6953 | 1025386.0 |
| 2024-01-03 15:00:00 | MSFT | Stock | 371.68 | 371.87 | 369.5 | 370.6 | 1883113.0 |
| 2024-01-03 16:00:00 | MSFT | Stock | 370.6 | 370.6 | 370.01 | 370.14 | 4161637.0 |
| 2024-01-03 17:00:00 | MSFT | Stock | 370.141 | 370.6 | 370.141 | 370.5 | 3311.0 |
| 2024-01-03 18:00:00 | MSFT | Stock | 370.5 | 370.8899 | 370.31 | 370.65 | 3900.0 |
| 2024-01-03 19:00:00 | MSFT | Stock | 370.65 | 371.28 | 370.32 | 371.05 | 16962.0 |
| 2024-01-03 04:00:00 | NVDA | Stock | 47.9 | 47.9 | 47.55 | 47.581 | 143180.0 |
| 2024-01-03 05:00:00 | NVDA | Stock | 47.54 | 47.676 | 47.534 | 47.605 | 65270.0 |
| 2024-01-03 06:00:00 | NVDA | Stock | 47.614 | 47.614 | 47.475 | 47.532 | 77040.0 |
| 2024-01-03 07:00:00 | NVDA | Stock | 47.538 | 47.64 | 47.267 | 47.35 | 1164320.0 |
| 2024-01-03 08:00:00 | NVDA | Stock | 47.6 | 48.168 | 47.2591 | 47.45 | 2009710.0 |
| 2024-01-03 09:00:00 | NVDA | Stock | 47.475 | 48.1841 | 47.32 | 47.8006 | 49324630.0 |
| 2024-01-03 10:00:00 | NVDA | Stock | 47.804 | 48.0 | 47.328 | 47.6432 | 52282080.0 |
| 2024-01-03 11:00:00 | NVDA | Stock | 47.648 | 47.926 | 47.648 | 47.744 | 27950850.0 |
| 2024-01-03 12:00:00 | NVDA | Stock | 47.748 | 47.879 | 47.663 | 47.8285 | 15927330.0 |
| 2024-01-03 13:00:00 | NVDA | Stock | 47.825 | 47.873 | 47.52 | 47.599 | 18421710.0 |
| 2024-01-03 14:00:00 | NVDA | Stock | 47.595 | 47.81 | 47.445 | 47.696 | 25736990.0 |
| 2024-01-03 15:00:00 | NVDA | Stock | 47.6915 | 47.75 | 47.45 | 47.569 | 31279950.0 |
| 2024-01-03 16:00:00 | NVDA | Stock | 47.568 | 47.59 | 47.519 | 47.5362 | 19658110.0 |
| 2024-01-03 17:00:00 | NVDA | Stock | 47.55 | 47.569 | 47.536 | 47.54 | 73380.0 |
| 2024-01-03 18:00:00 | NVDA | Stock | 47.569 | 47.672 | 47.569 | 47.6215 | 216540.0 |
| 2024-01-03 19:00:00 | NVDA | Stock | 47.62 | 47.68 | 47.575 | 47.669 | 201730.0 |
| 2024-01-03 04:00:00 | AMZN | Stock | 149.2 | 149.5 | 149.04 | 149.25 | 9140.0 |
| 2024-01-03 05:00:00 | AMZN | Stock | 149.15 | 149.91 | 149.1 | 149.83 | 18918.0 |
> showing 50 of 60,281 rows — these rows as CSV