PREVIEW / stock_30min / 2021-11-10
file: by_date/stock_30min/2021/2021-11-10.parquet size: 2.3 MB rows: 115,026 symbols: 2,708
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-10 04:00:00 | AAPL | Stock | 150.72 | 150.72 | 150.28 | 150.3 | 4844.0 |
| 2021-11-10 04:30:00 | AAPL | Stock | 150.28 | 150.3 | 150.16 | 150.29 | 2771.0 |
| 2021-11-10 05:00:00 | AAPL | Stock | 150.18 | 150.18 | 150.05 | 150.15 | 3093.0 |
| 2021-11-10 05:30:00 | AAPL | Stock | 150.15 | 150.16 | 149.92 | 150.04 | 6483.0 |
| 2021-11-10 06:00:00 | AAPL | Stock | 150.13 | 150.19 | 149.94 | 150.0 | 4417.0 |
| 2021-11-10 06:30:00 | AAPL | Stock | 149.95 | 150.0 | 149.83 | 149.94 | 9208.0 |
| 2021-11-10 07:00:00 | AAPL | Stock | 149.95 | 150.35 | 149.94 | 150.27 | 37588.0 |
| 2021-11-10 07:30:00 | AAPL | Stock | 150.2 | 150.37 | 150.08 | 150.28 | 46906.0 |
| 2021-11-10 08:00:00 | AAPL | Stock | 150.29 | 150.5 | 150.0 | 150.35 | 214348.0 |
| 2021-11-10 08:30:00 | AAPL | Stock | 150.3 | 150.31 | 149.96 | 150.21 | 314168.0 |
| 2021-11-10 09:00:00 | AAPL | Stock | 150.22 | 150.4 | 149.82 | 150.06 | 196439.0 |
| 2021-11-10 09:30:00 | AAPL | Stock | 150.08 | 150.13 | 147.95 | 149.02 | 11293439.0 |
| 2021-11-10 10:00:00 | AAPL | Stock | 149.03 | 149.61 | 148.85 | 149.01 | 3866243.0 |
| 2021-11-10 10:30:00 | AAPL | Stock | 149.015 | 149.18 | 148.72 | 148.97 | 2741003.0 |
| 2021-11-10 11:00:00 | AAPL | Stock | 148.975 | 149.0777 | 148.7501 | 148.86 | 2101008.0 |
| 2021-11-10 11:30:00 | AAPL | Stock | 148.865 | 149.08 | 148.68 | 149.07 | 1875727.0 |
| 2021-11-10 12:00:00 | AAPL | Stock | 149.07 | 149.19 | 148.94 | 148.98 | 1557357.0 |
| 2021-11-10 12:30:00 | AAPL | Stock | 148.98 | 149.18 | 148.795 | 149.18 | 1527398.0 |
| 2021-11-10 13:00:00 | AAPL | Stock | 149.17 | 149.18 | 148.525 | 148.827 | 2733949.0 |
| 2021-11-10 13:30:00 | AAPL | Stock | 148.8286 | 148.9 | 148.33 | 148.505 | 2151140.0 |
| 2021-11-10 14:00:00 | AAPL | Stock | 148.5 | 148.53 | 148.17 | 148.1799 | 2451771.0 |
| 2021-11-10 14:30:00 | AAPL | Stock | 148.18 | 148.37 | 147.933 | 148.15 | 3466189.0 |
| 2021-11-10 15:00:00 | AAPL | Stock | 148.16 | 148.25 | 147.98 | 148.055 | 2970463.0 |
| 2021-11-10 15:30:00 | AAPL | Stock | 148.055 | 148.2975 | 147.85 | 147.92 | 6328229.0 |
| 2021-11-10 16:00:00 | AAPL | Stock | 148.1 | 150.81 | 147.84 | 148.06 | 7303728.0 |
| 2021-11-10 16:30:00 | AAPL | Stock | 148.02 | 148.04 | 147.92 | 147.99 | 132879.0 |
| 2021-11-10 17:00:00 | AAPL | Stock | 147.96 | 148.16 | 147.92 | 148.15 | 32139.0 |
| 2021-11-10 17:30:00 | AAPL | Stock | 148.15 | 148.16 | 148.05 | 148.14 | 14843.0 |
| 2021-11-10 18:00:00 | AAPL | Stock | 148.14 | 148.2 | 148.08 | 148.08 | 13213.0 |
| 2021-11-10 18:30:00 | AAPL | Stock | 148.1 | 148.1 | 147.9 | 147.92 | 22115.0 |
| 2021-11-10 19:00:00 | AAPL | Stock | 147.98 | 148.19 | 147.94 | 148.16 | 21459.0 |
| 2021-11-10 19:30:00 | AAPL | Stock | 148.18 | 148.28 | 148.13 | 148.15 | 35522.0 |
| 2021-11-10 04:00:00 | MSFT | Stock | 336.0 | 336.0 | 335.8 | 335.8 | 329.0 |
| 2021-11-10 05:00:00 | MSFT | Stock | 335.05 | 335.05 | 334.51 | 334.97 | 454.0 |
| 2021-11-10 06:00:00 | MSFT | Stock | 334.94 | 335.4 | 334.94 | 335.29 | 4869.0 |
| 2021-11-10 06:30:00 | MSFT | Stock | 335.2 | 335.21 | 334.76 | 335.04 | 15802.0 |
| 2021-11-10 07:00:00 | MSFT | Stock | 334.96 | 335.6 | 334.94 | 335.6 | 13387.0 |
| 2021-11-10 07:30:00 | MSFT | Stock | 335.34 | 335.35 | 334.98 | 335.25 | 7462.0 |
| 2021-11-10 08:00:00 | MSFT | Stock | 334.9116 | 335.89 | 334.85 | 335.7 | 19083.0 |
| 2021-11-10 08:30:00 | MSFT | Stock | 335.37 | 335.37 | 334.12 | 334.7021 | 46889.0 |
| 2021-11-10 09:00:00 | MSFT | Stock | 334.71 | 335.45 | 334.13 | 334.43 | 26380.0 |
| 2021-11-10 09:30:00 | MSFT | Stock | 334.69 | 334.69 | 331.11 | 332.86 | 2512426.0 |
| 2021-11-10 10:00:00 | MSFT | Stock | 332.87 | 333.98 | 332.55 | 333.035 | 1012974.0 |
| 2021-11-10 10:30:00 | MSFT | Stock | 333.035 | 333.3933 | 332.71 | 333.09 | 646230.0 |
| 2021-11-10 11:00:00 | MSFT | Stock | 333.08 | 333.72 | 332.8163 | 332.895 | 555083.0 |
| 2021-11-10 11:30:00 | MSFT | Stock | 332.92 | 332.94 | 331.63 | 332.44 | 782139.0 |
| 2021-11-10 12:00:00 | MSFT | Stock | 332.445 | 332.7431 | 332.34 | 332.5 | 397571.0 |
| 2021-11-10 12:30:00 | MSFT | Stock | 332.525 | 332.856 | 332.12 | 332.8 | 437473.0 |
| 2021-11-10 13:00:00 | MSFT | Stock | 332.78 | 332.83 | 330.41 | 331.06 | 1063496.0 |
| 2021-11-10 13:30:00 | MSFT | Stock | 331.07 | 331.34 | 329.93 | 330.405 | 1023959.0 |
> showing 50 of 115,026 rows — these rows as CSV