PREVIEW / stock_1min / 2015-07-21
file: by_date/stock_1min/2015/2015-07-21.parquet size: 14.5 MB rows: 1,061,533 symbols: 2,836
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-21 04:00:00 | AAPL | Stock | 33.1875 | 33.1875 | 33.1875 | 33.1875 | 2800.0 |
| 2015-07-21 04:03:00 | AAPL | Stock | 33.1875 | 33.1875 | 33.1825 | 33.1825 | 1600.0 |
| 2015-07-21 04:05:00 | AAPL | Stock | 33.1875 | 33.195 | 33.1875 | 33.1875 | 5600.0 |
| 2015-07-21 04:06:00 | AAPL | Stock | 33.235 | 33.235 | 33.1875 | 33.1875 | 2400.0 |
| 2015-07-21 04:07:00 | AAPL | Stock | 33.25 | 33.25 | 33.25 | 33.25 | 400.0 |
| 2015-07-21 04:19:00 | AAPL | Stock | 33.215 | 33.215 | 33.2 | 33.215 | 4000.0 |
| 2015-07-21 04:30:00 | AAPL | Stock | 33.215 | 33.215 | 33.215 | 33.215 | 800.0 |
| 2015-07-21 04:31:00 | AAPL | Stock | 33.2425 | 33.2425 | 33.2425 | 33.2425 | 1200.0 |
| 2015-07-21 04:38:00 | AAPL | Stock | 33.2475 | 33.2475 | 33.2475 | 33.2475 | 2000.0 |
| 2015-07-21 04:41:00 | AAPL | Stock | 33.245 | 33.245 | 33.245 | 33.245 | 4000.0 |
| 2015-07-21 04:52:00 | AAPL | Stock | 33.2475 | 33.2475 | 33.2475 | 33.2475 | 800.0 |
| 2015-07-21 05:02:00 | AAPL | Stock | 33.24 | 33.24 | 33.24 | 33.24 | 1096.0 |
| 2015-07-21 05:05:00 | AAPL | Stock | 33.225 | 33.225 | 33.2175 | 33.2175 | 3600.0 |
| 2015-07-21 05:08:00 | AAPL | Stock | 33.2 | 33.2 | 33.2 | 33.2 | 1200.0 |
| 2015-07-21 05:16:00 | AAPL | Stock | 33.2 | 33.2 | 33.1975 | 33.1975 | 2000.0 |
| 2015-07-21 05:18:00 | AAPL | Stock | 33.215 | 33.215 | 33.215 | 33.215 | 800.0 |
| 2015-07-21 05:19:00 | AAPL | Stock | 33.225 | 33.225 | 33.225 | 33.225 | 4000.0 |
| 2015-07-21 05:24:00 | AAPL | Stock | 33.225 | 33.225 | 33.225 | 33.225 | 3800.0 |
| 2015-07-21 05:26:00 | AAPL | Stock | 33.225 | 33.225 | 33.225 | 33.225 | 2800.0 |
| 2015-07-21 05:27:00 | AAPL | Stock | 33.225 | 33.225 | 33.225 | 33.225 | 1200.0 |
| 2015-07-21 05:31:00 | AAPL | Stock | 33.2125 | 33.2125 | 33.2125 | 33.2125 | 400.0 |
| 2015-07-21 05:32:00 | AAPL | Stock | 33.2175 | 33.2175 | 33.2175 | 33.2175 | 1200.0 |
| 2015-07-21 05:34:00 | AAPL | Stock | 33.2125 | 33.2125 | 33.2125 | 33.2125 | 2360.0 |
| 2015-07-21 05:36:00 | AAPL | Stock | 33.22 | 33.22 | 33.22 | 33.22 | 6000.0 |
| 2015-07-21 05:39:00 | AAPL | Stock | 33.2175 | 33.2175 | 33.2125 | 33.2125 | 2440.0 |
| 2015-07-21 05:49:00 | AAPL | Stock | 33.2 | 33.2 | 33.2 | 33.2 | 800.0 |
| 2015-07-21 05:51:00 | AAPL | Stock | 33.2 | 33.2 | 33.2 | 33.2 | 2400.0 |
| 2015-07-21 05:53:00 | AAPL | Stock | 33.2175 | 33.22 | 33.2175 | 33.22 | 1100.0 |
| 2015-07-21 05:56:00 | AAPL | Stock | 33.2175 | 33.2175 | 33.2175 | 33.2175 | 1536.0 |
| 2015-07-21 06:00:00 | AAPL | Stock | 33.2075 | 33.2125 | 33.2075 | 33.2075 | 5460.0 |
| 2015-07-21 06:05:00 | AAPL | Stock | 33.22 | 33.22 | 33.22 | 33.22 | 400.0 |
| 2015-07-21 06:06:00 | AAPL | Stock | 33.22 | 33.22 | 33.22 | 33.22 | 2172.0 |
| 2015-07-21 06:07:00 | AAPL | Stock | 33.22 | 33.225 | 33.22 | 33.225 | 8400.0 |
| 2015-07-21 06:08:00 | AAPL | Stock | 33.225 | 33.225 | 33.225 | 33.225 | 3000.0 |
| 2015-07-21 06:09:00 | AAPL | Stock | 33.225 | 33.225 | 33.225 | 33.225 | 4448.0 |
| 2015-07-21 06:10:00 | AAPL | Stock | 33.225 | 33.225 | 33.225 | 33.225 | 400.0 |
| 2015-07-21 06:12:00 | AAPL | Stock | 33.2175 | 33.225 | 33.2175 | 33.2175 | 2960.0 |
| 2015-07-21 06:13:00 | AAPL | Stock | 33.225 | 33.225 | 33.225 | 33.225 | 8400.0 |
| 2015-07-21 06:14:00 | AAPL | Stock | 33.225 | 33.225 | 33.225 | 33.225 | 9108.0 |
| 2015-07-21 06:16:00 | AAPL | Stock | 33.245 | 33.245 | 33.225 | 33.225 | 6324.0 |
| 2015-07-21 06:21:00 | AAPL | Stock | 33.225 | 33.25 | 33.225 | 33.25 | 10916.0 |
| 2015-07-21 06:23:00 | AAPL | Stock | 33.2475 | 33.25 | 33.2475 | 33.25 | 868.0 |
| 2015-07-21 06:31:00 | AAPL | Stock | 33.25 | 33.25 | 33.25 | 33.25 | 880.0 |
| 2015-07-21 06:38:00 | AAPL | Stock | 33.225 | 33.225 | 33.205 | 33.2125 | 20000.0 |
| 2015-07-21 06:40:00 | AAPL | Stock | 33.23 | 33.23 | 33.225 | 33.225 | 7400.0 |
| 2015-07-21 06:41:00 | AAPL | Stock | 33.2175 | 33.225 | 33.2175 | 33.225 | 30000.0 |
| 2015-07-21 06:42:00 | AAPL | Stock | 33.22 | 33.22 | 33.2175 | 33.2175 | 7840.0 |
| 2015-07-21 06:50:00 | AAPL | Stock | 33.225 | 33.225 | 33.225 | 33.225 | 10400.0 |
| 2015-07-21 06:51:00 | AAPL | Stock | 33.2275 | 33.2275 | 33.2275 | 33.2275 | 400.0 |
| 2015-07-21 06:53:00 | AAPL | Stock | 33.225 | 33.225 | 33.2225 | 33.2225 | 3628.0 |
> showing 50 of 1,061,533 rows — these rows as CSV