PREVIEW / stock_5min / 2018-11-05
file: by_date/stock_5min/2018/2018-11-05.parquet size: 5.6 MB rows: 355,398 symbols: 2,761
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-11-05 04:00:00 | AAPL | Stock | 51.625 | 51.625 | 51.62 | 51.62 | 9988.0 |
| 2018-11-05 04:05:00 | AAPL | Stock | 51.575 | 51.6225 | 51.55 | 51.6225 | 8316.0 |
| 2018-11-05 04:15:00 | AAPL | Stock | 51.525 | 51.525 | 51.525 | 51.525 | 1812.0 |
| 2018-11-05 04:20:00 | AAPL | Stock | 51.5375 | 51.5375 | 51.5375 | 51.5375 | 1200.0 |
| 2018-11-05 04:25:00 | AAPL | Stock | 51.525 | 51.525 | 51.425 | 51.425 | 12984.0 |
| 2018-11-05 04:30:00 | AAPL | Stock | 51.435 | 51.435 | 51.4275 | 51.4275 | 1952.0 |
| 2018-11-05 04:35:00 | AAPL | Stock | 51.4325 | 51.49 | 51.4325 | 51.4725 | 3432.0 |
| 2018-11-05 04:40:00 | AAPL | Stock | 51.4725 | 51.4725 | 51.4725 | 51.4725 | 2004.0 |
| 2018-11-05 04:45:00 | AAPL | Stock | 51.4625 | 51.4625 | 51.4625 | 51.4625 | 4784.0 |
| 2018-11-05 05:00:00 | AAPL | Stock | 51.5775 | 51.615 | 51.5775 | 51.5775 | 2460.0 |
| 2018-11-05 05:15:00 | AAPL | Stock | 51.57 | 51.57 | 51.5 | 51.5 | 4512.0 |
| 2018-11-05 05:20:00 | AAPL | Stock | 51.5 | 51.57 | 51.5 | 51.57 | 1200.0 |
| 2018-11-05 05:35:00 | AAPL | Stock | 51.5525 | 51.56 | 51.5025 | 51.505 | 7120.0 |
| 2018-11-05 05:40:00 | AAPL | Stock | 51.5025 | 51.5025 | 51.5025 | 51.5025 | 4768.0 |
| 2018-11-05 05:45:00 | AAPL | Stock | 51.505 | 51.535 | 51.5 | 51.5 | 9572.0 |
| 2018-11-05 05:50:00 | AAPL | Stock | 51.525 | 51.5375 | 51.425 | 51.5175 | 27200.0 |
| 2018-11-05 05:55:00 | AAPL | Stock | 51.5175 | 51.55 | 51.5175 | 51.55 | 6400.0 |
| 2018-11-05 06:00:00 | AAPL | Stock | 51.5375 | 51.565 | 51.5375 | 51.565 | 1472.0 |
| 2018-11-05 06:05:00 | AAPL | Stock | 51.575 | 51.575 | 51.5 | 51.5 | 9096.0 |
| 2018-11-05 06:10:00 | AAPL | Stock | 51.4975 | 51.5 | 51.465 | 51.5 | 8280.0 |
| 2018-11-05 06:15:00 | AAPL | Stock | 51.475 | 51.5 | 51.465 | 51.5 | 6080.0 |
| 2018-11-05 06:20:00 | AAPL | Stock | 51.455 | 51.4875 | 51.45 | 51.4875 | 5288.0 |
| 2018-11-05 06:25:00 | AAPL | Stock | 51.4875 | 51.545 | 51.4525 | 51.5 | 14200.0 |
| 2018-11-05 06:30:00 | AAPL | Stock | 51.455 | 51.455 | 51.375 | 51.375 | 13112.0 |
| 2018-11-05 06:35:00 | AAPL | Stock | 51.325 | 51.325 | 51.2875 | 51.29 | 5540.0 |
| 2018-11-05 06:40:00 | AAPL | Stock | 51.3125 | 51.35 | 51.3125 | 51.3425 | 4764.0 |
| 2018-11-05 06:45:00 | AAPL | Stock | 51.3425 | 51.4125 | 51.3275 | 51.38 | 9284.0 |
| 2018-11-05 06:50:00 | AAPL | Stock | 51.3775 | 51.45 | 51.3775 | 51.45 | 15124.0 |
| 2018-11-05 06:55:00 | AAPL | Stock | 51.425 | 51.4475 | 51.355 | 51.355 | 15556.0 |
| 2018-11-05 07:00:00 | AAPL | Stock | 51.32 | 51.5 | 51.32 | 51.45 | 83252.0 |
| 2018-11-05 07:05:00 | AAPL | Stock | 51.445 | 51.535 | 51.4375 | 51.5 | 40076.0 |
| 2018-11-05 07:10:00 | AAPL | Stock | 51.5 | 51.5 | 51.42 | 51.42 | 13976.0 |
| 2018-11-05 07:15:00 | AAPL | Stock | 51.4075 | 51.4375 | 51.375 | 51.3875 | 20864.0 |
| 2018-11-05 07:20:00 | AAPL | Stock | 51.3875 | 51.4 | 51.2875 | 51.2875 | 70408.0 |
| 2018-11-05 07:25:00 | AAPL | Stock | 51.3 | 51.3225 | 51.265 | 51.29 | 31484.0 |
| 2018-11-05 07:30:00 | AAPL | Stock | 51.3125 | 51.325 | 51.2575 | 51.2575 | 54044.0 |
| 2018-11-05 07:35:00 | AAPL | Stock | 51.2625 | 51.2625 | 51.1325 | 51.15 | 237728.0 |
| 2018-11-05 07:40:00 | AAPL | Stock | 51.14 | 51.1725 | 51.105 | 51.125 | 166228.0 |
| 2018-11-05 07:45:00 | AAPL | Stock | 51.125 | 51.1625 | 51.0375 | 51.0375 | 117148.0 |
| 2018-11-05 07:50:00 | AAPL | Stock | 51.025 | 51.0375 | 50.9975 | 51.02 | 209720.0 |
| 2018-11-05 07:55:00 | AAPL | Stock | 51.02 | 51.09 | 50.905 | 50.905 | 179012.0 |
| 2018-11-05 08:00:00 | AAPL | Stock | 51.04 | 51.4375 | 50.875 | 50.9125 | 377236.0 |
| 2018-11-05 08:05:00 | AAPL | Stock | 50.925 | 50.9925 | 50.9125 | 50.9475 | 154732.0 |
| 2018-11-05 08:10:00 | AAPL | Stock | 50.95 | 51.025 | 50.9275 | 50.9625 | 212896.0 |
| 2018-11-05 08:15:00 | AAPL | Stock | 50.9625 | 50.9725 | 50.9275 | 50.9625 | 102548.0 |
| 2018-11-05 08:20:00 | AAPL | Stock | 50.975 | 51.1025 | 50.975 | 51.075 | 91768.0 |
| 2018-11-05 08:25:00 | AAPL | Stock | 51.0725 | 51.0875 | 50.9475 | 50.975 | 90908.0 |
| 2018-11-05 08:30:00 | AAPL | Stock | 50.9725 | 51.025 | 50.94 | 50.975 | 55696.0 |
| 2018-11-05 08:35:00 | AAPL | Stock | 50.99 | 51.0525 | 50.95 | 51.0475 | 59244.0 |
| 2018-11-05 08:40:00 | AAPL | Stock | 51.05 | 51.0625 | 50.975 | 51.0225 | 52100.0 |
> showing 50 of 355,398 rows — these rows as CSV