PREVIEW / stock_30min / 2021-10-07
file: by_date/stock_30min/2021/2021-10-07.parquet size: 2.2 MB rows: 108,725 symbols: 2,721
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-07 04:00:00 | AAPL | Stock | 143.25 | 143.68 | 143.14 | 143.47 | 33911.0 |
| 2021-10-07 04:30:00 | AAPL | Stock | 143.48 | 143.63 | 143.48 | 143.48 | 11229.0 |
| 2021-10-07 05:00:00 | AAPL | Stock | 143.38 | 143.5 | 143.3 | 143.38 | 4238.0 |
| 2021-10-07 05:30:00 | AAPL | Stock | 143.43 | 143.46 | 143.38 | 143.41 | 1820.0 |
| 2021-10-07 06:00:00 | AAPL | Stock | 143.42 | 143.5 | 143.24 | 143.24 | 7727.0 |
| 2021-10-07 06:30:00 | AAPL | Stock | 143.2 | 143.37 | 142.92 | 143.37 | 36666.0 |
| 2021-10-07 07:00:00 | AAPL | Stock | 143.38 | 143.85 | 143.26 | 143.67 | 103559.0 |
| 2021-10-07 07:30:00 | AAPL | Stock | 143.67 | 143.85 | 143.56 | 143.7 | 91866.0 |
| 2021-10-07 08:00:00 | AAPL | Stock | 143.71 | 143.85 | 143.34 | 143.36 | 426133.0 |
| 2021-10-07 08:30:00 | AAPL | Stock | 143.36 | 143.54 | 143.25 | 143.4 | 144508.0 |
| 2021-10-07 09:00:00 | AAPL | Stock | 143.4 | 143.4 | 142.92 | 142.97 | 227991.0 |
| 2021-10-07 09:30:00 | AAPL | Stock | 143.0 | 143.85 | 142.72 | 143.845 | 9949564.0 |
| 2021-10-07 10:00:00 | AAPL | Stock | 143.845 | 144.215 | 143.78 | 143.965 | 6249805.0 |
| 2021-10-07 10:30:00 | AAPL | Stock | 143.965 | 144.19 | 143.85 | 144.0 | 3674720.0 |
| 2021-10-07 11:00:00 | AAPL | Stock | 144.01 | 144.0614 | 143.545 | 143.83 | 3370163.0 |
| 2021-10-07 11:30:00 | AAPL | Stock | 143.84 | 144.15 | 143.7504 | 144.12 | 2759001.0 |
| 2021-10-07 12:00:00 | AAPL | Stock | 144.13 | 144.14 | 143.625 | 143.835 | 2362834.0 |
| 2021-10-07 12:30:00 | AAPL | Stock | 143.835 | 144.06 | 143.71 | 144.045 | 2450331.0 |
| 2021-10-07 13:00:00 | AAPL | Stock | 144.04 | 144.17 | 143.915 | 144.08 | 2620290.0 |
| 2021-10-07 13:30:00 | AAPL | Stock | 144.08 | 144.17 | 143.91 | 143.9433 | 1851120.0 |
| 2021-10-07 14:00:00 | AAPL | Stock | 143.945 | 144.0 | 143.64 | 143.735 | 2521462.0 |
| 2021-10-07 14:30:00 | AAPL | Stock | 143.74 | 143.82 | 143.425 | 143.54 | 2435093.0 |
| 2021-10-07 15:00:00 | AAPL | Stock | 143.545 | 143.82 | 143.43 | 143.77 | 2808179.0 |
| 2021-10-07 15:30:00 | AAPL | Stock | 143.77 | 143.84 | 143.0 | 143.28 | 5928544.0 |
| 2021-10-07 16:00:00 | AAPL | Stock | 143.28 | 143.3072 | 142.98 | 143.28 | 4506696.0 |
| 2021-10-07 16:30:00 | AAPL | Stock | 143.29 | 143.3 | 143.2 | 143.2 | 20083.0 |
| 2021-10-07 17:00:00 | AAPL | Stock | 143.25 | 143.27 | 143.2 | 143.27 | 8956.0 |
| 2021-10-07 17:30:00 | AAPL | Stock | 143.23 | 143.27 | 143.16 | 143.19 | 6949.0 |
| 2021-10-07 18:00:00 | AAPL | Stock | 143.25 | 143.33 | 143.22 | 143.24 | 13252.0 |
| 2021-10-07 18:30:00 | AAPL | Stock | 143.22 | 143.39 | 143.2 | 143.38 | 23180.0 |
| 2021-10-07 19:00:00 | AAPL | Stock | 143.38 | 143.47 | 143.32 | 143.36 | 23179.0 |
| 2021-10-07 19:30:00 | AAPL | Stock | 143.38 | 143.59 | 143.3 | 143.55 | 39839.0 |
| 2021-10-07 04:00:00 | MSFT | Stock | 295.26 | 295.97 | 295.26 | 295.59 | 2325.0 |
| 2021-10-07 04:30:00 | MSFT | Stock | 295.58 | 296.34 | 295.58 | 296.3 | 6792.0 |
| 2021-10-07 05:00:00 | MSFT | Stock | 296.15 | 296.25 | 296.15 | 296.15 | 661.0 |
| 2021-10-07 05:30:00 | MSFT | Stock | 295.95 | 295.95 | 295.85 | 295.85 | 859.0 |
| 2021-10-07 06:00:00 | MSFT | Stock | 296.03 | 296.03 | 295.85 | 295.85 | 1624.0 |
| 2021-10-07 06:30:00 | MSFT | Stock | 295.85 | 295.95 | 295.52 | 295.95 | 4170.0 |
| 2021-10-07 07:00:00 | MSFT | Stock | 295.86 | 296.48 | 295.85 | 296.36 | 29373.0 |
| 2021-10-07 07:30:00 | MSFT | Stock | 296.36 | 296.43 | 296.0 | 296.15 | 26549.0 |
| 2021-10-07 08:00:00 | MSFT | Stock | 296.15 | 296.48 | 295.67 | 295.91 | 56784.0 |
| 2021-10-07 08:30:00 | MSFT | Stock | 295.95 | 296.3 | 295.56 | 295.56 | 18412.0 |
| 2021-10-07 09:00:00 | MSFT | Stock | 295.66 | 295.6999 | 294.85 | 295.06 | 57642.0 |
| 2021-10-07 09:30:00 | MSFT | Stock | 295.07 | 296.3 | 293.92 | 295.39 | 2584816.0 |
| 2021-10-07 10:00:00 | MSFT | Stock | 295.41 | 296.17 | 295.13 | 295.8932 | 1388488.0 |
| 2021-10-07 10:30:00 | MSFT | Stock | 295.92 | 296.53 | 295.71 | 296.38 | 938014.0 |
| 2021-10-07 11:00:00 | MSFT | Stock | 296.38 | 296.64 | 295.42 | 295.54 | 901955.0 |
| 2021-10-07 11:30:00 | MSFT | Stock | 295.55 | 296.46 | 295.41 | 296.37 | 683241.0 |
| 2021-10-07 12:00:00 | MSFT | Stock | 296.37 | 296.435 | 295.76 | 295.86 | 548387.0 |
| 2021-10-07 12:30:00 | MSFT | Stock | 295.86 | 296.56 | 295.86 | 296.51 | 668743.0 |
> showing 50 of 108,725 rows — these rows as CSV