PREVIEW / stock_1min / 2017-10-05
file: by_date/stock_1min/2017/2017-10-05.parquet size: 14.4 MB rows: 1,038,734 symbols: 2,455
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-10-05 04:37:00 | AAPL | Stock | 38.41 | 38.41 | 38.41 | 38.41 | 400.0 |
| 2017-10-05 05:18:00 | AAPL | Stock | 38.375 | 38.375 | 38.375 | 38.375 | 2296.0 |
| 2017-10-05 06:11:00 | AAPL | Stock | 38.35 | 38.35 | 38.35 | 38.35 | 2000.0 |
| 2017-10-05 06:22:00 | AAPL | Stock | 38.375 | 38.375 | 38.375 | 38.375 | 1224.0 |
| 2017-10-05 06:47:00 | AAPL | Stock | 38.375 | 38.375 | 38.375 | 38.375 | 400.0 |
| 2017-10-05 07:00:00 | AAPL | Stock | 38.395 | 38.395 | 38.395 | 38.395 | 800.0 |
| 2017-10-05 07:02:00 | AAPL | Stock | 38.4175 | 38.4175 | 38.4175 | 38.4175 | 1600.0 |
| 2017-10-05 07:06:00 | AAPL | Stock | 38.415 | 38.415 | 38.415 | 38.415 | 1888.0 |
| 2017-10-05 07:12:00 | AAPL | Stock | 38.39 | 38.39 | 38.39 | 38.39 | 448.0 |
| 2017-10-05 07:14:00 | AAPL | Stock | 38.395 | 38.395 | 38.395 | 38.395 | 400.0 |
| 2017-10-05 07:15:00 | AAPL | Stock | 38.3925 | 38.3925 | 38.3925 | 38.3925 | 400.0 |
| 2017-10-05 07:23:00 | AAPL | Stock | 38.4175 | 38.4175 | 38.4175 | 38.4175 | 572.0 |
| 2017-10-05 07:25:00 | AAPL | Stock | 38.3925 | 38.3925 | 38.3925 | 38.3925 | 400.0 |
| 2017-10-05 07:39:00 | AAPL | Stock | 38.4225 | 38.425 | 38.4225 | 38.425 | 1080.0 |
| 2017-10-05 07:48:00 | AAPL | Stock | 38.43 | 38.43 | 38.43 | 38.43 | 400.0 |
| 2017-10-05 07:51:00 | AAPL | Stock | 38.435 | 38.435 | 38.435 | 38.435 | 1488.0 |
| 2017-10-05 07:55:00 | AAPL | Stock | 38.4475 | 38.4475 | 38.4475 | 38.4475 | 1200.0 |
| 2017-10-05 07:57:00 | AAPL | Stock | 38.4475 | 38.45 | 38.4475 | 38.45 | 1208.0 |
| 2017-10-05 08:00:00 | AAPL | Stock | 38.45 | 38.45 | 38.42 | 38.45 | 11292.0 |
| 2017-10-05 08:01:00 | AAPL | Stock | 38.46 | 38.4625 | 38.4575 | 38.4625 | 5276.0 |
| 2017-10-05 08:02:00 | AAPL | Stock | 38.46 | 38.4625 | 38.45 | 38.45 | 18100.0 |
| 2017-10-05 08:03:00 | AAPL | Stock | 38.465 | 38.475 | 38.465 | 38.475 | 2472.0 |
| 2017-10-05 08:04:00 | AAPL | Stock | 38.4825 | 38.4875 | 38.4825 | 38.4875 | 3872.0 |
| 2017-10-05 08:05:00 | AAPL | Stock | 38.475 | 38.475 | 38.475 | 38.475 | 2000.0 |
| 2017-10-05 08:06:00 | AAPL | Stock | 38.4925 | 38.4925 | 38.4925 | 38.4925 | 800.0 |
| 2017-10-05 08:07:00 | AAPL | Stock | 38.4875 | 38.4875 | 38.4875 | 38.4875 | 2000.0 |
| 2017-10-05 08:10:00 | AAPL | Stock | 38.475 | 38.475 | 38.475 | 38.475 | 1200.0 |
| 2017-10-05 08:11:00 | AAPL | Stock | 38.495 | 38.5 | 38.495 | 38.5 | 3704.0 |
| 2017-10-05 08:12:00 | AAPL | Stock | 38.5 | 38.5 | 38.5 | 38.5 | 400.0 |
| 2017-10-05 08:13:00 | AAPL | Stock | 38.525 | 38.525 | 38.5125 | 38.525 | 34436.0 |
| 2017-10-05 08:14:00 | AAPL | Stock | 38.55 | 38.55 | 38.5425 | 38.5475 | 15820.0 |
| 2017-10-05 08:15:00 | AAPL | Stock | 38.53 | 38.53 | 38.525 | 38.525 | 2400.0 |
| 2017-10-05 08:16:00 | AAPL | Stock | 38.545 | 38.545 | 38.545 | 38.545 | 916.0 |
| 2017-10-05 08:18:00 | AAPL | Stock | 38.5275 | 38.545 | 38.5275 | 38.545 | 2520.0 |
| 2017-10-05 08:19:00 | AAPL | Stock | 38.5275 | 38.545 | 38.525 | 38.525 | 6336.0 |
| 2017-10-05 08:20:00 | AAPL | Stock | 38.53 | 38.53 | 38.525 | 38.525 | 1200.0 |
| 2017-10-05 08:22:00 | AAPL | Stock | 38.525 | 38.5375 | 38.525 | 38.5375 | 3088.0 |
| 2017-10-05 08:23:00 | AAPL | Stock | 38.545 | 38.56 | 38.5425 | 38.56 | 7576.0 |
| 2017-10-05 08:24:00 | AAPL | Stock | 38.555 | 38.555 | 38.555 | 38.555 | 2000.0 |
| 2017-10-05 08:26:00 | AAPL | Stock | 38.555 | 38.5575 | 38.555 | 38.5575 | 3200.0 |
| 2017-10-05 08:27:00 | AAPL | Stock | 38.54 | 38.54 | 38.54 | 38.54 | 400.0 |
| 2017-10-05 08:28:00 | AAPL | Stock | 38.5375 | 38.5475 | 38.5375 | 38.5475 | 2800.0 |
| 2017-10-05 08:29:00 | AAPL | Stock | 38.5475 | 38.5475 | 38.5475 | 38.5475 | 800.0 |
| 2017-10-05 08:31:00 | AAPL | Stock | 38.54 | 38.54 | 38.54 | 38.54 | 480.0 |
| 2017-10-05 08:32:00 | AAPL | Stock | 38.53 | 38.5325 | 38.53 | 38.5325 | 3200.0 |
| 2017-10-05 08:33:00 | AAPL | Stock | 38.54 | 38.55 | 38.54 | 38.55 | 4080.0 |
| 2017-10-05 08:34:00 | AAPL | Stock | 38.5375 | 38.5475 | 38.5375 | 38.5475 | 1200.0 |
| 2017-10-05 08:35:00 | AAPL | Stock | 38.53 | 38.5375 | 38.53 | 38.5375 | 7700.0 |
| 2017-10-05 08:37:00 | AAPL | Stock | 38.525 | 38.525 | 38.525 | 38.525 | 4008.0 |
| 2017-10-05 08:38:00 | AAPL | Stock | 38.515 | 38.515 | 38.515 | 38.515 | 2992.0 |
> showing 50 of 1,038,734 rows — these rows as CSV