PREVIEW / stock_5min / 2016-10-05
file: by_date/stock_5min/2016/2016-10-05.parquet size: 5.3 MB rows: 347,200 symbols: 3,194
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-10-05 04:00:00 | AAPL | Stock | 28.5725 | 28.5725 | 28.5725 | 28.5725 | 400.0 |
| 2016-10-05 04:50:00 | AAPL | Stock | 28.2875 | 28.2875 | 28.2875 | 28.2875 | 504.0 |
| 2016-10-05 05:25:00 | AAPL | Stock | 28.3075 | 28.3425 | 28.3075 | 28.3425 | 3688.0 |
| 2016-10-05 07:10:00 | AAPL | Stock | 28.2775 | 28.31 | 28.2725 | 28.31 | 5520.0 |
| 2016-10-05 07:15:00 | AAPL | Stock | 28.31 | 28.31 | 28.31 | 28.31 | 880.0 |
| 2016-10-05 07:20:00 | AAPL | Stock | 28.315 | 28.315 | 28.315 | 28.315 | 400.0 |
| 2016-10-05 07:25:00 | AAPL | Stock | 28.315 | 28.315 | 28.31 | 28.31 | 1600.0 |
| 2016-10-05 07:30:00 | AAPL | Stock | 28.3225 | 28.3225 | 28.31 | 28.31 | 2760.0 |
| 2016-10-05 07:35:00 | AAPL | Stock | 28.3075 | 28.31 | 28.3075 | 28.31 | 2000.0 |
| 2016-10-05 07:40:00 | AAPL | Stock | 28.31 | 28.33 | 28.31 | 28.33 | 800.0 |
| 2016-10-05 07:45:00 | AAPL | Stock | 28.33 | 28.335 | 28.3125 | 28.3125 | 7964.0 |
| 2016-10-05 07:55:00 | AAPL | Stock | 28.3225 | 28.3325 | 28.3225 | 28.3325 | 7200.0 |
| 2016-10-05 08:00:00 | AAPL | Stock | 28.325 | 28.325 | 28.1875 | 28.305 | 43508.0 |
| 2016-10-05 08:05:00 | AAPL | Stock | 28.3125 | 28.3225 | 28.305 | 28.3225 | 3760.0 |
| 2016-10-05 08:10:00 | AAPL | Stock | 28.3225 | 28.325 | 28.3 | 28.3 | 14660.0 |
| 2016-10-05 08:15:00 | AAPL | Stock | 28.315 | 28.3325 | 28.315 | 28.315 | 6892.0 |
| 2016-10-05 08:20:00 | AAPL | Stock | 28.315 | 28.3375 | 28.315 | 28.3325 | 5132.0 |
| 2016-10-05 08:25:00 | AAPL | Stock | 28.3425 | 28.35 | 28.305 | 28.305 | 17784.0 |
| 2016-10-05 08:30:00 | AAPL | Stock | 28.3125 | 28.34 | 28.3125 | 28.325 | 4840.0 |
| 2016-10-05 08:35:00 | AAPL | Stock | 28.32 | 28.3275 | 28.32 | 28.3275 | 3200.0 |
| 2016-10-05 08:45:00 | AAPL | Stock | 28.3425 | 28.3425 | 28.325 | 28.325 | 9400.0 |
| 2016-10-05 08:50:00 | AAPL | Stock | 28.3075 | 28.33 | 28.3075 | 28.33 | 2320.0 |
| 2016-10-05 08:55:00 | AAPL | Stock | 28.325 | 28.35 | 28.325 | 28.35 | 13328.0 |
| 2016-10-05 09:00:00 | AAPL | Stock | 28.35 | 28.355 | 28.3375 | 28.3425 | 17988.0 |
| 2016-10-05 09:05:00 | AAPL | Stock | 28.3425 | 28.3475 | 28.3325 | 28.3475 | 46800.0 |
| 2016-10-05 09:10:00 | AAPL | Stock | 28.3625 | 28.3875 | 28.3625 | 28.3875 | 24000.0 |
| 2016-10-05 09:15:00 | AAPL | Stock | 28.3825 | 28.4 | 28.375 | 28.4 | 63300.0 |
| 2016-10-05 09:20:00 | AAPL | Stock | 28.39 | 28.395 | 28.365 | 28.365 | 17600.0 |
| 2016-10-05 09:25:00 | AAPL | Stock | 28.365 | 28.385 | 28.35 | 28.3675 | 63496.0 |
| 2016-10-05 09:30:00 | AAPL | Stock | 28.35 | 28.415 | 28.255 | 28.2625 | 4379876.0 |
| 2016-10-05 09:35:00 | AAPL | Stock | 28.2625 | 28.355 | 28.23 | 28.245 | 2777572.0 |
| 2016-10-05 09:40:00 | AAPL | Stock | 28.2425 | 28.2725 | 28.2175 | 28.2212 | 1915724.0 |
| 2016-10-05 09:45:00 | AAPL | Stock | 28.225 | 28.31 | 28.2125 | 28.2912 | 1853656.0 |
| 2016-10-05 09:50:00 | AAPL | Stock | 28.295 | 28.325 | 28.2875 | 28.3125 | 1188132.0 |
| 2016-10-05 09:55:00 | AAPL | Stock | 28.315 | 28.3325 | 28.2975 | 28.3225 | 1001168.0 |
| 2016-10-05 10:00:00 | AAPL | Stock | 28.325 | 28.35 | 28.3025 | 28.3412 | 1245844.0 |
| 2016-10-05 10:05:00 | AAPL | Stock | 28.34 | 28.3675 | 28.3325 | 28.35 | 1191664.0 |
| 2016-10-05 10:10:00 | AAPL | Stock | 28.3512 | 28.3525 | 28.3075 | 28.3112 | 1419736.0 |
| 2016-10-05 10:15:00 | AAPL | Stock | 28.31 | 28.3325 | 28.31 | 28.325 | 783652.0 |
| 2016-10-05 10:20:00 | AAPL | Stock | 28.325 | 28.3275 | 28.2725 | 28.2925 | 1550792.0 |
| 2016-10-05 10:25:00 | AAPL | Stock | 28.292 | 28.3062 | 28.255 | 28.285 | 1519804.0 |
| 2016-10-05 10:30:00 | AAPL | Stock | 28.2825 | 28.285 | 28.2325 | 28.2825 | 1833692.0 |
| 2016-10-05 10:35:00 | AAPL | Stock | 28.285 | 28.295 | 28.2725 | 28.2762 | 862192.0 |
| 2016-10-05 10:40:00 | AAPL | Stock | 28.2762 | 28.29 | 28.22 | 28.2212 | 1309428.0 |
| 2016-10-05 10:45:00 | AAPL | Stock | 28.2212 | 28.2375 | 28.1725 | 28.1725 | 1628340.0 |
| 2016-10-05 10:50:00 | AAPL | Stock | 28.175 | 28.2108 | 28.1728 | 28.195 | 1304864.0 |
| 2016-10-05 10:55:00 | AAPL | Stock | 28.195 | 28.2348 | 28.195 | 28.2325 | 860216.0 |
| 2016-10-05 11:00:00 | AAPL | Stock | 28.23 | 28.2525 | 28.22 | 28.25 | 772108.0 |
| 2016-10-05 11:05:00 | AAPL | Stock | 28.2488 | 28.255 | 28.2375 | 28.255 | 613468.0 |
| 2016-10-05 11:10:00 | AAPL | Stock | 28.2548 | 28.2635 | 28.235 | 28.2575 | 689376.0 |
> showing 50 of 347,200 rows — these rows as CSV