PREVIEW / stock_30min / 2009-09-29
file: by_date/stock_30min/2009/2009-09-29.parquet size: 1.4 MB rows: 74,111 symbols: 3,413
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-29 07:30:00 | AAPL | Stock | 6.6568 | 6.6643 | 6.6446 | 6.6482 | 76720.0 |
| 2009-09-29 08:00:00 | AAPL | Stock | 6.6482 | 6.6643 | 6.6482 | 6.6571 | 267652.0 |
| 2009-09-29 08:30:00 | AAPL | Stock | 6.6571 | 6.6579 | 6.6461 | 6.6461 | 439712.0 |
| 2009-09-29 09:00:00 | AAPL | Stock | 6.6504 | 6.6739 | 6.6493 | 6.6739 | 2266768.0 |
| 2009-09-29 09:30:00 | AAPL | Stock | 6.6689 | 6.6929 | 6.6407 | 6.6593 | 65121756.0 |
| 2009-09-29 10:00:00 | AAPL | Stock | 6.6561 | 6.6593 | 6.6125 | 6.6299 | 51860620.0 |
| 2009-09-29 10:30:00 | AAPL | Stock | 6.63 | 6.6389 | 6.5893 | 6.5921 | 35058240.0 |
| 2009-09-29 11:00:00 | AAPL | Stock | 6.5907 | 6.6146 | 6.5825 | 6.6146 | 25411736.0 |
| 2009-09-29 11:30:00 | AAPL | Stock | 6.6139 | 6.6161 | 6.5921 | 6.5964 | 16511180.0 |
| 2009-09-29 12:00:00 | AAPL | Stock | 6.5965 | 6.6118 | 6.5918 | 6.5982 | 12460560.0 |
| 2009-09-29 12:30:00 | AAPL | Stock | 6.5986 | 6.6232 | 6.5946 | 6.6193 | 12654096.0 |
| 2009-09-29 13:00:00 | AAPL | Stock | 6.6196 | 6.6429 | 6.6191 | 6.6343 | 19774804.0 |
| 2009-09-29 13:30:00 | AAPL | Stock | 6.6343 | 6.635 | 6.6107 | 6.6218 | 15705564.0 |
| 2009-09-29 14:00:00 | AAPL | Stock | 6.6218 | 6.6246 | 6.6096 | 6.6171 | 10751636.0 |
| 2009-09-29 14:30:00 | AAPL | Stock | 6.6175 | 6.621 | 6.6096 | 6.6175 | 10086328.0 |
| 2009-09-29 15:00:00 | AAPL | Stock | 6.6179 | 6.6336 | 6.6175 | 6.6264 | 16549204.0 |
| 2009-09-29 15:30:00 | AAPL | Stock | 6.6243 | 6.6264 | 6.6036 | 6.6221 | 29174012.0 |
| 2009-09-29 16:00:00 | AAPL | Stock | 6.6218 | 6.6279 | 6.6166 | 6.6207 | 6446944.0 |
| 2009-09-29 16:30:00 | AAPL | Stock | 6.6193 | 6.6207 | 6.6179 | 6.6196 | 53480.0 |
| 2009-09-29 17:00:00 | AAPL | Stock | 6.6243 | 6.6243 | 6.6161 | 6.6161 | 6684384.0 |
| 2009-09-29 17:30:00 | AAPL | Stock | 6.6157 | 6.6171 | 6.6096 | 6.6143 | 159488.0 |
| 2009-09-29 18:00:00 | AAPL | Stock | 6.6204 | 6.6232 | 6.6179 | 6.6179 | 271712.0 |
| 2009-09-29 18:30:00 | AAPL | Stock | 6.6214 | 6.6236 | 6.6214 | 6.6221 | 17920.0 |
| 2009-09-29 19:00:00 | AAPL | Stock | 6.6239 | 6.625 | 6.6211 | 6.6211 | 41300.0 |
| 2009-09-29 19:30:00 | AAPL | Stock | 6.6225 | 6.6243 | 6.6189 | 6.6196 | 55776.0 |
| 2009-09-29 04:00:00 | MSFT | Stock | 25.68 | 25.68 | 25.68 | 25.68 | 400.0 |
| 2009-09-29 07:00:00 | MSFT | Stock | 25.9 | 25.9 | 25.8 | 25.8 | 1000.0 |
| 2009-09-29 07:30:00 | MSFT | Stock | 25.85 | 25.85 | 25.85 | 25.85 | 120.0 |
| 2009-09-29 08:00:00 | MSFT | Stock | 25.8 | 25.89 | 25.76 | 25.89 | 3280.0 |
| 2009-09-29 08:30:00 | MSFT | Stock | 25.83 | 25.88 | 25.83 | 25.87 | 1010.0 |
| 2009-09-29 09:00:00 | MSFT | Stock | 25.88 | 25.91 | 25.85 | 25.91 | 21763.0 |
| 2009-09-29 09:30:00 | MSFT | Stock | 25.91 | 25.96 | 25.78 | 25.92 | 4641146.0 |
| 2009-09-29 10:00:00 | MSFT | Stock | 25.92 | 25.93 | 25.7 | 25.848 | 4816125.0 |
| 2009-09-29 10:30:00 | MSFT | Stock | 25.845 | 25.95 | 25.74 | 25.759 | 2752612.0 |
| 2009-09-29 11:00:00 | MSFT | Stock | 25.75 | 25.78 | 25.73 | 25.74 | 2338605.0 |
| 2009-09-29 11:30:00 | MSFT | Stock | 25.75 | 25.77 | 25.72 | 25.72 | 1955459.0 |
| 2009-09-29 12:00:00 | MSFT | Stock | 25.72 | 25.77 | 25.72 | 25.73 | 1383547.0 |
| 2009-09-29 12:30:00 | MSFT | Stock | 25.73 | 25.83 | 25.73 | 25.8 | 1316829.0 |
| 2009-09-29 13:00:00 | MSFT | Stock | 25.8 | 25.83 | 25.76 | 25.78 | 1477843.0 |
| 2009-09-29 13:30:00 | MSFT | Stock | 25.78 | 25.8 | 25.74 | 25.751 | 2046559.0 |
| 2009-09-29 14:00:00 | MSFT | Stock | 25.752 | 25.82 | 25.75 | 25.77 | 1892319.0 |
| 2009-09-29 14:30:00 | MSFT | Stock | 25.77 | 25.79 | 25.74 | 25.77 | 1479699.0 |
| 2009-09-29 15:00:00 | MSFT | Stock | 25.77 | 25.78 | 25.73 | 25.73 | 1742032.0 |
| 2009-09-29 15:30:00 | MSFT | Stock | 25.73 | 25.79 | 25.69 | 25.76 | 5173391.0 |
| 2009-09-29 16:00:00 | MSFT | Stock | 25.76 | 25.788 | 25.679 | 25.75 | 1936250.0 |
| 2009-09-29 16:30:00 | MSFT | Stock | 25.75 | 25.75 | 25.75 | 25.75 | 6422.0 |
| 2009-09-29 17:00:00 | MSFT | Stock | 25.75 | 25.75 | 25.68 | 25.74 | 32102.0 |
| 2009-09-29 17:30:00 | MSFT | Stock | 25.71 | 25.71 | 25.71 | 25.71 | 100.0 |
| 2009-09-29 18:00:00 | MSFT | Stock | 25.75 | 25.75 | 25.69 | 25.69 | 18533.0 |
| 2009-09-29 18:30:00 | MSFT | Stock | 25.68 | 25.74 | 25.67 | 25.71 | 3260.0 |
> showing 50 of 74,111 rows — these rows as CSV