PREVIEW / stock_5min / 2016-08-15
file: by_date/stock_5min/2016/2016-08-15.parquet size: 5.4 MB rows: 354,585 symbols: 3,280
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-08-15 04:40:00 | AAPL | Stock | 27.1175 | 27.12 | 27.1175 | 27.12 | 4000.0 |
| 2016-08-15 05:00:00 | AAPL | Stock | 27.1025 | 27.1025 | 27.0825 | 27.0825 | 2256.0 |
| 2016-08-15 06:50:00 | AAPL | Stock | 27.1075 | 27.1075 | 27.1075 | 27.1075 | 1144.0 |
| 2016-08-15 06:55:00 | AAPL | Stock | 27.1025 | 27.1025 | 27.1025 | 27.1025 | 3000.0 |
| 2016-08-15 07:10:00 | AAPL | Stock | 27.12 | 27.12 | 27.12 | 27.12 | 800.0 |
| 2016-08-15 07:15:00 | AAPL | Stock | 27.1025 | 27.1025 | 27.1025 | 27.1025 | 800.0 |
| 2016-08-15 07:20:00 | AAPL | Stock | 27.1025 | 27.1025 | 27.1025 | 27.1025 | 4000.0 |
| 2016-08-15 07:35:00 | AAPL | Stock | 27.1075 | 27.1075 | 27.1075 | 27.1075 | 2000.0 |
| 2016-08-15 07:40:00 | AAPL | Stock | 27.1125 | 27.1175 | 27.1125 | 27.1175 | 1200.0 |
| 2016-08-15 07:45:00 | AAPL | Stock | 27.1175 | 27.1175 | 27.1125 | 27.1125 | 5200.0 |
| 2016-08-15 08:00:00 | AAPL | Stock | 27.12 | 27.12 | 27.1025 | 27.1175 | 56232.0 |
| 2016-08-15 08:05:00 | AAPL | Stock | 27.1125 | 27.115 | 27.11 | 27.11 | 28200.0 |
| 2016-08-15 08:10:00 | AAPL | Stock | 27.1125 | 27.1125 | 27.105 | 27.105 | 8720.0 |
| 2016-08-15 08:15:00 | AAPL | Stock | 27.1025 | 27.1025 | 27.1025 | 27.1025 | 2040.0 |
| 2016-08-15 08:20:00 | AAPL | Stock | 27.105 | 27.1075 | 27.1025 | 27.1075 | 6800.0 |
| 2016-08-15 08:25:00 | AAPL | Stock | 27.1075 | 27.1075 | 27.1 | 27.1 | 15220.0 |
| 2016-08-15 08:30:00 | AAPL | Stock | 27.1 | 27.105 | 27.1 | 27.105 | 14400.0 |
| 2016-08-15 08:35:00 | AAPL | Stock | 27.105 | 27.1125 | 27.105 | 27.11 | 16972.0 |
| 2016-08-15 08:40:00 | AAPL | Stock | 27.115 | 27.125 | 27.115 | 27.12 | 26888.0 |
| 2016-08-15 08:45:00 | AAPL | Stock | 27.1225 | 27.1225 | 27.1175 | 27.1175 | 10564.0 |
| 2016-08-15 08:50:00 | AAPL | Stock | 27.1175 | 27.1175 | 27.1175 | 27.1175 | 3372.0 |
| 2016-08-15 08:55:00 | AAPL | Stock | 27.115 | 27.1175 | 27.11 | 27.1125 | 39080.0 |
| 2016-08-15 09:00:00 | AAPL | Stock | 27.1075 | 27.115 | 27.1075 | 27.1125 | 6240.0 |
| 2016-08-15 09:05:00 | AAPL | Stock | 27.1125 | 27.115 | 27.11 | 27.115 | 14000.0 |
| 2016-08-15 09:10:00 | AAPL | Stock | 27.1125 | 27.1125 | 27.1125 | 27.1125 | 9000.0 |
| 2016-08-15 09:15:00 | AAPL | Stock | 27.1075 | 27.1075 | 27.09 | 27.1 | 32044.0 |
| 2016-08-15 09:20:00 | AAPL | Stock | 27.1 | 27.1 | 27.09 | 27.09 | 9564.0 |
| 2016-08-15 09:25:00 | AAPL | Stock | 27.075 | 27.1 | 27.0375 | 27.0375 | 84868.0 |
| 2016-08-15 09:30:00 | AAPL | Stock | 27.035 | 27.1925 | 27.02 | 27.19 | 4998532.0 |
| 2016-08-15 09:35:00 | AAPL | Stock | 27.19 | 27.225 | 27.1825 | 27.195 | 2914912.0 |
| 2016-08-15 09:40:00 | AAPL | Stock | 27.1975 | 27.235 | 27.1775 | 27.2175 | 2609320.0 |
| 2016-08-15 09:45:00 | AAPL | Stock | 27.2175 | 27.2525 | 27.2172 | 27.2475 | 3886272.0 |
| 2016-08-15 09:50:00 | AAPL | Stock | 27.2475 | 27.2875 | 27.2475 | 27.2688 | 3445360.0 |
| 2016-08-15 09:55:00 | AAPL | Stock | 27.27 | 27.2925 | 27.2288 | 27.2375 | 2781024.0 |
| 2016-08-15 10:00:00 | AAPL | Stock | 27.2398 | 27.27 | 27.2375 | 27.2575 | 2033268.0 |
| 2016-08-15 10:05:00 | AAPL | Stock | 27.2575 | 27.2825 | 27.245 | 27.2625 | 1494464.0 |
| 2016-08-15 10:10:00 | AAPL | Stock | 27.2638 | 27.2812 | 27.245 | 27.2762 | 1525584.0 |
| 2016-08-15 10:15:00 | AAPL | Stock | 27.275 | 27.31 | 27.275 | 27.3025 | 1727548.0 |
| 2016-08-15 10:20:00 | AAPL | Stock | 27.305 | 27.3375 | 27.3025 | 27.3302 | 1729768.0 |
| 2016-08-15 10:25:00 | AAPL | Stock | 27.33 | 27.3625 | 27.3225 | 27.33 | 1868084.0 |
| 2016-08-15 10:30:00 | AAPL | Stock | 27.33 | 27.3548 | 27.3275 | 27.3338 | 1151344.0 |
| 2016-08-15 10:35:00 | AAPL | Stock | 27.3325 | 27.3345 | 27.3188 | 27.3275 | 1116996.0 |
| 2016-08-15 10:40:00 | AAPL | Stock | 27.33 | 27.3525 | 27.3275 | 27.33 | 974644.0 |
| 2016-08-15 10:45:00 | AAPL | Stock | 27.33 | 27.34 | 27.3112 | 27.3138 | 965648.0 |
| 2016-08-15 10:50:00 | AAPL | Stock | 27.315 | 27.32 | 27.295 | 27.3125 | 1150172.0 |
| 2016-08-15 10:55:00 | AAPL | Stock | 27.315 | 27.32 | 27.3 | 27.3188 | 791084.0 |
| 2016-08-15 11:00:00 | AAPL | Stock | 27.3178 | 27.3225 | 27.3075 | 27.3125 | 734672.0 |
| 2016-08-15 11:05:00 | AAPL | Stock | 27.315 | 27.3168 | 27.305 | 27.3085 | 541052.0 |
| 2016-08-15 11:10:00 | AAPL | Stock | 27.3075 | 27.3275 | 27.3025 | 27.325 | 909436.0 |
| 2016-08-15 11:15:00 | AAPL | Stock | 27.325 | 27.3525 | 27.325 | 27.3512 | 1039588.0 |
> showing 50 of 354,585 rows — these rows as CSV