PREVIEW / stock_30min / 2023-08-28
file: by_date/stock_30min/2023/2023-08-28.parquet size: 2.0 MB rows: 96,061 symbols: 1,443
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-08-28 04:00:00 | AAPL | Stock | 178.8 | 179.02 | 178.77 | 179.0 | 3897.0 |
| 2023-08-28 04:30:00 | AAPL | Stock | 179.02 | 179.08 | 178.84 | 178.88 | 2435.0 |
| 2023-08-28 05:00:00 | AAPL | Stock | 178.9 | 178.9 | 178.49 | 178.59 | 9585.0 |
| 2023-08-28 05:30:00 | AAPL | Stock | 178.59 | 178.69 | 178.52 | 178.52 | 2720.0 |
| 2023-08-28 06:00:00 | AAPL | Stock | 178.53 | 178.53 | 178.46 | 178.46 | 1178.0 |
| 2023-08-28 06:30:00 | AAPL | Stock | 178.53 | 178.66 | 178.52 | 178.58 | 1739.0 |
| 2023-08-28 07:00:00 | AAPL | Stock | 178.57 | 178.87 | 178.57 | 178.82 | 11358.0 |
| 2023-08-28 07:30:00 | AAPL | Stock | 178.88 | 179.08 | 178.85 | 179.08 | 6689.0 |
| 2023-08-28 08:00:00 | AAPL | Stock | 178.5684 | 179.49 | 178.5684 | 179.4 | 69852.0 |
| 2023-08-28 08:30:00 | AAPL | Stock | 179.44 | 179.8 | 179.38 | 179.77 | 83410.0 |
| 2023-08-28 09:00:00 | AAPL | Stock | 179.78 | 180.28 | 179.61 | 180.08 | 100377.0 |
| 2023-08-28 09:30:00 | AAPL | Stock | 180.09 | 180.2 | 178.92 | 179.29 | 4253199.0 |
| 2023-08-28 10:00:00 | AAPL | Stock | 179.29 | 179.93 | 178.79 | 179.79 | 2968027.0 |
| 2023-08-28 10:30:00 | AAPL | Stock | 179.8 | 179.8 | 178.68 | 179.015 | 2379334.0 |
| 2023-08-28 11:00:00 | AAPL | Stock | 179.01 | 179.13 | 178.68 | 178.7782 | 1554126.0 |
| 2023-08-28 11:30:00 | AAPL | Stock | 178.77 | 179.07 | 178.545 | 178.91 | 1733358.0 |
| 2023-08-28 12:00:00 | AAPL | Stock | 178.9 | 179.115 | 178.7201 | 178.81 | 1144000.0 |
| 2023-08-28 12:30:00 | AAPL | Stock | 178.82 | 179.61 | 178.75 | 179.6 | 1339884.0 |
| 2023-08-28 13:00:00 | AAPL | Stock | 179.61 | 180.1399 | 179.59 | 179.955 | 1962142.0 |
| 2023-08-28 13:30:00 | AAPL | Stock | 179.96 | 180.0899 | 179.1384 | 179.34 | 1810210.0 |
| 2023-08-28 14:00:00 | AAPL | Stock | 179.34 | 179.59 | 179.24 | 179.5394 | 1247023.0 |
| 2023-08-28 14:30:00 | AAPL | Stock | 179.55 | 179.85 | 179.35 | 179.82 | 1329117.0 |
| 2023-08-28 15:00:00 | AAPL | Stock | 179.82 | 180.01 | 179.73 | 179.905 | 1649083.0 |
| 2023-08-28 15:30:00 | AAPL | Stock | 179.89 | 180.59 | 179.805 | 180.21 | 4630890.0 |
| 2023-08-28 16:00:00 | AAPL | Stock | 180.19 | 180.24 | 179.96 | 180.07 | 5536155.0 |
| 2023-08-28 16:30:00 | AAPL | Stock | 180.05 | 180.1099 | 180.02 | 180.08 | 13229.0 |
| 2023-08-28 17:00:00 | AAPL | Stock | 180.1 | 180.19 | 180.08 | 180.16 | 21104.0 |
| 2023-08-28 17:30:00 | AAPL | Stock | 180.17 | 180.25 | 180.1126 | 180.25 | 17088.0 |
| 2023-08-28 18:00:00 | AAPL | Stock | 180.23 | 180.4 | 180.23 | 180.32 | 15261.0 |
| 2023-08-28 18:30:00 | AAPL | Stock | 180.33 | 180.38 | 180.26 | 180.38 | 3593.0 |
| 2023-08-28 19:00:00 | AAPL | Stock | 180.33 | 180.47 | 180.33 | 180.47 | 6335.0 |
| 2023-08-28 19:30:00 | AAPL | Stock | 180.45 | 180.46 | 180.25 | 180.25 | 25529.0 |
| 2023-08-28 04:00:00 | MSFT | Stock | 323.15 | 323.77 | 322.74 | 323.77 | 4962.0 |
| 2023-08-28 04:30:00 | MSFT | Stock | 323.88 | 323.88 | 323.65 | 323.72 | 1308.0 |
| 2023-08-28 05:00:00 | MSFT | Stock | 323.6 | 323.6 | 322.82 | 322.82 | 2494.0 |
| 2023-08-28 05:30:00 | MSFT | Stock | 323.53 | 323.53 | 323.51 | 323.51 | 513.0 |
| 2023-08-28 06:00:00 | MSFT | Stock | 323.01 | 323.01 | 323.01 | 323.01 | 187.0 |
| 2023-08-28 06:30:00 | MSFT | Stock | 323.5 | 323.5 | 323.5 | 323.5 | 342.0 |
| 2023-08-28 07:00:00 | MSFT | Stock | 323.55 | 323.75 | 323.5 | 323.75 | 1072.0 |
| 2023-08-28 07:30:00 | MSFT | Stock | 323.77 | 323.84 | 323.77 | 323.84 | 500.0 |
| 2023-08-28 08:00:00 | MSFT | Stock | 323.42 | 324.85 | 322.173 | 324.85 | 16988.0 |
| 2023-08-28 08:30:00 | MSFT | Stock | 324.834 | 325.25 | 324.6 | 325.25 | 14426.0 |
| 2023-08-28 09:00:00 | MSFT | Stock | 325.25 | 325.89 | 324.8301 | 325.52 | 9363.0 |
| 2023-08-28 09:30:00 | MSFT | Stock | 325.66 | 326.15 | 322.3642 | 323.35 | 1324051.0 |
| 2023-08-28 10:00:00 | MSFT | Stock | 323.355 | 324.56 | 322.92 | 324.32 | 674265.0 |
| 2023-08-28 10:30:00 | MSFT | Stock | 324.33 | 324.67 | 322.11 | 323.03 | 716225.0 |
| 2023-08-28 11:00:00 | MSFT | Stock | 323.0354 | 323.15 | 322.3 | 322.57 | 433220.0 |
| 2023-08-28 11:30:00 | MSFT | Stock | 322.53 | 323.5 | 322.04 | 322.84 | 506786.0 |
| 2023-08-28 12:00:00 | MSFT | Stock | 322.84 | 323.15 | 322.42 | 322.64 | 373338.0 |
| 2023-08-28 12:30:00 | MSFT | Stock | 322.65 | 324.12 | 322.39 | 324.055 | 396377.0 |
> showing 50 of 96,061 rows — these rows as CSV