PREVIEW / stock_5min / 2011-12-22
file: by_date/stock_5min/2011/2011-12-22.parquet size: 4.7 MB rows: 324,122 symbols: 3,536
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-22 04:00:00 | AAPL | Stock | 14.1429 | 14.2114 | 14.1429 | 14.2114 | 14000.0 |
| 2011-12-22 04:45:00 | AAPL | Stock | 14.1936 | 14.1936 | 14.1936 | 14.1936 | 2800.0 |
| 2011-12-22 05:35:00 | AAPL | Stock | 14.1429 | 14.1429 | 14.1429 | 14.1429 | 8400.0 |
| 2011-12-22 05:40:00 | AAPL | Stock | 14.1454 | 14.1454 | 14.1454 | 14.1454 | 5600.0 |
| 2011-12-22 06:05:00 | AAPL | Stock | 14.1489 | 14.1489 | 14.1432 | 14.1432 | 5600.0 |
| 2011-12-22 06:15:00 | AAPL | Stock | 14.1493 | 14.1493 | 14.1493 | 14.1493 | 2800.0 |
| 2011-12-22 06:20:00 | AAPL | Stock | 14.1493 | 14.1493 | 14.1493 | 14.1493 | 2800.0 |
| 2011-12-22 06:45:00 | AAPL | Stock | 14.1536 | 14.1536 | 14.1536 | 14.1536 | 5600.0 |
| 2011-12-22 06:50:00 | AAPL | Stock | 14.1536 | 14.1536 | 14.1536 | 14.1536 | 5600.0 |
| 2011-12-22 07:00:00 | AAPL | Stock | 14.1625 | 14.1736 | 14.1625 | 14.1736 | 14000.0 |
| 2011-12-22 07:10:00 | AAPL | Stock | 14.1557 | 14.1557 | 14.1557 | 14.1557 | 2800.0 |
| 2011-12-22 07:20:00 | AAPL | Stock | 14.1786 | 14.1875 | 14.1786 | 14.1875 | 11200.0 |
| 2011-12-22 07:25:00 | AAPL | Stock | 14.1861 | 14.1861 | 14.1786 | 14.1786 | 8400.0 |
| 2011-12-22 07:30:00 | AAPL | Stock | 14.1836 | 14.1839 | 14.1836 | 14.1839 | 44520.0 |
| 2011-12-22 07:35:00 | AAPL | Stock | 14.1857 | 14.1964 | 14.1857 | 14.1964 | 34720.0 |
| 2011-12-22 07:40:00 | AAPL | Stock | 14.1964 | 14.1964 | 14.1918 | 14.1918 | 28000.0 |
| 2011-12-22 07:45:00 | AAPL | Stock | 14.19 | 14.1921 | 14.19 | 14.1921 | 11200.0 |
| 2011-12-22 07:50:00 | AAPL | Stock | 14.1882 | 14.1882 | 14.1875 | 14.1875 | 14000.0 |
| 2011-12-22 07:55:00 | AAPL | Stock | 14.1882 | 14.1964 | 14.1882 | 14.1964 | 34076.0 |
| 2011-12-22 08:00:00 | AAPL | Stock | 14.1925 | 14.1946 | 14.1857 | 14.1893 | 97804.0 |
| 2011-12-22 08:05:00 | AAPL | Stock | 14.1904 | 14.1964 | 14.1904 | 14.1961 | 63392.0 |
| 2011-12-22 08:10:00 | AAPL | Stock | 14.19 | 14.1964 | 14.1893 | 14.1957 | 65660.0 |
| 2011-12-22 08:15:00 | AAPL | Stock | 14.1946 | 14.1961 | 14.1896 | 14.1961 | 71960.0 |
| 2011-12-22 08:20:00 | AAPL | Stock | 14.1961 | 14.205 | 14.1961 | 14.2046 | 115136.0 |
| 2011-12-22 08:25:00 | AAPL | Stock | 14.2054 | 14.2179 | 14.1975 | 14.2139 | 343560.0 |
| 2011-12-22 08:30:00 | AAPL | Stock | 14.2143 | 14.2175 | 14.2 | 14.2011 | 169008.0 |
| 2011-12-22 08:35:00 | AAPL | Stock | 14.2036 | 14.2143 | 14.2018 | 14.2125 | 99232.0 |
| 2011-12-22 08:40:00 | AAPL | Stock | 14.2125 | 14.2143 | 14.2 | 14.2025 | 203756.0 |
| 2011-12-22 08:45:00 | AAPL | Stock | 14.2043 | 14.2075 | 14.2004 | 14.2032 | 64624.0 |
| 2011-12-22 08:50:00 | AAPL | Stock | 14.2018 | 14.2018 | 14.1839 | 14.1875 | 465248.0 |
| 2011-12-22 08:55:00 | AAPL | Stock | 14.1886 | 14.1886 | 14.1786 | 14.1786 | 78120.0 |
| 2011-12-22 09:00:00 | AAPL | Stock | 14.1839 | 14.1904 | 14.1793 | 14.1889 | 201628.0 |
| 2011-12-22 09:05:00 | AAPL | Stock | 14.1832 | 14.1929 | 14.1832 | 14.1832 | 127596.0 |
| 2011-12-22 09:10:00 | AAPL | Stock | 14.1943 | 14.1943 | 14.1904 | 14.1925 | 47600.0 |
| 2011-12-22 09:15:00 | AAPL | Stock | 14.1886 | 14.1886 | 14.1832 | 14.1832 | 71260.0 |
| 2011-12-22 09:20:00 | AAPL | Stock | 14.1821 | 14.1854 | 14.1821 | 14.1854 | 16800.0 |
| 2011-12-22 09:25:00 | AAPL | Stock | 14.1857 | 14.1875 | 14.1786 | 14.1789 | 403032.0 |
| 2011-12-22 09:30:00 | AAPL | Stock | 14.1789 | 14.1936 | 14.1464 | 14.1852 | 8969072.0 |
| 2011-12-22 09:35:00 | AAPL | Stock | 14.1839 | 14.2246 | 14.1821 | 14.2196 | 10044440.0 |
| 2011-12-22 09:40:00 | AAPL | Stock | 14.2204 | 14.2454 | 14.2196 | 14.2418 | 7802172.0 |
| 2011-12-22 09:45:00 | AAPL | Stock | 14.2416 | 14.2443 | 14.2311 | 14.2356 | 5278392.0 |
| 2011-12-22 09:50:00 | AAPL | Stock | 14.2356 | 14.2404 | 14.2293 | 14.2382 | 3122196.0 |
| 2011-12-22 09:55:00 | AAPL | Stock | 14.2375 | 14.2414 | 14.205 | 14.2196 | 6086332.0 |
| 2011-12-22 10:00:00 | AAPL | Stock | 14.2232 | 14.2371 | 14.2075 | 14.2143 | 4053168.0 |
| 2011-12-22 10:05:00 | AAPL | Stock | 14.2097 | 14.2217 | 14.2054 | 14.2093 | 4100096.0 |
| 2011-12-22 10:10:00 | AAPL | Stock | 14.2071 | 14.2168 | 14.2039 | 14.2146 | 3346560.0 |
| 2011-12-22 10:15:00 | AAPL | Stock | 14.2146 | 14.2221 | 14.21 | 14.2221 | 2381036.0 |
| 2011-12-22 10:20:00 | AAPL | Stock | 14.2214 | 14.2289 | 14.2167 | 14.2221 | 2066232.0 |
| 2011-12-22 10:25:00 | AAPL | Stock | 14.2221 | 14.2393 | 14.2204 | 14.2303 | 3317636.0 |
| 2011-12-22 10:30:00 | AAPL | Stock | 14.2304 | 14.2357 | 14.2225 | 14.2236 | 2129764.0 |
> showing 50 of 324,122 rows — these rows as CSV