PREVIEW / stock_1min / 2018-12-21
file: by_date/stock_1min/2018/2018-12-21.parquet size: 18.3 MB rows: 1,254,465 symbols: 2,293
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-21 04:00:00 | AAPL | Stock | 39.25 | 39.25 | 39.25 | 39.25 | 400.0 |
| 2018-12-21 04:02:00 | AAPL | Stock | 39.2025 | 39.2025 | 39.17 | 39.17 | 1276.0 |
| 2018-12-21 04:05:00 | AAPL | Stock | 39.205 | 39.205 | 39.205 | 39.205 | 400.0 |
| 2018-12-21 04:30:00 | AAPL | Stock | 39.0675 | 39.0675 | 39.0675 | 39.0675 | 400.0 |
| 2018-12-21 04:31:00 | AAPL | Stock | 39.195 | 39.195 | 39.195 | 39.195 | 400.0 |
| 2018-12-21 04:33:00 | AAPL | Stock | 39.25 | 39.25 | 39.25 | 39.25 | 2800.0 |
| 2018-12-21 04:39:00 | AAPL | Stock | 39.18 | 39.18 | 39.18 | 39.18 | 860.0 |
| 2018-12-21 04:49:00 | AAPL | Stock | 39.1175 | 39.1175 | 39.1175 | 39.1175 | 800.0 |
| 2018-12-21 05:02:00 | AAPL | Stock | 39.125 | 39.125 | 39.125 | 39.125 | 800.0 |
| 2018-12-21 05:18:00 | AAPL | Stock | 39.12 | 39.12 | 39.12 | 39.12 | 400.0 |
| 2018-12-21 05:19:00 | AAPL | Stock | 39.1175 | 39.1175 | 39.1175 | 39.1175 | 1000.0 |
| 2018-12-21 05:24:00 | AAPL | Stock | 39.2 | 39.2 | 39.2 | 39.2 | 800.0 |
| 2018-12-21 05:25:00 | AAPL | Stock | 39.25 | 39.25 | 39.25 | 39.25 | 400.0 |
| 2018-12-21 05:34:00 | AAPL | Stock | 39.25 | 39.25 | 39.25 | 39.25 | 1060.0 |
| 2018-12-21 05:41:00 | AAPL | Stock | 39.2025 | 39.2025 | 39.2025 | 39.2025 | 400.0 |
| 2018-12-21 05:51:00 | AAPL | Stock | 39.17 | 39.17 | 39.17 | 39.17 | 400.0 |
| 2018-12-21 05:52:00 | AAPL | Stock | 39.2525 | 39.2525 | 39.25 | 39.25 | 2536.0 |
| 2018-12-21 05:57:00 | AAPL | Stock | 39.255 | 39.255 | 39.255 | 39.255 | 2396.0 |
| 2018-12-21 06:07:00 | AAPL | Stock | 39.3025 | 39.3025 | 39.3025 | 39.3025 | 1180.0 |
| 2018-12-21 06:08:00 | AAPL | Stock | 39.3025 | 39.3025 | 39.3025 | 39.3025 | 800.0 |
| 2018-12-21 06:09:00 | AAPL | Stock | 39.3025 | 39.3025 | 39.3025 | 39.3025 | 1984.0 |
| 2018-12-21 06:12:00 | AAPL | Stock | 39.3525 | 39.3525 | 39.3525 | 39.3525 | 800.0 |
| 2018-12-21 06:14:00 | AAPL | Stock | 39.3525 | 39.3525 | 39.3525 | 39.3525 | 1200.0 |
| 2018-12-21 06:41:00 | AAPL | Stock | 39.32 | 39.32 | 39.32 | 39.32 | 400.0 |
| 2018-12-21 06:42:00 | AAPL | Stock | 39.32 | 39.32 | 39.32 | 39.32 | 7200.0 |
| 2018-12-21 06:45:00 | AAPL | Stock | 39.3325 | 39.3325 | 39.3325 | 39.3325 | 400.0 |
| 2018-12-21 06:56:00 | AAPL | Stock | 39.355 | 39.3625 | 39.355 | 39.3625 | 1200.0 |
| 2018-12-21 07:00:00 | AAPL | Stock | 39.335 | 39.365 | 39.1125 | 39.35 | 26408.0 |
| 2018-12-21 07:02:00 | AAPL | Stock | 39.32 | 39.3225 | 39.32 | 39.3225 | 3680.0 |
| 2018-12-21 07:05:00 | AAPL | Stock | 39.2975 | 39.2975 | 39.2975 | 39.2975 | 400.0 |
| 2018-12-21 07:07:00 | AAPL | Stock | 39.3075 | 39.3225 | 39.3075 | 39.3225 | 5160.0 |
| 2018-12-21 07:08:00 | AAPL | Stock | 39.3125 | 39.3125 | 39.3125 | 39.3125 | 400.0 |
| 2018-12-21 07:10:00 | AAPL | Stock | 39.3125 | 39.3125 | 39.3125 | 39.3125 | 800.0 |
| 2018-12-21 07:11:00 | AAPL | Stock | 39.3125 | 39.3125 | 39.3125 | 39.3125 | 2516.0 |
| 2018-12-21 07:13:00 | AAPL | Stock | 39.2925 | 39.2925 | 39.2925 | 39.2925 | 400.0 |
| 2018-12-21 07:14:00 | AAPL | Stock | 39.2875 | 39.2875 | 39.275 | 39.275 | 9660.0 |
| 2018-12-21 07:15:00 | AAPL | Stock | 39.2775 | 39.2775 | 39.2775 | 39.2775 | 800.0 |
| 2018-12-21 07:16:00 | AAPL | Stock | 39.2775 | 39.2775 | 39.2775 | 39.2775 | 3200.0 |
| 2018-12-21 07:17:00 | AAPL | Stock | 39.295 | 39.295 | 39.2775 | 39.2775 | 8220.0 |
| 2018-12-21 07:18:00 | AAPL | Stock | 39.275 | 39.275 | 39.2675 | 39.2675 | 4400.0 |
| 2018-12-21 07:19:00 | AAPL | Stock | 39.2775 | 39.2775 | 39.2775 | 39.2775 | 4000.0 |
| 2018-12-21 07:21:00 | AAPL | Stock | 39.2625 | 39.2625 | 39.25 | 39.2625 | 6624.0 |
| 2018-12-21 07:23:00 | AAPL | Stock | 39.2675 | 39.2675 | 39.25 | 39.25 | 4160.0 |
| 2018-12-21 07:24:00 | AAPL | Stock | 39.2475 | 39.2475 | 39.225 | 39.225 | 2800.0 |
| 2018-12-21 07:26:00 | AAPL | Stock | 39.215 | 39.215 | 39.215 | 39.215 | 400.0 |
| 2018-12-21 07:27:00 | AAPL | Stock | 39.2175 | 39.2175 | 39.2 | 39.2 | 2108.0 |
| 2018-12-21 07:28:00 | AAPL | Stock | 39.18 | 39.18 | 39.175 | 39.175 | 3880.0 |
| 2018-12-21 07:29:00 | AAPL | Stock | 39.175 | 39.175 | 39.175 | 39.175 | 400.0 |
| 2018-12-21 07:30:00 | AAPL | Stock | 39.195 | 39.195 | 39.195 | 39.195 | 1600.0 |
| 2018-12-21 07:31:00 | AAPL | Stock | 39.195 | 39.195 | 39.195 | 39.195 | 3600.0 |
> showing 50 of 1,254,465 rows — these rows as CSV