PREVIEW / stock_30min / 2005-08-01
file: by_date/stock_30min/2005/2005-08-01.parquet size: 850 KB rows: 46,006 symbols: 2,063
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-08-01 08:00:00 | AAPL | Stock | 1.5232 | 1.5232 | 1.5111 | 1.5214 | 411572.0 |
| 2005-08-01 08:30:00 | AAPL | Stock | 1.5232 | 1.525 | 1.5196 | 1.5214 | 383152.0 |
| 2005-08-01 09:00:00 | AAPL | Stock | 1.5214 | 1.5268 | 1.5214 | 1.5214 | 1004752.0 |
| 2005-08-01 09:30:00 | AAPL | Stock | 1.5204 | 1.5361 | 1.515 | 1.5268 | 44662492.0 |
| 2005-08-01 10:00:00 | AAPL | Stock | 1.5268 | 1.5275 | 1.5029 | 1.5164 | 46494728.0 |
| 2005-08-01 10:30:00 | AAPL | Stock | 1.5171 | 1.5196 | 1.5111 | 1.5182 | 23762928.0 |
| 2005-08-01 11:00:00 | AAPL | Stock | 1.5186 | 1.5225 | 1.5139 | 1.5218 | 19000324.0 |
| 2005-08-01 11:30:00 | AAPL | Stock | 1.5218 | 1.5307 | 1.5214 | 1.5293 | 28019292.0 |
| 2005-08-01 12:00:00 | AAPL | Stock | 1.5293 | 1.5321 | 1.5271 | 1.5289 | 13736464.0 |
| 2005-08-01 12:30:00 | AAPL | Stock | 1.5293 | 1.5314 | 1.5157 | 1.5286 | 13717844.0 |
| 2005-08-01 13:00:00 | AAPL | Stock | 1.5289 | 1.5304 | 1.5171 | 1.5268 | 18968068.0 |
| 2005-08-01 13:30:00 | AAPL | Stock | 1.5268 | 1.5275 | 1.5236 | 1.5254 | 10290588.0 |
| 2005-08-01 14:00:00 | AAPL | Stock | 1.5257 | 1.5343 | 1.525 | 1.5339 | 21116760.0 |
| 2005-08-01 14:30:00 | AAPL | Stock | 1.5343 | 1.5386 | 1.5304 | 1.5304 | 22851752.0 |
| 2005-08-01 15:00:00 | AAPL | Stock | 1.5307 | 1.5339 | 1.5293 | 1.5304 | 12013148.0 |
| 2005-08-01 15:30:00 | AAPL | Stock | 1.5304 | 1.5329 | 1.525 | 1.5254 | 26426960.0 |
| 2005-08-01 16:00:00 | AAPL | Stock | 1.5257 | 1.5279 | 1.5214 | 1.5268 | 1349964.0 |
| 2005-08-01 16:30:00 | AAPL | Stock | 1.5254 | 1.5268 | 1.5254 | 1.5268 | 105700.0 |
| 2005-08-01 17:00:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.525 | 1.5268 | 96796.0 |
| 2005-08-01 17:30:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5254 | 1.5254 | 72800.0 |
| 2005-08-01 18:00:00 | AAPL | Stock | 1.5254 | 1.5254 | 1.5254 | 1.5254 | 53424.0 |
| 2005-08-01 07:30:00 | MSFT | Stock | 25.8 | 25.8 | 25.76 | 25.76 | 106500.0 |
| 2005-08-01 08:00:00 | MSFT | Stock | 25.76 | 26.0 | 25.73 | 25.78 | 107582.0 |
| 2005-08-01 08:30:00 | MSFT | Stock | 25.78 | 25.8 | 25.77 | 25.79 | 32525.0 |
| 2005-08-01 09:00:00 | MSFT | Stock | 25.79 | 25.82 | 25.61 | 25.82 | 138978.0 |
| 2005-08-01 09:30:00 | MSFT | Stock | 25.81 | 25.92 | 25.76 | 25.92 | 8883021.0 |
| 2005-08-01 10:00:00 | MSFT | Stock | 25.91 | 25.97 | 25.89 | 25.97 | 5728018.0 |
| 2005-08-01 10:30:00 | MSFT | Stock | 25.97 | 25.98 | 25.85 | 25.89 | 6717283.0 |
| 2005-08-01 11:00:00 | MSFT | Stock | 25.89 | 25.92 | 25.85 | 25.88 | 3042809.0 |
| 2005-08-01 11:30:00 | MSFT | Stock | 25.88 | 25.94 | 25.87 | 25.938 | 2396364.0 |
| 2005-08-01 12:00:00 | MSFT | Stock | 25.94 | 25.971 | 25.91 | 25.95 | 3892309.0 |
| 2005-08-01 12:30:00 | MSFT | Stock | 25.94 | 25.99 | 25.93 | 25.94 | 3152679.0 |
| 2005-08-01 13:00:00 | MSFT | Stock | 25.94 | 25.96 | 25.91 | 25.91 | 2088378.0 |
| 2005-08-01 13:30:00 | MSFT | Stock | 25.91 | 25.92 | 25.9 | 25.92 | 1870492.0 |
| 2005-08-01 14:00:00 | MSFT | Stock | 25.92 | 26.05 | 25.91 | 25.99 | 7360768.0 |
| 2005-08-01 14:30:00 | MSFT | Stock | 26.0 | 26.04 | 25.969 | 25.97 | 4085414.0 |
| 2005-08-01 15:00:00 | MSFT | Stock | 25.97 | 26.01 | 25.96 | 25.98 | 3573326.0 |
| 2005-08-01 15:30:00 | MSFT | Stock | 25.98 | 25.99 | 25.91 | 25.91 | 6500199.0 |
| 2005-08-01 16:00:00 | MSFT | Stock | 25.9 | 25.97 | 25.85 | 25.88 | 401846.0 |
| 2005-08-01 16:30:00 | MSFT | Stock | 25.86 | 25.92 | 25.86 | 25.92 | 83018.0 |
| 2005-08-01 17:00:00 | MSFT | Stock | 25.87 | 25.92 | 25.87 | 25.9 | 5324.0 |
| 2005-08-01 17:30:00 | MSFT | Stock | 25.88 | 25.9 | 25.87 | 25.89 | 6800.0 |
| 2005-08-01 18:00:00 | MSFT | Stock | 25.89 | 25.9 | 25.89 | 25.89 | 3740.0 |
| 2005-08-01 09:00:00 | NVDA | Stock | 0.2257 | 0.227 | 0.2257 | 0.2269 | 699000.0 |
| 2005-08-01 09:30:00 | NVDA | Stock | 0.2268 | 0.2277 | 0.2258 | 0.2273 | 43037640.0 |
| 2005-08-01 10:00:00 | NVDA | Stock | 0.2275 | 0.2286 | 0.2266 | 0.2272 | 39827880.0 |
| 2005-08-01 10:30:00 | NVDA | Stock | 0.2272 | 0.2272 | 0.2254 | 0.2267 | 26859360.0 |
| 2005-08-01 11:00:00 | NVDA | Stock | 0.2267 | 0.2267 | 0.2254 | 0.226 | 17781600.0 |
| 2005-08-01 11:30:00 | NVDA | Stock | 0.226 | 0.2264 | 0.2253 | 0.2254 | 21086640.0 |
| 2005-08-01 12:00:00 | NVDA | Stock | 0.2256 | 0.2269 | 0.2255 | 0.2265 | 12629880.0 |
> showing 50 of 46,006 rows — these rows as CSV