PREVIEW / stock_30min / 2008-09-05
file: by_date/stock_30min/2008/2008-09-05.parquet size: 1.2 MB rows: 69,757 symbols: 3,304
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-05 06:00:00 | AAPL | Stock | 5.7143 | 5.7143 | 5.7143 | 5.7143 | 5040.0 |
| 2008-09-05 07:00:00 | AAPL | Stock | 5.7143 | 5.7375 | 5.7143 | 5.7321 | 58240.0 |
| 2008-09-05 07:30:00 | AAPL | Stock | 5.7429 | 5.7607 | 5.7429 | 5.7507 | 65128.0 |
| 2008-09-05 08:00:00 | AAPL | Stock | 5.7536 | 5.7536 | 5.7154 | 5.7286 | 865032.0 |
| 2008-09-05 08:30:00 | AAPL | Stock | 5.7286 | 5.7443 | 5.6168 | 5.6604 | 5260640.0 |
| 2008-09-05 09:00:00 | AAPL | Stock | 5.6593 | 5.7036 | 5.6518 | 5.6646 | 2496648.0 |
| 2008-09-05 09:30:00 | AAPL | Stock | 5.6646 | 5.775 | 5.6429 | 5.7604 | 113871828.0 |
| 2008-09-05 10:00:00 | AAPL | Stock | 5.7614 | 5.8 | 5.6786 | 5.6993 | 91760004.0 |
| 2008-09-05 10:30:00 | AAPL | Stock | 5.7012 | 5.7321 | 5.6596 | 5.6768 | 58097256.0 |
| 2008-09-05 11:00:00 | AAPL | Stock | 5.6771 | 5.7143 | 5.6304 | 5.6882 | 59237808.0 |
| 2008-09-05 11:30:00 | AAPL | Stock | 5.6882 | 5.7489 | 5.6707 | 5.7286 | 59030104.0 |
| 2008-09-05 12:00:00 | AAPL | Stock | 5.7304 | 5.7589 | 5.6793 | 5.7064 | 53385052.0 |
| 2008-09-05 12:30:00 | AAPL | Stock | 5.7086 | 5.7407 | 5.6893 | 5.7132 | 44462656.0 |
| 2008-09-05 13:00:00 | AAPL | Stock | 5.7154 | 5.7757 | 5.6989 | 5.7132 | 45093216.0 |
| 2008-09-05 13:30:00 | AAPL | Stock | 5.7129 | 5.7311 | 5.6825 | 5.7189 | 33488336.0 |
| 2008-09-05 14:00:00 | AAPL | Stock | 5.7189 | 5.7525 | 5.6864 | 5.7314 | 39052664.0 |
| 2008-09-05 14:30:00 | AAPL | Stock | 5.7314 | 5.7604 | 5.7032 | 5.7376 | 56798336.0 |
| 2008-09-05 15:00:00 | AAPL | Stock | 5.7368 | 5.7393 | 5.6961 | 5.7121 | 42457828.0 |
| 2008-09-05 15:30:00 | AAPL | Stock | 5.7118 | 5.7393 | 5.7036 | 5.7143 | 57107652.0 |
| 2008-09-05 16:00:00 | AAPL | Stock | 5.7171 | 5.721 | 5.7114 | 5.7171 | 7835688.0 |
| 2008-09-05 16:30:00 | AAPL | Stock | 5.7168 | 5.7679 | 5.7168 | 5.7657 | 3137456.0 |
| 2008-09-05 17:00:00 | AAPL | Stock | 5.7661 | 5.7736 | 5.7207 | 5.7582 | 376040.0 |
| 2008-09-05 17:30:00 | AAPL | Stock | 5.7579 | 5.7757 | 5.75 | 5.7714 | 386876.0 |
| 2008-09-05 18:00:00 | AAPL | Stock | 5.7714 | 5.7721 | 5.7646 | 5.7714 | 99260.0 |
| 2008-09-05 18:30:00 | AAPL | Stock | 5.7714 | 5.7768 | 5.7714 | 5.7764 | 77840.0 |
| 2008-09-05 19:00:00 | AAPL | Stock | 5.7721 | 5.7768 | 5.7721 | 5.7729 | 23464.0 |
| 2008-09-05 19:30:00 | AAPL | Stock | 5.7729 | 5.7746 | 5.7682 | 5.7746 | 84504.0 |
| 2008-09-05 07:00:00 | MSFT | Stock | 26.2 | 26.2 | 26.2 | 26.2 | 200.0 |
| 2008-09-05 07:30:00 | MSFT | Stock | 26.25 | 26.29 | 26.25 | 26.29 | 784.0 |
| 2008-09-05 08:00:00 | MSFT | Stock | 26.35 | 26.38 | 26.2 | 26.2 | 28750.0 |
| 2008-09-05 08:30:00 | MSFT | Stock | 26.17 | 26.17 | 25.92 | 26.09 | 37668.0 |
| 2008-09-05 09:00:00 | MSFT | Stock | 26.07 | 26.2 | 25.95 | 26.03 | 40421.0 |
| 2008-09-05 09:30:00 | MSFT | Stock | 26.04 | 26.22 | 25.98 | 26.05 | 10017119.0 |
| 2008-09-05 10:00:00 | MSFT | Stock | 26.06 | 26.09 | 25.86 | 25.9 | 10319118.0 |
| 2008-09-05 10:30:00 | MSFT | Stock | 25.9 | 25.99 | 25.71 | 25.763 | 6171288.0 |
| 2008-09-05 11:00:00 | MSFT | Stock | 25.77 | 25.84 | 25.69 | 25.84 | 5707093.0 |
| 2008-09-05 11:30:00 | MSFT | Stock | 25.84 | 25.98 | 25.76 | 25.92 | 6045825.0 |
| 2008-09-05 12:00:00 | MSFT | Stock | 25.92 | 25.97 | 25.79 | 25.97 | 3557444.0 |
| 2008-09-05 12:30:00 | MSFT | Stock | 25.96 | 26.04 | 25.89 | 25.95 | 4805472.0 |
| 2008-09-05 13:00:00 | MSFT | Stock | 25.96 | 26.08 | 25.93 | 25.94 | 4492150.0 |
| 2008-09-05 13:30:00 | MSFT | Stock | 25.946 | 25.98 | 25.8 | 25.928 | 4512115.0 |
| 2008-09-05 14:00:00 | MSFT | Stock | 25.92 | 25.96 | 25.85 | 25.89 | 4394441.0 |
| 2008-09-05 14:30:00 | MSFT | Stock | 25.9 | 25.95 | 25.85 | 25.89 | 3233822.0 |
| 2008-09-05 15:00:00 | MSFT | Stock | 25.89 | 25.91 | 25.72 | 25.76 | 5490765.0 |
| 2008-09-05 15:30:00 | MSFT | Stock | 25.75 | 25.87 | 25.63 | 25.64 | 8949778.0 |
| 2008-09-05 16:00:00 | MSFT | Stock | 25.63 | 25.897 | 25.56 | 25.67 | 2416953.0 |
| 2008-09-05 16:30:00 | MSFT | Stock | 25.68 | 25.85 | 25.65 | 25.85 | 296414.0 |
| 2008-09-05 17:00:00 | MSFT | Stock | 25.84 | 25.85 | 25.65 | 25.85 | 32247.0 |
| 2008-09-05 17:30:00 | MSFT | Stock | 25.92 | 25.98 | 25.85 | 25.95 | 65574.0 |
| 2008-09-05 18:00:00 | MSFT | Stock | 25.95 | 25.95 | 25.9 | 25.94 | 4700.0 |
> showing 50 of 69,757 rows — these rows as CSV