PREVIEW / stock_30min / 2006-01-04
file: by_date/stock_30min/2006/2006-01-04.parquet size: 886 KB rows: 47,816 symbols: 2,175
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-04 07:00:00 | AAPL | Stock | 2.6696 | 2.6696 | 2.6696 | 2.6696 | 2800.0 |
| 2006-01-04 07:30:00 | AAPL | Stock | 2.6786 | 2.6786 | 2.6786 | 2.6786 | 14000.0 |
| 2006-01-04 08:00:00 | AAPL | Stock | 2.6779 | 2.6857 | 2.67 | 2.6786 | 1603280.0 |
| 2006-01-04 08:30:00 | AAPL | Stock | 2.6779 | 2.6821 | 2.6729 | 2.6789 | 1394400.0 |
| 2006-01-04 09:00:00 | AAPL | Stock | 2.6786 | 2.6868 | 2.6725 | 2.6832 | 3093552.0 |
| 2006-01-04 09:30:00 | AAPL | Stock | 2.6832 | 2.7136 | 2.6771 | 2.6786 | 140587104.0 |
| 2006-01-04 10:00:00 | AAPL | Stock | 2.6786 | 2.6946 | 2.665 | 2.6718 | 88580660.0 |
| 2006-01-04 10:30:00 | AAPL | Stock | 2.6718 | 2.6821 | 2.6607 | 2.6725 | 56754012.0 |
| 2006-01-04 11:00:00 | AAPL | Stock | 2.6725 | 2.6818 | 2.6643 | 2.68 | 34323604.0 |
| 2006-01-04 11:30:00 | AAPL | Stock | 2.6804 | 2.6893 | 2.6739 | 2.6843 | 34122536.0 |
| 2006-01-04 12:00:00 | AAPL | Stock | 2.6843 | 2.6843 | 2.675 | 2.6779 | 21763952.0 |
| 2006-01-04 12:30:00 | AAPL | Stock | 2.6771 | 2.6811 | 2.6711 | 2.6746 | 23702448.0 |
| 2006-01-04 13:00:00 | AAPL | Stock | 2.675 | 2.675 | 2.6679 | 2.6746 | 23682512.0 |
| 2006-01-04 13:30:00 | AAPL | Stock | 2.6746 | 2.6839 | 2.6689 | 2.68 | 23468032.0 |
| 2006-01-04 14:00:00 | AAPL | Stock | 2.68 | 2.6818 | 2.6639 | 2.6754 | 30210964.0 |
| 2006-01-04 14:30:00 | AAPL | Stock | 2.6754 | 2.6821 | 2.6675 | 2.6686 | 22994412.0 |
| 2006-01-04 15:00:00 | AAPL | Stock | 2.6689 | 2.6768 | 2.6668 | 2.6754 | 33282928.0 |
| 2006-01-04 15:30:00 | AAPL | Stock | 2.675 | 2.6821 | 2.6696 | 2.6779 | 60092340.0 |
| 2006-01-04 16:00:00 | AAPL | Stock | 2.6775 | 2.6787 | 2.6725 | 2.6736 | 2031652.0 |
| 2006-01-04 16:30:00 | AAPL | Stock | 2.6746 | 2.6775 | 2.6714 | 2.6729 | 251636.0 |
| 2006-01-04 17:00:00 | AAPL | Stock | 2.6732 | 2.6742 | 2.6718 | 2.6725 | 1790824.0 |
| 2006-01-04 17:30:00 | AAPL | Stock | 2.6725 | 2.6775 | 2.6725 | 2.6732 | 503972.0 |
| 2006-01-04 18:00:00 | AAPL | Stock | 2.6725 | 2.675 | 2.6725 | 2.675 | 136920.0 |
| 2006-01-04 07:30:00 | MSFT | Stock | 26.83 | 26.83 | 26.83 | 26.83 | 200.0 |
| 2006-01-04 08:00:00 | MSFT | Stock | 26.78 | 26.8 | 26.78 | 26.8 | 716.0 |
| 2006-01-04 08:30:00 | MSFT | Stock | 26.77 | 26.83 | 26.77 | 26.79 | 22591.0 |
| 2006-01-04 09:00:00 | MSFT | Stock | 26.78 | 26.82 | 26.77 | 26.79 | 109890.0 |
| 2006-01-04 09:30:00 | MSFT | Stock | 26.77 | 26.97 | 26.77 | 26.92 | 8765724.0 |
| 2006-01-04 10:00:00 | MSFT | Stock | 26.922 | 26.98 | 26.88 | 26.94 | 5621929.0 |
| 2006-01-04 10:30:00 | MSFT | Stock | 26.95 | 26.98 | 26.93 | 26.95 | 4338118.0 |
| 2006-01-04 11:00:00 | MSFT | Stock | 26.96 | 26.97 | 26.89 | 26.95 | 3625012.0 |
| 2006-01-04 11:30:00 | MSFT | Stock | 26.95 | 27.08 | 26.93 | 27.018 | 5775988.0 |
| 2006-01-04 12:00:00 | MSFT | Stock | 27.02 | 27.05 | 26.98 | 26.99 | 3301787.0 |
| 2006-01-04 12:30:00 | MSFT | Stock | 26.99 | 27.08 | 26.95 | 26.99 | 2116546.0 |
| 2006-01-04 13:00:00 | MSFT | Stock | 26.99 | 27.0 | 26.92 | 26.96 | 1891201.0 |
| 2006-01-04 13:30:00 | MSFT | Stock | 26.96 | 26.99 | 26.91 | 26.94 | 2731804.0 |
| 2006-01-04 14:00:00 | MSFT | Stock | 26.94 | 26.96 | 26.87 | 26.95 | 3395887.0 |
| 2006-01-04 14:30:00 | MSFT | Stock | 26.95 | 27.0 | 26.92 | 26.97 | 3515685.0 |
| 2006-01-04 15:00:00 | MSFT | Stock | 26.98 | 26.99 | 26.93 | 26.98 | 4686889.0 |
| 2006-01-04 15:30:00 | MSFT | Stock | 26.98 | 27.01 | 26.95 | 26.99 | 6036436.0 |
| 2006-01-04 16:00:00 | MSFT | Stock | 26.99 | 27.0 | 26.932 | 26.98 | 211037.0 |
| 2006-01-04 16:30:00 | MSFT | Stock | 26.98 | 26.98 | 26.96 | 26.98 | 49799.0 |
| 2006-01-04 17:00:00 | MSFT | Stock | 26.96 | 26.99 | 26.95 | 26.95 | 2981.0 |
| 2006-01-04 17:30:00 | MSFT | Stock | 26.98 | 26.99 | 26.97 | 26.99 | 13075.0 |
| 2006-01-04 08:00:00 | NVDA | Stock | 0.3145 | 0.3145 | 0.3145 | 0.3145 | 24000.0 |
| 2006-01-04 09:00:00 | NVDA | Stock | 0.3187 | 0.3208 | 0.3182 | 0.3207 | 1932000.0 |
| 2006-01-04 09:30:00 | NVDA | Stock | 0.3209 | 0.3223 | 0.3176 | 0.3214 | 65733360.0 |
| 2006-01-04 10:00:00 | NVDA | Stock | 0.3215 | 0.3272 | 0.3212 | 0.326 | 70213200.0 |
| 2006-01-04 10:30:00 | NVDA | Stock | 0.326 | 0.3267 | 0.3224 | 0.3262 | 56957640.0 |
| 2006-01-04 11:00:00 | NVDA | Stock | 0.3262 | 0.3267 | 0.324 | 0.3244 | 21693600.0 |
> showing 50 of 47,816 rows — these rows as CSV