PREVIEW / stock_30min / 2024-03-28
file: by_date/stock_30min/2024/2024-03-28.parquet size: 2.1 MB rows: 101,723 symbols: 1,064
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 |
|---|---|---|---|---|---|---|---|
| 2024-03-28 04:00:00 | AAPL | Stock | 173.17 | 173.38 | 172.7 | 172.96 | 7597.0 |
| 2024-03-28 04:30:00 | AAPL | Stock | 172.99 | 173.0 | 172.77 | 172.77 | 1919.0 |
| 2024-03-28 05:00:00 | AAPL | Stock | 172.74 | 172.8 | 172.52 | 172.54 | 5381.0 |
| 2024-03-28 05:30:00 | AAPL | Stock | 172.6 | 172.68 | 172.57 | 172.63 | 2494.0 |
| 2024-03-28 06:00:00 | AAPL | Stock | 172.72 | 172.77 | 172.72 | 172.77 | 1369.0 |
| 2024-03-28 06:30:00 | AAPL | Stock | 172.89 | 172.89 | 172.65 | 172.75 | 3534.0 |
| 2024-03-28 07:00:00 | AAPL | Stock | 172.69 | 172.78 | 172.58 | 172.7 | 6128.0 |
| 2024-03-28 07:30:00 | AAPL | Stock | 172.65 | 172.66 | 172.4 | 172.47 | 15420.0 |
| 2024-03-28 08:00:00 | AAPL | Stock | 172.6457 | 173.37 | 172.4001 | 172.6 | 84963.0 |
| 2024-03-28 08:30:00 | AAPL | Stock | 172.64 | 172.75 | 172.2 | 172.49 | 39637.0 |
| 2024-03-28 09:00:00 | AAPL | Stock | 172.49 | 172.5399 | 171.43 | 171.69 | 197701.0 |
| 2024-03-28 09:30:00 | AAPL | Stock | 171.71 | 171.97 | 170.72 | 171.35 | 7364295.0 |
| 2024-03-28 10:00:00 | AAPL | Stock | 171.36 | 171.49 | 170.99 | 171.195 | 3871631.0 |
| 2024-03-28 10:30:00 | AAPL | Stock | 171.2 | 171.21 | 170.51 | 170.835 | 4130337.0 |
| 2024-03-28 11:00:00 | AAPL | Stock | 170.835 | 170.89 | 170.56 | 170.835 | 2371553.0 |
| 2024-03-28 11:30:00 | AAPL | Stock | 170.84 | 171.15 | 170.76 | 171.11 | 2090642.0 |
| 2024-03-28 12:00:00 | AAPL | Stock | 171.105 | 171.2 | 170.73 | 171.1692 | 2045993.0 |
| 2024-03-28 12:30:00 | AAPL | Stock | 171.17 | 171.35 | 171.06 | 171.325 | 1667980.0 |
| 2024-03-28 13:00:00 | AAPL | Stock | 171.325 | 171.37 | 170.95 | 170.965 | 1427390.0 |
| 2024-03-28 13:30:00 | AAPL | Stock | 170.96 | 171.5 | 170.89 | 171.48 | 1754503.0 |
| 2024-03-28 14:00:00 | AAPL | Stock | 171.485 | 171.8103 | 171.3 | 171.7801 | 1847348.0 |
| 2024-03-28 14:30:00 | AAPL | Stock | 171.79 | 172.07 | 171.61 | 172.065 | 1854615.0 |
| 2024-03-28 15:00:00 | AAPL | Stock | 172.0641 | 172.23 | 171.83 | 172.1399 | 2117346.0 |
| 2024-03-28 15:30:00 | AAPL | Stock | 172.14 | 172.23 | 171.25 | 171.48 | 5841195.0 |
| 2024-03-28 16:00:00 | AAPL | Stock | 171.315 | 171.48 | 171.08 | 171.24 | 13243978.0 |
| 2024-03-28 16:30:00 | AAPL | Stock | 171.2484 | 171.48 | 171.22 | 171.23 | 123864.0 |
| 2024-03-28 17:00:00 | AAPL | Stock | 171.2698 | 171.31 | 171.2 | 171.31 | 16437.0 |
| 2024-03-28 17:30:00 | AAPL | Stock | 171.31 | 171.39 | 171.31 | 171.37 | 10168.0 |
| 2024-03-28 18:00:00 | AAPL | Stock | 171.3254 | 171.48 | 171.19 | 171.26 | 11679.0 |
| 2024-03-28 18:30:00 | AAPL | Stock | 171.25 | 171.36 | 171.25 | 171.31 | 5500.0 |
| 2024-03-28 19:00:00 | AAPL | Stock | 171.28 | 171.3 | 171.24 | 171.24 | 7104.0 |
| 2024-03-28 19:30:00 | AAPL | Stock | 171.24 | 171.29 | 171.03 | 171.18 | 22230.0 |
| 2024-03-28 04:30:00 | MSFT | Stock | 420.98 | 421.02 | 420.92 | 420.99 | 786.0 |
| 2024-03-28 05:00:00 | MSFT | Stock | 421.05 | 421.05 | 420.99 | 421.0 | 691.0 |
| 2024-03-28 05:30:00 | MSFT | Stock | 420.91 | 420.95 | 420.91 | 420.95 | 300.0 |
| 2024-03-28 06:30:00 | MSFT | Stock | 421.27 | 421.39 | 421.27 | 421.39 | 322.0 |
| 2024-03-28 07:00:00 | MSFT | Stock | 421.38 | 421.51 | 421.38 | 421.51 | 829.0 |
| 2024-03-28 07:30:00 | MSFT | Stock | 421.51 | 421.61 | 421.51 | 421.61 | 768.0 |
| 2024-03-28 08:00:00 | MSFT | Stock | 421.29 | 421.75 | 421.04 | 421.691 | 10797.0 |
| 2024-03-28 08:30:00 | MSFT | Stock | 421.7 | 422.0 | 421.05 | 421.6 | 4254.0 |
| 2024-03-28 09:00:00 | MSFT | Stock | 421.9 | 421.9 | 420.25 | 420.86 | 11938.0 |
| 2024-03-28 09:30:00 | MSFT | Stock | 421.36 | 421.7499 | 419.12 | 420.9 | 1173972.0 |
| 2024-03-28 10:00:00 | MSFT | Stock | 420.99 | 421.5 | 420.43 | 420.56 | 503683.0 |
| 2024-03-28 10:30:00 | MSFT | Stock | 420.62 | 421.76 | 420.46 | 421.355 | 536684.0 |
| 2024-03-28 11:00:00 | MSFT | Stock | 421.31 | 421.59 | 420.715 | 420.93 | 474701.0 |
| 2024-03-28 11:30:00 | MSFT | Stock | 420.95 | 421.27 | 420.62 | 420.92 | 551538.0 |
| 2024-03-28 12:00:00 | MSFT | Stock | 420.94 | 420.97 | 419.82 | 420.3725 | 509992.0 |
| 2024-03-28 12:30:00 | MSFT | Stock | 420.38 | 420.39 | 419.7 | 420.16 | 399401.0 |
| 2024-03-28 13:00:00 | MSFT | Stock | 420.14 | 420.36 | 419.73 | 420.05 | 370400.0 |
| 2024-03-28 13:30:00 | MSFT | Stock | 420.05 | 420.37 | 419.9001 | 420.2 | 298922.0 |
> showing 50 of 101,723 rows — these rows as CSV