PREVIEW / stock_30min / 2005-08-23
file: by_date/stock_30min/2005/2005-08-23.parquet size: 823 KB rows: 44,515 symbols: 2,067
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-23 08:00:00 | AAPL | Stock | 1.6425 | 1.6496 | 1.6414 | 1.6418 | 36708.0 |
| 2005-08-23 08:30:00 | AAPL | Stock | 1.6414 | 1.6429 | 1.6414 | 1.6421 | 94248.0 |
| 2005-08-23 09:00:00 | AAPL | Stock | 1.6421 | 1.6421 | 1.6311 | 1.6382 | 1727628.0 |
| 2005-08-23 09:30:00 | AAPL | Stock | 1.6375 | 1.6464 | 1.6307 | 1.6357 | 42395332.0 |
| 2005-08-23 10:00:00 | AAPL | Stock | 1.6357 | 1.6436 | 1.6307 | 1.6425 | 25385332.0 |
| 2005-08-23 10:30:00 | AAPL | Stock | 1.6429 | 1.6429 | 1.6314 | 1.6354 | 17626560.0 |
| 2005-08-23 11:00:00 | AAPL | Stock | 1.6354 | 1.6354 | 1.6271 | 1.6299 | 23633204.0 |
| 2005-08-23 11:30:00 | AAPL | Stock | 1.6296 | 1.6311 | 1.6214 | 1.6214 | 18827508.0 |
| 2005-08-23 12:00:00 | AAPL | Stock | 1.6218 | 1.6307 | 1.6186 | 1.6282 | 25108440.0 |
| 2005-08-23 12:30:00 | AAPL | Stock | 1.6282 | 1.6357 | 1.6268 | 1.6296 | 16568860.0 |
| 2005-08-23 13:00:00 | AAPL | Stock | 1.63 | 1.6304 | 1.625 | 1.6275 | 14733068.0 |
| 2005-08-23 13:30:00 | AAPL | Stock | 1.6275 | 1.6321 | 1.6268 | 1.6293 | 13429752.0 |
| 2005-08-23 14:00:00 | AAPL | Stock | 1.6293 | 1.6389 | 1.6271 | 1.6386 | 17526880.0 |
| 2005-08-23 14:30:00 | AAPL | Stock | 1.6386 | 1.6421 | 1.6357 | 1.6396 | 30330300.0 |
| 2005-08-23 15:00:00 | AAPL | Stock | 1.6396 | 1.6404 | 1.6307 | 1.6361 | 20471444.0 |
| 2005-08-23 15:30:00 | AAPL | Stock | 1.6361 | 1.6382 | 1.6321 | 1.6329 | 22686188.0 |
| 2005-08-23 16:00:00 | AAPL | Stock | 1.6332 | 1.6336 | 1.6318 | 1.6336 | 528668.0 |
| 2005-08-23 16:30:00 | AAPL | Stock | 1.6324 | 1.6336 | 1.6324 | 1.6336 | 85344.0 |
| 2005-08-23 17:00:00 | AAPL | Stock | 1.6339 | 1.6339 | 1.6304 | 1.6304 | 53144.0 |
| 2005-08-23 17:30:00 | AAPL | Stock | 1.6304 | 1.6304 | 1.6304 | 1.6304 | 5600.0 |
| 2005-08-23 18:00:00 | AAPL | Stock | 1.6304 | 1.6304 | 1.6304 | 1.6304 | 42000.0 |
| 2005-08-23 08:00:00 | MSFT | Stock | 26.92 | 26.92 | 26.82 | 26.88 | 5996.0 |
| 2005-08-23 08:30:00 | MSFT | Stock | 26.89 | 26.9 | 26.88 | 26.89 | 2900.0 |
| 2005-08-23 09:00:00 | MSFT | Stock | 26.88 | 26.9 | 26.83 | 26.83 | 69901.0 |
| 2005-08-23 09:30:00 | MSFT | Stock | 26.84 | 26.92 | 26.8 | 26.84 | 5786159.0 |
| 2005-08-23 10:00:00 | MSFT | Stock | 26.84 | 26.9 | 26.81 | 26.89 | 3473467.0 |
| 2005-08-23 10:30:00 | MSFT | Stock | 26.889 | 26.92 | 26.82 | 26.82 | 3136577.0 |
| 2005-08-23 11:00:00 | MSFT | Stock | 26.82 | 26.84 | 26.8 | 26.83 | 2242609.0 |
| 2005-08-23 11:30:00 | MSFT | Stock | 26.82 | 26.83 | 26.75 | 26.78 | 3110859.0 |
| 2005-08-23 12:00:00 | MSFT | Stock | 26.78 | 26.81 | 26.75 | 26.78 | 1912093.0 |
| 2005-08-23 12:30:00 | MSFT | Stock | 26.77 | 26.85 | 26.74 | 26.77 | 1739302.0 |
| 2005-08-23 13:00:00 | MSFT | Stock | 26.78 | 26.858 | 26.768 | 26.85 | 2675223.0 |
| 2005-08-23 13:30:00 | MSFT | Stock | 26.85 | 27.0 | 26.84 | 26.94 | 4743949.0 |
| 2005-08-23 14:00:00 | MSFT | Stock | 26.95 | 27.0 | 26.92 | 26.97 | 2308180.0 |
| 2005-08-23 14:30:00 | MSFT | Stock | 26.96 | 27.07 | 26.95 | 27.05 | 5367555.0 |
| 2005-08-23 15:00:00 | MSFT | Stock | 27.06 | 27.06 | 26.94 | 26.94 | 4305365.0 |
| 2005-08-23 15:30:00 | MSFT | Stock | 26.94 | 27.07 | 26.88 | 26.88 | 6133214.0 |
| 2005-08-23 16:00:00 | MSFT | Stock | 26.88 | 26.9 | 26.86 | 26.87 | 238504.0 |
| 2005-08-23 16:30:00 | MSFT | Stock | 26.86 | 26.87 | 26.86 | 26.87 | 39996.0 |
| 2005-08-23 17:00:00 | MSFT | Stock | 26.89 | 26.89 | 26.89 | 26.89 | 100.0 |
| 2005-08-23 17:30:00 | MSFT | Stock | 26.87 | 26.87 | 26.86 | 26.86 | 2800.0 |
| 2005-08-23 18:00:00 | MSFT | Stock | 26.86 | 26.87 | 26.86 | 26.86 | 4245.0 |
| 2005-08-23 09:30:00 | NVDA | Stock | 0.2411 | 0.2437 | 0.2411 | 0.2418 | 34121880.0 |
| 2005-08-23 10:00:00 | NVDA | Stock | 0.242 | 0.2437 | 0.2418 | 0.2436 | 23954520.0 |
| 2005-08-23 10:30:00 | NVDA | Stock | 0.2436 | 0.2442 | 0.2425 | 0.2433 | 17418720.0 |
| 2005-08-23 11:00:00 | NVDA | Stock | 0.2433 | 0.2433 | 0.2421 | 0.2426 | 13604760.0 |
| 2005-08-23 11:30:00 | NVDA | Stock | 0.2426 | 0.2427 | 0.2408 | 0.241 | 15321360.0 |
| 2005-08-23 12:00:00 | NVDA | Stock | 0.241 | 0.2417 | 0.2408 | 0.2413 | 10967880.0 |
| 2005-08-23 12:30:00 | NVDA | Stock | 0.2413 | 0.2417 | 0.2409 | 0.2411 | 6941760.0 |
| 2005-08-23 13:00:00 | NVDA | Stock | 0.2411 | 0.2415 | 0.2402 | 0.2403 | 7461840.0 |
> showing 50 of 44,515 rows — these rows as CSV