PREVIEW / stock_30min / 2022-03-29
file: by_date/stock_30min/2022/2022-03-29.parquet size: 2.3 MB rows: 112,521 symbols: 2,546
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-03-29 04:00:00 | AAPL | Stock | 175.79 | 176.09 | 175.76 | 175.76 | 20139.0 |
| 2022-03-29 04:30:00 | AAPL | Stock | 175.76 | 176.0 | 175.72 | 175.78 | 7104.0 |
| 2022-03-29 05:00:00 | AAPL | Stock | 175.8 | 176.3 | 175.62 | 176.1 | 26820.0 |
| 2022-03-29 05:30:00 | AAPL | Stock | 176.16 | 176.4 | 175.94 | 175.97 | 22536.0 |
| 2022-03-29 06:00:00 | AAPL | Stock | 175.97 | 176.05 | 175.6 | 175.89 | 7985.0 |
| 2022-03-29 06:30:00 | AAPL | Stock | 175.9 | 176.0 | 175.8 | 175.9 | 5049.0 |
| 2022-03-29 07:00:00 | AAPL | Stock | 175.9 | 176.21 | 175.8 | 175.8 | 58721.0 |
| 2022-03-29 07:30:00 | AAPL | Stock | 175.84 | 176.56 | 175.63 | 176.36 | 115100.0 |
| 2022-03-29 08:00:00 | AAPL | Stock | 176.1501 | 176.95 | 174.49 | 176.93 | 399949.0 |
| 2022-03-29 08:30:00 | AAPL | Stock | 176.9 | 176.9 | 176.39 | 176.87 | 191973.0 |
| 2022-03-29 09:00:00 | AAPL | Stock | 176.85 | 176.92 | 176.35 | 176.75 | 289958.0 |
| 2022-03-29 09:30:00 | AAPL | Stock | 176.69 | 178.13 | 176.34 | 177.585 | 12560634.0 |
| 2022-03-29 10:00:00 | AAPL | Stock | 177.6 | 178.0 | 176.6 | 177.3811 | 7454441.0 |
| 2022-03-29 10:30:00 | AAPL | Stock | 177.38 | 177.443 | 176.35 | 177.2 | 5491699.0 |
| 2022-03-29 11:00:00 | AAPL | Stock | 177.2 | 177.85 | 176.995 | 177.838 | 4407412.0 |
| 2022-03-29 11:30:00 | AAPL | Stock | 177.83 | 177.89 | 177.41 | 177.48 | 3120737.0 |
| 2022-03-29 12:00:00 | AAPL | Stock | 177.488 | 177.51 | 177.09 | 177.165 | 2963759.0 |
| 2022-03-29 12:30:00 | AAPL | Stock | 177.16 | 177.39 | 176.72 | 177.185 | 3314176.0 |
| 2022-03-29 13:00:00 | AAPL | Stock | 177.185 | 177.23 | 176.81 | 177.095 | 2828791.0 |
| 2022-03-29 13:30:00 | AAPL | Stock | 177.1 | 178.095 | 177.02 | 178.085 | 4018088.0 |
| 2022-03-29 14:00:00 | AAPL | Stock | 178.08 | 178.08 | 177.48 | 177.85 | 3467359.0 |
| 2022-03-29 14:30:00 | AAPL | Stock | 177.84 | 178.39 | 177.76 | 178.34 | 4504653.0 |
| 2022-03-29 15:00:00 | AAPL | Stock | 178.3401 | 178.96 | 178.28 | 178.78 | 6481359.0 |
| 2022-03-29 15:30:00 | AAPL | Stock | 178.785 | 179.01 | 178.41 | 179.0 | 9636732.0 |
| 2022-03-29 16:00:00 | AAPL | Stock | 178.97 | 178.99 | 178.7 | 178.73 | 12138540.0 |
| 2022-03-29 16:30:00 | AAPL | Stock | 178.7 | 178.96 | 178.53 | 178.68 | 136360.0 |
| 2022-03-29 17:00:00 | AAPL | Stock | 178.68 | 178.77 | 178.65 | 178.77 | 26363.0 |
| 2022-03-29 17:30:00 | AAPL | Stock | 178.75 | 178.78 | 178.73 | 178.75 | 9738.0 |
| 2022-03-29 18:00:00 | AAPL | Stock | 178.76 | 178.76 | 178.58 | 178.74 | 17596.0 |
| 2022-03-29 18:30:00 | AAPL | Stock | 178.64 | 178.71 | 178.5 | 178.63 | 17566.0 |
| 2022-03-29 19:00:00 | AAPL | Stock | 178.63 | 178.72 | 178.56 | 178.6 | 14411.0 |
| 2022-03-29 19:30:00 | AAPL | Stock | 178.56 | 178.75 | 178.56 | 178.75 | 34001.0 |
| 2022-03-29 04:00:00 | MSFT | Stock | 311.25 | 311.8 | 311.25 | 311.5 | 3979.0 |
| 2022-03-29 04:30:00 | MSFT | Stock | 311.6 | 311.6 | 311.6 | 311.6 | 200.0 |
| 2022-03-29 05:00:00 | MSFT | Stock | 311.81 | 312.54 | 311.76 | 312.54 | 1973.0 |
| 2022-03-29 05:30:00 | MSFT | Stock | 312.52 | 312.52 | 312.01 | 312.05 | 2677.0 |
| 2022-03-29 06:00:00 | MSFT | Stock | 312.05 | 312.05 | 311.5 | 311.96 | 1889.0 |
| 2022-03-29 06:30:00 | MSFT | Stock | 311.81 | 312.35 | 311.81 | 312.0 | 1173.0 |
| 2022-03-29 07:00:00 | MSFT | Stock | 312.19 | 312.19 | 311.52 | 311.6 | 9363.0 |
| 2022-03-29 07:30:00 | MSFT | Stock | 311.5 | 312.7 | 311.1 | 311.95 | 17308.0 |
| 2022-03-29 08:00:00 | MSFT | Stock | 311.8808 | 314.5 | 309.42 | 313.9 | 61604.0 |
| 2022-03-29 08:30:00 | MSFT | Stock | 313.8024 | 313.97 | 313.01 | 313.57 | 42835.0 |
| 2022-03-29 09:00:00 | MSFT | Stock | 313.45 | 314.22 | 313.21 | 313.65 | 47947.0 |
| 2022-03-29 09:30:00 | MSFT | Stock | 313.68 | 314.4 | 311.31 | 312.725 | 3060700.0 |
| 2022-03-29 10:00:00 | MSFT | Stock | 312.725 | 313.23 | 309.77 | 310.6628 | 1768437.0 |
| 2022-03-29 10:30:00 | MSFT | Stock | 310.62 | 310.96 | 309.05 | 310.89 | 1459314.0 |
| 2022-03-29 11:00:00 | MSFT | Stock | 310.9 | 312.44 | 310.82 | 312.0965 | 1341141.0 |
| 2022-03-29 11:30:00 | MSFT | Stock | 312.1 | 312.65 | 311.84 | 312.155 | 995601.0 |
| 2022-03-29 12:00:00 | MSFT | Stock | 312.17 | 312.62 | 311.53 | 311.9 | 774012.0 |
| 2022-03-29 12:30:00 | MSFT | Stock | 311.89 | 312.55 | 311.21 | 312.405 | 694434.0 |
> showing 50 of 112,521 rows — these rows as CSV