PREVIEW / stock_5min / 2016-04-12
file: by_date/stock_5min/2016/2016-04-12.parquet size: 5.4 MB rows: 357,516 symbols: 3,345
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-04-12 04:45:00 | AAPL | Stock | 27.215 | 27.255 | 27.215 | 27.255 | 1200.0 |
| 2016-04-12 04:55:00 | AAPL | Stock | 27.23 | 27.23 | 27.23 | 27.23 | 400.0 |
| 2016-04-12 05:25:00 | AAPL | Stock | 27.29 | 27.295 | 27.29 | 27.295 | 2116.0 |
| 2016-04-12 05:50:00 | AAPL | Stock | 27.3375 | 27.3375 | 27.3375 | 27.3375 | 400.0 |
| 2016-04-12 06:20:00 | AAPL | Stock | 27.34 | 27.3425 | 27.34 | 27.3425 | 2800.0 |
| 2016-04-12 06:30:00 | AAPL | Stock | 27.3625 | 27.3625 | 27.3625 | 27.3625 | 400.0 |
| 2016-04-12 06:35:00 | AAPL | Stock | 27.3675 | 27.3675 | 27.3675 | 27.3675 | 704.0 |
| 2016-04-12 06:50:00 | AAPL | Stock | 27.35 | 27.35 | 27.3375 | 27.3375 | 10800.0 |
| 2016-04-12 06:55:00 | AAPL | Stock | 27.325 | 27.325 | 27.325 | 27.325 | 1200.0 |
| 2016-04-12 07:00:00 | AAPL | Stock | 27.3375 | 27.3575 | 27.3375 | 27.355 | 8200.0 |
| 2016-04-12 07:05:00 | AAPL | Stock | 27.3475 | 27.3475 | 27.3475 | 27.3475 | 1600.0 |
| 2016-04-12 07:10:00 | AAPL | Stock | 27.35 | 27.35 | 27.3375 | 27.3375 | 1680.0 |
| 2016-04-12 07:20:00 | AAPL | Stock | 27.29 | 27.29 | 27.285 | 27.285 | 10000.0 |
| 2016-04-12 07:25:00 | AAPL | Stock | 27.3125 | 27.3125 | 27.3125 | 27.3125 | 1460.0 |
| 2016-04-12 07:30:00 | AAPL | Stock | 27.3125 | 27.3125 | 27.3125 | 27.3125 | 400.0 |
| 2016-04-12 07:35:00 | AAPL | Stock | 27.3225 | 27.325 | 27.3225 | 27.325 | 8980.0 |
| 2016-04-12 07:50:00 | AAPL | Stock | 27.32 | 27.32 | 27.32 | 27.32 | 400.0 |
| 2016-04-12 08:00:00 | AAPL | Stock | 27.33 | 27.3375 | 27.31 | 27.3225 | 20052.0 |
| 2016-04-12 08:05:00 | AAPL | Stock | 27.325 | 27.35 | 27.32 | 27.345 | 25872.0 |
| 2016-04-12 08:10:00 | AAPL | Stock | 27.345 | 27.345 | 27.325 | 27.325 | 6444.0 |
| 2016-04-12 08:15:00 | AAPL | Stock | 27.335 | 27.35 | 27.335 | 27.345 | 25636.0 |
| 2016-04-12 08:20:00 | AAPL | Stock | 27.35 | 27.36 | 27.35 | 27.3575 | 17884.0 |
| 2016-04-12 08:25:00 | AAPL | Stock | 27.345 | 27.345 | 27.345 | 27.345 | 3176.0 |
| 2016-04-12 08:30:00 | AAPL | Stock | 27.345 | 27.35 | 27.345 | 27.345 | 11400.0 |
| 2016-04-12 08:35:00 | AAPL | Stock | 27.3525 | 27.3625 | 27.3525 | 27.3625 | 5000.0 |
| 2016-04-12 08:40:00 | AAPL | Stock | 27.3625 | 27.38 | 27.35 | 27.38 | 33232.0 |
| 2016-04-12 08:45:00 | AAPL | Stock | 27.375 | 27.4125 | 27.375 | 27.4125 | 44440.0 |
| 2016-04-12 08:50:00 | AAPL | Stock | 27.375 | 27.375 | 27.3625 | 27.3625 | 7628.0 |
| 2016-04-12 08:55:00 | AAPL | Stock | 27.3625 | 27.365 | 27.3575 | 27.365 | 20080.0 |
| 2016-04-12 09:00:00 | AAPL | Stock | 27.36 | 27.3675 | 27.35 | 27.36 | 54472.0 |
| 2016-04-12 09:05:00 | AAPL | Stock | 27.36 | 27.375 | 27.36 | 27.3725 | 6960.0 |
| 2016-04-12 09:10:00 | AAPL | Stock | 27.3725 | 27.3725 | 27.3475 | 27.36 | 27588.0 |
| 2016-04-12 09:15:00 | AAPL | Stock | 27.35 | 27.375 | 27.35 | 27.3725 | 26960.0 |
| 2016-04-12 09:20:00 | AAPL | Stock | 27.3625 | 27.4075 | 27.3625 | 27.3875 | 84288.0 |
| 2016-04-12 09:25:00 | AAPL | Stock | 27.39 | 27.4125 | 27.3475 | 27.3475 | 115960.0 |
| 2016-04-12 09:30:00 | AAPL | Stock | 27.3425 | 27.4375 | 27.3025 | 27.3038 | 5062672.0 |
| 2016-04-12 09:35:00 | AAPL | Stock | 27.3038 | 27.5025 | 27.2925 | 27.3975 | 4088692.0 |
| 2016-04-12 09:40:00 | AAPL | Stock | 27.395 | 27.45 | 27.3375 | 27.435 | 2250336.0 |
| 2016-04-12 09:45:00 | AAPL | Stock | 27.4375 | 27.475 | 27.4025 | 27.42 | 2095824.0 |
| 2016-04-12 09:50:00 | AAPL | Stock | 27.4175 | 27.425 | 27.3625 | 27.3875 | 1673240.0 |
| 2016-04-12 09:55:00 | AAPL | Stock | 27.3875 | 27.3875 | 27.28 | 27.2825 | 1784252.0 |
| 2016-04-12 10:00:00 | AAPL | Stock | 27.285 | 27.3475 | 27.285 | 27.29 | 1667764.0 |
| 2016-04-12 10:05:00 | AAPL | Stock | 27.29 | 27.29 | 27.1952 | 27.1975 | 2090652.0 |
| 2016-04-12 10:10:00 | AAPL | Stock | 27.195 | 27.235 | 27.1752 | 27.23 | 1954948.0 |
| 2016-04-12 10:15:00 | AAPL | Stock | 27.2312 | 27.2325 | 27.175 | 27.21 | 1678032.0 |
| 2016-04-12 10:20:00 | AAPL | Stock | 27.2075 | 27.2125 | 27.165 | 27.1825 | 1352892.0 |
| 2016-04-12 10:25:00 | AAPL | Stock | 27.1825 | 27.235 | 27.1825 | 27.2175 | 1251268.0 |
| 2016-04-12 10:30:00 | AAPL | Stock | 27.2128 | 27.3375 | 27.2075 | 27.2875 | 3137972.0 |
| 2016-04-12 10:35:00 | AAPL | Stock | 27.286 | 27.345 | 27.2775 | 27.2925 | 2403616.0 |
| 2016-04-12 10:40:00 | AAPL | Stock | 27.29 | 27.35 | 27.2875 | 27.3425 | 1330592.0 |
> showing 50 of 357,516 rows — these rows as CSV