PREVIEW / stock_30min / 2022-10-19
file: by_date/stock_30min/2022/2022-10-19.parquet size: 2.1 MB rows: 101,967 symbols: 2,152
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-19 04:00:00 | AAPL | Stock | 144.06 | 144.15 | 142.4 | 142.55 | 47047.0 |
| 2022-10-19 04:30:00 | AAPL | Stock | 142.55 | 143.1 | 142.55 | 143.02 | 10615.0 |
| 2022-10-19 05:00:00 | AAPL | Stock | 143.0 | 143.4 | 143.0 | 143.31 | 18628.0 |
| 2022-10-19 05:30:00 | AAPL | Stock | 143.48 | 144.5 | 143.48 | 144.41 | 58284.0 |
| 2022-10-19 06:00:00 | AAPL | Stock | 144.29 | 144.38 | 143.65 | 143.65 | 19633.0 |
| 2022-10-19 06:30:00 | AAPL | Stock | 143.71 | 143.91 | 143.21 | 143.22 | 34900.0 |
| 2022-10-19 07:00:00 | AAPL | Stock | 143.46 | 143.59 | 142.11 | 142.11 | 60700.0 |
| 2022-10-19 07:30:00 | AAPL | Stock | 142.18 | 142.52 | 141.95 | 142.52 | 109533.0 |
| 2022-10-19 08:00:00 | AAPL | Stock | 143.5275 | 143.63 | 141.51 | 141.8 | 194636.0 |
| 2022-10-19 08:30:00 | AAPL | Stock | 141.8 | 141.92 | 141.5 | 141.82 | 131238.0 |
| 2022-10-19 09:00:00 | AAPL | Stock | 141.82 | 142.14 | 141.38 | 141.64 | 179835.0 |
| 2022-10-19 09:30:00 | AAPL | Stock | 141.64 | 144.13 | 141.5 | 143.44 | 8430643.0 |
| 2022-10-19 10:00:00 | AAPL | Stock | 143.43 | 144.9492 | 143.17 | 144.8004 | 4909589.0 |
| 2022-10-19 10:30:00 | AAPL | Stock | 144.81 | 144.9 | 143.44 | 143.6 | 3879084.0 |
| 2022-10-19 11:00:00 | AAPL | Stock | 143.59 | 144.05 | 143.275 | 143.51 | 3306858.0 |
| 2022-10-19 11:30:00 | AAPL | Stock | 143.52 | 144.34 | 143.23 | 143.94 | 3154612.0 |
| 2022-10-19 12:00:00 | AAPL | Stock | 143.94 | 143.99 | 143.38 | 143.465 | 2414743.0 |
| 2022-10-19 12:30:00 | AAPL | Stock | 143.46 | 143.9207 | 142.85 | 143.06 | 2880730.0 |
| 2022-10-19 13:00:00 | AAPL | Stock | 143.06 | 143.155 | 142.17 | 142.69 | 3533354.0 |
| 2022-10-19 13:30:00 | AAPL | Stock | 142.68 | 142.89 | 142.27 | 142.805 | 2248917.0 |
| 2022-10-19 14:00:00 | AAPL | Stock | 142.8 | 143.59 | 142.62 | 143.435 | 3014721.0 |
| 2022-10-19 14:30:00 | AAPL | Stock | 143.4379 | 143.5 | 142.84 | 142.95 | 2363319.0 |
| 2022-10-19 15:00:00 | AAPL | Stock | 142.96 | 143.76 | 142.83 | 143.39 | 3451586.0 |
| 2022-10-19 15:30:00 | AAPL | Stock | 143.395 | 143.96 | 143.07 | 143.9 | 5573320.0 |
| 2022-10-19 16:00:00 | AAPL | Stock | 143.9 | 144.59 | 143.4 | 143.93 | 5008138.0 |
| 2022-10-19 16:30:00 | AAPL | Stock | 143.93 | 144.35 | 143.86 | 143.93 | 58000.0 |
| 2022-10-19 17:00:00 | AAPL | Stock | 143.8912 | 143.98 | 143.78 | 143.79 | 10571.0 |
| 2022-10-19 17:30:00 | AAPL | Stock | 143.82 | 143.99 | 143.75 | 143.76 | 41378.0 |
| 2022-10-19 18:00:00 | AAPL | Stock | 143.78 | 143.9 | 143.61 | 143.9 | 18361.0 |
| 2022-10-19 18:30:00 | AAPL | Stock | 143.84 | 143.9 | 143.3 | 143.3 | 19008.0 |
| 2022-10-19 19:00:00 | AAPL | Stock | 143.25 | 143.3 | 142.95 | 143.03 | 33107.0 |
| 2022-10-19 19:30:00 | AAPL | Stock | 143.03 | 143.1 | 142.81 | 143.0 | 21891.0 |
| 2022-10-19 04:00:00 | MSFT | Stock | 239.17 | 239.17 | 237.6 | 237.6 | 6460.0 |
| 2022-10-19 04:30:00 | MSFT | Stock | 237.95 | 238.7 | 237.88 | 238.7 | 21557.0 |
| 2022-10-19 05:00:00 | MSFT | Stock | 239.3 | 239.39 | 239.04 | 239.04 | 1015.0 |
| 2022-10-19 05:30:00 | MSFT | Stock | 239.62 | 240.2 | 239.62 | 240.15 | 531.0 |
| 2022-10-19 06:00:00 | MSFT | Stock | 240.35 | 240.35 | 239.72 | 239.72 | 596.0 |
| 2022-10-19 06:30:00 | MSFT | Stock | 239.06 | 239.63 | 237.33 | 238.53 | 7024.0 |
| 2022-10-19 07:00:00 | MSFT | Stock | 238.58 | 238.58 | 236.68 | 236.68 | 13123.0 |
| 2022-10-19 07:30:00 | MSFT | Stock | 236.6 | 237.45 | 236.33 | 237.45 | 4962.0 |
| 2022-10-19 08:00:00 | MSFT | Stock | 238.6812 | 242.0 | 236.28 | 236.8 | 33013.0 |
| 2022-10-19 08:30:00 | MSFT | Stock | 236.5 | 237.06 | 236.37 | 236.91 | 12331.0 |
| 2022-10-19 09:00:00 | MSFT | Stock | 236.75 | 237.3 | 236.2 | 237.1899 | 25347.0 |
| 2022-10-19 09:30:00 | MSFT | Stock | 237.22 | 238.57 | 236.51 | 237.18 | 1913068.0 |
| 2022-10-19 10:00:00 | MSFT | Stock | 237.14 | 239.61 | 236.76 | 239.15 | 1396083.0 |
| 2022-10-19 10:30:00 | MSFT | Stock | 239.2 | 239.48 | 237.37 | 237.7801 | 969768.0 |
| 2022-10-19 11:00:00 | MSFT | Stock | 237.785 | 238.34 | 236.77 | 236.88 | 735654.0 |
| 2022-10-19 11:30:00 | MSFT | Stock | 236.89 | 237.98 | 236.52 | 237.36 | 972162.0 |
| 2022-10-19 12:00:00 | MSFT | Stock | 237.31 | 237.4 | 236.5 | 236.66 | 685291.0 |
| 2022-10-19 12:30:00 | MSFT | Stock | 236.65 | 237.04 | 235.37 | 235.715 | 836461.0 |
> showing 50 of 101,967 rows — these rows as CSV