PREVIEW / stock_5min / 2014-11-26
file: by_date/stock_5min/2014/2014-11-26.parquet size: 5.2 MB rows: 351,992 symbols: 3,567
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 |
|---|---|---|---|---|---|---|---|
| 2014-11-26 04:00:00 | AAPL | Stock | 29.5 | 29.555 | 29.5 | 29.505 | 13440.0 |
| 2014-11-26 04:10:00 | AAPL | Stock | 29.505 | 29.505 | 29.505 | 29.505 | 1400.0 |
| 2014-11-26 04:15:00 | AAPL | Stock | 29.51 | 29.51 | 29.51 | 29.51 | 2000.0 |
| 2014-11-26 04:20:00 | AAPL | Stock | 29.525 | 29.5275 | 29.525 | 29.5275 | 2200.0 |
| 2014-11-26 04:25:00 | AAPL | Stock | 29.5275 | 29.5275 | 29.51 | 29.51 | 2400.0 |
| 2014-11-26 04:35:00 | AAPL | Stock | 29.5125 | 29.515 | 29.5125 | 29.515 | 10240.0 |
| 2014-11-26 04:40:00 | AAPL | Stock | 29.5025 | 29.51 | 29.5025 | 29.51 | 3000.0 |
| 2014-11-26 04:50:00 | AAPL | Stock | 29.5125 | 29.5125 | 29.5125 | 29.5125 | 2400.0 |
| 2014-11-26 04:55:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 4000.0 |
| 2014-11-26 05:00:00 | AAPL | Stock | 29.4975 | 29.4975 | 29.4975 | 29.4975 | 400.0 |
| 2014-11-26 05:25:00 | AAPL | Stock | 29.4775 | 29.5 | 29.475 | 29.5 | 3800.0 |
| 2014-11-26 05:40:00 | AAPL | Stock | 29.4875 | 29.4875 | 29.4875 | 29.4875 | 3648.0 |
| 2014-11-26 05:50:00 | AAPL | Stock | 29.5025 | 29.5025 | 29.5025 | 29.5025 | 1332.0 |
| 2014-11-26 05:55:00 | AAPL | Stock | 29.475 | 29.475 | 29.4675 | 29.475 | 6000.0 |
| 2014-11-26 06:00:00 | AAPL | Stock | 29.465 | 29.475 | 29.4625 | 29.475 | 12084.0 |
| 2014-11-26 06:05:00 | AAPL | Stock | 29.475 | 29.475 | 29.475 | 29.475 | 29152.0 |
| 2014-11-26 06:10:00 | AAPL | Stock | 29.475 | 29.475 | 29.475 | 29.475 | 400.0 |
| 2014-11-26 06:15:00 | AAPL | Stock | 29.4625 | 29.475 | 29.4625 | 29.475 | 1200.0 |
| 2014-11-26 06:20:00 | AAPL | Stock | 29.475 | 29.475 | 29.475 | 29.475 | 2556.0 |
| 2014-11-26 06:25:00 | AAPL | Stock | 29.49 | 29.495 | 29.49 | 29.495 | 1000.0 |
| 2014-11-26 06:35:00 | AAPL | Stock | 29.49 | 29.5 | 29.49 | 29.5 | 1060.0 |
| 2014-11-26 06:40:00 | AAPL | Stock | 29.4875 | 29.4975 | 29.4875 | 29.4975 | 4400.0 |
| 2014-11-26 06:50:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 6000.0 |
| 2014-11-26 07:00:00 | AAPL | Stock | 29.4925 | 29.5 | 29.49 | 29.49 | 8000.0 |
| 2014-11-26 07:05:00 | AAPL | Stock | 29.485 | 29.5 | 29.475 | 29.4875 | 25348.0 |
| 2014-11-26 07:10:00 | AAPL | Stock | 29.5 | 29.5 | 29.4875 | 29.4875 | 11600.0 |
| 2014-11-26 07:15:00 | AAPL | Stock | 29.4775 | 29.5 | 29.475 | 29.4875 | 25296.0 |
| 2014-11-26 07:20:00 | AAPL | Stock | 29.4875 | 29.495 | 29.4775 | 29.4775 | 11200.0 |
| 2014-11-26 07:30:00 | AAPL | Stock | 29.475 | 29.49 | 29.475 | 29.475 | 6476.0 |
| 2014-11-26 07:35:00 | AAPL | Stock | 29.4625 | 29.505 | 29.4625 | 29.495 | 12556.0 |
| 2014-11-26 07:40:00 | AAPL | Stock | 29.495 | 29.495 | 29.475 | 29.485 | 14600.0 |
| 2014-11-26 07:45:00 | AAPL | Stock | 29.4875 | 29.4875 | 29.48 | 29.485 | 14000.0 |
| 2014-11-26 07:50:00 | AAPL | Stock | 29.4825 | 29.485 | 29.455 | 29.4825 | 23600.0 |
| 2014-11-26 07:55:00 | AAPL | Stock | 29.4775 | 29.4825 | 29.465 | 29.465 | 41396.0 |
| 2014-11-26 08:00:00 | AAPL | Stock | 29.485 | 29.525 | 29.4 | 29.525 | 186424.0 |
| 2014-11-26 08:05:00 | AAPL | Stock | 29.525 | 29.59 | 29.525 | 29.555 | 93772.0 |
| 2014-11-26 08:10:00 | AAPL | Stock | 29.5525 | 29.5625 | 29.5075 | 29.5375 | 74316.0 |
| 2014-11-26 08:15:00 | AAPL | Stock | 29.5275 | 29.5425 | 29.5175 | 29.54 | 56664.0 |
| 2014-11-26 08:20:00 | AAPL | Stock | 29.5375 | 29.54 | 29.525 | 29.525 | 40908.0 |
| 2014-11-26 08:25:00 | AAPL | Stock | 29.52 | 29.5275 | 29.5075 | 29.5275 | 50616.0 |
| 2014-11-26 08:30:00 | AAPL | Stock | 29.515 | 29.515 | 29.475 | 29.4875 | 52996.0 |
| 2014-11-26 08:35:00 | AAPL | Stock | 29.4875 | 29.5275 | 29.48 | 29.52 | 47396.0 |
| 2014-11-26 08:40:00 | AAPL | Stock | 29.5225 | 29.5275 | 29.5125 | 29.52 | 65168.0 |
| 2014-11-26 08:45:00 | AAPL | Stock | 29.515 | 29.52 | 29.5025 | 29.51 | 25060.0 |
| 2014-11-26 08:50:00 | AAPL | Stock | 29.51 | 29.56 | 29.51 | 29.5375 | 71716.0 |
| 2014-11-26 08:55:00 | AAPL | Stock | 29.545 | 29.5475 | 29.525 | 29.535 | 89268.0 |
| 2014-11-26 09:00:00 | AAPL | Stock | 29.52 | 29.5375 | 29.52 | 29.53 | 31800.0 |
| 2014-11-26 09:05:00 | AAPL | Stock | 29.5275 | 29.53 | 29.52 | 29.53 | 34292.0 |
| 2014-11-26 09:10:00 | AAPL | Stock | 29.5275 | 29.53 | 29.51 | 29.515 | 42320.0 |
| 2014-11-26 09:15:00 | AAPL | Stock | 29.515 | 29.515 | 29.4925 | 29.5 | 55864.0 |
> showing 50 of 351,992 rows — these rows as CSV