PREVIEW / stock_5min / 2014-06-12
file: by_date/stock_5min/2014/2014-06-12.parquet size: 5.4 MB rows: 356,821 symbols: 3,525
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-06-12 04:15:00 | AAPL | Stock | 23.475 | 23.475 | 23.47 | 23.47 | 4000.0 |
| 2014-06-12 05:45:00 | AAPL | Stock | 23.4625 | 23.4625 | 23.4625 | 23.4625 | 1316.0 |
| 2014-06-12 05:50:00 | AAPL | Stock | 23.485 | 23.485 | 23.4625 | 23.4625 | 3200.0 |
| 2014-06-12 06:05:00 | AAPL | Stock | 23.4625 | 23.4625 | 23.4625 | 23.4625 | 4284.0 |
| 2014-06-12 06:10:00 | AAPL | Stock | 23.4625 | 23.4625 | 23.4625 | 23.4625 | 6800.0 |
| 2014-06-12 06:20:00 | AAPL | Stock | 23.5 | 23.5 | 23.5 | 23.5 | 400.0 |
| 2014-06-12 06:25:00 | AAPL | Stock | 23.4975 | 23.5 | 23.4975 | 23.4975 | 6000.0 |
| 2014-06-12 06:30:00 | AAPL | Stock | 23.4875 | 23.4875 | 23.4875 | 23.4875 | 400.0 |
| 2014-06-12 06:35:00 | AAPL | Stock | 23.4825 | 23.485 | 23.475 | 23.475 | 6700.0 |
| 2014-06-12 06:45:00 | AAPL | Stock | 23.48 | 23.48 | 23.48 | 23.48 | 560.0 |
| 2014-06-12 06:55:00 | AAPL | Stock | 23.485 | 23.485 | 23.485 | 23.485 | 800.0 |
| 2014-06-12 07:00:00 | AAPL | Stock | 23.475 | 23.485 | 23.475 | 23.485 | 15688.0 |
| 2014-06-12 07:05:00 | AAPL | Stock | 23.485 | 23.4925 | 23.4775 | 23.4925 | 5688.0 |
| 2014-06-12 07:15:00 | AAPL | Stock | 23.4825 | 23.4825 | 23.4775 | 23.4825 | 6352.0 |
| 2014-06-12 07:20:00 | AAPL | Stock | 23.485 | 23.485 | 23.485 | 23.485 | 5200.0 |
| 2014-06-12 07:25:00 | AAPL | Stock | 23.485 | 23.485 | 23.4825 | 23.4825 | 3956.0 |
| 2014-06-12 07:35:00 | AAPL | Stock | 23.4925 | 23.5075 | 23.4925 | 23.5075 | 21084.0 |
| 2014-06-12 07:40:00 | AAPL | Stock | 23.4925 | 23.5125 | 23.4825 | 23.5125 | 20892.0 |
| 2014-06-12 07:45:00 | AAPL | Stock | 23.51 | 23.5375 | 23.485 | 23.485 | 20364.0 |
| 2014-06-12 07:50:00 | AAPL | Stock | 23.5 | 23.5125 | 23.5 | 23.5125 | 1200.0 |
| 2014-06-12 07:55:00 | AAPL | Stock | 23.515 | 23.5175 | 23.51 | 23.5175 | 3200.0 |
| 2014-06-12 08:00:00 | AAPL | Stock | 23.52 | 23.5325 | 23.4775 | 23.5225 | 131780.0 |
| 2014-06-12 08:05:00 | AAPL | Stock | 23.5225 | 23.525 | 23.5125 | 23.52 | 61864.0 |
| 2014-06-12 08:10:00 | AAPL | Stock | 23.5125 | 23.525 | 23.5 | 23.525 | 51712.0 |
| 2014-06-12 08:15:00 | AAPL | Stock | 23.5175 | 23.5225 | 23.5175 | 23.5225 | 12448.0 |
| 2014-06-12 08:20:00 | AAPL | Stock | 23.5225 | 23.525 | 23.4975 | 23.5 | 80316.0 |
| 2014-06-12 08:25:00 | AAPL | Stock | 23.5075 | 23.51 | 23.495 | 23.5 | 26100.0 |
| 2014-06-12 08:30:00 | AAPL | Stock | 23.5 | 23.505 | 23.485 | 23.5 | 66528.0 |
| 2014-06-12 08:35:00 | AAPL | Stock | 23.5 | 23.5075 | 23.495 | 23.4975 | 35172.0 |
| 2014-06-12 08:40:00 | AAPL | Stock | 23.5 | 23.505 | 23.4975 | 23.505 | 7200.0 |
| 2014-06-12 08:45:00 | AAPL | Stock | 23.505 | 23.52 | 23.505 | 23.52 | 20684.0 |
| 2014-06-12 08:50:00 | AAPL | Stock | 23.52 | 23.52 | 23.5125 | 23.5125 | 13200.0 |
| 2014-06-12 08:55:00 | AAPL | Stock | 23.5175 | 23.52 | 23.505 | 23.505 | 34016.0 |
| 2014-06-12 09:00:00 | AAPL | Stock | 23.5 | 23.5 | 23.49 | 23.49 | 78100.0 |
| 2014-06-12 09:05:00 | AAPL | Stock | 23.49 | 23.4925 | 23.44 | 23.455 | 112240.0 |
| 2014-06-12 09:10:00 | AAPL | Stock | 23.4575 | 23.475 | 23.4575 | 23.47 | 23188.0 |
| 2014-06-12 09:15:00 | AAPL | Stock | 23.47 | 23.4875 | 23.47 | 23.485 | 37760.0 |
| 2014-06-12 09:20:00 | AAPL | Stock | 23.485 | 23.515 | 23.485 | 23.51 | 63168.0 |
| 2014-06-12 09:25:00 | AAPL | Stock | 23.5125 | 23.53 | 23.5 | 23.5 | 94908.0 |
| 2014-06-12 09:30:00 | AAPL | Stock | 23.51 | 23.53 | 23.385 | 23.397 | 6080004.0 |
| 2014-06-12 09:35:00 | AAPL | Stock | 23.395 | 23.4225 | 23.3275 | 23.385 | 5420536.0 |
| 2014-06-12 09:40:00 | AAPL | Stock | 23.385 | 23.3875 | 23.3425 | 23.367 | 4091480.0 |
| 2014-06-12 09:45:00 | AAPL | Stock | 23.3675 | 23.4375 | 23.355 | 23.41 | 3087672.0 |
| 2014-06-12 09:50:00 | AAPL | Stock | 23.4125 | 23.48 | 23.395 | 23.475 | 2574088.0 |
| 2014-06-12 09:55:00 | AAPL | Stock | 23.4748 | 23.475 | 23.4275 | 23.4425 | 2563084.0 |
| 2014-06-12 10:00:00 | AAPL | Stock | 23.4375 | 23.46 | 23.4075 | 23.4488 | 2129216.0 |
| 2014-06-12 10:05:00 | AAPL | Stock | 23.4475 | 23.45 | 23.4175 | 23.4325 | 1522928.0 |
| 2014-06-12 10:10:00 | AAPL | Stock | 23.435 | 23.4468 | 23.395 | 23.395 | 1841272.0 |
| 2014-06-12 10:15:00 | AAPL | Stock | 23.3975 | 23.3975 | 23.355 | 23.3702 | 2182120.0 |
| 2014-06-12 10:20:00 | AAPL | Stock | 23.3702 | 23.42 | 23.365 | 23.4142 | 1615600.0 |
> showing 50 of 356,821 rows — these rows as CSV