PREVIEW / stock_1hour / 2024-10-23
file: by_date/stock_1hour/2024/2024-10-23.parquet size: 1.4 MB rows: 59,809 symbols: 742
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-23 04:00:00 | AAPL | Stock | 235.39 | 235.7 | 235.0 | 235.0 | 2765.0 |
| 2024-10-23 05:00:00 | AAPL | Stock | 234.94 | 234.95 | 234.75 | 234.77 | 5026.0 |
| 2024-10-23 06:00:00 | AAPL | Stock | 234.72 | 234.87 | 234.31 | 234.4 | 9748.0 |
| 2024-10-23 07:00:00 | AAPL | Stock | 234.53 | 234.85 | 234.39 | 234.45 | 37397.0 |
| 2024-10-23 08:00:00 | AAPL | Stock | 234.74 | 235.48 | 233.8 | 233.9979 | 94212.0 |
| 2024-10-23 09:00:00 | AAPL | Stock | 233.93 | 235.144 | 233.61 | 234.915 | 3294087.0 |
| 2024-10-23 10:00:00 | AAPL | Stock | 234.915 | 235.1199 | 234.11 | 234.2925 | 2658368.0 |
| 2024-10-23 11:00:00 | AAPL | Stock | 234.29 | 234.5621 | 230.58 | 231.56 | 6126971.0 |
| 2024-10-23 12:00:00 | AAPL | Stock | 231.58 | 231.9199 | 228.93 | 229.64 | 8276252.0 |
| 2024-10-23 13:00:00 | AAPL | Stock | 229.63 | 230.2 | 228.28 | 228.37 | 3753419.0 |
| 2024-10-23 14:00:00 | AAPL | Stock | 228.36 | 229.66 | 227.76 | 229.26 | 3454247.0 |
| 2024-10-23 15:00:00 | AAPL | Stock | 229.24 | 230.86 | 229.1802 | 230.75 | 4409500.0 |
| 2024-10-23 16:00:00 | AAPL | Stock | 230.76 | 230.77 | 230.02 | 230.35 | 7727564.0 |
| 2024-10-23 17:00:00 | AAPL | Stock | 230.51 | 230.76 | 230.29 | 230.49 | 208481.0 |
| 2024-10-23 18:00:00 | AAPL | Stock | 230.49 | 230.49 | 230.12 | 230.25 | 24929.0 |
| 2024-10-23 19:00:00 | AAPL | Stock | 230.3 | 230.64 | 230.1121 | 230.4178 | 28676.0 |
| 2024-10-23 04:00:00 | MSFT | Stock | 426.44 | 428.35 | 426.44 | 427.34 | 4702.0 |
| 2024-10-23 05:00:00 | MSFT | Stock | 428.26 | 428.26 | 427.32 | 427.75 | 3980.0 |
| 2024-10-23 06:00:00 | MSFT | Stock | 427.5 | 428.5 | 426.45 | 428.08 | 10618.0 |
| 2024-10-23 07:00:00 | MSFT | Stock | 428.22 | 429.78 | 428.0 | 429.5 | 18475.0 |
| 2024-10-23 08:00:00 | MSFT | Stock | 428.37 | 431.41 | 426.38 | 430.918 | 108947.0 |
| 2024-10-23 09:00:00 | MSFT | Stock | 430.7 | 431.08 | 426.7 | 429.26 | 1928530.0 |
| 2024-10-23 10:00:00 | MSFT | Stock | 429.255 | 430.59 | 427.8 | 428.77 | 1955653.0 |
| 2024-10-23 11:00:00 | MSFT | Stock | 428.775 | 429.64 | 427.5789 | 429.405 | 1058424.0 |
| 2024-10-23 12:00:00 | MSFT | Stock | 429.3249 | 429.3249 | 426.54 | 426.91 | 835369.0 |
| 2024-10-23 13:00:00 | MSFT | Stock | 426.83 | 426.83 | 423.62 | 423.73 | 883840.0 |
| 2024-10-23 14:00:00 | MSFT | Stock | 423.72 | 424.76 | 422.53 | 424.51 | 894444.0 |
| 2024-10-23 15:00:00 | MSFT | Stock | 424.4415 | 425.57 | 423.77 | 424.62 | 1337107.0 |
| 2024-10-23 16:00:00 | MSFT | Stock | 424.6 | 424.97 | 423.98 | 424.21 | 2745270.0 |
| 2024-10-23 17:00:00 | MSFT | Stock | 424.2 | 424.5 | 424.01 | 424.5 | 11885.0 |
| 2024-10-23 18:00:00 | MSFT | Stock | 424.32 | 424.6 | 423.9 | 424.16 | 7373.0 |
| 2024-10-23 19:00:00 | MSFT | Stock | 424.1 | 424.5 | 423.45 | 424.24 | 5057.0 |
| 2024-10-23 04:00:00 | NVDA | Stock | 143.11 | 143.5 | 143.02 | 143.17 | 204549.0 |
| 2024-10-23 05:00:00 | NVDA | Stock | 143.16 | 143.28 | 142.4 | 142.95 | 307283.0 |
| 2024-10-23 06:00:00 | NVDA | Stock | 142.91 | 143.01 | 142.0 | 142.3 | 367521.0 |
| 2024-10-23 07:00:00 | NVDA | Stock | 142.3 | 142.78 | 142.26 | 142.58 | 665491.0 |
| 2024-10-23 08:00:00 | NVDA | Stock | 142.39 | 143.5 | 142.21 | 142.55 | 1899757.0 |
| 2024-10-23 09:00:00 | NVDA | Stock | 142.55 | 142.56 | 140.3908 | 140.8318 | 37569065.0 |
| 2024-10-23 10:00:00 | NVDA | Stock | 140.84 | 141.41 | 138.26 | 140.745 | 55680169.0 |
| 2024-10-23 11:00:00 | NVDA | Stock | 140.7501 | 141.24 | 139.6201 | 140.6601 | 27883132.0 |
| 2024-10-23 12:00:00 | NVDA | Stock | 140.66 | 140.7 | 139.0488 | 139.1808 | 22177166.0 |
| 2024-10-23 13:00:00 | NVDA | Stock | 139.1873 | 139.2 | 137.46 | 137.86 | 32103437.0 |
| 2024-10-23 14:00:00 | NVDA | Stock | 137.86 | 139.24 | 137.63 | 139.0898 | 25654588.0 |
| 2024-10-23 15:00:00 | NVDA | Stock | 139.08 | 139.86 | 138.37 | 139.57 | 27450064.0 |
| 2024-10-23 16:00:00 | NVDA | Stock | 139.55 | 140.55 | 139.33 | 140.032 | 18569382.0 |
| 2024-10-23 17:00:00 | NVDA | Stock | 140.02 | 140.4376 | 139.56 | 140.4 | 791943.0 |
| 2024-10-23 18:00:00 | NVDA | Stock | 140.4199 | 140.4199 | 140.02 | 140.26 | 381236.0 |
| 2024-10-23 19:00:00 | NVDA | Stock | 140.27 | 140.34 | 140.2 | 140.21 | 431165.0 |
| 2024-10-23 04:00:00 | AMZN | Stock | 189.7 | 189.94 | 189.3 | 189.3 | 6304.0 |
| 2024-10-23 05:00:00 | AMZN | Stock | 189.33 | 189.6 | 189.32 | 189.58 | 5528.0 |
> showing 50 of 59,809 rows — these rows as CSV