PREVIEW / stock_30min / 2008-12-19
file: by_date/stock_30min/2008/2008-12-19.parquet size: 1.3 MB rows: 74,582 symbols: 3,389
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-19 07:00:00 | AAPL | Stock | 3.1896 | 3.1896 | 3.1896 | 3.1896 | 4200.0 |
| 2008-12-19 07:30:00 | AAPL | Stock | 3.1896 | 3.1896 | 3.1896 | 3.1896 | 36400.0 |
| 2008-12-19 08:00:00 | AAPL | Stock | 3.2111 | 3.2143 | 3.1786 | 3.2118 | 780752.0 |
| 2008-12-19 08:30:00 | AAPL | Stock | 3.2107 | 3.2214 | 3.1939 | 3.2207 | 5713736.0 |
| 2008-12-19 09:00:00 | AAPL | Stock | 3.2214 | 3.2279 | 3.1939 | 3.2139 | 6696592.0 |
| 2008-12-19 09:30:00 | AAPL | Stock | 3.2107 | 3.2479 | 3.2 | 3.2161 | 175473452.0 |
| 2008-12-19 10:00:00 | AAPL | Stock | 3.2168 | 3.23 | 3.2054 | 3.2132 | 62030668.0 |
| 2008-12-19 10:30:00 | AAPL | Stock | 3.2139 | 3.2218 | 3.2039 | 3.2096 | 47400892.0 |
| 2008-12-19 11:00:00 | AAPL | Stock | 3.2096 | 3.2171 | 3.2043 | 3.2054 | 33055288.0 |
| 2008-12-19 11:30:00 | AAPL | Stock | 3.2057 | 3.2139 | 3.1904 | 3.1921 | 40175548.0 |
| 2008-12-19 12:00:00 | AAPL | Stock | 3.1921 | 3.1982 | 3.1764 | 3.1932 | 43106000.0 |
| 2008-12-19 12:30:00 | AAPL | Stock | 3.1936 | 3.2 | 3.1861 | 3.1914 | 26792864.0 |
| 2008-12-19 13:00:00 | AAPL | Stock | 3.1911 | 3.1954 | 3.1714 | 3.1933 | 32668748.0 |
| 2008-12-19 13:30:00 | AAPL | Stock | 3.1932 | 3.2136 | 3.1929 | 3.2061 | 46261740.0 |
| 2008-12-19 14:00:00 | AAPL | Stock | 3.2057 | 3.2121 | 3.1779 | 3.2036 | 35054600.0 |
| 2008-12-19 14:30:00 | AAPL | Stock | 3.2036 | 3.2179 | 3.195 | 3.205 | 41024788.0 |
| 2008-12-19 15:00:00 | AAPL | Stock | 3.2046 | 3.2104 | 3.1893 | 3.2071 | 57331680.0 |
| 2008-12-19 15:30:00 | AAPL | Stock | 3.2064 | 3.2114 | 3.1954 | 3.2107 | 80048808.0 |
| 2008-12-19 16:00:00 | AAPL | Stock | 3.2107 | 3.2159 | 3.2029 | 3.2143 | 50180424.0 |
| 2008-12-19 16:30:00 | AAPL | Stock | 3.2143 | 3.2161 | 3.2016 | 3.2139 | 2754024.0 |
| 2008-12-19 17:00:00 | AAPL | Stock | 3.2143 | 3.2154 | 3.2077 | 3.2143 | 2493232.0 |
| 2008-12-19 17:30:00 | AAPL | Stock | 3.2143 | 3.2145 | 3.2118 | 3.2143 | 381444.0 |
| 2008-12-19 18:00:00 | AAPL | Stock | 3.2121 | 3.2121 | 3.2111 | 3.2118 | 33600.0 |
| 2008-12-19 18:30:00 | AAPL | Stock | 3.2121 | 3.2125 | 3.2118 | 3.2118 | 36400.0 |
| 2008-12-19 19:00:00 | AAPL | Stock | 3.2139 | 3.2145 | 3.2129 | 3.2145 | 12929560.0 |
| 2008-12-19 19:30:00 | AAPL | Stock | 3.2125 | 3.2139 | 3.2125 | 3.2139 | 44968.0 |
| 2008-12-19 07:30:00 | MSFT | Stock | 19.56 | 19.56 | 19.49 | 19.49 | 550.0 |
| 2008-12-19 08:00:00 | MSFT | Stock | 19.4 | 19.46 | 19.39 | 19.45 | 5247.0 |
| 2008-12-19 08:30:00 | MSFT | Stock | 19.45 | 19.52 | 19.3 | 19.4 | 484123.0 |
| 2008-12-19 09:00:00 | MSFT | Stock | 19.39 | 19.42 | 19.3 | 19.42 | 504098.0 |
| 2008-12-19 09:30:00 | MSFT | Stock | 19.4 | 19.7 | 19.25 | 19.55 | 5975704.0 |
| 2008-12-19 10:00:00 | MSFT | Stock | 19.55 | 19.7 | 19.51 | 19.625 | 7035068.0 |
| 2008-12-19 10:30:00 | MSFT | Stock | 19.63 | 19.8 | 19.56 | 19.67 | 6431960.0 |
| 2008-12-19 11:00:00 | MSFT | Stock | 19.67 | 19.69 | 19.58 | 19.59 | 3963654.0 |
| 2008-12-19 11:30:00 | MSFT | Stock | 19.59 | 19.65 | 19.495 | 19.54 | 3695169.0 |
| 2008-12-19 12:00:00 | MSFT | Stock | 19.54 | 19.568 | 19.37 | 19.432 | 3197835.0 |
| 2008-12-19 12:30:00 | MSFT | Stock | 19.43 | 19.47 | 19.28 | 19.31 | 3234106.0 |
| 2008-12-19 13:00:00 | MSFT | Stock | 19.32 | 19.43 | 19.31 | 19.42 | 2326994.0 |
| 2008-12-19 13:30:00 | MSFT | Stock | 19.43 | 19.5 | 19.4 | 19.47 | 3836599.0 |
| 2008-12-19 14:00:00 | MSFT | Stock | 19.47 | 19.55 | 19.3 | 19.34 | 3360118.0 |
| 2008-12-19 14:30:00 | MSFT | Stock | 19.34 | 19.4 | 19.21 | 19.25 | 4340146.0 |
| 2008-12-19 15:00:00 | MSFT | Stock | 19.26 | 19.29 | 19.15 | 19.24 | 5508366.0 |
| 2008-12-19 15:30:00 | MSFT | Stock | 19.26 | 19.26 | 19.11 | 19.12 | 13286877.0 |
| 2008-12-19 16:00:00 | MSFT | Stock | 19.11 | 19.543 | 19.1 | 19.12 | 21745963.0 |
| 2008-12-19 16:30:00 | MSFT | Stock | 19.118 | 19.29 | 19.1 | 19.12 | 1585272.0 |
| 2008-12-19 17:00:00 | MSFT | Stock | 19.12 | 19.436 | 19.11 | 19.15 | 1192528.0 |
| 2008-12-19 17:30:00 | MSFT | Stock | 19.15 | 19.15 | 19.126 | 19.15 | 69231.0 |
| 2008-12-19 18:00:00 | MSFT | Stock | 19.15 | 19.16 | 19.15 | 19.16 | 5800.0 |
| 2008-12-19 18:30:00 | MSFT | Stock | 19.16 | 19.16 | 19.16 | 19.16 | 17178.0 |
| 2008-12-19 19:00:00 | MSFT | Stock | 19.17 | 19.19 | 19.126 | 19.126 | 1865855.0 |
> showing 50 of 74,582 rows — these rows as CSV