PREVIEW / stock_1min / 2018-10-23
file: by_date/stock_1min/2018/2018-10-23.parquet size: 17.1 MB rows: 1,142,208 symbols: 2,326
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-23 04:00:00 | AAPL | Stock | 54.9675 | 54.9675 | 54.9675 | 54.9675 | 3200.0 |
| 2018-10-23 04:02:00 | AAPL | Stock | 54.4425 | 54.5 | 54.375 | 54.5 | 2200.0 |
| 2018-10-23 04:03:00 | AAPL | Stock | 54.5 | 54.5 | 54.5 | 54.5 | 3680.0 |
| 2018-10-23 04:05:00 | AAPL | Stock | 54.525 | 54.525 | 54.525 | 54.525 | 10528.0 |
| 2018-10-23 04:10:00 | AAPL | Stock | 54.4375 | 54.4375 | 54.4375 | 54.4375 | 2400.0 |
| 2018-10-23 04:13:00 | AAPL | Stock | 54.5 | 54.5 | 54.5 | 54.5 | 800.0 |
| 2018-10-23 04:16:00 | AAPL | Stock | 54.38 | 54.38 | 54.38 | 54.38 | 5120.0 |
| 2018-10-23 04:24:00 | AAPL | Stock | 54.375 | 54.375 | 54.375 | 54.375 | 1444.0 |
| 2018-10-23 04:27:00 | AAPL | Stock | 54.3275 | 54.395 | 54.3275 | 54.395 | 4080.0 |
| 2018-10-23 04:29:00 | AAPL | Stock | 54.375 | 54.375 | 54.3575 | 54.3575 | 800.0 |
| 2018-10-23 04:31:00 | AAPL | Stock | 54.3275 | 54.3275 | 54.3275 | 54.3275 | 3304.0 |
| 2018-10-23 04:32:00 | AAPL | Stock | 54.3575 | 54.3575 | 54.3575 | 54.3575 | 1912.0 |
| 2018-10-23 04:42:00 | AAPL | Stock | 54.42 | 54.42 | 54.3325 | 54.3325 | 2384.0 |
| 2018-10-23 04:49:00 | AAPL | Stock | 54.335 | 54.335 | 54.335 | 54.335 | 2000.0 |
| 2018-10-23 04:50:00 | AAPL | Stock | 54.3725 | 54.3725 | 54.3725 | 54.3725 | 1520.0 |
| 2018-10-23 04:54:00 | AAPL | Stock | 54.335 | 54.335 | 54.335 | 54.335 | 800.0 |
| 2018-10-23 04:55:00 | AAPL | Stock | 54.3375 | 54.3375 | 54.3375 | 54.3375 | 4000.0 |
| 2018-10-23 04:57:00 | AAPL | Stock | 54.4 | 54.4 | 54.4 | 54.4 | 1576.0 |
| 2018-10-23 05:01:00 | AAPL | Stock | 54.3325 | 54.3325 | 54.33 | 54.33 | 2600.0 |
| 2018-10-23 05:02:00 | AAPL | Stock | 54.25 | 54.25 | 54.25 | 54.25 | 1200.0 |
| 2018-10-23 05:14:00 | AAPL | Stock | 54.32 | 54.32 | 54.32 | 54.32 | 6180.0 |
| 2018-10-23 05:30:00 | AAPL | Stock | 54.25 | 54.25 | 54.25 | 54.25 | 3360.0 |
| 2018-10-23 05:32:00 | AAPL | Stock | 54.2325 | 54.2325 | 54.22 | 54.22 | 1400.0 |
| 2018-10-23 05:34:00 | AAPL | Stock | 54.22 | 54.22 | 54.22 | 54.22 | 400.0 |
| 2018-10-23 05:35:00 | AAPL | Stock | 54.25 | 54.25 | 54.25 | 54.25 | 600.0 |
| 2018-10-23 05:36:00 | AAPL | Stock | 54.275 | 54.275 | 54.2725 | 54.275 | 1332.0 |
| 2018-10-23 05:45:00 | AAPL | Stock | 54.32 | 54.32 | 54.32 | 54.32 | 748.0 |
| 2018-10-23 05:46:00 | AAPL | Stock | 54.32 | 54.32 | 54.32 | 54.32 | 1200.0 |
| 2018-10-23 05:52:00 | AAPL | Stock | 54.255 | 54.3575 | 54.2525 | 54.3575 | 1600.0 |
| 2018-10-23 05:55:00 | AAPL | Stock | 54.3625 | 54.3625 | 54.3625 | 54.3625 | 2400.0 |
| 2018-10-23 06:10:00 | AAPL | Stock | 54.325 | 54.325 | 54.325 | 54.325 | 400.0 |
| 2018-10-23 06:13:00 | AAPL | Stock | 54.32 | 54.32 | 54.3125 | 54.3125 | 1000.0 |
| 2018-10-23 06:15:00 | AAPL | Stock | 54.3125 | 54.3875 | 54.3125 | 54.3875 | 1340.0 |
| 2018-10-23 06:16:00 | AAPL | Stock | 54.375 | 54.375 | 54.375 | 54.375 | 400.0 |
| 2018-10-23 06:21:00 | AAPL | Stock | 54.36 | 54.3625 | 54.36 | 54.3625 | 1080.0 |
| 2018-10-23 06:22:00 | AAPL | Stock | 54.35 | 54.375 | 54.35 | 54.375 | 3600.0 |
| 2018-10-23 06:25:00 | AAPL | Stock | 54.375 | 54.375 | 54.375 | 54.375 | 1200.0 |
| 2018-10-23 06:28:00 | AAPL | Stock | 54.31 | 54.31 | 54.31 | 54.31 | 400.0 |
| 2018-10-23 06:30:00 | AAPL | Stock | 54.3175 | 54.3175 | 54.3175 | 54.3175 | 800.0 |
| 2018-10-23 06:31:00 | AAPL | Stock | 54.31 | 54.31 | 54.31 | 54.31 | 2400.0 |
| 2018-10-23 06:33:00 | AAPL | Stock | 54.2425 | 54.2425 | 54.2425 | 54.2425 | 1204.0 |
| 2018-10-23 06:37:00 | AAPL | Stock | 54.25 | 54.275 | 54.2125 | 54.275 | 4604.0 |
| 2018-10-23 06:46:00 | AAPL | Stock | 54.2775 | 54.2775 | 54.2775 | 54.2775 | 1360.0 |
| 2018-10-23 06:48:00 | AAPL | Stock | 54.325 | 54.325 | 54.325 | 54.325 | 2000.0 |
| 2018-10-23 06:49:00 | AAPL | Stock | 54.36 | 54.36 | 54.36 | 54.36 | 600.0 |
| 2018-10-23 06:51:00 | AAPL | Stock | 54.31 | 54.31 | 54.31 | 54.31 | 1244.0 |
| 2018-10-23 06:52:00 | AAPL | Stock | 54.365 | 54.3925 | 54.3325 | 54.3325 | 2896.0 |
| 2018-10-23 06:54:00 | AAPL | Stock | 54.3775 | 54.3775 | 54.3775 | 54.3775 | 432.0 |
| 2018-10-23 06:57:00 | AAPL | Stock | 54.405 | 54.4125 | 54.405 | 54.4125 | 8168.0 |
| 2018-10-23 06:59:00 | AAPL | Stock | 54.4125 | 54.4125 | 54.4125 | 54.4125 | 2800.0 |
> showing 50 of 1,142,208 rows — these rows as CSV