PREVIEW / stock_30min / 2006-12-11
file: by_date/stock_30min/2006/2006-12-11.parquet size: 956 KB rows: 52,442 symbols: 2,483
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-11 05:00:00 | AAPL | Stock | 3.1736 | 3.1736 | 3.1736 | 3.1736 | 2800.0 |
| 2006-12-11 07:30:00 | AAPL | Stock | 3.1714 | 3.1757 | 3.1714 | 3.1757 | 11200.0 |
| 2006-12-11 08:00:00 | AAPL | Stock | 3.1714 | 3.1907 | 3.1704 | 3.1839 | 1287300.0 |
| 2006-12-11 08:30:00 | AAPL | Stock | 3.1839 | 3.1857 | 3.1521 | 3.1521 | 283976.0 |
| 2006-12-11 09:00:00 | AAPL | Stock | 3.1804 | 3.1846 | 3.1714 | 3.1771 | 445564.0 |
| 2006-12-11 09:30:00 | AAPL | Stock | 3.175 | 3.1839 | 3.1446 | 3.1782 | 80414292.0 |
| 2006-12-11 10:00:00 | AAPL | Stock | 3.1782 | 3.1893 | 3.165 | 3.1754 | 73479532.0 |
| 2006-12-11 10:30:00 | AAPL | Stock | 3.175 | 3.1825 | 3.1679 | 3.1707 | 34153924.0 |
| 2006-12-11 11:00:00 | AAPL | Stock | 3.1707 | 3.1771 | 3.1686 | 3.1757 | 26447120.0 |
| 2006-12-11 11:30:00 | AAPL | Stock | 3.1761 | 3.1811 | 3.1707 | 3.1707 | 25776380.0 |
| 2006-12-11 12:00:00 | AAPL | Stock | 3.1707 | 3.1839 | 3.1518 | 3.1589 | 43046276.0 |
| 2006-12-11 12:30:00 | AAPL | Stock | 3.1593 | 3.1654 | 3.1564 | 3.1632 | 19270328.0 |
| 2006-12-11 13:00:00 | AAPL | Stock | 3.1632 | 3.1779 | 3.1582 | 3.1732 | 24486140.0 |
| 2006-12-11 13:30:00 | AAPL | Stock | 3.1736 | 3.1775 | 3.1682 | 3.1736 | 19714128.0 |
| 2006-12-11 14:00:00 | AAPL | Stock | 3.1736 | 3.1829 | 3.1689 | 3.1725 | 36643572.0 |
| 2006-12-11 14:30:00 | AAPL | Stock | 3.1725 | 3.1768 | 3.1714 | 3.1746 | 19112100.0 |
| 2006-12-11 15:00:00 | AAPL | Stock | 3.1746 | 3.1807 | 3.1686 | 3.1714 | 29400504.0 |
| 2006-12-11 15:30:00 | AAPL | Stock | 3.1718 | 3.1739 | 3.1646 | 3.1668 | 49618156.0 |
| 2006-12-11 16:00:00 | AAPL | Stock | 3.1696 | 3.1746 | 3.1696 | 3.1714 | 2390192.0 |
| 2006-12-11 16:30:00 | AAPL | Stock | 3.1707 | 3.1729 | 3.17 | 3.1714 | 422632.0 |
| 2006-12-11 17:00:00 | AAPL | Stock | 3.1729 | 3.1736 | 3.1696 | 3.1736 | 790916.0 |
| 2006-12-11 17:30:00 | AAPL | Stock | 3.1739 | 3.1743 | 3.1718 | 3.1718 | 143416.0 |
| 2006-12-11 18:00:00 | AAPL | Stock | 3.1739 | 3.1746 | 3.1696 | 3.1696 | 125188.0 |
| 2006-12-11 18:30:00 | AAPL | Stock | 3.1746 | 3.175 | 3.1746 | 3.175 | 60200.0 |
| 2006-12-11 19:00:00 | AAPL | Stock | 3.1768 | 3.1779 | 3.1721 | 3.1757 | 86604.0 |
| 2006-12-11 19:30:00 | AAPL | Stock | 3.1779 | 3.1782 | 3.1721 | 3.1782 | 58520.0 |
| 2006-12-11 07:30:00 | MSFT | Stock | 29.19 | 29.25 | 29.19 | 29.25 | 800.0 |
| 2006-12-11 08:00:00 | MSFT | Stock | 29.2 | 29.25 | 29.2 | 29.22 | 3700.0 |
| 2006-12-11 08:30:00 | MSFT | Stock | 29.22 | 29.4 | 29.2 | 29.28 | 53967.0 |
| 2006-12-11 09:00:00 | MSFT | Stock | 29.27 | 29.27 | 29.17 | 29.21 | 85643.0 |
| 2006-12-11 09:30:00 | MSFT | Stock | 29.19 | 29.38 | 29.11 | 29.22 | 6126057.0 |
| 2006-12-11 10:00:00 | MSFT | Stock | 29.22 | 29.45 | 29.21 | 29.44 | 7714711.0 |
| 2006-12-11 10:30:00 | MSFT | Stock | 29.44 | 29.68 | 29.42 | 29.58 | 48375701.0 |
| 2006-12-11 11:00:00 | MSFT | Stock | 29.58 | 29.75 | 29.53 | 29.73 | 5205085.0 |
| 2006-12-11 11:30:00 | MSFT | Stock | 29.73 | 29.75 | 29.64 | 29.64 | 3926594.0 |
| 2006-12-11 12:00:00 | MSFT | Stock | 29.65 | 29.66 | 29.56 | 29.65 | 5341819.0 |
| 2006-12-11 12:30:00 | MSFT | Stock | 29.66 | 29.69 | 29.63 | 29.668 | 2445230.0 |
| 2006-12-11 13:00:00 | MSFT | Stock | 29.67 | 29.73 | 29.66 | 29.7 | 3098284.0 |
| 2006-12-11 13:30:00 | MSFT | Stock | 29.69 | 29.73 | 29.65 | 29.65 | 3349972.0 |
| 2006-12-11 14:00:00 | MSFT | Stock | 29.65 | 29.711 | 29.59 | 29.63 | 2385865.0 |
| 2006-12-11 14:30:00 | MSFT | Stock | 29.64 | 29.7 | 29.63 | 29.632 | 2370951.0 |
| 2006-12-11 15:00:00 | MSFT | Stock | 29.63 | 29.66 | 29.55 | 29.58 | 4531817.0 |
| 2006-12-11 15:30:00 | MSFT | Stock | 29.59 | 29.62 | 29.49 | 29.56 | 9997724.0 |
| 2006-12-11 16:00:00 | MSFT | Stock | 29.56 | 29.56 | 29.53 | 29.56 | 324149.0 |
| 2006-12-11 16:30:00 | MSFT | Stock | 29.54 | 29.56 | 29.54 | 29.56 | 200200.0 |
| 2006-12-11 17:00:00 | MSFT | Stock | 29.56 | 29.56 | 29.444 | 29.55 | 264736.0 |
| 2006-12-11 17:30:00 | MSFT | Stock | 29.56 | 29.56 | 29.56 | 29.56 | 200.0 |
| 2006-12-11 18:00:00 | MSFT | Stock | 29.56 | 29.56 | 29.53 | 29.53 | 300.0 |
| 2006-12-11 18:30:00 | MSFT | Stock | 29.54 | 29.54 | 29.52 | 29.52 | 1978.0 |
| 2006-12-11 08:30:00 | NVDA | Stock | 0.5925 | 0.5925 | 0.5925 | 0.5925 | 27960.0 |
> showing 50 of 52,442 rows — these rows as CSV