PREVIEW / stock_5min / 2016-10-31
file: by_date/stock_5min/2016/2016-10-31.parquet size: 5.1 MB rows: 341,426 symbols: 3,205
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-31 04:00:00 | AAPL | Stock | 28.4725 | 28.475 | 28.4375 | 28.475 | 1864.0 |
| 2016-10-31 04:05:00 | AAPL | Stock | 28.44 | 28.44 | 28.35 | 28.35 | 3264.0 |
| 2016-10-31 05:00:00 | AAPL | Stock | 28.44 | 28.44 | 28.44 | 28.44 | 476.0 |
| 2016-10-31 05:20:00 | AAPL | Stock | 28.47 | 28.4875 | 28.47 | 28.4875 | 1100.0 |
| 2016-10-31 06:05:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.4375 | 28.4375 | 980.0 |
| 2016-10-31 06:20:00 | AAPL | Stock | 28.455 | 28.47 | 28.455 | 28.47 | 4800.0 |
| 2016-10-31 06:30:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.4375 | 28.4375 | 800.0 |
| 2016-10-31 07:00:00 | AAPL | Stock | 28.44 | 28.4425 | 28.4375 | 28.4375 | 9200.0 |
| 2016-10-31 07:10:00 | AAPL | Stock | 28.435 | 28.435 | 28.435 | 28.435 | 512.0 |
| 2016-10-31 07:15:00 | AAPL | Stock | 28.4375 | 28.45 | 28.43 | 28.43 | 12688.0 |
| 2016-10-31 07:20:00 | AAPL | Stock | 28.43 | 28.435 | 28.43 | 28.435 | 5200.0 |
| 2016-10-31 07:30:00 | AAPL | Stock | 28.43 | 28.43 | 28.43 | 28.43 | 800.0 |
| 2016-10-31 07:45:00 | AAPL | Stock | 28.43 | 28.43 | 28.43 | 28.43 | 808.0 |
| 2016-10-31 07:50:00 | AAPL | Stock | 28.44 | 28.44 | 28.4375 | 28.4375 | 3200.0 |
| 2016-10-31 07:55:00 | AAPL | Stock | 28.43 | 28.43 | 28.43 | 28.43 | 1992.0 |
| 2016-10-31 08:00:00 | AAPL | Stock | 28.445 | 28.445 | 28.4325 | 28.4375 | 26492.0 |
| 2016-10-31 08:05:00 | AAPL | Stock | 28.4375 | 28.4375 | 28.425 | 28.43 | 4560.0 |
| 2016-10-31 08:10:00 | AAPL | Stock | 28.43 | 28.43 | 28.43 | 28.43 | 3600.0 |
| 2016-10-31 08:15:00 | AAPL | Stock | 28.43 | 28.43 | 28.415 | 28.415 | 6580.0 |
| 2016-10-31 08:20:00 | AAPL | Stock | 28.41 | 28.4125 | 28.405 | 28.4125 | 25484.0 |
| 2016-10-31 08:25:00 | AAPL | Stock | 28.405 | 28.4125 | 28.405 | 28.41 | 24400.0 |
| 2016-10-31 08:30:00 | AAPL | Stock | 28.4175 | 28.4175 | 28.4075 | 28.4075 | 2524.0 |
| 2016-10-31 08:35:00 | AAPL | Stock | 28.42 | 28.4375 | 28.405 | 28.4375 | 5760.0 |
| 2016-10-31 08:40:00 | AAPL | Stock | 28.4425 | 28.45 | 28.4325 | 28.45 | 13136.0 |
| 2016-10-31 08:45:00 | AAPL | Stock | 28.45 | 28.45 | 28.445 | 28.445 | 29608.0 |
| 2016-10-31 08:50:00 | AAPL | Stock | 28.445 | 28.445 | 28.445 | 28.445 | 7712.0 |
| 2016-10-31 08:55:00 | AAPL | Stock | 28.4475 | 28.45 | 28.4325 | 28.45 | 4648.0 |
| 2016-10-31 09:00:00 | AAPL | Stock | 28.445 | 28.445 | 28.41 | 28.41 | 22976.0 |
| 2016-10-31 09:05:00 | AAPL | Stock | 28.4225 | 28.43 | 28.4225 | 28.43 | 5056.0 |
| 2016-10-31 09:10:00 | AAPL | Stock | 28.425 | 28.425 | 28.405 | 28.4125 | 51520.0 |
| 2016-10-31 09:15:00 | AAPL | Stock | 28.4125 | 28.4125 | 28.375 | 28.375 | 38768.0 |
| 2016-10-31 09:20:00 | AAPL | Stock | 28.3925 | 28.395 | 28.385 | 28.395 | 6364.0 |
| 2016-10-31 09:25:00 | AAPL | Stock | 28.3925 | 28.43 | 28.375 | 28.4125 | 71624.0 |
| 2016-10-31 09:30:00 | AAPL | Stock | 28.4125 | 28.485 | 28.3875 | 28.4125 | 5103864.0 |
| 2016-10-31 09:35:00 | AAPL | Stock | 28.4125 | 28.44 | 28.3625 | 28.3775 | 2591708.0 |
| 2016-10-31 09:40:00 | AAPL | Stock | 28.3788 | 28.3875 | 28.3 | 28.345 | 2687180.0 |
| 2016-10-31 09:45:00 | AAPL | Stock | 28.344 | 28.387 | 28.3375 | 28.3775 | 2077588.0 |
| 2016-10-31 09:50:00 | AAPL | Stock | 28.3775 | 28.38 | 28.3175 | 28.3225 | 2051640.0 |
| 2016-10-31 09:55:00 | AAPL | Stock | 28.3225 | 28.3672 | 28.3175 | 28.3225 | 1815684.0 |
| 2016-10-31 10:00:00 | AAPL | Stock | 28.3225 | 28.3675 | 28.315 | 28.3425 | 1389124.0 |
| 2016-10-31 10:05:00 | AAPL | Stock | 28.34 | 28.36 | 28.33 | 28.3475 | 1471760.0 |
| 2016-10-31 10:10:00 | AAPL | Stock | 28.35 | 28.395 | 28.3425 | 28.3775 | 1615112.0 |
| 2016-10-31 10:15:00 | AAPL | Stock | 28.375 | 28.4525 | 28.375 | 28.4388 | 1725320.0 |
| 2016-10-31 10:20:00 | AAPL | Stock | 28.4388 | 28.4675 | 28.4325 | 28.4525 | 1816352.0 |
| 2016-10-31 10:25:00 | AAPL | Stock | 28.4525 | 28.4625 | 28.45 | 28.4562 | 1476820.0 |
| 2016-10-31 10:30:00 | AAPL | Stock | 28.4575 | 28.4575 | 28.3958 | 28.3975 | 1380580.0 |
| 2016-10-31 10:35:00 | AAPL | Stock | 28.397 | 28.42 | 28.38 | 28.4175 | 1420604.0 |
| 2016-10-31 10:40:00 | AAPL | Stock | 28.415 | 28.4425 | 28.415 | 28.4425 | 1374988.0 |
| 2016-10-31 10:45:00 | AAPL | Stock | 28.44 | 28.45 | 28.4275 | 28.435 | 948772.0 |
| 2016-10-31 10:50:00 | AAPL | Stock | 28.435 | 28.465 | 28.425 | 28.4638 | 1560460.0 |
> showing 50 of 341,426 rows — these rows as CSV