PREVIEW / stock_1min / 2011-03-24
file: by_date/stock_1min/2011/2011-03-24.parquet size: 13.1 MB rows: 979,071 symbols: 2,843
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-03-24 04:20:00 | AAPL | Stock | 12.1139 | 12.1139 | 12.1139 | 12.1139 | 2800.0 |
| 2011-03-24 05:25:00 | AAPL | Stock | 12.1475 | 12.1475 | 12.1475 | 12.1475 | 8400.0 |
| 2011-03-24 06:13:00 | AAPL | Stock | 12.1707 | 12.1707 | 12.1707 | 12.1707 | 2800.0 |
| 2011-03-24 06:16:00 | AAPL | Stock | 12.1821 | 12.1821 | 12.1821 | 12.1821 | 2800.0 |
| 2011-03-24 07:12:00 | AAPL | Stock | 12.1768 | 12.1768 | 12.1768 | 12.1768 | 5796.0 |
| 2011-03-24 07:14:00 | AAPL | Stock | 12.2007 | 12.2007 | 12.2007 | 12.2007 | 8400.0 |
| 2011-03-24 07:15:00 | AAPL | Stock | 12.2018 | 12.2018 | 12.2007 | 12.2007 | 8400.0 |
| 2011-03-24 07:16:00 | AAPL | Stock | 12.2007 | 12.2007 | 12.2007 | 12.2007 | 2800.0 |
| 2011-03-24 07:19:00 | AAPL | Stock | 12.2007 | 12.2039 | 12.2007 | 12.2039 | 30800.0 |
| 2011-03-24 07:20:00 | AAPL | Stock | 12.1896 | 12.1896 | 12.185 | 12.185 | 25200.0 |
| 2011-03-24 07:27:00 | AAPL | Stock | 12.1786 | 12.1786 | 12.1786 | 12.1786 | 2800.0 |
| 2011-03-24 07:31:00 | AAPL | Stock | 12.1893 | 12.1893 | 12.1786 | 12.1786 | 23800.0 |
| 2011-03-24 07:32:00 | AAPL | Stock | 12.1786 | 12.1786 | 12.1786 | 12.1786 | 8400.0 |
| 2011-03-24 07:36:00 | AAPL | Stock | 12.1857 | 12.1857 | 12.1857 | 12.1857 | 11200.0 |
| 2011-03-24 07:37:00 | AAPL | Stock | 12.1857 | 12.1857 | 12.1857 | 12.1857 | 5600.0 |
| 2011-03-24 07:38:00 | AAPL | Stock | 12.1857 | 12.1857 | 12.1857 | 12.1857 | 10360.0 |
| 2011-03-24 07:39:00 | AAPL | Stock | 12.19 | 12.1907 | 12.19 | 12.1907 | 14000.0 |
| 2011-03-24 07:41:00 | AAPL | Stock | 12.1832 | 12.1832 | 12.1818 | 12.1818 | 17024.0 |
| 2011-03-24 07:42:00 | AAPL | Stock | 12.18 | 12.18 | 12.18 | 12.18 | 5600.0 |
| 2011-03-24 07:43:00 | AAPL | Stock | 12.18 | 12.18 | 12.18 | 12.18 | 19600.0 |
| 2011-03-24 07:44:00 | AAPL | Stock | 12.18 | 12.18 | 12.18 | 12.18 | 2800.0 |
| 2011-03-24 07:47:00 | AAPL | Stock | 12.1843 | 12.1843 | 12.1843 | 12.1843 | 2800.0 |
| 2011-03-24 07:48:00 | AAPL | Stock | 12.1868 | 12.1868 | 12.1868 | 12.1868 | 2800.0 |
| 2011-03-24 07:55:00 | AAPL | Stock | 12.1854 | 12.1854 | 12.1854 | 12.1854 | 8400.0 |
| 2011-03-24 07:59:00 | AAPL | Stock | 12.1886 | 12.1886 | 12.1886 | 12.1886 | 2800.0 |
| 2011-03-24 08:00:00 | AAPL | Stock | 12.1879 | 12.1882 | 12.1821 | 12.1857 | 61124.0 |
| 2011-03-24 08:01:00 | AAPL | Stock | 12.1857 | 12.1932 | 12.1786 | 12.1932 | 57400.0 |
| 2011-03-24 08:02:00 | AAPL | Stock | 12.1964 | 12.2018 | 12.1964 | 12.1975 | 142968.0 |
| 2011-03-24 08:03:00 | AAPL | Stock | 12.1982 | 12.2036 | 12.1982 | 12.2036 | 28840.0 |
| 2011-03-24 08:04:00 | AAPL | Stock | 12.2036 | 12.2143 | 12.2 | 12.2143 | 134064.0 |
| 2011-03-24 08:05:00 | AAPL | Stock | 12.2143 | 12.2232 | 12.2143 | 12.2214 | 175280.0 |
| 2011-03-24 08:06:00 | AAPL | Stock | 12.2211 | 12.2286 | 12.2179 | 12.2286 | 66640.0 |
| 2011-03-24 08:07:00 | AAPL | Stock | 12.2254 | 12.2282 | 12.2254 | 12.2279 | 14000.0 |
| 2011-03-24 08:08:00 | AAPL | Stock | 12.2314 | 12.2314 | 12.2214 | 12.2218 | 79660.0 |
| 2011-03-24 08:09:00 | AAPL | Stock | 12.2214 | 12.2218 | 12.2211 | 12.2211 | 39200.0 |
| 2011-03-24 08:10:00 | AAPL | Stock | 12.2211 | 12.2243 | 12.2211 | 12.2243 | 46872.0 |
| 2011-03-24 08:11:00 | AAPL | Stock | 12.2211 | 12.2214 | 12.2143 | 12.2143 | 58800.0 |
| 2011-03-24 08:12:00 | AAPL | Stock | 12.2107 | 12.2107 | 12.2107 | 12.2107 | 2800.0 |
| 2011-03-24 08:13:00 | AAPL | Stock | 12.2143 | 12.2143 | 12.2143 | 12.2143 | 14000.0 |
| 2011-03-24 08:14:00 | AAPL | Stock | 12.2175 | 12.2182 | 12.2175 | 12.2182 | 12964.0 |
| 2011-03-24 08:15:00 | AAPL | Stock | 12.2211 | 12.2211 | 12.2211 | 12.2211 | 15764.0 |
| 2011-03-24 08:16:00 | AAPL | Stock | 12.2211 | 12.2211 | 12.2211 | 12.2211 | 3388.0 |
| 2011-03-24 08:17:00 | AAPL | Stock | 12.2211 | 12.2211 | 12.2211 | 12.2211 | 3416.0 |
| 2011-03-24 08:18:00 | AAPL | Stock | 12.2146 | 12.225 | 12.2143 | 12.2214 | 37100.0 |
| 2011-03-24 08:19:00 | AAPL | Stock | 12.2214 | 12.2214 | 12.2214 | 12.2214 | 5600.0 |
| 2011-03-24 08:20:00 | AAPL | Stock | 12.2182 | 12.2182 | 12.2107 | 12.2107 | 6384.0 |
| 2011-03-24 08:21:00 | AAPL | Stock | 12.2143 | 12.2143 | 12.2143 | 12.2143 | 2800.0 |
| 2011-03-24 08:23:00 | AAPL | Stock | 12.2086 | 12.2086 | 12.2054 | 12.2075 | 28000.0 |
| 2011-03-24 08:24:00 | AAPL | Stock | 12.1982 | 12.2 | 12.1964 | 12.2 | 74004.0 |
| 2011-03-24 08:25:00 | AAPL | Stock | 12.2025 | 12.2032 | 12.1932 | 12.1932 | 160048.0 |
> showing 50 of 979,071 rows — these rows as CSV