PREVIEW / stock_30min / 2023-12-13
file: by_date/stock_30min/2023/2023-12-13.parquet size: 2.1 MB rows: 103,727 symbols: 1,305
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-13 04:00:00 | AAPL | Stock | 194.51 | 194.75 | 194.51 | 194.7 | 3853.0 |
| 2023-12-13 04:30:00 | AAPL | Stock | 194.73 | 194.73 | 194.6 | 194.6 | 897.0 |
| 2023-12-13 05:00:00 | AAPL | Stock | 194.65 | 194.65 | 194.48 | 194.5 | 2312.0 |
| 2023-12-13 05:30:00 | AAPL | Stock | 194.44 | 194.51 | 194.41 | 194.51 | 4306.0 |
| 2023-12-13 06:00:00 | AAPL | Stock | 194.51 | 194.61 | 194.51 | 194.58 | 6291.0 |
| 2023-12-13 06:30:00 | AAPL | Stock | 194.61 | 195.36 | 194.61 | 195.36 | 38419.0 |
| 2023-12-13 07:00:00 | AAPL | Stock | 195.18 | 195.21 | 195.05 | 195.09 | 10701.0 |
| 2023-12-13 07:30:00 | AAPL | Stock | 195.05 | 195.46 | 195.0 | 195.4 | 26324.0 |
| 2023-12-13 08:00:00 | AAPL | Stock | 195.1 | 195.83 | 194.53 | 195.78 | 112502.0 |
| 2023-12-13 08:30:00 | AAPL | Stock | 195.78 | 196.19 | 195.75 | 195.89 | 187190.0 |
| 2023-12-13 09:00:00 | AAPL | Stock | 195.83 | 196.0 | 194.71 | 195.01 | 333327.0 |
| 2023-12-13 09:30:00 | AAPL | Stock | 195.08 | 196.58 | 194.85 | 195.91 | 6324917.0 |
| 2023-12-13 10:00:00 | AAPL | Stock | 195.9 | 196.63 | 195.8 | 196.5201 | 3399018.0 |
| 2023-12-13 10:30:00 | AAPL | Stock | 196.525 | 196.7381 | 196.16 | 196.322 | 2993565.0 |
| 2023-12-13 11:00:00 | AAPL | Stock | 196.33 | 196.46 | 195.65 | 195.96 | 2774121.0 |
| 2023-12-13 11:30:00 | AAPL | Stock | 195.965 | 196.28 | 195.91 | 195.9501 | 1382441.0 |
| 2023-12-13 12:00:00 | AAPL | Stock | 195.955 | 196.11 | 195.695 | 195.77 | 1453497.0 |
| 2023-12-13 12:30:00 | AAPL | Stock | 195.7663 | 196.1 | 195.48 | 196.095 | 1461953.0 |
| 2023-12-13 13:00:00 | AAPL | Stock | 196.095 | 196.62 | 196.05 | 196.555 | 2145150.0 |
| 2023-12-13 13:30:00 | AAPL | Stock | 196.555 | 196.92 | 196.43 | 196.47 | 2401999.0 |
| 2023-12-13 14:00:00 | AAPL | Stock | 196.48 | 197.45 | 196.48 | 197.2975 | 4947461.0 |
| 2023-12-13 14:30:00 | AAPL | Stock | 197.295 | 198.0 | 197.0112 | 197.91 | 4895465.0 |
| 2023-12-13 15:00:00 | AAPL | Stock | 197.915 | 197.98 | 196.57 | 196.975 | 4309232.0 |
| 2023-12-13 15:30:00 | AAPL | Stock | 196.975 | 197.89 | 196.67 | 197.88 | 7092261.0 |
| 2023-12-13 16:00:00 | AAPL | Stock | 197.88 | 197.98 | 197.51 | 197.82 | 9663496.0 |
| 2023-12-13 16:30:00 | AAPL | Stock | 197.82 | 197.96 | 197.68 | 197.86 | 337176.0 |
| 2023-12-13 17:00:00 | AAPL | Stock | 197.85 | 197.96 | 197.7 | 197.8 | 221619.0 |
| 2023-12-13 17:30:00 | AAPL | Stock | 197.83 | 198.24 | 197.79 | 198.1 | 136604.0 |
| 2023-12-13 18:00:00 | AAPL | Stock | 198.1 | 198.14 | 197.85 | 197.92 | 68785.0 |
| 2023-12-13 18:30:00 | AAPL | Stock | 197.93 | 197.98 | 197.76 | 197.88 | 72575.0 |
| 2023-12-13 19:00:00 | AAPL | Stock | 197.95 | 198.0 | 197.84 | 197.98 | 36099.0 |
| 2023-12-13 19:30:00 | AAPL | Stock | 197.99 | 198.78 | 197.95 | 198.53 | 86722.0 |
| 2023-12-13 04:00:00 | MSFT | Stock | 374.7 | 374.9 | 374.67 | 374.9 | 1104.0 |
| 2023-12-13 04:30:00 | MSFT | Stock | 375.0 | 375.41 | 375.0 | 375.2 | 1259.0 |
| 2023-12-13 05:00:00 | MSFT | Stock | 375.1 | 375.15 | 375.1 | 375.15 | 674.0 |
| 2023-12-13 05:30:00 | MSFT | Stock | 375.08 | 375.08 | 374.9 | 374.9 | 1675.0 |
| 2023-12-13 06:00:00 | MSFT | Stock | 375.08 | 376.56 | 375.08 | 376.2 | 13413.0 |
| 2023-12-13 06:30:00 | MSFT | Stock | 376.37 | 376.64 | 376.1 | 376.57 | 11140.0 |
| 2023-12-13 07:00:00 | MSFT | Stock | 376.29 | 376.55 | 376.2 | 376.2 | 6976.0 |
| 2023-12-13 07:30:00 | MSFT | Stock | 376.02 | 376.2 | 375.96 | 375.96 | 3055.0 |
| 2023-12-13 08:00:00 | MSFT | Stock | 376.4779 | 376.61 | 374.61 | 376.61 | 36252.0 |
| 2023-12-13 08:30:00 | MSFT | Stock | 376.64 | 377.65 | 376.64 | 377.4448 | 73656.0 |
| 2023-12-13 09:00:00 | MSFT | Stock | 377.6 | 377.69 | 375.8 | 376.02 | 38161.0 |
| 2023-12-13 09:30:00 | MSFT | Stock | 376.11 | 377.6361 | 375.55 | 375.89 | 2421187.0 |
| 2023-12-13 10:00:00 | MSFT | Stock | 375.87 | 375.9 | 374.95 | 375.11 | 1222444.0 |
| 2023-12-13 10:30:00 | MSFT | Stock | 375.1 | 375.85 | 375.07 | 375.16 | 1022246.0 |
| 2023-12-13 11:00:00 | MSFT | Stock | 375.18 | 375.34 | 373.16 | 374.335 | 1043273.0 |
| 2023-12-13 11:30:00 | MSFT | Stock | 374.335 | 374.85 | 373.99 | 374.05 | 730769.0 |
| 2023-12-13 12:00:00 | MSFT | Stock | 374.07 | 374.7218 | 373.945 | 374.4 | 572843.0 |
| 2023-12-13 12:30:00 | MSFT | Stock | 374.4 | 374.47 | 373.84 | 374.06 | 426630.0 |
> showing 50 of 103,727 rows — these rows as CSV