PREVIEW / stock_1min / 2017-05-30
file: by_date/stock_1min/2017/2017-05-30.parquet size: 14.0 MB rows: 1,025,888 symbols: 2,520
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-30 04:00:00 | AAPL | Stock | 38.4 | 38.4275 | 38.4 | 38.4275 | 2800.0 |
| 2017-05-30 04:01:00 | AAPL | Stock | 38.4275 | 38.4275 | 38.4275 | 38.4275 | 2756.0 |
| 2017-05-30 04:20:00 | AAPL | Stock | 38.375 | 38.375 | 38.375 | 38.375 | 4400.0 |
| 2017-05-30 04:29:00 | AAPL | Stock | 38.35 | 38.35 | 38.35 | 38.35 | 800.0 |
| 2017-05-30 05:10:00 | AAPL | Stock | 38.3425 | 38.3425 | 38.3425 | 38.3425 | 1680.0 |
| 2017-05-30 05:23:00 | AAPL | Stock | 38.31 | 38.31 | 38.31 | 38.31 | 400.0 |
| 2017-05-30 06:03:00 | AAPL | Stock | 38.3325 | 38.3325 | 38.3325 | 38.3325 | 2616.0 |
| 2017-05-30 06:04:00 | AAPL | Stock | 38.3325 | 38.3325 | 38.3325 | 38.3325 | 800.0 |
| 2017-05-30 06:05:00 | AAPL | Stock | 38.3325 | 38.3325 | 38.3325 | 38.3325 | 800.0 |
| 2017-05-30 06:06:00 | AAPL | Stock | 38.3325 | 38.3325 | 38.3325 | 38.3325 | 488.0 |
| 2017-05-30 06:13:00 | AAPL | Stock | 38.3475 | 38.3475 | 38.3475 | 38.3475 | 680.0 |
| 2017-05-30 06:24:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3325 | 38.3375 | 4240.0 |
| 2017-05-30 06:29:00 | AAPL | Stock | 38.3225 | 38.325 | 38.3225 | 38.325 | 10400.0 |
| 2017-05-30 06:35:00 | AAPL | Stock | 38.345 | 38.3475 | 38.345 | 38.3475 | 1300.0 |
| 2017-05-30 06:36:00 | AAPL | Stock | 38.3025 | 38.3025 | 38.3 | 38.3 | 800.0 |
| 2017-05-30 06:45:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3375 | 38.3375 | 4400.0 |
| 2017-05-30 07:01:00 | AAPL | Stock | 38.3225 | 38.3225 | 38.3225 | 38.3225 | 400.0 |
| 2017-05-30 07:04:00 | AAPL | Stock | 38.295 | 38.295 | 38.29 | 38.29 | 6000.0 |
| 2017-05-30 07:11:00 | AAPL | Stock | 38.29 | 38.29 | 38.29 | 38.29 | 400.0 |
| 2017-05-30 07:14:00 | AAPL | Stock | 38.295 | 38.295 | 38.295 | 38.295 | 780.0 |
| 2017-05-30 07:15:00 | AAPL | Stock | 38.295 | 38.295 | 38.29 | 38.29 | 1980.0 |
| 2017-05-30 07:21:00 | AAPL | Stock | 38.29 | 38.29 | 38.29 | 38.29 | 400.0 |
| 2017-05-30 07:25:00 | AAPL | Stock | 38.2975 | 38.2975 | 38.2975 | 38.2975 | 400.0 |
| 2017-05-30 07:28:00 | AAPL | Stock | 38.3 | 38.3 | 38.3 | 38.3 | 1200.0 |
| 2017-05-30 07:29:00 | AAPL | Stock | 38.3075 | 38.3075 | 38.3075 | 38.3075 | 6800.0 |
| 2017-05-30 07:37:00 | AAPL | Stock | 38.3 | 38.3 | 38.2975 | 38.2975 | 2000.0 |
| 2017-05-30 07:40:00 | AAPL | Stock | 38.29 | 38.29 | 38.29 | 38.29 | 816.0 |
| 2017-05-30 07:45:00 | AAPL | Stock | 38.295 | 38.295 | 38.295 | 38.295 | 800.0 |
| 2017-05-30 07:51:00 | AAPL | Stock | 38.3 | 38.3 | 38.29 | 38.29 | 2400.0 |
| 2017-05-30 07:54:00 | AAPL | Stock | 38.3075 | 38.3075 | 38.29 | 38.29 | 1600.0 |
| 2017-05-30 07:55:00 | AAPL | Stock | 38.305 | 38.305 | 38.305 | 38.305 | 800.0 |
| 2017-05-30 07:56:00 | AAPL | Stock | 38.29 | 38.29 | 38.29 | 38.29 | 1600.0 |
| 2017-05-30 07:57:00 | AAPL | Stock | 38.3 | 38.3 | 38.3 | 38.3 | 1200.0 |
| 2017-05-30 07:58:00 | AAPL | Stock | 38.3 | 38.3 | 38.3 | 38.3 | 2000.0 |
| 2017-05-30 07:59:00 | AAPL | Stock | 38.3 | 38.3 | 38.3 | 38.3 | 800.0 |
| 2017-05-30 08:00:00 | AAPL | Stock | 38.305 | 38.31 | 38.3 | 38.3 | 50020.0 |
| 2017-05-30 08:01:00 | AAPL | Stock | 38.2925 | 38.2925 | 38.29 | 38.2925 | 28284.0 |
| 2017-05-30 08:03:00 | AAPL | Stock | 38.3 | 38.3 | 38.295 | 38.295 | 2404.0 |
| 2017-05-30 08:04:00 | AAPL | Stock | 38.305 | 38.305 | 38.305 | 38.305 | 2000.0 |
| 2017-05-30 08:05:00 | AAPL | Stock | 38.295 | 38.295 | 38.295 | 38.295 | 400.0 |
| 2017-05-30 08:06:00 | AAPL | Stock | 38.29 | 38.3025 | 38.2875 | 38.3025 | 3680.0 |
| 2017-05-30 08:08:00 | AAPL | Stock | 38.31 | 38.31 | 38.31 | 38.31 | 2000.0 |
| 2017-05-30 08:09:00 | AAPL | Stock | 38.31 | 38.3125 | 38.3 | 38.3 | 4828.0 |
| 2017-05-30 08:11:00 | AAPL | Stock | 38.3225 | 38.3225 | 38.3175 | 38.3175 | 5744.0 |
| 2017-05-30 08:12:00 | AAPL | Stock | 38.3375 | 38.345 | 38.3375 | 38.345 | 3600.0 |
| 2017-05-30 08:13:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.33 | 38.33 | 2596.0 |
| 2017-05-30 08:16:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3375 | 38.3375 | 400.0 |
| 2017-05-30 08:17:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3375 | 38.3375 | 4000.0 |
| 2017-05-30 08:21:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3375 | 38.3375 | 5000.0 |
| 2017-05-30 08:23:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3375 | 38.3375 | 1200.0 |
> showing 50 of 1,025,888 rows — these rows as CSV