PREVIEW / stock_30min / 2006-10-16
file: by_date/stock_30min/2006/2006-10-16.parquet size: 930 KB rows: 50,657 symbols: 2,388
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-10-16 04:30:00 | AAPL | Stock | 2.6896 | 2.6904 | 2.6896 | 2.6904 | 14000.0 |
| 2006-10-16 07:00:00 | AAPL | Stock | 2.6904 | 2.6904 | 2.6904 | 2.6904 | 5600.0 |
| 2006-10-16 07:30:00 | AAPL | Stock | 2.6929 | 2.6929 | 2.6854 | 2.6854 | 22400.0 |
| 2006-10-16 08:00:00 | AAPL | Stock | 2.6857 | 2.6893 | 2.6825 | 2.6857 | 1239560.0 |
| 2006-10-16 08:30:00 | AAPL | Stock | 2.6861 | 2.6893 | 2.6825 | 2.6832 | 629440.0 |
| 2006-10-16 09:00:00 | AAPL | Stock | 2.6825 | 2.6889 | 2.6821 | 2.6825 | 602672.0 |
| 2006-10-16 09:30:00 | AAPL | Stock | 2.6854 | 2.6982 | 2.6807 | 2.685 | 76500396.0 |
| 2006-10-16 10:00:00 | AAPL | Stock | 2.6854 | 2.6879 | 2.6714 | 2.6818 | 60108608.0 |
| 2006-10-16 10:30:00 | AAPL | Stock | 2.6814 | 2.6864 | 2.6725 | 2.6757 | 41238176.0 |
| 2006-10-16 11:00:00 | AAPL | Stock | 2.6757 | 2.6836 | 2.671 | 2.6818 | 31176712.0 |
| 2006-10-16 11:30:00 | AAPL | Stock | 2.6814 | 2.6911 | 2.6782 | 2.6886 | 27383160.0 |
| 2006-10-16 12:00:00 | AAPL | Stock | 2.6886 | 2.6914 | 2.6871 | 2.6889 | 18195520.0 |
| 2006-10-16 12:30:00 | AAPL | Stock | 2.6889 | 2.6946 | 2.6875 | 2.6921 | 17600604.0 |
| 2006-10-16 13:00:00 | AAPL | Stock | 2.6925 | 2.6932 | 2.6846 | 2.6886 | 20599600.0 |
| 2006-10-16 13:30:00 | AAPL | Stock | 2.6882 | 2.7071 | 2.6868 | 2.7036 | 37097816.0 |
| 2006-10-16 14:00:00 | AAPL | Stock | 2.7054 | 2.7054 | 2.6954 | 2.7018 | 21280168.0 |
| 2006-10-16 14:30:00 | AAPL | Stock | 2.7018 | 2.71 | 2.6946 | 2.7029 | 35405104.0 |
| 2006-10-16 15:00:00 | AAPL | Stock | 2.7032 | 2.7071 | 2.6982 | 2.7011 | 23121056.0 |
| 2006-10-16 15:30:00 | AAPL | Stock | 2.7014 | 2.7057 | 2.6921 | 2.695 | 47346292.0 |
| 2006-10-16 16:00:00 | AAPL | Stock | 2.6939 | 2.695 | 2.6921 | 2.6936 | 2344104.0 |
| 2006-10-16 16:30:00 | AAPL | Stock | 2.6929 | 2.6936 | 2.6929 | 2.6936 | 20636.0 |
| 2006-10-16 17:00:00 | AAPL | Stock | 2.6929 | 2.6936 | 2.6921 | 2.6936 | 40684224.0 |
| 2006-10-16 17:30:00 | AAPL | Stock | 2.6936 | 2.6936 | 2.6921 | 2.6936 | 42028.0 |
| 2006-10-16 18:00:00 | AAPL | Stock | 2.6936 | 2.6936 | 2.6911 | 2.6911 | 237720.0 |
| 2006-10-16 18:30:00 | AAPL | Stock | 2.6936 | 2.6936 | 2.6936 | 2.6936 | 27916.0 |
| 2006-10-16 19:00:00 | AAPL | Stock | 2.695 | 2.695 | 2.6936 | 2.6936 | 10500.0 |
| 2006-10-16 07:00:00 | MSFT | Stock | 28.5 | 28.56 | 28.5 | 28.56 | 2200.0 |
| 2006-10-16 07:30:00 | MSFT | Stock | 28.57 | 28.57 | 28.5 | 28.57 | 2100.0 |
| 2006-10-16 08:00:00 | MSFT | Stock | 28.38 | 28.58 | 28.37 | 28.51 | 41458.0 |
| 2006-10-16 08:30:00 | MSFT | Stock | 28.49 | 28.53 | 28.46 | 28.47 | 24517.0 |
| 2006-10-16 09:00:00 | MSFT | Stock | 28.5 | 28.5 | 28.38 | 28.46 | 160731.0 |
| 2006-10-16 09:30:00 | MSFT | Stock | 28.48 | 28.5 | 28.4 | 28.42 | 5775096.0 |
| 2006-10-16 10:00:00 | MSFT | Stock | 28.42 | 28.59 | 28.4 | 28.58 | 4580019.0 |
| 2006-10-16 10:30:00 | MSFT | Stock | 28.582 | 28.6 | 28.51 | 28.56 | 3572031.0 |
| 2006-10-16 11:00:00 | MSFT | Stock | 28.57 | 28.58 | 28.5 | 28.56 | 2129481.0 |
| 2006-10-16 11:30:00 | MSFT | Stock | 28.56 | 28.59 | 28.45 | 28.46 | 4276610.0 |
| 2006-10-16 12:00:00 | MSFT | Stock | 28.47 | 28.55 | 28.37 | 28.4 | 3646514.0 |
| 2006-10-16 12:30:00 | MSFT | Stock | 28.4 | 28.4 | 28.33 | 28.34 | 2434025.0 |
| 2006-10-16 13:00:00 | MSFT | Stock | 28.34 | 28.47 | 28.33 | 28.44 | 2667323.0 |
| 2006-10-16 13:30:00 | MSFT | Stock | 28.45 | 28.47 | 28.37 | 28.45 | 2164702.0 |
| 2006-10-16 14:00:00 | MSFT | Stock | 28.46 | 28.48 | 28.4 | 28.48 | 2168919.0 |
| 2006-10-16 14:30:00 | MSFT | Stock | 28.48 | 28.5 | 28.42 | 28.44 | 2220808.0 |
| 2006-10-16 15:00:00 | MSFT | Stock | 28.442 | 28.51 | 28.43 | 28.51 | 1998981.0 |
| 2006-10-16 15:30:00 | MSFT | Stock | 28.51 | 28.53 | 28.42 | 28.46 | 9071334.0 |
| 2006-10-16 16:00:00 | MSFT | Stock | 28.46 | 28.5 | 28.418 | 28.418 | 615709.0 |
| 2006-10-16 16:30:00 | MSFT | Stock | 28.44 | 28.44 | 28.44 | 28.44 | 100.0 |
| 2006-10-16 17:00:00 | MSFT | Stock | 28.44 | 28.46 | 28.44 | 28.46 | 600.0 |
| 2006-10-16 17:30:00 | MSFT | Stock | 28.45 | 28.48 | 28.45 | 28.48 | 11850.0 |
| 2006-10-16 18:00:00 | MSFT | Stock | 28.45 | 28.48 | 28.45 | 28.48 | 200.0 |
| 2006-10-16 08:00:00 | NVDA | Stock | 0.5625 | 0.5625 | 0.5625 | 0.5625 | 12000.0 |
> showing 50 of 50,657 rows — these rows as CSV