PREVIEW / stock_30min / 2023-11-24
file: by_date/stock_30min/2023/2023-11-24.parquet size: 1.3 MB rows: 59,578 symbols: 1,211
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-24 04:00:00 | AAPL | Stock | 191.26 | 191.26 | 191.16 | 191.16 | 1601.0 |
| 2023-11-24 04:30:00 | AAPL | Stock | 191.15 | 191.15 | 191.1 | 191.1 | 633.0 |
| 2023-11-24 05:00:00 | AAPL | Stock | 191.08 | 191.08 | 191.08 | 191.08 | 376.0 |
| 2023-11-24 05:30:00 | AAPL | Stock | 191.0 | 191.1 | 190.97 | 191.1 | 5457.0 |
| 2023-11-24 06:00:00 | AAPL | Stock | 191.1 | 191.1 | 190.9 | 190.91 | 3448.0 |
| 2023-11-24 06:30:00 | AAPL | Stock | 190.91 | 190.91 | 190.72 | 190.76 | 3467.0 |
| 2023-11-24 07:00:00 | AAPL | Stock | 190.8 | 190.9 | 190.75 | 190.9 | 7526.0 |
| 2023-11-24 07:30:00 | AAPL | Stock | 190.85 | 190.85 | 190.67 | 190.77 | 9956.0 |
| 2023-11-24 08:00:00 | AAPL | Stock | 190.7989 | 191.35 | 190.61 | 190.7001 | 43488.0 |
| 2023-11-24 08:30:00 | AAPL | Stock | 190.7 | 190.88 | 190.59 | 190.85 | 24562.0 |
| 2023-11-24 09:00:00 | AAPL | Stock | 190.88 | 190.89 | 190.55 | 190.89 | 58609.0 |
| 2023-11-24 09:30:00 | AAPL | Stock | 190.87 | 190.9 | 189.69 | 190.0 | 3827412.0 |
| 2023-11-24 10:00:00 | AAPL | Stock | 189.99 | 190.09 | 189.3 | 189.46 | 2664542.0 |
| 2023-11-24 10:30:00 | AAPL | Stock | 189.47 | 189.67 | 189.25 | 189.485 | 2060857.0 |
| 2023-11-24 11:00:00 | AAPL | Stock | 189.49 | 189.65 | 189.35 | 189.61 | 1960380.0 |
| 2023-11-24 11:30:00 | AAPL | Stock | 189.6 | 189.7889 | 189.35 | 189.6 | 1849151.0 |
| 2023-11-24 12:00:00 | AAPL | Stock | 189.6 | 189.725 | 189.5 | 189.54 | 1463949.0 |
| 2023-11-24 12:30:00 | AAPL | Stock | 189.54 | 190.0 | 189.5181 | 189.98 | 3043263.0 |
| 2023-11-24 13:00:00 | AAPL | Stock | 189.97 | 190.0 | 189.86 | 189.9 | 3119881.0 |
| 2023-11-24 13:30:00 | AAPL | Stock | 189.89 | 189.97 | 189.84 | 189.9 | 58875.0 |
| 2023-11-24 14:00:00 | AAPL | Stock | 189.9 | 189.9602 | 189.85 | 189.94 | 32464.0 |
| 2023-11-24 14:30:00 | AAPL | Stock | 189.94 | 190.0 | 189.92 | 189.92 | 2920.0 |
| 2023-11-24 15:00:00 | AAPL | Stock | 189.97 | 189.97 | 189.9401 | 189.97 | 1357.0 |
| 2023-11-24 15:30:00 | AAPL | Stock | 189.98 | 190.09 | 189.94 | 189.99 | 2287.0 |
| 2023-11-24 16:00:00 | AAPL | Stock | 189.97 | 189.99 | 189.95 | 189.99 | 759.0 |
| 2023-11-24 16:30:00 | AAPL | Stock | 189.93 | 189.95 | 189.9 | 189.9 | 1650.0 |
| 2023-11-24 04:00:00 | MSFT | Stock | 378.25 | 379.33 | 378.08 | 379.33 | 3312.0 |
| 2023-11-24 04:30:00 | MSFT | Stock | 379.0 | 379.01 | 378.94 | 378.94 | 690.0 |
| 2023-11-24 05:00:00 | MSFT | Stock | 378.85 | 378.85 | 378.53 | 378.55 | 700.0 |
| 2023-11-24 05:30:00 | MSFT | Stock | 378.28 | 378.68 | 378.03 | 378.68 | 1117.0 |
| 2023-11-24 06:00:00 | MSFT | Stock | 378.6 | 378.6 | 378.25 | 378.25 | 200.0 |
| 2023-11-24 06:30:00 | MSFT | Stock | 378.61 | 378.73 | 378.61 | 378.73 | 400.0 |
| 2023-11-24 07:00:00 | MSFT | Stock | 378.64 | 378.76 | 378.5 | 378.5 | 12671.0 |
| 2023-11-24 07:30:00 | MSFT | Stock | 378.56 | 378.57 | 378.45 | 378.57 | 3209.0 |
| 2023-11-24 08:00:00 | MSFT | Stock | 378.75 | 378.8 | 377.86 | 377.9966 | 41023.0 |
| 2023-11-24 08:30:00 | MSFT | Stock | 377.85 | 378.0 | 377.3 | 377.3 | 21653.0 |
| 2023-11-24 09:00:00 | MSFT | Stock | 377.3027 | 377.33 | 376.91 | 377.23 | 17092.0 |
| 2023-11-24 09:30:00 | MSFT | Stock | 377.33 | 377.97 | 376.39 | 377.74 | 1547080.0 |
| 2023-11-24 10:00:00 | MSFT | Stock | 377.77 | 377.9 | 375.91 | 375.99 | 853883.0 |
| 2023-11-24 10:30:00 | MSFT | Stock | 375.97 | 376.4479 | 375.135 | 375.785 | 595793.0 |
| 2023-11-24 11:00:00 | MSFT | Stock | 375.79 | 376.14 | 375.38 | 376.11 | 608012.0 |
| 2023-11-24 11:30:00 | MSFT | Stock | 376.09 | 376.71 | 375.63 | 376.51 | 531075.0 |
| 2023-11-24 12:00:00 | MSFT | Stock | 376.504 | 376.85 | 376.34 | 376.77 | 389075.0 |
| 2023-11-24 12:30:00 | MSFT | Stock | 376.76 | 377.5 | 376.23 | 377.3201 | 726090.0 |
| 2023-11-24 13:00:00 | MSFT | Stock | 377.43 | 377.98 | 377.43 | 377.47 | 1397097.0 |
| 2023-11-24 13:30:00 | MSFT | Stock | 377.46 | 377.53 | 377.22 | 377.43 | 9841.0 |
| 2023-11-24 14:00:00 | MSFT | Stock | 377.43 | 377.55 | 377.43 | 377.45 | 2979.0 |
| 2023-11-24 14:30:00 | MSFT | Stock | 377.3 | 377.4 | 376.68 | 377.35 | 2965.0 |
| 2023-11-24 15:00:00 | MSFT | Stock | 377.39 | 377.4 | 377.28 | 377.28 | 1346.0 |
| 2023-11-24 15:30:00 | MSFT | Stock | 377.28 | 377.47 | 377.2 | 377.47 | 2119.0 |
> showing 50 of 59,578 rows — these rows as CSV