PREVIEW / stock_1min / 2017-05-24
file: by_date/stock_1min/2017/2017-05-24.parquet size: 14.1 MB rows: 1,028,610 symbols: 2,495
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-05-24 04:36:00 | AAPL | Stock | 38.5125 | 38.5125 | 38.5125 | 38.5125 | 400.0 |
| 2017-05-24 06:10:00 | AAPL | Stock | 38.535 | 38.535 | 38.535 | 38.535 | 712.0 |
| 2017-05-24 06:14:00 | AAPL | Stock | 38.55 | 38.55 | 38.55 | 38.55 | 4688.0 |
| 2017-05-24 06:32:00 | AAPL | Stock | 38.5425 | 38.5425 | 38.5425 | 38.5425 | 800.0 |
| 2017-05-24 06:36:00 | AAPL | Stock | 38.545 | 38.545 | 38.545 | 38.545 | 1200.0 |
| 2017-05-24 06:44:00 | AAPL | Stock | 38.505 | 38.505 | 38.505 | 38.505 | 600.0 |
| 2017-05-24 06:51:00 | AAPL | Stock | 38.505 | 38.505 | 38.505 | 38.505 | 4000.0 |
| 2017-05-24 06:59:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 3988.0 |
| 2017-05-24 07:05:00 | AAPL | Stock | 38.4775 | 38.4775 | 38.475 | 38.475 | 1972.0 |
| 2017-05-24 07:10:00 | AAPL | Stock | 38.475 | 38.475 | 38.475 | 38.475 | 400.0 |
| 2017-05-24 07:13:00 | AAPL | Stock | 38.475 | 38.475 | 38.475 | 38.475 | 400.0 |
| 2017-05-24 07:35:00 | AAPL | Stock | 38.4975 | 38.4975 | 38.4975 | 38.4975 | 3620.0 |
| 2017-05-24 07:44:00 | AAPL | Stock | 38.475 | 38.475 | 38.475 | 38.475 | 1024.0 |
| 2017-05-24 07:46:00 | AAPL | Stock | 38.4975 | 38.4975 | 38.4975 | 38.4975 | 400.0 |
| 2017-05-24 07:49:00 | AAPL | Stock | 38.475 | 38.4925 | 38.475 | 38.4925 | 800.0 |
| 2017-05-24 07:55:00 | AAPL | Stock | 38.4925 | 38.4925 | 38.4925 | 38.4925 | 1040.0 |
| 2017-05-24 07:58:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 1712.0 |
| 2017-05-24 08:00:00 | AAPL | Stock | 38.5 | 38.535 | 38.475 | 38.4925 | 10400.0 |
| 2017-05-24 08:01:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 7700.0 |
| 2017-05-24 08:02:00 | AAPL | Stock | 38.5 | 38.5125 | 38.5 | 38.5125 | 3200.0 |
| 2017-05-24 08:04:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 800.0 |
| 2017-05-24 08:07:00 | AAPL | Stock | 38.5075 | 38.5075 | 38.5075 | 38.5075 | 2000.0 |
| 2017-05-24 08:08:00 | AAPL | Stock | 38.5125 | 38.5125 | 38.5 | 38.5 | 800.0 |
| 2017-05-24 08:09:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 400.0 |
| 2017-05-24 08:10:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 400.0 |
| 2017-05-24 08:11:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 4800.0 |
| 2017-05-24 08:12:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 800.0 |
| 2017-05-24 08:13:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 1200.0 |
| 2017-05-24 08:14:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 4324.0 |
| 2017-05-24 08:17:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 476.0 |
| 2017-05-24 08:19:00 | AAPL | Stock | 38.465 | 38.4675 | 38.46 | 38.46 | 9436.0 |
| 2017-05-24 08:21:00 | AAPL | Stock | 38.45 | 38.45 | 38.45 | 38.45 | 3684.0 |
| 2017-05-24 08:23:00 | AAPL | Stock | 38.4275 | 38.4275 | 38.4275 | 38.4275 | 532.0 |
| 2017-05-24 08:25:00 | AAPL | Stock | 38.4275 | 38.4275 | 38.4275 | 38.4275 | 400.0 |
| 2017-05-24 08:26:00 | AAPL | Stock | 38.4425 | 38.45 | 38.4425 | 38.45 | 4000.0 |
| 2017-05-24 08:27:00 | AAPL | Stock | 38.4575 | 38.46 | 38.4575 | 38.46 | 4000.0 |
| 2017-05-24 08:29:00 | AAPL | Stock | 38.46 | 38.4725 | 38.46 | 38.4725 | 9688.0 |
| 2017-05-24 08:31:00 | AAPL | Stock | 38.4675 | 38.48 | 38.4675 | 38.48 | 7420.0 |
| 2017-05-24 08:32:00 | AAPL | Stock | 38.4675 | 38.4675 | 38.4675 | 38.4675 | 1200.0 |
| 2017-05-24 08:34:00 | AAPL | Stock | 38.475 | 38.475 | 38.4625 | 38.465 | 6760.0 |
| 2017-05-24 08:36:00 | AAPL | Stock | 38.4625 | 38.4625 | 38.4625 | 38.4625 | 400.0 |
| 2017-05-24 08:43:00 | AAPL | Stock | 38.4625 | 38.475 | 38.4625 | 38.475 | 1600.0 |
| 2017-05-24 08:44:00 | AAPL | Stock | 38.475 | 38.475 | 38.475 | 38.475 | 800.0 |
| 2017-05-24 08:47:00 | AAPL | Stock | 38.4625 | 38.4625 | 38.4625 | 38.4625 | 2000.0 |
| 2017-05-24 08:50:00 | AAPL | Stock | 38.4675 | 38.4675 | 38.4675 | 38.4675 | 800.0 |
| 2017-05-24 08:54:00 | AAPL | Stock | 38.4725 | 38.4875 | 38.4725 | 38.4875 | 9988.0 |
| 2017-05-24 08:55:00 | AAPL | Stock | 38.495 | 38.5 | 38.495 | 38.5 | 8212.0 |
| 2017-05-24 08:56:00 | AAPL | Stock | 38.5 | 38.505 | 38.5 | 38.505 | 5200.0 |
| 2017-05-24 08:57:00 | AAPL | Stock | 38.4875 | 38.4875 | 38.4875 | 38.4875 | 8892.0 |
| 2017-05-24 08:58:00 | AAPL | Stock | 38.4825 | 38.4825 | 38.4825 | 38.4825 | 6060.0 |
> showing 50 of 1,028,610 rows — these rows as CSV