PREVIEW / stock_1hour / 2024-07-16
file: by_date/stock_1hour/2024/2024-07-16.parquet size: 1.4 MB rows: 60,000 symbols: 910
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-07-16 04:00:00 | AAPL | Stock | 236.0 | 236.0 | 234.43 | 235.01 | 20759.0 |
| 2024-07-16 05:00:00 | AAPL | Stock | 235.05 | 235.05 | 234.7 | 234.99 | 8520.0 |
| 2024-07-16 06:00:00 | AAPL | Stock | 235.0 | 235.29 | 235.0 | 235.15 | 5334.0 |
| 2024-07-16 07:00:00 | AAPL | Stock | 235.15 | 235.3 | 234.9 | 235.18 | 22782.0 |
| 2024-07-16 08:00:00 | AAPL | Stock | 235.08 | 236.65 | 234.5345 | 234.82 | 138964.0 |
| 2024-07-16 09:00:00 | AAPL | Stock | 234.85 | 236.27 | 233.97 | 234.4 | 5712262.0 |
| 2024-07-16 10:00:00 | AAPL | Stock | 234.37 | 234.75 | 233.01 | 234.1 | 5743228.0 |
| 2024-07-16 11:00:00 | AAPL | Stock | 234.092 | 234.91 | 233.79 | 233.91 | 2782870.0 |
| 2024-07-16 12:00:00 | AAPL | Stock | 233.92 | 234.25 | 232.33 | 233.59 | 3144287.0 |
| 2024-07-16 13:00:00 | AAPL | Stock | 233.56 | 234.2 | 233.285 | 234.13 | 2408669.0 |
| 2024-07-16 14:00:00 | AAPL | Stock | 234.1136 | 234.865 | 233.71 | 234.79 | 2511411.0 |
| 2024-07-16 15:00:00 | AAPL | Stock | 234.795 | 234.98 | 234.285 | 234.81 | 3329785.0 |
| 2024-07-16 16:00:00 | AAPL | Stock | 234.8 | 234.9 | 234.43 | 234.55 | 4398481.0 |
| 2024-07-16 17:00:00 | AAPL | Stock | 234.56 | 234.64 | 234.44 | 234.64 | 16460.0 |
| 2024-07-16 18:00:00 | AAPL | Stock | 234.62 | 234.75 | 234.561 | 234.65 | 16161.0 |
| 2024-07-16 19:00:00 | AAPL | Stock | 234.6512 | 234.72 | 234.2413 | 234.3195 | 27292.0 |
| 2024-07-16 04:00:00 | MSFT | Stock | 454.78 | 454.78 | 452.0 | 452.4 | 3203.0 |
| 2024-07-16 05:00:00 | MSFT | Stock | 452.5 | 453.17 | 452.5 | 453.12 | 1045.0 |
| 2024-07-16 06:00:00 | MSFT | Stock | 452.9 | 453.45 | 452.9 | 453.13 | 716.0 |
| 2024-07-16 07:00:00 | MSFT | Stock | 453.38 | 454.0 | 453.15 | 454.0 | 1819.0 |
| 2024-07-16 08:00:00 | MSFT | Stock | 453.25 | 454.8 | 453.12 | 454.15 | 18109.0 |
| 2024-07-16 09:00:00 | MSFT | Stock | 454.0 | 454.95 | 450.93 | 451.1635 | 1262480.0 |
| 2024-07-16 10:00:00 | MSFT | Stock | 451.17 | 451.66 | 447.25 | 448.3301 | 1796283.0 |
| 2024-07-16 11:00:00 | MSFT | Stock | 448.33 | 450.029 | 447.77 | 448.53 | 1028583.0 |
| 2024-07-16 12:00:00 | MSFT | Stock | 448.56 | 448.9814 | 447.11 | 448.7 | 814824.0 |
| 2024-07-16 13:00:00 | MSFT | Stock | 448.7 | 448.7 | 446.66 | 447.7408 | 1004322.0 |
| 2024-07-16 14:00:00 | MSFT | Stock | 447.75 | 449.49 | 447.06 | 449.45 | 874732.0 |
| 2024-07-16 15:00:00 | MSFT | Stock | 449.43 | 450.18 | 449.1 | 449.49 | 1268429.0 |
| 2024-07-16 16:00:00 | MSFT | Stock | 449.52 | 449.72 | 448.81 | 449.0 | 2943990.0 |
| 2024-07-16 17:00:00 | MSFT | Stock | 449.0 | 449.3026 | 449.0 | 449.1 | 3394.0 |
| 2024-07-16 18:00:00 | MSFT | Stock | 449.15 | 449.3958 | 449.0 | 449.02 | 4136.0 |
| 2024-07-16 19:00:00 | MSFT | Stock | 448.95 | 449.3254 | 448.55 | 448.76 | 2047.0 |
| 2024-07-16 04:00:00 | NVDA | Stock | 128.15 | 128.8 | 127.62 | 128.01 | 218680.0 |
| 2024-07-16 05:00:00 | NVDA | Stock | 128.05 | 128.41 | 127.69 | 128.06 | 132061.0 |
| 2024-07-16 06:00:00 | NVDA | Stock | 128.07 | 128.4 | 127.99 | 128.35 | 100528.0 |
| 2024-07-16 07:00:00 | NVDA | Stock | 128.35 | 128.85 | 128.25 | 128.49 | 366381.0 |
| 2024-07-16 08:00:00 | NVDA | Stock | 128.48 | 129.03 | 127.8907 | 128.78 | 1142453.0 |
| 2024-07-16 09:00:00 | NVDA | Stock | 128.76 | 129.04 | 125.7504 | 126.115 | 28914397.0 |
| 2024-07-16 10:00:00 | NVDA | Stock | 126.12 | 126.65 | 124.58 | 125.865 | 41564409.0 |
| 2024-07-16 11:00:00 | NVDA | Stock | 125.87 | 126.95 | 125.74 | 126.66 | 19363724.0 |
| 2024-07-16 12:00:00 | NVDA | Stock | 126.655 | 126.87 | 125.18 | 125.9658 | 20880287.0 |
| 2024-07-16 13:00:00 | NVDA | Stock | 125.96 | 126.34 | 125.53 | 125.88 | 13292746.0 |
| 2024-07-16 14:00:00 | NVDA | Stock | 125.885 | 126.57 | 125.285 | 126.37 | 17344000.0 |
| 2024-07-16 15:00:00 | NVDA | Stock | 126.37 | 126.65 | 125.52 | 126.315 | 22054440.0 |
| 2024-07-16 16:00:00 | NVDA | Stock | 126.36 | 126.65 | 126.0 | 126.41 | 14559107.0 |
| 2024-07-16 17:00:00 | NVDA | Stock | 126.41 | 126.41 | 125.83 | 126.0 | 533927.0 |
| 2024-07-16 18:00:00 | NVDA | Stock | 126.0 | 126.05 | 125.8005 | 125.9506 | 338754.0 |
| 2024-07-16 19:00:00 | NVDA | Stock | 125.95 | 126.11 | 125.85 | 125.9 | 325565.0 |
| 2024-07-16 04:00:00 | AMZN | Stock | 193.36 | 193.36 | 192.75 | 192.97 | 5761.0 |
| 2024-07-16 05:00:00 | AMZN | Stock | 193.23 | 193.5 | 193.01 | 193.31 | 12146.0 |
> showing 50 of 60,000 rows — these rows as CSV