PREVIEW / stock_30min / 2023-11-15
file: by_date/stock_30min/2023/2023-11-15.parquet size: 2.1 MB rows: 101,043 symbols: 1,319
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-15 04:00:00 | AAPL | Stock | 187.82 | 187.86 | 187.79 | 187.8 | 6011.0 |
| 2023-11-15 04:30:00 | AAPL | Stock | 187.8 | 187.8 | 187.7 | 187.78 | 2214.0 |
| 2023-11-15 05:00:00 | AAPL | Stock | 187.8 | 187.88 | 187.8 | 187.88 | 2788.0 |
| 2023-11-15 05:30:00 | AAPL | Stock | 187.9 | 188.05 | 187.9 | 188.01 | 3635.0 |
| 2023-11-15 06:00:00 | AAPL | Stock | 187.95 | 187.96 | 187.95 | 187.96 | 899.0 |
| 2023-11-15 06:30:00 | AAPL | Stock | 188.0 | 188.09 | 188.0 | 188.0 | 1873.0 |
| 2023-11-15 07:00:00 | AAPL | Stock | 187.97 | 188.52 | 187.97 | 188.25 | 46714.0 |
| 2023-11-15 07:30:00 | AAPL | Stock | 188.27 | 188.32 | 188.15 | 188.3 | 38304.0 |
| 2023-11-15 08:00:00 | AAPL | Stock | 188.1009 | 188.5 | 187.48 | 188.3599 | 92115.0 |
| 2023-11-15 08:30:00 | AAPL | Stock | 188.36 | 188.88 | 187.44 | 187.86 | 115299.0 |
| 2023-11-15 09:00:00 | AAPL | Stock | 187.89 | 187.99 | 187.44 | 187.81 | 379300.0 |
| 2023-11-15 09:30:00 | AAPL | Stock | 187.845 | 188.7 | 187.8 | 188.24 | 5343325.0 |
| 2023-11-15 10:00:00 | AAPL | Stock | 188.225 | 188.3625 | 187.85 | 188.15 | 2974673.0 |
| 2023-11-15 10:30:00 | AAPL | Stock | 188.16 | 189.24 | 188.11 | 189.175 | 3577465.0 |
| 2023-11-15 11:00:00 | AAPL | Stock | 189.175 | 189.5 | 188.88 | 189.415 | 3302235.0 |
| 2023-11-15 11:30:00 | AAPL | Stock | 189.415 | 189.4499 | 188.61 | 188.759 | 2408194.0 |
| 2023-11-15 12:00:00 | AAPL | Stock | 188.76 | 189.14 | 188.53 | 189.12 | 2175260.0 |
| 2023-11-15 12:30:00 | AAPL | Stock | 189.11 | 189.17 | 188.72 | 188.7997 | 1343641.0 |
| 2023-11-15 13:00:00 | AAPL | Stock | 188.79 | 189.05 | 188.465 | 189.035 | 2057354.0 |
| 2023-11-15 13:30:00 | AAPL | Stock | 189.031 | 189.08 | 188.845 | 188.94 | 1196531.0 |
| 2023-11-15 14:00:00 | AAPL | Stock | 188.95 | 188.96 | 188.4 | 188.77 | 1551516.0 |
| 2023-11-15 14:30:00 | AAPL | Stock | 188.77 | 188.78 | 188.17 | 188.3126 | 1489762.0 |
| 2023-11-15 15:00:00 | AAPL | Stock | 188.32 | 188.45 | 187.955 | 188.195 | 1787530.0 |
| 2023-11-15 15:30:00 | AAPL | Stock | 188.2 | 188.56 | 187.78 | 188.09 | 4997984.0 |
| 2023-11-15 16:00:00 | AAPL | Stock | 188.11 | 188.28 | 187.84 | 188.11 | 8159639.0 |
| 2023-11-15 16:30:00 | AAPL | Stock | 188.11 | 188.18 | 187.9 | 188.1 | 112257.0 |
| 2023-11-15 17:00:00 | AAPL | Stock | 188.1 | 188.18 | 188.01 | 188.0203 | 36698.0 |
| 2023-11-15 17:30:00 | AAPL | Stock | 188.05 | 188.14 | 188.02 | 188.0217 | 7761.0 |
| 2023-11-15 18:00:00 | AAPL | Stock | 188.07 | 188.35 | 188.07 | 188.35 | 10623.0 |
| 2023-11-15 18:30:00 | AAPL | Stock | 188.25 | 189.64 | 188.25 | 189.0 | 55283.0 |
| 2023-11-15 19:00:00 | AAPL | Stock | 188.85 | 189.0 | 188.63 | 188.8 | 22677.0 |
| 2023-11-15 19:30:00 | AAPL | Stock | 188.81 | 189.0 | 188.68 | 188.7 | 9736.0 |
| 2023-11-15 04:00:00 | MSFT | Stock | 371.6 | 371.94 | 371.5 | 371.5 | 14836.0 |
| 2023-11-15 04:30:00 | MSFT | Stock | 371.48 | 371.49 | 371.31 | 371.37 | 1681.0 |
| 2023-11-15 05:00:00 | MSFT | Stock | 371.7 | 371.89 | 371.7 | 371.79 | 630.0 |
| 2023-11-15 05:30:00 | MSFT | Stock | 371.83 | 372.66 | 371.83 | 372.66 | 2452.0 |
| 2023-11-15 06:00:00 | MSFT | Stock | 372.51 | 372.51 | 372.27 | 372.27 | 2393.0 |
| 2023-11-15 06:30:00 | MSFT | Stock | 372.45 | 372.8 | 372.45 | 372.8 | 7618.0 |
| 2023-11-15 07:00:00 | MSFT | Stock | 372.75 | 372.8 | 371.54 | 371.77 | 33044.0 |
| 2023-11-15 07:30:00 | MSFT | Stock | 371.72 | 372.35 | 371.72 | 372.35 | 15778.0 |
| 2023-11-15 08:00:00 | MSFT | Stock | 372.7 | 372.8 | 370.55 | 372.5 | 56832.0 |
| 2023-11-15 08:30:00 | MSFT | Stock | 372.5 | 373.48 | 369.52 | 371.7 | 56281.0 |
| 2023-11-15 09:00:00 | MSFT | Stock | 371.77 | 371.9 | 370.7641 | 371.31 | 33188.0 |
| 2023-11-15 09:30:00 | MSFT | Stock | 371.35 | 373.13 | 369.62 | 370.41 | 2511032.0 |
| 2023-11-15 10:00:00 | MSFT | Stock | 370.38 | 371.53 | 370.0 | 370.505 | 967908.0 |
| 2023-11-15 10:30:00 | MSFT | Stock | 370.5225 | 370.6 | 369.04 | 369.6 | 1181206.0 |
| 2023-11-15 11:00:00 | MSFT | Stock | 369.64 | 370.48 | 368.42 | 370.29 | 1445630.0 |
| 2023-11-15 11:30:00 | MSFT | Stock | 370.31 | 371.04 | 369.04 | 369.31 | 960469.0 |
| 2023-11-15 12:00:00 | MSFT | Stock | 369.3 | 369.67 | 368.7 | 369.29 | 783556.0 |
| 2023-11-15 12:30:00 | MSFT | Stock | 369.3 | 369.33 | 368.05 | 368.11 | 809049.0 |
> showing 50 of 101,043 rows — these rows as CSV