PREVIEW / stock_1min / 2017-03-01
file: by_date/stock_1min/2017/2017-03-01.parquet size: 16.1 MB rows: 1,146,278 symbols: 2,553
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-01 04:00:00 | AAPL | Stock | 34.3125 | 34.345 | 34.3125 | 34.345 | 800.0 |
| 2017-03-01 04:04:00 | AAPL | Stock | 34.3325 | 34.3325 | 34.3325 | 34.3325 | 1200.0 |
| 2017-03-01 04:05:00 | AAPL | Stock | 34.3325 | 34.3325 | 34.3275 | 34.3275 | 4000.0 |
| 2017-03-01 04:06:00 | AAPL | Stock | 34.3325 | 34.3325 | 34.3325 | 34.3325 | 800.0 |
| 2017-03-01 04:08:00 | AAPL | Stock | 34.3475 | 34.3475 | 34.3475 | 34.3475 | 3448.0 |
| 2017-03-01 04:09:00 | AAPL | Stock | 34.3475 | 34.36 | 34.3475 | 34.36 | 1352.0 |
| 2017-03-01 04:10:00 | AAPL | Stock | 34.3675 | 34.3825 | 34.3675 | 34.3825 | 2332.0 |
| 2017-03-01 04:14:00 | AAPL | Stock | 34.375 | 34.375 | 34.375 | 34.375 | 1808.0 |
| 2017-03-01 04:20:00 | AAPL | Stock | 34.395 | 34.395 | 34.395 | 34.395 | 1200.0 |
| 2017-03-01 04:23:00 | AAPL | Stock | 34.4 | 34.4 | 34.4 | 34.4 | 7672.0 |
| 2017-03-01 04:27:00 | AAPL | Stock | 34.4 | 34.4 | 34.4 | 34.4 | 800.0 |
| 2017-03-01 05:19:00 | AAPL | Stock | 34.3975 | 34.3975 | 34.3975 | 34.3975 | 1200.0 |
| 2017-03-01 05:33:00 | AAPL | Stock | 34.3975 | 34.3975 | 34.3975 | 34.3975 | 828.0 |
| 2017-03-01 05:35:00 | AAPL | Stock | 34.3975 | 34.3975 | 34.3975 | 34.3975 | 964.0 |
| 2017-03-01 05:36:00 | AAPL | Stock | 34.4025 | 34.4025 | 34.4025 | 34.4025 | 800.0 |
| 2017-03-01 05:49:00 | AAPL | Stock | 34.42 | 34.42 | 34.42 | 34.42 | 400.0 |
| 2017-03-01 05:51:00 | AAPL | Stock | 34.425 | 34.425 | 34.425 | 34.425 | 4000.0 |
| 2017-03-01 05:55:00 | AAPL | Stock | 34.4025 | 34.4025 | 34.4025 | 34.4025 | 2692.0 |
| 2017-03-01 05:59:00 | AAPL | Stock | 34.4 | 34.4 | 34.4 | 34.4 | 1044.0 |
| 2017-03-01 06:03:00 | AAPL | Stock | 34.4 | 34.4 | 34.4 | 34.4 | 2400.0 |
| 2017-03-01 06:04:00 | AAPL | Stock | 34.4 | 34.425 | 34.4 | 34.425 | 6352.0 |
| 2017-03-01 06:07:00 | AAPL | Stock | 34.4225 | 34.4225 | 34.4225 | 34.4225 | 400.0 |
| 2017-03-01 06:18:00 | AAPL | Stock | 34.42 | 34.4225 | 34.42 | 34.4225 | 1072.0 |
| 2017-03-01 06:29:00 | AAPL | Stock | 34.4225 | 34.4225 | 34.4225 | 34.4225 | 2800.0 |
| 2017-03-01 06:32:00 | AAPL | Stock | 34.42 | 34.4225 | 34.42 | 34.4225 | 7888.0 |
| 2017-03-01 06:35:00 | AAPL | Stock | 34.4225 | 34.4225 | 34.4 | 34.4 | 800.0 |
| 2017-03-01 06:40:00 | AAPL | Stock | 34.42 | 34.42 | 34.42 | 34.42 | 400.0 |
| 2017-03-01 06:41:00 | AAPL | Stock | 34.415 | 34.415 | 34.4 | 34.4 | 4648.0 |
| 2017-03-01 06:48:00 | AAPL | Stock | 34.4 | 34.4 | 34.4 | 34.4 | 7600.0 |
| 2017-03-01 06:49:00 | AAPL | Stock | 34.4 | 34.4175 | 34.4 | 34.4175 | 7444.0 |
| 2017-03-01 06:50:00 | AAPL | Stock | 34.4175 | 34.43 | 34.4175 | 34.43 | 1360.0 |
| 2017-03-01 06:51:00 | AAPL | Stock | 34.4175 | 34.4175 | 34.4175 | 34.4175 | 1200.0 |
| 2017-03-01 06:52:00 | AAPL | Stock | 34.4125 | 34.4125 | 34.4 | 34.4 | 2576.0 |
| 2017-03-01 06:57:00 | AAPL | Stock | 34.42 | 34.42 | 34.42 | 34.42 | 1200.0 |
| 2017-03-01 06:59:00 | AAPL | Stock | 34.4225 | 34.425 | 34.4225 | 34.425 | 3156.0 |
| 2017-03-01 07:01:00 | AAPL | Stock | 34.425 | 34.425 | 34.4125 | 34.4125 | 7700.0 |
| 2017-03-01 07:03:00 | AAPL | Stock | 34.4175 | 34.425 | 34.4125 | 34.425 | 5184.0 |
| 2017-03-01 07:05:00 | AAPL | Stock | 34.425 | 34.425 | 34.4125 | 34.425 | 2000.0 |
| 2017-03-01 07:06:00 | AAPL | Stock | 34.425 | 34.425 | 34.425 | 34.425 | 7676.0 |
| 2017-03-01 07:07:00 | AAPL | Stock | 34.425 | 34.425 | 34.425 | 34.425 | 6400.0 |
| 2017-03-01 07:08:00 | AAPL | Stock | 34.4375 | 34.4375 | 34.4375 | 34.4375 | 400.0 |
| 2017-03-01 07:09:00 | AAPL | Stock | 34.4325 | 34.4325 | 34.425 | 34.425 | 11940.0 |
| 2017-03-01 07:10:00 | AAPL | Stock | 34.4075 | 34.4075 | 34.38 | 34.38 | 3716.0 |
| 2017-03-01 07:13:00 | AAPL | Stock | 34.41 | 34.4125 | 34.41 | 34.4125 | 3200.0 |
| 2017-03-01 07:16:00 | AAPL | Stock | 34.4125 | 34.4125 | 34.4125 | 34.4125 | 2400.0 |
| 2017-03-01 07:17:00 | AAPL | Stock | 34.4125 | 34.4125 | 34.4125 | 34.4125 | 400.0 |
| 2017-03-01 07:18:00 | AAPL | Stock | 34.4125 | 34.4125 | 34.4125 | 34.4125 | 1800.0 |
| 2017-03-01 07:21:00 | AAPL | Stock | 34.4 | 34.4 | 34.4 | 34.4 | 1200.0 |
| 2017-03-01 07:23:00 | AAPL | Stock | 34.41 | 34.41 | 34.4075 | 34.4075 | 5596.0 |
| 2017-03-01 07:26:00 | AAPL | Stock | 34.41 | 34.4125 | 34.41 | 34.4125 | 4240.0 |
> showing 50 of 1,146,278 rows — these rows as CSV