PREVIEW / stock_30min / 2021-10-26
file: by_date/stock_30min/2021/2021-10-26.parquet size: 2.3 MB rows: 113,451 symbols: 2,730
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-26 04:00:00 | AAPL | Stock | 148.87 | 149.48 | 148.65 | 149.31 | 31543.0 |
| 2021-10-26 04:30:00 | AAPL | Stock | 149.22 | 149.37 | 149.15 | 149.15 | 7442.0 |
| 2021-10-26 05:00:00 | AAPL | Stock | 149.13 | 149.15 | 148.82 | 149.08 | 15070.0 |
| 2021-10-26 05:30:00 | AAPL | Stock | 149.08 | 149.14 | 149.08 | 149.08 | 10377.0 |
| 2021-10-26 06:00:00 | AAPL | Stock | 149.12 | 149.12 | 148.85 | 148.85 | 11185.0 |
| 2021-10-26 06:30:00 | AAPL | Stock | 148.9 | 148.9 | 148.81 | 148.83 | 10381.0 |
| 2021-10-26 07:00:00 | AAPL | Stock | 148.85 | 149.08 | 148.84 | 149.07 | 38130.0 |
| 2021-10-26 07:30:00 | AAPL | Stock | 149.05 | 149.11 | 148.96 | 149.08 | 39528.0 |
| 2021-10-26 08:00:00 | AAPL | Stock | 148.889 | 149.15 | 148.269 | 149.06 | 133964.0 |
| 2021-10-26 08:30:00 | AAPL | Stock | 149.05 | 149.13 | 148.97 | 149.08 | 65632.0 |
| 2021-10-26 09:00:00 | AAPL | Stock | 149.09 | 149.35 | 149.06 | 149.32 | 145473.0 |
| 2021-10-26 09:30:00 | AAPL | Stock | 149.32 | 150.84 | 149.16 | 149.63 | 9622560.0 |
| 2021-10-26 10:00:00 | AAPL | Stock | 149.63 | 149.89 | 149.0101 | 149.28 | 4869000.0 |
| 2021-10-26 10:30:00 | AAPL | Stock | 149.28 | 149.69 | 149.1 | 149.38 | 3279687.0 |
| 2021-10-26 11:00:00 | AAPL | Stock | 149.39 | 150.0499 | 149.38 | 149.94 | 3577085.0 |
| 2021-10-26 11:30:00 | AAPL | Stock | 149.94 | 149.98 | 149.43 | 149.605 | 3922501.0 |
| 2021-10-26 12:00:00 | AAPL | Stock | 149.61 | 149.859 | 149.375 | 149.6562 | 3080040.0 |
| 2021-10-26 12:30:00 | AAPL | Stock | 149.655 | 149.745 | 149.2 | 149.4604 | 2792751.0 |
| 2021-10-26 13:00:00 | AAPL | Stock | 149.46 | 149.645 | 149.29 | 149.58 | 2269427.0 |
| 2021-10-26 13:30:00 | AAPL | Stock | 149.59 | 149.9 | 149.45 | 149.615 | 2097164.0 |
| 2021-10-26 14:00:00 | AAPL | Stock | 149.615 | 149.71 | 149.11 | 149.18 | 2174777.0 |
| 2021-10-26 14:30:00 | AAPL | Stock | 149.17 | 149.49 | 149.12 | 149.36 | 1923630.0 |
| 2021-10-26 15:00:00 | AAPL | Stock | 149.3699 | 149.6 | 149.25 | 149.332 | 2289740.0 |
| 2021-10-26 15:30:00 | AAPL | Stock | 149.34 | 149.835 | 149.25 | 149.26 | 4765289.0 |
| 2021-10-26 16:00:00 | AAPL | Stock | 149.32 | 149.56 | 149.2 | 149.5 | 6920637.0 |
| 2021-10-26 16:30:00 | AAPL | Stock | 149.46 | 149.52 | 149.2 | 149.31 | 98672.0 |
| 2021-10-26 17:00:00 | AAPL | Stock | 149.3 | 149.4529 | 149.21 | 149.4 | 40947.0 |
| 2021-10-26 17:30:00 | AAPL | Stock | 149.4 | 149.51 | 149.3 | 149.33 | 26008.0 |
| 2021-10-26 18:00:00 | AAPL | Stock | 149.33 | 149.48 | 149.3 | 149.48 | 21135.0 |
| 2021-10-26 18:30:00 | AAPL | Stock | 149.48 | 149.48 | 149.35 | 149.38 | 12608.0 |
| 2021-10-26 19:00:00 | AAPL | Stock | 149.4 | 149.48 | 149.37 | 149.41 | 11208.0 |
| 2021-10-26 19:30:00 | AAPL | Stock | 149.42 | 149.5 | 149.34 | 149.34 | 37891.0 |
| 2021-10-26 04:00:00 | MSFT | Stock | 309.6 | 309.66 | 309.59 | 309.6 | 795.0 |
| 2021-10-26 04:30:00 | MSFT | Stock | 309.69 | 309.69 | 309.59 | 309.66 | 845.0 |
| 2021-10-26 05:00:00 | MSFT | Stock | 309.58 | 309.58 | 309.02 | 309.39 | 2011.0 |
| 2021-10-26 05:30:00 | MSFT | Stock | 309.75 | 309.9 | 309.75 | 309.9 | 509.0 |
| 2021-10-26 06:00:00 | MSFT | Stock | 310.08 | 310.2 | 309.8 | 309.8 | 5160.0 |
| 2021-10-26 06:30:00 | MSFT | Stock | 310.05 | 310.05 | 309.85 | 309.85 | 1056.0 |
| 2021-10-26 07:00:00 | MSFT | Stock | 309.97 | 310.3 | 309.97 | 310.3 | 7160.0 |
| 2021-10-26 07:30:00 | MSFT | Stock | 310.3 | 310.3 | 309.85 | 309.85 | 14901.0 |
| 2021-10-26 08:00:00 | MSFT | Stock | 310.1 | 310.36 | 309.8 | 310.0 | 35611.0 |
| 2021-10-26 08:30:00 | MSFT | Stock | 310.0 | 310.0 | 309.35 | 309.79 | 16317.0 |
| 2021-10-26 09:00:00 | MSFT | Stock | 309.79 | 311.2 | 309.78 | 310.98 | 44998.0 |
| 2021-10-26 09:30:00 | MSFT | Stock | 310.81 | 311.1 | 308.5967 | 308.885 | 2457479.0 |
| 2021-10-26 10:00:00 | MSFT | Stock | 308.885 | 310.09 | 308.735 | 309.9 | 962703.0 |
| 2021-10-26 10:30:00 | MSFT | Stock | 309.91 | 310.62 | 309.76 | 310.46 | 1151087.0 |
| 2021-10-26 11:00:00 | MSFT | Stock | 310.47 | 312.395 | 310.372 | 312.13 | 1347604.0 |
| 2021-10-26 11:30:00 | MSFT | Stock | 312.13 | 312.18 | 310.7101 | 310.965 | 1064258.0 |
| 2021-10-26 12:00:00 | MSFT | Stock | 310.9525 | 311.06 | 310.21 | 310.364 | 966883.0 |
| 2021-10-26 12:30:00 | MSFT | Stock | 310.42 | 310.72 | 309.6941 | 310.35 | 817885.0 |
> showing 50 of 113,451 rows — these rows as CSV