PREVIEW / stock_1hour / 2023-10-11
file: by_date/stock_1hour/2023/2023-10-11.parquet size: 1.3 MB rows: 58,643 symbols: 1,380
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 |
|---|---|---|---|---|---|---|---|
| 2023-10-11 04:00:00 | AAPL | Stock | 178.62 | 178.62 | 178.36 | 178.4 | 9395.0 |
| 2023-10-11 05:00:00 | AAPL | Stock | 178.4 | 178.61 | 178.35 | 178.6 | 2248.0 |
| 2023-10-11 06:00:00 | AAPL | Stock | 178.6 | 178.64 | 178.47 | 178.58 | 4942.0 |
| 2023-10-11 07:00:00 | AAPL | Stock | 178.56 | 178.9 | 178.4 | 178.44 | 30001.0 |
| 2023-10-11 08:00:00 | AAPL | Stock | 178.58 | 178.92 | 177.63 | 178.44 | 222695.0 |
| 2023-10-11 09:00:00 | AAPL | Stock | 178.43 | 178.9576 | 177.6 | 177.935 | 5302235.0 |
| 2023-10-11 10:00:00 | AAPL | Stock | 177.93 | 179.28 | 177.67 | 179.1 | 6055787.0 |
| 2023-10-11 11:00:00 | AAPL | Stock | 179.1 | 179.32 | 178.445 | 178.7083 | 4505699.0 |
| 2023-10-11 12:00:00 | AAPL | Stock | 178.71 | 178.74 | 178.27 | 178.625 | 3098098.0 |
| 2023-10-11 13:00:00 | AAPL | Stock | 178.64 | 178.742 | 178.33 | 178.63 | 2387322.0 |
| 2023-10-11 14:00:00 | AAPL | Stock | 178.62 | 179.38 | 178.59 | 179.085 | 4021161.0 |
| 2023-10-11 15:00:00 | AAPL | Stock | 179.0773 | 179.85 | 179.04 | 179.75 | 7032180.0 |
| 2023-10-11 16:00:00 | AAPL | Stock | 179.74 | 180.3883 | 179.74 | 180.24 | 6426356.0 |
| 2023-10-11 17:00:00 | AAPL | Stock | 180.23 | 180.33 | 180.19 | 180.22 | 57747.0 |
| 2023-10-11 18:00:00 | AAPL | Stock | 180.21 | 180.33 | 180.21 | 180.29 | 18348.0 |
| 2023-10-11 19:00:00 | AAPL | Stock | 180.29 | 180.38 | 180.2 | 180.36 | 45038.0 |
| 2023-10-11 04:00:00 | MSFT | Stock | 329.33 | 329.33 | 328.66 | 328.66 | 839.0 |
| 2023-10-11 05:00:00 | MSFT | Stock | 329.53 | 329.53 | 329.4 | 329.5 | 800.0 |
| 2023-10-11 06:00:00 | MSFT | Stock | 329.41 | 329.8 | 329.41 | 329.6 | 1592.0 |
| 2023-10-11 07:00:00 | MSFT | Stock | 329.85 | 330.15 | 329.74 | 329.75 | 2543.0 |
| 2023-10-11 08:00:00 | MSFT | Stock | 329.77 | 330.5 | 329.28 | 330.44 | 37284.0 |
| 2023-10-11 09:00:00 | MSFT | Stock | 330.1705 | 332.59 | 329.82 | 331.485 | 2027077.0 |
| 2023-10-11 10:00:00 | MSFT | Stock | 331.495 | 331.69 | 329.8 | 331.455 | 2078059.0 |
| 2023-10-11 11:00:00 | MSFT | Stock | 331.455 | 332.13 | 330.42 | 330.735 | 1536612.0 |
| 2023-10-11 12:00:00 | MSFT | Stock | 330.7957 | 330.7957 | 329.65 | 330.44 | 886867.0 |
| 2023-10-11 13:00:00 | MSFT | Stock | 330.43 | 330.565 | 329.14 | 330.1 | 895242.0 |
| 2023-10-11 14:00:00 | MSFT | Stock | 330.1 | 332.0 | 330.07 | 331.39 | 1032440.0 |
| 2023-10-11 15:00:00 | MSFT | Stock | 331.4137 | 332.82 | 330.985 | 332.45 | 2544563.0 |
| 2023-10-11 16:00:00 | MSFT | Stock | 332.45 | 333.25 | 328.75 | 331.3 | 3934733.0 |
| 2023-10-11 17:00:00 | MSFT | Stock | 331.21 | 331.21 | 330.01 | 330.53 | 31422.0 |
| 2023-10-11 18:00:00 | MSFT | Stock | 330.5 | 330.8 | 330.29 | 330.55 | 10190.0 |
| 2023-10-11 19:00:00 | MSFT | Stock | 330.5 | 331.1 | 330.5 | 331.0 | 11800.0 |
| 2023-10-11 04:00:00 | NVDA | Stock | 46.018 | 46.097 | 46.01 | 46.05 | 92190.0 |
| 2023-10-11 05:00:00 | NVDA | Stock | 46.05 | 46.08 | 46.026 | 46.08 | 31600.0 |
| 2023-10-11 06:00:00 | NVDA | Stock | 46.085 | 46.103 | 46.071 | 46.08 | 51590.0 |
| 2023-10-11 07:00:00 | NVDA | Stock | 46.08 | 46.298 | 46.05 | 46.18 | 863100.0 |
| 2023-10-11 08:00:00 | NVDA | Stock | 46.093 | 46.299 | 45.997 | 46.22 | 2692220.0 |
| 2023-10-11 09:00:00 | NVDA | Stock | 46.217 | 46.555 | 46.11 | 46.2464 | 46261340.0 |
| 2023-10-11 10:00:00 | NVDA | Stock | 46.25 | 46.651 | 46.15 | 46.6239 | 58256230.0 |
| 2023-10-11 11:00:00 | NVDA | Stock | 46.626 | 46.72 | 46.22 | 46.411 | 41650640.0 |
| 2023-10-11 12:00:00 | NVDA | Stock | 46.411 | 46.499 | 46.147 | 46.311 | 29691130.0 |
| 2023-10-11 13:00:00 | NVDA | Stock | 46.307 | 46.35 | 46.05 | 46.237 | 22279780.0 |
| 2023-10-11 14:00:00 | NVDA | Stock | 46.237 | 46.53 | 46.236 | 46.494 | 28728040.0 |
| 2023-10-11 15:00:00 | NVDA | Stock | 46.492 | 46.859 | 46.402 | 46.809 | 50931150.0 |
| 2023-10-11 16:00:00 | NVDA | Stock | 46.806 | 46.985 | 46.5709 | 46.911 | 13509440.0 |
| 2023-10-11 17:00:00 | NVDA | Stock | 46.918 | 46.9219 | 46.842 | 46.897 | 496220.0 |
| 2023-10-11 18:00:00 | NVDA | Stock | 46.8802 | 46.9 | 46.855 | 46.885 | 358000.0 |
| 2023-10-11 19:00:00 | NVDA | Stock | 46.889 | 46.969 | 46.875 | 46.955 | 686700.0 |
| 2023-10-11 04:00:00 | AMZN | Stock | 129.9 | 129.9 | 129.61 | 129.81 | 10987.0 |
| 2023-10-11 05:00:00 | AMZN | Stock | 129.81 | 129.99 | 129.79 | 129.99 | 4748.0 |
> showing 50 of 58,643 rows — these rows as CSV