PREVIEW / stock_30min / 2006-07-21
file: by_date/stock_30min/2006/2006-07-21.parquet size: 902 KB rows: 49,248 symbols: 2,297
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-07-21 04:00:00 | AAPL | Stock | 2.1679 | 2.1679 | 2.1625 | 2.1625 | 77000.0 |
| 2006-07-21 04:30:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1571 | 2.1571 | 64400.0 |
| 2006-07-21 07:30:00 | AAPL | Stock | 2.1571 | 2.1571 | 2.1429 | 2.1429 | 103376.0 |
| 2006-07-21 08:00:00 | AAPL | Stock | 2.1536 | 2.1564 | 2.1257 | 2.1321 | 3327800.0 |
| 2006-07-21 08:30:00 | AAPL | Stock | 2.1321 | 2.1375 | 2.1289 | 2.1357 | 1188068.0 |
| 2006-07-21 09:00:00 | AAPL | Stock | 2.1364 | 2.1411 | 2.1293 | 2.1332 | 6423564.0 |
| 2006-07-21 09:30:00 | AAPL | Stock | 2.1364 | 2.1579 | 2.13 | 2.1475 | 156137296.0 |
| 2006-07-21 10:00:00 | AAPL | Stock | 2.1471 | 2.1561 | 2.1393 | 2.1521 | 90712216.0 |
| 2006-07-21 10:30:00 | AAPL | Stock | 2.1518 | 2.1782 | 2.1468 | 2.1725 | 99769012.0 |
| 2006-07-21 11:00:00 | AAPL | Stock | 2.1725 | 2.18 | 2.1632 | 2.1664 | 58051364.0 |
| 2006-07-21 11:30:00 | AAPL | Stock | 2.1668 | 2.1839 | 2.1661 | 2.1818 | 46708620.0 |
| 2006-07-21 12:00:00 | AAPL | Stock | 2.1814 | 2.1818 | 2.1657 | 2.1705 | 36366568.0 |
| 2006-07-21 12:30:00 | AAPL | Stock | 2.1707 | 2.1775 | 2.1671 | 2.1739 | 40250868.0 |
| 2006-07-21 13:00:00 | AAPL | Stock | 2.1739 | 2.1779 | 2.1689 | 2.1707 | 31434760.0 |
| 2006-07-21 13:30:00 | AAPL | Stock | 2.1704 | 2.1782 | 2.1675 | 2.1682 | 39540144.0 |
| 2006-07-21 14:00:00 | AAPL | Stock | 2.1682 | 2.1689 | 2.1529 | 2.1654 | 54991804.0 |
| 2006-07-21 14:30:00 | AAPL | Stock | 2.1657 | 2.1679 | 2.1593 | 2.1621 | 49380156.0 |
| 2006-07-21 15:00:00 | AAPL | Stock | 2.1621 | 2.1661 | 2.1457 | 2.1561 | 74663876.0 |
| 2006-07-21 15:30:00 | AAPL | Stock | 2.1561 | 2.1739 | 2.1557 | 2.17 | 91184100.0 |
| 2006-07-21 16:00:00 | AAPL | Stock | 2.1689 | 2.1714 | 2.1675 | 2.1682 | 1225616.0 |
| 2006-07-21 16:30:00 | AAPL | Stock | 2.1714 | 2.1743 | 2.1696 | 2.1714 | 454468.0 |
| 2006-07-21 17:00:00 | AAPL | Stock | 2.1732 | 2.1739 | 2.1686 | 2.1686 | 252784.0 |
| 2006-07-21 17:30:00 | AAPL | Stock | 2.1696 | 2.1711 | 2.1696 | 2.1711 | 98000.0 |
| 2006-07-21 18:00:00 | AAPL | Stock | 2.1696 | 2.1696 | 2.1689 | 2.1689 | 91000.0 |
| 2006-07-21 05:30:00 | MSFT | Stock | 23.98 | 24.05 | 23.98 | 24.05 | 400.0 |
| 2006-07-21 06:00:00 | MSFT | Stock | 24.01 | 24.01 | 23.98 | 23.98 | 2100.0 |
| 2006-07-21 07:00:00 | MSFT | Stock | 24.02 | 24.11 | 24.02 | 24.11 | 1350.0 |
| 2006-07-21 07:30:00 | MSFT | Stock | 23.9 | 24.01 | 23.75 | 24.01 | 44944.0 |
| 2006-07-21 08:00:00 | MSFT | Stock | 23.96 | 24.27 | 23.87 | 24.25 | 1327397.0 |
| 2006-07-21 08:30:00 | MSFT | Stock | 24.25 | 24.36 | 24.15 | 24.25 | 2034220.0 |
| 2006-07-21 09:00:00 | MSFT | Stock | 24.24 | 24.27 | 23.92 | 24.07 | 2578255.0 |
| 2006-07-21 09:30:00 | MSFT | Stock | 24.08 | 24.15 | 23.78 | 23.82 | 47852602.0 |
| 2006-07-21 10:00:00 | MSFT | Stock | 23.83 | 23.91 | 23.0 | 23.79 | 19449340.0 |
| 2006-07-21 10:30:00 | MSFT | Stock | 23.79 | 24.04 | 23.77 | 23.9 | 10392951.0 |
| 2006-07-21 11:00:00 | MSFT | Stock | 23.9 | 23.94 | 23.77 | 23.8 | 8188962.0 |
| 2006-07-21 11:30:00 | MSFT | Stock | 23.8 | 23.92 | 23.78 | 23.89 | 7126683.0 |
| 2006-07-21 12:00:00 | MSFT | Stock | 23.89 | 23.91 | 23.7 | 23.89 | 5027854.0 |
| 2006-07-21 12:30:00 | MSFT | Stock | 23.89 | 23.92 | 23.84 | 23.9 | 4840239.0 |
| 2006-07-21 13:00:00 | MSFT | Stock | 23.9 | 23.951 | 23.88 | 23.937 | 11001012.0 |
| 2006-07-21 13:30:00 | MSFT | Stock | 23.94 | 24.1 | 23.92 | 23.98 | 9090902.0 |
| 2006-07-21 14:00:00 | MSFT | Stock | 23.98 | 24.0 | 23.7 | 23.99 | 6498590.0 |
| 2006-07-21 14:30:00 | MSFT | Stock | 23.99 | 24.08 | 23.92 | 23.94 | 8698807.0 |
| 2006-07-21 15:00:00 | MSFT | Stock | 23.94 | 23.95 | 23.78 | 23.81 | 10603304.0 |
| 2006-07-21 15:30:00 | MSFT | Stock | 23.81 | 23.9 | 23.76 | 23.84 | 12724286.0 |
| 2006-07-21 16:00:00 | MSFT | Stock | 23.86 | 23.88 | 23.8 | 23.8 | 3882851.0 |
| 2006-07-21 16:30:00 | MSFT | Stock | 23.87 | 23.87 | 23.81 | 23.81 | 702828.0 |
| 2006-07-21 17:00:00 | MSFT | Stock | 23.82 | 23.83 | 23.8 | 23.83 | 8945.0 |
| 2006-07-21 17:30:00 | MSFT | Stock | 23.83 | 23.87 | 23.83 | 23.87 | 2401.0 |
| 2006-07-21 18:00:00 | MSFT | Stock | 23.83 | 23.85 | 23.83 | 23.85 | 5200.0 |
| 2006-07-21 07:30:00 | NVDA | Stock | 0.3127 | 0.3127 | 0.3127 | 0.3127 | 12000.0 |
> showing 50 of 49,248 rows — these rows as CSV