PREVIEW / stock_5min / 2017-12-05
file: by_date/stock_5min/2017/2017-12-05.parquet size: 5.6 MB rows: 363,981 symbols: 2,936
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-12-05 04:20:00 | AAPL | Stock | 42.3625 | 42.3625 | 42.3575 | 42.3575 | 9600.0 |
| 2017-12-05 04:25:00 | AAPL | Stock | 42.325 | 42.325 | 42.255 | 42.255 | 4028.0 |
| 2017-12-05 04:30:00 | AAPL | Stock | 42.295 | 42.3125 | 42.295 | 42.3125 | 7240.0 |
| 2017-12-05 04:40:00 | AAPL | Stock | 42.3125 | 42.3125 | 42.3125 | 42.3125 | 4000.0 |
| 2017-12-05 04:50:00 | AAPL | Stock | 42.325 | 42.325 | 42.325 | 42.325 | 932.0 |
| 2017-12-05 04:55:00 | AAPL | Stock | 42.325 | 42.34 | 42.325 | 42.34 | 2240.0 |
| 2017-12-05 05:00:00 | AAPL | Stock | 42.3 | 42.3 | 42.3 | 42.3 | 10800.0 |
| 2017-12-05 05:20:00 | AAPL | Stock | 42.3 | 42.3 | 42.265 | 42.265 | 7936.0 |
| 2017-12-05 05:25:00 | AAPL | Stock | 42.19 | 42.19 | 42.19 | 42.19 | 460.0 |
| 2017-12-05 05:30:00 | AAPL | Stock | 42.225 | 42.225 | 42.225 | 42.225 | 400.0 |
| 2017-12-05 05:40:00 | AAPL | Stock | 42.165 | 42.1875 | 42.165 | 42.1875 | 800.0 |
| 2017-12-05 05:45:00 | AAPL | Stock | 42.1875 | 42.2175 | 42.1875 | 42.2175 | 8400.0 |
| 2017-12-05 05:50:00 | AAPL | Stock | 42.165 | 42.165 | 42.165 | 42.165 | 464.0 |
| 2017-12-05 05:55:00 | AAPL | Stock | 42.1475 | 42.1475 | 42.1475 | 42.1475 | 8000.0 |
| 2017-12-05 06:00:00 | AAPL | Stock | 42.15 | 42.15 | 42.15 | 42.15 | 400.0 |
| 2017-12-05 06:05:00 | AAPL | Stock | 42.1125 | 42.1125 | 42.1125 | 42.1125 | 400.0 |
| 2017-12-05 06:15:00 | AAPL | Stock | 42.15 | 42.15 | 42.1125 | 42.1375 | 5100.0 |
| 2017-12-05 06:20:00 | AAPL | Stock | 42.125 | 42.125 | 42.125 | 42.125 | 2800.0 |
| 2017-12-05 06:25:00 | AAPL | Stock | 42.1225 | 42.1475 | 42.1225 | 42.1475 | 2188.0 |
| 2017-12-05 06:40:00 | AAPL | Stock | 42.1775 | 42.1775 | 42.1775 | 42.1775 | 1600.0 |
| 2017-12-05 06:50:00 | AAPL | Stock | 42.2125 | 42.225 | 42.2125 | 42.225 | 3324.0 |
| 2017-12-05 06:55:00 | AAPL | Stock | 42.25 | 42.25 | 42.25 | 42.25 | 9308.0 |
| 2017-12-05 07:00:00 | AAPL | Stock | 42.2875 | 42.3125 | 42.265 | 42.3 | 25420.0 |
| 2017-12-05 07:05:00 | AAPL | Stock | 42.275 | 42.365 | 42.275 | 42.365 | 37212.0 |
| 2017-12-05 07:10:00 | AAPL | Stock | 42.3425 | 42.37 | 42.315 | 42.37 | 18928.0 |
| 2017-12-05 07:15:00 | AAPL | Stock | 42.3275 | 42.3275 | 42.3275 | 42.3275 | 600.0 |
| 2017-12-05 07:20:00 | AAPL | Stock | 42.3625 | 42.3625 | 42.3275 | 42.35 | 6172.0 |
| 2017-12-05 07:25:00 | AAPL | Stock | 42.35 | 42.35 | 42.3025 | 42.3125 | 12216.0 |
| 2017-12-05 07:30:00 | AAPL | Stock | 42.335 | 42.375 | 42.335 | 42.375 | 8052.0 |
| 2017-12-05 07:35:00 | AAPL | Stock | 42.42 | 42.45 | 42.42 | 42.425 | 26056.0 |
| 2017-12-05 07:40:00 | AAPL | Stock | 42.42 | 42.5 | 42.42 | 42.4975 | 11060.0 |
| 2017-12-05 07:45:00 | AAPL | Stock | 42.495 | 42.495 | 42.465 | 42.465 | 4976.0 |
| 2017-12-05 07:50:00 | AAPL | Stock | 42.465 | 42.5125 | 42.4625 | 42.48 | 10984.0 |
| 2017-12-05 07:55:00 | AAPL | Stock | 42.5125 | 42.525 | 42.5 | 42.5225 | 30392.0 |
| 2017-12-05 08:00:00 | AAPL | Stock | 42.25 | 42.5625 | 42.25 | 42.5225 | 35736.0 |
| 2017-12-05 08:05:00 | AAPL | Stock | 42.5225 | 42.5625 | 42.5225 | 42.5625 | 26636.0 |
| 2017-12-05 08:10:00 | AAPL | Stock | 42.5625 | 42.5775 | 42.5125 | 42.525 | 11400.0 |
| 2017-12-05 08:15:00 | AAPL | Stock | 42.5125 | 42.5125 | 42.5 | 42.5 | 76808.0 |
| 2017-12-05 08:20:00 | AAPL | Stock | 42.475 | 42.475 | 42.415 | 42.4225 | 28772.0 |
| 2017-12-05 08:25:00 | AAPL | Stock | 42.4375 | 42.4725 | 42.4375 | 42.4725 | 2600.0 |
| 2017-12-05 08:30:00 | AAPL | Stock | 42.4825 | 42.4975 | 42.45 | 42.45 | 23776.0 |
| 2017-12-05 08:35:00 | AAPL | Stock | 42.45 | 42.45 | 42.425 | 42.425 | 14012.0 |
| 2017-12-05 08:40:00 | AAPL | Stock | 42.415 | 42.425 | 42.415 | 42.425 | 11400.0 |
| 2017-12-05 08:45:00 | AAPL | Stock | 42.4375 | 42.565 | 42.4375 | 42.48 | 37424.0 |
| 2017-12-05 08:50:00 | AAPL | Stock | 42.4975 | 42.5 | 42.4625 | 42.4625 | 8032.0 |
| 2017-12-05 08:55:00 | AAPL | Stock | 42.4725 | 42.4725 | 42.4375 | 42.44 | 7396.0 |
| 2017-12-05 09:00:00 | AAPL | Stock | 42.4375 | 42.4375 | 42.3875 | 42.3875 | 32924.0 |
| 2017-12-05 09:05:00 | AAPL | Stock | 42.4225 | 42.495 | 42.4225 | 42.4725 | 15788.0 |
| 2017-12-05 09:10:00 | AAPL | Stock | 42.4725 | 42.4725 | 42.4725 | 42.4725 | 800.0 |
| 2017-12-05 09:15:00 | AAPL | Stock | 42.475 | 42.475 | 42.465 | 42.465 | 18500.0 |
> showing 50 of 363,981 rows — these rows as CSV