PREVIEW / stock_5min / 2018-03-13
file: by_date/stock_5min/2018/2018-03-13.parquet size: 5.7 MB rows: 364,685 symbols: 2,864
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-03-13 04:00:00 | AAPL | Stock | 45.375 | 45.375 | 45.375 | 45.375 | 400.0 |
| 2018-03-13 04:05:00 | AAPL | Stock | 45.3875 | 45.3875 | 45.3875 | 45.3875 | 1848.0 |
| 2018-03-13 04:10:00 | AAPL | Stock | 45.3775 | 45.3775 | 45.3775 | 45.3775 | 408.0 |
| 2018-03-13 04:20:00 | AAPL | Stock | 45.375 | 45.375 | 45.375 | 45.375 | 480.0 |
| 2018-03-13 04:30:00 | AAPL | Stock | 45.375 | 45.375 | 45.375 | 45.375 | 800.0 |
| 2018-03-13 04:35:00 | AAPL | Stock | 45.375 | 45.4 | 45.375 | 45.4 | 1200.0 |
| 2018-03-13 05:05:00 | AAPL | Stock | 45.4 | 45.4025 | 45.4 | 45.4025 | 14456.0 |
| 2018-03-13 05:20:00 | AAPL | Stock | 45.375 | 45.375 | 45.375 | 45.375 | 3600.0 |
| 2018-03-13 05:30:00 | AAPL | Stock | 45.4025 | 45.4025 | 45.4025 | 45.4025 | 484.0 |
| 2018-03-13 05:35:00 | AAPL | Stock | 45.4025 | 45.4025 | 45.4025 | 45.4025 | 400.0 |
| 2018-03-13 06:10:00 | AAPL | Stock | 45.4125 | 45.4125 | 45.4125 | 45.4125 | 400.0 |
| 2018-03-13 06:15:00 | AAPL | Stock | 45.435 | 45.4375 | 45.435 | 45.4375 | 5600.0 |
| 2018-03-13 06:20:00 | AAPL | Stock | 45.4375 | 45.4375 | 45.4375 | 45.4375 | 6864.0 |
| 2018-03-13 06:25:00 | AAPL | Stock | 45.45 | 45.45 | 45.45 | 45.45 | 2000.0 |
| 2018-03-13 06:30:00 | AAPL | Stock | 45.45 | 45.45 | 45.45 | 45.45 | 400.0 |
| 2018-03-13 06:35:00 | AAPL | Stock | 45.4375 | 45.4375 | 45.4375 | 45.4375 | 2400.0 |
| 2018-03-13 06:40:00 | AAPL | Stock | 45.45 | 45.45 | 45.45 | 45.45 | 12404.0 |
| 2018-03-13 07:00:00 | AAPL | Stock | 45.4625 | 45.5 | 45.4625 | 45.495 | 34000.0 |
| 2018-03-13 07:05:00 | AAPL | Stock | 45.4975 | 45.5 | 45.4975 | 45.5 | 7040.0 |
| 2018-03-13 07:10:00 | AAPL | Stock | 45.505 | 45.5225 | 45.505 | 45.5225 | 7600.0 |
| 2018-03-13 07:15:00 | AAPL | Stock | 45.5225 | 45.525 | 45.475 | 45.5 | 71500.0 |
| 2018-03-13 07:20:00 | AAPL | Stock | 45.505 | 45.505 | 45.5 | 45.5 | 6360.0 |
| 2018-03-13 07:25:00 | AAPL | Stock | 45.49 | 45.5 | 45.49 | 45.5 | 9040.0 |
| 2018-03-13 07:30:00 | AAPL | Stock | 45.505 | 45.505 | 45.5 | 45.5 | 5560.0 |
| 2018-03-13 07:35:00 | AAPL | Stock | 45.5 | 45.5 | 45.4725 | 45.4725 | 49200.0 |
| 2018-03-13 07:40:00 | AAPL | Stock | 45.465 | 45.47 | 45.465 | 45.47 | 4200.0 |
| 2018-03-13 07:45:00 | AAPL | Stock | 45.47 | 45.475 | 45.47 | 45.475 | 8000.0 |
| 2018-03-13 07:55:00 | AAPL | Stock | 45.4775 | 45.4925 | 45.475 | 45.4925 | 2400.0 |
| 2018-03-13 08:00:00 | AAPL | Stock | 45.475 | 45.53 | 45.4375 | 45.4375 | 98120.0 |
| 2018-03-13 08:05:00 | AAPL | Stock | 45.45 | 45.5075 | 45.45 | 45.5075 | 56944.0 |
| 2018-03-13 08:10:00 | AAPL | Stock | 45.5 | 45.51 | 45.5 | 45.5025 | 38604.0 |
| 2018-03-13 08:15:00 | AAPL | Stock | 45.5 | 45.5 | 45.495 | 45.495 | 53324.0 |
| 2018-03-13 08:20:00 | AAPL | Stock | 45.4875 | 45.4875 | 45.475 | 45.475 | 10100.0 |
| 2018-03-13 08:25:00 | AAPL | Stock | 45.4875 | 45.4925 | 45.47 | 45.49 | 13844.0 |
| 2018-03-13 08:30:00 | AAPL | Stock | 45.4975 | 45.5925 | 45.4975 | 45.5725 | 137976.0 |
| 2018-03-13 08:35:00 | AAPL | Stock | 45.56 | 45.6125 | 45.56 | 45.605 | 116424.0 |
| 2018-03-13 08:40:00 | AAPL | Stock | 45.6 | 45.6375 | 45.475 | 45.5475 | 196628.0 |
| 2018-03-13 08:45:00 | AAPL | Stock | 45.545 | 45.6 | 45.545 | 45.5725 | 109576.0 |
| 2018-03-13 08:50:00 | AAPL | Stock | 45.575 | 45.5875 | 45.5675 | 45.585 | 55352.0 |
| 2018-03-13 08:55:00 | AAPL | Stock | 45.5925 | 45.595 | 45.575 | 45.575 | 17080.0 |
| 2018-03-13 09:00:00 | AAPL | Stock | 45.5775 | 45.595 | 45.54 | 45.55 | 61916.0 |
| 2018-03-13 09:05:00 | AAPL | Stock | 45.55 | 45.5725 | 45.535 | 45.5625 | 32584.0 |
| 2018-03-13 09:10:00 | AAPL | Stock | 45.5625 | 45.5725 | 45.5525 | 45.5625 | 48636.0 |
| 2018-03-13 09:15:00 | AAPL | Stock | 45.5625 | 45.605 | 45.5625 | 45.6 | 47164.0 |
| 2018-03-13 09:20:00 | AAPL | Stock | 45.605 | 45.6075 | 45.6 | 45.6075 | 30288.0 |
| 2018-03-13 09:25:00 | AAPL | Stock | 45.6125 | 45.6475 | 45.6025 | 45.6375 | 63168.0 |
| 2018-03-13 09:30:00 | AAPL | Stock | 45.6425 | 45.7025 | 45.5525 | 45.67 | 4134932.0 |
| 2018-03-13 09:35:00 | AAPL | Stock | 45.66 | 45.7625 | 45.6425 | 45.7562 | 2679964.0 |
| 2018-03-13 09:40:00 | AAPL | Stock | 45.7575 | 45.8175 | 45.755 | 45.795 | 2146668.0 |
| 2018-03-13 09:45:00 | AAPL | Stock | 45.795 | 45.825 | 45.7325 | 45.752 | 2321604.0 |
> showing 50 of 364,685 rows — these rows as CSV