PREVIEW / stock_30min / 2021-11-22
file: by_date/stock_30min/2021/2021-11-22.parquet size: 2.3 MB rows: 115,736 symbols: 2,712
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-11-22 04:00:00 | AAPL | Stock | 161.15 | 161.2 | 160.8 | 161.19 | 35992.0 |
| 2021-11-22 04:30:00 | AAPL | Stock | 161.19 | 161.19 | 161.1 | 161.15 | 16621.0 |
| 2021-11-22 05:00:00 | AAPL | Stock | 161.19 | 161.2 | 161.12 | 161.13 | 15306.0 |
| 2021-11-22 05:30:00 | AAPL | Stock | 161.13 | 161.17 | 160.9 | 160.97 | 24302.0 |
| 2021-11-22 06:00:00 | AAPL | Stock | 161.0 | 161.09 | 160.98 | 161.04 | 10816.0 |
| 2021-11-22 06:30:00 | AAPL | Stock | 161.01 | 161.11 | 161.01 | 161.11 | 20359.0 |
| 2021-11-22 07:00:00 | AAPL | Stock | 161.07 | 161.45 | 161.06 | 161.32 | 96959.0 |
| 2021-11-22 07:30:00 | AAPL | Stock | 161.3 | 161.67 | 161.25 | 161.52 | 83240.0 |
| 2021-11-22 08:00:00 | AAPL | Stock | 161.47 | 161.67 | 161.08 | 161.39 | 296589.0 |
| 2021-11-22 08:30:00 | AAPL | Stock | 161.39 | 161.75 | 161.37 | 161.72 | 191324.0 |
| 2021-11-22 09:00:00 | AAPL | Stock | 161.69 | 161.85 | 161.46 | 161.65 | 429276.0 |
| 2021-11-22 09:30:00 | AAPL | Stock | 161.68 | 164.78 | 161.63 | 164.69 | 16957024.0 |
| 2021-11-22 10:00:00 | AAPL | Stock | 164.67 | 165.7 | 164.64 | 165.3025 | 14950354.0 |
| 2021-11-22 10:30:00 | AAPL | Stock | 165.31 | 165.59 | 164.52 | 164.7425 | 8711734.0 |
| 2021-11-22 11:00:00 | AAPL | Stock | 164.7 | 164.89 | 163.97 | 164.435 | 7326859.0 |
| 2021-11-22 11:30:00 | AAPL | Stock | 164.4221 | 165.22 | 163.04 | 163.54 | 8339943.0 |
| 2021-11-22 12:00:00 | AAPL | Stock | 163.5201 | 164.0 | 163.04 | 163.385 | 6139007.0 |
| 2021-11-22 12:30:00 | AAPL | Stock | 163.385 | 164.38 | 163.33 | 163.945 | 4849933.0 |
| 2021-11-22 13:00:00 | AAPL | Stock | 163.945 | 163.98 | 163.33 | 163.3646 | 3295547.0 |
| 2021-11-22 13:30:00 | AAPL | Stock | 163.37 | 163.84 | 163.34 | 163.68 | 2626334.0 |
| 2021-11-22 14:00:00 | AAPL | Stock | 163.69 | 164.28 | 163.6 | 164.005 | 3260810.0 |
| 2021-11-22 14:30:00 | AAPL | Stock | 164.01 | 164.2 | 163.68 | 163.7989 | 2686024.0 |
| 2021-11-22 15:00:00 | AAPL | Stock | 163.8 | 164.0 | 163.455 | 163.5614 | 3124867.0 |
| 2021-11-22 15:30:00 | AAPL | Stock | 163.565 | 163.565 | 161.0 | 161.08 | 11146953.0 |
| 2021-11-22 16:00:00 | AAPL | Stock | 161.08 | 161.3 | 160.52 | 161.1 | 6475141.0 |
| 2021-11-22 16:30:00 | AAPL | Stock | 161.1 | 161.3 | 160.92 | 161.25 | 103877.0 |
| 2021-11-22 17:00:00 | AAPL | Stock | 161.3 | 161.45 | 161.02 | 161.2 | 87552.0 |
| 2021-11-22 17:30:00 | AAPL | Stock | 161.2 | 161.25 | 161.06 | 161.11 | 22566.0 |
| 2021-11-22 18:00:00 | AAPL | Stock | 161.11 | 161.5 | 161.1 | 161.38 | 34000.0 |
| 2021-11-22 18:30:00 | AAPL | Stock | 161.41 | 161.45 | 161.21 | 161.38 | 34811.0 |
| 2021-11-22 19:00:00 | AAPL | Stock | 161.2501 | 161.35 | 161.05 | 161.35 | 22314.0 |
| 2021-11-22 19:30:00 | AAPL | Stock | 161.35 | 161.5 | 161.33 | 161.5 | 33296.0 |
| 2021-11-22 04:00:00 | MSFT | Stock | 344.1 | 344.5 | 344.02 | 344.03 | 2982.0 |
| 2021-11-22 04:30:00 | MSFT | Stock | 343.91 | 344.61 | 343.6 | 344.61 | 4569.0 |
| 2021-11-22 05:00:00 | MSFT | Stock | 344.69 | 344.93 | 344.45 | 344.45 | 5663.0 |
| 2021-11-22 05:30:00 | MSFT | Stock | 344.7 | 344.7 | 344.0 | 344.0 | 1366.0 |
| 2021-11-22 06:00:00 | MSFT | Stock | 344.39 | 344.43 | 344.05 | 344.43 | 1562.0 |
| 2021-11-22 06:30:00 | MSFT | Stock | 344.11 | 344.53 | 344.02 | 344.53 | 4580.0 |
| 2021-11-22 07:00:00 | MSFT | Stock | 344.59 | 344.59 | 343.85 | 344.01 | 12469.0 |
| 2021-11-22 07:30:00 | MSFT | Stock | 343.86 | 344.33 | 343.86 | 344.08 | 7441.0 |
| 2021-11-22 08:00:00 | MSFT | Stock | 344.3272 | 344.6986 | 343.85 | 343.88 | 32626.0 |
| 2021-11-22 08:30:00 | MSFT | Stock | 343.8899 | 344.0 | 343.75 | 343.9175 | 11058.0 |
| 2021-11-22 09:00:00 | MSFT | Stock | 343.97 | 344.7 | 343.41 | 344.7 | 48573.0 |
| 2021-11-22 09:30:00 | MSFT | Stock | 344.62 | 348.38 | 344.06 | 346.91 | 2961499.0 |
| 2021-11-22 10:00:00 | MSFT | Stock | 346.96 | 349.67 | 346.96 | 349.23 | 2116038.0 |
| 2021-11-22 10:30:00 | MSFT | Stock | 349.2 | 349.21 | 347.27 | 347.68 | 1558808.0 |
| 2021-11-22 11:00:00 | MSFT | Stock | 347.7 | 348.085 | 344.96 | 345.28 | 1787127.0 |
| 2021-11-22 11:30:00 | MSFT | Stock | 345.27 | 345.85 | 342.86 | 343.64 | 1805295.0 |
| 2021-11-22 12:00:00 | MSFT | Stock | 343.58 | 343.89 | 342.06 | 342.42 | 1379092.0 |
| 2021-11-22 12:30:00 | MSFT | Stock | 342.41 | 343.36 | 341.59 | 342.22 | 1072399.0 |
> showing 50 of 115,736 rows — these rows as CSV