PREVIEW / stock_30min / 2022-10-18
file: by_date/stock_30min/2022/2022-10-18.parquet size: 2.1 MB rows: 104,393 symbols: 2,174
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 |
|---|---|---|---|---|---|---|---|
| 2022-10-18 04:00:00 | AAPL | Stock | 144.21 | 145.25 | 144.02 | 144.88 | 47162.0 |
| 2022-10-18 04:30:00 | AAPL | Stock | 144.89 | 144.89 | 144.21 | 144.23 | 15242.0 |
| 2022-10-18 05:00:00 | AAPL | Stock | 144.21 | 144.25 | 143.66 | 143.98 | 27792.0 |
| 2022-10-18 05:30:00 | AAPL | Stock | 143.76 | 144.38 | 143.76 | 144.38 | 14640.0 |
| 2022-10-18 06:00:00 | AAPL | Stock | 144.36 | 144.5 | 144.21 | 144.38 | 11632.0 |
| 2022-10-18 06:30:00 | AAPL | Stock | 144.21 | 144.82 | 144.18 | 144.23 | 26349.0 |
| 2022-10-18 07:00:00 | AAPL | Stock | 144.23 | 144.76 | 144.16 | 144.75 | 59091.0 |
| 2022-10-18 07:30:00 | AAPL | Stock | 144.77 | 145.01 | 144.6 | 144.74 | 95323.0 |
| 2022-10-18 08:00:00 | AAPL | Stock | 144.35 | 145.66 | 142.054 | 144.95 | 200096.0 |
| 2022-10-18 08:30:00 | AAPL | Stock | 145.0 | 145.43 | 144.96 | 145.4 | 159942.0 |
| 2022-10-18 09:00:00 | AAPL | Stock | 145.39 | 145.47 | 145.01 | 145.31 | 248356.0 |
| 2022-10-18 09:30:00 | AAPL | Stock | 145.35 | 146.7 | 145.35 | 145.57 | 11031145.0 |
| 2022-10-18 10:00:00 | AAPL | Stock | 145.56 | 145.96 | 145.14 | 145.32 | 4716044.0 |
| 2022-10-18 10:30:00 | AAPL | Stock | 145.32 | 145.787 | 144.83 | 145.085 | 4505560.0 |
| 2022-10-18 11:00:00 | AAPL | Stock | 145.085 | 145.18 | 143.28 | 143.6 | 5228867.0 |
| 2022-10-18 11:30:00 | AAPL | Stock | 143.5989 | 144.03 | 142.965 | 144.005 | 4486276.0 |
| 2022-10-18 12:00:00 | AAPL | Stock | 144.005 | 144.6966 | 143.6 | 144.35 | 3802737.0 |
| 2022-10-18 12:30:00 | AAPL | Stock | 144.36 | 145.3 | 144.2 | 144.73 | 3961863.0 |
| 2022-10-18 13:00:00 | AAPL | Stock | 144.73 | 145.13 | 144.14 | 144.96 | 3960486.0 |
| 2022-10-18 13:30:00 | AAPL | Stock | 144.96 | 145.63 | 144.8301 | 145.33 | 2932642.0 |
| 2022-10-18 14:00:00 | AAPL | Stock | 145.33 | 145.41 | 144.93 | 145.35 | 2851375.0 |
| 2022-10-18 14:30:00 | AAPL | Stock | 145.34 | 145.36 | 140.61 | 142.5 | 17177675.0 |
| 2022-10-18 15:00:00 | AAPL | Stock | 142.481 | 142.83 | 141.54 | 142.765 | 7234651.0 |
| 2022-10-18 15:30:00 | AAPL | Stock | 142.78 | 143.89 | 142.62 | 143.79 | 9165520.0 |
| 2022-10-18 16:00:00 | AAPL | Stock | 143.79 | 144.82 | 143.5 | 144.36 | 6642950.0 |
| 2022-10-18 16:30:00 | AAPL | Stock | 144.36 | 144.65 | 143.75 | 144.3671 | 97374.0 |
| 2022-10-18 17:00:00 | AAPL | Stock | 144.33 | 144.68 | 144.32 | 144.65 | 59298.0 |
| 2022-10-18 17:30:00 | AAPL | Stock | 144.59 | 144.78 | 144.51 | 144.6699 | 41847.0 |
| 2022-10-18 18:00:00 | AAPL | Stock | 144.52 | 144.64 | 144.33 | 144.42 | 33541.0 |
| 2022-10-18 18:30:00 | AAPL | Stock | 144.43 | 144.5 | 144.34 | 144.48 | 21088.0 |
| 2022-10-18 19:00:00 | AAPL | Stock | 144.48 | 145.5 | 144.42 | 145.25 | 48407.0 |
| 2022-10-18 19:30:00 | AAPL | Stock | 145.28 | 145.38 | 144.85 | 144.88 | 51544.0 |
| 2022-10-18 04:00:00 | MSFT | Stock | 241.01 | 242.12 | 241.01 | 241.96 | 8975.0 |
| 2022-10-18 04:30:00 | MSFT | Stock | 241.79 | 241.85 | 240.35 | 240.35 | 2133.0 |
| 2022-10-18 05:00:00 | MSFT | Stock | 240.35 | 240.82 | 240.09 | 240.51 | 12967.0 |
| 2022-10-18 05:30:00 | MSFT | Stock | 240.5 | 241.7 | 240.5 | 241.67 | 2102.0 |
| 2022-10-18 06:00:00 | MSFT | Stock | 241.67 | 242.0 | 241.43 | 241.43 | 2326.0 |
| 2022-10-18 06:30:00 | MSFT | Stock | 241.19 | 242.1 | 241.1 | 241.3 | 8037.0 |
| 2022-10-18 07:00:00 | MSFT | Stock | 241.01 | 241.75 | 241.01 | 241.63 | 15243.0 |
| 2022-10-18 07:30:00 | MSFT | Stock | 241.65 | 242.61 | 241.6 | 242.35 | 18950.0 |
| 2022-10-18 08:00:00 | MSFT | Stock | 241.0344 | 243.2283 | 236.937 | 242.8 | 63566.0 |
| 2022-10-18 08:30:00 | MSFT | Stock | 242.94 | 244.0 | 242.94 | 243.8 | 40448.0 |
| 2022-10-18 09:00:00 | MSFT | Stock | 243.7 | 244.16 | 243.0 | 243.37 | 92790.0 |
| 2022-10-18 09:30:00 | MSFT | Stock | 243.39 | 243.93 | 239.729 | 239.99 | 3099456.0 |
| 2022-10-18 10:00:00 | MSFT | Stock | 240.0 | 241.34 | 239.5599 | 239.78 | 1741347.0 |
| 2022-10-18 10:30:00 | MSFT | Stock | 239.75 | 240.0 | 238.68 | 239.6 | 1100915.0 |
| 2022-10-18 11:00:00 | MSFT | Stock | 239.55 | 239.56 | 235.97 | 236.56 | 1435198.0 |
| 2022-10-18 11:30:00 | MSFT | Stock | 236.55 | 237.32 | 235.37 | 237.25 | 1350144.0 |
| 2022-10-18 12:00:00 | MSFT | Stock | 237.23 | 238.3799 | 236.92 | 237.769 | 1088920.0 |
| 2022-10-18 12:30:00 | MSFT | Stock | 237.79 | 239.05 | 237.53 | 238.16 | 1027829.0 |
> showing 50 of 104,393 rows — these rows as CSV