PREVIEW / stock_30min / 2006-09-14
file: by_date/stock_30min/2006/2006-09-14.parquet size: 925 KB rows: 50,304 symbols: 2,363
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-09-14 06:00:00 | AAPL | Stock | 2.6668 | 2.6761 | 2.6668 | 2.6761 | 16800.0 |
| 2006-09-14 07:00:00 | AAPL | Stock | 2.6586 | 2.6629 | 2.6571 | 2.6629 | 33600.0 |
| 2006-09-14 07:30:00 | AAPL | Stock | 2.6636 | 2.6661 | 2.6607 | 2.6607 | 237524.0 |
| 2006-09-14 08:00:00 | AAPL | Stock | 2.6618 | 2.6618 | 2.6368 | 2.6429 | 4209016.0 |
| 2006-09-14 08:30:00 | AAPL | Stock | 2.6454 | 2.6468 | 2.6361 | 2.6375 | 2109912.0 |
| 2006-09-14 09:00:00 | AAPL | Stock | 2.6361 | 2.6375 | 2.6325 | 2.6329 | 1933176.0 |
| 2006-09-14 09:30:00 | AAPL | Stock | 2.6329 | 2.6454 | 2.6236 | 2.6364 | 108690288.0 |
| 2006-09-14 10:00:00 | AAPL | Stock | 2.6367 | 2.66 | 2.6321 | 2.6432 | 101659012.0 |
| 2006-09-14 10:30:00 | AAPL | Stock | 2.6432 | 2.665 | 2.6379 | 2.6593 | 93885876.0 |
| 2006-09-14 11:00:00 | AAPL | Stock | 2.6593 | 2.6668 | 2.6532 | 2.6629 | 85770804.0 |
| 2006-09-14 11:30:00 | AAPL | Stock | 2.6626 | 2.6632 | 2.6479 | 2.6567 | 44310000.0 |
| 2006-09-14 12:00:00 | AAPL | Stock | 2.6568 | 2.6596 | 2.6432 | 2.6546 | 47165412.0 |
| 2006-09-14 12:30:00 | AAPL | Stock | 2.6543 | 2.6607 | 2.6504 | 2.6525 | 28732844.0 |
| 2006-09-14 13:00:00 | AAPL | Stock | 2.6525 | 2.6532 | 2.645 | 2.6489 | 41050548.0 |
| 2006-09-14 13:30:00 | AAPL | Stock | 2.6492 | 2.6611 | 2.6489 | 2.6568 | 39753336.0 |
| 2006-09-14 14:00:00 | AAPL | Stock | 2.6568 | 2.6586 | 2.6482 | 2.6518 | 29438248.0 |
| 2006-09-14 14:30:00 | AAPL | Stock | 2.6518 | 2.6586 | 2.6461 | 2.6525 | 40788160.0 |
| 2006-09-14 15:00:00 | AAPL | Stock | 2.6525 | 2.6536 | 2.64 | 2.6496 | 63754712.0 |
| 2006-09-14 15:30:00 | AAPL | Stock | 2.6496 | 2.6557 | 2.6464 | 2.65 | 57090292.0 |
| 2006-09-14 16:00:00 | AAPL | Stock | 2.65 | 2.6518 | 2.6482 | 2.6504 | 1426376.0 |
| 2006-09-14 16:30:00 | AAPL | Stock | 2.6504 | 2.6514 | 2.6493 | 2.6507 | 290948.0 |
| 2006-09-14 17:00:00 | AAPL | Stock | 2.6489 | 2.6518 | 2.6429 | 2.6482 | 322140.0 |
| 2006-09-14 17:30:00 | AAPL | Stock | 2.6496 | 2.65 | 2.6486 | 2.6486 | 39200.0 |
| 2006-09-14 18:00:00 | AAPL | Stock | 2.6486 | 2.6486 | 2.6479 | 2.6482 | 61600.0 |
| 2006-09-14 07:00:00 | MSFT | Stock | 25.98 | 26.06 | 25.98 | 26.06 | 3696.0 |
| 2006-09-14 08:00:00 | MSFT | Stock | 26.01 | 26.12 | 26.01 | 26.09 | 21440.0 |
| 2006-09-14 08:30:00 | MSFT | Stock | 26.07 | 26.14 | 26.05 | 26.1 | 55889.0 |
| 2006-09-14 09:00:00 | MSFT | Stock | 26.09 | 26.14 | 25.9 | 25.98 | 369542.0 |
| 2006-09-14 09:30:00 | MSFT | Stock | 25.99 | 26.17 | 25.98 | 26.17 | 13649373.0 |
| 2006-09-14 10:00:00 | MSFT | Stock | 26.16 | 26.35 | 26.15 | 26.32 | 9733570.0 |
| 2006-09-14 10:30:00 | MSFT | Stock | 26.32 | 26.41 | 26.25 | 26.31 | 7532554.0 |
| 2006-09-14 11:00:00 | MSFT | Stock | 26.31 | 26.35 | 26.18 | 26.3 | 3293989.0 |
| 2006-09-14 11:30:00 | MSFT | Stock | 26.3 | 26.34 | 26.24 | 26.31 | 3975366.0 |
| 2006-09-14 12:00:00 | MSFT | Stock | 26.32 | 26.35 | 26.3 | 26.33 | 1839033.0 |
| 2006-09-14 12:30:00 | MSFT | Stock | 26.337 | 26.5 | 26.33 | 26.42 | 3504429.0 |
| 2006-09-14 13:00:00 | MSFT | Stock | 26.42 | 26.42 | 26.3 | 26.35 | 4165860.0 |
| 2006-09-14 13:30:00 | MSFT | Stock | 26.36 | 26.39 | 26.34 | 26.388 | 2601721.0 |
| 2006-09-14 14:00:00 | MSFT | Stock | 26.39 | 26.41 | 26.38 | 26.392 | 2835687.0 |
| 2006-09-14 14:30:00 | MSFT | Stock | 26.4 | 26.42 | 26.32 | 26.34 | 5025408.0 |
| 2006-09-14 15:00:00 | MSFT | Stock | 26.34 | 26.39 | 26.3 | 26.37 | 4783931.0 |
| 2006-09-14 15:30:00 | MSFT | Stock | 26.37 | 26.38 | 26.3 | 26.35 | 8129687.0 |
| 2006-09-14 16:00:00 | MSFT | Stock | 26.35 | 26.37 | 26.136 | 26.37 | 140277.0 |
| 2006-09-14 16:30:00 | MSFT | Stock | 26.33 | 26.38 | 26.33 | 26.38 | 2311.0 |
| 2006-09-14 17:00:00 | MSFT | Stock | 26.35 | 26.35 | 26.28 | 26.33 | 20242.0 |
| 2006-09-14 17:30:00 | MSFT | Stock | 26.37 | 26.37 | 26.33 | 26.33 | 1200.0 |
| 2006-09-14 18:00:00 | MSFT | Stock | 26.36 | 26.37 | 26.36 | 26.37 | 1325.0 |
| 2006-09-14 08:00:00 | NVDA | Stock | 0.485 | 0.485 | 0.485 | 0.485 | 30000.0 |
| 2006-09-14 09:00:00 | NVDA | Stock | 0.4833 | 0.484 | 0.4822 | 0.4822 | 294000.0 |
| 2006-09-14 09:30:00 | NVDA | Stock | 0.4827 | 0.4892 | 0.4768 | 0.4872 | 50305320.0 |
| 2006-09-14 10:00:00 | NVDA | Stock | 0.4872 | 0.4907 | 0.4847 | 0.4887 | 36607680.0 |
> showing 50 of 50,304 rows — these rows as CSV