PREVIEW / stock_1min / 2019-10-21
file: by_date/stock_1min/2019/2019-10-21.parquet size: 15.1 MB rows: 1,074,036 symbols: 2,110
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 |
|---|---|---|---|---|---|---|---|
| 2019-10-21 04:00:00 | AAPL | Stock | 59.31 | 59.375 | 59.31 | 59.375 | 19620.0 |
| 2019-10-21 04:02:00 | AAPL | Stock | 59.3625 | 59.3625 | 59.3625 | 59.3625 | 400.0 |
| 2019-10-21 04:22:00 | AAPL | Stock | 59.3575 | 59.3575 | 59.3575 | 59.3575 | 1808.0 |
| 2019-10-21 04:43:00 | AAPL | Stock | 59.3875 | 59.3875 | 59.3875 | 59.3875 | 1200.0 |
| 2019-10-21 04:52:00 | AAPL | Stock | 59.3675 | 59.3875 | 59.3625 | 59.375 | 21632.0 |
| 2019-10-21 04:53:00 | AAPL | Stock | 59.375 | 59.375 | 59.375 | 59.375 | 400.0 |
| 2019-10-21 05:03:00 | AAPL | Stock | 59.3625 | 59.3625 | 59.3625 | 59.3625 | 1188.0 |
| 2019-10-21 05:04:00 | AAPL | Stock | 59.37 | 59.375 | 59.37 | 59.375 | 1200.0 |
| 2019-10-21 05:18:00 | AAPL | Stock | 59.3675 | 59.3775 | 59.3675 | 59.3775 | 5200.0 |
| 2019-10-21 05:19:00 | AAPL | Stock | 59.3775 | 59.3775 | 59.3775 | 59.3775 | 1200.0 |
| 2019-10-21 05:49:00 | AAPL | Stock | 59.3775 | 59.3775 | 59.3775 | 59.3775 | 1620.0 |
| 2019-10-21 06:24:00 | AAPL | Stock | 59.3675 | 59.375 | 59.3675 | 59.375 | 7636.0 |
| 2019-10-21 06:28:00 | AAPL | Stock | 59.375 | 59.375 | 59.375 | 59.375 | 764.0 |
| 2019-10-21 06:32:00 | AAPL | Stock | 59.375 | 59.375 | 59.375 | 59.375 | 400.0 |
| 2019-10-21 06:33:00 | AAPL | Stock | 59.4225 | 59.4225 | 59.4225 | 59.4225 | 400.0 |
| 2019-10-21 06:34:00 | AAPL | Stock | 59.375 | 59.375 | 59.375 | 59.375 | 1656.0 |
| 2019-10-21 06:39:00 | AAPL | Stock | 59.375 | 59.375 | 59.375 | 59.375 | 400.0 |
| 2019-10-21 06:53:00 | AAPL | Stock | 59.375 | 59.375 | 59.375 | 59.375 | 756.0 |
| 2019-10-21 06:56:00 | AAPL | Stock | 59.375 | 59.375 | 59.375 | 59.375 | 800.0 |
| 2019-10-21 06:59:00 | AAPL | Stock | 59.4 | 59.4 | 59.4 | 59.4 | 400.0 |
| 2019-10-21 07:00:00 | AAPL | Stock | 59.3525 | 59.3775 | 59.2875 | 59.375 | 48492.0 |
| 2019-10-21 07:01:00 | AAPL | Stock | 59.35 | 59.35 | 59.35 | 59.35 | 400.0 |
| 2019-10-21 07:03:00 | AAPL | Stock | 59.3025 | 59.3125 | 59.3025 | 59.3125 | 800.0 |
| 2019-10-21 07:04:00 | AAPL | Stock | 59.315 | 59.315 | 59.3 | 59.3 | 3600.0 |
| 2019-10-21 07:05:00 | AAPL | Stock | 59.3 | 59.3125 | 59.3 | 59.3125 | 10200.0 |
| 2019-10-21 07:06:00 | AAPL | Stock | 59.3125 | 59.32 | 59.31 | 59.3125 | 8800.0 |
| 2019-10-21 07:07:00 | AAPL | Stock | 59.31 | 59.3125 | 59.31 | 59.3125 | 1200.0 |
| 2019-10-21 07:09:00 | AAPL | Stock | 59.3125 | 59.3125 | 59.3 | 59.3 | 3000.0 |
| 2019-10-21 07:14:00 | AAPL | Stock | 59.3 | 59.3 | 59.3 | 59.3 | 2400.0 |
| 2019-10-21 07:15:00 | AAPL | Stock | 59.3 | 59.3 | 59.3 | 59.3 | 1600.0 |
| 2019-10-21 07:18:00 | AAPL | Stock | 59.3125 | 59.3125 | 59.3125 | 59.3125 | 3360.0 |
| 2019-10-21 07:20:00 | AAPL | Stock | 59.3225 | 59.3225 | 59.315 | 59.315 | 5616.0 |
| 2019-10-21 07:22:00 | AAPL | Stock | 59.305 | 59.305 | 59.2925 | 59.2925 | 1600.0 |
| 2019-10-21 07:23:00 | AAPL | Stock | 59.3 | 59.315 | 59.3 | 59.315 | 2320.0 |
| 2019-10-21 07:25:00 | AAPL | Stock | 59.31 | 59.3425 | 59.31 | 59.3425 | 3608.0 |
| 2019-10-21 07:27:00 | AAPL | Stock | 59.35 | 59.35 | 59.35 | 59.35 | 13124.0 |
| 2019-10-21 07:28:00 | AAPL | Stock | 59.3325 | 59.3325 | 59.3325 | 59.3325 | 400.0 |
| 2019-10-21 07:29:00 | AAPL | Stock | 59.3575 | 59.375 | 59.3575 | 59.375 | 12800.0 |
| 2019-10-21 07:30:00 | AAPL | Stock | 59.37 | 59.375 | 59.34 | 59.34 | 4392.0 |
| 2019-10-21 07:31:00 | AAPL | Stock | 59.375 | 59.385 | 59.375 | 59.385 | 4784.0 |
| 2019-10-21 07:32:00 | AAPL | Stock | 59.375 | 59.4125 | 59.375 | 59.4 | 10680.0 |
| 2019-10-21 07:33:00 | AAPL | Stock | 59.4075 | 59.4125 | 59.4075 | 59.4125 | 1596.0 |
| 2019-10-21 07:34:00 | AAPL | Stock | 59.4 | 59.4 | 59.4 | 59.4 | 800.0 |
| 2019-10-21 07:35:00 | AAPL | Stock | 59.41 | 59.4125 | 59.41 | 59.4125 | 800.0 |
| 2019-10-21 07:36:00 | AAPL | Stock | 59.41 | 59.4375 | 59.41 | 59.4375 | 11604.0 |
| 2019-10-21 07:37:00 | AAPL | Stock | 59.4325 | 59.435 | 59.425 | 59.435 | 4640.0 |
| 2019-10-21 07:38:00 | AAPL | Stock | 59.425 | 59.425 | 59.425 | 59.425 | 1280.0 |
| 2019-10-21 07:39:00 | AAPL | Stock | 59.4375 | 59.4375 | 59.4325 | 59.4375 | 1800.0 |
| 2019-10-21 07:40:00 | AAPL | Stock | 59.425 | 59.425 | 59.425 | 59.425 | 3000.0 |
| 2019-10-21 07:41:00 | AAPL | Stock | 59.425 | 59.425 | 59.4225 | 59.425 | 3600.0 |
> showing 50 of 1,074,036 rows — these rows as CSV