PREVIEW / stock_30min / 2021-12-10
file: by_date/stock_30min/2021/2021-12-10.parquet size: 2.2 MB rows: 109,655 symbols: 2,668
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-12-10 04:00:00 | AAPL | Stock | 174.73 | 175.15 | 174.56 | 174.83 | 20516.0 |
| 2021-12-10 04:30:00 | AAPL | Stock | 174.83 | 175.09 | 174.76 | 175.0 | 14033.0 |
| 2021-12-10 05:00:00 | AAPL | Stock | 174.96 | 174.97 | 174.48 | 174.64 | 3425.0 |
| 2021-12-10 05:30:00 | AAPL | Stock | 174.68 | 174.74 | 174.61 | 174.68 | 4984.0 |
| 2021-12-10 06:00:00 | AAPL | Stock | 174.66 | 174.99 | 174.66 | 174.99 | 13636.0 |
| 2021-12-10 06:30:00 | AAPL | Stock | 174.92 | 175.19 | 174.8 | 175.05 | 37177.0 |
| 2021-12-10 07:00:00 | AAPL | Stock | 175.01 | 175.15 | 174.73 | 174.95 | 65087.0 |
| 2021-12-10 07:30:00 | AAPL | Stock | 174.95 | 175.06 | 174.63 | 174.74 | 46401.0 |
| 2021-12-10 08:00:00 | AAPL | Stock | 174.85 | 175.15 | 174.124 | 174.63 | 304145.0 |
| 2021-12-10 08:30:00 | AAPL | Stock | 174.63 | 175.88 | 174.59 | 175.45 | 542130.0 |
| 2021-12-10 09:00:00 | AAPL | Stock | 175.46 | 175.6 | 175.1 | 175.23 | 233795.0 |
| 2021-12-10 09:30:00 | AAPL | Stock | 175.25 | 176.556 | 174.69 | 175.18 | 13495017.0 |
| 2021-12-10 10:00:00 | AAPL | Stock | 175.18 | 176.95 | 175.09 | 176.91 | 9629930.0 |
| 2021-12-10 10:30:00 | AAPL | Stock | 176.911 | 176.99 | 175.59 | 176.14 | 7075201.0 |
| 2021-12-10 11:00:00 | AAPL | Stock | 176.12 | 176.37 | 175.4 | 176.305 | 5816341.0 |
| 2021-12-10 11:30:00 | AAPL | Stock | 176.305 | 176.74 | 175.7337 | 176.7 | 4662147.0 |
| 2021-12-10 12:00:00 | AAPL | Stock | 176.71 | 177.18 | 176.6 | 176.95 | 5884593.0 |
| 2021-12-10 12:30:00 | AAPL | Stock | 176.97 | 177.32 | 176.64 | 177.29 | 4066237.0 |
| 2021-12-10 13:00:00 | AAPL | Stock | 177.3 | 177.665 | 177.045 | 177.62 | 5259850.0 |
| 2021-12-10 13:30:00 | AAPL | Stock | 177.6101 | 177.8199 | 177.33 | 177.6839 | 4099828.0 |
| 2021-12-10 14:00:00 | AAPL | Stock | 177.6773 | 177.88 | 177.58 | 177.83 | 3464895.0 |
| 2021-12-10 14:30:00 | AAPL | Stock | 177.835 | 177.91 | 177.61 | 177.84 | 4932474.0 |
| 2021-12-10 15:00:00 | AAPL | Stock | 177.831 | 178.2 | 177.67 | 177.925 | 7443788.0 |
| 2021-12-10 15:30:00 | AAPL | Stock | 177.92 | 179.63 | 177.9038 | 179.5 | 13055099.0 |
| 2021-12-10 16:00:00 | AAPL | Stock | 179.49 | 179.62 | 179.22 | 179.55 | 9097145.0 |
| 2021-12-10 16:30:00 | AAPL | Stock | 179.5501 | 179.75 | 179.45 | 179.58 | 93542.0 |
| 2021-12-10 17:00:00 | AAPL | Stock | 179.58 | 179.67 | 179.45 | 179.55 | 1344249.0 |
| 2021-12-10 17:30:00 | AAPL | Stock | 179.52 | 179.65 | 179.42 | 179.6 | 38111.0 |
| 2021-12-10 18:00:00 | AAPL | Stock | 179.66 | 179.71 | 179.5 | 179.6 | 34096.0 |
| 2021-12-10 18:30:00 | AAPL | Stock | 179.62 | 179.68 | 179.5 | 179.65 | 32498.0 |
| 2021-12-10 19:00:00 | AAPL | Stock | 179.65 | 179.94 | 179.63 | 179.9 | 41848.0 |
| 2021-12-10 19:30:00 | AAPL | Stock | 179.88 | 179.88 | 179.71 | 179.84 | 57605.0 |
| 2021-12-10 04:00:00 | MSFT | Stock | 332.89 | 333.5 | 332.89 | 333.5 | 2111.0 |
| 2021-12-10 04:30:00 | MSFT | Stock | 333.64 | 333.81 | 333.64 | 333.8 | 882.0 |
| 2021-12-10 05:30:00 | MSFT | Stock | 333.75 | 333.76 | 333.75 | 333.76 | 1500.0 |
| 2021-12-10 06:30:00 | MSFT | Stock | 333.97 | 334.0 | 333.91 | 333.91 | 841.0 |
| 2021-12-10 07:00:00 | MSFT | Stock | 333.91 | 333.91 | 333.53 | 333.6 | 2933.0 |
| 2021-12-10 07:30:00 | MSFT | Stock | 333.5 | 333.59 | 333.01 | 333.1 | 2009.0 |
| 2021-12-10 08:00:00 | MSFT | Stock | 333.865 | 333.87 | 332.7 | 333.6 | 18895.0 |
| 2021-12-10 08:30:00 | MSFT | Stock | 333.8 | 336.29 | 333.8 | 335.69 | 68574.0 |
| 2021-12-10 09:00:00 | MSFT | Stock | 335.6 | 335.86 | 334.35 | 334.72 | 35486.0 |
| 2021-12-10 09:30:00 | MSFT | Stock | 334.8 | 339.0 | 334.79 | 338.2999 | 3190987.0 |
| 2021-12-10 10:00:00 | MSFT | Stock | 338.3 | 342.7 | 338.11 | 342.59 | 4220290.0 |
| 2021-12-10 10:30:00 | MSFT | Stock | 342.63 | 342.6406 | 339.7959 | 340.98 | 2966836.0 |
| 2021-12-10 11:00:00 | MSFT | Stock | 340.93 | 340.96 | 338.36 | 339.4 | 2029859.0 |
| 2021-12-10 11:30:00 | MSFT | Stock | 339.42 | 340.63 | 338.52 | 339.95 | 1371052.0 |
| 2021-12-10 12:00:00 | MSFT | Stock | 339.9697 | 340.06 | 338.25 | 339.12 | 904344.0 |
| 2021-12-10 12:30:00 | MSFT | Stock | 339.12 | 340.29 | 338.4989 | 340.26 | 861353.0 |
| 2021-12-10 13:00:00 | MSFT | Stock | 340.26 | 340.95 | 339.95 | 340.8299 | 1039516.0 |
| 2021-12-10 13:30:00 | MSFT | Stock | 340.8133 | 340.91 | 339.98 | 340.525 | 849411.0 |
> showing 50 of 109,655 rows — these rows as CSV