PREVIEW / stock_5min / 2018-09-17
file: by_date/stock_5min/2018/2018-09-17.parquet size: 5.6 MB rows: 358,221 symbols: 2,781
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-09-17 04:00:00 | AAPL | Stock | 55.975 | 55.975 | 55.9025 | 55.95 | 3200.0 |
| 2018-09-17 04:05:00 | AAPL | Stock | 55.8875 | 55.8875 | 55.8875 | 55.8875 | 8152.0 |
| 2018-09-17 04:10:00 | AAPL | Stock | 55.9425 | 55.9425 | 55.9425 | 55.9425 | 400.0 |
| 2018-09-17 04:15:00 | AAPL | Stock | 55.9275 | 55.95 | 55.9275 | 55.95 | 2400.0 |
| 2018-09-17 04:25:00 | AAPL | Stock | 55.8875 | 55.8875 | 55.8875 | 55.8875 | 400.0 |
| 2018-09-17 04:40:00 | AAPL | Stock | 55.8875 | 55.9125 | 55.8875 | 55.9125 | 1200.0 |
| 2018-09-17 04:45:00 | AAPL | Stock | 55.91 | 55.91 | 55.91 | 55.91 | 400.0 |
| 2018-09-17 05:00:00 | AAPL | Stock | 55.945 | 55.95 | 55.945 | 55.95 | 3720.0 |
| 2018-09-17 05:20:00 | AAPL | Stock | 55.9375 | 55.9375 | 55.9375 | 55.9375 | 1200.0 |
| 2018-09-17 05:25:00 | AAPL | Stock | 55.9325 | 55.9325 | 55.9325 | 55.9325 | 752.0 |
| 2018-09-17 05:35:00 | AAPL | Stock | 55.925 | 55.925 | 55.925 | 55.925 | 400.0 |
| 2018-09-17 05:55:00 | AAPL | Stock | 55.825 | 55.875 | 55.8 | 55.825 | 13116.0 |
| 2018-09-17 06:00:00 | AAPL | Stock | 55.825 | 55.825 | 55.7525 | 55.7525 | 2556.0 |
| 2018-09-17 06:05:00 | AAPL | Stock | 55.775 | 55.775 | 55.75 | 55.75 | 800.0 |
| 2018-09-17 06:10:00 | AAPL | Stock | 55.75 | 55.775 | 55.75 | 55.775 | 4244.0 |
| 2018-09-17 06:15:00 | AAPL | Stock | 55.775 | 55.7875 | 55.75 | 55.75 | 4380.0 |
| 2018-09-17 06:20:00 | AAPL | Stock | 55.725 | 55.725 | 55.6525 | 55.6525 | 3980.0 |
| 2018-09-17 06:25:00 | AAPL | Stock | 55.6975 | 55.6975 | 55.6675 | 55.6675 | 4000.0 |
| 2018-09-17 06:30:00 | AAPL | Stock | 55.7 | 55.7075 | 55.6625 | 55.67 | 2944.0 |
| 2018-09-17 06:40:00 | AAPL | Stock | 55.7 | 55.7125 | 55.575 | 55.575 | 8596.0 |
| 2018-09-17 06:45:00 | AAPL | Stock | 55.6375 | 55.695 | 55.62 | 55.695 | 11052.0 |
| 2018-09-17 06:50:00 | AAPL | Stock | 55.675 | 55.675 | 55.675 | 55.675 | 400.0 |
| 2018-09-17 07:00:00 | AAPL | Stock | 55.695 | 55.72 | 55.625 | 55.6875 | 36612.0 |
| 2018-09-17 07:05:00 | AAPL | Stock | 55.6625 | 55.69 | 55.6275 | 55.69 | 6996.0 |
| 2018-09-17 07:10:00 | AAPL | Stock | 55.6375 | 55.6375 | 55.6325 | 55.6325 | 1968.0 |
| 2018-09-17 07:15:00 | AAPL | Stock | 55.6475 | 55.6475 | 55.6475 | 55.6475 | 1000.0 |
| 2018-09-17 07:20:00 | AAPL | Stock | 55.65 | 55.6575 | 55.6325 | 55.6325 | 12604.0 |
| 2018-09-17 07:25:00 | AAPL | Stock | 55.635 | 55.635 | 55.3275 | 55.5 | 101212.0 |
| 2018-09-17 07:30:00 | AAPL | Stock | 55.5 | 55.5375 | 55.43 | 55.5125 | 62456.0 |
| 2018-09-17 07:35:00 | AAPL | Stock | 55.5125 | 55.595 | 55.5125 | 55.595 | 41612.0 |
| 2018-09-17 07:40:00 | AAPL | Stock | 55.535 | 55.5825 | 55.5325 | 55.55 | 12064.0 |
| 2018-09-17 07:45:00 | AAPL | Stock | 55.55 | 55.575 | 55.525 | 55.53 | 25256.0 |
| 2018-09-17 07:50:00 | AAPL | Stock | 55.5075 | 55.5225 | 55.5 | 55.5225 | 37012.0 |
| 2018-09-17 07:55:00 | AAPL | Stock | 55.5075 | 55.5075 | 55.45 | 55.4675 | 45960.0 |
| 2018-09-17 08:00:00 | AAPL | Stock | 55.675 | 55.7125 | 55.4625 | 55.525 | 42948.0 |
| 2018-09-17 08:05:00 | AAPL | Stock | 55.5125 | 55.675 | 55.5125 | 55.65 | 52704.0 |
| 2018-09-17 08:10:00 | AAPL | Stock | 55.63 | 55.63 | 55.5575 | 55.5825 | 52784.0 |
| 2018-09-17 08:15:00 | AAPL | Stock | 55.622 | 55.622 | 55.5625 | 55.5625 | 11144.0 |
| 2018-09-17 08:20:00 | AAPL | Stock | 55.555 | 55.5575 | 55.54 | 55.5575 | 10796.0 |
| 2018-09-17 08:25:00 | AAPL | Stock | 55.545 | 55.545 | 55.3875 | 55.405 | 52920.0 |
| 2018-09-17 08:30:00 | AAPL | Stock | 55.4075 | 55.4725 | 55.405 | 55.47 | 49620.0 |
| 2018-09-17 08:35:00 | AAPL | Stock | 55.46 | 55.46 | 55.4375 | 55.4475 | 46292.0 |
| 2018-09-17 08:40:00 | AAPL | Stock | 55.4475 | 55.4625 | 55.425 | 55.46 | 14200.0 |
| 2018-09-17 08:45:00 | AAPL | Stock | 55.455 | 55.4575 | 55.39 | 55.4125 | 57428.0 |
| 2018-09-17 08:50:00 | AAPL | Stock | 55.4225 | 55.4625 | 55.4225 | 55.4475 | 15620.0 |
| 2018-09-17 08:55:00 | AAPL | Stock | 55.4475 | 55.485 | 55.43 | 55.485 | 37340.0 |
| 2018-09-17 09:00:00 | AAPL | Stock | 55.475 | 55.535 | 55.475 | 55.4975 | 55324.0 |
| 2018-09-17 09:05:00 | AAPL | Stock | 55.4975 | 55.5325 | 55.4825 | 55.5075 | 20836.0 |
| 2018-09-17 09:10:00 | AAPL | Stock | 55.53 | 55.575 | 55.51 | 55.55 | 19852.0 |
| 2018-09-17 09:15:00 | AAPL | Stock | 55.5525 | 55.575 | 55.535 | 55.5475 | 18972.0 |
> showing 50 of 358,221 rows — these rows as CSV