PREVIEW / stock_1min / 2017-06-02
file: by_date/stock_1min/2017/2017-06-02.parquet size: 14.8 MB rows: 1,073,661 symbols: 2,512
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-06-02 04:25:00 | AAPL | Stock | 38.41 | 38.41 | 38.41 | 38.41 | 2000.0 |
| 2017-06-02 05:51:00 | AAPL | Stock | 38.4625 | 38.4625 | 38.4625 | 38.4625 | 3828.0 |
| 2017-06-02 06:07:00 | AAPL | Stock | 38.4575 | 38.4575 | 38.4575 | 38.4575 | 4000.0 |
| 2017-06-02 06:13:00 | AAPL | Stock | 38.425 | 38.425 | 38.425 | 38.425 | 5656.0 |
| 2017-06-02 06:18:00 | AAPL | Stock | 38.46 | 38.4725 | 38.46 | 38.4725 | 1272.0 |
| 2017-06-02 06:26:00 | AAPL | Stock | 38.4275 | 38.4275 | 38.4275 | 38.4275 | 400.0 |
| 2017-06-02 06:42:00 | AAPL | Stock | 38.445 | 38.445 | 38.4425 | 38.4425 | 2400.0 |
| 2017-06-02 06:59:00 | AAPL | Stock | 38.4425 | 38.4425 | 38.4425 | 38.4425 | 400.0 |
| 2017-06-02 07:00:00 | AAPL | Stock | 38.435 | 38.45 | 38.435 | 38.45 | 3000.0 |
| 2017-06-02 07:01:00 | AAPL | Stock | 38.45 | 38.45 | 38.45 | 38.45 | 600.0 |
| 2017-06-02 07:03:00 | AAPL | Stock | 38.45 | 38.45 | 38.4425 | 38.4425 | 2572.0 |
| 2017-06-02 07:04:00 | AAPL | Stock | 38.4425 | 38.4425 | 38.4425 | 38.4425 | 800.0 |
| 2017-06-02 07:05:00 | AAPL | Stock | 38.4375 | 38.4375 | 38.4375 | 38.4375 | 6892.0 |
| 2017-06-02 07:12:00 | AAPL | Stock | 38.4325 | 38.4325 | 38.4325 | 38.4325 | 1568.0 |
| 2017-06-02 07:20:00 | AAPL | Stock | 38.4375 | 38.4375 | 38.4375 | 38.4375 | 800.0 |
| 2017-06-02 07:30:00 | AAPL | Stock | 38.41 | 38.41 | 38.41 | 38.41 | 3100.0 |
| 2017-06-02 07:37:00 | AAPL | Stock | 38.4 | 38.4 | 38.4 | 38.4 | 400.0 |
| 2017-06-02 07:50:00 | AAPL | Stock | 38.42 | 38.425 | 38.42 | 38.425 | 1996.0 |
| 2017-06-02 07:55:00 | AAPL | Stock | 38.425 | 38.425 | 38.425 | 38.425 | 800.0 |
| 2017-06-02 07:56:00 | AAPL | Stock | 38.38 | 38.3825 | 38.38 | 38.3825 | 1848.0 |
| 2017-06-02 08:00:00 | AAPL | Stock | 38.4375 | 38.45 | 38.3775 | 38.38 | 39916.0 |
| 2017-06-02 08:01:00 | AAPL | Stock | 38.38 | 38.3875 | 38.3775 | 38.3875 | 10552.0 |
| 2017-06-02 08:02:00 | AAPL | Stock | 38.3875 | 38.3875 | 38.385 | 38.3875 | 11800.0 |
| 2017-06-02 08:04:00 | AAPL | Stock | 38.3975 | 38.3975 | 38.3975 | 38.3975 | 400.0 |
| 2017-06-02 08:06:00 | AAPL | Stock | 38.4 | 38.4 | 38.4 | 38.4 | 2000.0 |
| 2017-06-02 08:09:00 | AAPL | Stock | 38.3975 | 38.3975 | 38.385 | 38.385 | 4656.0 |
| 2017-06-02 08:10:00 | AAPL | Stock | 38.385 | 38.385 | 38.385 | 38.385 | 3616.0 |
| 2017-06-02 08:11:00 | AAPL | Stock | 38.3975 | 38.4 | 38.3975 | 38.4 | 1200.0 |
| 2017-06-02 08:15:00 | AAPL | Stock | 38.41 | 38.41 | 38.41 | 38.41 | 1396.0 |
| 2017-06-02 08:16:00 | AAPL | Stock | 38.43 | 38.43 | 38.43 | 38.43 | 1792.0 |
| 2017-06-02 08:17:00 | AAPL | Stock | 38.4225 | 38.4225 | 38.4225 | 38.4225 | 612.0 |
| 2017-06-02 08:27:00 | AAPL | Stock | 38.415 | 38.4175 | 38.415 | 38.4175 | 800.0 |
| 2017-06-02 08:30:00 | AAPL | Stock | 38.4 | 38.4 | 38.35 | 38.375 | 30620.0 |
| 2017-06-02 08:31:00 | AAPL | Stock | 38.4125 | 38.4125 | 38.4075 | 38.41 | 7600.0 |
| 2017-06-02 08:32:00 | AAPL | Stock | 38.4075 | 38.415 | 38.3425 | 38.3425 | 18856.0 |
| 2017-06-02 08:34:00 | AAPL | Stock | 38.375 | 38.3825 | 38.35 | 38.35 | 7428.0 |
| 2017-06-02 08:35:00 | AAPL | Stock | 38.3875 | 38.3875 | 38.3675 | 38.375 | 4380.0 |
| 2017-06-02 08:36:00 | AAPL | Stock | 38.3625 | 38.3625 | 38.3625 | 38.3625 | 3276.0 |
| 2017-06-02 08:37:00 | AAPL | Stock | 38.3625 | 38.3625 | 38.3625 | 38.3625 | 4200.0 |
| 2017-06-02 08:38:00 | AAPL | Stock | 38.375 | 38.375 | 38.375 | 38.375 | 800.0 |
| 2017-06-02 08:39:00 | AAPL | Stock | 38.3725 | 38.375 | 38.3725 | 38.375 | 10000.0 |
| 2017-06-02 08:40:00 | AAPL | Stock | 38.3675 | 38.3675 | 38.3625 | 38.3625 | 4400.0 |
| 2017-06-02 08:41:00 | AAPL | Stock | 38.355 | 38.355 | 38.35 | 38.35 | 3752.0 |
| 2017-06-02 08:43:00 | AAPL | Stock | 38.37 | 38.3875 | 38.36 | 38.3875 | 14436.0 |
| 2017-06-02 08:44:00 | AAPL | Stock | 38.3625 | 38.3625 | 38.355 | 38.355 | 13180.0 |
| 2017-06-02 08:45:00 | AAPL | Stock | 38.345 | 38.3525 | 38.345 | 38.3525 | 4400.0 |
| 2017-06-02 08:46:00 | AAPL | Stock | 38.33 | 38.33 | 38.3 | 38.3 | 4000.0 |
| 2017-06-02 08:47:00 | AAPL | Stock | 38.27 | 38.315 | 38.27 | 38.315 | 2800.0 |
| 2017-06-02 08:48:00 | AAPL | Stock | 38.315 | 38.315 | 38.3 | 38.3 | 10400.0 |
| 2017-06-02 08:50:00 | AAPL | Stock | 38.3 | 38.3 | 38.3 | 38.3 | 1600.0 |
> showing 50 of 1,073,661 rows — these rows as CSV