PREVIEW / stock_30min / 2024-11-04
file: by_date/stock_30min/2024/2024-11-04.parquet size: 2.1 MB rows: 101,365 symbols: 728
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-11-04 04:00:00 | AAPL | Stock | 221.51 | 221.82 | 221.43 | 221.55 | 10868.0 |
| 2024-11-04 04:30:00 | AAPL | Stock | 221.45 | 221.73 | 221.3 | 221.71 | 16228.0 |
| 2024-11-04 05:00:00 | AAPL | Stock | 221.7 | 222.05 | 221.64 | 221.9 | 8647.0 |
| 2024-11-04 05:30:00 | AAPL | Stock | 221.81 | 222.01 | 221.77 | 222.01 | 5200.0 |
| 2024-11-04 06:00:00 | AAPL | Stock | 221.96 | 221.96 | 221.03 | 221.03 | 23488.0 |
| 2024-11-04 06:30:00 | AAPL | Stock | 221.1 | 221.48 | 221.1 | 221.42 | 6477.0 |
| 2024-11-04 07:00:00 | AAPL | Stock | 221.45 | 222.0 | 221.32 | 221.43 | 39280.0 |
| 2024-11-04 07:30:00 | AAPL | Stock | 221.5 | 221.64 | 221.2 | 221.51 | 26902.0 |
| 2024-11-04 08:00:00 | AAPL | Stock | 221.7714 | 222.3 | 221.1514 | 221.38 | 87600.0 |
| 2024-11-04 08:30:00 | AAPL | Stock | 221.41 | 221.81 | 221.3 | 221.36 | 49405.0 |
| 2024-11-04 09:00:00 | AAPL | Stock | 221.33 | 221.38 | 219.98 | 220.94 | 292985.0 |
| 2024-11-04 09:30:00 | AAPL | Stock | 220.93 | 222.41 | 219.71 | 222.065 | 4954504.0 |
| 2024-11-04 10:00:00 | AAPL | Stock | 222.06 | 222.54 | 221.595 | 221.735 | 1825134.0 |
| 2024-11-04 10:30:00 | AAPL | Stock | 221.75 | 222.265 | 221.35 | 221.61 | 1321581.0 |
| 2024-11-04 11:00:00 | AAPL | Stock | 221.62 | 222.01 | 221.1301 | 221.49 | 1130389.0 |
| 2024-11-04 11:30:00 | AAPL | Stock | 221.495 | 221.57 | 220.81 | 221.08 | 1079057.0 |
| 2024-11-04 12:00:00 | AAPL | Stock | 221.071 | 221.2 | 220.41 | 221.1151 | 1168822.0 |
| 2024-11-04 12:30:00 | AAPL | Stock | 221.115 | 222.15 | 221.0201 | 221.79 | 949992.0 |
| 2024-11-04 13:00:00 | AAPL | Stock | 221.77 | 222.62 | 221.46 | 222.0205 | 1059761.0 |
| 2024-11-04 13:30:00 | AAPL | Stock | 222.02 | 222.6088 | 221.9601 | 222.4 | 747347.0 |
| 2024-11-04 14:00:00 | AAPL | Stock | 222.43 | 222.6191 | 222.23 | 222.26 | 752766.0 |
| 2024-11-04 14:30:00 | AAPL | Stock | 222.25 | 222.76 | 222.2 | 222.625 | 755232.0 |
| 2024-11-04 15:00:00 | AAPL | Stock | 222.625 | 222.79 | 222.4 | 222.5 | 976739.0 |
| 2024-11-04 15:30:00 | AAPL | Stock | 222.5 | 222.56 | 221.52 | 222.12 | 2983931.0 |
| 2024-11-04 16:00:00 | AAPL | Stock | 222.06 | 222.2998 | 221.8018 | 222.06 | 8170013.0 |
| 2024-11-04 16:30:00 | AAPL | Stock | 222.04 | 222.07 | 221.8118 | 221.98 | 76074.0 |
| 2024-11-04 17:00:00 | AAPL | Stock | 221.91 | 222.01 | 221.6036 | 221.6036 | 1439084.0 |
| 2024-11-04 17:30:00 | AAPL | Stock | 221.72 | 221.72 | 221.61 | 221.6132 | 6484.0 |
| 2024-11-04 18:00:00 | AAPL | Stock | 221.68 | 222.0 | 221.61 | 221.89 | 15603.0 |
| 2024-11-04 18:30:00 | AAPL | Stock | 221.85 | 221.85 | 221.62 | 221.7 | 10294.0 |
| 2024-11-04 19:00:00 | AAPL | Stock | 221.63 | 221.7696 | 221.6 | 221.6 | 2260.0 |
| 2024-11-04 19:30:00 | AAPL | Stock | 221.5885 | 221.59 | 221.5 | 221.53 | 9716.0 |
| 2024-11-04 04:00:00 | MSFT | Stock | 411.91 | 411.91 | 410.15 | 411.58 | 8042.0 |
| 2024-11-04 04:30:00 | MSFT | Stock | 411.45 | 411.45 | 411.23 | 411.24 | 3048.0 |
| 2024-11-04 05:00:00 | MSFT | Stock | 411.37 | 411.75 | 411.37 | 411.75 | 565.0 |
| 2024-11-04 05:30:00 | MSFT | Stock | 411.92 | 411.95 | 411.9 | 411.95 | 621.0 |
| 2024-11-04 06:00:00 | MSFT | Stock | 411.74 | 411.74 | 411.56 | 411.56 | 567.0 |
| 2024-11-04 06:30:00 | MSFT | Stock | 411.5 | 411.5 | 411.0 | 411.0 | 3490.0 |
| 2024-11-04 07:00:00 | MSFT | Stock | 411.03 | 411.03 | 409.53 | 409.53 | 10514.0 |
| 2024-11-04 07:30:00 | MSFT | Stock | 409.9 | 410.01 | 409.27 | 410.01 | 9523.0 |
| 2024-11-04 08:00:00 | MSFT | Stock | 410.4 | 412.0 | 409.3 | 410.99 | 40186.0 |
| 2024-11-04 08:30:00 | MSFT | Stock | 410.8719 | 411.27 | 409.54 | 410.0 | 11733.0 |
| 2024-11-04 09:00:00 | MSFT | Stock | 409.85 | 410.0 | 408.67 | 410.0 | 19448.0 |
| 2024-11-04 09:30:00 | MSFT | Stock | 410.0 | 410.22 | 405.5713 | 409.1 | 1885956.0 |
| 2024-11-04 10:00:00 | MSFT | Stock | 409.075 | 410.22 | 408.55 | 409.775 | 639416.0 |
| 2024-11-04 10:30:00 | MSFT | Stock | 409.78 | 410.415 | 409.42 | 409.67 | 406298.0 |
| 2024-11-04 11:00:00 | MSFT | Stock | 409.705 | 409.86 | 408.09 | 408.1 | 549896.0 |
| 2024-11-04 11:30:00 | MSFT | Stock | 408.07 | 408.2899 | 406.11 | 406.61 | 575911.0 |
| 2024-11-04 12:00:00 | MSFT | Stock | 406.65 | 407.39 | 405.87 | 407.085 | 436205.0 |
| 2024-11-04 12:30:00 | MSFT | Stock | 407.1 | 407.48 | 406.7 | 407.17 | 344026.0 |
> showing 50 of 101,365 rows — these rows as CSV