PREVIEW / stock_5min / 2018-02-15
file: by_date/stock_5min/2018/2018-02-15.parquet size: 5.6 MB rows: 359,945 symbols: 2,884
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-02-15 04:00:00 | AAPL | Stock | 42.4 | 42.4 | 42.3975 | 42.4 | 6000.0 |
| 2018-02-15 04:05:00 | AAPL | Stock | 42.39 | 42.39 | 42.38 | 42.38 | 4400.0 |
| 2018-02-15 04:10:00 | AAPL | Stock | 42.425 | 42.425 | 42.425 | 42.425 | 1400.0 |
| 2018-02-15 04:15:00 | AAPL | Stock | 42.4075 | 42.4075 | 42.4025 | 42.4025 | 2092.0 |
| 2018-02-15 04:20:00 | AAPL | Stock | 42.4025 | 42.495 | 42.3925 | 42.495 | 8376.0 |
| 2018-02-15 04:35:00 | AAPL | Stock | 42.49 | 42.49 | 42.49 | 42.49 | 800.0 |
| 2018-02-15 04:40:00 | AAPL | Stock | 42.49 | 42.49 | 42.45 | 42.475 | 8400.0 |
| 2018-02-15 04:45:00 | AAPL | Stock | 42.4925 | 42.4925 | 42.49 | 42.49 | 4416.0 |
| 2018-02-15 04:55:00 | AAPL | Stock | 42.465 | 42.4875 | 42.45 | 42.4875 | 7772.0 |
| 2018-02-15 05:00:00 | AAPL | Stock | 42.4875 | 42.49 | 42.4875 | 42.4875 | 6640.0 |
| 2018-02-15 05:05:00 | AAPL | Stock | 42.4675 | 42.4675 | 42.4675 | 42.4675 | 10264.0 |
| 2018-02-15 05:10:00 | AAPL | Stock | 42.45 | 42.45 | 42.4325 | 42.4325 | 16920.0 |
| 2018-02-15 05:15:00 | AAPL | Stock | 42.4275 | 42.475 | 42.4275 | 42.4475 | 3868.0 |
| 2018-02-15 05:20:00 | AAPL | Stock | 42.4475 | 42.4475 | 42.4475 | 42.4475 | 4404.0 |
| 2018-02-15 05:25:00 | AAPL | Stock | 42.415 | 42.4475 | 42.415 | 42.4475 | 800.0 |
| 2018-02-15 05:30:00 | AAPL | Stock | 42.435 | 42.435 | 42.4325 | 42.435 | 13800.0 |
| 2018-02-15 05:35:00 | AAPL | Stock | 42.445 | 42.45 | 42.445 | 42.45 | 3040.0 |
| 2018-02-15 05:45:00 | AAPL | Stock | 42.4425 | 42.4425 | 42.4425 | 42.4425 | 10832.0 |
| 2018-02-15 05:50:00 | AAPL | Stock | 42.435 | 42.435 | 42.405 | 42.425 | 9160.0 |
| 2018-02-15 05:55:00 | AAPL | Stock | 42.42 | 42.425 | 42.3825 | 42.3825 | 17148.0 |
| 2018-02-15 06:00:00 | AAPL | Stock | 42.3875 | 42.3875 | 42.3875 | 42.3875 | 2400.0 |
| 2018-02-15 06:05:00 | AAPL | Stock | 42.3825 | 42.3825 | 42.3125 | 42.325 | 22008.0 |
| 2018-02-15 06:10:00 | AAPL | Stock | 42.325 | 42.35 | 42.3 | 42.35 | 9864.0 |
| 2018-02-15 06:15:00 | AAPL | Stock | 42.35 | 42.35 | 42.3 | 42.305 | 2800.0 |
| 2018-02-15 06:20:00 | AAPL | Stock | 42.3 | 42.3 | 42.25 | 42.3 | 11140.0 |
| 2018-02-15 06:25:00 | AAPL | Stock | 42.3 | 42.3925 | 42.2875 | 42.375 | 18820.0 |
| 2018-02-15 06:30:00 | AAPL | Stock | 42.325 | 42.325 | 42.3 | 42.3 | 2880.0 |
| 2018-02-15 06:35:00 | AAPL | Stock | 42.325 | 42.37 | 42.325 | 42.37 | 3244.0 |
| 2018-02-15 06:40:00 | AAPL | Stock | 42.33 | 42.3425 | 42.33 | 42.3425 | 6000.0 |
| 2018-02-15 06:45:00 | AAPL | Stock | 42.36 | 42.3675 | 42.3025 | 42.3025 | 16064.0 |
| 2018-02-15 06:50:00 | AAPL | Stock | 42.275 | 42.375 | 42.265 | 42.375 | 18804.0 |
| 2018-02-15 06:55:00 | AAPL | Stock | 42.355 | 42.375 | 42.3475 | 42.375 | 38088.0 |
| 2018-02-15 07:00:00 | AAPL | Stock | 42.3575 | 42.4175 | 42.3075 | 42.4175 | 52128.0 |
| 2018-02-15 07:05:00 | AAPL | Stock | 42.4225 | 42.455 | 42.4225 | 42.425 | 62340.0 |
| 2018-02-15 07:10:00 | AAPL | Stock | 42.4225 | 42.475 | 42.4125 | 42.475 | 25348.0 |
| 2018-02-15 07:15:00 | AAPL | Stock | 42.455 | 42.47 | 42.4425 | 42.4625 | 23128.0 |
| 2018-02-15 07:20:00 | AAPL | Stock | 42.45 | 42.45 | 42.3925 | 42.395 | 57548.0 |
| 2018-02-15 07:25:00 | AAPL | Stock | 42.3925 | 42.4125 | 42.38 | 42.38 | 30748.0 |
| 2018-02-15 07:30:00 | AAPL | Stock | 42.3825 | 42.3825 | 42.3175 | 42.3275 | 82232.0 |
| 2018-02-15 07:35:00 | AAPL | Stock | 42.35 | 42.35 | 42.2775 | 42.35 | 49096.0 |
| 2018-02-15 07:40:00 | AAPL | Stock | 42.35 | 42.3625 | 42.275 | 42.275 | 26632.0 |
| 2018-02-15 07:45:00 | AAPL | Stock | 42.2975 | 42.3125 | 42.2675 | 42.285 | 66544.0 |
| 2018-02-15 07:50:00 | AAPL | Stock | 42.275 | 42.3125 | 42.245 | 42.3025 | 88580.0 |
| 2018-02-15 07:55:00 | AAPL | Stock | 42.3125 | 42.325 | 42.3 | 42.3 | 21616.0 |
| 2018-02-15 08:00:00 | AAPL | Stock | 42.315 | 42.47 | 42.245 | 42.3325 | 194548.0 |
| 2018-02-15 08:05:00 | AAPL | Stock | 42.3275 | 42.3325 | 42.305 | 42.325 | 19884.0 |
| 2018-02-15 08:10:00 | AAPL | Stock | 42.3275 | 42.34 | 42.2775 | 42.2925 | 103484.0 |
| 2018-02-15 08:15:00 | AAPL | Stock | 42.29 | 42.3275 | 42.2875 | 42.3225 | 62500.0 |
| 2018-02-15 08:20:00 | AAPL | Stock | 42.315 | 42.325 | 42.2775 | 42.325 | 110732.0 |
| 2018-02-15 08:25:00 | AAPL | Stock | 42.325 | 42.325 | 42.295 | 42.305 | 45004.0 |
> showing 50 of 359,945 rows — these rows as CSV