PREVIEW / stock_1min / 2017-02-06
file: by_date/stock_1min/2017/2017-02-06.parquet size: 14.2 MB rows: 1,028,203 symbols: 2,566
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 |
|---|---|---|---|---|---|---|---|
| 2017-02-06 04:06:00 | AAPL | Stock | 32.25 | 32.25 | 32.25 | 32.25 | 1944.0 |
| 2017-02-06 04:07:00 | AAPL | Stock | 32.25 | 32.25 | 32.215 | 32.25 | 2524.0 |
| 2017-02-06 04:36:00 | AAPL | Stock | 32.2225 | 32.2225 | 32.2225 | 32.2225 | 1200.0 |
| 2017-02-06 05:06:00 | AAPL | Stock | 32.2375 | 32.2375 | 32.2375 | 32.2375 | 400.0 |
| 2017-02-06 05:31:00 | AAPL | Stock | 32.2375 | 32.2375 | 32.2375 | 32.2375 | 1200.0 |
| 2017-02-06 05:32:00 | AAPL | Stock | 32.2275 | 32.2275 | 32.2275 | 32.2275 | 800.0 |
| 2017-02-06 05:33:00 | AAPL | Stock | 32.2275 | 32.2275 | 32.2275 | 32.2275 | 400.0 |
| 2017-02-06 05:34:00 | AAPL | Stock | 32.2275 | 32.2275 | 32.2275 | 32.2275 | 800.0 |
| 2017-02-06 05:37:00 | AAPL | Stock | 32.2375 | 32.2375 | 32.2375 | 32.2375 | 13416.0 |
| 2017-02-06 05:41:00 | AAPL | Stock | 32.275 | 32.275 | 32.275 | 32.275 | 400.0 |
| 2017-02-06 06:06:00 | AAPL | Stock | 32.295 | 32.2975 | 32.295 | 32.2975 | 4000.0 |
| 2017-02-06 06:22:00 | AAPL | Stock | 32.2575 | 32.2575 | 32.2475 | 32.2475 | 13580.0 |
| 2017-02-06 06:23:00 | AAPL | Stock | 32.2475 | 32.2475 | 32.2475 | 32.2475 | 400.0 |
| 2017-02-06 06:27:00 | AAPL | Stock | 32.2475 | 32.2475 | 32.2475 | 32.2475 | 400.0 |
| 2017-02-06 06:30:00 | AAPL | Stock | 32.26 | 32.27 | 32.26 | 32.27 | 3800.0 |
| 2017-02-06 06:33:00 | AAPL | Stock | 32.235 | 32.235 | 32.235 | 32.235 | 400.0 |
| 2017-02-06 06:40:00 | AAPL | Stock | 32.23 | 32.23 | 32.23 | 32.23 | 400.0 |
| 2017-02-06 06:53:00 | AAPL | Stock | 32.225 | 32.225 | 32.225 | 32.225 | 1320.0 |
| 2017-02-06 06:54:00 | AAPL | Stock | 32.2275 | 32.25 | 32.2275 | 32.25 | 4200.0 |
| 2017-02-06 07:04:00 | AAPL | Stock | 32.25 | 32.25 | 32.25 | 32.25 | 1796.0 |
| 2017-02-06 07:07:00 | AAPL | Stock | 32.25 | 32.25 | 32.25 | 32.25 | 1596.0 |
| 2017-02-06 07:08:00 | AAPL | Stock | 32.25 | 32.25 | 32.25 | 32.25 | 8816.0 |
| 2017-02-06 07:17:00 | AAPL | Stock | 32.25 | 32.25 | 32.25 | 32.25 | 3416.0 |
| 2017-02-06 07:18:00 | AAPL | Stock | 32.26 | 32.26 | 32.26 | 32.26 | 2000.0 |
| 2017-02-06 07:20:00 | AAPL | Stock | 32.2625 | 32.2625 | 32.2625 | 32.2625 | 1200.0 |
| 2017-02-06 07:22:00 | AAPL | Stock | 32.2575 | 32.2575 | 32.2525 | 32.2525 | 4280.0 |
| 2017-02-06 07:27:00 | AAPL | Stock | 32.2425 | 32.2425 | 32.2425 | 32.2425 | 2000.0 |
| 2017-02-06 07:28:00 | AAPL | Stock | 32.24 | 32.24 | 32.2375 | 32.2375 | 2980.0 |
| 2017-02-06 07:29:00 | AAPL | Stock | 32.235 | 32.235 | 32.235 | 32.235 | 3800.0 |
| 2017-02-06 07:32:00 | AAPL | Stock | 32.23 | 32.23 | 32.23 | 32.23 | 1100.0 |
| 2017-02-06 07:33:00 | AAPL | Stock | 32.245 | 32.245 | 32.245 | 32.245 | 568.0 |
| 2017-02-06 07:34:00 | AAPL | Stock | 32.25 | 32.25 | 32.25 | 32.25 | 3200.0 |
| 2017-02-06 07:40:00 | AAPL | Stock | 32.2425 | 32.2425 | 32.2425 | 32.2425 | 772.0 |
| 2017-02-06 07:42:00 | AAPL | Stock | 32.23 | 32.23 | 32.23 | 32.23 | 400.0 |
| 2017-02-06 07:45:00 | AAPL | Stock | 32.24 | 32.24 | 32.24 | 32.24 | 400.0 |
| 2017-02-06 07:46:00 | AAPL | Stock | 32.24 | 32.24 | 32.24 | 32.24 | 1200.0 |
| 2017-02-06 07:48:00 | AAPL | Stock | 32.23 | 32.23 | 32.23 | 32.23 | 772.0 |
| 2017-02-06 07:53:00 | AAPL | Stock | 32.23 | 32.23 | 32.2275 | 32.2275 | 2000.0 |
| 2017-02-06 07:56:00 | AAPL | Stock | 32.23 | 32.23 | 32.225 | 32.225 | 12968.0 |
| 2017-02-06 07:57:00 | AAPL | Stock | 32.215 | 32.215 | 32.2125 | 32.2125 | 2000.0 |
| 2017-02-06 08:00:00 | AAPL | Stock | 32.225 | 32.25 | 32.205 | 32.205 | 29844.0 |
| 2017-02-06 08:01:00 | AAPL | Stock | 32.205 | 32.215 | 32.19 | 32.19 | 24800.0 |
| 2017-02-06 08:02:00 | AAPL | Stock | 32.1875 | 32.1875 | 32.1875 | 32.1875 | 8000.0 |
| 2017-02-06 08:03:00 | AAPL | Stock | 32.1925 | 32.2125 | 32.1925 | 32.2125 | 13600.0 |
| 2017-02-06 08:09:00 | AAPL | Stock | 32.2 | 32.2 | 32.2 | 32.2 | 400.0 |
| 2017-02-06 08:10:00 | AAPL | Stock | 32.2 | 32.2 | 32.2 | 32.2 | 3008.0 |
| 2017-02-06 08:12:00 | AAPL | Stock | 32.1925 | 32.2 | 32.1925 | 32.2 | 3092.0 |
| 2017-02-06 08:14:00 | AAPL | Stock | 32.205 | 32.205 | 32.205 | 32.205 | 1200.0 |
| 2017-02-06 08:15:00 | AAPL | Stock | 32.205 | 32.2075 | 32.205 | 32.2075 | 1732.0 |
| 2017-02-06 08:16:00 | AAPL | Stock | 32.2075 | 32.2075 | 32.2 | 32.2 | 9868.0 |
> showing 50 of 1,028,203 rows — these rows as CSV