PREVIEW / stock_1hour / 2024-09-26
file: by_date/stock_1hour/2024/2024-09-26.parquet size: 1.4 MB rows: 61,016 symbols: 786
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-26 04:00:00 | AAPL | Stock | 227.12 | 228.23 | 226.6 | 227.95 | 22002.0 |
| 2024-09-26 05:00:00 | AAPL | Stock | 228.07 | 228.42 | 228.0 | 228.12 | 22738.0 |
| 2024-09-26 06:00:00 | AAPL | Stock | 228.0 | 228.4 | 227.91 | 228.1 | 22246.0 |
| 2024-09-26 07:00:00 | AAPL | Stock | 228.06 | 228.25 | 227.61 | 227.81 | 49075.0 |
| 2024-09-26 08:00:00 | AAPL | Stock | 227.95 | 228.33 | 226.84 | 228.1 | 206785.0 |
| 2024-09-26 09:00:00 | AAPL | Stock | 228.13 | 228.39 | 225.41 | 226.52 | 4235835.0 |
| 2024-09-26 10:00:00 | AAPL | Stock | 226.51 | 228.5 | 226.045 | 227.17 | 4493498.0 |
| 2024-09-26 11:00:00 | AAPL | Stock | 227.19 | 227.94 | 226.68 | 227.7 | 2440141.0 |
| 2024-09-26 12:00:00 | AAPL | Stock | 227.69 | 227.7 | 226.998 | 227.2567 | 1182312.0 |
| 2024-09-26 13:00:00 | AAPL | Stock | 227.24 | 227.49 | 226.66 | 227.135 | 1579255.0 |
| 2024-09-26 14:00:00 | AAPL | Stock | 227.15 | 227.85 | 226.97 | 227.78 | 1369070.0 |
| 2024-09-26 15:00:00 | AAPL | Stock | 227.78 | 227.87 | 226.85 | 227.52 | 3600550.0 |
| 2024-09-26 16:00:00 | AAPL | Stock | 227.52 | 228.09 | 227.52 | 227.93 | 6976631.0 |
| 2024-09-26 17:00:00 | AAPL | Stock | 227.52 | 228.0 | 227.52 | 227.89 | 32984.0 |
| 2024-09-26 18:00:00 | AAPL | Stock | 227.95 | 228.25 | 227.8156 | 228.2 | 44683.0 |
| 2024-09-26 19:00:00 | AAPL | Stock | 228.13 | 228.23 | 228.05 | 228.066 | 14762.0 |
| 2024-09-26 04:00:00 | MSFT | Stock | 434.69 | 435.56 | 434.12 | 434.9 | 9337.0 |
| 2024-09-26 05:00:00 | MSFT | Stock | 435.3 | 435.75 | 435.3 | 435.41 | 1781.0 |
| 2024-09-26 06:00:00 | MSFT | Stock | 435.34 | 435.87 | 435.0 | 435.61 | 2002.0 |
| 2024-09-26 07:00:00 | MSFT | Stock | 435.61 | 435.61 | 434.5 | 434.85 | 13755.0 |
| 2024-09-26 08:00:00 | MSFT | Stock | 435.3 | 435.5241 | 433.0 | 435.3999 | 44563.0 |
| 2024-09-26 09:00:00 | MSFT | Stock | 435.3817 | 436.0 | 430.86 | 433.335 | 1686935.0 |
| 2024-09-26 10:00:00 | MSFT | Stock | 433.3 | 433.39 | 430.2 | 430.28 | 1112048.0 |
| 2024-09-26 11:00:00 | MSFT | Stock | 430.28 | 431.52 | 429.735 | 431.47 | 688987.0 |
| 2024-09-26 12:00:00 | MSFT | Stock | 431.47 | 431.5 | 429.81 | 430.15 | 447465.0 |
| 2024-09-26 13:00:00 | MSFT | Stock | 430.14 | 430.28 | 429.13 | 429.695 | 726736.0 |
| 2024-09-26 14:00:00 | MSFT | Stock | 429.7 | 430.84 | 429.62 | 429.9 | 747954.0 |
| 2024-09-26 15:00:00 | MSFT | Stock | 429.85 | 431.6 | 429.85 | 431.31 | 1273766.0 |
| 2024-09-26 16:00:00 | MSFT | Stock | 431.31 | 432.05 | 431.31 | 431.7192 | 3034188.0 |
| 2024-09-26 17:00:00 | MSFT | Stock | 431.31 | 431.71 | 431.31 | 431.67 | 8538.0 |
| 2024-09-26 18:00:00 | MSFT | Stock | 431.75 | 433.0 | 431.75 | 432.669 | 13111.0 |
| 2024-09-26 19:00:00 | MSFT | Stock | 432.5 | 432.5 | 431.88 | 432.25 | 1575.0 |
| 2024-09-26 04:00:00 | NVDA | Stock | 126.17 | 126.58 | 125.0 | 126.07 | 1445571.0 |
| 2024-09-26 05:00:00 | NVDA | Stock | 126.08 | 126.15 | 125.38 | 125.58 | 507972.0 |
| 2024-09-26 06:00:00 | NVDA | Stock | 125.57 | 125.87 | 125.4 | 125.8 | 371540.0 |
| 2024-09-26 07:00:00 | NVDA | Stock | 125.82 | 126.75 | 125.57 | 126.33 | 2054975.0 |
| 2024-09-26 08:00:00 | NVDA | Stock | 126.34 | 126.98 | 125.4848 | 126.6108 | 4780072.0 |
| 2024-09-26 09:00:00 | NVDA | Stock | 126.61 | 127.665 | 125.78 | 126.88 | 49459299.0 |
| 2024-09-26 10:00:00 | NVDA | Stock | 126.87 | 127.0 | 122.63 | 122.9599 | 53651150.0 |
| 2024-09-26 11:00:00 | NVDA | Stock | 122.9501 | 124.49 | 122.155 | 124.4708 | 41480498.0 |
| 2024-09-26 12:00:00 | NVDA | Stock | 124.47 | 124.48 | 122.95 | 123.21 | 23144587.0 |
| 2024-09-26 13:00:00 | NVDA | Stock | 123.215 | 123.39 | 121.8 | 123.1966 | 25519047.0 |
| 2024-09-26 14:00:00 | NVDA | Stock | 123.2 | 124.13 | 123.19 | 123.87 | 19855746.0 |
| 2024-09-26 15:00:00 | NVDA | Stock | 123.87 | 124.45 | 123.53 | 123.99 | 26249870.0 |
| 2024-09-26 16:00:00 | NVDA | Stock | 123.98 | 124.04 | 123.7 | 123.78 | 14650501.0 |
| 2024-09-26 17:00:00 | NVDA | Stock | 123.78 | 124.04 | 123.33 | 123.37 | 526856.0 |
| 2024-09-26 18:00:00 | NVDA | Stock | 123.38 | 123.77 | 123.361 | 123.5813 | 481817.0 |
| 2024-09-26 19:00:00 | NVDA | Stock | 123.634 | 123.65 | 123.25 | 123.35 | 442401.0 |
| 2024-09-26 04:00:00 | AMZN | Stock | 193.68 | 194.42 | 193.4 | 194.2 | 19639.0 |
| 2024-09-26 05:00:00 | AMZN | Stock | 194.13 | 194.25 | 194.09 | 194.12 | 3260.0 |
> showing 50 of 61,016 rows — these rows as CSV