PREVIEW / stock_5min / 2016-03-24
file: by_date/stock_5min/2016/2016-03-24.parquet size: 5.2 MB rows: 347,211 symbols: 3,309
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-24 04:00:00 | AAPL | Stock | 26.505 | 26.505 | 26.505 | 26.505 | 400.0 |
| 2016-03-24 04:05:00 | AAPL | Stock | 26.48 | 26.48 | 26.48 | 26.48 | 400.0 |
| 2016-03-24 05:15:00 | AAPL | Stock | 26.4375 | 26.4375 | 26.4375 | 26.4375 | 1996.0 |
| 2016-03-24 06:00:00 | AAPL | Stock | 26.4325 | 26.4375 | 26.4325 | 26.4375 | 800.0 |
| 2016-03-24 06:05:00 | AAPL | Stock | 26.385 | 26.385 | 26.3825 | 26.3825 | 2800.0 |
| 2016-03-24 06:10:00 | AAPL | Stock | 26.4175 | 26.4175 | 26.4175 | 26.4175 | 4000.0 |
| 2016-03-24 06:20:00 | AAPL | Stock | 26.4325 | 26.4325 | 26.4325 | 26.4325 | 400.0 |
| 2016-03-24 06:35:00 | AAPL | Stock | 26.42 | 26.42 | 26.42 | 26.42 | 400.0 |
| 2016-03-24 07:00:00 | AAPL | Stock | 26.42 | 26.4225 | 26.42 | 26.4225 | 2000.0 |
| 2016-03-24 07:05:00 | AAPL | Stock | 26.41 | 26.41 | 26.41 | 26.41 | 1000.0 |
| 2016-03-24 07:10:00 | AAPL | Stock | 26.4125 | 26.425 | 26.41 | 26.425 | 4252.0 |
| 2016-03-24 07:25:00 | AAPL | Stock | 26.42 | 26.42 | 26.42 | 26.42 | 400.0 |
| 2016-03-24 07:30:00 | AAPL | Stock | 26.4175 | 26.42 | 26.415 | 26.42 | 4600.0 |
| 2016-03-24 07:35:00 | AAPL | Stock | 26.4125 | 26.4175 | 26.41 | 26.4125 | 6000.0 |
| 2016-03-24 07:40:00 | AAPL | Stock | 26.4175 | 26.4175 | 26.41 | 26.41 | 10584.0 |
| 2016-03-24 07:45:00 | AAPL | Stock | 26.4 | 26.41 | 26.4 | 26.41 | 3800.0 |
| 2016-03-24 07:50:00 | AAPL | Stock | 26.4 | 26.4 | 26.4 | 26.4 | 936.0 |
| 2016-03-24 08:00:00 | AAPL | Stock | 26.41 | 26.4225 | 26.41 | 26.415 | 17800.0 |
| 2016-03-24 08:05:00 | AAPL | Stock | 26.4225 | 26.4225 | 26.4225 | 26.4225 | 400.0 |
| 2016-03-24 08:10:00 | AAPL | Stock | 26.4225 | 26.4325 | 26.4125 | 26.4225 | 10968.0 |
| 2016-03-24 08:15:00 | AAPL | Stock | 26.415 | 26.4275 | 26.415 | 26.4175 | 6000.0 |
| 2016-03-24 08:25:00 | AAPL | Stock | 26.4275 | 26.4375 | 26.4275 | 26.4375 | 1680.0 |
| 2016-03-24 08:30:00 | AAPL | Stock | 26.4275 | 26.4475 | 26.4275 | 26.4325 | 14180.0 |
| 2016-03-24 08:35:00 | AAPL | Stock | 26.4325 | 26.4325 | 26.41 | 26.41 | 13012.0 |
| 2016-03-24 08:40:00 | AAPL | Stock | 26.4025 | 26.4125 | 26.4 | 26.4 | 34440.0 |
| 2016-03-24 08:45:00 | AAPL | Stock | 26.405 | 26.42 | 26.405 | 26.415 | 7700.0 |
| 2016-03-24 08:50:00 | AAPL | Stock | 26.425 | 26.4325 | 26.425 | 26.4275 | 5332.0 |
| 2016-03-24 08:55:00 | AAPL | Stock | 26.4175 | 26.425 | 26.4175 | 26.4175 | 13600.0 |
| 2016-03-24 09:00:00 | AAPL | Stock | 26.4175 | 26.43 | 26.41 | 26.43 | 19600.0 |
| 2016-03-24 09:05:00 | AAPL | Stock | 26.415 | 26.4275 | 26.415 | 26.4275 | 8492.0 |
| 2016-03-24 09:10:00 | AAPL | Stock | 26.4275 | 26.4375 | 26.425 | 26.425 | 22648.0 |
| 2016-03-24 09:15:00 | AAPL | Stock | 26.425 | 26.425 | 26.42 | 26.425 | 13000.0 |
| 2016-03-24 09:20:00 | AAPL | Stock | 26.43 | 26.4325 | 26.425 | 26.43 | 21000.0 |
| 2016-03-24 09:25:00 | AAPL | Stock | 26.4275 | 26.43 | 26.375 | 26.375 | 75928.0 |
| 2016-03-24 09:30:00 | AAPL | Stock | 26.3675 | 26.4725 | 26.36 | 26.465 | 3924220.0 |
| 2016-03-24 09:35:00 | AAPL | Stock | 26.4625 | 26.5625 | 26.4565 | 26.5075 | 2066148.0 |
| 2016-03-24 09:40:00 | AAPL | Stock | 26.5075 | 26.51 | 26.4318 | 26.45 | 1682072.0 |
| 2016-03-24 09:45:00 | AAPL | Stock | 26.4475 | 26.4675 | 26.39 | 26.3925 | 1754780.0 |
| 2016-03-24 09:50:00 | AAPL | Stock | 26.3938 | 26.4325 | 26.3725 | 26.3875 | 2500660.0 |
| 2016-03-24 09:55:00 | AAPL | Stock | 26.3875 | 26.4125 | 26.3538 | 26.4075 | 1750836.0 |
| 2016-03-24 10:00:00 | AAPL | Stock | 26.4075 | 26.43 | 26.3775 | 26.3898 | 1319560.0 |
| 2016-03-24 10:05:00 | AAPL | Stock | 26.39 | 26.4025 | 26.3675 | 26.37 | 1068144.0 |
| 2016-03-24 10:10:00 | AAPL | Stock | 26.3695 | 26.3725 | 26.315 | 26.34 | 2448476.0 |
| 2016-03-24 10:15:00 | AAPL | Stock | 26.341 | 26.345 | 26.295 | 26.298 | 2372808.0 |
| 2016-03-24 10:20:00 | AAPL | Stock | 26.2975 | 26.325 | 26.29 | 26.3075 | 1591684.0 |
| 2016-03-24 10:25:00 | AAPL | Stock | 26.3065 | 26.3138 | 26.2575 | 26.26 | 1523484.0 |
| 2016-03-24 10:30:00 | AAPL | Stock | 26.2585 | 26.2925 | 26.23 | 26.2375 | 2634580.0 |
| 2016-03-24 10:35:00 | AAPL | Stock | 26.24 | 26.255 | 26.2225 | 26.241 | 1987436.0 |
| 2016-03-24 10:40:00 | AAPL | Stock | 26.24 | 26.275 | 26.2325 | 26.2462 | 2092312.0 |
| 2016-03-24 10:45:00 | AAPL | Stock | 26.2462 | 26.28 | 26.246 | 26.2725 | 2167396.0 |
> showing 50 of 347,211 rows — these rows as CSV