PREVIEW / stock_30min / 2023-10-11
file: by_date/stock_30min/2023/2023-10-11.parquet size: 2.0 MB rows: 97,374 symbols: 1,380
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-11 04:00:00 | AAPL | Stock | 178.62 | 178.62 | 178.36 | 178.36 | 5390.0 |
| 2023-10-11 04:30:00 | AAPL | Stock | 178.5 | 178.61 | 178.4 | 178.4 | 4005.0 |
| 2023-10-11 05:00:00 | AAPL | Stock | 178.4 | 178.47 | 178.35 | 178.35 | 1363.0 |
| 2023-10-11 05:30:00 | AAPL | Stock | 178.44 | 178.61 | 178.44 | 178.6 | 885.0 |
| 2023-10-11 06:00:00 | AAPL | Stock | 178.6 | 178.64 | 178.47 | 178.49 | 2106.0 |
| 2023-10-11 06:30:00 | AAPL | Stock | 178.55 | 178.6 | 178.52 | 178.58 | 2836.0 |
| 2023-10-11 07:00:00 | AAPL | Stock | 178.56 | 178.87 | 178.56 | 178.74 | 7086.0 |
| 2023-10-11 07:30:00 | AAPL | Stock | 178.75 | 178.9 | 178.4 | 178.44 | 22915.0 |
| 2023-10-11 08:00:00 | AAPL | Stock | 178.58 | 178.92 | 178.18 | 178.18 | 88521.0 |
| 2023-10-11 08:30:00 | AAPL | Stock | 178.2 | 178.44 | 177.63 | 178.44 | 134174.0 |
| 2023-10-11 09:00:00 | AAPL | Stock | 178.43 | 178.49 | 178.0 | 178.2 | 139073.0 |
| 2023-10-11 09:30:00 | AAPL | Stock | 178.25 | 178.9576 | 177.6 | 177.935 | 5163162.0 |
| 2023-10-11 10:00:00 | AAPL | Stock | 177.93 | 178.32 | 177.67 | 178.28 | 2875417.0 |
| 2023-10-11 10:30:00 | AAPL | Stock | 178.28 | 179.28 | 178.131 | 179.1 | 3180370.0 |
| 2023-10-11 11:00:00 | AAPL | Stock | 179.1 | 179.32 | 178.56 | 178.5883 | 2668581.0 |
| 2023-10-11 11:30:00 | AAPL | Stock | 178.59 | 178.95 | 178.445 | 178.7083 | 1837118.0 |
| 2023-10-11 12:00:00 | AAPL | Stock | 178.71 | 178.74 | 178.365 | 178.5701 | 1576018.0 |
| 2023-10-11 12:30:00 | AAPL | Stock | 178.58 | 178.71 | 178.27 | 178.625 | 1522080.0 |
| 2023-10-11 13:00:00 | AAPL | Stock | 178.64 | 178.742 | 178.33 | 178.5907 | 1399896.0 |
| 2023-10-11 13:30:00 | AAPL | Stock | 178.59 | 178.68 | 178.36 | 178.63 | 987426.0 |
| 2023-10-11 14:00:00 | AAPL | Stock | 178.62 | 179.38 | 178.59 | 178.95 | 2265044.0 |
| 2023-10-11 14:30:00 | AAPL | Stock | 178.95 | 179.22 | 178.9 | 179.085 | 1756117.0 |
| 2023-10-11 15:00:00 | AAPL | Stock | 179.0773 | 179.29 | 179.04 | 179.17 | 1922411.0 |
| 2023-10-11 15:30:00 | AAPL | Stock | 179.17 | 179.85 | 179.14 | 179.75 | 5109769.0 |
| 2023-10-11 16:00:00 | AAPL | Stock | 179.74 | 180.3883 | 179.74 | 180.08 | 6351518.0 |
| 2023-10-11 16:30:00 | AAPL | Stock | 180.08 | 180.24 | 179.8 | 180.24 | 74838.0 |
| 2023-10-11 17:00:00 | AAPL | Stock | 180.23 | 180.29 | 180.19 | 180.26 | 36082.0 |
| 2023-10-11 17:30:00 | AAPL | Stock | 180.26 | 180.33 | 180.2 | 180.22 | 21665.0 |
| 2023-10-11 18:00:00 | AAPL | Stock | 180.21 | 180.28 | 180.21 | 180.25 | 8391.0 |
| 2023-10-11 18:30:00 | AAPL | Stock | 180.23 | 180.33 | 180.23 | 180.29 | 9957.0 |
| 2023-10-11 19:00:00 | AAPL | Stock | 180.29 | 180.29 | 180.2 | 180.27 | 10532.0 |
| 2023-10-11 19:30:00 | AAPL | Stock | 180.2201 | 180.38 | 180.22 | 180.36 | 34506.0 |
| 2023-10-11 04:00:00 | MSFT | Stock | 329.33 | 329.33 | 328.8 | 328.8 | 639.0 |
| 2023-10-11 04:30:00 | MSFT | Stock | 328.66 | 328.66 | 328.66 | 328.66 | 200.0 |
| 2023-10-11 05:00:00 | MSFT | Stock | 329.53 | 329.53 | 329.4 | 329.4 | 400.0 |
| 2023-10-11 05:30:00 | MSFT | Stock | 329.5 | 329.5 | 329.5 | 329.5 | 400.0 |
| 2023-10-11 06:00:00 | MSFT | Stock | 329.41 | 329.46 | 329.41 | 329.46 | 300.0 |
| 2023-10-11 06:30:00 | MSFT | Stock | 329.6 | 329.8 | 329.6 | 329.6 | 1292.0 |
| 2023-10-11 07:00:00 | MSFT | Stock | 329.85 | 330.15 | 329.85 | 330.15 | 804.0 |
| 2023-10-11 07:30:00 | MSFT | Stock | 330.0 | 330.0 | 329.74 | 329.75 | 1739.0 |
| 2023-10-11 08:00:00 | MSFT | Stock | 329.77 | 330.5 | 329.28 | 330.26 | 21880.0 |
| 2023-10-11 08:30:00 | MSFT | Stock | 330.24 | 330.45 | 329.5 | 330.44 | 15404.0 |
| 2023-10-11 09:00:00 | MSFT | Stock | 330.1705 | 331.49 | 329.82 | 331.19 | 28087.0 |
| 2023-10-11 09:30:00 | MSFT | Stock | 331.22 | 332.59 | 330.74 | 331.485 | 1998990.0 |
| 2023-10-11 10:00:00 | MSFT | Stock | 331.495 | 331.495 | 329.8 | 331.04 | 1228906.0 |
| 2023-10-11 10:30:00 | MSFT | Stock | 331.01 | 331.69 | 330.3678 | 331.455 | 849153.0 |
| 2023-10-11 11:00:00 | MSFT | Stock | 331.455 | 332.13 | 330.67 | 330.69 | 977918.0 |
| 2023-10-11 11:30:00 | MSFT | Stock | 330.69 | 331.38 | 330.42 | 330.735 | 558694.0 |
| 2023-10-11 12:00:00 | MSFT | Stock | 330.7957 | 330.7957 | 329.97 | 330.34 | 444553.0 |
| 2023-10-11 12:30:00 | MSFT | Stock | 330.34 | 330.62 | 329.65 | 330.44 | 442314.0 |
> showing 50 of 97,374 rows — these rows as CSV