PREVIEW / stock_1min / 2011-08-05
file: by_date/stock_1min/2011/2011-08-05.parquet size: 16.7 MB rows: 1,188,860 symbols: 2,875
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-08-05 04:00:00 | AAPL | Stock | 13.3929 | 13.3929 | 13.3929 | 13.3929 | 28000.0 |
| 2011-08-05 04:02:00 | AAPL | Stock | 13.1471 | 13.1479 | 13.1471 | 13.1479 | 8400.0 |
| 2011-08-05 04:03:00 | AAPL | Stock | 13.1482 | 13.165 | 13.1482 | 13.1589 | 8400.0 |
| 2011-08-05 04:04:00 | AAPL | Stock | 13.1611 | 13.1611 | 13.1611 | 13.1611 | 2800.0 |
| 2011-08-05 04:05:00 | AAPL | Stock | 13.1471 | 13.1471 | 13.1471 | 13.1471 | 5600.0 |
| 2011-08-05 04:10:00 | AAPL | Stock | 13.125 | 13.125 | 13.125 | 13.125 | 5600.0 |
| 2011-08-05 04:11:00 | AAPL | Stock | 13.1429 | 13.1429 | 13.1429 | 13.1429 | 5600.0 |
| 2011-08-05 04:15:00 | AAPL | Stock | 13.0929 | 13.0929 | 13.0929 | 13.0929 | 5600.0 |
| 2011-08-05 04:17:00 | AAPL | Stock | 13.0714 | 13.0714 | 13.0714 | 13.0714 | 5600.0 |
| 2011-08-05 04:19:00 | AAPL | Stock | 13.1061 | 13.1061 | 13.1061 | 13.1061 | 2800.0 |
| 2011-08-05 04:23:00 | AAPL | Stock | 13.0814 | 13.0814 | 13.0804 | 13.0814 | 19600.0 |
| 2011-08-05 04:24:00 | AAPL | Stock | 13.1057 | 13.1057 | 13.0814 | 13.0814 | 8400.0 |
| 2011-08-05 04:25:00 | AAPL | Stock | 13.1032 | 13.1032 | 13.1032 | 13.1032 | 2800.0 |
| 2011-08-05 04:27:00 | AAPL | Stock | 13.0714 | 13.0714 | 13.0714 | 13.0714 | 8400.0 |
| 2011-08-05 04:28:00 | AAPL | Stock | 13.0779 | 13.0779 | 13.0357 | 13.0357 | 5600.0 |
| 2011-08-05 04:29:00 | AAPL | Stock | 13.0236 | 13.0236 | 13.0236 | 13.0236 | 2800.0 |
| 2011-08-05 04:30:00 | AAPL | Stock | 13.0896 | 13.0896 | 13.0896 | 13.0896 | 25200.0 |
| 2011-08-05 04:31:00 | AAPL | Stock | 13.1118 | 13.1246 | 13.0896 | 13.1164 | 14000.0 |
| 2011-08-05 04:32:00 | AAPL | Stock | 13.1171 | 13.1571 | 13.1171 | 13.1429 | 28000.0 |
| 2011-08-05 04:33:00 | AAPL | Stock | 13.1429 | 13.1743 | 13.1429 | 13.1604 | 50400.0 |
| 2011-08-05 04:34:00 | AAPL | Stock | 13.1429 | 13.1504 | 13.1429 | 13.1504 | 16800.0 |
| 2011-08-05 04:38:00 | AAPL | Stock | 13.1786 | 13.2021 | 13.1786 | 13.2021 | 5600.0 |
| 2011-08-05 04:39:00 | AAPL | Stock | 13.2125 | 13.2382 | 13.2125 | 13.2382 | 16800.0 |
| 2011-08-05 04:40:00 | AAPL | Stock | 13.2143 | 13.2232 | 13.2011 | 13.2232 | 16800.0 |
| 2011-08-05 04:41:00 | AAPL | Stock | 13.1964 | 13.1971 | 13.1961 | 13.1961 | 16800.0 |
| 2011-08-05 04:42:00 | AAPL | Stock | 13.1857 | 13.1964 | 13.1857 | 13.1964 | 30800.0 |
| 2011-08-05 04:44:00 | AAPL | Stock | 13.1968 | 13.2143 | 13.1964 | 13.1964 | 19600.0 |
| 2011-08-05 04:45:00 | AAPL | Stock | 13.1964 | 13.1964 | 13.1882 | 13.1882 | 11200.0 |
| 2011-08-05 04:47:00 | AAPL | Stock | 13.2107 | 13.2107 | 13.2107 | 13.2107 | 2800.0 |
| 2011-08-05 04:48:00 | AAPL | Stock | 13.2225 | 13.2225 | 13.2225 | 13.2225 | 2800.0 |
| 2011-08-05 04:50:00 | AAPL | Stock | 13.1964 | 13.1964 | 13.1964 | 13.1964 | 14000.0 |
| 2011-08-05 04:51:00 | AAPL | Stock | 13.2061 | 13.2061 | 13.2061 | 13.2061 | 5600.0 |
| 2011-08-05 04:52:00 | AAPL | Stock | 13.1971 | 13.1971 | 13.1971 | 13.1971 | 14000.0 |
| 2011-08-05 04:53:00 | AAPL | Stock | 13.2014 | 13.2143 | 13.1896 | 13.1896 | 19600.0 |
| 2011-08-05 04:54:00 | AAPL | Stock | 13.1957 | 13.2 | 13.18 | 13.2 | 14000.0 |
| 2011-08-05 04:55:00 | AAPL | Stock | 13.1964 | 13.1964 | 13.1911 | 13.1911 | 16800.0 |
| 2011-08-05 04:56:00 | AAPL | Stock | 13.1796 | 13.1925 | 13.1796 | 13.1925 | 19600.0 |
| 2011-08-05 04:58:00 | AAPL | Stock | 13.1607 | 13.1607 | 13.1607 | 13.1607 | 2800.0 |
| 2011-08-05 04:59:00 | AAPL | Stock | 13.19 | 13.19 | 13.1607 | 13.1607 | 5600.0 |
| 2011-08-05 05:01:00 | AAPL | Stock | 13.1846 | 13.1846 | 13.1846 | 13.1846 | 2800.0 |
| 2011-08-05 05:03:00 | AAPL | Stock | 13.2107 | 13.2143 | 13.2107 | 13.2143 | 28560.0 |
| 2011-08-05 05:04:00 | AAPL | Stock | 13.2143 | 13.2143 | 13.2143 | 13.2143 | 16800.0 |
| 2011-08-05 05:05:00 | AAPL | Stock | 13.2236 | 13.2243 | 13.2236 | 13.2243 | 8400.0 |
| 2011-08-05 05:08:00 | AAPL | Stock | 13.2143 | 13.2143 | 13.2143 | 13.2143 | 2800.0 |
| 2011-08-05 05:12:00 | AAPL | Stock | 13.2214 | 13.2214 | 13.2214 | 13.2214 | 2800.0 |
| 2011-08-05 05:14:00 | AAPL | Stock | 13.2321 | 13.2321 | 13.2321 | 13.2321 | 5600.0 |
| 2011-08-05 05:15:00 | AAPL | Stock | 13.2146 | 13.25 | 13.2146 | 13.25 | 5600.0 |
| 2011-08-05 05:18:00 | AAPL | Stock | 13.2179 | 13.2179 | 13.2179 | 13.2179 | 2800.0 |
| 2011-08-05 05:19:00 | AAPL | Stock | 13.2496 | 13.2496 | 13.2496 | 13.2496 | 2800.0 |
| 2011-08-05 05:20:00 | AAPL | Stock | 13.2389 | 13.2389 | 13.2179 | 13.2179 | 8400.0 |
> showing 50 of 1,188,860 rows — these rows as CSV