PREVIEW / stock_5min / 2015-09-28
file: by_date/stock_5min/2015/2015-09-28.parquet size: 5.6 MB rows: 370,286 symbols: 3,459
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 |
|---|---|---|---|---|---|---|---|
| 2015-09-28 04:00:00 | AAPL | Stock | 28.6775 | 28.6775 | 28.6775 | 28.6775 | 800.0 |
| 2015-09-28 04:25:00 | AAPL | Stock | 28.7625 | 28.7625 | 28.7625 | 28.7625 | 400.0 |
| 2015-09-28 04:30:00 | AAPL | Stock | 28.7425 | 28.7425 | 28.72 | 28.7325 | 10016.0 |
| 2015-09-28 04:35:00 | AAPL | Stock | 28.6775 | 28.6775 | 28.6775 | 28.6775 | 400.0 |
| 2015-09-28 04:40:00 | AAPL | Stock | 28.675 | 28.6775 | 28.675 | 28.675 | 6800.0 |
| 2015-09-28 04:45:00 | AAPL | Stock | 28.7025 | 28.7025 | 28.7025 | 28.7025 | 800.0 |
| 2015-09-28 04:55:00 | AAPL | Stock | 28.6525 | 28.6525 | 28.6525 | 28.6525 | 400.0 |
| 2015-09-28 05:20:00 | AAPL | Stock | 28.575 | 28.6125 | 28.575 | 28.6 | 4000.0 |
| 2015-09-28 05:30:00 | AAPL | Stock | 28.59 | 28.59 | 28.5625 | 28.5625 | 11508.0 |
| 2015-09-28 05:35:00 | AAPL | Stock | 28.5475 | 28.5475 | 28.5275 | 28.5275 | 21292.0 |
| 2015-09-28 05:40:00 | AAPL | Stock | 28.5725 | 28.5725 | 28.5725 | 28.5725 | 1200.0 |
| 2015-09-28 05:45:00 | AAPL | Stock | 28.55 | 28.55 | 28.55 | 28.55 | 1600.0 |
| 2015-09-28 05:50:00 | AAPL | Stock | 28.55 | 28.55 | 28.55 | 28.55 | 400.0 |
| 2015-09-28 06:20:00 | AAPL | Stock | 28.55 | 28.55 | 28.55 | 28.55 | 760.0 |
| 2015-09-28 07:00:00 | AAPL | Stock | 28.475 | 28.5 | 28.475 | 28.5 | 7200.0 |
| 2015-09-28 07:05:00 | AAPL | Stock | 28.5125 | 28.525 | 28.5125 | 28.525 | 6552.0 |
| 2015-09-28 07:10:00 | AAPL | Stock | 28.5125 | 28.5125 | 28.5125 | 28.5125 | 2400.0 |
| 2015-09-28 07:15:00 | AAPL | Stock | 28.5075 | 28.525 | 28.505 | 28.525 | 3720.0 |
| 2015-09-28 07:30:00 | AAPL | Stock | 28.5625 | 28.5625 | 28.5625 | 28.5625 | 400.0 |
| 2015-09-28 07:35:00 | AAPL | Stock | 28.555 | 28.5625 | 28.515 | 28.515 | 36372.0 |
| 2015-09-28 07:40:00 | AAPL | Stock | 28.5375 | 28.55 | 28.5 | 28.5 | 25752.0 |
| 2015-09-28 07:45:00 | AAPL | Stock | 28.5 | 28.5 | 28.47 | 28.47 | 14600.0 |
| 2015-09-28 07:50:00 | AAPL | Stock | 28.475 | 28.5125 | 28.475 | 28.5125 | 14400.0 |
| 2015-09-28 07:55:00 | AAPL | Stock | 28.525 | 28.525 | 28.515 | 28.515 | 10400.0 |
| 2015-09-28 08:00:00 | AAPL | Stock | 28.5225 | 28.5725 | 28.475 | 28.515 | 93816.0 |
| 2015-09-28 08:05:00 | AAPL | Stock | 28.5325 | 28.5675 | 28.5325 | 28.55 | 31916.0 |
| 2015-09-28 08:10:00 | AAPL | Stock | 28.545 | 28.5675 | 28.545 | 28.555 | 16504.0 |
| 2015-09-28 08:15:00 | AAPL | Stock | 28.555 | 28.5575 | 28.545 | 28.555 | 34600.0 |
| 2015-09-28 08:20:00 | AAPL | Stock | 28.555 | 28.555 | 28.495 | 28.495 | 235852.0 |
| 2015-09-28 08:25:00 | AAPL | Stock | 28.4875 | 28.515 | 28.455 | 28.4625 | 152412.0 |
| 2015-09-28 08:30:00 | AAPL | Stock | 28.4625 | 28.7615 | 28.4575 | 28.6875 | 1833604.0 |
| 2015-09-28 08:35:00 | AAPL | Stock | 28.6725 | 28.7925 | 28.65 | 28.7225 | 680796.0 |
| 2015-09-28 08:40:00 | AAPL | Stock | 28.695 | 28.7575 | 28.6675 | 28.6825 | 409720.0 |
| 2015-09-28 08:45:00 | AAPL | Stock | 28.6925 | 28.6925 | 28.575 | 28.68 | 260600.0 |
| 2015-09-28 08:50:00 | AAPL | Stock | 28.68 | 28.7125 | 28.65 | 28.675 | 572120.0 |
| 2015-09-28 08:55:00 | AAPL | Stock | 28.675 | 28.6775 | 28.6325 | 28.65 | 128760.0 |
| 2015-09-28 09:00:00 | AAPL | Stock | 28.6675 | 28.75 | 28.65 | 28.745 | 202860.0 |
| 2015-09-28 09:05:00 | AAPL | Stock | 28.7375 | 28.7375 | 28.645 | 28.6725 | 174696.0 |
| 2015-09-28 09:10:00 | AAPL | Stock | 28.6625 | 28.6725 | 28.5875 | 28.615 | 213452.0 |
| 2015-09-28 09:15:00 | AAPL | Stock | 28.615 | 28.6225 | 28.55 | 28.57 | 113916.0 |
| 2015-09-28 09:20:00 | AAPL | Stock | 28.5625 | 28.5675 | 28.5275 | 28.535 | 208672.0 |
| 2015-09-28 09:25:00 | AAPL | Stock | 28.5325 | 28.535 | 28.425 | 28.46 | 517604.0 |
| 2015-09-28 09:30:00 | AAPL | Stock | 28.4625 | 28.515 | 28.375 | 28.485 | 8493156.0 |
| 2015-09-28 09:35:00 | AAPL | Stock | 28.485 | 28.6425 | 28.4525 | 28.495 | 5172640.0 |
| 2015-09-28 09:40:00 | AAPL | Stock | 28.4825 | 28.515 | 28.4175 | 28.435 | 4325856.0 |
| 2015-09-28 09:45:00 | AAPL | Stock | 28.4325 | 28.4675 | 28.2175 | 28.27 | 7385212.0 |
| 2015-09-28 09:50:00 | AAPL | Stock | 28.2688 | 28.2725 | 28.1875 | 28.1942 | 5081720.0 |
| 2015-09-28 09:55:00 | AAPL | Stock | 28.1932 | 28.25 | 28.1575 | 28.17 | 3689488.0 |
| 2015-09-28 10:00:00 | AAPL | Stock | 28.163 | 28.2125 | 28.1538 | 28.191 | 3219864.0 |
| 2015-09-28 10:05:00 | AAPL | Stock | 28.1912 | 28.2238 | 28.1375 | 28.1375 | 3741136.0 |
> showing 50 of 370,286 rows — these rows as CSV