PREVIEW / stock_30min / 2023-12-01
file: by_date/stock_30min/2023/2023-12-01.parquet size: 2.1 MB rows: 100,957 symbols: 1,262
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-01 04:00:00 | AAPL | Stock | 189.98 | 190.17 | 189.97 | 190.15 | 5910.0 |
| 2023-12-01 04:30:00 | AAPL | Stock | 190.25 | 190.28 | 190.08 | 190.08 | 5124.0 |
| 2023-12-01 05:00:00 | AAPL | Stock | 190.08 | 190.1 | 189.9 | 189.91 | 4534.0 |
| 2023-12-01 05:30:00 | AAPL | Stock | 189.91 | 189.91 | 189.87 | 189.87 | 873.0 |
| 2023-12-01 06:00:00 | AAPL | Stock | 189.85 | 189.95 | 189.85 | 189.95 | 609.0 |
| 2023-12-01 06:30:00 | AAPL | Stock | 189.99 | 190.06 | 189.95 | 189.95 | 1786.0 |
| 2023-12-01 07:00:00 | AAPL | Stock | 189.95 | 189.97 | 189.59 | 189.7 | 29299.0 |
| 2023-12-01 07:30:00 | AAPL | Stock | 189.74 | 189.74 | 189.55 | 189.61 | 10659.0 |
| 2023-12-01 08:00:00 | AAPL | Stock | 189.75 | 190.15 | 189.54 | 189.82 | 20863.0 |
| 2023-12-01 08:30:00 | AAPL | Stock | 189.84 | 189.888 | 189.51 | 189.54 | 41745.0 |
| 2023-12-01 09:00:00 | AAPL | Stock | 189.54 | 190.47 | 189.53 | 190.24 | 113255.0 |
| 2023-12-01 09:30:00 | AAPL | Stock | 190.33 | 190.49 | 189.23 | 189.96 | 3970796.0 |
| 2023-12-01 10:00:00 | AAPL | Stock | 189.97 | 190.5 | 189.913 | 190.06 | 2975152.0 |
| 2023-12-01 10:30:00 | AAPL | Stock | 190.06 | 190.48 | 189.92 | 190.34 | 1964313.0 |
| 2023-12-01 11:00:00 | AAPL | Stock | 190.35 | 190.99 | 190.18 | 190.8301 | 2992330.0 |
| 2023-12-01 11:30:00 | AAPL | Stock | 190.84 | 191.25 | 190.6 | 191.04 | 2634106.0 |
| 2023-12-01 12:00:00 | AAPL | Stock | 191.045 | 191.4502 | 190.9601 | 191.445 | 1756869.0 |
| 2023-12-01 12:30:00 | AAPL | Stock | 191.44 | 191.54 | 191.21 | 191.4982 | 1363330.0 |
| 2023-12-01 13:00:00 | AAPL | Stock | 191.5 | 191.56 | 191.04 | 191.06 | 1376661.0 |
| 2023-12-01 13:30:00 | AAPL | Stock | 191.05 | 191.195 | 190.8201 | 191.17 | 1346438.0 |
| 2023-12-01 14:00:00 | AAPL | Stock | 191.18 | 191.29 | 190.91 | 191.2787 | 1370591.0 |
| 2023-12-01 14:30:00 | AAPL | Stock | 191.28 | 191.34 | 190.94 | 191.28 | 1164478.0 |
| 2023-12-01 15:00:00 | AAPL | Stock | 191.265 | 191.31 | 190.92 | 191.12 | 1160756.0 |
| 2023-12-01 15:30:00 | AAPL | Stock | 191.1224 | 191.38 | 190.8816 | 191.26 | 4290456.0 |
| 2023-12-01 16:00:00 | AAPL | Stock | 191.25 | 191.34 | 191.07 | 191.24 | 4767074.0 |
| 2023-12-01 16:30:00 | AAPL | Stock | 191.24 | 191.3 | 191.06 | 191.15 | 65929.0 |
| 2023-12-01 17:00:00 | AAPL | Stock | 191.14 | 191.24 | 191.06 | 191.17 | 42579.0 |
| 2023-12-01 17:30:00 | AAPL | Stock | 191.2894 | 191.32 | 191.25 | 191.32 | 11040.0 |
| 2023-12-01 18:00:00 | AAPL | Stock | 191.29 | 191.32 | 191.15 | 191.19 | 55756.0 |
| 2023-12-01 18:30:00 | AAPL | Stock | 191.23 | 191.27 | 191.2 | 191.25 | 4298.0 |
| 2023-12-01 19:00:00 | AAPL | Stock | 191.28 | 191.3 | 191.28 | 191.3 | 3064.0 |
| 2023-12-01 19:30:00 | AAPL | Stock | 191.2709 | 191.33 | 191.27 | 191.33 | 5976.0 |
| 2023-12-01 04:00:00 | MSFT | Stock | 378.68 | 379.34 | 378.48 | 379.34 | 5537.0 |
| 2023-12-01 04:30:00 | MSFT | Stock | 379.4 | 379.43 | 378.61 | 379.0 | 5923.0 |
| 2023-12-01 05:00:00 | MSFT | Stock | 379.02 | 379.2 | 379.02 | 379.2 | 1800.0 |
| 2023-12-01 05:30:00 | MSFT | Stock | 378.84 | 378.84 | 378.84 | 378.84 | 215.0 |
| 2023-12-01 06:00:00 | MSFT | Stock | 378.53 | 378.57 | 378.52 | 378.53 | 934.0 |
| 2023-12-01 06:30:00 | MSFT | Stock | 378.77 | 378.85 | 378.5 | 378.5 | 949.0 |
| 2023-12-01 07:00:00 | MSFT | Stock | 378.41 | 378.41 | 377.79 | 378.2 | 4372.0 |
| 2023-12-01 07:30:00 | MSFT | Stock | 378.3 | 378.51 | 378.18 | 378.2 | 12076.0 |
| 2023-12-01 08:00:00 | MSFT | Stock | 378.5217 | 378.69 | 377.8 | 378.6799 | 12022.0 |
| 2023-12-01 08:30:00 | MSFT | Stock | 378.56 | 378.56 | 378.12 | 378.3 | 16633.0 |
| 2023-12-01 09:00:00 | MSFT | Stock | 378.21 | 378.67 | 376.4 | 377.01 | 78628.0 |
| 2023-12-01 09:30:00 | MSFT | Stock | 377.16 | 378.16 | 375.31 | 375.336 | 2040127.0 |
| 2023-12-01 10:00:00 | MSFT | Stock | 375.31 | 376.455 | 372.52 | 372.765 | 2348608.0 |
| 2023-12-01 10:30:00 | MSFT | Stock | 372.77 | 372.89 | 371.31 | 372.372 | 2180908.0 |
| 2023-12-01 11:00:00 | MSFT | Stock | 372.38 | 373.15 | 371.67 | 372.3 | 1728973.0 |
| 2023-12-01 11:30:00 | MSFT | Stock | 372.305 | 373.38 | 371.53 | 373.14 | 1545160.0 |
| 2023-12-01 12:00:00 | MSFT | Stock | 373.13 | 373.5484 | 372.25 | 373.49 | 1114246.0 |
| 2023-12-01 12:30:00 | MSFT | Stock | 373.4801 | 375.3 | 373.36 | 374.66 | 1290592.0 |
> showing 50 of 100,957 rows — these rows as CSV