PREVIEW / stock_30min / 2006-11-21
file: by_date/stock_30min/2006/2006-11-21.parquet size: 964 KB rows: 52,191 symbols: 2,456
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-11-21 06:30:00 | AAPL | Stock | 3.0907 | 3.0907 | 3.0907 | 3.0907 | 5600.0 |
| 2006-11-21 07:00:00 | AAPL | Stock | 3.0904 | 3.0907 | 3.0904 | 3.0907 | 11200.0 |
| 2006-11-21 07:30:00 | AAPL | Stock | 3.0946 | 3.0946 | 3.0946 | 3.0946 | 2800.0 |
| 2006-11-21 08:00:00 | AAPL | Stock | 3.0957 | 3.1446 | 3.0946 | 3.1321 | 4870432.0 |
| 2006-11-21 08:30:00 | AAPL | Stock | 3.135 | 3.1361 | 3.1239 | 3.125 | 2040024.0 |
| 2006-11-21 09:00:00 | AAPL | Stock | 3.1264 | 3.1286 | 3.1186 | 3.1221 | 2893548.0 |
| 2006-11-21 09:30:00 | AAPL | Stock | 3.1221 | 3.13 | 3.1111 | 3.1214 | 99748180.0 |
| 2006-11-21 10:00:00 | AAPL | Stock | 3.1218 | 3.1411 | 3.1196 | 3.1371 | 69065304.0 |
| 2006-11-21 10:30:00 | AAPL | Stock | 3.1371 | 3.1411 | 3.1243 | 3.1343 | 59376268.0 |
| 2006-11-21 11:00:00 | AAPL | Stock | 3.1343 | 3.1346 | 3.1232 | 3.1296 | 48761664.0 |
| 2006-11-21 11:30:00 | AAPL | Stock | 3.1296 | 3.1386 | 3.1257 | 3.1371 | 31394104.0 |
| 2006-11-21 12:00:00 | AAPL | Stock | 3.1368 | 3.1418 | 3.1357 | 3.1407 | 27296836.0 |
| 2006-11-21 12:30:00 | AAPL | Stock | 3.1404 | 3.1429 | 3.1368 | 3.1404 | 28438704.0 |
| 2006-11-21 13:00:00 | AAPL | Stock | 3.1404 | 3.1571 | 3.1379 | 3.1436 | 57546272.0 |
| 2006-11-21 13:30:00 | AAPL | Stock | 3.1436 | 3.155 | 3.1425 | 3.1461 | 26949860.0 |
| 2006-11-21 14:00:00 | AAPL | Stock | 3.1457 | 3.1518 | 3.1432 | 3.1489 | 28558936.0 |
| 2006-11-21 14:30:00 | AAPL | Stock | 3.1489 | 3.1554 | 3.1464 | 3.1521 | 22398096.0 |
| 2006-11-21 15:00:00 | AAPL | Stock | 3.1518 | 3.1586 | 3.1504 | 3.1547 | 32141116.0 |
| 2006-11-21 15:30:00 | AAPL | Stock | 3.155 | 3.1643 | 3.1525 | 3.1643 | 70990416.0 |
| 2006-11-21 16:00:00 | AAPL | Stock | 3.1632 | 3.1775 | 3.1632 | 3.175 | 1767052.0 |
| 2006-11-21 16:30:00 | AAPL | Stock | 3.1736 | 3.1764 | 3.1707 | 3.175 | 314776.0 |
| 2006-11-21 17:00:00 | AAPL | Stock | 3.1732 | 3.1757 | 3.1732 | 3.1757 | 397880.0 |
| 2006-11-21 17:30:00 | AAPL | Stock | 3.175 | 3.1761 | 3.1732 | 3.1732 | 412804.0 |
| 2006-11-21 18:00:00 | AAPL | Stock | 3.175 | 3.1764 | 3.175 | 3.175 | 55104.0 |
| 2006-11-21 18:30:00 | AAPL | Stock | 3.1743 | 3.175 | 3.1714 | 3.175 | 71960.0 |
| 2006-11-21 19:00:00 | AAPL | Stock | 3.1739 | 3.1786 | 3.1739 | 3.1786 | 615832.0 |
| 2006-11-21 19:30:00 | AAPL | Stock | 3.1786 | 3.1796 | 3.1757 | 3.1789 | 144424.0 |
| 2006-11-21 08:00:00 | MSFT | Stock | 29.94 | 29.98 | 29.9 | 29.94 | 13869.0 |
| 2006-11-21 08:30:00 | MSFT | Stock | 29.95 | 29.97 | 29.92 | 29.94 | 20990.0 |
| 2006-11-21 09:00:00 | MSFT | Stock | 29.93 | 29.97 | 29.9 | 29.9 | 28500.0 |
| 2006-11-21 09:30:00 | MSFT | Stock | 29.91 | 29.97 | 29.9 | 29.96 | 5974557.0 |
| 2006-11-21 10:00:00 | MSFT | Stock | 29.95 | 30.0 | 29.95 | 29.96 | 7006226.0 |
| 2006-11-21 10:30:00 | MSFT | Stock | 29.96 | 29.97 | 29.85 | 29.9 | 5245179.0 |
| 2006-11-21 11:00:00 | MSFT | Stock | 29.9 | 29.94 | 29.85 | 29.93 | 3721089.0 |
| 2006-11-21 11:30:00 | MSFT | Stock | 29.93 | 29.94 | 29.88 | 29.91 | 2949539.0 |
| 2006-11-21 12:00:00 | MSFT | Stock | 29.92 | 29.98 | 29.9 | 29.95 | 3531618.0 |
| 2006-11-21 12:30:00 | MSFT | Stock | 29.95 | 29.96 | 29.92 | 29.928 | 1421704.0 |
| 2006-11-21 13:00:00 | MSFT | Stock | 29.92 | 29.94 | 29.87 | 29.872 | 4139129.0 |
| 2006-11-21 13:30:00 | MSFT | Stock | 29.87 | 29.9 | 29.82 | 29.86 | 4650404.0 |
| 2006-11-21 14:00:00 | MSFT | Stock | 29.86 | 29.86 | 29.79 | 29.857 | 2521685.0 |
| 2006-11-21 14:30:00 | MSFT | Stock | 29.86 | 29.92 | 29.85 | 29.89 | 3017522.0 |
| 2006-11-21 15:00:00 | MSFT | Stock | 29.89 | 29.93 | 29.85 | 29.9 | 3383804.0 |
| 2006-11-21 15:30:00 | MSFT | Stock | 29.9 | 29.95 | 29.89 | 29.92 | 6120707.0 |
| 2006-11-21 16:00:00 | MSFT | Stock | 29.92 | 30.0 | 29.79 | 29.99 | 185166.0 |
| 2006-11-21 16:30:00 | MSFT | Stock | 29.98 | 29.99 | 29.93 | 29.99 | 407600.0 |
| 2006-11-21 17:00:00 | MSFT | Stock | 29.99 | 29.99 | 29.95 | 29.95 | 256450.0 |
| 2006-11-21 17:30:00 | MSFT | Stock | 29.99 | 29.99 | 29.98 | 29.99 | 2870.0 |
| 2006-11-21 18:00:00 | MSFT | Stock | 29.99 | 30.0 | 29.98 | 29.98 | 8766.0 |
| 2006-11-21 19:00:00 | MSFT | Stock | 29.99 | 29.99 | 29.94 | 29.94 | 5700.0 |
| 2006-11-21 19:30:00 | MSFT | Stock | 30.0 | 30.0 | 29.94 | 29.94 | 1525.0 |
> showing 50 of 52,191 rows — these rows as CSV