PREVIEW / stock_1hour / 2024-10-15
file: by_date/stock_1hour/2024/2024-10-15.parquet size: 1.4 MB rows: 59,925 symbols: 757
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-10-15 04:00:00 | AAPL | Stock | 231.34 | 231.34 | 230.3 | 230.54 | 18750.0 |
| 2024-10-15 05:00:00 | AAPL | Stock | 230.55 | 230.81 | 230.45 | 230.81 | 10129.0 |
| 2024-10-15 06:00:00 | AAPL | Stock | 230.86 | 233.02 | 230.75 | 232.65 | 82141.0 |
| 2024-10-15 07:00:00 | AAPL | Stock | 232.54 | 233.99 | 232.3 | 233.99 | 120305.0 |
| 2024-10-15 08:00:00 | AAPL | Stock | 232.68 | 234.48 | 230.722 | 234.3185 | 248643.0 |
| 2024-10-15 09:00:00 | AAPL | Stock | 234.21 | 237.13 | 232.37 | 236.635 | 10858257.0 |
| 2024-10-15 10:00:00 | AAPL | Stock | 236.635 | 237.49 | 235.14 | 235.38 | 8198231.0 |
| 2024-10-15 11:00:00 | AAPL | Stock | 235.37 | 236.29 | 234.6701 | 235.37 | 3803006.0 |
| 2024-10-15 12:00:00 | AAPL | Stock | 235.38 | 235.82 | 234.31 | 234.48 | 2889333.0 |
| 2024-10-15 13:00:00 | AAPL | Stock | 234.4699 | 234.66 | 233.73 | 233.76 | 2196650.0 |
| 2024-10-15 14:00:00 | AAPL | Stock | 233.77 | 234.17 | 233.5 | 233.78 | 1890105.0 |
| 2024-10-15 15:00:00 | AAPL | Stock | 233.8 | 234.07 | 232.81 | 233.8 | 5988461.0 |
| 2024-10-15 16:00:00 | AAPL | Stock | 233.83 | 234.07 | 233.6 | 233.8436 | 7009159.0 |
| 2024-10-15 17:00:00 | AAPL | Stock | 233.85 | 233.89 | 233.5 | 233.6 | 15491.0 |
| 2024-10-15 18:00:00 | AAPL | Stock | 233.56 | 234.0 | 233.5036 | 233.83 | 16696.0 |
| 2024-10-15 19:00:00 | AAPL | Stock | 233.99 | 234.14 | 233.95 | 234.1 | 18237.0 |
| 2024-10-15 04:00:00 | MSFT | Stock | 420.34 | 420.34 | 419.1 | 419.62 | 7601.0 |
| 2024-10-15 05:00:00 | MSFT | Stock | 419.38 | 419.8 | 419.38 | 419.72 | 2455.0 |
| 2024-10-15 06:00:00 | MSFT | Stock | 419.8 | 420.67 | 419.8 | 420.3 | 3608.0 |
| 2024-10-15 07:00:00 | MSFT | Stock | 420.26 | 420.39 | 419.8 | 420.0 | 9041.0 |
| 2024-10-15 08:00:00 | MSFT | Stock | 420.3 | 420.9 | 419.41 | 420.9 | 36188.0 |
| 2024-10-15 09:00:00 | MSFT | Stock | 420.79 | 422.48 | 419.84 | 420.57 | 1142934.0 |
| 2024-10-15 10:00:00 | MSFT | Stock | 420.54 | 420.81 | 415.26 | 416.63 | 1665529.0 |
| 2024-10-15 11:00:00 | MSFT | Stock | 416.6 | 418.15 | 415.64 | 415.88 | 790689.0 |
| 2024-10-15 12:00:00 | MSFT | Stock | 415.89 | 417.62 | 415.89 | 417.555 | 647079.0 |
| 2024-10-15 13:00:00 | MSFT | Stock | 417.54 | 417.96 | 416.635 | 417.0866 | 505970.0 |
| 2024-10-15 14:00:00 | MSFT | Stock | 417.07 | 417.69 | 416.86 | 417.28 | 401695.0 |
| 2024-10-15 15:00:00 | MSFT | Stock | 417.32 | 418.92 | 416.35 | 418.78 | 1773987.0 |
| 2024-10-15 16:00:00 | MSFT | Stock | 418.77 | 419.42 | 418.74 | 419.24 | 2948645.0 |
| 2024-10-15 17:00:00 | MSFT | Stock | 419.06 | 419.14 | 418.8 | 418.82 | 4259.0 |
| 2024-10-15 18:00:00 | MSFT | Stock | 418.82 | 418.9697 | 418.6 | 418.89 | 4043.0 |
| 2024-10-15 19:00:00 | MSFT | Stock | 419.0 | 419.25 | 418.815 | 419.1109 | 5160.0 |
| 2024-10-15 04:00:00 | NVDA | Stock | 137.6 | 138.28 | 135.5 | 136.3 | 1024260.0 |
| 2024-10-15 05:00:00 | NVDA | Stock | 136.37 | 136.89 | 136.18 | 136.2 | 433393.0 |
| 2024-10-15 06:00:00 | NVDA | Stock | 136.21 | 136.5 | 135.91 | 136.42 | 392802.0 |
| 2024-10-15 07:00:00 | NVDA | Stock | 136.42 | 137.47 | 136.32 | 136.97 | 1315898.0 |
| 2024-10-15 08:00:00 | NVDA | Stock | 136.62 | 138.13 | 135.8148 | 136.95 | 2344109.0 |
| 2024-10-15 09:00:00 | NVDA | Stock | 136.97 | 138.57 | 135.36 | 135.51 | 37978329.0 |
| 2024-10-15 10:00:00 | NVDA | Stock | 135.51 | 136.18 | 128.74 | 132.06 | 102483323.0 |
| 2024-10-15 11:00:00 | NVDA | Stock | 132.07 | 132.818 | 130.53 | 130.5799 | 46658033.0 |
| 2024-10-15 12:00:00 | NVDA | Stock | 130.58 | 131.7 | 130.01 | 131.4102 | 29988797.0 |
| 2024-10-15 13:00:00 | NVDA | Stock | 131.4001 | 131.68 | 130.83 | 131.36 | 21251561.0 |
| 2024-10-15 14:00:00 | NVDA | Stock | 131.35 | 132.25 | 131.26 | 131.424 | 24136841.0 |
| 2024-10-15 15:00:00 | NVDA | Stock | 131.43 | 131.98 | 130.645 | 131.61 | 38367611.0 |
| 2024-10-15 16:00:00 | NVDA | Stock | 131.77 | 132.0 | 130.89 | 131.05 | 22342465.0 |
| 2024-10-15 17:00:00 | NVDA | Stock | 131.05 | 131.05 | 130.6 | 130.95 | 657665.0 |
| 2024-10-15 18:00:00 | NVDA | Stock | 130.94 | 132.9511 | 130.7 | 131.29 | 603243.0 |
| 2024-10-15 19:00:00 | NVDA | Stock | 131.3 | 131.48 | 131.2 | 131.24 | 557718.0 |
| 2024-10-15 04:00:00 | AMZN | Stock | 188.0 | 188.0 | 187.34 | 187.57 | 8491.0 |
| 2024-10-15 05:00:00 | AMZN | Stock | 187.61 | 187.63 | 187.43 | 187.44 | 5470.0 |
> showing 50 of 59,925 rows — these rows as CSV