PREVIEW / stock_30min / 2023-12-04
file: by_date/stock_30min/2023/2023-12-04.parquet size: 2.1 MB rows: 103,543 symbols: 1,290
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-04 04:00:00 | AAPL | Stock | 190.7 | 190.82 | 190.19 | 190.24 | 10218.0 |
| 2023-12-04 04:30:00 | AAPL | Stock | 190.3 | 190.39 | 190.3 | 190.31 | 9469.0 |
| 2023-12-04 05:00:00 | AAPL | Stock | 190.3 | 190.35 | 190.3 | 190.35 | 4621.0 |
| 2023-12-04 05:30:00 | AAPL | Stock | 190.36 | 190.36 | 190.16 | 190.18 | 6276.0 |
| 2023-12-04 06:00:00 | AAPL | Stock | 190.2 | 190.25 | 190.2 | 190.25 | 750.0 |
| 2023-12-04 06:30:00 | AAPL | Stock | 190.3 | 190.33 | 190.0 | 190.0 | 13401.0 |
| 2023-12-04 07:00:00 | AAPL | Stock | 190.09 | 190.21 | 189.78 | 189.98 | 23051.0 |
| 2023-12-04 07:30:00 | AAPL | Stock | 189.98 | 190.25 | 189.98 | 190.22 | 13889.0 |
| 2023-12-04 08:00:00 | AAPL | Stock | 190.11 | 191.24 | 189.81 | 190.1 | 62125.0 |
| 2023-12-04 08:30:00 | AAPL | Stock | 190.1 | 190.1 | 189.76 | 189.9051 | 46714.0 |
| 2023-12-04 09:00:00 | AAPL | Stock | 189.86 | 190.0 | 189.5 | 190.0 | 134390.0 |
| 2023-12-04 09:30:00 | AAPL | Stock | 189.98 | 190.05 | 188.93 | 189.3972 | 5289769.0 |
| 2023-12-04 10:00:00 | AAPL | Stock | 189.4 | 189.64 | 188.09 | 188.16 | 3125142.0 |
| 2023-12-04 10:30:00 | AAPL | Stock | 188.16 | 188.28 | 187.75 | 188.03 | 3051469.0 |
| 2023-12-04 11:00:00 | AAPL | Stock | 188.02 | 188.08 | 187.4511 | 187.97 | 2481085.0 |
| 2023-12-04 11:30:00 | AAPL | Stock | 187.96 | 188.42 | 187.835 | 188.3601 | 1597783.0 |
| 2023-12-04 12:00:00 | AAPL | Stock | 188.365 | 188.57 | 188.19 | 188.4542 | 1510425.0 |
| 2023-12-04 12:30:00 | AAPL | Stock | 188.46 | 188.77 | 188.42 | 188.67 | 1133193.0 |
| 2023-12-04 13:00:00 | AAPL | Stock | 188.67 | 188.81 | 188.495 | 188.5499 | 1210203.0 |
| 2023-12-04 13:30:00 | AAPL | Stock | 188.545 | 188.78 | 188.49 | 188.665 | 1020210.0 |
| 2023-12-04 14:00:00 | AAPL | Stock | 188.665 | 188.965 | 188.495 | 188.85 | 1364168.0 |
| 2023-12-04 14:30:00 | AAPL | Stock | 188.84 | 189.13 | 188.78 | 189.0117 | 1159475.0 |
| 2023-12-04 15:00:00 | AAPL | Stock | 189.01 | 189.07 | 188.72 | 189.06 | 1609765.0 |
| 2023-12-04 15:30:00 | AAPL | Stock | 189.065 | 189.66 | 188.98 | 189.45 | 4670325.0 |
| 2023-12-04 16:00:00 | AAPL | Stock | 189.43 | 189.43 | 189.09 | 189.14 | 6327324.0 |
| 2023-12-04 16:30:00 | AAPL | Stock | 189.15 | 189.43 | 189.07 | 189.18 | 44531.0 |
| 2023-12-04 17:00:00 | AAPL | Stock | 189.17 | 189.43 | 189.17 | 189.43 | 109920.0 |
| 2023-12-04 17:30:00 | AAPL | Stock | 189.22 | 189.34 | 189.16 | 189.25 | 5658.0 |
| 2023-12-04 18:00:00 | AAPL | Stock | 189.2 | 189.2 | 189.11 | 189.1101 | 2912.0 |
| 2023-12-04 18:30:00 | AAPL | Stock | 189.08 | 189.1024 | 189.05 | 189.05 | 2632.0 |
| 2023-12-04 19:00:00 | AAPL | Stock | 189.09 | 189.17 | 189.03 | 189.07 | 4116.0 |
| 2023-12-04 19:30:00 | AAPL | Stock | 189.07 | 189.29 | 189.04 | 189.21 | 5332.0 |
| 2023-12-04 04:00:00 | MSFT | Stock | 373.0 | 373.0 | 372.4 | 372.4 | 927.0 |
| 2023-12-04 04:30:00 | MSFT | Stock | 372.56 | 372.68 | 372.15 | 372.15 | 1300.0 |
| 2023-12-04 05:30:00 | MSFT | Stock | 372.42 | 372.55 | 372.32 | 372.4 | 775.0 |
| 2023-12-04 06:00:00 | MSFT | Stock | 372.54 | 372.57 | 372.48 | 372.57 | 2547.0 |
| 2023-12-04 06:30:00 | MSFT | Stock | 372.58 | 372.58 | 372.0 | 372.0 | 2902.0 |
| 2023-12-04 07:00:00 | MSFT | Stock | 372.0 | 372.0 | 371.7 | 372.0 | 5210.0 |
| 2023-12-04 07:30:00 | MSFT | Stock | 372.06 | 372.3 | 372.06 | 372.27 | 2590.0 |
| 2023-12-04 08:00:00 | MSFT | Stock | 372.08 | 374.51 | 371.51 | 371.51 | 30893.0 |
| 2023-12-04 08:30:00 | MSFT | Stock | 371.51 | 371.62 | 370.75 | 370.8898 | 29182.0 |
| 2023-12-04 09:00:00 | MSFT | Stock | 370.6955 | 370.73 | 368.57 | 369.12 | 122368.0 |
| 2023-12-04 09:30:00 | MSFT | Stock | 369.15 | 369.3 | 363.68 | 365.02 | 5471085.0 |
| 2023-12-04 10:00:00 | MSFT | Stock | 365.02 | 366.3999 | 363.068 | 363.64 | 2324101.0 |
| 2023-12-04 10:30:00 | MSFT | Stock | 363.61 | 364.89 | 362.9 | 364.44 | 1935730.0 |
| 2023-12-04 11:00:00 | MSFT | Stock | 364.44 | 365.86 | 363.95 | 365.71 | 1241026.0 |
| 2023-12-04 11:30:00 | MSFT | Stock | 365.7101 | 367.99 | 365.5777 | 367.7699 | 1164157.0 |
| 2023-12-04 12:00:00 | MSFT | Stock | 367.77 | 368.6 | 367.18 | 368.205 | 1135003.0 |
| 2023-12-04 12:30:00 | MSFT | Stock | 368.2 | 369.265 | 368.01 | 369.17 | 981313.0 |
| 2023-12-04 13:00:00 | MSFT | Stock | 369.18 | 369.4599 | 368.333 | 368.3702 | 873390.0 |
> showing 50 of 103,543 rows — these rows as CSV