PREVIEW / stock_1hour / 2024-10-09
file: by_date/stock_1hour/2024/2024-10-09.parquet size: 1.3 MB rows: 58,566 symbols: 762
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-09 04:00:00 | AAPL | Stock | 225.12 | 225.12 | 224.45 | 224.72 | 3996.0 |
| 2024-10-09 05:00:00 | AAPL | Stock | 224.83 | 225.26 | 224.82 | 225.13 | 3594.0 |
| 2024-10-09 06:00:00 | AAPL | Stock | 224.99 | 225.17 | 224.93 | 225.0 | 4572.0 |
| 2024-10-09 07:00:00 | AAPL | Stock | 225.14 | 225.69 | 225.1 | 225.5 | 26459.0 |
| 2024-10-09 08:00:00 | AAPL | Stock | 225.3 | 225.73 | 224.7726 | 225.65 | 57999.0 |
| 2024-10-09 09:00:00 | AAPL | Stock | 225.59 | 226.485 | 224.83 | 226.15 | 2840255.0 |
| 2024-10-09 10:00:00 | AAPL | Stock | 226.15 | 227.8 | 225.82 | 227.65 | 4190665.0 |
| 2024-10-09 11:00:00 | AAPL | Stock | 227.66 | 228.63 | 227.64 | 228.4245 | 2908117.0 |
| 2024-10-09 12:00:00 | AAPL | Stock | 228.425 | 229.0399 | 228.082 | 228.65 | 2112424.0 |
| 2024-10-09 13:00:00 | AAPL | Stock | 228.64 | 229.0 | 228.02 | 228.5032 | 1407154.0 |
| 2024-10-09 14:00:00 | AAPL | Stock | 228.51 | 229.67 | 228.41 | 229.3 | 2451627.0 |
| 2024-10-09 15:00:00 | AAPL | Stock | 229.31 | 229.75 | 228.8 | 229.49 | 3623696.0 |
| 2024-10-09 16:00:00 | AAPL | Stock | 229.51 | 229.55 | 229.05 | 229.18 | 5289411.0 |
| 2024-10-09 17:00:00 | AAPL | Stock | 229.22 | 229.54 | 229.12 | 229.14 | 73802.0 |
| 2024-10-09 18:00:00 | AAPL | Stock | 229.19 | 229.23 | 229.12 | 229.1503 | 16064.0 |
| 2024-10-09 19:00:00 | AAPL | Stock | 229.14 | 229.4 | 229.135 | 229.3961 | 19205.0 |
| 2024-10-09 04:00:00 | MSFT | Stock | 414.74 | 415.5 | 414.74 | 415.4 | 1819.0 |
| 2024-10-09 05:00:00 | MSFT | Stock | 415.48 | 415.59 | 415.42 | 415.5 | 3586.0 |
| 2024-10-09 06:00:00 | MSFT | Stock | 415.8 | 417.48 | 415.8 | 416.7 | 6288.0 |
| 2024-10-09 07:00:00 | MSFT | Stock | 416.7 | 416.7 | 415.51 | 415.52 | 8119.0 |
| 2024-10-09 08:00:00 | MSFT | Stock | 416.71 | 416.71 | 414.21 | 415.456 | 41134.0 |
| 2024-10-09 09:00:00 | MSFT | Stock | 415.333 | 416.7899 | 414.3 | 415.45 | 1107379.0 |
| 2024-10-09 10:00:00 | MSFT | Stock | 415.465 | 418.17 | 415.45 | 418.17 | 1613924.0 |
| 2024-10-09 11:00:00 | MSFT | Stock | 418.13 | 420.38 | 418.07 | 419.81 | 1281850.0 |
| 2024-10-09 12:00:00 | MSFT | Stock | 419.85 | 419.85 | 417.76 | 417.92 | 1047834.0 |
| 2024-10-09 13:00:00 | MSFT | Stock | 417.915 | 418.5596 | 416.6 | 417.31 | 777826.0 |
| 2024-10-09 14:00:00 | MSFT | Stock | 417.34 | 417.99 | 416.91 | 417.36 | 579006.0 |
| 2024-10-09 15:00:00 | MSFT | Stock | 417.365 | 418.22 | 416.96 | 417.42 | 1304935.0 |
| 2024-10-09 16:00:00 | MSFT | Stock | 417.46 | 417.46 | 416.75 | 417.0 | 2686958.0 |
| 2024-10-09 17:00:00 | MSFT | Stock | 417.0 | 417.0 | 416.9645 | 417.0 | 11005.0 |
| 2024-10-09 18:00:00 | MSFT | Stock | 417.04 | 417.375 | 416.86 | 416.86 | 8185.0 |
| 2024-10-09 19:00:00 | MSFT | Stock | 416.89 | 417.1465 | 416.51 | 416.51 | 29044.0 |
| 2024-10-09 04:00:00 | NVDA | Stock | 133.38 | 134.64 | 132.73 | 134.52 | 1011298.0 |
| 2024-10-09 05:00:00 | NVDA | Stock | 134.53 | 134.85 | 134.42 | 134.57 | 556840.0 |
| 2024-10-09 06:00:00 | NVDA | Stock | 134.55 | 134.65 | 134.2 | 134.53 | 303200.0 |
| 2024-10-09 07:00:00 | NVDA | Stock | 134.52 | 134.8 | 133.62 | 133.8 | 1512678.0 |
| 2024-10-09 08:00:00 | NVDA | Stock | 133.8 | 134.79 | 132.57 | 134.2 | 3699379.0 |
| 2024-10-09 09:00:00 | NVDA | Stock | 134.2 | 134.7 | 131.38 | 132.36 | 45478627.0 |
| 2024-10-09 10:00:00 | NVDA | Stock | 132.37 | 133.99 | 132.37 | 133.2099 | 43877092.0 |
| 2024-10-09 11:00:00 | NVDA | Stock | 133.2 | 133.8 | 132.54 | 132.725 | 26204769.0 |
| 2024-10-09 12:00:00 | NVDA | Stock | 132.74 | 132.77 | 131.47 | 132.1798 | 24380298.0 |
| 2024-10-09 13:00:00 | NVDA | Stock | 132.18 | 132.26 | 131.48 | 131.82 | 18924141.0 |
| 2024-10-09 14:00:00 | NVDA | Stock | 131.82 | 132.69 | 131.58 | 132.3311 | 17803688.0 |
| 2024-10-09 15:00:00 | NVDA | Stock | 132.34 | 132.84 | 132.15 | 132.61 | 22174050.0 |
| 2024-10-09 16:00:00 | NVDA | Stock | 132.62 | 132.65 | 132.15 | 132.35 | 11270223.0 |
| 2024-10-09 17:00:00 | NVDA | Stock | 132.35 | 132.43 | 132.3 | 132.339 | 243719.0 |
| 2024-10-09 18:00:00 | NVDA | Stock | 132.34 | 132.4 | 132.12 | 132.14 | 268480.0 |
| 2024-10-09 19:00:00 | NVDA | Stock | 132.2 | 132.36 | 132.07 | 132.14 | 394784.0 |
| 2024-10-09 04:00:00 | AMZN | Stock | 182.63 | 183.12 | 182.61 | 183.06 | 15780.0 |
| 2024-10-09 05:00:00 | AMZN | Stock | 183.15 | 183.15 | 183.02 | 183.02 | 1778.0 |
> showing 50 of 58,566 rows — these rows as CSV