PREVIEW / stock_5min / 2016-11-09
file: by_date/stock_5min/2016/2016-11-09.parquet size: 5.8 MB rows: 374,023 symbols: 3,179
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-11-09 04:00:00 | AAPL | Stock | 26.9975 | 27.15 | 26.925 | 27.15 | 261332.0 |
| 2016-11-09 04:05:00 | AAPL | Stock | 27.15 | 27.2 | 27.125 | 27.155 | 31196.0 |
| 2016-11-09 04:10:00 | AAPL | Stock | 27.135 | 27.2625 | 27.125 | 27.2625 | 118816.0 |
| 2016-11-09 04:15:00 | AAPL | Stock | 27.2 | 27.2 | 27.125 | 27.1275 | 10872.0 |
| 2016-11-09 04:20:00 | AAPL | Stock | 27.155 | 27.205 | 27.145 | 27.2 | 38960.0 |
| 2016-11-09 04:25:00 | AAPL | Stock | 27.1225 | 27.1225 | 27.1225 | 27.1225 | 1308.0 |
| 2016-11-09 04:30:00 | AAPL | Stock | 27.1125 | 27.2 | 27.1125 | 27.2 | 9904.0 |
| 2016-11-09 04:35:00 | AAPL | Stock | 27.1825 | 27.2 | 27.1775 | 27.2 | 18896.0 |
| 2016-11-09 04:40:00 | AAPL | Stock | 27.25 | 27.25 | 27.1875 | 27.25 | 32412.0 |
| 2016-11-09 04:45:00 | AAPL | Stock | 27.25 | 27.265 | 27.25 | 27.265 | 4192.0 |
| 2016-11-09 04:50:00 | AAPL | Stock | 27.3175 | 27.3175 | 27.3175 | 27.3175 | 2004.0 |
| 2016-11-09 04:55:00 | AAPL | Stock | 27.2825 | 27.2825 | 27.27 | 27.275 | 2000.0 |
| 2016-11-09 05:00:00 | AAPL | Stock | 27.25 | 27.2525 | 27.225 | 27.225 | 59376.0 |
| 2016-11-09 05:05:00 | AAPL | Stock | 27.2 | 27.2 | 27.2 | 27.2 | 1200.0 |
| 2016-11-09 05:15:00 | AAPL | Stock | 27.2 | 27.205 | 27.2 | 27.2 | 16280.0 |
| 2016-11-09 05:20:00 | AAPL | Stock | 27.2 | 27.2025 | 27.1875 | 27.2 | 32340.0 |
| 2016-11-09 05:25:00 | AAPL | Stock | 27.215 | 27.24 | 27.215 | 27.24 | 3708.0 |
| 2016-11-09 05:30:00 | AAPL | Stock | 27.295 | 27.305 | 27.2875 | 27.305 | 7060.0 |
| 2016-11-09 05:35:00 | AAPL | Stock | 27.2925 | 27.315 | 27.27 | 27.27 | 57956.0 |
| 2016-11-09 05:45:00 | AAPL | Stock | 27.2775 | 27.2775 | 27.25 | 27.25 | 12480.0 |
| 2016-11-09 05:50:00 | AAPL | Stock | 27.22 | 27.22 | 27.2125 | 27.2125 | 7616.0 |
| 2016-11-09 05:55:00 | AAPL | Stock | 27.25 | 27.25 | 27.2275 | 27.2275 | 23460.0 |
| 2016-11-09 06:00:00 | AAPL | Stock | 27.25 | 27.25 | 27.1925 | 27.225 | 32588.0 |
| 2016-11-09 06:05:00 | AAPL | Stock | 27.19 | 27.19 | 27.1625 | 27.175 | 21896.0 |
| 2016-11-09 06:10:00 | AAPL | Stock | 27.175 | 27.1775 | 27.15 | 27.15 | 60504.0 |
| 2016-11-09 06:15:00 | AAPL | Stock | 27.15 | 27.15 | 27.13 | 27.13 | 28276.0 |
| 2016-11-09 06:20:00 | AAPL | Stock | 27.13 | 27.1375 | 27.0775 | 27.1125 | 80944.0 |
| 2016-11-09 06:25:00 | AAPL | Stock | 27.115 | 27.1275 | 27.1 | 27.1 | 118532.0 |
| 2016-11-09 06:30:00 | AAPL | Stock | 27.115 | 27.125 | 27.0875 | 27.125 | 60592.0 |
| 2016-11-09 06:35:00 | AAPL | Stock | 27.1275 | 27.175 | 27.1275 | 27.175 | 25040.0 |
| 2016-11-09 06:40:00 | AAPL | Stock | 27.185 | 27.185 | 27.175 | 27.175 | 1600.0 |
| 2016-11-09 06:45:00 | AAPL | Stock | 27.1525 | 27.1525 | 27.125 | 27.15 | 24500.0 |
| 2016-11-09 06:50:00 | AAPL | Stock | 27.155 | 27.175 | 27.1525 | 27.155 | 5840.0 |
| 2016-11-09 06:55:00 | AAPL | Stock | 27.1525 | 27.1525 | 27.14 | 27.14 | 5200.0 |
| 2016-11-09 07:00:00 | AAPL | Stock | 27.1625 | 27.175 | 27.125 | 27.13 | 91028.0 |
| 2016-11-09 07:05:00 | AAPL | Stock | 27.1625 | 27.2375 | 27.1625 | 27.215 | 59248.0 |
| 2016-11-09 07:10:00 | AAPL | Stock | 27.2125 | 27.2325 | 27.1875 | 27.2125 | 67096.0 |
| 2016-11-09 07:15:00 | AAPL | Stock | 27.225 | 27.3725 | 27.1875 | 27.26 | 153568.0 |
| 2016-11-09 07:20:00 | AAPL | Stock | 27.2625 | 27.375 | 27.2275 | 27.375 | 100696.0 |
| 2016-11-09 07:25:00 | AAPL | Stock | 27.3325 | 27.4025 | 27.325 | 27.4025 | 132268.0 |
| 2016-11-09 07:30:00 | AAPL | Stock | 27.4075 | 27.45 | 27.3775 | 27.4375 | 105152.0 |
| 2016-11-09 07:35:00 | AAPL | Stock | 27.45 | 27.4625 | 27.415 | 27.4625 | 49072.0 |
| 2016-11-09 07:40:00 | AAPL | Stock | 27.45 | 27.4675 | 27.4125 | 27.425 | 33112.0 |
| 2016-11-09 07:45:00 | AAPL | Stock | 27.44 | 27.4975 | 27.425 | 27.4975 | 41072.0 |
| 2016-11-09 07:50:00 | AAPL | Stock | 27.4825 | 27.5425 | 27.475 | 27.5025 | 193076.0 |
| 2016-11-09 07:55:00 | AAPL | Stock | 27.5025 | 27.55 | 27.5 | 27.55 | 94680.0 |
| 2016-11-09 08:00:00 | AAPL | Stock | 27.545 | 27.6475 | 27.075 | 27.6325 | 1240384.0 |
| 2016-11-09 08:05:00 | AAPL | Stock | 27.6275 | 27.6425 | 27.5325 | 27.5325 | 116256.0 |
| 2016-11-09 08:10:00 | AAPL | Stock | 27.5325 | 27.5875 | 27.5 | 27.5625 | 189376.0 |
| 2016-11-09 08:15:00 | AAPL | Stock | 27.57 | 27.6125 | 27.5125 | 27.5125 | 258136.0 |
> showing 50 of 374,023 rows — these rows as CSV