PREVIEW / stock_1min / 2017-03-16
file: by_date/stock_1min/2017/2017-03-16.parquet size: 14.4 MB rows: 1,056,885 symbols: 2,547
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-03-16 04:01:00 | AAPL | Stock | 35.1875 | 35.2075 | 35.1875 | 35.2075 | 1600.0 |
| 2017-03-16 04:27:00 | AAPL | Stock | 35.23 | 35.2375 | 35.23 | 35.2375 | 800.0 |
| 2017-03-16 04:31:00 | AAPL | Stock | 35.245 | 35.245 | 35.245 | 35.245 | 400.0 |
| 2017-03-16 04:47:00 | AAPL | Stock | 35.225 | 35.225 | 35.225 | 35.225 | 3996.0 |
| 2017-03-16 04:48:00 | AAPL | Stock | 35.225 | 35.225 | 35.225 | 35.225 | 3192.0 |
| 2017-03-16 05:11:00 | AAPL | Stock | 35.22 | 35.22 | 35.22 | 35.22 | 2400.0 |
| 2017-03-16 05:15:00 | AAPL | Stock | 35.2375 | 35.2475 | 35.2375 | 35.2475 | 3544.0 |
| 2017-03-16 05:17:00 | AAPL | Stock | 35.22 | 35.22 | 35.22 | 35.22 | 5420.0 |
| 2017-03-16 05:25:00 | AAPL | Stock | 35.25 | 35.25 | 35.25 | 35.25 | 1736.0 |
| 2017-03-16 05:32:00 | AAPL | Stock | 35.2375 | 35.2375 | 35.2375 | 35.2375 | 800.0 |
| 2017-03-16 05:35:00 | AAPL | Stock | 35.2375 | 35.2375 | 35.2375 | 35.2375 | 400.0 |
| 2017-03-16 05:45:00 | AAPL | Stock | 35.22 | 35.22 | 35.22 | 35.22 | 1724.0 |
| 2017-03-16 05:46:00 | AAPL | Stock | 35.22 | 35.22 | 35.22 | 35.22 | 2000.0 |
| 2017-03-16 05:47:00 | AAPL | Stock | 35.21 | 35.21 | 35.21 | 35.21 | 444.0 |
| 2017-03-16 05:48:00 | AAPL | Stock | 35.21 | 35.21 | 35.21 | 35.21 | 800.0 |
| 2017-03-16 06:06:00 | AAPL | Stock | 35.2225 | 35.2225 | 35.22 | 35.22 | 2000.0 |
| 2017-03-16 06:07:00 | AAPL | Stock | 35.22 | 35.22 | 35.22 | 35.22 | 2800.0 |
| 2017-03-16 06:11:00 | AAPL | Stock | 35.21 | 35.21 | 35.21 | 35.21 | 2400.0 |
| 2017-03-16 06:21:00 | AAPL | Stock | 35.2 | 35.2 | 35.2 | 35.2 | 2128.0 |
| 2017-03-16 06:23:00 | AAPL | Stock | 35.2 | 35.2 | 35.2 | 35.2 | 700.0 |
| 2017-03-16 06:26:00 | AAPL | Stock | 35.2025 | 35.2025 | 35.1975 | 35.1975 | 2764.0 |
| 2017-03-16 06:38:00 | AAPL | Stock | 35.215 | 35.2175 | 35.215 | 35.2175 | 8000.0 |
| 2017-03-16 06:40:00 | AAPL | Stock | 35.2175 | 35.2175 | 35.2175 | 35.2175 | 400.0 |
| 2017-03-16 06:42:00 | AAPL | Stock | 35.195 | 35.195 | 35.195 | 35.195 | 600.0 |
| 2017-03-16 06:50:00 | AAPL | Stock | 35.2 | 35.2 | 35.195 | 35.195 | 2000.0 |
| 2017-03-16 06:51:00 | AAPL | Stock | 35.2075 | 35.2075 | 35.195 | 35.195 | 1204.0 |
| 2017-03-16 06:54:00 | AAPL | Stock | 35.1875 | 35.1875 | 35.175 | 35.1875 | 1596.0 |
| 2017-03-16 07:01:00 | AAPL | Stock | 35.1875 | 35.2 | 35.1875 | 35.1875 | 6484.0 |
| 2017-03-16 07:02:00 | AAPL | Stock | 35.1875 | 35.1875 | 35.1775 | 35.1775 | 1248.0 |
| 2017-03-16 07:04:00 | AAPL | Stock | 35.1875 | 35.1875 | 35.1875 | 35.1875 | 800.0 |
| 2017-03-16 07:06:00 | AAPL | Stock | 35.1825 | 35.1825 | 35.1825 | 35.1825 | 800.0 |
| 2017-03-16 07:07:00 | AAPL | Stock | 35.1825 | 35.1875 | 35.1825 | 35.1875 | 6320.0 |
| 2017-03-16 07:09:00 | AAPL | Stock | 35.2 | 35.2 | 35.2 | 35.2 | 800.0 |
| 2017-03-16 07:11:00 | AAPL | Stock | 35.2 | 35.2 | 35.2 | 35.2 | 1600.0 |
| 2017-03-16 07:15:00 | AAPL | Stock | 35.2 | 35.2 | 35.2 | 35.2 | 400.0 |
| 2017-03-16 07:18:00 | AAPL | Stock | 35.1875 | 35.2 | 35.1875 | 35.2 | 3800.0 |
| 2017-03-16 07:22:00 | AAPL | Stock | 35.2 | 35.2 | 35.2 | 35.2 | 1200.0 |
| 2017-03-16 07:27:00 | AAPL | Stock | 35.1975 | 35.1975 | 35.1975 | 35.1975 | 5120.0 |
| 2017-03-16 07:28:00 | AAPL | Stock | 35.1975 | 35.1975 | 35.1975 | 35.1975 | 2800.0 |
| 2017-03-16 07:37:00 | AAPL | Stock | 35.1875 | 35.1875 | 35.1875 | 35.1875 | 400.0 |
| 2017-03-16 07:38:00 | AAPL | Stock | 35.1875 | 35.1875 | 35.1875 | 35.1875 | 4000.0 |
| 2017-03-16 07:41:00 | AAPL | Stock | 35.1875 | 35.1875 | 35.1875 | 35.1875 | 800.0 |
| 2017-03-16 07:43:00 | AAPL | Stock | 35.1825 | 35.1825 | 35.18 | 35.18 | 3280.0 |
| 2017-03-16 07:45:00 | AAPL | Stock | 35.175 | 35.175 | 35.1725 | 35.1725 | 1996.0 |
| 2017-03-16 07:50:00 | AAPL | Stock | 35.1725 | 35.1725 | 35.1725 | 35.1725 | 1464.0 |
| 2017-03-16 07:52:00 | AAPL | Stock | 35.1725 | 35.1725 | 35.1725 | 35.1725 | 1892.0 |
| 2017-03-16 07:53:00 | AAPL | Stock | 35.1825 | 35.1825 | 35.1825 | 35.1825 | 560.0 |
| 2017-03-16 07:54:00 | AAPL | Stock | 35.1825 | 35.1875 | 35.1825 | 35.1875 | 7800.0 |
| 2017-03-16 07:56:00 | AAPL | Stock | 35.1875 | 35.1875 | 35.1875 | 35.1875 | 600.0 |
| 2017-03-16 07:58:00 | AAPL | Stock | 35.1875 | 35.1925 | 35.1875 | 35.1925 | 3920.0 |
> showing 50 of 1,056,885 rows — these rows as CSV