PREVIEW / stock_1min / 2018-12-17
file: by_date/stock_1min/2018/2018-12-17.parquet size: 18.1 MB rows: 1,221,600 symbols: 2,281
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-12-17 04:00:00 | AAPL | Stock | 41.42 | 41.4875 | 41.4 | 41.4875 | 10468.0 |
| 2018-12-17 04:01:00 | AAPL | Stock | 41.5 | 41.5 | 41.4975 | 41.5 | 3196.0 |
| 2018-12-17 04:03:00 | AAPL | Stock | 41.4525 | 41.4525 | 41.4525 | 41.4525 | 800.0 |
| 2018-12-17 04:06:00 | AAPL | Stock | 41.5725 | 41.5725 | 41.5725 | 41.5725 | 448.0 |
| 2018-12-17 04:10:00 | AAPL | Stock | 41.5 | 41.5 | 41.5 | 41.5 | 1200.0 |
| 2018-12-17 04:15:00 | AAPL | Stock | 41.4525 | 41.4525 | 41.4525 | 41.4525 | 448.0 |
| 2018-12-17 04:22:00 | AAPL | Stock | 41.495 | 41.495 | 41.495 | 41.495 | 3616.0 |
| 2018-12-17 04:36:00 | AAPL | Stock | 41.4225 | 41.4225 | 41.4225 | 41.4225 | 1928.0 |
| 2018-12-17 04:47:00 | AAPL | Stock | 41.375 | 41.375 | 41.375 | 41.375 | 1200.0 |
| 2018-12-17 04:48:00 | AAPL | Stock | 41.375 | 41.375 | 41.375 | 41.375 | 1772.0 |
| 2018-12-17 04:59:00 | AAPL | Stock | 41.47 | 41.47 | 41.47 | 41.47 | 400.0 |
| 2018-12-17 05:02:00 | AAPL | Stock | 41.47 | 41.47 | 41.47 | 41.47 | 660.0 |
| 2018-12-17 05:09:00 | AAPL | Stock | 41.4425 | 41.4425 | 41.4425 | 41.4425 | 540.0 |
| 2018-12-17 05:53:00 | AAPL | Stock | 41.4525 | 41.4525 | 41.4525 | 41.4525 | 800.0 |
| 2018-12-17 05:58:00 | AAPL | Stock | 41.3825 | 41.3925 | 41.375 | 41.3925 | 4056.0 |
| 2018-12-17 05:59:00 | AAPL | Stock | 41.47 | 41.47 | 41.47 | 41.47 | 1600.0 |
| 2018-12-17 06:28:00 | AAPL | Stock | 41.38 | 41.38 | 41.375 | 41.375 | 2600.0 |
| 2018-12-17 06:29:00 | AAPL | Stock | 41.4025 | 41.4025 | 41.4025 | 41.4025 | 3960.0 |
| 2018-12-17 06:31:00 | AAPL | Stock | 41.4025 | 41.4025 | 41.4025 | 41.4025 | 4000.0 |
| 2018-12-17 06:33:00 | AAPL | Stock | 41.375 | 41.375 | 41.375 | 41.375 | 2744.0 |
| 2018-12-17 06:35:00 | AAPL | Stock | 41.375 | 41.375 | 41.375 | 41.375 | 400.0 |
| 2018-12-17 06:37:00 | AAPL | Stock | 41.3875 | 41.3875 | 41.3875 | 41.3875 | 2400.0 |
| 2018-12-17 06:39:00 | AAPL | Stock | 41.38 | 41.38 | 41.355 | 41.355 | 2588.0 |
| 2018-12-17 06:40:00 | AAPL | Stock | 41.3275 | 41.3275 | 41.3125 | 41.3125 | 3100.0 |
| 2018-12-17 06:41:00 | AAPL | Stock | 41.3025 | 41.3025 | 41.275 | 41.275 | 5276.0 |
| 2018-12-17 06:42:00 | AAPL | Stock | 41.3 | 41.3 | 41.275 | 41.275 | 6700.0 |
| 2018-12-17 06:43:00 | AAPL | Stock | 41.255 | 41.255 | 41.25 | 41.25 | 3600.0 |
| 2018-12-17 06:44:00 | AAPL | Stock | 41.225 | 41.225 | 41.225 | 41.225 | 400.0 |
| 2018-12-17 06:50:00 | AAPL | Stock | 41.225 | 41.225 | 41.225 | 41.225 | 416.0 |
| 2018-12-17 06:53:00 | AAPL | Stock | 41.15 | 41.22 | 41.125 | 41.22 | 8212.0 |
| 2018-12-17 06:57:00 | AAPL | Stock | 41.225 | 41.225 | 41.225 | 41.225 | 4520.0 |
| 2018-12-17 06:58:00 | AAPL | Stock | 41.225 | 41.275 | 41.225 | 41.275 | 6224.0 |
| 2018-12-17 07:00:00 | AAPL | Stock | 41.275 | 41.32 | 41.25 | 41.3 | 5096.0 |
| 2018-12-17 07:01:00 | AAPL | Stock | 41.32 | 41.3625 | 41.32 | 41.36 | 4480.0 |
| 2018-12-17 07:02:00 | AAPL | Stock | 41.3375 | 41.3575 | 41.3125 | 41.3125 | 4808.0 |
| 2018-12-17 07:04:00 | AAPL | Stock | 41.345 | 41.345 | 41.345 | 41.345 | 1240.0 |
| 2018-12-17 07:11:00 | AAPL | Stock | 41.3675 | 41.3725 | 41.3675 | 41.3725 | 11900.0 |
| 2018-12-17 07:12:00 | AAPL | Stock | 41.3625 | 41.3625 | 41.3625 | 41.3625 | 400.0 |
| 2018-12-17 07:14:00 | AAPL | Stock | 41.33 | 41.33 | 41.33 | 41.33 | 400.0 |
| 2018-12-17 07:16:00 | AAPL | Stock | 41.3625 | 41.375 | 41.3625 | 41.375 | 1200.0 |
| 2018-12-17 07:18:00 | AAPL | Stock | 41.37 | 41.37 | 41.37 | 41.37 | 400.0 |
| 2018-12-17 07:20:00 | AAPL | Stock | 41.3425 | 41.3425 | 41.26 | 41.26 | 6212.0 |
| 2018-12-17 07:21:00 | AAPL | Stock | 41.27 | 41.27 | 41.2675 | 41.2675 | 1200.0 |
| 2018-12-17 07:22:00 | AAPL | Stock | 41.2675 | 41.3 | 41.2675 | 41.3 | 2400.0 |
| 2018-12-17 07:23:00 | AAPL | Stock | 41.285 | 41.2975 | 41.285 | 41.2975 | 1200.0 |
| 2018-12-17 07:24:00 | AAPL | Stock | 41.275 | 41.275 | 41.25 | 41.25 | 20552.0 |
| 2018-12-17 07:25:00 | AAPL | Stock | 41.2275 | 41.2275 | 41.2275 | 41.2275 | 1996.0 |
| 2018-12-17 07:26:00 | AAPL | Stock | 41.25 | 41.3125 | 41.25 | 41.3 | 39980.0 |
| 2018-12-17 07:27:00 | AAPL | Stock | 41.3125 | 41.3275 | 41.3125 | 41.3275 | 6000.0 |
| 2018-12-17 07:28:00 | AAPL | Stock | 41.3425 | 41.375 | 41.33 | 41.33 | 3200.0 |
> showing 50 of 1,221,600 rows — these rows as CSV