PREVIEW / stock_1min / 2011-11-21
file: by_date/stock_1min/2011/2011-11-21.parquet size: 13.1 MB rows: 979,651 symbols: 2,848
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-11-21 04:03:00 | AAPL | Stock | 13.1821 | 13.1821 | 13.1821 | 13.1821 | 2800.0 |
| 2011-11-21 04:05:00 | AAPL | Stock | 13.1925 | 13.1925 | 13.1925 | 13.1925 | 5600.0 |
| 2011-11-21 04:07:00 | AAPL | Stock | 13.1921 | 13.1921 | 13.1921 | 13.1921 | 2800.0 |
| 2011-11-21 04:23:00 | AAPL | Stock | 13.1975 | 13.1975 | 13.1975 | 13.1975 | 2800.0 |
| 2011-11-21 04:32:00 | AAPL | Stock | 13.1893 | 13.1893 | 13.1893 | 13.1893 | 4200.0 |
| 2011-11-21 04:50:00 | AAPL | Stock | 13.1389 | 13.1389 | 13.1389 | 13.1389 | 2800.0 |
| 2011-11-21 04:52:00 | AAPL | Stock | 13.1354 | 13.1382 | 13.1332 | 13.1382 | 42000.0 |
| 2011-11-21 04:54:00 | AAPL | Stock | 13.1382 | 13.1382 | 13.1382 | 13.1382 | 2800.0 |
| 2011-11-21 04:55:00 | AAPL | Stock | 13.1332 | 13.1339 | 13.1332 | 13.1339 | 8400.0 |
| 2011-11-21 04:56:00 | AAPL | Stock | 13.1404 | 13.1429 | 13.1404 | 13.1429 | 22400.0 |
| 2011-11-21 04:57:00 | AAPL | Stock | 13.14 | 13.1429 | 13.14 | 13.1429 | 19600.0 |
| 2011-11-21 05:00:00 | AAPL | Stock | 13.1518 | 13.1518 | 13.1518 | 13.1518 | 2800.0 |
| 2011-11-21 05:02:00 | AAPL | Stock | 13.1518 | 13.1518 | 13.1518 | 13.1518 | 5600.0 |
| 2011-11-21 05:35:00 | AAPL | Stock | 13.1836 | 13.1836 | 13.1786 | 13.1786 | 11200.0 |
| 2011-11-21 05:38:00 | AAPL | Stock | 13.1786 | 13.1786 | 13.1786 | 13.1786 | 5600.0 |
| 2011-11-21 05:52:00 | AAPL | Stock | 13.1789 | 13.1789 | 13.1789 | 13.1789 | 2800.0 |
| 2011-11-21 05:53:00 | AAPL | Stock | 13.2093 | 13.2093 | 13.2093 | 13.2093 | 37240.0 |
| 2011-11-21 05:54:00 | AAPL | Stock | 13.2093 | 13.2093 | 13.1786 | 13.1786 | 5600.0 |
| 2011-11-21 05:57:00 | AAPL | Stock | 13.2136 | 13.2136 | 13.2136 | 13.2136 | 2800.0 |
| 2011-11-21 06:11:00 | AAPL | Stock | 13.2046 | 13.2046 | 13.2046 | 13.2046 | 2800.0 |
| 2011-11-21 06:41:00 | AAPL | Stock | 13.2104 | 13.2104 | 13.2104 | 13.2104 | 5600.0 |
| 2011-11-21 07:00:00 | AAPL | Stock | 13.2143 | 13.2143 | 13.2143 | 13.2143 | 16772.0 |
| 2011-11-21 07:01:00 | AAPL | Stock | 13.2143 | 13.2143 | 13.1964 | 13.1964 | 10500.0 |
| 2011-11-21 07:05:00 | AAPL | Stock | 13.2089 | 13.2143 | 13.2089 | 13.2143 | 10360.0 |
| 2011-11-21 07:06:00 | AAPL | Stock | 13.2089 | 13.2089 | 13.2089 | 13.2089 | 5600.0 |
| 2011-11-21 07:08:00 | AAPL | Stock | 13.2093 | 13.2143 | 13.2093 | 13.2093 | 44800.0 |
| 2011-11-21 07:09:00 | AAPL | Stock | 13.2089 | 13.2089 | 13.2089 | 13.2089 | 2800.0 |
| 2011-11-21 07:11:00 | AAPL | Stock | 13.2071 | 13.2071 | 13.2071 | 13.2071 | 14000.0 |
| 2011-11-21 07:13:00 | AAPL | Stock | 13.2004 | 13.2071 | 13.1964 | 13.2 | 35280.0 |
| 2011-11-21 07:14:00 | AAPL | Stock | 13.1964 | 13.1964 | 13.1964 | 13.1964 | 6720.0 |
| 2011-11-21 07:15:00 | AAPL | Stock | 13.2068 | 13.2068 | 13.2068 | 13.2068 | 2800.0 |
| 2011-11-21 07:16:00 | AAPL | Stock | 13.2068 | 13.2068 | 13.2054 | 13.2054 | 42140.0 |
| 2011-11-21 07:17:00 | AAPL | Stock | 13.2143 | 13.2143 | 13.2143 | 13.2143 | 56000.0 |
| 2011-11-21 07:18:00 | AAPL | Stock | 13.2139 | 13.2143 | 13.2139 | 13.2143 | 47516.0 |
| 2011-11-21 07:19:00 | AAPL | Stock | 13.2039 | 13.2039 | 13.2039 | 13.2039 | 2800.0 |
| 2011-11-21 07:20:00 | AAPL | Stock | 13.2071 | 13.2071 | 13.2071 | 13.2071 | 2800.0 |
| 2011-11-21 07:21:00 | AAPL | Stock | 13.2071 | 13.2071 | 13.2071 | 13.2071 | 2800.0 |
| 2011-11-21 07:24:00 | AAPL | Stock | 13.2107 | 13.2107 | 13.2107 | 13.2107 | 21700.0 |
| 2011-11-21 07:25:00 | AAPL | Stock | 13.2143 | 13.2143 | 13.2143 | 13.2143 | 30800.0 |
| 2011-11-21 07:26:00 | AAPL | Stock | 13.2129 | 13.2232 | 13.2129 | 13.2232 | 30856.0 |
| 2011-11-21 07:30:00 | AAPL | Stock | 13.2218 | 13.2321 | 13.2218 | 13.2321 | 6720.0 |
| 2011-11-21 07:32:00 | AAPL | Stock | 13.2289 | 13.2289 | 13.2289 | 13.2289 | 2800.0 |
| 2011-11-21 07:33:00 | AAPL | Stock | 13.2321 | 13.2321 | 13.2321 | 13.2321 | 7700.0 |
| 2011-11-21 07:35:00 | AAPL | Stock | 13.2321 | 13.2321 | 13.2321 | 13.2321 | 5600.0 |
| 2011-11-21 07:36:00 | AAPL | Stock | 13.2321 | 13.2321 | 13.2321 | 13.2321 | 2800.0 |
| 2011-11-21 07:37:00 | AAPL | Stock | 13.2321 | 13.2321 | 13.2321 | 13.2321 | 14000.0 |
| 2011-11-21 07:42:00 | AAPL | Stock | 13.22 | 13.22 | 13.22 | 13.22 | 2800.0 |
| 2011-11-21 07:43:00 | AAPL | Stock | 13.2179 | 13.225 | 13.2179 | 13.225 | 5600.0 |
| 2011-11-21 07:50:00 | AAPL | Stock | 13.2232 | 13.2232 | 13.2232 | 13.2232 | 2800.0 |
| 2011-11-21 07:51:00 | AAPL | Stock | 13.2304 | 13.2304 | 13.2304 | 13.2304 | 4340.0 |
> showing 50 of 979,651 rows — these rows as CSV