PREVIEW / stock_1hour / 2024-03-22
file: by_date/stock_1hour/2024/2024-03-22.parquet size: 1.3 MB rows: 59,222 symbols: 1,052
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-03-22 04:00:00 | AAPL | Stock | 171.68 | 171.74 | 171.15 | 171.63 | 19381.0 |
| 2024-03-22 05:00:00 | AAPL | Stock | 171.63 | 171.8 | 171.63 | 171.74 | 18344.0 |
| 2024-03-22 06:00:00 | AAPL | Stock | 171.82 | 171.84 | 171.4 | 171.45 | 13733.0 |
| 2024-03-22 07:00:00 | AAPL | Stock | 171.5 | 171.75 | 171.02 | 171.05 | 53406.0 |
| 2024-03-22 08:00:00 | AAPL | Stock | 171.66 | 172.11 | 170.96 | 172.05 | 379727.0 |
| 2024-03-22 09:00:00 | AAPL | Stock | 172.0498 | 172.55 | 170.06 | 171.03 | 10088368.0 |
| 2024-03-22 10:00:00 | AAPL | Stock | 171.04 | 172.56 | 170.87 | 171.89 | 9859645.0 |
| 2024-03-22 11:00:00 | AAPL | Stock | 171.885 | 172.88 | 171.81 | 172.59 | 5470069.0 |
| 2024-03-22 12:00:00 | AAPL | Stock | 172.5904 | 172.9 | 172.08 | 172.65 | 4256518.0 |
| 2024-03-22 13:00:00 | AAPL | Stock | 172.64 | 172.94 | 172.36 | 172.665 | 3656451.0 |
| 2024-03-22 14:00:00 | AAPL | Stock | 172.66 | 172.935 | 172.37 | 172.7499 | 4088535.0 |
| 2024-03-22 15:00:00 | AAPL | Stock | 172.7498 | 173.05 | 172.23 | 172.25 | 8047553.0 |
| 2024-03-22 16:00:00 | AAPL | Stock | 172.37 | 172.46 | 172.25 | 172.42 | 10062765.0 |
| 2024-03-22 17:00:00 | AAPL | Stock | 172.42 | 172.44 | 172.16 | 172.2054 | 61122.0 |
| 2024-03-22 18:00:00 | AAPL | Stock | 172.24 | 172.27 | 172.12 | 172.18 | 16517.0 |
| 2024-03-22 19:00:00 | AAPL | Stock | 172.12 | 172.3 | 172.08 | 172.29 | 23586.0 |
| 2024-03-22 04:00:00 | MSFT | Stock | 430.06 | 430.1 | 429.79 | 429.97 | 2032.0 |
| 2024-03-22 05:00:00 | MSFT | Stock | 430.34 | 430.43 | 430.34 | 430.43 | 944.0 |
| 2024-03-22 06:00:00 | MSFT | Stock | 430.8 | 431.61 | 430.8 | 430.8 | 4150.0 |
| 2024-03-22 07:00:00 | MSFT | Stock | 430.81 | 430.83 | 428.1 | 428.33 | 11791.0 |
| 2024-03-22 08:00:00 | MSFT | Stock | 430.73 | 430.7816 | 428.0 | 428.42 | 20206.0 |
| 2024-03-22 09:00:00 | MSFT | Stock | 428.52 | 429.76 | 427.18 | 427.95 | 897029.0 |
| 2024-03-22 10:00:00 | MSFT | Stock | 427.96 | 429.1 | 426.71 | 427.08 | 1204702.0 |
| 2024-03-22 11:00:00 | MSFT | Stock | 427.085 | 427.66 | 426.11 | 427.11 | 968280.0 |
| 2024-03-22 12:00:00 | MSFT | Stock | 427.14 | 428.36 | 426.07 | 428.3599 | 799605.0 |
| 2024-03-22 13:00:00 | MSFT | Stock | 428.34 | 429.22 | 428.25 | 429.2 | 659384.0 |
| 2024-03-22 14:00:00 | MSFT | Stock | 429.1971 | 429.86 | 428.96 | 429.1403 | 697117.0 |
| 2024-03-22 15:00:00 | MSFT | Stock | 429.13 | 429.7 | 428.07 | 428.68 | 1468321.0 |
| 2024-03-22 16:00:00 | MSFT | Stock | 428.46 | 429.18 | 428.02 | 428.56 | 5054862.0 |
| 2024-03-22 17:00:00 | MSFT | Stock | 428.5 | 428.5 | 428.2601 | 428.5 | 1147.0 |
| 2024-03-22 18:00:00 | MSFT | Stock | 428.5 | 429.69 | 428.15 | 428.17 | 6147.0 |
| 2024-03-22 19:00:00 | MSFT | Stock | 428.2 | 428.5 | 428.2 | 428.5 | 2177.0 |
| 2024-03-22 04:00:00 | NVDA | Stock | 91.6 | 92.1 | 91.44 | 92.05 | 210830.0 |
| 2024-03-22 05:00:00 | NVDA | Stock | 92.05 | 92.133 | 91.797 | 91.988 | 230450.0 |
| 2024-03-22 06:00:00 | NVDA | Stock | 91.974 | 91.988 | 91.52 | 91.625 | 154260.0 |
| 2024-03-22 07:00:00 | NVDA | Stock | 91.65 | 91.76 | 90.802 | 90.95 | 1041990.0 |
| 2024-03-22 08:00:00 | NVDA | Stock | 91.735 | 91.7694 | 90.8 | 91.19 | 2335180.0 |
| 2024-03-22 09:00:00 | NVDA | Stock | 91.2 | 92.203 | 90.834 | 92.004 | 45388250.0 |
| 2024-03-22 10:00:00 | NVDA | Stock | 92.019 | 93.13 | 92.004 | 92.805 | 74777790.0 |
| 2024-03-22 11:00:00 | NVDA | Stock | 92.805 | 94.194 | 92.75 | 94.146 | 70148740.0 |
| 2024-03-22 12:00:00 | NVDA | Stock | 94.143 | 94.698 | 93.918 | 94.3884 | 57454820.0 |
| 2024-03-22 13:00:00 | NVDA | Stock | 94.374 | 94.778 | 94.182 | 94.69 | 38788890.0 |
| 2024-03-22 14:00:00 | NVDA | Stock | 94.69 | 94.69 | 93.778 | 94.073 | 40013920.0 |
| 2024-03-22 15:00:00 | NVDA | Stock | 94.0738 | 94.485 | 93.443 | 94.245 | 62889380.0 |
| 2024-03-22 16:00:00 | NVDA | Stock | 94.289 | 94.44 | 93.932 | 94.0 | 15816340.0 |
| 2024-03-22 17:00:00 | NVDA | Stock | 94.01 | 94.2987 | 93.973 | 94.26 | 755680.0 |
| 2024-03-22 18:00:00 | NVDA | Stock | 94.264 | 94.289 | 94.13 | 94.211 | 304490.0 |
| 2024-03-22 19:00:00 | NVDA | Stock | 94.21 | 94.212 | 93.98 | 94.02 | 642850.0 |
| 2024-03-22 04:00:00 | AMZN | Stock | 178.2 | 178.84 | 178.2 | 178.84 | 4647.0 |
| 2024-03-22 05:00:00 | AMZN | Stock | 178.86 | 178.86 | 178.37 | 178.67 | 2776.0 |
> showing 50 of 59,222 rows — these rows as CSV