PREVIEW / stock_30min / 2006-12-14
file: by_date/stock_30min/2006/2006-12-14.parquet size: 963 KB rows: 52,536 symbols: 2,479
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-14 07:30:00 | AAPL | Stock | 3.1786 | 3.1893 | 3.1786 | 3.1811 | 352800.0 |
| 2006-12-14 08:00:00 | AAPL | Stock | 3.1857 | 3.1893 | 3.1736 | 3.1804 | 1958292.0 |
| 2006-12-14 08:30:00 | AAPL | Stock | 3.1804 | 3.1857 | 3.1746 | 3.175 | 1938608.0 |
| 2006-12-14 09:00:00 | AAPL | Stock | 3.1746 | 3.1964 | 3.1732 | 3.1804 | 2527532.0 |
| 2006-12-14 09:30:00 | AAPL | Stock | 3.1804 | 3.1864 | 3.1521 | 3.1664 | 133987812.0 |
| 2006-12-14 10:00:00 | AAPL | Stock | 3.1664 | 3.2143 | 3.1654 | 3.2107 | 151803988.0 |
| 2006-12-14 10:30:00 | AAPL | Stock | 3.211 | 3.2136 | 3.1946 | 3.2043 | 70025200.0 |
| 2006-12-14 11:00:00 | AAPL | Stock | 3.2043 | 3.2068 | 3.1918 | 3.2007 | 46482660.0 |
| 2006-12-14 11:30:00 | AAPL | Stock | 3.2 | 3.2039 | 3.1939 | 3.1957 | 33721548.0 |
| 2006-12-14 12:00:00 | AAPL | Stock | 3.1957 | 3.1996 | 3.1854 | 3.1911 | 37124864.0 |
| 2006-12-14 12:30:00 | AAPL | Stock | 3.1907 | 3.1946 | 3.1832 | 3.1925 | 38320688.0 |
| 2006-12-14 13:00:00 | AAPL | Stock | 3.1929 | 3.1989 | 3.1768 | 3.1907 | 49798196.0 |
| 2006-12-14 13:30:00 | AAPL | Stock | 3.1911 | 3.1989 | 3.1879 | 3.1911 | 39012988.0 |
| 2006-12-14 14:00:00 | AAPL | Stock | 3.1907 | 3.2021 | 3.1875 | 3.1971 | 33918696.0 |
| 2006-12-14 14:30:00 | AAPL | Stock | 3.1975 | 3.2043 | 3.1939 | 3.1968 | 31546536.0 |
| 2006-12-14 15:00:00 | AAPL | Stock | 3.1968 | 3.1982 | 3.1786 | 3.1814 | 51453416.0 |
| 2006-12-14 15:30:00 | AAPL | Stock | 3.1818 | 3.1889 | 3.1582 | 3.1614 | 88170264.0 |
| 2006-12-14 16:00:00 | AAPL | Stock | 3.1621 | 3.175 | 3.1575 | 3.1643 | 3184804.0 |
| 2006-12-14 16:30:00 | AAPL | Stock | 3.1643 | 3.1671 | 3.1625 | 3.1671 | 237608.0 |
| 2006-12-14 17:00:00 | AAPL | Stock | 3.1661 | 3.1671 | 3.1661 | 3.1671 | 179480.0 |
| 2006-12-14 17:30:00 | AAPL | Stock | 3.1671 | 3.1686 | 3.1671 | 3.1679 | 103600.0 |
| 2006-12-14 18:00:00 | AAPL | Stock | 3.1664 | 3.1696 | 3.1646 | 3.1664 | 94808.0 |
| 2006-12-14 18:30:00 | AAPL | Stock | 3.1664 | 3.1664 | 3.1643 | 3.1643 | 68236.0 |
| 2006-12-14 19:00:00 | AAPL | Stock | 3.1643 | 3.1675 | 3.1625 | 3.1675 | 91980.0 |
| 2006-12-14 19:30:00 | AAPL | Stock | 3.1693 | 3.1693 | 3.1661 | 3.1689 | 106400.0 |
| 2006-12-14 07:30:00 | MSFT | Stock | 29.53 | 29.53 | 29.53 | 29.53 | 500.0 |
| 2006-12-14 08:00:00 | MSFT | Stock | 29.55 | 29.55 | 29.53 | 29.55 | 2625.0 |
| 2006-12-14 08:30:00 | MSFT | Stock | 29.55 | 29.57 | 29.54 | 29.56 | 6960.0 |
| 2006-12-14 09:00:00 | MSFT | Stock | 29.58 | 29.58 | 29.51 | 29.53 | 36069.0 |
| 2006-12-14 09:30:00 | MSFT | Stock | 29.535 | 29.85 | 29.52 | 29.82 | 7312735.0 |
| 2006-12-14 10:00:00 | MSFT | Stock | 29.82 | 29.88 | 29.72 | 29.86 | 7151777.0 |
| 2006-12-14 10:30:00 | MSFT | Stock | 29.85 | 29.94 | 29.8 | 29.88 | 6585031.0 |
| 2006-12-14 11:00:00 | MSFT | Stock | 29.88 | 29.93 | 29.85 | 29.917 | 7156823.0 |
| 2006-12-14 11:30:00 | MSFT | Stock | 29.92 | 29.95 | 29.72 | 29.93 | 5059129.0 |
| 2006-12-14 12:00:00 | MSFT | Stock | 29.94 | 30.0 | 29.72 | 29.952 | 4405446.0 |
| 2006-12-14 12:30:00 | MSFT | Stock | 29.951 | 29.99 | 29.95 | 29.98 | 4877300.0 |
| 2006-12-14 13:00:00 | MSFT | Stock | 29.98 | 30.03 | 29.9 | 29.99 | 8538400.0 |
| 2006-12-14 13:30:00 | MSFT | Stock | 30.0 | 30.0 | 29.8 | 29.96 | 5585228.0 |
| 2006-12-14 14:00:00 | MSFT | Stock | 29.96 | 30.05 | 29.92 | 29.96 | 5202044.0 |
| 2006-12-14 14:30:00 | MSFT | Stock | 29.96 | 30.02 | 29.94 | 30.0 | 4386543.0 |
| 2006-12-14 15:00:00 | MSFT | Stock | 30.01 | 30.01 | 29.97 | 29.99 | 2925863.0 |
| 2006-12-14 15:30:00 | MSFT | Stock | 29.99 | 30.08 | 29.96 | 30.07 | 9258847.0 |
| 2006-12-14 16:00:00 | MSFT | Stock | 30.06 | 30.08 | 30.05 | 30.06 | 330224.0 |
| 2006-12-14 16:30:00 | MSFT | Stock | 30.06 | 30.07 | 30.04 | 30.05 | 43250.0 |
| 2006-12-14 17:00:00 | MSFT | Stock | 30.04 | 30.06 | 30.03 | 30.03 | 10135.0 |
| 2006-12-14 17:30:00 | MSFT | Stock | 30.03 | 30.07 | 30.03 | 30.03 | 1673700.0 |
| 2006-12-14 18:00:00 | MSFT | Stock | 30.04 | 30.04 | 30.03 | 30.04 | 1035.0 |
| 2006-12-14 18:30:00 | MSFT | Stock | 30.05 | 30.05 | 30.05 | 30.05 | 4915.0 |
| 2006-12-14 19:00:00 | MSFT | Stock | 30.06 | 30.06 | 30.03 | 30.05 | 2450.0 |
| 2006-12-14 19:30:00 | MSFT | Stock | 30.05 | 30.09 | 30.05 | 30.09 | 1050.0 |
> showing 50 of 52,536 rows — these rows as CSV