PREVIEW / stock_30min / 2005-11-23
file: by_date/stock_30min/2005/2005-11-23.parquet size: 843 KB rows: 45,241 symbols: 2,119
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-23 08:00:00 | AAPL | Stock | 2.39 | 2.3914 | 2.3764 | 2.3907 | 1026368.0 |
| 2005-11-23 08:30:00 | AAPL | Stock | 2.3896 | 2.3946 | 2.3886 | 2.3896 | 1174600.0 |
| 2005-11-23 09:00:00 | AAPL | Stock | 2.3886 | 2.39 | 2.3811 | 2.3811 | 1234408.0 |
| 2005-11-23 09:30:00 | AAPL | Stock | 2.3886 | 2.4089 | 2.3818 | 2.4018 | 85495032.0 |
| 2005-11-23 10:00:00 | AAPL | Stock | 2.4018 | 2.425 | 2.3979 | 2.4171 | 75919592.0 |
| 2005-11-23 10:30:00 | AAPL | Stock | 2.4171 | 2.4279 | 2.4168 | 2.4196 | 47679156.0 |
| 2005-11-23 11:00:00 | AAPL | Stock | 2.4193 | 2.4232 | 2.4079 | 2.4214 | 36271032.0 |
| 2005-11-23 11:30:00 | AAPL | Stock | 2.4214 | 2.4214 | 2.4107 | 2.4139 | 24236912.0 |
| 2005-11-23 12:00:00 | AAPL | Stock | 2.4136 | 2.4143 | 2.411 | 2.4132 | 17813740.0 |
| 2005-11-23 12:30:00 | AAPL | Stock | 2.4132 | 2.4229 | 2.4118 | 2.42 | 22063440.0 |
| 2005-11-23 13:00:00 | AAPL | Stock | 2.42 | 2.4214 | 2.4168 | 2.42 | 12415200.0 |
| 2005-11-23 13:30:00 | AAPL | Stock | 2.42 | 2.4204 | 2.4168 | 2.4179 | 10767092.0 |
| 2005-11-23 14:00:00 | AAPL | Stock | 2.4179 | 2.4186 | 2.4118 | 2.4168 | 21355684.0 |
| 2005-11-23 14:30:00 | AAPL | Stock | 2.4171 | 2.4189 | 2.3936 | 2.3961 | 40360376.0 |
| 2005-11-23 15:00:00 | AAPL | Stock | 2.3964 | 2.3982 | 2.3839 | 2.3921 | 49928564.0 |
| 2005-11-23 15:30:00 | AAPL | Stock | 2.3921 | 2.3971 | 2.3875 | 2.3968 | 31108028.0 |
| 2005-11-23 16:00:00 | AAPL | Stock | 2.3954 | 2.4011 | 2.3946 | 2.4011 | 1261540.0 |
| 2005-11-23 16:30:00 | AAPL | Stock | 2.4007 | 2.4018 | 2.3975 | 2.4018 | 375480.0 |
| 2005-11-23 17:00:00 | AAPL | Stock | 2.4018 | 2.4064 | 2.3968 | 2.4004 | 1699684.0 |
| 2005-11-23 17:30:00 | AAPL | Stock | 2.4004 | 2.4018 | 2.4004 | 2.4018 | 22400.0 |
| 2005-11-23 18:00:00 | AAPL | Stock | 2.4036 | 2.4039 | 2.4004 | 2.4036 | 39900.0 |
| 2005-11-23 08:00:00 | MSFT | Stock | 27.85 | 28.0 | 27.85 | 28.0 | 23455.0 |
| 2005-11-23 08:30:00 | MSFT | Stock | 27.96 | 27.96 | 27.92 | 27.92 | 7200.0 |
| 2005-11-23 09:00:00 | MSFT | Stock | 27.91 | 27.94 | 27.86 | 27.92 | 4038175.0 |
| 2005-11-23 09:30:00 | MSFT | Stock | 27.92 | 27.92 | 27.74 | 27.88 | 8864173.0 |
| 2005-11-23 10:00:00 | MSFT | Stock | 27.88 | 27.98 | 27.84 | 27.96 | 4127090.0 |
| 2005-11-23 10:30:00 | MSFT | Stock | 27.97 | 28.01 | 27.919 | 27.98 | 3763145.0 |
| 2005-11-23 11:00:00 | MSFT | Stock | 27.98 | 28.0 | 27.9 | 27.96 | 2948344.0 |
| 2005-11-23 11:30:00 | MSFT | Stock | 27.96 | 28.09 | 27.96 | 27.98 | 6240008.0 |
| 2005-11-23 12:00:00 | MSFT | Stock | 27.97 | 27.981 | 27.88 | 27.95 | 5889287.0 |
| 2005-11-23 12:30:00 | MSFT | Stock | 27.95 | 28.0 | 27.93 | 27.95 | 5777850.0 |
| 2005-11-23 13:00:00 | MSFT | Stock | 27.95 | 27.99 | 27.9 | 27.95 | 3036424.0 |
| 2005-11-23 13:30:00 | MSFT | Stock | 27.95 | 27.99 | 27.95 | 27.98 | 4169795.0 |
| 2005-11-23 14:00:00 | MSFT | Stock | 27.98 | 28.01 | 27.96 | 28.01 | 4136453.0 |
| 2005-11-23 14:30:00 | MSFT | Stock | 28.01 | 28.04 | 27.93 | 27.96 | 3996228.0 |
| 2005-11-23 15:00:00 | MSFT | Stock | 27.96 | 27.96 | 27.88 | 27.93 | 3672414.0 |
| 2005-11-23 15:30:00 | MSFT | Stock | 27.92 | 27.94 | 27.85 | 27.92 | 8460083.0 |
| 2005-11-23 16:00:00 | MSFT | Stock | 27.92 | 27.96 | 27.89 | 27.94 | 283714.0 |
| 2005-11-23 16:30:00 | MSFT | Stock | 27.93 | 27.93 | 27.92 | 27.92 | 3200.0 |
| 2005-11-23 17:00:00 | MSFT | Stock | 27.93 | 27.95 | 27.92 | 27.93 | 179250.0 |
| 2005-11-23 17:30:00 | MSFT | Stock | 27.92 | 27.92 | 27.92 | 27.92 | 1700.0 |
| 2005-11-23 18:00:00 | MSFT | Stock | 27.91 | 28.0 | 27.88 | 27.88 | 7349.0 |
| 2005-11-23 08:00:00 | NVDA | Stock | 0.3157 | 0.3157 | 0.3157 | 0.3157 | 12000.0 |
| 2005-11-23 08:30:00 | NVDA | Stock | 0.3157 | 0.3157 | 0.3157 | 0.3157 | 120000.0 |
| 2005-11-23 09:00:00 | NVDA | Stock | 0.3153 | 0.3158 | 0.3152 | 0.3158 | 684000.0 |
| 2005-11-23 09:30:00 | NVDA | Stock | 0.3154 | 0.3183 | 0.3138 | 0.317 | 53875440.0 |
| 2005-11-23 10:00:00 | NVDA | Stock | 0.3171 | 0.3182 | 0.3148 | 0.3164 | 41421240.0 |
| 2005-11-23 10:30:00 | NVDA | Stock | 0.3165 | 0.3172 | 0.3153 | 0.3156 | 21975480.0 |
| 2005-11-23 11:00:00 | NVDA | Stock | 0.3155 | 0.3156 | 0.3125 | 0.3149 | 45032400.0 |
| 2005-11-23 11:30:00 | NVDA | Stock | 0.3149 | 0.3155 | 0.3142 | 0.3151 | 17740800.0 |
> showing 50 of 45,241 rows — these rows as CSV