PREVIEW / stock_30min / 2021-11-30
file: by_date/stock_30min/2021/2021-11-30.parquet size: 2.3 MB rows: 115,957 symbols: 2,727
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-30 04:00:00 | AAPL | Stock | 159.24 | 159.58 | 158.67 | 158.79 | 48528.0 |
| 2021-11-30 04:30:00 | AAPL | Stock | 158.83 | 159.1 | 158.56 | 159.1 | 20546.0 |
| 2021-11-30 05:00:00 | AAPL | Stock | 159.1 | 159.11 | 158.74 | 158.89 | 10882.0 |
| 2021-11-30 05:30:00 | AAPL | Stock | 158.92 | 159.19 | 158.5 | 159.17 | 23256.0 |
| 2021-11-30 06:00:00 | AAPL | Stock | 159.23 | 159.23 | 158.97 | 159.12 | 26929.0 |
| 2021-11-30 06:30:00 | AAPL | Stock | 159.12 | 159.39 | 158.96 | 158.96 | 24267.0 |
| 2021-11-30 07:00:00 | AAPL | Stock | 159.0 | 159.39 | 159.0 | 159.21 | 93446.0 |
| 2021-11-30 07:30:00 | AAPL | Stock | 159.23 | 159.24 | 158.97 | 159.11 | 54589.0 |
| 2021-11-30 08:00:00 | AAPL | Stock | 159.1999 | 159.84 | 158.75 | 158.93 | 306361.0 |
| 2021-11-30 08:30:00 | AAPL | Stock | 158.92 | 159.66 | 158.75 | 159.59 | 201651.0 |
| 2021-11-30 09:00:00 | AAPL | Stock | 159.56 | 160.0 | 159.33 | 159.97 | 215652.0 |
| 2021-11-30 09:30:00 | AAPL | Stock | 159.99 | 162.3 | 159.92 | 162.09 | 11675470.0 |
| 2021-11-30 10:00:00 | AAPL | Stock | 162.1 | 164.22 | 162.0089 | 164.06 | 14048329.0 |
| 2021-11-30 10:30:00 | AAPL | Stock | 164.06 | 164.58 | 162.15 | 162.15 | 14092007.0 |
| 2021-11-30 11:00:00 | AAPL | Stock | 162.17 | 163.44 | 161.84 | 163.1 | 11254024.0 |
| 2021-11-30 11:30:00 | AAPL | Stock | 163.09 | 163.23 | 162.02 | 162.53 | 8479259.0 |
| 2021-11-30 12:00:00 | AAPL | Stock | 162.53 | 163.68 | 162.035 | 163.45 | 7942410.0 |
| 2021-11-30 12:30:00 | AAPL | Stock | 163.45 | 164.26 | 163.065 | 163.575 | 6609018.0 |
| 2021-11-30 13:00:00 | AAPL | Stock | 163.59 | 163.79 | 163.13 | 163.7589 | 4500327.0 |
| 2021-11-30 13:30:00 | AAPL | Stock | 163.76 | 164.37 | 163.66 | 164.34 | 5886070.0 |
| 2021-11-30 14:00:00 | AAPL | Stock | 164.34 | 164.92 | 163.93 | 164.5 | 7028131.0 |
| 2021-11-30 14:30:00 | AAPL | Stock | 164.5 | 164.86 | 164.03 | 164.235 | 6061738.0 |
| 2021-11-30 15:00:00 | AAPL | Stock | 164.22 | 164.62 | 163.43 | 163.51 | 7615563.0 |
| 2021-11-30 15:30:00 | AAPL | Stock | 163.5 | 165.52 | 163.05 | 165.43 | 17327800.0 |
| 2021-11-30 16:00:00 | AAPL | Stock | 165.43 | 166.4 | 165.26 | 166.01 | 25049147.0 |
| 2021-11-30 16:30:00 | AAPL | Stock | 166.04 | 166.1 | 165.3 | 165.9 | 153185.0 |
| 2021-11-30 17:00:00 | AAPL | Stock | 165.88 | 166.59 | 165.77 | 166.36 | 187124.0 |
| 2021-11-30 17:30:00 | AAPL | Stock | 166.35 | 166.64 | 166.26 | 166.42 | 175253.0 |
| 2021-11-30 18:00:00 | AAPL | Stock | 166.48 | 166.64 | 166.42 | 166.45 | 83865.0 |
| 2021-11-30 18:30:00 | AAPL | Stock | 166.44 | 166.56 | 166.23 | 166.41 | 46805.0 |
| 2021-11-30 19:00:00 | AAPL | Stock | 166.41 | 166.5 | 166.05 | 166.05 | 73795.0 |
| 2021-11-30 19:30:00 | AAPL | Stock | 166.0899 | 166.64 | 165.9 | 166.35 | 93934.0 |
| 2021-11-30 04:00:00 | MSFT | Stock | 335.66 | 335.96 | 335.19 | 335.4 | 7843.0 |
| 2021-11-30 04:30:00 | MSFT | Stock | 335.2 | 335.7 | 334.71 | 335.7 | 5213.0 |
| 2021-11-30 05:00:00 | MSFT | Stock | 335.87 | 335.89 | 335.57 | 335.89 | 1273.0 |
| 2021-11-30 05:30:00 | MSFT | Stock | 335.9 | 335.95 | 335.47 | 335.83 | 1903.0 |
| 2021-11-30 06:00:00 | MSFT | Stock | 335.6 | 335.98 | 335.41 | 335.98 | 404.0 |
| 2021-11-30 06:30:00 | MSFT | Stock | 336.24 | 336.51 | 335.19 | 335.19 | 4674.0 |
| 2021-11-30 07:00:00 | MSFT | Stock | 335.4 | 336.0 | 335.3 | 335.69 | 6364.0 |
| 2021-11-30 07:30:00 | MSFT | Stock | 335.55 | 335.56 | 335.06 | 335.35 | 10248.0 |
| 2021-11-30 08:00:00 | MSFT | Stock | 335.3499 | 336.0 | 335.1 | 335.27 | 21688.0 |
| 2021-11-30 08:30:00 | MSFT | Stock | 335.23 | 336.65 | 334.79 | 336.65 | 18137.0 |
| 2021-11-30 09:00:00 | MSFT | Stock | 336.5 | 336.63 | 335.08 | 335.38 | 30294.0 |
| 2021-11-30 09:30:00 | MSFT | Stock | 335.58 | 336.19 | 334.12 | 335.98 | 2169296.0 |
| 2021-11-30 10:00:00 | MSFT | Stock | 335.95 | 337.75 | 335.75 | 337.2 | 1559217.0 |
| 2021-11-30 10:30:00 | MSFT | Stock | 337.22 | 337.78 | 332.13 | 332.19 | 2033889.0 |
| 2021-11-30 11:00:00 | MSFT | Stock | 332.2 | 332.34 | 330.56 | 331.04 | 1790826.0 |
| 2021-11-30 11:30:00 | MSFT | Stock | 331.03 | 331.4 | 328.99 | 329.99 | 1722412.0 |
| 2021-11-30 12:00:00 | MSFT | Stock | 329.98 | 331.48 | 329.62 | 330.28 | 1183992.0 |
| 2021-11-30 12:30:00 | MSFT | Stock | 330.26 | 330.75 | 329.73 | 330.39 | 761771.0 |
> showing 50 of 115,957 rows — these rows as CSV