PREVIEW / stock_5min / 2017-04-17
file: by_date/stock_5min/2017/2017-04-17.parquet size: 5.2 MB rows: 345,205 symbols: 3,063
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-04-17 06:45:00 | AAPL | Stock | 35.2775 | 35.2775 | 35.2775 | 35.2775 | 800.0 |
| 2017-04-17 06:50:00 | AAPL | Stock | 35.3575 | 35.3575 | 35.3575 | 35.3575 | 800.0 |
| 2017-04-17 07:00:00 | AAPL | Stock | 35.325 | 35.325 | 35.325 | 35.325 | 1600.0 |
| 2017-04-17 07:15:00 | AAPL | Stock | 35.345 | 35.345 | 35.345 | 35.345 | 720.0 |
| 2017-04-17 07:20:00 | AAPL | Stock | 35.355 | 35.355 | 35.355 | 35.355 | 400.0 |
| 2017-04-17 07:40:00 | AAPL | Stock | 35.3725 | 35.3725 | 35.3725 | 35.3725 | 400.0 |
| 2017-04-17 07:50:00 | AAPL | Stock | 35.3875 | 35.3875 | 35.3875 | 35.3875 | 400.0 |
| 2017-04-17 07:55:00 | AAPL | Stock | 35.405 | 35.41 | 35.4 | 35.41 | 5908.0 |
| 2017-04-17 08:00:00 | AAPL | Stock | 35.405 | 35.4125 | 35.325 | 35.4125 | 31204.0 |
| 2017-04-17 08:05:00 | AAPL | Stock | 35.4125 | 35.4125 | 35.4125 | 35.4125 | 4328.0 |
| 2017-04-17 08:10:00 | AAPL | Stock | 35.43 | 35.445 | 35.43 | 35.445 | 16000.0 |
| 2017-04-17 08:15:00 | AAPL | Stock | 35.4375 | 35.4375 | 35.415 | 35.415 | 16500.0 |
| 2017-04-17 08:20:00 | AAPL | Stock | 35.4275 | 35.43 | 35.415 | 35.415 | 25980.0 |
| 2017-04-17 08:25:00 | AAPL | Stock | 35.43 | 35.43 | 35.43 | 35.43 | 3284.0 |
| 2017-04-17 08:30:00 | AAPL | Stock | 35.4375 | 35.4425 | 35.4275 | 35.4425 | 11800.0 |
| 2017-04-17 08:35:00 | AAPL | Stock | 35.445 | 35.46 | 35.44 | 35.46 | 10880.0 |
| 2017-04-17 08:40:00 | AAPL | Stock | 35.455 | 35.4575 | 35.455 | 35.4575 | 6100.0 |
| 2017-04-17 08:45:00 | AAPL | Stock | 35.45 | 35.4625 | 35.45 | 35.4625 | 15416.0 |
| 2017-04-17 08:50:00 | AAPL | Stock | 35.45 | 35.45 | 35.45 | 35.45 | 5984.0 |
| 2017-04-17 08:55:00 | AAPL | Stock | 35.4625 | 35.4825 | 35.4625 | 35.4825 | 21972.0 |
| 2017-04-17 09:00:00 | AAPL | Stock | 35.475 | 35.475 | 35.4625 | 35.4625 | 7020.0 |
| 2017-04-17 09:05:00 | AAPL | Stock | 35.45 | 35.4825 | 35.45 | 35.4825 | 28324.0 |
| 2017-04-17 09:10:00 | AAPL | Stock | 35.475 | 35.475 | 35.4425 | 35.4425 | 15792.0 |
| 2017-04-17 09:15:00 | AAPL | Stock | 35.4625 | 35.4725 | 35.4575 | 35.46 | 9820.0 |
| 2017-04-17 09:20:00 | AAPL | Stock | 35.4425 | 35.4425 | 35.4425 | 35.4425 | 6000.0 |
| 2017-04-17 09:25:00 | AAPL | Stock | 35.4425 | 35.46 | 35.2875 | 35.295 | 272464.0 |
| 2017-04-17 09:30:00 | AAPL | Stock | 35.295 | 35.41 | 35.2875 | 35.4075 | 5546584.0 |
| 2017-04-17 09:35:00 | AAPL | Stock | 35.4075 | 35.425 | 35.367 | 35.3838 | 1920028.0 |
| 2017-04-17 09:40:00 | AAPL | Stock | 35.3875 | 35.3998 | 35.35 | 35.375 | 1083348.0 |
| 2017-04-17 09:45:00 | AAPL | Stock | 35.37 | 35.4025 | 35.3625 | 35.376 | 897552.0 |
| 2017-04-17 09:50:00 | AAPL | Stock | 35.3775 | 35.3812 | 35.305 | 35.3448 | 988944.0 |
| 2017-04-17 09:55:00 | AAPL | Stock | 35.3425 | 35.3475 | 35.2768 | 35.3075 | 1096228.0 |
| 2017-04-17 10:00:00 | AAPL | Stock | 35.305 | 35.35 | 35.295 | 35.3375 | 1055028.0 |
| 2017-04-17 10:05:00 | AAPL | Stock | 35.3375 | 35.3625 | 35.3225 | 35.36 | 819204.0 |
| 2017-04-17 10:10:00 | AAPL | Stock | 35.3588 | 35.3588 | 35.3175 | 35.3305 | 1009404.0 |
| 2017-04-17 10:15:00 | AAPL | Stock | 35.33 | 35.3875 | 35.327 | 35.3725 | 1136324.0 |
| 2017-04-17 10:20:00 | AAPL | Stock | 35.375 | 35.3812 | 35.3175 | 35.3212 | 698424.0 |
| 2017-04-17 10:25:00 | AAPL | Stock | 35.3225 | 35.325 | 35.2625 | 35.2625 | 1238020.0 |
| 2017-04-17 10:30:00 | AAPL | Stock | 35.2625 | 35.2925 | 35.2625 | 35.28 | 1238916.0 |
| 2017-04-17 10:35:00 | AAPL | Stock | 35.2775 | 35.285 | 35.2175 | 35.24 | 1555416.0 |
| 2017-04-17 10:40:00 | AAPL | Stock | 35.24 | 35.271 | 35.2312 | 35.26 | 764956.0 |
| 2017-04-17 10:45:00 | AAPL | Stock | 35.2625 | 35.29 | 35.26 | 35.275 | 644088.0 |
| 2017-04-17 10:50:00 | AAPL | Stock | 35.2775 | 35.3 | 35.27 | 35.275 | 488144.0 |
| 2017-04-17 10:55:00 | AAPL | Stock | 35.2738 | 35.29 | 35.265 | 35.28 | 422076.0 |
| 2017-04-17 11:00:00 | AAPL | Stock | 35.28 | 35.285 | 35.2425 | 35.2688 | 500380.0 |
| 2017-04-17 11:05:00 | AAPL | Stock | 35.2675 | 35.275 | 35.235 | 35.2525 | 468440.0 |
| 2017-04-17 11:10:00 | AAPL | Stock | 35.2525 | 35.29 | 35.2525 | 35.29 | 443264.0 |
| 2017-04-17 11:15:00 | AAPL | Stock | 35.2888 | 35.3325 | 35.2875 | 35.325 | 848448.0 |
| 2017-04-17 11:20:00 | AAPL | Stock | 35.3275 | 35.3388 | 35.3025 | 35.3062 | 583128.0 |
| 2017-04-17 11:25:00 | AAPL | Stock | 35.3075 | 35.325 | 35.305 | 35.325 | 354776.0 |
> showing 50 of 345,205 rows — these rows as CSV