PREVIEW / stock_5min / 2018-12-04
file: by_date/stock_5min/2018/2018-12-04.parquet size: 5.9 MB rows: 373,487 symbols: 2,754
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-04 04:00:00 | AAPL | Stock | 45.4625 | 45.535 | 45.46 | 45.535 | 4016.0 |
| 2018-12-04 04:10:00 | AAPL | Stock | 45.4975 | 45.4975 | 45.4975 | 45.4975 | 2872.0 |
| 2018-12-04 04:15:00 | AAPL | Stock | 45.4825 | 45.4925 | 45.45 | 45.45 | 9660.0 |
| 2018-12-04 04:20:00 | AAPL | Stock | 45.39 | 45.39 | 45.39 | 45.39 | 400.0 |
| 2018-12-04 04:25:00 | AAPL | Stock | 45.4375 | 45.4375 | 45.4375 | 45.4375 | 8000.0 |
| 2018-12-04 04:30:00 | AAPL | Stock | 45.43 | 45.4375 | 45.43 | 45.435 | 3600.0 |
| 2018-12-04 04:40:00 | AAPL | Stock | 45.375 | 45.375 | 45.375 | 45.375 | 400.0 |
| 2018-12-04 04:50:00 | AAPL | Stock | 45.27 | 45.2775 | 45.27 | 45.2775 | 2076.0 |
| 2018-12-04 04:55:00 | AAPL | Stock | 45.2775 | 45.2775 | 45.2775 | 45.2775 | 400.0 |
| 2018-12-04 05:05:00 | AAPL | Stock | 45.3375 | 45.3375 | 45.3375 | 45.3375 | 400.0 |
| 2018-12-04 05:10:00 | AAPL | Stock | 45.32 | 45.375 | 45.32 | 45.375 | 1600.0 |
| 2018-12-04 05:25:00 | AAPL | Stock | 45.405 | 45.405 | 45.405 | 45.405 | 856.0 |
| 2018-12-04 05:30:00 | AAPL | Stock | 45.4375 | 45.4375 | 45.4375 | 45.4375 | 7036.0 |
| 2018-12-04 05:35:00 | AAPL | Stock | 45.45 | 45.45 | 45.45 | 45.45 | 692.0 |
| 2018-12-04 05:40:00 | AAPL | Stock | 45.495 | 45.5 | 45.495 | 45.5 | 2000.0 |
| 2018-12-04 05:45:00 | AAPL | Stock | 45.4975 | 45.4975 | 45.4975 | 45.4975 | 400.0 |
| 2018-12-04 05:50:00 | AAPL | Stock | 45.4975 | 45.4975 | 45.4975 | 45.4975 | 400.0 |
| 2018-12-04 05:55:00 | AAPL | Stock | 45.485 | 45.4875 | 45.485 | 45.4875 | 800.0 |
| 2018-12-04 06:00:00 | AAPL | Stock | 45.4575 | 45.4575 | 45.4575 | 45.4575 | 1200.0 |
| 2018-12-04 06:05:00 | AAPL | Stock | 45.535 | 45.57 | 45.535 | 45.57 | 800.0 |
| 2018-12-04 06:20:00 | AAPL | Stock | 45.55 | 45.55 | 45.4525 | 45.4525 | 13800.0 |
| 2018-12-04 06:25:00 | AAPL | Stock | 45.475 | 45.475 | 45.475 | 45.475 | 400.0 |
| 2018-12-04 06:30:00 | AAPL | Stock | 45.4375 | 45.455 | 45.4375 | 45.455 | 2400.0 |
| 2018-12-04 06:35:00 | AAPL | Stock | 45.475 | 45.475 | 45.475 | 45.475 | 3600.0 |
| 2018-12-04 06:40:00 | AAPL | Stock | 45.4375 | 45.475 | 45.4375 | 45.4525 | 1908.0 |
| 2018-12-04 06:45:00 | AAPL | Stock | 45.495 | 45.4975 | 45.495 | 45.4975 | 7408.0 |
| 2018-12-04 06:50:00 | AAPL | Stock | 45.4625 | 45.4625 | 45.4425 | 45.4425 | 2212.0 |
| 2018-12-04 06:55:00 | AAPL | Stock | 45.425 | 45.425 | 45.4125 | 45.4125 | 2600.0 |
| 2018-12-04 07:00:00 | AAPL | Stock | 45.38 | 45.435 | 45.3275 | 45.4 | 27732.0 |
| 2018-12-04 07:05:00 | AAPL | Stock | 45.4 | 45.4 | 45.375 | 45.3875 | 32164.0 |
| 2018-12-04 07:10:00 | AAPL | Stock | 45.405 | 45.4375 | 45.3125 | 45.3425 | 18492.0 |
| 2018-12-04 07:15:00 | AAPL | Stock | 45.345 | 45.345 | 45.2625 | 45.3 | 56084.0 |
| 2018-12-04 07:20:00 | AAPL | Stock | 45.2975 | 45.335 | 45.2975 | 45.3 | 18132.0 |
| 2018-12-04 07:25:00 | AAPL | Stock | 45.315 | 45.3325 | 45.305 | 45.305 | 7080.0 |
| 2018-12-04 07:30:00 | AAPL | Stock | 45.3225 | 45.34 | 45.2875 | 45.3125 | 21692.0 |
| 2018-12-04 07:35:00 | AAPL | Stock | 45.32 | 45.325 | 45.2875 | 45.305 | 39792.0 |
| 2018-12-04 07:40:00 | AAPL | Stock | 45.31 | 45.3375 | 45.2975 | 45.325 | 32572.0 |
| 2018-12-04 07:45:00 | AAPL | Stock | 45.335 | 45.3425 | 45.325 | 45.3375 | 26864.0 |
| 2018-12-04 07:50:00 | AAPL | Stock | 45.3325 | 45.3375 | 45.3175 | 45.3175 | 15676.0 |
| 2018-12-04 07:55:00 | AAPL | Stock | 45.315 | 45.325 | 45.305 | 45.325 | 13480.0 |
| 2018-12-04 08:00:00 | AAPL | Stock | 45.3875 | 45.4425 | 45.2625 | 45.2775 | 172552.0 |
| 2018-12-04 08:05:00 | AAPL | Stock | 45.275 | 45.2875 | 45.1875 | 45.215 | 93356.0 |
| 2018-12-04 08:10:00 | AAPL | Stock | 45.2025 | 45.2325 | 45.175 | 45.22 | 102552.0 |
| 2018-12-04 08:15:00 | AAPL | Stock | 45.2275 | 45.3425 | 45.2 | 45.3425 | 51928.0 |
| 2018-12-04 08:20:00 | AAPL | Stock | 45.325 | 45.35 | 45.3025 | 45.345 | 107252.0 |
| 2018-12-04 08:25:00 | AAPL | Stock | 45.3475 | 45.35 | 45.25 | 45.29 | 108740.0 |
| 2018-12-04 08:30:00 | AAPL | Stock | 45.275 | 45.325 | 45.23 | 45.23 | 38776.0 |
| 2018-12-04 08:35:00 | AAPL | Stock | 45.2275 | 45.275 | 45.22 | 45.275 | 29932.0 |
| 2018-12-04 08:40:00 | AAPL | Stock | 45.275 | 45.32 | 45.275 | 45.275 | 24520.0 |
| 2018-12-04 08:45:00 | AAPL | Stock | 45.2875 | 45.3125 | 45.2775 | 45.28 | 43008.0 |
> showing 50 of 373,487 rows — these rows as CSV