PREVIEW / stock_30min / 2023-10-10
file: by_date/stock_30min/2023/2023-10-10.parquet size: 2.0 MB rows: 96,299 symbols: 1,387
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-10-10 04:00:00 | AAPL | Stock | 179.0 | 179.25 | 178.85 | 179.25 | 14425.0 |
| 2023-10-10 04:30:00 | AAPL | Stock | 179.3 | 179.35 | 179.2 | 179.35 | 5305.0 |
| 2023-10-10 05:00:00 | AAPL | Stock | 179.3 | 179.3 | 179.15 | 179.18 | 7792.0 |
| 2023-10-10 05:30:00 | AAPL | Stock | 179.15 | 179.16 | 179.1 | 179.12 | 1115.0 |
| 2023-10-10 06:00:00 | AAPL | Stock | 179.14 | 179.18 | 179.05 | 179.18 | 4506.0 |
| 2023-10-10 06:30:00 | AAPL | Stock | 179.17 | 179.17 | 178.82 | 178.82 | 9988.0 |
| 2023-10-10 07:00:00 | AAPL | Stock | 178.89 | 178.89 | 178.2 | 178.25 | 22334.0 |
| 2023-10-10 07:30:00 | AAPL | Stock | 178.3 | 178.51 | 177.7 | 177.7 | 52556.0 |
| 2023-10-10 08:00:00 | AAPL | Stock | 178.25 | 179.11 | 177.7 | 178.29 | 102952.0 |
| 2023-10-10 08:30:00 | AAPL | Stock | 178.3 | 178.3765 | 178.0 | 178.15 | 58044.0 |
| 2023-10-10 09:00:00 | AAPL | Stock | 178.03 | 178.3462 | 177.85 | 178.1 | 85793.0 |
| 2023-10-10 09:30:00 | AAPL | Stock | 178.1 | 179.16 | 178.1 | 178.63 | 4177723.0 |
| 2023-10-10 10:00:00 | AAPL | Stock | 178.63 | 179.31 | 178.35 | 179.1851 | 3199525.0 |
| 2023-10-10 10:30:00 | AAPL | Stock | 179.191 | 179.43 | 179.04 | 179.32 | 2289753.0 |
| 2023-10-10 11:00:00 | AAPL | Stock | 179.33 | 179.68 | 179.13 | 179.48 | 2100755.0 |
| 2023-10-10 11:30:00 | AAPL | Stock | 179.485 | 179.675 | 179.34 | 179.565 | 1410288.0 |
| 2023-10-10 12:00:00 | AAPL | Stock | 179.56 | 179.72 | 179.44 | 179.6101 | 1120197.0 |
| 2023-10-10 12:30:00 | AAPL | Stock | 179.62 | 179.69 | 179.35 | 179.51 | 1152156.0 |
| 2023-10-10 13:00:00 | AAPL | Stock | 179.5 | 179.5 | 178.14 | 178.45 | 2989164.0 |
| 2023-10-10 13:30:00 | AAPL | Stock | 178.46 | 178.5759 | 178.04 | 178.275 | 1944299.0 |
| 2023-10-10 14:00:00 | AAPL | Stock | 178.27 | 178.3946 | 177.95 | 178.17 | 1810314.0 |
| 2023-10-10 14:30:00 | AAPL | Stock | 178.19 | 178.63 | 177.96 | 178.175 | 1865543.0 |
| 2023-10-10 15:00:00 | AAPL | Stock | 178.175 | 178.9099 | 178.07 | 178.79 | 2125992.0 |
| 2023-10-10 15:30:00 | AAPL | Stock | 178.79 | 178.8 | 178.12 | 178.41 | 4891446.0 |
| 2023-10-10 16:00:00 | AAPL | Stock | 178.42 | 178.58 | 178.33 | 178.33 | 5473685.0 |
| 2023-10-10 16:30:00 | AAPL | Stock | 178.37 | 178.42 | 178.3 | 178.37 | 25559.0 |
| 2023-10-10 17:00:00 | AAPL | Stock | 178.35 | 178.49 | 178.31 | 178.35 | 9393.0 |
| 2023-10-10 17:30:00 | AAPL | Stock | 178.3279 | 178.39 | 178.31 | 178.31 | 21828.0 |
| 2023-10-10 18:00:00 | AAPL | Stock | 178.34 | 178.39 | 178.33 | 178.39 | 13505.0 |
| 2023-10-10 18:30:00 | AAPL | Stock | 178.39 | 178.45 | 178.3701 | 178.45 | 11567.0 |
| 2023-10-10 19:00:00 | AAPL | Stock | 178.45 | 178.5 | 178.41 | 178.48 | 4147.0 |
| 2023-10-10 19:30:00 | AAPL | Stock | 178.49 | 178.54 | 178.42 | 178.54 | 3626.0 |
| 2023-10-10 04:00:00 | MSFT | Stock | 330.33 | 330.6 | 330.33 | 330.6 | 1181.0 |
| 2023-10-10 04:30:00 | MSFT | Stock | 331.09 | 331.27 | 331.0 | 331.27 | 1111.0 |
| 2023-10-10 05:00:00 | MSFT | Stock | 331.1 | 331.3 | 331.0 | 331.29 | 1415.0 |
| 2023-10-10 05:30:00 | MSFT | Stock | 331.11 | 331.3 | 331.11 | 331.18 | 1614.0 |
| 2023-10-10 06:00:00 | MSFT | Stock | 331.3 | 331.3 | 331.09 | 331.09 | 271.0 |
| 2023-10-10 06:30:00 | MSFT | Stock | 331.17 | 331.3 | 331.17 | 331.2 | 2807.0 |
| 2023-10-10 07:00:00 | MSFT | Stock | 331.1 | 331.6 | 330.36 | 330.5 | 11070.0 |
| 2023-10-10 07:30:00 | MSFT | Stock | 330.7 | 330.94 | 330.42 | 330.42 | 6081.0 |
| 2023-10-10 08:00:00 | MSFT | Stock | 331.01 | 331.7557 | 329.33 | 331.01 | 33998.0 |
| 2023-10-10 08:30:00 | MSFT | Stock | 331.12 | 331.55 | 330.3522 | 331.35 | 7185.0 |
| 2023-10-10 09:00:00 | MSFT | Stock | 331.2 | 331.3 | 330.65 | 330.8 | 17501.0 |
| 2023-10-10 09:30:00 | MSFT | Stock | 330.8 | 331.1 | 327.9925 | 329.14 | 1888163.0 |
| 2023-10-10 10:00:00 | MSFT | Stock | 329.18 | 329.86 | 328.55 | 328.785 | 1091046.0 |
| 2023-10-10 10:30:00 | MSFT | Stock | 328.8 | 330.31 | 328.56 | 329.59 | 1528680.0 |
| 2023-10-10 11:00:00 | MSFT | Stock | 329.65 | 330.65 | 329.25 | 330.27 | 1272349.0 |
| 2023-10-10 11:30:00 | MSFT | Stock | 330.28 | 330.98 | 329.85 | 330.54 | 944517.0 |
| 2023-10-10 12:00:00 | MSFT | Stock | 330.54 | 330.67 | 330.08 | 330.6 | 546423.0 |
| 2023-10-10 12:30:00 | MSFT | Stock | 330.59 | 330.68 | 329.83 | 330.0601 | 495882.0 |
> showing 50 of 96,299 rows — these rows as CSV