PREVIEW / stock_30min / 2005-08-05
file: by_date/stock_30min/2005/2005-08-05.parquet size: 840 KB rows: 45,297 symbols: 2,048
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-05 08:00:00 | AAPL | Stock | 1.5232 | 1.5243 | 1.5204 | 1.5204 | 522200.0 |
| 2005-08-05 08:30:00 | AAPL | Stock | 1.5214 | 1.5214 | 1.5164 | 1.5207 | 299600.0 |
| 2005-08-05 09:00:00 | AAPL | Stock | 1.5182 | 1.5207 | 1.5139 | 1.5207 | 908544.0 |
| 2005-08-05 09:30:00 | AAPL | Stock | 1.5175 | 1.5486 | 1.5007 | 1.5425 | 61419904.0 |
| 2005-08-05 10:00:00 | AAPL | Stock | 1.5418 | 1.5425 | 1.5307 | 1.5368 | 33789700.0 |
| 2005-08-05 10:30:00 | AAPL | Stock | 1.5368 | 1.5375 | 1.5307 | 1.5346 | 14123984.0 |
| 2005-08-05 11:00:00 | AAPL | Stock | 1.5343 | 1.5368 | 1.5304 | 1.5318 | 8243760.0 |
| 2005-08-05 11:30:00 | AAPL | Stock | 1.5318 | 1.5364 | 1.5304 | 1.5311 | 7594720.0 |
| 2005-08-05 12:00:00 | AAPL | Stock | 1.5311 | 1.5393 | 1.5307 | 1.5386 | 10463768.0 |
| 2005-08-05 12:30:00 | AAPL | Stock | 1.5393 | 1.5393 | 1.5329 | 1.5371 | 9595068.0 |
| 2005-08-05 13:00:00 | AAPL | Stock | 1.5368 | 1.5479 | 1.5364 | 1.5439 | 23201976.0 |
| 2005-08-05 13:30:00 | AAPL | Stock | 1.5439 | 1.5443 | 1.5393 | 1.5404 | 8892212.0 |
| 2005-08-05 14:00:00 | AAPL | Stock | 1.5404 | 1.5407 | 1.5357 | 1.5364 | 7206584.0 |
| 2005-08-05 14:30:00 | AAPL | Stock | 1.5368 | 1.5429 | 1.5361 | 1.5379 | 13270040.0 |
| 2005-08-05 15:00:00 | AAPL | Stock | 1.5382 | 1.5411 | 1.5364 | 1.5404 | 12942188.0 |
| 2005-08-05 15:30:00 | AAPL | Stock | 1.5404 | 1.5418 | 1.5346 | 1.5357 | 20402536.0 |
| 2005-08-05 16:00:00 | AAPL | Stock | 1.5357 | 1.5407 | 1.5086 | 1.5293 | 2559844.0 |
| 2005-08-05 16:30:00 | AAPL | Stock | 1.5293 | 1.5293 | 1.5286 | 1.5293 | 224700.0 |
| 2005-08-05 17:00:00 | AAPL | Stock | 1.5314 | 1.5314 | 1.5314 | 1.5314 | 19600.0 |
| 2005-08-05 17:30:00 | AAPL | Stock | 1.5314 | 1.5314 | 1.5286 | 1.5286 | 42000.0 |
| 2005-08-05 18:00:00 | AAPL | Stock | 1.5289 | 1.5289 | 1.5286 | 1.5286 | 19600.0 |
| 2005-08-05 08:00:00 | MSFT | Stock | 27.35 | 27.44 | 27.35 | 27.39 | 35028.0 |
| 2005-08-05 08:30:00 | MSFT | Stock | 27.39 | 27.4 | 27.3 | 27.34 | 38922.0 |
| 2005-08-05 09:00:00 | MSFT | Stock | 27.34 | 27.35 | 27.26 | 27.26 | 121981.0 |
| 2005-08-05 09:30:00 | MSFT | Stock | 27.29 | 27.54 | 27.25 | 27.43 | 12166134.0 |
| 2005-08-05 10:00:00 | MSFT | Stock | 27.43 | 27.46 | 27.35 | 27.42 | 6152095.0 |
| 2005-08-05 10:30:00 | MSFT | Stock | 27.42 | 27.56 | 27.42 | 27.51 | 6043973.0 |
| 2005-08-05 11:00:00 | MSFT | Stock | 27.5 | 27.53 | 27.47 | 27.48 | 3864975.0 |
| 2005-08-05 11:30:00 | MSFT | Stock | 27.48 | 27.56 | 27.45 | 27.54 | 4318251.0 |
| 2005-08-05 12:00:00 | MSFT | Stock | 27.53 | 27.58 | 27.53 | 27.55 | 3272305.0 |
| 2005-08-05 12:30:00 | MSFT | Stock | 27.54 | 27.6 | 27.529 | 27.6 | 3404418.0 |
| 2005-08-05 13:00:00 | MSFT | Stock | 27.59 | 27.75 | 27.58 | 27.7 | 7203626.0 |
| 2005-08-05 13:30:00 | MSFT | Stock | 27.7 | 27.75 | 27.66 | 27.66 | 5395652.0 |
| 2005-08-05 14:00:00 | MSFT | Stock | 27.66 | 27.73 | 27.64 | 27.72 | 4075682.0 |
| 2005-08-05 14:30:00 | MSFT | Stock | 27.71 | 27.82 | 27.7 | 27.75 | 7110576.0 |
| 2005-08-05 15:00:00 | MSFT | Stock | 27.75 | 27.88 | 27.74 | 27.88 | 4405526.0 |
| 2005-08-05 15:30:00 | MSFT | Stock | 27.87 | 27.94 | 27.61 | 27.77 | 12475680.0 |
| 2005-08-05 16:00:00 | MSFT | Stock | 27.76 | 27.82 | 27.48 | 27.75 | 786718.0 |
| 2005-08-05 16:30:00 | MSFT | Stock | 27.75 | 27.75 | 27.72 | 27.75 | 4530.0 |
| 2005-08-05 17:00:00 | MSFT | Stock | 27.76 | 27.77 | 27.7 | 27.7 | 2640.0 |
| 2005-08-05 17:30:00 | MSFT | Stock | 27.75 | 27.76 | 27.73 | 27.76 | 2100.0 |
| 2005-08-05 18:00:00 | MSFT | Stock | 27.76 | 27.8 | 27.75 | 27.8 | 3330.0 |
| 2005-08-05 08:00:00 | NVDA | Stock | 0.2296 | 0.2317 | 0.2296 | 0.2317 | 228000.0 |
| 2005-08-05 08:30:00 | NVDA | Stock | 0.2312 | 0.2312 | 0.2293 | 0.2293 | 138000.0 |
| 2005-08-05 09:00:00 | NVDA | Stock | 0.2292 | 0.2292 | 0.2282 | 0.2282 | 528000.0 |
| 2005-08-05 09:30:00 | NVDA | Stock | 0.2292 | 0.2326 | 0.2277 | 0.2316 | 73929600.0 |
| 2005-08-05 10:00:00 | NVDA | Stock | 0.2315 | 0.233 | 0.23 | 0.2307 | 96172440.0 |
| 2005-08-05 10:30:00 | NVDA | Stock | 0.2307 | 0.2327 | 0.2306 | 0.2327 | 65456280.0 |
| 2005-08-05 11:00:00 | NVDA | Stock | 0.2327 | 0.2332 | 0.2317 | 0.2319 | 33423000.0 |
| 2005-08-05 11:30:00 | NVDA | Stock | 0.2319 | 0.2331 | 0.2317 | 0.2321 | 32747280.0 |
> showing 50 of 45,297 rows — these rows as CSV