PREVIEW / stock_30min / 2008-07-11
file: by_date/stock_30min/2008/2008-07-11.parquet size: 1.2 MB rows: 68,729 symbols: 3,330
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-07-11 06:00:00 | AAPL | Stock | 6.3179 | 6.3179 | 6.3179 | 6.3179 | 11200.0 |
| 2008-07-11 06:30:00 | AAPL | Stock | 6.3179 | 6.3218 | 6.3071 | 6.3143 | 60200.0 |
| 2008-07-11 07:00:00 | AAPL | Stock | 6.3071 | 6.3171 | 6.2679 | 6.2682 | 238980.0 |
| 2008-07-11 07:30:00 | AAPL | Stock | 6.2679 | 6.2893 | 6.2429 | 6.2429 | 300496.0 |
| 2008-07-11 08:00:00 | AAPL | Stock | 6.25 | 6.2821 | 6.2321 | 6.24 | 1280160.0 |
| 2008-07-11 08:30:00 | AAPL | Stock | 6.2393 | 6.2604 | 6.2161 | 6.2268 | 1597008.0 |
| 2008-07-11 09:00:00 | AAPL | Stock | 6.2254 | 6.2832 | 6.2143 | 6.2664 | 3666376.0 |
| 2008-07-11 09:30:00 | AAPL | Stock | 6.2668 | 6.3254 | 6.1921 | 6.2957 | 117161156.0 |
| 2008-07-11 10:00:00 | AAPL | Stock | 6.2943 | 6.3214 | 6.2075 | 6.2318 | 80148712.0 |
| 2008-07-11 10:30:00 | AAPL | Stock | 6.2332 | 6.2604 | 6.2036 | 6.2443 | 50148588.0 |
| 2008-07-11 11:00:00 | AAPL | Stock | 6.2432 | 6.2564 | 6.1832 | 6.1918 | 51131388.0 |
| 2008-07-11 11:30:00 | AAPL | Stock | 6.1918 | 6.2321 | 6.1679 | 6.2218 | 51292332.0 |
| 2008-07-11 12:00:00 | AAPL | Stock | 6.2214 | 6.2311 | 6.1571 | 6.1911 | 43358924.0 |
| 2008-07-11 12:30:00 | AAPL | Stock | 6.1911 | 6.1996 | 6.1082 | 6.1179 | 62868148.0 |
| 2008-07-11 13:00:00 | AAPL | Stock | 6.1175 | 6.175 | 6.1071 | 6.1689 | 53954684.0 |
| 2008-07-11 13:30:00 | AAPL | Stock | 6.1693 | 6.2114 | 6.1504 | 6.1893 | 52847536.0 |
| 2008-07-11 14:00:00 | AAPL | Stock | 6.1893 | 6.2425 | 6.1582 | 6.1582 | 57718136.0 |
| 2008-07-11 14:30:00 | AAPL | Stock | 6.1614 | 6.2743 | 6.1369 | 6.2711 | 82333804.0 |
| 2008-07-11 15:00:00 | AAPL | Stock | 6.2714 | 6.3064 | 6.1964 | 6.2368 | 89286344.0 |
| 2008-07-11 15:30:00 | AAPL | Stock | 6.2375 | 6.2386 | 6.13 | 6.1643 | 97084064.0 |
| 2008-07-11 16:00:00 | AAPL | Stock | 6.1643 | 6.2119 | 6.1518 | 6.1525 | 16199120.0 |
| 2008-07-11 16:30:00 | AAPL | Stock | 6.1518 | 6.1636 | 6.1471 | 6.1604 | 2990932.0 |
| 2008-07-11 17:00:00 | AAPL | Stock | 6.1607 | 6.1768 | 6.1543 | 6.1696 | 395528.0 |
| 2008-07-11 17:30:00 | AAPL | Stock | 6.1739 | 6.1786 | 6.1725 | 6.175 | 305872.0 |
| 2008-07-11 18:00:00 | AAPL | Stock | 6.1782 | 6.1782 | 6.1636 | 6.175 | 162568.0 |
| 2008-07-11 18:30:00 | AAPL | Stock | 6.175 | 6.1779 | 6.1743 | 6.1743 | 19600.0 |
| 2008-07-11 19:00:00 | AAPL | Stock | 6.175 | 6.1779 | 6.175 | 6.1779 | 25900.0 |
| 2008-07-11 19:30:00 | AAPL | Stock | 6.1757 | 6.1757 | 6.1707 | 6.1725 | 93380.0 |
| 2008-07-11 07:00:00 | MSFT | Stock | 25.31 | 25.31 | 25.3 | 25.3 | 450.0 |
| 2008-07-11 07:30:00 | MSFT | Stock | 25.3 | 25.3 | 25.26 | 25.26 | 700.0 |
| 2008-07-11 08:00:00 | MSFT | Stock | 25.21 | 25.28 | 25.13 | 25.2 | 18050.0 |
| 2008-07-11 08:30:00 | MSFT | Stock | 25.2 | 25.21 | 25.15 | 25.15 | 9000.0 |
| 2008-07-11 09:00:00 | MSFT | Stock | 25.15 | 25.24 | 25.12 | 25.12 | 17023.0 |
| 2008-07-11 09:30:00 | MSFT | Stock | 25.13 | 25.2 | 25.05 | 25.15 | 6027435.0 |
| 2008-07-11 10:00:00 | MSFT | Stock | 25.15 | 25.23 | 24.96 | 24.99 | 6042281.0 |
| 2008-07-11 10:30:00 | MSFT | Stock | 24.98 | 25.03 | 24.87 | 25.01 | 4869737.0 |
| 2008-07-11 11:00:00 | MSFT | Stock | 25.01 | 25.05 | 24.9 | 24.93 | 3743925.0 |
| 2008-07-11 11:30:00 | MSFT | Stock | 24.93 | 25.15 | 24.87 | 25.142 | 4460213.0 |
| 2008-07-11 12:00:00 | MSFT | Stock | 25.15 | 25.19 | 25.02 | 25.09 | 2700623.0 |
| 2008-07-11 12:30:00 | MSFT | Stock | 25.09 | 25.152 | 24.99 | 25.03 | 3433167.0 |
| 2008-07-11 13:00:00 | MSFT | Stock | 25.03 | 25.08 | 24.88 | 24.99 | 4380004.0 |
| 2008-07-11 13:30:00 | MSFT | Stock | 24.98 | 25.19 | 24.98 | 25.135 | 4368166.0 |
| 2008-07-11 14:00:00 | MSFT | Stock | 25.14 | 25.23 | 25.05 | 25.1 | 3229399.0 |
| 2008-07-11 14:30:00 | MSFT | Stock | 25.09 | 25.52 | 25.07 | 25.43 | 5167207.0 |
| 2008-07-11 15:00:00 | MSFT | Stock | 25.43 | 25.64 | 25.27 | 25.3 | 7212567.0 |
| 2008-07-11 15:30:00 | MSFT | Stock | 25.3 | 25.41 | 25.08 | 25.25 | 8160689.0 |
| 2008-07-11 16:00:00 | MSFT | Stock | 25.25 | 25.38 | 24.915 | 25.24 | 2802262.0 |
| 2008-07-11 16:30:00 | MSFT | Stock | 25.25 | 25.25 | 25.154 | 25.25 | 19150.0 |
| 2008-07-11 17:00:00 | MSFT | Stock | 25.27 | 25.28 | 25.25 | 25.25 | 1590.0 |
| 2008-07-11 17:30:00 | MSFT | Stock | 25.26 | 25.28 | 25.25 | 25.28 | 401.0 |
> showing 50 of 68,729 rows — these rows as CSV