PREVIEW / stock_30min / 2006-09-22
file: by_date/stock_30min/2006/2006-09-22.parquet size: 923 KB rows: 50,203 symbols: 2,367
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-22 08:00:00 | AAPL | Stock | 2.6661 | 2.6661 | 2.6561 | 2.6571 | 351736.0 |
| 2006-09-22 08:30:00 | AAPL | Stock | 2.6571 | 2.6639 | 2.6561 | 2.6636 | 257012.0 |
| 2006-09-22 09:00:00 | AAPL | Stock | 2.6621 | 2.6661 | 2.6521 | 2.6521 | 885080.0 |
| 2006-09-22 09:30:00 | AAPL | Stock | 2.6536 | 2.655 | 2.62 | 2.6236 | 114779364.0 |
| 2006-09-22 10:00:00 | AAPL | Stock | 2.6236 | 2.6246 | 2.6021 | 2.6193 | 85567944.0 |
| 2006-09-22 10:30:00 | AAPL | Stock | 2.6193 | 2.6264 | 2.6118 | 2.6161 | 50437856.0 |
| 2006-09-22 11:00:00 | AAPL | Stock | 2.6161 | 2.6196 | 2.6068 | 2.6075 | 45664500.0 |
| 2006-09-22 11:30:00 | AAPL | Stock | 2.6071 | 2.6164 | 2.6036 | 2.6068 | 54533612.0 |
| 2006-09-22 12:00:00 | AAPL | Stock | 2.6064 | 2.6096 | 2.5921 | 2.6018 | 57452976.0 |
| 2006-09-22 12:30:00 | AAPL | Stock | 2.6011 | 2.6104 | 2.5968 | 2.6061 | 35074396.0 |
| 2006-09-22 13:00:00 | AAPL | Stock | 2.6064 | 2.6157 | 2.605 | 2.6129 | 30634912.0 |
| 2006-09-22 13:30:00 | AAPL | Stock | 2.6132 | 2.6143 | 2.6064 | 2.6104 | 19301212.0 |
| 2006-09-22 14:00:00 | AAPL | Stock | 2.61 | 2.6146 | 2.6 | 2.6014 | 25647048.0 |
| 2006-09-22 14:30:00 | AAPL | Stock | 2.6018 | 2.6075 | 2.5954 | 2.6007 | 40287324.0 |
| 2006-09-22 15:00:00 | AAPL | Stock | 2.6011 | 2.6146 | 2.6 | 2.6075 | 47093648.0 |
| 2006-09-22 15:30:00 | AAPL | Stock | 2.6075 | 2.6125 | 2.605 | 2.6065 | 49893844.0 |
| 2006-09-22 16:00:00 | AAPL | Stock | 2.6064 | 2.6089 | 2.6054 | 2.6054 | 938224.0 |
| 2006-09-22 16:30:00 | AAPL | Stock | 2.6071 | 2.6075 | 2.6054 | 2.6068 | 131236.0 |
| 2006-09-22 17:00:00 | AAPL | Stock | 2.6071 | 2.6075 | 2.6071 | 2.6071 | 109116.0 |
| 2006-09-22 17:30:00 | AAPL | Stock | 2.6071 | 2.6075 | 2.6057 | 2.6071 | 88144.0 |
| 2006-09-22 18:00:00 | AAPL | Stock | 2.6071 | 2.6089 | 2.6054 | 2.6086 | 222880.0 |
| 2006-09-22 18:30:00 | AAPL | Stock | 2.6086 | 2.6089 | 2.6086 | 2.6089 | 199360.0 |
| 2006-09-22 19:00:00 | AAPL | Stock | 2.6089 | 2.6089 | 2.6089 | 2.6089 | 63448.0 |
| 2006-09-22 19:30:00 | AAPL | Stock | 2.6096 | 2.6096 | 2.6096 | 2.6096 | 8400.0 |
| 2006-09-22 07:00:00 | MSFT | Stock | 26.81 | 26.81 | 26.81 | 26.81 | 1700.0 |
| 2006-09-22 08:00:00 | MSFT | Stock | 26.85 | 26.85 | 26.78 | 26.83 | 14120.0 |
| 2006-09-22 08:30:00 | MSFT | Stock | 26.83 | 26.85 | 26.77 | 26.8 | 5225.0 |
| 2006-09-22 09:00:00 | MSFT | Stock | 26.8 | 26.84 | 26.8 | 26.84 | 141105.0 |
| 2006-09-22 09:30:00 | MSFT | Stock | 26.83 | 26.85 | 26.67 | 26.68 | 6320574.0 |
| 2006-09-22 10:00:00 | MSFT | Stock | 26.68 | 26.78 | 26.63 | 26.7 | 3469832.0 |
| 2006-09-22 10:30:00 | MSFT | Stock | 26.71 | 26.74 | 26.523 | 26.54 | 5144366.0 |
| 2006-09-22 11:00:00 | MSFT | Stock | 26.54 | 26.68 | 26.5 | 26.65 | 3444891.0 |
| 2006-09-22 11:30:00 | MSFT | Stock | 26.65 | 26.74 | 26.64 | 26.71 | 2075561.0 |
| 2006-09-22 12:00:00 | MSFT | Stock | 26.7 | 26.71 | 26.58 | 26.59 | 2105193.0 |
| 2006-09-22 12:30:00 | MSFT | Stock | 26.59 | 26.67 | 26.56 | 26.65 | 2333423.0 |
| 2006-09-22 13:00:00 | MSFT | Stock | 26.64 | 26.7 | 26.59 | 26.62 | 1593270.0 |
| 2006-09-22 13:30:00 | MSFT | Stock | 26.62 | 26.68 | 26.56 | 26.567 | 1848682.0 |
| 2006-09-22 14:00:00 | MSFT | Stock | 26.56 | 26.615 | 26.51 | 26.52 | 2700937.0 |
| 2006-09-22 14:30:00 | MSFT | Stock | 26.53 | 26.54 | 26.48 | 26.52 | 1991132.0 |
| 2006-09-22 15:00:00 | MSFT | Stock | 26.53 | 26.67 | 26.52 | 26.63 | 3176929.0 |
| 2006-09-22 15:30:00 | MSFT | Stock | 26.63 | 26.75 | 26.61 | 26.66 | 8552388.0 |
| 2006-09-22 16:00:00 | MSFT | Stock | 26.65 | 26.74 | 26.65 | 26.68 | 256703.0 |
| 2006-09-22 16:30:00 | MSFT | Stock | 26.66 | 26.68 | 26.66 | 26.68 | 2026.0 |
| 2006-09-22 17:00:00 | MSFT | Stock | 26.7 | 26.7 | 26.7 | 26.7 | 500.0 |
| 2006-09-22 17:30:00 | MSFT | Stock | 26.68 | 26.69 | 26.65 | 26.65 | 20250.0 |
| 2006-09-22 18:00:00 | MSFT | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 300.0 |
| 2006-09-22 18:30:00 | MSFT | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 1000.0 |
| 2006-09-22 08:30:00 | NVDA | Stock | 0.5107 | 0.5108 | 0.5083 | 0.5092 | 126000.0 |
| 2006-09-22 09:00:00 | NVDA | Stock | 0.5107 | 0.5107 | 0.51 | 0.51 | 234000.0 |
| 2006-09-22 09:30:00 | NVDA | Stock | 0.5104 | 0.5137 | 0.506 | 0.5097 | 56671380.0 |
> showing 50 of 50,203 rows — these rows as CSV