PREVIEW / stock_30min / 2006-06-23
file: by_date/stock_30min/2006/2006-06-23.parquet size: 896 KB rows: 48,864 symbols: 2,301
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-06-23 07:00:00 | AAPL | Stock | 2.1329 | 2.1329 | 2.1329 | 2.1329 | 2800.0 |
| 2006-06-23 08:00:00 | AAPL | Stock | 2.1357 | 2.1425 | 2.1339 | 2.135 | 801024.0 |
| 2006-06-23 08:30:00 | AAPL | Stock | 2.1354 | 2.1389 | 2.1307 | 2.1343 | 714840.0 |
| 2006-06-23 09:00:00 | AAPL | Stock | 2.1343 | 2.1343 | 2.1218 | 2.1318 | 1623048.0 |
| 2006-06-23 09:30:00 | AAPL | Stock | 2.1329 | 2.1489 | 2.1204 | 2.1382 | 108380664.0 |
| 2006-06-23 10:00:00 | AAPL | Stock | 2.1379 | 2.1382 | 2.1125 | 2.1207 | 95886672.0 |
| 2006-06-23 10:30:00 | AAPL | Stock | 2.1207 | 2.1268 | 2.1143 | 2.1193 | 39333896.0 |
| 2006-06-23 11:00:00 | AAPL | Stock | 2.1193 | 2.12 | 2.1021 | 2.1089 | 52388952.0 |
| 2006-06-23 11:30:00 | AAPL | Stock | 2.1092 | 2.1121 | 2.1036 | 2.1039 | 28917812.0 |
| 2006-06-23 12:00:00 | AAPL | Stock | 2.1039 | 2.135 | 2.1021 | 2.1307 | 51495332.0 |
| 2006-06-23 12:30:00 | AAPL | Stock | 2.1307 | 2.1404 | 2.1279 | 2.1332 | 42559412.0 |
| 2006-06-23 13:00:00 | AAPL | Stock | 2.1336 | 2.1414 | 2.13 | 2.1311 | 30406964.0 |
| 2006-06-23 13:30:00 | AAPL | Stock | 2.1311 | 2.1379 | 2.1254 | 2.1282 | 31117492.0 |
| 2006-06-23 14:00:00 | AAPL | Stock | 2.1286 | 2.1286 | 2.1168 | 2.1207 | 25009628.0 |
| 2006-06-23 14:30:00 | AAPL | Stock | 2.1207 | 2.1246 | 2.1061 | 2.1086 | 30071524.0 |
| 2006-06-23 15:00:00 | AAPL | Stock | 2.1085 | 2.1129 | 2.1036 | 2.1071 | 32826668.0 |
| 2006-06-23 15:30:00 | AAPL | Stock | 2.1075 | 2.1143 | 2.0979 | 2.0982 | 53921812.0 |
| 2006-06-23 16:00:00 | AAPL | Stock | 2.1007 | 2.1014 | 2.0943 | 2.0986 | 2886940.0 |
| 2006-06-23 16:30:00 | AAPL | Stock | 2.0986 | 2.1011 | 2.0946 | 2.0946 | 1738800.0 |
| 2006-06-23 17:00:00 | AAPL | Stock | 2.0975 | 2.1011 | 2.0975 | 2.1 | 22696604.0 |
| 2006-06-23 17:30:00 | AAPL | Stock | 2.0975 | 2.0975 | 2.0975 | 2.0975 | 25200.0 |
| 2006-06-23 18:00:00 | AAPL | Stock | 2.1009 | 2.1009 | 2.0993 | 2.1 | 234220.0 |
| 2006-06-23 08:00:00 | MSFT | Stock | 22.9 | 22.9 | 22.9 | 22.9 | 7268.0 |
| 2006-06-23 08:30:00 | MSFT | Stock | 22.9 | 22.93 | 22.9 | 22.93 | 9150.0 |
| 2006-06-23 09:00:00 | MSFT | Stock | 22.91 | 22.91 | 22.8 | 22.82 | 44179.0 |
| 2006-06-23 09:30:00 | MSFT | Stock | 22.85 | 22.87 | 22.7 | 22.72 | 5638631.0 |
| 2006-06-23 10:00:00 | MSFT | Stock | 22.72 | 22.83 | 22.71 | 22.79 | 2563225.0 |
| 2006-06-23 10:30:00 | MSFT | Stock | 22.8 | 22.83 | 22.76 | 22.82 | 2284350.0 |
| 2006-06-23 11:00:00 | MSFT | Stock | 22.82 | 22.83 | 22.77 | 22.778 | 4351559.0 |
| 2006-06-23 11:30:00 | MSFT | Stock | 22.771 | 22.8 | 22.73 | 22.75 | 2626638.0 |
| 2006-06-23 12:00:00 | MSFT | Stock | 22.75 | 22.86 | 22.74 | 22.827 | 5346957.0 |
| 2006-06-23 12:30:00 | MSFT | Stock | 22.82 | 22.83 | 22.75 | 22.81 | 3916680.0 |
| 2006-06-23 13:00:00 | MSFT | Stock | 22.8 | 22.82 | 22.75 | 22.76 | 2312332.0 |
| 2006-06-23 13:30:00 | MSFT | Stock | 22.76 | 22.79 | 22.74 | 22.76 | 2806031.0 |
| 2006-06-23 14:00:00 | MSFT | Stock | 22.76 | 22.77 | 22.65 | 22.66 | 5124182.0 |
| 2006-06-23 14:30:00 | MSFT | Stock | 22.66 | 22.82 | 22.55 | 22.558 | 5795345.0 |
| 2006-06-23 15:00:00 | MSFT | Stock | 22.56 | 22.68 | 22.52 | 22.63 | 7067300.0 |
| 2006-06-23 15:30:00 | MSFT | Stock | 22.64 | 22.7 | 22.5 | 22.51 | 8563014.0 |
| 2006-06-23 16:00:00 | MSFT | Stock | 22.5 | 22.53 | 22.5 | 22.52 | 140504.0 |
| 2006-06-23 16:30:00 | MSFT | Stock | 22.51 | 22.52 | 22.5 | 22.5 | 4000.0 |
| 2006-06-23 17:00:00 | MSFT | Stock | 22.5 | 22.5 | 22.5 | 22.5 | 11050.0 |
| 2006-06-23 17:30:00 | MSFT | Stock | 22.52 | 22.53 | 22.5 | 22.5 | 16954.0 |
| 2006-06-23 18:00:00 | MSFT | Stock | 22.53 | 22.53 | 22.53 | 22.53 | 2000.0 |
| 2006-06-23 08:30:00 | NVDA | Stock | 0.3383 | 0.3383 | 0.3383 | 0.3383 | 45000.0 |
| 2006-06-23 09:00:00 | NVDA | Stock | 0.3433 | 0.3438 | 0.3375 | 0.3375 | 123000.0 |
| 2006-06-23 09:30:00 | NVDA | Stock | 0.3377 | 0.3385 | 0.3345 | 0.3372 | 24981180.0 |
| 2006-06-23 10:00:00 | NVDA | Stock | 0.3372 | 0.3397 | 0.3355 | 0.338 | 35354160.0 |
| 2006-06-23 10:30:00 | NVDA | Stock | 0.3383 | 0.3408 | 0.3378 | 0.3401 | 26622120.0 |
| 2006-06-23 11:00:00 | NVDA | Stock | 0.34 | 0.341 | 0.3385 | 0.339 | 24616320.0 |
| 2006-06-23 11:30:00 | NVDA | Stock | 0.3388 | 0.34 | 0.3382 | 0.3388 | 12346140.0 |
> showing 50 of 48,864 rows — these rows as CSV