PREVIEW / stock_30min / 2006-10-30
file: by_date/stock_30min/2006/2006-10-30.parquet size: 949 KB rows: 51,526 symbols: 2,427
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-30 04:30:00 | AAPL | Stock | 2.8643 | 2.8643 | 2.8643 | 2.8643 | 2800.0 |
| 2006-10-30 07:30:00 | AAPL | Stock | 2.8643 | 2.8643 | 2.8643 | 2.8643 | 2800.0 |
| 2006-10-30 08:00:00 | AAPL | Stock | 2.8643 | 2.8696 | 2.8607 | 2.8629 | 616588.0 |
| 2006-10-30 08:30:00 | AAPL | Stock | 2.8629 | 2.8646 | 2.8625 | 2.8643 | 231000.0 |
| 2006-10-30 09:00:00 | AAPL | Stock | 2.8657 | 2.8707 | 2.8557 | 2.8575 | 1517712.0 |
| 2006-10-30 09:30:00 | AAPL | Stock | 2.8566 | 2.8646 | 2.8393 | 2.8561 | 100836568.0 |
| 2006-10-30 10:00:00 | AAPL | Stock | 2.8561 | 2.8661 | 2.8482 | 2.8561 | 53512620.0 |
| 2006-10-30 10:30:00 | AAPL | Stock | 2.8561 | 2.865 | 2.8554 | 2.8643 | 36742580.0 |
| 2006-10-30 11:00:00 | AAPL | Stock | 2.8643 | 2.8854 | 2.8643 | 2.8839 | 55737920.0 |
| 2006-10-30 11:30:00 | AAPL | Stock | 2.8843 | 2.885 | 2.8607 | 2.8675 | 29295000.0 |
| 2006-10-30 12:00:00 | AAPL | Stock | 2.8679 | 2.8689 | 2.8586 | 2.8643 | 19662160.0 |
| 2006-10-30 12:30:00 | AAPL | Stock | 2.8639 | 2.8711 | 2.8589 | 2.8689 | 14042532.0 |
| 2006-10-30 13:00:00 | AAPL | Stock | 2.8689 | 2.875 | 2.8668 | 2.8739 | 21117488.0 |
| 2006-10-30 13:30:00 | AAPL | Stock | 2.8746 | 2.8893 | 2.8743 | 2.8864 | 26485144.0 |
| 2006-10-30 14:00:00 | AAPL | Stock | 2.8864 | 2.8875 | 2.8771 | 2.8839 | 19456948.0 |
| 2006-10-30 14:30:00 | AAPL | Stock | 2.8839 | 2.8864 | 2.8771 | 2.8818 | 13842976.0 |
| 2006-10-30 15:00:00 | AAPL | Stock | 2.8814 | 2.8854 | 2.8682 | 2.8686 | 21923244.0 |
| 2006-10-30 15:30:00 | AAPL | Stock | 2.8686 | 2.8757 | 2.8646 | 2.8714 | 33852812.0 |
| 2006-10-30 16:00:00 | AAPL | Stock | 2.8721 | 2.8743 | 2.8718 | 2.8739 | 18538352.0 |
| 2006-10-30 16:30:00 | AAPL | Stock | 2.8739 | 2.8739 | 2.8732 | 2.8739 | 159600.0 |
| 2006-10-30 17:00:00 | AAPL | Stock | 2.8739 | 2.8771 | 2.8725 | 2.8771 | 149044.0 |
| 2006-10-30 17:30:00 | AAPL | Stock | 2.8764 | 2.8764 | 2.8764 | 2.8764 | 2800.0 |
| 2006-10-30 18:00:00 | AAPL | Stock | 2.8732 | 2.8768 | 2.8721 | 2.8725 | 28756.0 |
| 2006-10-30 18:30:00 | AAPL | Stock | 2.8725 | 2.8725 | 2.8725 | 2.8725 | 5600.0 |
| 2006-10-30 19:30:00 | AAPL | Stock | 2.8725 | 2.8779 | 2.8725 | 2.8779 | 8400.0 |
| 2006-10-30 07:00:00 | MSFT | Stock | 28.3 | 28.3 | 28.3 | 28.3 | 100.0 |
| 2006-10-30 08:00:00 | MSFT | Stock | 28.4 | 28.4 | 28.28 | 28.28 | 7248.0 |
| 2006-10-30 08:30:00 | MSFT | Stock | 28.3 | 28.3 | 28.25 | 28.25 | 4283.0 |
| 2006-10-30 09:00:00 | MSFT | Stock | 28.26 | 28.41 | 28.24 | 28.35 | 80658.0 |
| 2006-10-30 09:30:00 | MSFT | Stock | 28.35 | 28.49 | 28.32 | 28.39 | 4755152.0 |
| 2006-10-30 10:00:00 | MSFT | Stock | 28.39 | 28.48 | 28.39 | 28.45 | 2801727.0 |
| 2006-10-30 10:30:00 | MSFT | Stock | 28.45 | 28.55 | 28.45 | 28.539 | 2394901.0 |
| 2006-10-30 11:00:00 | MSFT | Stock | 28.53 | 28.67 | 28.52 | 28.63 | 4302031.0 |
| 2006-10-30 11:30:00 | MSFT | Stock | 28.63 | 28.69 | 28.6 | 28.68 | 4465275.0 |
| 2006-10-30 12:00:00 | MSFT | Stock | 28.68 | 28.69 | 28.62 | 28.66 | 1968559.0 |
| 2006-10-30 12:30:00 | MSFT | Stock | 28.66 | 28.67 | 28.63 | 28.66 | 2000448.0 |
| 2006-10-30 13:00:00 | MSFT | Stock | 28.66 | 28.7 | 28.64 | 28.7 | 2223701.0 |
| 2006-10-30 13:30:00 | MSFT | Stock | 28.69 | 28.79 | 28.68 | 28.77 | 4699225.0 |
| 2006-10-30 14:00:00 | MSFT | Stock | 28.78 | 28.84 | 28.75 | 28.78 | 5509414.0 |
| 2006-10-30 14:30:00 | MSFT | Stock | 28.78 | 28.79 | 28.69 | 28.7 | 2268671.0 |
| 2006-10-30 15:00:00 | MSFT | Stock | 28.7 | 28.74 | 28.56 | 28.57 | 2913481.0 |
| 2006-10-30 15:30:00 | MSFT | Stock | 28.57 | 28.62 | 28.5 | 28.57 | 4613744.0 |
| 2006-10-30 16:00:00 | MSFT | Stock | 28.58 | 28.58 | 28.52 | 28.53 | 365120.0 |
| 2006-10-30 16:30:00 | MSFT | Stock | 28.53 | 28.53 | 28.53 | 28.53 | 1500.0 |
| 2006-10-30 17:00:00 | MSFT | Stock | 28.57 | 28.6 | 28.57 | 28.6 | 11152.0 |
| 2006-10-30 17:30:00 | MSFT | Stock | 28.58 | 28.58 | 28.58 | 28.58 | 100.0 |
| 2006-10-30 18:00:00 | MSFT | Stock | 28.53 | 28.6 | 28.53 | 28.6 | 4266.0 |
| 2006-10-30 19:00:00 | MSFT | Stock | 28.6 | 28.6 | 28.6 | 28.6 | 1000.0 |
| 2006-10-30 08:30:00 | NVDA | Stock | 0.54 | 0.54 | 0.54 | 0.54 | 6000.0 |
| 2006-10-30 09:00:00 | NVDA | Stock | 0.5383 | 0.5433 | 0.5383 | 0.5433 | 270000.0 |
> showing 50 of 51,526 rows — these rows as CSV