PREVIEW / stock_1min / 2016-09-09
file: by_date/stock_1min/2016/2016-09-09.parquet size: 15.3 MB rows: 1,094,987 symbols: 2,670
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 |
|---|---|---|---|---|---|---|---|
| 2016-09-09 04:00:00 | AAPL | Stock | 26.3475 | 26.3475 | 26.3475 | 26.3475 | 1200.0 |
| 2016-09-09 04:15:00 | AAPL | Stock | 26.3375 | 26.3375 | 26.3375 | 26.3375 | 1200.0 |
| 2016-09-09 04:25:00 | AAPL | Stock | 26.325 | 26.325 | 26.325 | 26.325 | 400.0 |
| 2016-09-09 04:29:00 | AAPL | Stock | 26.3575 | 26.3575 | 26.3575 | 26.3575 | 1096.0 |
| 2016-09-09 04:48:00 | AAPL | Stock | 26.3525 | 26.3525 | 26.35 | 26.35 | 2156.0 |
| 2016-09-09 05:06:00 | AAPL | Stock | 26.35 | 26.35 | 26.35 | 26.35 | 1344.0 |
| 2016-09-09 05:14:00 | AAPL | Stock | 26.35 | 26.35 | 26.35 | 26.35 | 400.0 |
| 2016-09-09 06:09:00 | AAPL | Stock | 26.3575 | 26.3575 | 26.3575 | 26.3575 | 1456.0 |
| 2016-09-09 06:13:00 | AAPL | Stock | 26.3575 | 26.3575 | 26.3575 | 26.3575 | 6000.0 |
| 2016-09-09 06:41:00 | AAPL | Stock | 26.3375 | 26.3375 | 26.3375 | 26.3375 | 400.0 |
| 2016-09-09 06:48:00 | AAPL | Stock | 26.3125 | 26.3475 | 26.2925 | 26.3475 | 2000.0 |
| 2016-09-09 07:03:00 | AAPL | Stock | 26.32 | 26.325 | 26.32 | 26.325 | 1608.0 |
| 2016-09-09 07:04:00 | AAPL | Stock | 26.3125 | 26.3125 | 26.3125 | 26.3125 | 1200.0 |
| 2016-09-09 07:05:00 | AAPL | Stock | 26.3 | 26.3 | 26.3 | 26.3 | 800.0 |
| 2016-09-09 07:06:00 | AAPL | Stock | 26.3 | 26.3 | 26.3 | 26.3 | 2340.0 |
| 2016-09-09 07:07:00 | AAPL | Stock | 26.3 | 26.3 | 26.3 | 26.3 | 460.0 |
| 2016-09-09 07:09:00 | AAPL | Stock | 26.2875 | 26.2875 | 26.285 | 26.285 | 1096.0 |
| 2016-09-09 07:10:00 | AAPL | Stock | 26.28 | 26.28 | 26.2775 | 26.2775 | 1200.0 |
| 2016-09-09 07:13:00 | AAPL | Stock | 26.28 | 26.2875 | 26.275 | 26.2875 | 4400.0 |
| 2016-09-09 07:15:00 | AAPL | Stock | 26.2925 | 26.2925 | 26.2775 | 26.2775 | 1200.0 |
| 2016-09-09 07:16:00 | AAPL | Stock | 26.2925 | 26.2925 | 26.2925 | 26.2925 | 1400.0 |
| 2016-09-09 07:19:00 | AAPL | Stock | 26.2825 | 26.2825 | 26.2825 | 26.2825 | 400.0 |
| 2016-09-09 07:22:00 | AAPL | Stock | 26.285 | 26.2875 | 26.285 | 26.2875 | 1188.0 |
| 2016-09-09 07:24:00 | AAPL | Stock | 26.285 | 26.285 | 26.285 | 26.285 | 912.0 |
| 2016-09-09 07:25:00 | AAPL | Stock | 26.285 | 26.285 | 26.28 | 26.285 | 2268.0 |
| 2016-09-09 07:28:00 | AAPL | Stock | 26.285 | 26.285 | 26.285 | 26.285 | 448.0 |
| 2016-09-09 07:29:00 | AAPL | Stock | 26.28 | 26.285 | 26.28 | 26.285 | 4384.0 |
| 2016-09-09 07:30:00 | AAPL | Stock | 26.2875 | 26.295 | 26.2875 | 26.295 | 7792.0 |
| 2016-09-09 07:31:00 | AAPL | Stock | 26.2875 | 26.2875 | 26.285 | 26.2875 | 8000.0 |
| 2016-09-09 07:33:00 | AAPL | Stock | 26.2825 | 26.2825 | 26.2825 | 26.2825 | 912.0 |
| 2016-09-09 07:36:00 | AAPL | Stock | 26.2825 | 26.2825 | 26.2825 | 26.2825 | 800.0 |
| 2016-09-09 07:37:00 | AAPL | Stock | 26.29 | 26.29 | 26.29 | 26.29 | 3676.0 |
| 2016-09-09 07:38:00 | AAPL | Stock | 26.305 | 26.305 | 26.3 | 26.3 | 1648.0 |
| 2016-09-09 07:41:00 | AAPL | Stock | 26.2875 | 26.2875 | 26.2825 | 26.2825 | 4400.0 |
| 2016-09-09 07:42:00 | AAPL | Stock | 26.28 | 26.28 | 26.2775 | 26.2775 | 4000.0 |
| 2016-09-09 07:43:00 | AAPL | Stock | 26.28 | 26.28 | 26.2775 | 26.2775 | 800.0 |
| 2016-09-09 07:44:00 | AAPL | Stock | 26.28 | 26.28 | 26.2725 | 26.2725 | 12376.0 |
| 2016-09-09 07:45:00 | AAPL | Stock | 26.2625 | 26.2625 | 26.2625 | 26.2625 | 3000.0 |
| 2016-09-09 07:46:00 | AAPL | Stock | 26.255 | 26.255 | 26.25 | 26.255 | 23840.0 |
| 2016-09-09 07:47:00 | AAPL | Stock | 26.25 | 26.255 | 26.25 | 26.255 | 25380.0 |
| 2016-09-09 07:48:00 | AAPL | Stock | 26.25 | 26.25 | 26.2375 | 26.2375 | 4276.0 |
| 2016-09-09 07:49:00 | AAPL | Stock | 26.25 | 26.25 | 26.25 | 26.25 | 400.0 |
| 2016-09-09 07:50:00 | AAPL | Stock | 26.26 | 26.26 | 26.26 | 26.26 | 1588.0 |
| 2016-09-09 07:53:00 | AAPL | Stock | 26.2625 | 26.2675 | 26.2625 | 26.2675 | 2400.0 |
| 2016-09-09 07:58:00 | AAPL | Stock | 26.2725 | 26.275 | 26.2725 | 26.275 | 3188.0 |
| 2016-09-09 07:59:00 | AAPL | Stock | 26.2875 | 26.2875 | 26.2875 | 26.2875 | 400.0 |
| 2016-09-09 08:00:00 | AAPL | Stock | 26.2675 | 26.3125 | 26.26 | 26.28 | 62440.0 |
| 2016-09-09 08:01:00 | AAPL | Stock | 26.28 | 26.28 | 26.275 | 26.275 | 2720.0 |
| 2016-09-09 08:02:00 | AAPL | Stock | 26.275 | 26.2875 | 26.275 | 26.2875 | 11460.0 |
| 2016-09-09 08:03:00 | AAPL | Stock | 26.285 | 26.2925 | 26.285 | 26.2925 | 2300.0 |
> showing 50 of 1,094,987 rows — these rows as CSV