PREVIEW / stock_30min / 2006-10-23
file: by_date/stock_30min/2006/2006-10-23.parquet size: 936 KB rows: 51,072 symbols: 2,415
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-23 07:00:00 | AAPL | Stock | 2.8614 | 2.8614 | 2.8614 | 2.8614 | 2800.0 |
| 2006-10-23 07:30:00 | AAPL | Stock | 2.8571 | 2.8571 | 2.8571 | 2.8571 | 2800.0 |
| 2006-10-23 08:00:00 | AAPL | Stock | 2.86 | 2.875 | 2.8571 | 2.8686 | 2723140.0 |
| 2006-10-23 08:30:00 | AAPL | Stock | 2.8686 | 2.8729 | 2.8625 | 2.8643 | 1550388.0 |
| 2006-10-23 09:00:00 | AAPL | Stock | 2.8646 | 2.8746 | 2.8536 | 2.8557 | 3390828.0 |
| 2006-10-23 09:30:00 | AAPL | Stock | 2.8568 | 2.8782 | 2.8482 | 2.8654 | 122235624.0 |
| 2006-10-23 10:00:00 | AAPL | Stock | 2.8654 | 2.9136 | 2.8636 | 2.9129 | 121285388.0 |
| 2006-10-23 10:30:00 | AAPL | Stock | 2.9129 | 2.9143 | 2.9018 | 2.9118 | 59419276.0 |
| 2006-10-23 11:00:00 | AAPL | Stock | 2.9121 | 2.9211 | 2.9071 | 2.9092 | 63047712.0 |
| 2006-10-23 11:30:00 | AAPL | Stock | 2.9093 | 2.9129 | 2.9054 | 2.9081 | 34594476.0 |
| 2006-10-23 12:00:00 | AAPL | Stock | 2.9082 | 2.9232 | 2.9079 | 2.915 | 47570040.0 |
| 2006-10-23 12:30:00 | AAPL | Stock | 2.915 | 2.925 | 2.915 | 2.9168 | 34316156.0 |
| 2006-10-23 13:00:00 | AAPL | Stock | 2.9168 | 2.9214 | 2.9157 | 2.9211 | 24779832.0 |
| 2006-10-23 13:30:00 | AAPL | Stock | 2.921 | 2.9232 | 2.9129 | 2.9146 | 32854724.0 |
| 2006-10-23 14:00:00 | AAPL | Stock | 2.9143 | 2.9161 | 2.8957 | 2.9047 | 54330164.0 |
| 2006-10-23 14:30:00 | AAPL | Stock | 2.905 | 2.9211 | 2.9018 | 2.9175 | 41122116.0 |
| 2006-10-23 15:00:00 | AAPL | Stock | 2.9175 | 2.9246 | 2.9114 | 2.9121 | 44645776.0 |
| 2006-10-23 15:30:00 | AAPL | Stock | 2.9121 | 2.9146 | 2.9025 | 2.9096 | 64701952.0 |
| 2006-10-23 16:00:00 | AAPL | Stock | 2.9093 | 2.9104 | 2.9054 | 2.9071 | 8839096.0 |
| 2006-10-23 16:30:00 | AAPL | Stock | 2.9071 | 2.9079 | 2.9057 | 2.9079 | 224000.0 |
| 2006-10-23 17:00:00 | AAPL | Stock | 2.9071 | 2.9071 | 2.9057 | 2.9057 | 44380.0 |
| 2006-10-23 17:30:00 | AAPL | Stock | 2.9057 | 2.9093 | 2.9054 | 2.9057 | 111272.0 |
| 2006-10-23 18:00:00 | AAPL | Stock | 2.9057 | 2.9057 | 2.9057 | 2.9057 | 8400.0 |
| 2006-10-23 18:30:00 | AAPL | Stock | 2.9054 | 2.9089 | 2.9054 | 2.9089 | 46508.0 |
| 2006-10-23 19:00:00 | AAPL | Stock | 2.9089 | 2.9089 | 2.9086 | 2.9086 | 9800.0 |
| 2006-10-23 19:30:00 | AAPL | Stock | 2.9061 | 2.9061 | 2.9054 | 2.9054 | 19852.0 |
| 2006-10-23 08:00:00 | MSFT | Stock | 28.42 | 28.48 | 28.36 | 28.4 | 12698.0 |
| 2006-10-23 08:30:00 | MSFT | Stock | 28.4 | 28.4 | 28.38 | 28.4 | 2720.0 |
| 2006-10-23 09:00:00 | MSFT | Stock | 28.36 | 28.4 | 28.28 | 28.35 | 126340.0 |
| 2006-10-23 09:30:00 | MSFT | Stock | 28.3 | 28.41 | 28.18 | 28.4 | 4686023.0 |
| 2006-10-23 10:00:00 | MSFT | Stock | 28.4 | 28.6 | 28.39 | 28.59 | 5179071.0 |
| 2006-10-23 10:30:00 | MSFT | Stock | 28.58 | 28.6 | 28.49 | 28.56 | 3304998.0 |
| 2006-10-23 11:00:00 | MSFT | Stock | 28.56 | 28.69 | 28.56 | 28.57 | 5789280.0 |
| 2006-10-23 11:30:00 | MSFT | Stock | 28.58 | 28.59 | 28.45 | 28.5 | 4012956.0 |
| 2006-10-23 12:00:00 | MSFT | Stock | 28.5 | 28.61 | 28.48 | 28.56 | 3029039.0 |
| 2006-10-23 12:30:00 | MSFT | Stock | 28.563 | 28.57 | 28.49 | 28.52 | 1557108.0 |
| 2006-10-23 13:00:00 | MSFT | Stock | 28.52 | 28.57 | 28.52 | 28.57 | 1436577.0 |
| 2006-10-23 13:30:00 | MSFT | Stock | 28.57 | 28.59 | 28.47 | 28.55 | 1439861.0 |
| 2006-10-23 14:00:00 | MSFT | Stock | 28.54 | 28.55 | 28.45 | 28.46 | 2059322.0 |
| 2006-10-23 14:30:00 | MSFT | Stock | 28.46 | 28.5 | 28.42 | 28.43 | 3100909.0 |
| 2006-10-23 15:00:00 | MSFT | Stock | 28.44 | 28.49 | 28.42 | 28.47 | 4268695.0 |
| 2006-10-23 15:30:00 | MSFT | Stock | 28.47 | 28.5 | 28.43 | 28.44 | 5277649.0 |
| 2006-10-23 16:00:00 | MSFT | Stock | 28.49 | 28.605 | 28.42 | 28.47 | 1408942.0 |
| 2006-10-23 16:30:00 | MSFT | Stock | 28.44 | 28.48 | 28.44 | 28.48 | 404005.0 |
| 2006-10-23 17:00:00 | MSFT | Stock | 28.44 | 28.46 | 28.44 | 28.46 | 600.0 |
| 2006-10-23 17:30:00 | MSFT | Stock | 28.45 | 28.47 | 28.45 | 28.47 | 71486.0 |
| 2006-10-23 18:00:00 | MSFT | Stock | 28.48 | 28.48 | 28.46 | 28.46 | 125300.0 |
| 2006-10-23 19:30:00 | MSFT | Stock | 28.4 | 28.4 | 28.4 | 28.4 | 100.0 |
| 2006-10-23 09:00:00 | NVDA | Stock | 0.5275 | 0.5303 | 0.5272 | 0.5293 | 231540.0 |
| 2006-10-23 09:30:00 | NVDA | Stock | 0.5287 | 0.5323 | 0.525 | 0.5313 | 24892980.0 |
> showing 50 of 51,072 rows — these rows as CSV