PREVIEW / stock_30min / 2008-12-17
file: by_date/stock_30min/2008/2008-12-17.parquet size: 1.3 MB rows: 74,872 symbols: 3,363
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 |
|---|---|---|---|---|---|---|---|
| 2008-12-17 04:30:00 | AAPL | Stock | 3.3193 | 3.3193 | 3.3193 | 3.3193 | 2800.0 |
| 2008-12-17 05:30:00 | AAPL | Stock | 3.3482 | 3.3482 | 3.3482 | 3.3482 | 2800.0 |
| 2008-12-17 06:30:00 | AAPL | Stock | 3.3232 | 3.3232 | 3.2857 | 3.2861 | 383740.0 |
| 2008-12-17 07:00:00 | AAPL | Stock | 3.2982 | 3.3054 | 3.265 | 3.2661 | 495600.0 |
| 2008-12-17 07:30:00 | AAPL | Stock | 3.2575 | 3.2857 | 3.2571 | 3.2786 | 812392.0 |
| 2008-12-17 08:00:00 | AAPL | Stock | 3.2836 | 3.2857 | 3.2214 | 3.2607 | 7640472.0 |
| 2008-12-17 08:30:00 | AAPL | Stock | 3.2607 | 3.2786 | 3.2589 | 3.2782 | 3146276.0 |
| 2008-12-17 09:00:00 | AAPL | Stock | 3.2793 | 3.2814 | 3.2436 | 3.25 | 9725324.0 |
| 2008-12-17 09:30:00 | AAPL | Stock | 3.2511 | 3.2536 | 3.1911 | 3.214 | 230381984.0 |
| 2008-12-17 10:00:00 | AAPL | Stock | 3.2139 | 3.2175 | 3.1436 | 3.1793 | 171028844.0 |
| 2008-12-17 10:30:00 | AAPL | Stock | 3.1789 | 3.2018 | 3.1696 | 3.1786 | 90118280.0 |
| 2008-12-17 11:00:00 | AAPL | Stock | 3.1786 | 3.1857 | 3.1475 | 3.1639 | 89295248.0 |
| 2008-12-17 11:30:00 | AAPL | Stock | 3.1636 | 3.1921 | 3.1625 | 3.1729 | 58859668.0 |
| 2008-12-17 12:00:00 | AAPL | Stock | 3.1729 | 3.1936 | 3.1614 | 3.1768 | 78447152.0 |
| 2008-12-17 12:30:00 | AAPL | Stock | 3.1768 | 3.1889 | 3.1643 | 3.185 | 48387192.0 |
| 2008-12-17 13:00:00 | AAPL | Stock | 3.185 | 3.2054 | 3.175 | 3.1941 | 63116928.0 |
| 2008-12-17 13:30:00 | AAPL | Stock | 3.1929 | 3.225 | 3.1918 | 3.1986 | 88680620.0 |
| 2008-12-17 14:00:00 | AAPL | Stock | 3.1982 | 3.2161 | 3.1779 | 3.1811 | 55937784.0 |
| 2008-12-17 14:30:00 | AAPL | Stock | 3.1814 | 3.1904 | 3.1614 | 3.185 | 67600232.0 |
| 2008-12-17 15:00:00 | AAPL | Stock | 3.185 | 3.2 | 3.1682 | 3.1696 | 59221344.0 |
| 2008-12-17 15:30:00 | AAPL | Stock | 3.1693 | 3.2089 | 3.1643 | 3.1839 | 122203760.0 |
| 2008-12-17 16:00:00 | AAPL | Stock | 3.1821 | 3.1922 | 3.1768 | 3.1821 | 20324164.0 |
| 2008-12-17 16:30:00 | AAPL | Stock | 3.1821 | 3.1904 | 3.1807 | 3.1818 | 416304.0 |
| 2008-12-17 17:00:00 | AAPL | Stock | 3.1807 | 3.1843 | 3.1793 | 3.18 | 2663248.0 |
| 2008-12-17 17:30:00 | AAPL | Stock | 3.18 | 3.1818 | 3.1754 | 3.1786 | 365400.0 |
| 2008-12-17 18:00:00 | AAPL | Stock | 3.1779 | 3.1843 | 3.175 | 3.18 | 5211444.0 |
| 2008-12-17 18:30:00 | AAPL | Stock | 3.18 | 3.18 | 3.1754 | 3.1779 | 114324.0 |
| 2008-12-17 19:00:00 | AAPL | Stock | 3.1757 | 3.1768 | 3.1721 | 3.1761 | 247940.0 |
| 2008-12-17 19:30:00 | AAPL | Stock | 3.1754 | 3.1821 | 3.175 | 3.1754 | 253540.0 |
| 2008-12-17 20:00:00 | AAPL | Stock | 3.1843 | 3.1843 | 3.1843 | 3.1843 | 131600.0 |
| 2008-12-17 07:00:00 | MSFT | Stock | 19.85 | 19.85 | 19.72 | 19.72 | 800.0 |
| 2008-12-17 07:30:00 | MSFT | Stock | 19.75 | 19.83 | 19.75 | 19.83 | 897.0 |
| 2008-12-17 08:00:00 | MSFT | Stock | 19.85 | 19.87 | 19.8 | 19.85 | 7770.0 |
| 2008-12-17 08:30:00 | MSFT | Stock | 19.85 | 19.9 | 19.84 | 19.9 | 7187.0 |
| 2008-12-17 09:00:00 | MSFT | Stock | 19.9 | 19.95 | 19.79 | 19.79 | 25909.0 |
| 2008-12-17 09:30:00 | MSFT | Stock | 19.81 | 20.02 | 19.76 | 19.8 | 8722849.0 |
| 2008-12-17 10:00:00 | MSFT | Stock | 19.81 | 19.82 | 19.5 | 19.64 | 7227941.0 |
| 2008-12-17 10:30:00 | MSFT | Stock | 19.63 | 19.75 | 19.61 | 19.68 | 5006339.0 |
| 2008-12-17 11:00:00 | MSFT | Stock | 19.68 | 19.75 | 19.5 | 19.73 | 3728428.0 |
| 2008-12-17 11:30:00 | MSFT | Stock | 19.72 | 19.868 | 19.7 | 19.84 | 3378526.0 |
| 2008-12-17 12:00:00 | MSFT | Stock | 19.84 | 20.05 | 19.8 | 19.98 | 3731627.0 |
| 2008-12-17 12:30:00 | MSFT | Stock | 19.98 | 20.05 | 19.91 | 19.94 | 3097670.0 |
| 2008-12-17 13:00:00 | MSFT | Stock | 19.94 | 19.96 | 19.86 | 19.9 | 3692544.0 |
| 2008-12-17 13:30:00 | MSFT | Stock | 19.9 | 20.01 | 19.89 | 19.94 | 4010868.0 |
| 2008-12-17 14:00:00 | MSFT | Stock | 19.94 | 20.01 | 19.72 | 19.76 | 5826759.0 |
| 2008-12-17 14:30:00 | MSFT | Stock | 19.75 | 19.84 | 19.62 | 19.79 | 6773696.0 |
| 2008-12-17 15:00:00 | MSFT | Stock | 19.79 | 20.0 | 19.76 | 19.8 | 7121678.0 |
| 2008-12-17 15:30:00 | MSFT | Stock | 19.8 | 19.91 | 19.63 | 19.64 | 10081085.0 |
| 2008-12-17 16:00:00 | MSFT | Stock | 19.64 | 19.83 | 19.62 | 19.66 | 2927952.0 |
| 2008-12-17 16:30:00 | MSFT | Stock | 19.663 | 19.86 | 19.66 | 19.86 | 89929.0 |
> showing 50 of 74,872 rows — these rows as CSV