PREVIEW / stock_30min / 2022-07-26
file: by_date/stock_30min/2022/2022-07-26.parquet size: 2.0 MB rows: 102,053 symbols: 2,257
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-26 04:00:00 | AAPL | Stock | 153.24 | 153.24 | 152.08 | 152.49 | 16172.0 |
| 2022-07-26 04:30:00 | AAPL | Stock | 152.54 | 152.6 | 152.44 | 152.55 | 6549.0 |
| 2022-07-26 05:00:00 | AAPL | Stock | 152.65 | 152.79 | 152.6 | 152.67 | 3739.0 |
| 2022-07-26 05:30:00 | AAPL | Stock | 152.51 | 152.85 | 152.5 | 152.69 | 7472.0 |
| 2022-07-26 06:00:00 | AAPL | Stock | 152.83 | 152.85 | 152.25 | 152.39 | 15715.0 |
| 2022-07-26 06:30:00 | AAPL | Stock | 152.39 | 152.42 | 152.13 | 152.4 | 18195.0 |
| 2022-07-26 07:00:00 | AAPL | Stock | 152.35 | 152.42 | 152.0 | 152.26 | 49087.0 |
| 2022-07-26 07:30:00 | AAPL | Stock | 152.29 | 152.47 | 152.11 | 152.11 | 21850.0 |
| 2022-07-26 08:00:00 | AAPL | Stock | 152.31 | 152.568 | 151.5 | 152.1119 | 162882.0 |
| 2022-07-26 08:30:00 | AAPL | Stock | 152.13 | 152.3 | 151.75 | 151.89 | 170478.0 |
| 2022-07-26 09:00:00 | AAPL | Stock | 151.96 | 152.29 | 151.7133 | 152.26 | 257725.0 |
| 2022-07-26 09:30:00 | AAPL | Stock | 152.26 | 153.085 | 151.54 | 152.18 | 6664107.0 |
| 2022-07-26 10:00:00 | AAPL | Stock | 152.18 | 152.47 | 151.6037 | 151.7399 | 3661187.0 |
| 2022-07-26 10:30:00 | AAPL | Stock | 151.7348 | 151.7348 | 151.1884 | 151.605 | 2634942.0 |
| 2022-07-26 11:00:00 | AAPL | Stock | 151.61 | 151.68 | 151.2 | 151.27 | 1837646.0 |
| 2022-07-26 11:30:00 | AAPL | Stock | 151.27 | 151.36 | 150.85 | 150.99 | 2666575.0 |
| 2022-07-26 12:00:00 | AAPL | Stock | 151.0 | 151.33 | 150.8 | 151.3 | 2127589.0 |
| 2022-07-26 12:30:00 | AAPL | Stock | 151.2981 | 151.69 | 151.27 | 151.63 | 1850211.0 |
| 2022-07-26 13:00:00 | AAPL | Stock | 151.63 | 152.17 | 151.55 | 152.1 | 2504104.0 |
| 2022-07-26 13:30:00 | AAPL | Stock | 152.1 | 152.18 | 151.81 | 151.855 | 1598313.0 |
| 2022-07-26 14:00:00 | AAPL | Stock | 151.87 | 152.49 | 151.65 | 151.6689 | 2981291.0 |
| 2022-07-26 14:30:00 | AAPL | Stock | 151.66 | 151.68 | 151.3424 | 151.59 | 2411912.0 |
| 2022-07-26 15:00:00 | AAPL | Stock | 151.585 | 151.5901 | 151.1499 | 151.52 | 2834965.0 |
| 2022-07-26 15:30:00 | AAPL | Stock | 151.52 | 151.75 | 151.25 | 151.56 | 5871791.0 |
| 2022-07-26 16:00:00 | AAPL | Stock | 151.56 | 152.37 | 151.33 | 151.95 | 6244139.0 |
| 2022-07-26 16:30:00 | AAPL | Stock | 151.93 | 152.48 | 151.6 | 152.31 | 76159.0 |
| 2022-07-26 17:00:00 | AAPL | Stock | 152.44 | 152.58 | 152.2 | 152.23 | 61424.0 |
| 2022-07-26 17:30:00 | AAPL | Stock | 152.29 | 152.46 | 152.26 | 152.37 | 18932.0 |
| 2022-07-26 18:00:00 | AAPL | Stock | 152.44 | 152.82 | 152.3 | 152.49 | 293907.0 |
| 2022-07-26 18:30:00 | AAPL | Stock | 152.48 | 152.6 | 152.08 | 152.32 | 87274.0 |
| 2022-07-26 19:00:00 | AAPL | Stock | 152.3 | 152.65 | 152.3 | 152.57 | 36418.0 |
| 2022-07-26 19:30:00 | AAPL | Stock | 152.65 | 152.83 | 152.56 | 152.83 | 43701.0 |
| 2022-07-26 04:00:00 | MSFT | Stock | 259.17 | 259.17 | 258.57 | 258.57 | 1217.0 |
| 2022-07-26 04:30:00 | MSFT | Stock | 258.88 | 258.98 | 258.88 | 258.98 | 1735.0 |
| 2022-07-26 05:00:00 | MSFT | Stock | 259.05 | 259.13 | 258.99 | 258.99 | 808.0 |
| 2022-07-26 05:30:00 | MSFT | Stock | 258.7 | 258.88 | 258.7 | 258.88 | 354.0 |
| 2022-07-26 06:00:00 | MSFT | Stock | 259.15 | 259.15 | 258.0 | 258.0 | 1892.0 |
| 2022-07-26 06:30:00 | MSFT | Stock | 258.02 | 258.48 | 258.02 | 258.48 | 1386.0 |
| 2022-07-26 07:00:00 | MSFT | Stock | 258.72 | 258.75 | 258.02 | 258.34 | 4489.0 |
| 2022-07-26 07:30:00 | MSFT | Stock | 258.43 | 258.89 | 258.38 | 258.5 | 5577.0 |
| 2022-07-26 08:00:00 | MSFT | Stock | 258.5 | 258.8789 | 258.15 | 258.67 | 7561.0 |
| 2022-07-26 08:30:00 | MSFT | Stock | 258.58 | 258.99 | 258.15 | 258.5 | 24467.0 |
| 2022-07-26 09:00:00 | MSFT | Stock | 258.65 | 260.88 | 258.15 | 260.24 | 54073.0 |
| 2022-07-26 09:30:00 | MSFT | Stock | 259.98 | 259.98 | 253.64 | 255.66 | 2934271.0 |
| 2022-07-26 10:00:00 | MSFT | Stock | 255.6 | 255.96 | 253.7 | 254.02 | 1068971.0 |
| 2022-07-26 10:30:00 | MSFT | Stock | 254.03 | 254.03 | 252.87 | 253.63 | 1425959.0 |
| 2022-07-26 11:00:00 | MSFT | Stock | 253.64 | 253.8238 | 252.22 | 252.53 | 1026889.0 |
| 2022-07-26 11:30:00 | MSFT | Stock | 252.52 | 252.61 | 250.65 | 251.03 | 1520296.0 |
| 2022-07-26 12:00:00 | MSFT | Stock | 251.02 | 251.52 | 249.9 | 250.4629 | 1775592.0 |
| 2022-07-26 12:30:00 | MSFT | Stock | 250.4601 | 250.8 | 249.93 | 250.2617 | 1152061.0 |
> showing 50 of 102,053 rows — these rows as CSV