PREVIEW / stock_5min / 2017-11-13
file: by_date/stock_5min/2017/2017-11-13.parquet size: 5.5 MB rows: 358,335 symbols: 2,956
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-11-13 04:00:00 | AAPL | Stock | 43.675 | 43.675 | 43.675 | 43.675 | 4000.0 |
| 2017-11-13 04:25:00 | AAPL | Stock | 43.69 | 43.69 | 43.69 | 43.69 | 400.0 |
| 2017-11-13 04:30:00 | AAPL | Stock | 43.675 | 43.675 | 43.675 | 43.675 | 400.0 |
| 2017-11-13 04:35:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 800.0 |
| 2017-11-13 04:45:00 | AAPL | Stock | 43.65 | 43.65 | 43.65 | 43.65 | 1200.0 |
| 2017-11-13 06:05:00 | AAPL | Stock | 43.625 | 43.625 | 43.625 | 43.625 | 800.0 |
| 2017-11-13 06:15:00 | AAPL | Stock | 43.5625 | 43.5625 | 43.5625 | 43.5625 | 400.0 |
| 2017-11-13 06:20:00 | AAPL | Stock | 43.5625 | 43.5625 | 43.5625 | 43.5625 | 400.0 |
| 2017-11-13 07:00:00 | AAPL | Stock | 43.5625 | 43.5725 | 43.5625 | 43.5725 | 844.0 |
| 2017-11-13 07:05:00 | AAPL | Stock | 43.5625 | 43.5825 | 43.5625 | 43.5625 | 6432.0 |
| 2017-11-13 07:10:00 | AAPL | Stock | 43.54 | 43.55 | 43.54 | 43.55 | 5092.0 |
| 2017-11-13 07:15:00 | AAPL | Stock | 43.54 | 43.55 | 43.54 | 43.55 | 7600.0 |
| 2017-11-13 07:20:00 | AAPL | Stock | 43.55 | 43.555 | 43.5475 | 43.555 | 6620.0 |
| 2017-11-13 07:25:00 | AAPL | Stock | 43.55 | 43.55 | 43.4925 | 43.5025 | 50808.0 |
| 2017-11-13 07:30:00 | AAPL | Stock | 43.4825 | 43.5075 | 43.4825 | 43.5075 | 5784.0 |
| 2017-11-13 07:35:00 | AAPL | Stock | 43.5 | 43.5125 | 43.485 | 43.5 | 35444.0 |
| 2017-11-13 07:40:00 | AAPL | Stock | 43.5 | 43.5125 | 43.5 | 43.5 | 9208.0 |
| 2017-11-13 07:45:00 | AAPL | Stock | 43.5125 | 43.515 | 43.5125 | 43.515 | 3400.0 |
| 2017-11-13 07:50:00 | AAPL | Stock | 43.5 | 43.5 | 43.4875 | 43.4875 | 9836.0 |
| 2017-11-13 07:55:00 | AAPL | Stock | 43.485 | 43.4875 | 43.475 | 43.475 | 5388.0 |
| 2017-11-13 08:00:00 | AAPL | Stock | 43.595 | 43.6025 | 43.475 | 43.5 | 97696.0 |
| 2017-11-13 08:05:00 | AAPL | Stock | 43.525 | 43.5325 | 43.5 | 43.5225 | 15956.0 |
| 2017-11-13 08:10:00 | AAPL | Stock | 43.5225 | 43.525 | 43.505 | 43.5225 | 17828.0 |
| 2017-11-13 08:15:00 | AAPL | Stock | 43.51 | 43.5225 | 43.5025 | 43.5225 | 2912.0 |
| 2017-11-13 08:20:00 | AAPL | Stock | 43.5025 | 43.525 | 43.5025 | 43.5025 | 3432.0 |
| 2017-11-13 08:25:00 | AAPL | Stock | 43.5125 | 43.52 | 43.47 | 43.4725 | 53436.0 |
| 2017-11-13 08:30:00 | AAPL | Stock | 43.475 | 43.4775 | 43.4675 | 43.4675 | 3184.0 |
| 2017-11-13 08:35:00 | AAPL | Stock | 43.47 | 43.475 | 43.45 | 43.46 | 25928.0 |
| 2017-11-13 08:40:00 | AAPL | Stock | 43.4575 | 43.4725 | 43.445 | 43.4725 | 33300.0 |
| 2017-11-13 08:45:00 | AAPL | Stock | 43.455 | 43.455 | 43.425 | 43.4375 | 42020.0 |
| 2017-11-13 08:50:00 | AAPL | Stock | 43.4475 | 43.455 | 43.4475 | 43.455 | 28380.0 |
| 2017-11-13 08:55:00 | AAPL | Stock | 43.4475 | 43.455 | 43.4375 | 43.4375 | 19996.0 |
| 2017-11-13 09:00:00 | AAPL | Stock | 43.43 | 43.4475 | 43.425 | 43.425 | 12644.0 |
| 2017-11-13 09:05:00 | AAPL | Stock | 43.425 | 43.4375 | 43.425 | 43.43 | 14096.0 |
| 2017-11-13 09:10:00 | AAPL | Stock | 43.4375 | 43.4375 | 43.43 | 43.4375 | 2776.0 |
| 2017-11-13 09:15:00 | AAPL | Stock | 43.4375 | 43.455 | 43.4375 | 43.455 | 21664.0 |
| 2017-11-13 09:20:00 | AAPL | Stock | 43.4525 | 43.455 | 43.4425 | 43.455 | 16228.0 |
| 2017-11-13 09:25:00 | AAPL | Stock | 43.445 | 43.445 | 43.365 | 43.3775 | 93824.0 |
| 2017-11-13 09:30:00 | AAPL | Stock | 43.375 | 43.5375 | 43.365 | 43.4975 | 3949644.0 |
| 2017-11-13 09:35:00 | AAPL | Stock | 43.505 | 43.5075 | 43.35 | 43.4012 | 2681264.0 |
| 2017-11-13 09:40:00 | AAPL | Stock | 43.4 | 43.475 | 43.3935 | 43.45 | 1514388.0 |
| 2017-11-13 09:45:00 | AAPL | Stock | 43.4475 | 43.4525 | 43.3625 | 43.384 | 1823300.0 |
| 2017-11-13 09:50:00 | AAPL | Stock | 43.3825 | 43.425 | 43.35 | 43.415 | 1636232.0 |
| 2017-11-13 09:55:00 | AAPL | Stock | 43.415 | 43.4845 | 43.4125 | 43.4675 | 1348308.0 |
| 2017-11-13 10:00:00 | AAPL | Stock | 43.4675 | 43.545 | 43.4675 | 43.494 | 1686924.0 |
| 2017-11-13 10:05:00 | AAPL | Stock | 43.495 | 43.53 | 43.4875 | 43.5225 | 969508.0 |
| 2017-11-13 10:10:00 | AAPL | Stock | 43.52 | 43.625 | 43.5175 | 43.57 | 1371652.0 |
| 2017-11-13 10:15:00 | AAPL | Stock | 43.572 | 43.5725 | 43.5225 | 43.5345 | 1079100.0 |
| 2017-11-13 10:20:00 | AAPL | Stock | 43.5338 | 43.575 | 43.52 | 43.57 | 711708.0 |
| 2017-11-13 10:25:00 | AAPL | Stock | 43.57 | 43.5975 | 43.5375 | 43.5688 | 988568.0 |
> showing 50 of 358,335 rows — these rows as CSV