PREVIEW / stock_1hour / 2024-04-04
file: by_date/stock_1hour/2024/2024-04-04.parquet size: 1.3 MB rows: 59,835 symbols: 1,042
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-04-04 04:00:00 | AAPL | Stock | 169.99 | 170.18 | 169.9 | 170.06 | 6481.0 |
| 2024-04-04 05:00:00 | AAPL | Stock | 170.06 | 170.2 | 170.06 | 170.19 | 3092.0 |
| 2024-04-04 06:00:00 | AAPL | Stock | 170.05 | 170.14 | 170.0 | 170.14 | 3477.0 |
| 2024-04-04 07:00:00 | AAPL | Stock | 170.2 | 170.31 | 170.1 | 170.2 | 17736.0 |
| 2024-04-04 08:00:00 | AAPL | Stock | 170.19 | 170.79 | 169.83 | 170.75 | 94775.0 |
| 2024-04-04 09:00:00 | AAPL | Stock | 170.75 | 171.01 | 170.04 | 170.9799 | 4775541.0 |
| 2024-04-04 10:00:00 | AAPL | Stock | 170.9792 | 171.19 | 170.71 | 171.0182 | 4365769.0 |
| 2024-04-04 11:00:00 | AAPL | Stock | 171.0175 | 171.765 | 170.85 | 171.73 | 3452791.0 |
| 2024-04-04 12:00:00 | AAPL | Stock | 171.73 | 171.92 | 171.335 | 171.425 | 3203157.0 |
| 2024-04-04 13:00:00 | AAPL | Stock | 171.42 | 171.61 | 170.8 | 170.82 | 2780145.0 |
| 2024-04-04 14:00:00 | AAPL | Stock | 170.82 | 170.8251 | 169.2 | 169.8 | 7010098.0 |
| 2024-04-04 15:00:00 | AAPL | Stock | 169.79 | 169.93 | 168.83 | 168.89 | 9992816.0 |
| 2024-04-04 16:00:00 | AAPL | Stock | 168.86 | 169.12 | 168.77 | 169.05 | 8222971.0 |
| 2024-04-04 17:00:00 | AAPL | Stock | 169.02 | 169.22 | 168.82 | 169.1204 | 36516.0 |
| 2024-04-04 18:00:00 | AAPL | Stock | 169.15 | 169.2886 | 169.02 | 169.1 | 54305.0 |
| 2024-04-04 19:00:00 | AAPL | Stock | 169.07 | 169.55 | 169.02 | 169.22 | 49922.0 |
| 2024-04-04 04:00:00 | MSFT | Stock | 422.56 | 422.92 | 422.42 | 422.92 | 548.0 |
| 2024-04-04 05:00:00 | MSFT | Stock | 422.79 | 423.14 | 422.79 | 423.14 | 5046.0 |
| 2024-04-04 06:00:00 | MSFT | Stock | 422.86 | 422.86 | 422.8 | 422.85 | 404.0 |
| 2024-04-04 07:00:00 | MSFT | Stock | 422.85 | 422.98 | 421.86 | 422.28 | 3388.0 |
| 2024-04-04 08:00:00 | MSFT | Stock | 422.85 | 424.26 | 421.8557 | 423.8 | 37794.0 |
| 2024-04-04 09:00:00 | MSFT | Stock | 423.88 | 427.58 | 423.32 | 426.49 | 1564374.0 |
| 2024-04-04 10:00:00 | MSFT | Stock | 426.4639 | 426.94 | 425.13 | 425.81 | 859203.0 |
| 2024-04-04 11:00:00 | MSFT | Stock | 425.8479 | 427.08 | 425.8479 | 427.04 | 758633.0 |
| 2024-04-04 12:00:00 | MSFT | Stock | 427.06 | 428.67 | 427.015 | 428.14 | 840793.0 |
| 2024-04-04 13:00:00 | MSFT | Stock | 428.1 | 428.105 | 426.54 | 426.76 | 535099.0 |
| 2024-04-04 14:00:00 | MSFT | Stock | 426.6801 | 426.75 | 421.08 | 421.44 | 1314067.0 |
| 2024-04-04 15:00:00 | MSFT | Stock | 421.39 | 421.8 | 417.57 | 417.9 | 2662900.0 |
| 2024-04-04 16:00:00 | MSFT | Stock | 417.863 | 419.2 | 417.68 | 418.4 | 4598583.0 |
| 2024-04-04 17:00:00 | MSFT | Stock | 418.45 | 419.0 | 418.33 | 419.0 | 7176.0 |
| 2024-04-04 18:00:00 | MSFT | Stock | 418.99 | 419.4498 | 418.45 | 418.8 | 17270.0 |
| 2024-04-04 19:00:00 | MSFT | Stock | 418.8 | 419.1 | 418.61 | 418.9 | 11298.0 |
| 2024-04-04 04:00:00 | NVDA | Stock | 89.573 | 89.6 | 89.5 | 89.53 | 46190.0 |
| 2024-04-04 05:00:00 | NVDA | Stock | 89.54 | 89.878 | 89.536 | 89.8 | 56200.0 |
| 2024-04-04 06:00:00 | NVDA | Stock | 89.788 | 89.859 | 89.739 | 89.825 | 47540.0 |
| 2024-04-04 07:00:00 | NVDA | Stock | 89.8 | 90.15 | 89.7 | 90.002 | 787880.0 |
| 2024-04-04 08:00:00 | NVDA | Stock | 89.75 | 90.5582 | 89.41 | 90.462 | 2569730.0 |
| 2024-04-04 09:00:00 | NVDA | Stock | 90.498 | 90.634 | 89.321 | 89.717 | 47863810.0 |
| 2024-04-04 10:00:00 | NVDA | Stock | 89.7128 | 89.9535 | 89.428 | 89.774 | 38623960.0 |
| 2024-04-04 11:00:00 | NVDA | Stock | 89.763 | 89.799 | 89.213 | 89.283 | 28170080.0 |
| 2024-04-04 12:00:00 | NVDA | Stock | 89.2853 | 89.729 | 89.241 | 89.643 | 19598310.0 |
| 2024-04-04 13:00:00 | NVDA | Stock | 89.65 | 89.69 | 89.197 | 89.275 | 15372580.0 |
| 2024-04-04 14:00:00 | NVDA | Stock | 89.26 | 89.269 | 87.305 | 87.475 | 59010320.0 |
| 2024-04-04 15:00:00 | NVDA | Stock | 87.466 | 87.466 | 85.88 | 85.902 | 77879150.0 |
| 2024-04-04 16:00:00 | NVDA | Stock | 85.903 | 86.073 | 85.6 | 85.825 | 23885480.0 |
| 2024-04-04 17:00:00 | NVDA | Stock | 85.837 | 86.3503 | 85.837 | 86.256 | 1372360.0 |
| 2024-04-04 18:00:00 | NVDA | Stock | 86.29 | 86.368 | 86.1302 | 86.27 | 661980.0 |
| 2024-04-04 19:00:00 | NVDA | Stock | 86.217 | 86.3 | 86.2 | 86.21 | 488490.0 |
| 2024-04-04 04:00:00 | AMZN | Stock | 183.64 | 183.78 | 183.22 | 183.51 | 13119.0 |
| 2024-04-04 05:00:00 | AMZN | Stock | 183.55 | 183.7 | 183.31 | 183.35 | 4396.0 |
> showing 50 of 59,835 rows — these rows as CSV