PREVIEW / stock_1hour / 2024-09-30
file: by_date/stock_1hour/2024/2024-09-30.parquet size: 1.4 MB rows: 61,531 symbols: 788
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-09-30 04:00:00 | AAPL | Stock | 227.33 | 229.37 | 227.33 | 229.0 | 55912.0 |
| 2024-09-30 05:00:00 | AAPL | Stock | 229.0 | 230.22 | 229.0 | 230.2 | 48965.0 |
| 2024-09-30 06:00:00 | AAPL | Stock | 230.12 | 230.55 | 229.83 | 229.9 | 24962.0 |
| 2024-09-30 07:00:00 | AAPL | Stock | 229.85 | 229.92 | 229.0 | 229.42 | 113494.0 |
| 2024-09-30 08:00:00 | AAPL | Stock | 229.4 | 230.39 | 226.84 | 230.35 | 352808.0 |
| 2024-09-30 09:00:00 | AAPL | Stock | 230.35 | 232.35 | 229.21 | 230.925 | 5637829.0 |
| 2024-09-30 10:00:00 | AAPL | Stock | 230.925 | 231.76 | 230.31 | 231.61 | 3880400.0 |
| 2024-09-30 11:00:00 | AAPL | Stock | 231.6 | 232.43 | 231.38 | 232.25 | 3139997.0 |
| 2024-09-30 12:00:00 | AAPL | Stock | 232.25 | 232.5383 | 231.74 | 231.7878 | 2094276.0 |
| 2024-09-30 13:00:00 | AAPL | Stock | 231.78 | 232.0399 | 231.31 | 231.84 | 1851301.0 |
| 2024-09-30 14:00:00 | AAPL | Stock | 231.825 | 231.91 | 230.55 | 231.7516 | 2531594.0 |
| 2024-09-30 15:00:00 | AAPL | Stock | 231.735 | 233.0 | 231.04 | 233.0 | 8255233.0 |
| 2024-09-30 16:00:00 | AAPL | Stock | 233.0 | 233.25 | 232.7 | 232.88 | 13317954.0 |
| 2024-09-30 17:00:00 | AAPL | Stock | 232.88 | 233.0 | 232.8 | 232.88 | 119675.0 |
| 2024-09-30 18:00:00 | AAPL | Stock | 232.9 | 232.98 | 232.7755 | 232.782 | 32809.0 |
| 2024-09-30 19:00:00 | AAPL | Stock | 232.782 | 233.195 | 232.7701 | 233.15 | 32388.0 |
| 2024-09-30 04:00:00 | MSFT | Stock | 428.0 | 428.0 | 426.6 | 426.6 | 3295.0 |
| 2024-09-30 05:00:00 | MSFT | Stock | 426.96 | 427.32 | 426.85 | 427.32 | 2261.0 |
| 2024-09-30 06:00:00 | MSFT | Stock | 427.3 | 427.5 | 427.17 | 427.5 | 1572.0 |
| 2024-09-30 07:00:00 | MSFT | Stock | 427.38 | 427.5 | 426.64 | 426.64 | 4914.0 |
| 2024-09-30 08:00:00 | MSFT | Stock | 427.37 | 427.79 | 426.601 | 427.78 | 24492.0 |
| 2024-09-30 09:00:00 | MSFT | Stock | 427.72 | 429.5705 | 426.23 | 426.37 | 903904.0 |
| 2024-09-30 10:00:00 | MSFT | Stock | 426.41 | 427.19 | 425.57 | 426.262 | 827971.0 |
| 2024-09-30 11:00:00 | MSFT | Stock | 426.23 | 428.21 | 426.16 | 428.07 | 656231.0 |
| 2024-09-30 12:00:00 | MSFT | Stock | 428.05 | 428.91 | 428.025 | 428.24 | 356866.0 |
| 2024-09-30 13:00:00 | MSFT | Stock | 428.24 | 428.32 | 427.255 | 428.0904 | 398140.0 |
| 2024-09-30 14:00:00 | MSFT | Stock | 428.04 | 428.16 | 425.37 | 426.9349 | 495997.0 |
| 2024-09-30 15:00:00 | MSFT | Stock | 426.92 | 430.42 | 426.215 | 430.34 | 1973275.0 |
| 2024-09-30 16:00:00 | MSFT | Stock | 430.3 | 430.3 | 428.0525 | 428.1 | 4885778.0 |
| 2024-09-30 17:00:00 | MSFT | Stock | 428.27 | 428.6 | 428.1 | 428.303 | 3416.0 |
| 2024-09-30 18:00:00 | MSFT | Stock | 428.5 | 428.5 | 428.3 | 428.33 | 1369.0 |
| 2024-09-30 19:00:00 | MSFT | Stock | 428.33 | 428.99 | 428.3 | 428.99 | 6492.0 |
| 2024-09-30 04:00:00 | NVDA | Stock | 120.8 | 120.81 | 119.1 | 119.5 | 633930.0 |
| 2024-09-30 05:00:00 | NVDA | Stock | 119.48 | 119.5 | 118.63 | 119.17 | 503229.0 |
| 2024-09-30 06:00:00 | NVDA | Stock | 119.17 | 119.3 | 118.83 | 119.25 | 251745.0 |
| 2024-09-30 07:00:00 | NVDA | Stock | 119.25 | 119.38 | 117.72 | 118.08 | 1670108.0 |
| 2024-09-30 08:00:00 | NVDA | Stock | 118.09 | 121.0 | 117.72 | 118.23 | 3342175.0 |
| 2024-09-30 09:00:00 | NVDA | Stock | 118.25 | 121.27 | 118.06 | 120.18 | 33045349.0 |
| 2024-09-30 10:00:00 | NVDA | Stock | 120.185 | 120.295 | 119.18 | 119.9 | 31226632.0 |
| 2024-09-30 11:00:00 | NVDA | Stock | 119.89 | 121.1 | 119.755 | 120.6991 | 23855696.0 |
| 2024-09-30 12:00:00 | NVDA | Stock | 120.695 | 121.1 | 120.34 | 120.52 | 15954874.0 |
| 2024-09-30 13:00:00 | NVDA | Stock | 120.52 | 120.62 | 119.87 | 120.45 | 14818440.0 |
| 2024-09-30 14:00:00 | NVDA | Stock | 120.4606 | 120.69 | 119.18 | 120.1806 | 22370668.0 |
| 2024-09-30 15:00:00 | NVDA | Stock | 120.19 | 121.5 | 119.8101 | 121.49 | 27847653.0 |
| 2024-09-30 16:00:00 | NVDA | Stock | 121.5 | 121.66 | 120.3653 | 121.18 | 21307048.0 |
| 2024-09-30 17:00:00 | NVDA | Stock | 121.17 | 121.28 | 120.942 | 121.04 | 441002.0 |
| 2024-09-30 18:00:00 | NVDA | Stock | 121.06 | 121.13 | 120.95 | 121.04 | 197507.0 |
| 2024-09-30 19:00:00 | NVDA | Stock | 121.07 | 121.3 | 121.02 | 121.29 | 289341.0 |
| 2024-09-30 04:00:00 | AMZN | Stock | 187.75 | 188.0 | 187.16 | 187.54 | 16684.0 |
| 2024-09-30 05:00:00 | AMZN | Stock | 187.55 | 187.63 | 187.32 | 187.55 | 3656.0 |
> showing 50 of 61,531 rows — these rows as CSV