PREVIEW / stock_30min / 2005-08-02
file: by_date/stock_30min/2005/2005-08-02.parquet size: 862 KB rows: 46,275 symbols: 2,051
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-02 08:00:00 | AAPL | Stock | 1.525 | 1.5286 | 1.525 | 1.5286 | 28784.0 |
| 2005-08-02 08:30:00 | AAPL | Stock | 1.5282 | 1.5282 | 1.5261 | 1.5261 | 70000.0 |
| 2005-08-02 09:00:00 | AAPL | Stock | 1.5268 | 1.5336 | 1.5268 | 1.5271 | 614824.0 |
| 2005-08-02 09:30:00 | AAPL | Stock | 1.5318 | 1.5368 | 1.5218 | 1.5307 | 26329576.0 |
| 2005-08-02 10:00:00 | AAPL | Stock | 1.5304 | 1.5446 | 1.5286 | 1.5425 | 30029468.0 |
| 2005-08-02 10:30:00 | AAPL | Stock | 1.5425 | 1.5536 | 1.5411 | 1.5461 | 35348096.0 |
| 2005-08-02 11:00:00 | AAPL | Stock | 1.5461 | 1.5464 | 1.5425 | 1.5443 | 28080220.0 |
| 2005-08-02 11:30:00 | AAPL | Stock | 1.5443 | 1.5471 | 1.5382 | 1.5457 | 16716308.0 |
| 2005-08-02 12:00:00 | AAPL | Stock | 1.5461 | 1.5529 | 1.545 | 1.5521 | 11054344.0 |
| 2005-08-02 12:30:00 | AAPL | Stock | 1.5521 | 1.5525 | 1.5432 | 1.5443 | 12117868.0 |
| 2005-08-02 13:00:00 | AAPL | Stock | 1.5443 | 1.5504 | 1.5414 | 1.5464 | 28383460.0 |
| 2005-08-02 13:30:00 | AAPL | Stock | 1.5468 | 1.5479 | 1.5436 | 1.545 | 14016632.0 |
| 2005-08-02 14:00:00 | AAPL | Stock | 1.5454 | 1.5486 | 1.545 | 1.5464 | 13300448.0 |
| 2005-08-02 14:30:00 | AAPL | Stock | 1.5461 | 1.5464 | 1.5407 | 1.5429 | 21634228.0 |
| 2005-08-02 15:00:00 | AAPL | Stock | 1.5425 | 1.5454 | 1.5407 | 1.5425 | 18913720.0 |
| 2005-08-02 15:30:00 | AAPL | Stock | 1.5429 | 1.5454 | 1.5418 | 1.5425 | 33472488.0 |
| 2005-08-02 16:00:00 | AAPL | Stock | 1.5443 | 1.5457 | 1.5396 | 1.5421 | 550256.0 |
| 2005-08-02 16:30:00 | AAPL | Stock | 1.5421 | 1.5421 | 1.54 | 1.54 | 28812.0 |
| 2005-08-02 17:00:00 | AAPL | Stock | 1.5472 | 1.5472 | 1.5404 | 1.5404 | 156800.0 |
| 2005-08-02 17:30:00 | AAPL | Stock | 1.5404 | 1.5443 | 1.5404 | 1.5423 | 60368.0 |
| 2005-08-02 18:00:00 | AAPL | Stock | 1.54 | 1.54 | 1.54 | 1.54 | 45528.0 |
| 2005-08-02 07:30:00 | MSFT | Stock | 25.95 | 25.95 | 25.95 | 25.95 | 1400.0 |
| 2005-08-02 08:00:00 | MSFT | Stock | 25.95 | 25.96 | 25.94 | 25.96 | 11681.0 |
| 2005-08-02 08:30:00 | MSFT | Stock | 25.95 | 25.96 | 25.93 | 25.93 | 10593.0 |
| 2005-08-02 09:00:00 | MSFT | Stock | 25.94 | 25.94 | 25.89 | 25.91 | 82110.0 |
| 2005-08-02 09:30:00 | MSFT | Stock | 25.9 | 26.15 | 25.87 | 26.13 | 12261883.0 |
| 2005-08-02 10:00:00 | MSFT | Stock | 26.12 | 26.18 | 26.09 | 26.16 | 7630906.0 |
| 2005-08-02 10:30:00 | MSFT | Stock | 26.16 | 26.36 | 26.15 | 26.36 | 11962997.0 |
| 2005-08-02 11:00:00 | MSFT | Stock | 26.36 | 26.44 | 26.25 | 26.41 | 10810237.0 |
| 2005-08-02 11:30:00 | MSFT | Stock | 26.41 | 26.6 | 26.25 | 26.57 | 11413398.0 |
| 2005-08-02 12:00:00 | MSFT | Stock | 26.57 | 26.59 | 26.45 | 26.49 | 9092667.0 |
| 2005-08-02 12:30:00 | MSFT | Stock | 26.49 | 26.541 | 26.46 | 26.51 | 4785976.0 |
| 2005-08-02 13:00:00 | MSFT | Stock | 26.51 | 26.52 | 26.38 | 26.462 | 7565906.0 |
| 2005-08-02 13:30:00 | MSFT | Stock | 26.47 | 26.57 | 26.462 | 26.52 | 8406899.0 |
| 2005-08-02 14:00:00 | MSFT | Stock | 26.52 | 26.55 | 26.45 | 26.48 | 8379359.0 |
| 2005-08-02 14:30:00 | MSFT | Stock | 26.48 | 26.65 | 26.46 | 26.64 | 9595962.0 |
| 2005-08-02 15:00:00 | MSFT | Stock | 26.63 | 26.8 | 26.59 | 26.78 | 13899317.0 |
| 2005-08-02 15:30:00 | MSFT | Stock | 26.78 | 26.901 | 26.6 | 26.81 | 19121531.0 |
| 2005-08-02 16:00:00 | MSFT | Stock | 26.81 | 26.86 | 26.78 | 26.84 | 696690.0 |
| 2005-08-02 16:30:00 | MSFT | Stock | 26.84 | 26.86 | 26.81 | 26.84 | 80558.0 |
| 2005-08-02 17:00:00 | MSFT | Stock | 26.83 | 26.86 | 26.525 | 26.86 | 18348.0 |
| 2005-08-02 17:30:00 | MSFT | Stock | 26.86 | 26.87 | 26.516 | 26.87 | 59024.0 |
| 2005-08-02 18:00:00 | MSFT | Stock | 26.86 | 26.86 | 26.72 | 26.78 | 104710.0 |
| 2005-08-02 08:00:00 | NVDA | Stock | 0.2272 | 0.2277 | 0.2267 | 0.2277 | 288000.0 |
| 2005-08-02 08:30:00 | NVDA | Stock | 0.2276 | 0.228 | 0.2275 | 0.2275 | 744000.0 |
| 2005-08-02 09:00:00 | NVDA | Stock | 0.2271 | 0.2292 | 0.2267 | 0.2292 | 732000.0 |
| 2005-08-02 09:30:00 | NVDA | Stock | 0.2292 | 0.2307 | 0.2288 | 0.23 | 62660520.0 |
| 2005-08-02 10:00:00 | NVDA | Stock | 0.23 | 0.2318 | 0.2298 | 0.2305 | 46764840.0 |
| 2005-08-02 10:30:00 | NVDA | Stock | 0.2305 | 0.2308 | 0.23 | 0.2301 | 18527760.0 |
| 2005-08-02 11:00:00 | NVDA | Stock | 0.2301 | 0.2309 | 0.2294 | 0.2307 | 33909960.0 |
> showing 50 of 46,275 rows — these rows as CSV