PREVIEW / stock_30min / 2006-10-09
file: by_date/stock_30min/2006/2006-10-09.parquet size: 901 KB rows: 49,264 symbols: 2,376
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 |
|---|---|---|---|---|---|---|---|
| 2006-10-09 07:00:00 | AAPL | Stock | 2.6411 | 2.6411 | 2.6411 | 2.6411 | 2800.0 |
| 2006-10-09 08:00:00 | AAPL | Stock | 2.6411 | 2.6425 | 2.6375 | 2.6375 | 253512.0 |
| 2006-10-09 08:30:00 | AAPL | Stock | 2.6375 | 2.6421 | 2.6375 | 2.6407 | 306432.0 |
| 2006-10-09 09:00:00 | AAPL | Stock | 2.6393 | 2.6425 | 2.6336 | 2.6336 | 491008.0 |
| 2006-10-09 09:30:00 | AAPL | Stock | 2.6357 | 2.6457 | 2.6261 | 2.6296 | 61901924.0 |
| 2006-10-09 10:00:00 | AAPL | Stock | 2.6289 | 2.6436 | 2.6264 | 2.6343 | 42214984.0 |
| 2006-10-09 10:30:00 | AAPL | Stock | 2.6346 | 2.64 | 2.6304 | 2.6364 | 24107664.0 |
| 2006-10-09 11:00:00 | AAPL | Stock | 2.6361 | 2.6507 | 2.635 | 2.6475 | 25286548.0 |
| 2006-10-09 11:30:00 | AAPL | Stock | 2.6471 | 2.6618 | 2.6464 | 2.6482 | 44545144.0 |
| 2006-10-09 12:00:00 | AAPL | Stock | 2.6489 | 2.6604 | 2.6482 | 2.6568 | 16047416.0 |
| 2006-10-09 12:30:00 | AAPL | Stock | 2.6568 | 2.6768 | 2.6568 | 2.6696 | 34717788.0 |
| 2006-10-09 13:00:00 | AAPL | Stock | 2.6693 | 2.6771 | 2.665 | 2.6725 | 24628100.0 |
| 2006-10-09 13:30:00 | AAPL | Stock | 2.6729 | 2.675 | 2.6636 | 2.6657 | 17062808.0 |
| 2006-10-09 14:00:00 | AAPL | Stock | 2.6661 | 2.675 | 2.6643 | 2.6704 | 18806536.0 |
| 2006-10-09 14:30:00 | AAPL | Stock | 2.67 | 2.6811 | 2.6696 | 2.6786 | 37726052.0 |
| 2006-10-09 15:00:00 | AAPL | Stock | 2.6786 | 2.6814 | 2.6639 | 2.6646 | 38148880.0 |
| 2006-10-09 15:30:00 | AAPL | Stock | 2.6646 | 2.6728 | 2.6629 | 2.6629 | 37996728.0 |
| 2006-10-09 16:00:00 | AAPL | Stock | 2.6629 | 2.6639 | 2.6411 | 2.6636 | 2534644.0 |
| 2006-10-09 16:30:00 | AAPL | Stock | 2.6636 | 2.6654 | 2.6636 | 2.6643 | 3579576.0 |
| 2006-10-09 17:00:00 | AAPL | Stock | 2.6643 | 2.6654 | 2.6639 | 2.6639 | 117600.0 |
| 2006-10-09 17:30:00 | AAPL | Stock | 2.6643 | 2.6643 | 2.6643 | 2.6643 | 6244.0 |
| 2006-10-09 18:00:00 | AAPL | Stock | 2.6654 | 2.6657 | 2.6654 | 2.6657 | 98112.0 |
| 2006-10-09 19:00:00 | AAPL | Stock | 2.6661 | 2.6661 | 2.6661 | 2.6661 | 8400.0 |
| 2006-10-09 19:30:00 | AAPL | Stock | 2.6654 | 2.6654 | 2.6654 | 2.6654 | 2912.0 |
| 2006-10-09 06:30:00 | MSFT | Stock | 27.8 | 27.8 | 27.8 | 27.8 | 1000.0 |
| 2006-10-09 07:00:00 | MSFT | Stock | 27.79 | 27.79 | 27.79 | 27.79 | 700.0 |
| 2006-10-09 07:30:00 | MSFT | Stock | 27.75 | 27.75 | 27.75 | 27.75 | 800.0 |
| 2006-10-09 08:00:00 | MSFT | Stock | 27.75 | 27.79 | 27.7 | 27.72 | 5004.0 |
| 2006-10-09 08:30:00 | MSFT | Stock | 27.79 | 27.79 | 27.71 | 27.78 | 4303.0 |
| 2006-10-09 09:00:00 | MSFT | Stock | 27.78 | 27.8 | 27.73 | 27.8 | 146496.0 |
| 2006-10-09 09:30:00 | MSFT | Stock | 27.8 | 27.93 | 27.7 | 27.73 | 3469245.0 |
| 2006-10-09 10:00:00 | MSFT | Stock | 27.73 | 27.75 | 27.68 | 27.69 | 2265366.0 |
| 2006-10-09 10:30:00 | MSFT | Stock | 27.69 | 27.72 | 27.62 | 27.69 | 2533865.0 |
| 2006-10-09 11:00:00 | MSFT | Stock | 27.69 | 27.76 | 27.63 | 27.74 | 2632416.0 |
| 2006-10-09 11:30:00 | MSFT | Stock | 27.73 | 27.82 | 27.72 | 27.76 | 3133395.0 |
| 2006-10-09 12:00:00 | MSFT | Stock | 27.76 | 27.78 | 27.74 | 27.74 | 1028792.0 |
| 2006-10-09 12:30:00 | MSFT | Stock | 27.74 | 27.76 | 27.7 | 27.7 | 1266597.0 |
| 2006-10-09 13:00:00 | MSFT | Stock | 27.7 | 27.73 | 27.62 | 27.68 | 2810873.0 |
| 2006-10-09 13:30:00 | MSFT | Stock | 27.68 | 27.72 | 27.66 | 27.7 | 1626232.0 |
| 2006-10-09 14:00:00 | MSFT | Stock | 27.7 | 27.73 | 27.67 | 27.71 | 1814737.0 |
| 2006-10-09 14:30:00 | MSFT | Stock | 27.71 | 27.75 | 27.7 | 27.72 | 1279704.0 |
| 2006-10-09 15:00:00 | MSFT | Stock | 27.73 | 27.9 | 27.62 | 27.63 | 2149683.0 |
| 2006-10-09 15:30:00 | MSFT | Stock | 27.63 | 27.77 | 27.63 | 27.71 | 4464659.0 |
| 2006-10-09 16:00:00 | MSFT | Stock | 27.7 | 27.72 | 27.65 | 27.7 | 1339199.0 |
| 2006-10-09 16:30:00 | MSFT | Stock | 27.7 | 27.7 | 27.7 | 27.7 | 367289.0 |
| 2006-10-09 17:00:00 | MSFT | Stock | 27.69 | 27.69 | 27.69 | 27.69 | 100.0 |
| 2006-10-09 17:30:00 | MSFT | Stock | 27.69 | 27.75 | 27.67 | 27.75 | 5300.0 |
| 2006-10-09 19:30:00 | MSFT | Stock | 27.65 | 27.65 | 27.65 | 27.65 | 500.0 |
| 2006-10-09 08:00:00 | NVDA | Stock | 0.5117 | 0.5162 | 0.51 | 0.5162 | 432000.0 |
| 2006-10-09 08:30:00 | NVDA | Stock | 0.5125 | 0.5125 | 0.5123 | 0.5123 | 60000.0 |
> showing 50 of 49,264 rows — these rows as CSV