PREVIEW / stock_30min / 2006-12-08
file: by_date/stock_30min/2006/2006-12-08.parquet size: 962 KB rows: 52,062 symbols: 2,454
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-08 04:00:00 | AAPL | Stock | 3.1064 | 3.1064 | 3.1064 | 3.1064 | 2800.0 |
| 2006-12-08 07:00:00 | AAPL | Stock | 3.1064 | 3.1064 | 3.1046 | 3.1046 | 19600.0 |
| 2006-12-08 07:30:00 | AAPL | Stock | 3.1064 | 3.1064 | 3.1032 | 3.1032 | 15148.0 |
| 2006-12-08 08:00:00 | AAPL | Stock | 3.1036 | 3.115 | 3.1 | 3.1054 | 1569316.0 |
| 2006-12-08 08:30:00 | AAPL | Stock | 3.1071 | 3.1332 | 3.1071 | 3.125 | 5461316.0 |
| 2006-12-08 09:00:00 | AAPL | Stock | 3.1232 | 3.1271 | 3.1079 | 3.1129 | 1778952.0 |
| 2006-12-08 09:30:00 | AAPL | Stock | 3.1154 | 3.1643 | 3.1071 | 3.1236 | 160376300.0 |
| 2006-12-08 10:00:00 | AAPL | Stock | 3.1236 | 3.1429 | 3.1093 | 3.14 | 91605080.0 |
| 2006-12-08 10:30:00 | AAPL | Stock | 3.14 | 3.1614 | 3.1329 | 3.1593 | 71480920.0 |
| 2006-12-08 11:00:00 | AAPL | Stock | 3.1589 | 3.1925 | 3.155 | 3.1836 | 96193300.0 |
| 2006-12-08 11:30:00 | AAPL | Stock | 3.1839 | 3.1879 | 3.1754 | 3.1764 | 54505248.0 |
| 2006-12-08 12:00:00 | AAPL | Stock | 3.1761 | 3.1861 | 3.1682 | 3.1779 | 39073468.0 |
| 2006-12-08 12:30:00 | AAPL | Stock | 3.1779 | 3.1829 | 3.1675 | 3.1811 | 29120756.0 |
| 2006-12-08 13:00:00 | AAPL | Stock | 3.1811 | 3.185 | 3.175 | 3.1761 | 24925124.0 |
| 2006-12-08 13:30:00 | AAPL | Stock | 3.1764 | 3.1779 | 3.1593 | 3.1636 | 40202456.0 |
| 2006-12-08 14:00:00 | AAPL | Stock | 3.1632 | 3.1675 | 3.1504 | 3.1525 | 43652392.0 |
| 2006-12-08 14:30:00 | AAPL | Stock | 3.1528 | 3.1661 | 3.1482 | 3.1611 | 35362152.0 |
| 2006-12-08 15:00:00 | AAPL | Stock | 3.1611 | 3.1611 | 3.1525 | 3.1575 | 27487544.0 |
| 2006-12-08 15:30:00 | AAPL | Stock | 3.1575 | 3.1586 | 3.1429 | 3.1529 | 54665016.0 |
| 2006-12-08 16:00:00 | AAPL | Stock | 3.1529 | 3.1554 | 3.1507 | 3.155 | 1156568.0 |
| 2006-12-08 16:30:00 | AAPL | Stock | 3.155 | 3.1557 | 3.1536 | 3.1557 | 439348.0 |
| 2006-12-08 17:00:00 | AAPL | Stock | 3.1554 | 3.1571 | 3.1554 | 3.1568 | 64736.0 |
| 2006-12-08 17:30:00 | AAPL | Stock | 3.1568 | 3.1621 | 3.1568 | 3.1607 | 203532.0 |
| 2006-12-08 18:00:00 | AAPL | Stock | 3.1589 | 3.1636 | 3.1575 | 3.1589 | 247352.0 |
| 2006-12-08 18:30:00 | AAPL | Stock | 3.1589 | 3.1625 | 3.1575 | 3.1607 | 133560.0 |
| 2006-12-08 19:00:00 | AAPL | Stock | 3.1604 | 3.1621 | 3.16 | 3.1621 | 129472.0 |
| 2006-12-08 19:30:00 | AAPL | Stock | 3.1618 | 3.1661 | 3.1618 | 3.1661 | 131012.0 |
| 2006-12-08 07:30:00 | MSFT | Stock | 28.81 | 28.81 | 28.81 | 28.81 | 500.0 |
| 2006-12-08 08:00:00 | MSFT | Stock | 28.84 | 28.85 | 28.79 | 28.79 | 2900.0 |
| 2006-12-08 08:30:00 | MSFT | Stock | 28.79 | 28.9 | 28.79 | 28.88 | 1523137.0 |
| 2006-12-08 09:00:00 | MSFT | Stock | 28.88 | 28.89 | 28.81 | 28.83 | 83791.0 |
| 2006-12-08 09:30:00 | MSFT | Stock | 28.81 | 28.93 | 28.8 | 28.88 | 4217757.0 |
| 2006-12-08 10:00:00 | MSFT | Stock | 28.89 | 28.94 | 28.85 | 28.94 | 4168995.0 |
| 2006-12-08 10:30:00 | MSFT | Stock | 28.94 | 28.94 | 28.88 | 28.89 | 1970637.0 |
| 2006-12-08 11:00:00 | MSFT | Stock | 28.89 | 28.96 | 28.89 | 28.94 | 4639767.0 |
| 2006-12-08 11:30:00 | MSFT | Stock | 28.95 | 28.99 | 28.91 | 28.95 | 2944580.0 |
| 2006-12-08 12:00:00 | MSFT | Stock | 28.95 | 29.0 | 28.82 | 28.92 | 8909424.0 |
| 2006-12-08 12:30:00 | MSFT | Stock | 28.93 | 28.96 | 28.89 | 28.96 | 1745053.0 |
| 2006-12-08 13:00:00 | MSFT | Stock | 28.95 | 28.96 | 28.91 | 28.91 | 1012022.0 |
| 2006-12-08 13:30:00 | MSFT | Stock | 28.91 | 28.92 | 28.87 | 28.88 | 2408227.0 |
| 2006-12-08 14:00:00 | MSFT | Stock | 28.877 | 28.91 | 28.87 | 28.89 | 1553946.0 |
| 2006-12-08 14:30:00 | MSFT | Stock | 28.88 | 28.95 | 28.88 | 28.93 | 4173880.0 |
| 2006-12-08 15:00:00 | MSFT | Stock | 28.94 | 29.09 | 28.93 | 29.09 | 18507468.0 |
| 2006-12-08 15:30:00 | MSFT | Stock | 29.09 | 29.11 | 28.8 | 29.08 | 20707788.0 |
| 2006-12-08 16:00:00 | MSFT | Stock | 29.11 | 29.4 | 29.07 | 29.19 | 5591791.0 |
| 2006-12-08 16:30:00 | MSFT | Stock | 29.18 | 29.23 | 29.16 | 29.2 | 305283.0 |
| 2006-12-08 17:00:00 | MSFT | Stock | 29.19 | 29.2 | 29.15 | 29.19 | 105154.0 |
| 2006-12-08 17:30:00 | MSFT | Stock | 29.19 | 29.19 | 29.18 | 29.19 | 2200.0 |
| 2006-12-08 18:00:00 | MSFT | Stock | 29.18 | 29.18 | 29.18 | 29.18 | 1900.0 |
| 2006-12-08 18:30:00 | MSFT | Stock | 29.2 | 29.2 | 29.19 | 29.2 | 6302.0 |
> showing 50 of 52,062 rows — these rows as CSV