PREVIEW / stock_5min / 2017-10-26
file: by_date/stock_5min/2017/2017-10-26.parquet size: 5.5 MB rows: 353,482 symbols: 2,940
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-10-26 04:40:00 | AAPL | Stock | 39.155 | 39.155 | 39.155 | 39.155 | 800.0 |
| 2017-10-26 05:30:00 | AAPL | Stock | 39.175 | 39.175 | 39.175 | 39.175 | 400.0 |
| 2017-10-26 06:20:00 | AAPL | Stock | 39.245 | 39.25 | 39.245 | 39.25 | 19400.0 |
| 2017-10-26 06:55:00 | AAPL | Stock | 39.185 | 39.185 | 39.185 | 39.185 | 1332.0 |
| 2017-10-26 07:00:00 | AAPL | Stock | 39.185 | 39.185 | 39.185 | 39.185 | 2000.0 |
| 2017-10-26 07:10:00 | AAPL | Stock | 39.2425 | 39.2525 | 39.2425 | 39.25 | 23212.0 |
| 2017-10-26 07:15:00 | AAPL | Stock | 39.2525 | 39.275 | 39.25 | 39.25 | 31580.0 |
| 2017-10-26 07:20:00 | AAPL | Stock | 39.25 | 39.25 | 39.25 | 39.25 | 14844.0 |
| 2017-10-26 07:25:00 | AAPL | Stock | 39.25 | 39.25 | 39.25 | 39.25 | 7184.0 |
| 2017-10-26 07:30:00 | AAPL | Stock | 39.2975 | 39.2975 | 39.2975 | 39.2975 | 400.0 |
| 2017-10-26 07:35:00 | AAPL | Stock | 39.2975 | 39.2975 | 39.275 | 39.275 | 9564.0 |
| 2017-10-26 07:40:00 | AAPL | Stock | 39.2775 | 39.2775 | 39.2775 | 39.2775 | 400.0 |
| 2017-10-26 07:45:00 | AAPL | Stock | 39.255 | 39.2775 | 39.255 | 39.2625 | 7004.0 |
| 2017-10-26 07:50:00 | AAPL | Stock | 39.26 | 39.26 | 39.25 | 39.2525 | 7200.0 |
| 2017-10-26 08:00:00 | AAPL | Stock | 39.25 | 39.295 | 39.235 | 39.25 | 60808.0 |
| 2017-10-26 08:05:00 | AAPL | Stock | 39.25 | 39.2925 | 39.24 | 39.26 | 11660.0 |
| 2017-10-26 08:10:00 | AAPL | Stock | 39.2725 | 39.275 | 39.2725 | 39.275 | 7584.0 |
| 2017-10-26 08:15:00 | AAPL | Stock | 39.28 | 39.2925 | 39.25 | 39.2775 | 14996.0 |
| 2017-10-26 08:20:00 | AAPL | Stock | 39.285 | 39.3 | 39.27 | 39.2775 | 12600.0 |
| 2017-10-26 08:25:00 | AAPL | Stock | 39.27 | 39.2825 | 39.2425 | 39.2425 | 21808.0 |
| 2017-10-26 08:30:00 | AAPL | Stock | 39.275 | 39.3225 | 39.2525 | 39.3125 | 40908.0 |
| 2017-10-26 08:35:00 | AAPL | Stock | 39.2875 | 39.3075 | 39.275 | 39.275 | 8740.0 |
| 2017-10-26 08:40:00 | AAPL | Stock | 39.3025 | 39.305 | 39.2525 | 39.3 | 31308.0 |
| 2017-10-26 08:45:00 | AAPL | Stock | 39.275 | 39.275 | 39.2725 | 39.275 | 2208.0 |
| 2017-10-26 08:50:00 | AAPL | Stock | 39.265 | 39.275 | 39.24 | 39.26 | 70720.0 |
| 2017-10-26 08:55:00 | AAPL | Stock | 39.2375 | 39.2625 | 39.2375 | 39.25 | 10548.0 |
| 2017-10-26 09:00:00 | AAPL | Stock | 39.2675 | 39.2675 | 39.23 | 39.25 | 31844.0 |
| 2017-10-26 09:05:00 | AAPL | Stock | 39.245 | 39.2475 | 39.23 | 39.2375 | 7140.0 |
| 2017-10-26 09:10:00 | AAPL | Stock | 39.2475 | 39.2675 | 39.24 | 39.2675 | 17260.0 |
| 2017-10-26 09:15:00 | AAPL | Stock | 39.265 | 39.265 | 39.2375 | 39.245 | 4800.0 |
| 2017-10-26 09:20:00 | AAPL | Stock | 39.23 | 39.2425 | 39.2025 | 39.24 | 25968.0 |
| 2017-10-26 09:25:00 | AAPL | Stock | 39.23 | 39.3125 | 39.23 | 39.3075 | 47660.0 |
| 2017-10-26 09:30:00 | AAPL | Stock | 39.3125 | 39.435 | 39.2925 | 39.4325 | 3748168.0 |
| 2017-10-26 09:35:00 | AAPL | Stock | 39.4325 | 39.4575 | 39.375 | 39.395 | 2127660.0 |
| 2017-10-26 09:40:00 | AAPL | Stock | 39.395 | 39.4375 | 39.35 | 39.425 | 1658216.0 |
| 2017-10-26 09:45:00 | AAPL | Stock | 39.425 | 39.425 | 39.3175 | 39.3418 | 1086308.0 |
| 2017-10-26 09:50:00 | AAPL | Stock | 39.345 | 39.3675 | 39.315 | 39.33 | 845764.0 |
| 2017-10-26 09:55:00 | AAPL | Stock | 39.33 | 39.3325 | 39.285 | 39.315 | 965288.0 |
| 2017-10-26 10:00:00 | AAPL | Stock | 39.315 | 39.32 | 39.25 | 39.3 | 1088688.0 |
| 2017-10-26 10:05:00 | AAPL | Stock | 39.3 | 39.31 | 39.225 | 39.2425 | 1083508.0 |
| 2017-10-26 10:10:00 | AAPL | Stock | 39.24 | 39.28 | 39.21 | 39.215 | 869300.0 |
| 2017-10-26 10:15:00 | AAPL | Stock | 39.215 | 39.295 | 39.195 | 39.28 | 1032976.0 |
| 2017-10-26 10:20:00 | AAPL | Stock | 39.2775 | 39.3525 | 39.2775 | 39.345 | 799368.0 |
| 2017-10-26 10:25:00 | AAPL | Stock | 39.345 | 39.3675 | 39.3 | 39.3 | 683844.0 |
| 2017-10-26 10:30:00 | AAPL | Stock | 39.3025 | 39.3375 | 39.28 | 39.3262 | 468200.0 |
| 2017-10-26 10:35:00 | AAPL | Stock | 39.325 | 39.3925 | 39.3125 | 39.3875 | 811400.0 |
| 2017-10-26 10:40:00 | AAPL | Stock | 39.3868 | 39.395 | 39.35 | 39.36 | 561324.0 |
| 2017-10-26 10:45:00 | AAPL | Stock | 39.36 | 39.42 | 39.36 | 39.3975 | 1117884.0 |
| 2017-10-26 10:50:00 | AAPL | Stock | 39.4 | 39.425 | 39.3925 | 39.4175 | 639284.0 |
| 2017-10-26 10:55:00 | AAPL | Stock | 39.42 | 39.4325 | 39.3825 | 39.3852 | 597424.0 |
> showing 50 of 353,482 rows — these rows as CSV