PREVIEW / stock_1min / 2013-12-11
file: by_date/stock_1min/2013/2013-12-11.parquet size: 14.6 MB rows: 1,064,287 symbols: 2,860
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-11 04:02:00 | AAPL | Stock | 20.1786 | 20.1786 | 20.1786 | 20.1786 | 12936.0 |
| 2013-12-11 04:20:00 | AAPL | Stock | 20.1896 | 20.1896 | 20.1896 | 20.1896 | 2800.0 |
| 2013-12-11 04:40:00 | AAPL | Stock | 20.2079 | 20.2079 | 20.2079 | 20.2079 | 2800.0 |
| 2013-12-11 05:48:00 | AAPL | Stock | 20.2329 | 20.2329 | 20.2329 | 20.2329 | 2800.0 |
| 2013-12-11 05:53:00 | AAPL | Stock | 20.2289 | 20.2289 | 20.2289 | 20.2289 | 2800.0 |
| 2013-12-11 06:14:00 | AAPL | Stock | 20.2204 | 20.2204 | 20.2204 | 20.2204 | 2800.0 |
| 2013-12-11 06:19:00 | AAPL | Stock | 20.2014 | 20.2014 | 20.2014 | 20.2014 | 11200.0 |
| 2013-12-11 06:20:00 | AAPL | Stock | 20.2014 | 20.2014 | 20.2014 | 20.2014 | 2800.0 |
| 2013-12-11 06:21:00 | AAPL | Stock | 20.2014 | 20.2014 | 20.2014 | 20.2014 | 5600.0 |
| 2013-12-11 06:22:00 | AAPL | Stock | 20.2014 | 20.2014 | 20.2014 | 20.2014 | 5600.0 |
| 2013-12-11 06:25:00 | AAPL | Stock | 20.2014 | 20.2014 | 20.2014 | 20.2014 | 11200.0 |
| 2013-12-11 06:27:00 | AAPL | Stock | 20.2014 | 20.2014 | 20.2014 | 20.2014 | 2800.0 |
| 2013-12-11 06:28:00 | AAPL | Stock | 20.2014 | 20.2014 | 20.2014 | 20.2014 | 2800.0 |
| 2013-12-11 06:32:00 | AAPL | Stock | 20.2132 | 20.2136 | 20.2132 | 20.2136 | 12684.0 |
| 2013-12-11 06:33:00 | AAPL | Stock | 20.2021 | 20.2021 | 20.1982 | 20.1982 | 22400.0 |
| 2013-12-11 06:36:00 | AAPL | Stock | 20.1989 | 20.1989 | 20.1989 | 20.1989 | 5404.0 |
| 2013-12-11 06:38:00 | AAPL | Stock | 20.2025 | 20.2025 | 20.2025 | 20.2025 | 2800.0 |
| 2013-12-11 06:47:00 | AAPL | Stock | 20.2021 | 20.2021 | 20.2021 | 20.2021 | 2800.0 |
| 2013-12-11 06:48:00 | AAPL | Stock | 20.2018 | 20.2018 | 20.2018 | 20.2018 | 5628.0 |
| 2013-12-11 06:53:00 | AAPL | Stock | 20.1979 | 20.1979 | 20.1979 | 20.1979 | 2800.0 |
| 2013-12-11 06:56:00 | AAPL | Stock | 20.1954 | 20.1954 | 20.1954 | 20.1954 | 2800.0 |
| 2013-12-11 07:00:00 | AAPL | Stock | 20.2021 | 20.2175 | 20.2021 | 20.2175 | 5600.0 |
| 2013-12-11 07:03:00 | AAPL | Stock | 20.2204 | 20.2314 | 20.2196 | 20.2314 | 11200.0 |
| 2013-12-11 07:04:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 2800.0 |
| 2013-12-11 07:06:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 2800.0 |
| 2013-12-11 07:08:00 | AAPL | Stock | 20.2214 | 20.2214 | 20.2214 | 20.2214 | 5600.0 |
| 2013-12-11 07:09:00 | AAPL | Stock | 20.2039 | 20.2039 | 20.2004 | 20.2039 | 8400.0 |
| 2013-12-11 07:10:00 | AAPL | Stock | 20.1996 | 20.1996 | 20.1964 | 20.1964 | 9296.0 |
| 2013-12-11 07:12:00 | AAPL | Stock | 20.1954 | 20.1954 | 20.1954 | 20.1954 | 9296.0 |
| 2013-12-11 07:14:00 | AAPL | Stock | 20.1954 | 20.1954 | 20.1954 | 20.1954 | 5628.0 |
| 2013-12-11 07:15:00 | AAPL | Stock | 20.1954 | 20.1954 | 20.1954 | 20.1954 | 2800.0 |
| 2013-12-11 07:19:00 | AAPL | Stock | 20.1789 | 20.1893 | 20.1464 | 20.1893 | 38360.0 |
| 2013-12-11 07:39:00 | AAPL | Stock | 20.22 | 20.22 | 20.22 | 20.22 | 2800.0 |
| 2013-12-11 07:40:00 | AAPL | Stock | 20.2211 | 20.2225 | 20.2211 | 20.2225 | 11200.0 |
| 2013-12-11 07:42:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 5600.0 |
| 2013-12-11 07:43:00 | AAPL | Stock | 20.2314 | 20.2321 | 20.2314 | 20.2321 | 8960.0 |
| 2013-12-11 07:44:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 5600.0 |
| 2013-12-11 07:48:00 | AAPL | Stock | 20.25 | 20.25 | 20.2464 | 20.2464 | 5600.0 |
| 2013-12-11 07:50:00 | AAPL | Stock | 20.25 | 20.25 | 20.25 | 20.25 | 16800.0 |
| 2013-12-11 07:54:00 | AAPL | Stock | 20.25 | 20.2586 | 20.25 | 20.2586 | 21532.0 |
| 2013-12-11 07:59:00 | AAPL | Stock | 20.2579 | 20.2679 | 20.2579 | 20.2679 | 22400.0 |
| 2013-12-11 08:00:00 | AAPL | Stock | 20.2696 | 20.2696 | 20.1786 | 20.2696 | 100800.0 |
| 2013-12-11 08:01:00 | AAPL | Stock | 20.2696 | 20.2696 | 20.2696 | 20.2696 | 2800.0 |
| 2013-12-11 08:02:00 | AAPL | Stock | 20.2646 | 20.2646 | 20.2646 | 20.2646 | 2800.0 |
| 2013-12-11 08:03:00 | AAPL | Stock | 20.2714 | 20.275 | 20.2646 | 20.2732 | 25200.0 |
| 2013-12-11 08:04:00 | AAPL | Stock | 20.2732 | 20.2754 | 20.2729 | 20.2739 | 36400.0 |
| 2013-12-11 08:06:00 | AAPL | Stock | 20.2661 | 20.2661 | 20.2661 | 20.2661 | 2800.0 |
| 2013-12-11 08:07:00 | AAPL | Stock | 20.2725 | 20.275 | 20.2725 | 20.275 | 11620.0 |
| 2013-12-11 08:08:00 | AAPL | Stock | 20.2679 | 20.2679 | 20.2679 | 20.2679 | 2800.0 |
| 2013-12-11 08:09:00 | AAPL | Stock | 20.2682 | 20.2768 | 20.2679 | 20.2679 | 123956.0 |
> showing 50 of 1,064,287 rows — these rows as CSV