PREVIEW / stock_30min / 2006-12-13
file: by_date/stock_30min/2006/2006-12-13.parquet size: 984 KB rows: 53,510 symbols: 2,471
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-12-13 06:00:00 | AAPL | Stock | 3.0804 | 3.1036 | 3.0804 | 3.1036 | 141036.0 |
| 2006-12-13 06:30:00 | AAPL | Stock | 3.0996 | 3.1157 | 3.0996 | 3.1093 | 183036.0 |
| 2006-12-13 07:00:00 | AAPL | Stock | 3.1071 | 3.1279 | 3.1071 | 3.1171 | 430780.0 |
| 2006-12-13 07:30:00 | AAPL | Stock | 3.1104 | 3.1232 | 3.1089 | 3.1214 | 1062600.0 |
| 2006-12-13 08:00:00 | AAPL | Stock | 3.1186 | 3.125 | 3.1139 | 3.1179 | 5959716.0 |
| 2006-12-13 08:30:00 | AAPL | Stock | 3.1193 | 3.1282 | 3.1161 | 3.1279 | 5204220.0 |
| 2006-12-13 09:00:00 | AAPL | Stock | 3.1279 | 3.1418 | 3.1275 | 3.1404 | 8148140.0 |
| 2006-12-13 09:30:00 | AAPL | Stock | 3.1411 | 3.1521 | 3.1268 | 3.1336 | 162581076.0 |
| 2006-12-13 10:00:00 | AAPL | Stock | 3.1332 | 3.1386 | 3.1168 | 3.1207 | 102391884.0 |
| 2006-12-13 10:30:00 | AAPL | Stock | 3.1207 | 3.1382 | 3.1125 | 3.1346 | 67784304.0 |
| 2006-12-13 11:00:00 | AAPL | Stock | 3.1346 | 3.1421 | 3.1161 | 3.1418 | 31645796.0 |
| 2006-12-13 11:30:00 | AAPL | Stock | 3.1418 | 3.1432 | 3.1329 | 3.1361 | 27028680.0 |
| 2006-12-13 12:00:00 | AAPL | Stock | 3.1364 | 3.1386 | 3.12 | 3.1233 | 30734956.0 |
| 2006-12-13 12:30:00 | AAPL | Stock | 3.1236 | 3.1393 | 3.1232 | 3.1353 | 41389824.0 |
| 2006-12-13 13:00:00 | AAPL | Stock | 3.1354 | 3.1386 | 3.1321 | 3.1354 | 17716804.0 |
| 2006-12-13 13:30:00 | AAPL | Stock | 3.1354 | 3.1375 | 3.1232 | 3.1343 | 33547192.0 |
| 2006-12-13 14:00:00 | AAPL | Stock | 3.1346 | 3.15 | 3.1343 | 3.15 | 63684040.0 |
| 2006-12-13 14:30:00 | AAPL | Stock | 3.15 | 3.1593 | 3.1446 | 3.1554 | 78256836.0 |
| 2006-12-13 15:00:00 | AAPL | Stock | 3.1557 | 3.1632 | 3.1518 | 3.1593 | 59134348.0 |
| 2006-12-13 15:30:00 | AAPL | Stock | 3.1593 | 3.1811 | 3.1575 | 3.1796 | 99805720.0 |
| 2006-12-13 16:00:00 | AAPL | Stock | 3.1796 | 3.1829 | 3.1775 | 3.1804 | 3206812.0 |
| 2006-12-13 16:30:00 | AAPL | Stock | 3.1793 | 3.1804 | 3.1793 | 3.1796 | 440076.0 |
| 2006-12-13 17:00:00 | AAPL | Stock | 3.1796 | 3.1804 | 3.1786 | 3.1786 | 230272.0 |
| 2006-12-13 17:30:00 | AAPL | Stock | 3.1786 | 3.185 | 3.1786 | 3.185 | 511196.0 |
| 2006-12-13 18:00:00 | AAPL | Stock | 3.1854 | 3.1857 | 3.1839 | 3.185 | 40600.0 |
| 2006-12-13 18:30:00 | AAPL | Stock | 3.185 | 3.1871 | 3.1804 | 3.1864 | 272048.0 |
| 2006-12-13 19:00:00 | AAPL | Stock | 3.1864 | 3.1864 | 3.1839 | 3.1854 | 22148.0 |
| 2006-12-13 19:30:00 | AAPL | Stock | 3.1857 | 3.1886 | 3.1857 | 3.1864 | 144956.0 |
| 2006-12-13 08:00:00 | MSFT | Stock | 29.45 | 29.45 | 29.45 | 29.45 | 5200.0 |
| 2006-12-13 08:30:00 | MSFT | Stock | 29.43 | 29.49 | 29.43 | 29.48 | 10450.0 |
| 2006-12-13 09:00:00 | MSFT | Stock | 29.48 | 29.65 | 29.48 | 29.6 | 85926.0 |
| 2006-12-13 09:30:00 | MSFT | Stock | 29.6 | 29.6 | 29.32 | 29.54 | 7026594.0 |
| 2006-12-13 10:00:00 | MSFT | Stock | 29.53 | 29.53 | 29.4 | 29.43 | 3394498.0 |
| 2006-12-13 10:30:00 | MSFT | Stock | 29.43 | 29.45 | 29.37 | 29.441 | 4233330.0 |
| 2006-12-13 11:00:00 | MSFT | Stock | 29.44 | 29.47 | 29.39 | 29.46 | 2117522.0 |
| 2006-12-13 11:30:00 | MSFT | Stock | 29.46 | 29.46 | 29.42 | 29.43 | 1438841.0 |
| 2006-12-13 12:00:00 | MSFT | Stock | 29.42 | 29.45 | 29.34 | 29.39 | 2013193.0 |
| 2006-12-13 12:30:00 | MSFT | Stock | 29.4 | 29.41 | 29.34 | 29.41 | 1499524.0 |
| 2006-12-13 13:00:00 | MSFT | Stock | 29.4 | 29.47 | 29.38 | 29.43 | 1726858.0 |
| 2006-12-13 13:30:00 | MSFT | Stock | 29.44 | 29.49 | 29.38 | 29.47 | 2111741.0 |
| 2006-12-13 14:00:00 | MSFT | Stock | 29.47 | 29.52 | 29.46 | 29.5 | 2487083.0 |
| 2006-12-13 14:30:00 | MSFT | Stock | 29.49 | 29.5 | 29.44 | 29.45 | 1745781.0 |
| 2006-12-13 15:00:00 | MSFT | Stock | 29.46 | 29.5 | 29.45 | 29.48 | 1906133.0 |
| 2006-12-13 15:30:00 | MSFT | Stock | 29.48 | 29.6 | 29.47 | 29.54 | 7909029.0 |
| 2006-12-13 16:00:00 | MSFT | Stock | 29.54 | 29.58 | 29.5 | 29.5 | 362801.0 |
| 2006-12-13 17:00:00 | MSFT | Stock | 29.55 | 29.55 | 29.55 | 29.55 | 175.0 |
| 2006-12-13 17:30:00 | MSFT | Stock | 29.55 | 29.55 | 29.55 | 29.55 | 250.0 |
| 2006-12-13 18:00:00 | MSFT | Stock | 29.57 | 29.6 | 29.57 | 29.6 | 6300.0 |
| 2006-12-13 18:30:00 | MSFT | Stock | 29.55 | 29.55 | 29.55 | 29.55 | 3293.0 |
| 2006-12-13 19:00:00 | MSFT | Stock | 29.61 | 29.62 | 29.61 | 29.62 | 3425.0 |
> showing 50 of 53,510 rows — these rows as CSV