PREVIEW / stock_1min / 2013-04-05
file: by_date/stock_1min/2013/2013-04-05.parquet size: 13.1 MB rows: 969,552 symbols: 2,818
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-04-05 04:00:00 | AAPL | Stock | 15.2643 | 15.2643 | 15.2643 | 15.2643 | 2800.0 |
| 2013-04-05 04:31:00 | AAPL | Stock | 15.2857 | 15.2857 | 15.2857 | 15.2857 | 4928.0 |
| 2013-04-05 04:49:00 | AAPL | Stock | 15.2857 | 15.2857 | 15.2857 | 15.2857 | 5600.0 |
| 2013-04-05 05:19:00 | AAPL | Stock | 15.2736 | 15.2736 | 15.2714 | 15.2714 | 16800.0 |
| 2013-04-05 05:20:00 | AAPL | Stock | 15.2679 | 15.2679 | 15.2679 | 15.2679 | 14000.0 |
| 2013-04-05 05:24:00 | AAPL | Stock | 15.2589 | 15.2589 | 15.2589 | 15.2589 | 2800.0 |
| 2013-04-05 05:25:00 | AAPL | Stock | 15.2589 | 15.2589 | 15.2589 | 15.2589 | 10332.0 |
| 2013-04-05 05:51:00 | AAPL | Stock | 15.2525 | 15.2525 | 15.2482 | 15.2482 | 39704.0 |
| 2013-04-05 06:52:00 | AAPL | Stock | 15.2268 | 15.2268 | 15.2268 | 15.2268 | 2800.0 |
| 2013-04-05 07:03:00 | AAPL | Stock | 15.2007 | 15.2007 | 15.2 | 15.2 | 21000.0 |
| 2013-04-05 07:04:00 | AAPL | Stock | 15.2004 | 15.2004 | 15.2 | 15.2 | 8400.0 |
| 2013-04-05 07:05:00 | AAPL | Stock | 15.1946 | 15.1964 | 15.1946 | 15.1964 | 8400.0 |
| 2013-04-05 07:06:00 | AAPL | Stock | 15.2032 | 15.2321 | 15.2032 | 15.2321 | 30800.0 |
| 2013-04-05 07:07:00 | AAPL | Stock | 15.25 | 15.2575 | 15.2457 | 15.25 | 19600.0 |
| 2013-04-05 07:12:00 | AAPL | Stock | 15.2357 | 15.2357 | 15.2357 | 15.2357 | 3052.0 |
| 2013-04-05 07:17:00 | AAPL | Stock | 15.2046 | 15.2046 | 15.1996 | 15.1996 | 68208.0 |
| 2013-04-05 07:18:00 | AAPL | Stock | 15.2096 | 15.2096 | 15.2096 | 15.2096 | 8400.0 |
| 2013-04-05 07:20:00 | AAPL | Stock | 15.2014 | 15.2014 | 15.1846 | 15.1846 | 39620.0 |
| 2013-04-05 07:22:00 | AAPL | Stock | 15.1964 | 15.1964 | 15.195 | 15.1964 | 8400.0 |
| 2013-04-05 07:23:00 | AAPL | Stock | 15.1964 | 15.1964 | 15.1786 | 15.1786 | 35000.0 |
| 2013-04-05 07:24:00 | AAPL | Stock | 15.1796 | 15.1796 | 15.1796 | 15.1796 | 3304.0 |
| 2013-04-05 07:25:00 | AAPL | Stock | 15.1857 | 15.1857 | 15.1786 | 15.1786 | 18760.0 |
| 2013-04-05 07:26:00 | AAPL | Stock | 15.1857 | 15.1964 | 15.1804 | 15.1804 | 81200.0 |
| 2013-04-05 07:30:00 | AAPL | Stock | 15.1882 | 15.1882 | 15.1882 | 15.1882 | 3360.0 |
| 2013-04-05 07:36:00 | AAPL | Stock | 15.2 | 15.2 | 15.2 | 15.2 | 2800.0 |
| 2013-04-05 07:38:00 | AAPL | Stock | 15.2 | 15.2 | 15.2 | 15.2 | 2800.0 |
| 2013-04-05 07:42:00 | AAPL | Stock | 15.195 | 15.2018 | 15.1886 | 15.2018 | 14000.0 |
| 2013-04-05 07:43:00 | AAPL | Stock | 15.1946 | 15.2018 | 15.1946 | 15.2018 | 13104.0 |
| 2013-04-05 07:44:00 | AAPL | Stock | 15.2054 | 15.2054 | 15.2054 | 15.2054 | 2800.0 |
| 2013-04-05 07:45:00 | AAPL | Stock | 15.2079 | 15.2079 | 15.2079 | 15.2079 | 2800.0 |
| 2013-04-05 07:49:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 5600.0 |
| 2013-04-05 07:51:00 | AAPL | Stock | 15.2254 | 15.2254 | 15.2232 | 15.2232 | 8400.0 |
| 2013-04-05 07:58:00 | AAPL | Stock | 15.2189 | 15.2189 | 15.2189 | 15.2189 | 18592.0 |
| 2013-04-05 08:00:00 | AAPL | Stock | 15.2261 | 15.2325 | 15.2036 | 15.2214 | 23128.0 |
| 2013-04-05 08:01:00 | AAPL | Stock | 15.22 | 15.2232 | 15.2189 | 15.2232 | 23800.0 |
| 2013-04-05 08:02:00 | AAPL | Stock | 15.22 | 15.225 | 15.2196 | 15.2196 | 14000.0 |
| 2013-04-05 08:03:00 | AAPL | Stock | 15.2171 | 15.2171 | 15.2171 | 15.2171 | 2800.0 |
| 2013-04-05 08:04:00 | AAPL | Stock | 15.2168 | 15.2218 | 15.2168 | 15.2218 | 18900.0 |
| 2013-04-05 08:05:00 | AAPL | Stock | 15.225 | 15.225 | 15.225 | 15.225 | 2800.0 |
| 2013-04-05 08:06:00 | AAPL | Stock | 15.2182 | 15.2182 | 15.2179 | 15.2179 | 14000.0 |
| 2013-04-05 08:07:00 | AAPL | Stock | 15.2168 | 15.2168 | 15.2139 | 15.2143 | 51520.0 |
| 2013-04-05 08:08:00 | AAPL | Stock | 15.2143 | 15.2143 | 15.2143 | 15.2143 | 33600.0 |
| 2013-04-05 08:09:00 | AAPL | Stock | 15.2111 | 15.2111 | 15.2079 | 15.2086 | 22400.0 |
| 2013-04-05 08:10:00 | AAPL | Stock | 15.2139 | 15.2179 | 15.2139 | 15.2179 | 16380.0 |
| 2013-04-05 08:12:00 | AAPL | Stock | 15.2307 | 15.2307 | 15.2275 | 15.2275 | 16800.0 |
| 2013-04-05 08:13:00 | AAPL | Stock | 15.2179 | 15.2179 | 15.2179 | 15.2179 | 11200.0 |
| 2013-04-05 08:15:00 | AAPL | Stock | 15.225 | 15.225 | 15.225 | 15.225 | 8400.0 |
| 2013-04-05 08:16:00 | AAPL | Stock | 15.2268 | 15.2382 | 15.2268 | 15.2382 | 8400.0 |
| 2013-04-05 08:17:00 | AAPL | Stock | 15.2393 | 15.2393 | 15.2382 | 15.2382 | 16800.0 |
| 2013-04-05 08:18:00 | AAPL | Stock | 15.2332 | 15.2332 | 15.2332 | 15.2332 | 2800.0 |
> showing 50 of 969,552 rows — these rows as CSV