PREVIEW / stock_1min / 2018-01-24
file: by_date/stock_1min/2018/2018-01-24.parquet size: 16.7 MB rows: 1,120,951 symbols: 2,409
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-01-24 04:06:00 | AAPL | Stock | 44.3125 | 44.3125 | 44.3125 | 44.3125 | 876.0 |
| 2018-01-24 04:15:00 | AAPL | Stock | 44.3125 | 44.3125 | 44.3125 | 44.3125 | 976.0 |
| 2018-01-24 04:27:00 | AAPL | Stock | 44.33 | 44.33 | 44.33 | 44.33 | 400.0 |
| 2018-01-24 04:33:00 | AAPL | Stock | 44.33 | 44.33 | 44.33 | 44.33 | 400.0 |
| 2018-01-24 04:36:00 | AAPL | Stock | 44.33 | 44.33 | 44.33 | 44.33 | 800.0 |
| 2018-01-24 04:38:00 | AAPL | Stock | 44.3775 | 44.3775 | 44.3775 | 44.3775 | 2000.0 |
| 2018-01-24 04:39:00 | AAPL | Stock | 44.385 | 44.385 | 44.385 | 44.385 | 780.0 |
| 2018-01-24 04:40:00 | AAPL | Stock | 44.3825 | 44.3875 | 44.37 | 44.37 | 5600.0 |
| 2018-01-24 04:41:00 | AAPL | Stock | 44.3775 | 44.3775 | 44.3775 | 44.3775 | 400.0 |
| 2018-01-24 04:43:00 | AAPL | Stock | 44.3775 | 44.3775 | 44.3775 | 44.3775 | 884.0 |
| 2018-01-24 04:46:00 | AAPL | Stock | 44.315 | 44.315 | 44.3125 | 44.3125 | 8328.0 |
| 2018-01-24 04:47:00 | AAPL | Stock | 44.3625 | 44.3625 | 44.3625 | 44.3625 | 4000.0 |
| 2018-01-24 05:02:00 | AAPL | Stock | 44.3575 | 44.3575 | 44.3575 | 44.3575 | 400.0 |
| 2018-01-24 06:01:00 | AAPL | Stock | 44.3275 | 44.3275 | 44.3275 | 44.3275 | 2000.0 |
| 2018-01-24 06:02:00 | AAPL | Stock | 44.3275 | 44.3275 | 44.3275 | 44.3275 | 2800.0 |
| 2018-01-24 06:44:00 | AAPL | Stock | 44.37 | 44.37 | 44.37 | 44.37 | 400.0 |
| 2018-01-24 06:47:00 | AAPL | Stock | 44.3525 | 44.3525 | 44.3375 | 44.3375 | 4000.0 |
| 2018-01-24 06:48:00 | AAPL | Stock | 44.3275 | 44.3275 | 44.3275 | 44.3275 | 1548.0 |
| 2018-01-24 07:00:00 | AAPL | Stock | 44.325 | 44.35 | 44.325 | 44.3275 | 4656.0 |
| 2018-01-24 07:04:00 | AAPL | Stock | 44.345 | 44.35 | 44.3425 | 44.35 | 5724.0 |
| 2018-01-24 07:05:00 | AAPL | Stock | 44.35 | 44.35 | 44.35 | 44.35 | 3340.0 |
| 2018-01-24 07:07:00 | AAPL | Stock | 44.3525 | 44.3525 | 44.35 | 44.3525 | 1600.0 |
| 2018-01-24 07:08:00 | AAPL | Stock | 44.345 | 44.3525 | 44.345 | 44.3525 | 800.0 |
| 2018-01-24 07:11:00 | AAPL | Stock | 44.3525 | 44.3525 | 44.3525 | 44.3525 | 2000.0 |
| 2018-01-24 07:13:00 | AAPL | Stock | 44.3675 | 44.3675 | 44.3675 | 44.3675 | 440.0 |
| 2018-01-24 07:14:00 | AAPL | Stock | 44.35 | 44.35 | 44.35 | 44.35 | 400.0 |
| 2018-01-24 07:15:00 | AAPL | Stock | 44.3625 | 44.3625 | 44.3625 | 44.3625 | 3992.0 |
| 2018-01-24 07:17:00 | AAPL | Stock | 44.3675 | 44.3675 | 44.3525 | 44.3525 | 2000.0 |
| 2018-01-24 07:18:00 | AAPL | Stock | 44.3675 | 44.3675 | 44.3675 | 44.3675 | 4000.0 |
| 2018-01-24 07:19:00 | AAPL | Stock | 44.3675 | 44.375 | 44.3675 | 44.375 | 4000.0 |
| 2018-01-24 07:20:00 | AAPL | Stock | 44.3625 | 44.4 | 44.3625 | 44.375 | 7000.0 |
| 2018-01-24 07:21:00 | AAPL | Stock | 44.375 | 44.375 | 44.375 | 44.375 | 2000.0 |
| 2018-01-24 07:22:00 | AAPL | Stock | 44.3925 | 44.3975 | 44.3925 | 44.3975 | 2000.0 |
| 2018-01-24 07:24:00 | AAPL | Stock | 44.4 | 44.4 | 44.4 | 44.4 | 800.0 |
| 2018-01-24 07:25:00 | AAPL | Stock | 44.4 | 44.4 | 44.375 | 44.375 | 4592.0 |
| 2018-01-24 07:26:00 | AAPL | Stock | 44.375 | 44.375 | 44.35 | 44.35 | 23760.0 |
| 2018-01-24 07:28:00 | AAPL | Stock | 44.3625 | 44.375 | 44.325 | 44.325 | 12404.0 |
| 2018-01-24 07:29:00 | AAPL | Stock | 44.33 | 44.33 | 44.3175 | 44.3175 | 4000.0 |
| 2018-01-24 07:35:00 | AAPL | Stock | 44.3275 | 44.345 | 44.325 | 44.345 | 6684.0 |
| 2018-01-24 07:36:00 | AAPL | Stock | 44.325 | 44.34 | 44.32 | 44.34 | 4800.0 |
| 2018-01-24 07:37:00 | AAPL | Stock | 44.3325 | 44.34 | 44.33 | 44.34 | 2400.0 |
| 2018-01-24 07:38:00 | AAPL | Stock | 44.34 | 44.34 | 44.34 | 44.34 | 656.0 |
| 2018-01-24 07:40:00 | AAPL | Stock | 44.345 | 44.345 | 44.33 | 44.3325 | 6240.0 |
| 2018-01-24 07:41:00 | AAPL | Stock | 44.3375 | 44.3375 | 44.325 | 44.3375 | 6560.0 |
| 2018-01-24 07:42:00 | AAPL | Stock | 44.3375 | 44.3375 | 44.325 | 44.325 | 6800.0 |
| 2018-01-24 07:43:00 | AAPL | Stock | 44.325 | 44.325 | 44.325 | 44.325 | 4800.0 |
| 2018-01-24 07:44:00 | AAPL | Stock | 44.32 | 44.325 | 44.32 | 44.325 | 2396.0 |
| 2018-01-24 07:45:00 | AAPL | Stock | 44.3175 | 44.325 | 44.3175 | 44.3175 | 1800.0 |
| 2018-01-24 07:46:00 | AAPL | Stock | 44.325 | 44.3375 | 44.325 | 44.325 | 8688.0 |
| 2018-01-24 07:48:00 | AAPL | Stock | 44.325 | 44.335 | 44.325 | 44.335 | 2220.0 |
> showing 50 of 1,120,951 rows — these rows as CSV