PREVIEW / stock_30min / 2006-01-30
file: by_date/stock_30min/2006/2006-01-30.parquet size: 900 KB rows: 48,123 symbols: 2,186
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 |
|---|---|---|---|---|---|---|---|
| 2006-01-30 04:00:00 | AAPL | Stock | 2.5732 | 2.5732 | 2.5732 | 2.5732 | 5600.0 |
| 2006-01-30 04:30:00 | AAPL | Stock | 2.5732 | 2.5768 | 2.5732 | 2.575 | 28000.0 |
| 2006-01-30 05:00:00 | AAPL | Stock | 2.5768 | 2.5768 | 2.5768 | 2.5768 | 39200.0 |
| 2006-01-30 05:30:00 | AAPL | Stock | 2.5804 | 2.5804 | 2.5714 | 2.5714 | 235200.0 |
| 2006-01-30 06:30:00 | AAPL | Stock | 2.575 | 2.5768 | 2.575 | 2.5768 | 140560.0 |
| 2006-01-30 07:00:00 | AAPL | Stock | 2.5768 | 2.5768 | 2.5571 | 2.5643 | 156800.0 |
| 2006-01-30 07:30:00 | AAPL | Stock | 2.5607 | 2.5607 | 2.5554 | 2.5554 | 231000.0 |
| 2006-01-30 08:00:00 | AAPL | Stock | 2.5661 | 2.5696 | 2.5436 | 2.5518 | 3857448.0 |
| 2006-01-30 08:30:00 | AAPL | Stock | 2.5518 | 2.5604 | 2.5518 | 2.5529 | 1665524.0 |
| 2006-01-30 09:00:00 | AAPL | Stock | 2.5521 | 2.5521 | 2.5332 | 2.5461 | 9525012.0 |
| 2006-01-30 09:30:00 | AAPL | Stock | 2.5418 | 2.5875 | 2.5311 | 2.5686 | 185692080.0 |
| 2006-01-30 10:00:00 | AAPL | Stock | 2.5679 | 2.5929 | 2.5546 | 2.5925 | 76146672.0 |
| 2006-01-30 10:30:00 | AAPL | Stock | 2.5929 | 2.6204 | 2.5846 | 2.6107 | 105322056.0 |
| 2006-01-30 11:00:00 | AAPL | Stock | 2.6118 | 2.6229 | 2.5936 | 2.6204 | 58792048.0 |
| 2006-01-30 11:30:00 | AAPL | Stock | 2.6207 | 2.6421 | 2.6143 | 2.6364 | 77458444.0 |
| 2006-01-30 12:00:00 | AAPL | Stock | 2.6361 | 2.6746 | 2.625 | 2.6725 | 118336344.0 |
| 2006-01-30 12:30:00 | AAPL | Stock | 2.6729 | 2.7193 | 2.6696 | 2.7061 | 155527876.0 |
| 2006-01-30 13:00:00 | AAPL | Stock | 2.7061 | 2.7175 | 2.6946 | 2.715 | 92655304.0 |
| 2006-01-30 13:30:00 | AAPL | Stock | 2.715 | 2.7314 | 2.7018 | 2.7246 | 90033048.0 |
| 2006-01-30 14:00:00 | AAPL | Stock | 2.7246 | 2.7357 | 2.6907 | 2.6946 | 114942688.0 |
| 2006-01-30 14:30:00 | AAPL | Stock | 2.6943 | 2.7039 | 2.6675 | 2.6777 | 95158448.0 |
| 2006-01-30 15:00:00 | AAPL | Stock | 2.6775 | 2.6939 | 2.6661 | 2.6861 | 89988640.0 |
| 2006-01-30 15:30:00 | AAPL | Stock | 2.6857 | 2.6914 | 2.6736 | 2.6857 | 82667732.0 |
| 2006-01-30 16:00:00 | AAPL | Stock | 2.6871 | 2.6996 | 2.6819 | 2.6857 | 3033604.0 |
| 2006-01-30 16:30:00 | AAPL | Stock | 2.6868 | 2.6889 | 2.6786 | 2.6854 | 400064.0 |
| 2006-01-30 17:00:00 | AAPL | Stock | 2.6857 | 2.6907 | 2.6839 | 2.69 | 495796.0 |
| 2006-01-30 17:30:00 | AAPL | Stock | 2.6893 | 2.6918 | 2.6786 | 2.6918 | 5467868.0 |
| 2006-01-30 18:00:00 | AAPL | Stock | 2.6918 | 2.6986 | 2.6896 | 2.6964 | 844648.0 |
| 2006-01-30 07:30:00 | MSFT | Stock | 27.72 | 27.82 | 27.66 | 27.7 | 25300.0 |
| 2006-01-30 08:00:00 | MSFT | Stock | 27.75 | 27.78 | 27.66 | 27.73 | 103252.0 |
| 2006-01-30 08:30:00 | MSFT | Stock | 27.74 | 27.75 | 27.72 | 27.74 | 19840.0 |
| 2006-01-30 09:00:00 | MSFT | Stock | 27.74 | 27.84 | 27.73 | 27.83 | 130226.0 |
| 2006-01-30 09:30:00 | MSFT | Stock | 27.82 | 28.11 | 27.78 | 27.962 | 15525709.0 |
| 2006-01-30 10:00:00 | MSFT | Stock | 27.97 | 28.04 | 27.9 | 27.96 | 11513878.0 |
| 2006-01-30 10:30:00 | MSFT | Stock | 27.96 | 28.01 | 27.89 | 27.94 | 7486912.0 |
| 2006-01-30 11:00:00 | MSFT | Stock | 27.94 | 27.96 | 27.86 | 27.95 | 5782119.0 |
| 2006-01-30 11:30:00 | MSFT | Stock | 27.95 | 27.96 | 27.91 | 27.94 | 4767645.0 |
| 2006-01-30 12:00:00 | MSFT | Stock | 27.93 | 27.97 | 27.91 | 27.942 | 4156278.0 |
| 2006-01-30 12:30:00 | MSFT | Stock | 27.95 | 27.97 | 27.898 | 27.95 | 3260113.0 |
| 2006-01-30 13:00:00 | MSFT | Stock | 27.95 | 27.99 | 27.9 | 27.98 | 5163629.0 |
| 2006-01-30 13:30:00 | MSFT | Stock | 27.97 | 28.02 | 27.96 | 27.97 | 7390213.0 |
| 2006-01-30 14:00:00 | MSFT | Stock | 27.97 | 28.04 | 27.97 | 28.03 | 5839715.0 |
| 2006-01-30 14:30:00 | MSFT | Stock | 28.03 | 28.12 | 28.01 | 28.12 | 6377897.0 |
| 2006-01-30 15:00:00 | MSFT | Stock | 28.12 | 28.18 | 28.02 | 28.05 | 9455826.0 |
| 2006-01-30 15:30:00 | MSFT | Stock | 28.04 | 28.06 | 27.97 | 28.0 | 11464139.0 |
| 2006-01-30 16:00:00 | MSFT | Stock | 28.01 | 28.04 | 27.99 | 28.0 | 421860.0 |
| 2006-01-30 16:30:00 | MSFT | Stock | 28.0 | 28.04 | 27.99 | 28.0 | 546391.0 |
| 2006-01-30 17:00:00 | MSFT | Stock | 28.02 | 28.04 | 28.01 | 28.04 | 704.0 |
| 2006-01-30 17:30:00 | MSFT | Stock | 28.04 | 28.04 | 28.0 | 28.02 | 702205.0 |
| 2006-01-30 18:00:00 | MSFT | Stock | 28.0 | 28.0 | 28.0 | 28.0 | 309.0 |
> showing 50 of 48,123 rows — these rows as CSV