PREVIEW / stock_5min / 2018-12-20
file: by_date/stock_5min/2018/2018-12-20.parquet size: 6.3 MB rows: 395,538 symbols: 2,763
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-12-20 04:00:00 | AAPL | Stock | 40.0475 | 40.0475 | 40.0475 | 40.0475 | 400.0 |
| 2018-12-20 04:20:00 | AAPL | Stock | 40.1 | 40.1 | 40.1 | 40.1 | 400.0 |
| 2018-12-20 04:25:00 | AAPL | Stock | 40.225 | 40.25 | 40.225 | 40.2425 | 3492.0 |
| 2018-12-20 04:30:00 | AAPL | Stock | 40.1875 | 40.1875 | 40.1875 | 40.1875 | 3216.0 |
| 2018-12-20 04:40:00 | AAPL | Stock | 40.24 | 40.2425 | 40.1525 | 40.1525 | 1600.0 |
| 2018-12-20 04:45:00 | AAPL | Stock | 40.1875 | 40.1875 | 40.1875 | 40.1875 | 2000.0 |
| 2018-12-20 04:50:00 | AAPL | Stock | 40.22 | 40.235 | 40.22 | 40.235 | 800.0 |
| 2018-12-20 05:00:00 | AAPL | Stock | 40.155 | 40.155 | 40.155 | 40.155 | 1460.0 |
| 2018-12-20 05:10:00 | AAPL | Stock | 40.205 | 40.25 | 40.205 | 40.25 | 6120.0 |
| 2018-12-20 05:25:00 | AAPL | Stock | 40.2225 | 40.2225 | 40.2225 | 40.2225 | 2000.0 |
| 2018-12-20 05:30:00 | AAPL | Stock | 40.175 | 40.175 | 40.175 | 40.175 | 3696.0 |
| 2018-12-20 05:35:00 | AAPL | Stock | 40.1725 | 40.175 | 40.15 | 40.15 | 4404.0 |
| 2018-12-20 05:40:00 | AAPL | Stock | 40.125 | 40.125 | 40.125 | 40.125 | 400.0 |
| 2018-12-20 05:45:00 | AAPL | Stock | 40.1 | 40.1 | 40.1 | 40.1 | 2000.0 |
| 2018-12-20 05:50:00 | AAPL | Stock | 40.15 | 40.15 | 40.15 | 40.15 | 1128.0 |
| 2018-12-20 05:55:00 | AAPL | Stock | 40.15 | 40.175 | 40.15 | 40.175 | 2600.0 |
| 2018-12-20 06:05:00 | AAPL | Stock | 40.21 | 40.21 | 40.21 | 40.21 | 1960.0 |
| 2018-12-20 06:10:00 | AAPL | Stock | 40.25 | 40.25 | 40.25 | 40.25 | 680.0 |
| 2018-12-20 06:20:00 | AAPL | Stock | 40.24 | 40.24 | 40.24 | 40.24 | 400.0 |
| 2018-12-20 06:25:00 | AAPL | Stock | 40.25 | 40.25 | 40.25 | 40.25 | 800.0 |
| 2018-12-20 06:30:00 | AAPL | Stock | 40.25 | 40.25 | 40.25 | 40.25 | 3420.0 |
| 2018-12-20 06:40:00 | AAPL | Stock | 40.275 | 40.275 | 40.275 | 40.275 | 400.0 |
| 2018-12-20 06:45:00 | AAPL | Stock | 40.2875 | 40.3125 | 40.2875 | 40.3125 | 12596.0 |
| 2018-12-20 06:55:00 | AAPL | Stock | 40.3 | 40.3 | 40.3 | 40.3 | 3996.0 |
| 2018-12-20 07:00:00 | AAPL | Stock | 40.3025 | 40.4225 | 40.3025 | 40.3925 | 24696.0 |
| 2018-12-20 07:05:00 | AAPL | Stock | 40.3925 | 40.3925 | 40.3925 | 40.3925 | 29044.0 |
| 2018-12-20 07:10:00 | AAPL | Stock | 40.3875 | 40.3925 | 40.3625 | 40.3625 | 14864.0 |
| 2018-12-20 07:15:00 | AAPL | Stock | 40.3625 | 40.3925 | 40.3425 | 40.3625 | 11968.0 |
| 2018-12-20 07:20:00 | AAPL | Stock | 40.3375 | 40.4075 | 40.325 | 40.37 | 18460.0 |
| 2018-12-20 07:25:00 | AAPL | Stock | 40.325 | 40.3375 | 40.325 | 40.3375 | 3400.0 |
| 2018-12-20 07:30:00 | AAPL | Stock | 40.345 | 40.345 | 40.3125 | 40.3125 | 26428.0 |
| 2018-12-20 07:35:00 | AAPL | Stock | 40.3125 | 40.315 | 40.2875 | 40.315 | 11100.0 |
| 2018-12-20 07:40:00 | AAPL | Stock | 40.2925 | 40.33 | 40.2925 | 40.305 | 7956.0 |
| 2018-12-20 07:45:00 | AAPL | Stock | 40.305 | 40.3675 | 40.305 | 40.33 | 18668.0 |
| 2018-12-20 07:50:00 | AAPL | Stock | 40.34 | 40.4 | 40.34 | 40.3675 | 30748.0 |
| 2018-12-20 07:55:00 | AAPL | Stock | 40.395 | 40.4125 | 40.3675 | 40.3675 | 6020.0 |
| 2018-12-20 08:00:00 | AAPL | Stock | 40.4375 | 40.4375 | 40.1375 | 40.235 | 153308.0 |
| 2018-12-20 08:05:00 | AAPL | Stock | 40.225 | 40.225 | 40.025 | 40.0925 | 90908.0 |
| 2018-12-20 08:10:00 | AAPL | Stock | 40.0925 | 40.1025 | 40.05 | 40.1 | 58324.0 |
| 2018-12-20 08:15:00 | AAPL | Stock | 40.1525 | 40.1825 | 40.1125 | 40.1625 | 44668.0 |
| 2018-12-20 08:20:00 | AAPL | Stock | 40.15 | 40.1625 | 40.1125 | 40.155 | 42652.0 |
| 2018-12-20 08:25:00 | AAPL | Stock | 40.155 | 40.27 | 40.155 | 40.25 | 112668.0 |
| 2018-12-20 08:30:00 | AAPL | Stock | 40.225 | 40.275 | 40.16 | 40.175 | 44364.0 |
| 2018-12-20 08:35:00 | AAPL | Stock | 40.1875 | 40.1875 | 40.125 | 40.1725 | 85664.0 |
| 2018-12-20 08:40:00 | AAPL | Stock | 40.16 | 40.205 | 40.0875 | 40.205 | 85196.0 |
| 2018-12-20 08:45:00 | AAPL | Stock | 40.15 | 40.21 | 40.055 | 40.055 | 50748.0 |
| 2018-12-20 08:50:00 | AAPL | Stock | 40.0625 | 40.075 | 39.98 | 39.98 | 77632.0 |
| 2018-12-20 08:55:00 | AAPL | Stock | 39.99 | 40.0475 | 39.98 | 40.0125 | 41220.0 |
| 2018-12-20 09:00:00 | AAPL | Stock | 40.0 | 40.025 | 39.975 | 39.9875 | 43600.0 |
| 2018-12-20 09:05:00 | AAPL | Stock | 39.9875 | 40.06 | 39.9875 | 40.0425 | 90316.0 |
> showing 50 of 395,538 rows — these rows as CSV