PREVIEW / stock_30min / 2023-12-22
file: by_date/stock_30min/2023/2023-12-22.parquet size: 2.1 MB rows: 101,235 symbols: 1,232
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-12-22 04:00:00 | AAPL | Stock | 194.46 | 194.46 | 193.84 | 194.18 | 13283.0 |
| 2023-12-22 04:30:00 | AAPL | Stock | 194.31 | 194.31 | 194.21 | 194.21 | 1845.0 |
| 2023-12-22 05:00:00 | AAPL | Stock | 194.21 | 194.35 | 194.15 | 194.35 | 691.0 |
| 2023-12-22 05:30:00 | AAPL | Stock | 194.42 | 194.56 | 194.31 | 194.53 | 6557.0 |
| 2023-12-22 06:00:00 | AAPL | Stock | 194.59 | 194.68 | 194.58 | 194.64 | 996.0 |
| 2023-12-22 06:30:00 | AAPL | Stock | 194.66 | 194.69 | 194.59 | 194.69 | 1647.0 |
| 2023-12-22 07:00:00 | AAPL | Stock | 194.74 | 194.96 | 194.74 | 194.96 | 7669.0 |
| 2023-12-22 07:30:00 | AAPL | Stock | 194.95 | 194.99 | 194.84 | 194.94 | 16503.0 |
| 2023-12-22 08:00:00 | AAPL | Stock | 194.665 | 195.12 | 194.1 | 195.0 | 67900.0 |
| 2023-12-22 08:30:00 | AAPL | Stock | 194.95 | 195.2 | 194.63 | 195.18 | 98909.0 |
| 2023-12-22 09:00:00 | AAPL | Stock | 195.18 | 195.25 | 194.76 | 195.1 | 82627.0 |
| 2023-12-22 09:30:00 | AAPL | Stock | 195.17 | 195.41 | 194.425 | 195.235 | 3878834.0 |
| 2023-12-22 10:00:00 | AAPL | Stock | 195.23 | 195.29 | 194.55 | 194.665 | 2183402.0 |
| 2023-12-22 10:30:00 | AAPL | Stock | 194.665 | 194.7412 | 194.33 | 194.345 | 2063605.0 |
| 2023-12-22 11:00:00 | AAPL | Stock | 194.34 | 194.38 | 194.01 | 194.175 | 1856546.0 |
| 2023-12-22 11:30:00 | AAPL | Stock | 194.17 | 194.35 | 194.12 | 194.13 | 1240373.0 |
| 2023-12-22 12:00:00 | AAPL | Stock | 194.1399 | 194.32 | 193.84 | 194.05 | 1609021.0 |
| 2023-12-22 12:30:00 | AAPL | Stock | 194.06 | 194.27 | 193.95 | 194.25 | 1223408.0 |
| 2023-12-22 13:00:00 | AAPL | Stock | 194.259 | 194.46 | 194.1 | 194.13 | 1253898.0 |
| 2023-12-22 13:30:00 | AAPL | Stock | 194.125 | 194.295 | 193.98 | 194.0 | 1067324.0 |
| 2023-12-22 14:00:00 | AAPL | Stock | 194.01 | 194.02 | 193.08 | 193.1195 | 1916542.0 |
| 2023-12-22 14:30:00 | AAPL | Stock | 193.115 | 193.9 | 192.97 | 193.8 | 1734160.0 |
| 2023-12-22 15:00:00 | AAPL | Stock | 193.81 | 193.98 | 193.61 | 193.98 | 1828875.0 |
| 2023-12-22 15:30:00 | AAPL | Stock | 193.975 | 193.99 | 193.485 | 193.53 | 3733463.0 |
| 2023-12-22 16:00:00 | AAPL | Stock | 193.62 | 193.76 | 193.53 | 193.55 | 4803756.0 |
| 2023-12-22 16:30:00 | AAPL | Stock | 193.56 | 193.62 | 193.54 | 193.6 | 39564.0 |
| 2023-12-22 17:00:00 | AAPL | Stock | 193.5809 | 193.5901 | 193.55 | 193.58 | 5193.0 |
| 2023-12-22 17:30:00 | AAPL | Stock | 193.56 | 193.6 | 193.56 | 193.58 | 45268.0 |
| 2023-12-22 18:00:00 | AAPL | Stock | 193.57 | 193.6 | 193.56 | 193.6 | 2784.0 |
| 2023-12-22 18:30:00 | AAPL | Stock | 193.58 | 193.65 | 193.58 | 193.6 | 1450.0 |
| 2023-12-22 19:00:00 | AAPL | Stock | 193.57 | 193.57 | 193.55 | 193.57 | 4322.0 |
| 2023-12-22 19:30:00 | AAPL | Stock | 193.59 | 193.59 | 193.55 | 193.58 | 11098.0 |
| 2023-12-22 04:00:00 | MSFT | Stock | 372.3 | 372.3 | 372.3 | 372.3 | 100.0 |
| 2023-12-22 04:30:00 | MSFT | Stock | 372.4 | 372.76 | 372.08 | 372.08 | 1974.0 |
| 2023-12-22 05:00:00 | MSFT | Stock | 372.4 | 372.4 | 372.04 | 372.04 | 746.0 |
| 2023-12-22 05:30:00 | MSFT | Stock | 372.67 | 372.67 | 372.67 | 372.67 | 149.0 |
| 2023-12-22 06:00:00 | MSFT | Stock | 372.8 | 372.97 | 372.71 | 372.71 | 400.0 |
| 2023-12-22 06:30:00 | MSFT | Stock | 372.64 | 372.8 | 372.64 | 372.8 | 800.0 |
| 2023-12-22 07:00:00 | MSFT | Stock | 372.71 | 372.87 | 372.71 | 372.87 | 7649.0 |
| 2023-12-22 07:30:00 | MSFT | Stock | 372.89 | 372.89 | 372.55 | 372.55 | 12227.0 |
| 2023-12-22 08:00:00 | MSFT | Stock | 372.74 | 373.1 | 372.0 | 373.05 | 29562.0 |
| 2023-12-22 08:30:00 | MSFT | Stock | 373.0 | 373.48 | 372.62 | 373.3 | 20758.0 |
| 2023-12-22 09:00:00 | MSFT | Stock | 373.35 | 373.8 | 373.3 | 373.72 | 18099.0 |
| 2023-12-22 09:30:00 | MSFT | Stock | 373.68 | 374.2969 | 372.71 | 374.07 | 1430670.0 |
| 2023-12-22 10:00:00 | MSFT | Stock | 374.09 | 374.89 | 373.9 | 374.615 | 800183.0 |
| 2023-12-22 10:30:00 | MSFT | Stock | 374.63 | 375.18 | 374.52 | 374.64 | 666948.0 |
| 2023-12-22 11:00:00 | MSFT | Stock | 374.6 | 374.96 | 374.01 | 374.745 | 575478.0 |
| 2023-12-22 11:30:00 | MSFT | Stock | 374.73 | 375.0 | 374.24 | 374.4382 | 419814.0 |
| 2023-12-22 12:00:00 | MSFT | Stock | 374.46 | 374.68 | 373.63 | 374.05 | 384715.0 |
| 2023-12-22 12:30:00 | MSFT | Stock | 374.065 | 374.68 | 373.9 | 374.67 | 379271.0 |
> showing 50 of 101,235 rows — these rows as CSV