PREVIEW / stock_30min / 2024-09-26
file: by_date/stock_30min/2024/2024-09-26.parquet size: 2.1 MB rows: 102,650 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 | 227.99 | 226.6 | 227.99 | 19548.0 |
| 2024-09-26 04:30:00 | AAPL | Stock | 228.0 | 228.23 | 227.95 | 227.95 | 2454.0 |
| 2024-09-26 05:00:00 | AAPL | Stock | 228.07 | 228.42 | 228.0 | 228.42 | 19159.0 |
| 2024-09-26 05:30:00 | AAPL | Stock | 228.37 | 228.4 | 228.01 | 228.12 | 3579.0 |
| 2024-09-26 06:00:00 | AAPL | Stock | 228.0 | 228.15 | 227.91 | 228.1 | 14195.0 |
| 2024-09-26 06:30:00 | AAPL | Stock | 228.12 | 228.4 | 228.0 | 228.1 | 8051.0 |
| 2024-09-26 07:00:00 | AAPL | Stock | 228.06 | 228.25 | 227.61 | 227.99 | 38202.0 |
| 2024-09-26 07:30:00 | AAPL | Stock | 227.99 | 228.0 | 227.8 | 227.81 | 10873.0 |
| 2024-09-26 08:00:00 | AAPL | Stock | 227.95 | 228.33 | 226.84 | 227.6199 | 132621.0 |
| 2024-09-26 08:30:00 | AAPL | Stock | 227.62 | 228.19 | 227.41 | 228.1 | 74164.0 |
| 2024-09-26 09:00:00 | AAPL | Stock | 228.13 | 228.39 | 227.24 | 227.27 | 139947.0 |
| 2024-09-26 09:30:00 | AAPL | Stock | 227.31 | 227.64 | 225.41 | 226.52 | 4095888.0 |
| 2024-09-26 10:00:00 | AAPL | Stock | 226.51 | 227.07 | 226.045 | 226.9 | 1692833.0 |
| 2024-09-26 10:30:00 | AAPL | Stock | 226.91 | 228.5 | 226.53 | 227.17 | 2800665.0 |
| 2024-09-26 11:00:00 | AAPL | Stock | 227.19 | 227.94 | 226.85 | 227.3897 | 1436528.0 |
| 2024-09-26 11:30:00 | AAPL | Stock | 227.3865 | 227.82 | 226.68 | 227.7 | 1003613.0 |
| 2024-09-26 12:00:00 | AAPL | Stock | 227.69 | 227.7 | 227.014 | 227.31 | 647168.0 |
| 2024-09-26 12:30:00 | AAPL | Stock | 227.315 | 227.4 | 226.998 | 227.2567 | 535144.0 |
| 2024-09-26 13:00:00 | AAPL | Stock | 227.24 | 227.29 | 226.66 | 227.155 | 758759.0 |
| 2024-09-26 13:30:00 | AAPL | Stock | 227.155 | 227.49 | 227.055 | 227.135 | 820496.0 |
| 2024-09-26 14:00:00 | AAPL | Stock | 227.15 | 227.71 | 226.97 | 227.705 | 731297.0 |
| 2024-09-26 14:30:00 | AAPL | Stock | 227.71 | 227.85 | 227.53 | 227.78 | 637773.0 |
| 2024-09-26 15:00:00 | AAPL | Stock | 227.78 | 227.87 | 227.46 | 227.5799 | 834797.0 |
| 2024-09-26 15:30:00 | AAPL | Stock | 227.58 | 227.79 | 226.85 | 227.52 | 2765753.0 |
| 2024-09-26 16:00:00 | AAPL | Stock | 227.52 | 228.09 | 227.52 | 227.91 | 6917832.0 |
| 2024-09-26 16:30:00 | AAPL | Stock | 227.91 | 228.05 | 227.52 | 227.93 | 58799.0 |
| 2024-09-26 17:00:00 | AAPL | Stock | 227.52 | 228.0 | 227.52 | 228.0 | 26032.0 |
| 2024-09-26 17:30:00 | AAPL | Stock | 227.92 | 227.92 | 227.77 | 227.89 | 6952.0 |
| 2024-09-26 18:00:00 | AAPL | Stock | 227.95 | 228.2 | 227.8156 | 228.05 | 28506.0 |
| 2024-09-26 18:30:00 | AAPL | Stock | 228.05 | 228.25 | 228.0013 | 228.2 | 16177.0 |
| 2024-09-26 19:00:00 | AAPL | Stock | 228.13 | 228.23 | 228.12 | 228.156 | 4816.0 |
| 2024-09-26 19:30:00 | AAPL | Stock | 228.09 | 228.19 | 228.05 | 228.066 | 9946.0 |
| 2024-09-26 04:00:00 | MSFT | Stock | 434.69 | 435.56 | 434.12 | 435.22 | 8777.0 |
| 2024-09-26 04:30:00 | MSFT | Stock | 435.21 | 435.49 | 434.9 | 434.9 | 560.0 |
| 2024-09-26 05:00:00 | MSFT | Stock | 435.3 | 435.57 | 435.3 | 435.57 | 853.0 |
| 2024-09-26 05:30:00 | MSFT | Stock | 435.75 | 435.75 | 435.41 | 435.41 | 928.0 |
| 2024-09-26 06:00:00 | MSFT | Stock | 435.34 | 435.5 | 435.0 | 435.5 | 1164.0 |
| 2024-09-26 06:30:00 | MSFT | Stock | 435.5 | 435.87 | 435.5 | 435.61 | 838.0 |
| 2024-09-26 07:00:00 | MSFT | Stock | 435.61 | 435.61 | 434.84 | 435.12 | 5682.0 |
| 2024-09-26 07:30:00 | MSFT | Stock | 435.06 | 435.25 | 434.5 | 434.85 | 8073.0 |
| 2024-09-26 08:00:00 | MSFT | Stock | 435.3 | 435.5241 | 433.0 | 434.3 | 29118.0 |
| 2024-09-26 08:30:00 | MSFT | Stock | 434.42 | 435.3999 | 434.0 | 435.3999 | 15445.0 |
| 2024-09-26 09:00:00 | MSFT | Stock | 435.3817 | 436.0 | 434.5 | 435.0 | 28237.0 |
| 2024-09-26 09:30:00 | MSFT | Stock | 435.0 | 435.3 | 430.86 | 433.335 | 1658698.0 |
| 2024-09-26 10:00:00 | MSFT | Stock | 433.3 | 433.39 | 430.67 | 430.815 | 579248.0 |
| 2024-09-26 10:30:00 | MSFT | Stock | 430.83 | 431.58 | 430.2 | 430.28 | 532800.0 |
| 2024-09-26 11:00:00 | MSFT | Stock | 430.28 | 431.21 | 429.75 | 430.47 | 389946.0 |
| 2024-09-26 11:30:00 | MSFT | Stock | 430.47 | 431.52 | 429.735 | 431.47 | 299041.0 |
| 2024-09-26 12:00:00 | MSFT | Stock | 431.47 | 431.5 | 429.81 | 430.02 | 279934.0 |
| 2024-09-26 12:30:00 | MSFT | Stock | 430.07 | 430.38 | 429.85 | 430.15 | 167531.0 |
> showing 50 of 102,650 rows — these rows as CSV