PREVIEW / stock_5min / 2017-04-19
file: by_date/stock_5min/2017/2017-04-19.parquet size: 5.4 MB rows: 352,987 symbols: 3,060
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-19 04:50:00 | AAPL | Stock | 35.35 | 35.35 | 35.35 | 35.35 | 608.0 |
| 2017-04-19 04:55:00 | AAPL | Stock | 35.375 | 35.38 | 35.375 | 35.38 | 2696.0 |
| 2017-04-19 05:00:00 | AAPL | Stock | 35.35 | 35.35 | 35.35 | 35.35 | 560.0 |
| 2017-04-19 06:45:00 | AAPL | Stock | 35.4 | 35.4 | 35.4 | 35.4 | 400.0 |
| 2017-04-19 06:55:00 | AAPL | Stock | 35.375 | 35.4 | 35.375 | 35.4 | 1460.0 |
| 2017-04-19 07:10:00 | AAPL | Stock | 35.3875 | 35.3875 | 35.3875 | 35.3875 | 1160.0 |
| 2017-04-19 07:20:00 | AAPL | Stock | 35.3875 | 35.3875 | 35.3875 | 35.3875 | 4000.0 |
| 2017-04-19 07:30:00 | AAPL | Stock | 35.3975 | 35.4 | 35.3975 | 35.4 | 2600.0 |
| 2017-04-19 07:40:00 | AAPL | Stock | 35.395 | 35.395 | 35.395 | 35.395 | 2000.0 |
| 2017-04-19 07:45:00 | AAPL | Stock | 35.39 | 35.39 | 35.39 | 35.39 | 400.0 |
| 2017-04-19 07:50:00 | AAPL | Stock | 35.4 | 35.405 | 35.4 | 35.4 | 6200.0 |
| 2017-04-19 08:00:00 | AAPL | Stock | 35.395 | 35.4125 | 35.395 | 35.4 | 3140.0 |
| 2017-04-19 08:05:00 | AAPL | Stock | 35.4075 | 35.4075 | 35.4075 | 35.4075 | 1200.0 |
| 2017-04-19 08:10:00 | AAPL | Stock | 35.41 | 35.4375 | 35.41 | 35.4375 | 19876.0 |
| 2017-04-19 08:15:00 | AAPL | Stock | 35.435 | 35.4475 | 35.435 | 35.4475 | 5200.0 |
| 2017-04-19 08:20:00 | AAPL | Stock | 35.4475 | 35.4675 | 35.4475 | 35.4675 | 12680.0 |
| 2017-04-19 08:25:00 | AAPL | Stock | 35.4825 | 35.4875 | 35.48 | 35.485 | 17976.0 |
| 2017-04-19 08:30:00 | AAPL | Stock | 35.485 | 35.4875 | 35.455 | 35.4875 | 29428.0 |
| 2017-04-19 08:35:00 | AAPL | Stock | 35.48 | 35.4875 | 35.475 | 35.475 | 13708.0 |
| 2017-04-19 08:40:00 | AAPL | Stock | 35.4775 | 35.485 | 35.475 | 35.475 | 21152.0 |
| 2017-04-19 08:45:00 | AAPL | Stock | 35.475 | 35.475 | 35.46 | 35.475 | 40192.0 |
| 2017-04-19 08:50:00 | AAPL | Stock | 35.4725 | 35.4725 | 35.4725 | 35.4725 | 400.0 |
| 2017-04-19 08:55:00 | AAPL | Stock | 35.4675 | 35.4725 | 35.4625 | 35.4725 | 5232.0 |
| 2017-04-19 09:00:00 | AAPL | Stock | 35.4725 | 35.4725 | 35.4725 | 35.4725 | 4000.0 |
| 2017-04-19 09:05:00 | AAPL | Stock | 35.47 | 35.4725 | 35.46 | 35.4625 | 3000.0 |
| 2017-04-19 09:10:00 | AAPL | Stock | 35.4625 | 35.4625 | 35.455 | 35.455 | 3600.0 |
| 2017-04-19 09:15:00 | AAPL | Stock | 35.4625 | 35.4625 | 35.45 | 35.45 | 8744.0 |
| 2017-04-19 09:20:00 | AAPL | Stock | 35.45 | 35.45 | 35.435 | 35.435 | 16892.0 |
| 2017-04-19 09:25:00 | AAPL | Stock | 35.445 | 35.4725 | 35.435 | 35.455 | 60916.0 |
| 2017-04-19 09:30:00 | AAPL | Stock | 35.47 | 35.5 | 35.3875 | 35.4075 | 3397864.0 |
| 2017-04-19 09:35:00 | AAPL | Stock | 35.41 | 35.44 | 35.38 | 35.44 | 1241956.0 |
| 2017-04-19 09:40:00 | AAPL | Stock | 35.44 | 35.445 | 35.3925 | 35.4125 | 1107392.0 |
| 2017-04-19 09:45:00 | AAPL | Stock | 35.4112 | 35.4425 | 35.4018 | 35.425 | 961204.0 |
| 2017-04-19 09:50:00 | AAPL | Stock | 35.4238 | 35.4425 | 35.4238 | 35.435 | 941848.0 |
| 2017-04-19 09:55:00 | AAPL | Stock | 35.4375 | 35.485 | 35.436 | 35.45 | 1698248.0 |
| 2017-04-19 10:00:00 | AAPL | Stock | 35.45 | 35.475 | 35.4375 | 35.4375 | 867960.0 |
| 2017-04-19 10:05:00 | AAPL | Stock | 35.44 | 35.4425 | 35.4175 | 35.4348 | 640456.0 |
| 2017-04-19 10:10:00 | AAPL | Stock | 35.435 | 35.45 | 35.4275 | 35.4323 | 677536.0 |
| 2017-04-19 10:15:00 | AAPL | Stock | 35.4308 | 35.435 | 35.415 | 35.419 | 336504.0 |
| 2017-04-19 10:20:00 | AAPL | Stock | 35.4175 | 35.435 | 35.4125 | 35.43 | 622936.0 |
| 2017-04-19 10:25:00 | AAPL | Stock | 35.43 | 35.43 | 35.4 | 35.4062 | 524672.0 |
| 2017-04-19 10:30:00 | AAPL | Stock | 35.4075 | 35.42 | 35.3962 | 35.4065 | 538964.0 |
| 2017-04-19 10:35:00 | AAPL | Stock | 35.4075 | 35.41 | 35.3915 | 35.4025 | 897976.0 |
| 2017-04-19 10:40:00 | AAPL | Stock | 35.4025 | 35.425 | 35.39 | 35.4238 | 684412.0 |
| 2017-04-19 10:45:00 | AAPL | Stock | 35.425 | 35.425 | 35.39 | 35.395 | 505520.0 |
| 2017-04-19 10:50:00 | AAPL | Stock | 35.395 | 35.4 | 35.38 | 35.4 | 660508.0 |
| 2017-04-19 10:55:00 | AAPL | Stock | 35.3975 | 35.4325 | 35.3925 | 35.4125 | 454248.0 |
| 2017-04-19 11:00:00 | AAPL | Stock | 35.4125 | 35.4448 | 35.4088 | 35.4385 | 453404.0 |
| 2017-04-19 11:05:00 | AAPL | Stock | 35.4375 | 35.4475 | 35.435 | 35.4475 | 471296.0 |
| 2017-04-19 11:10:00 | AAPL | Stock | 35.4485 | 35.4575 | 35.4312 | 35.4485 | 612968.0 |
> showing 50 of 352,987 rows — these rows as CSV