PREVIEW / stock_5min / 2014-07-18
file: by_date/stock_5min/2014/2014-07-18.parquet size: 5.3 MB rows: 353,577 symbols: 3,560
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-07-18 04:10:00 | AAPL | Stock | 23.285 | 23.285 | 23.285 | 23.285 | 632.0 |
| 2014-07-18 04:15:00 | AAPL | Stock | 23.33 | 23.33 | 23.2875 | 23.2875 | 1200.0 |
| 2014-07-18 04:20:00 | AAPL | Stock | 23.285 | 23.285 | 23.285 | 23.285 | 2000.0 |
| 2014-07-18 04:25:00 | AAPL | Stock | 23.285 | 23.285 | 23.285 | 23.285 | 724.0 |
| 2014-07-18 04:30:00 | AAPL | Stock | 23.2875 | 23.2875 | 23.2875 | 23.2875 | 800.0 |
| 2014-07-18 04:50:00 | AAPL | Stock | 23.2875 | 23.2875 | 23.2875 | 23.2875 | 800.0 |
| 2014-07-18 04:55:00 | AAPL | Stock | 23.285 | 23.285 | 23.285 | 23.285 | 876.0 |
| 2014-07-18 06:00:00 | AAPL | Stock | 23.2825 | 23.2825 | 23.2825 | 23.2825 | 1800.0 |
| 2014-07-18 06:05:00 | AAPL | Stock | 23.2825 | 23.2825 | 23.2825 | 23.2825 | 2800.0 |
| 2014-07-18 06:10:00 | AAPL | Stock | 23.2825 | 23.285 | 23.2825 | 23.285 | 4000.0 |
| 2014-07-18 06:15:00 | AAPL | Stock | 23.285 | 23.2875 | 23.285 | 23.2875 | 2824.0 |
| 2014-07-18 06:30:00 | AAPL | Stock | 23.3 | 23.3025 | 23.3 | 23.3025 | 2800.0 |
| 2014-07-18 06:35:00 | AAPL | Stock | 23.305 | 23.305 | 23.305 | 23.305 | 500.0 |
| 2014-07-18 06:40:00 | AAPL | Stock | 23.335 | 23.335 | 23.3275 | 23.3275 | 15016.0 |
| 2014-07-18 06:45:00 | AAPL | Stock | 23.36 | 23.36 | 23.3375 | 23.3375 | 2004.0 |
| 2014-07-18 06:50:00 | AAPL | Stock | 23.3625 | 23.3625 | 23.3625 | 23.3625 | 4192.0 |
| 2014-07-18 07:00:00 | AAPL | Stock | 23.3725 | 23.39 | 23.3725 | 23.3875 | 11060.0 |
| 2014-07-18 07:05:00 | AAPL | Stock | 23.4 | 23.4 | 23.4 | 23.4 | 400.0 |
| 2014-07-18 07:10:00 | AAPL | Stock | 23.4025 | 23.41 | 23.3875 | 23.4025 | 6400.0 |
| 2014-07-18 07:15:00 | AAPL | Stock | 23.405 | 23.41 | 23.3875 | 23.4 | 34276.0 |
| 2014-07-18 07:20:00 | AAPL | Stock | 23.4 | 23.4075 | 23.39 | 23.4075 | 11200.0 |
| 2014-07-18 07:25:00 | AAPL | Stock | 23.4075 | 23.425 | 23.4075 | 23.425 | 25132.0 |
| 2014-07-18 07:30:00 | AAPL | Stock | 23.4125 | 23.4125 | 23.4125 | 23.4125 | 5680.0 |
| 2014-07-18 07:35:00 | AAPL | Stock | 23.415 | 23.415 | 23.4 | 23.4 | 25320.0 |
| 2014-07-18 07:40:00 | AAPL | Stock | 23.395 | 23.41 | 23.39 | 23.4 | 24384.0 |
| 2014-07-18 07:45:00 | AAPL | Stock | 23.3975 | 23.3975 | 23.395 | 23.395 | 8000.0 |
| 2014-07-18 07:50:00 | AAPL | Stock | 23.3875 | 23.3875 | 23.3575 | 23.3725 | 15916.0 |
| 2014-07-18 07:55:00 | AAPL | Stock | 23.3625 | 23.3775 | 23.35 | 23.3775 | 49140.0 |
| 2014-07-18 08:00:00 | AAPL | Stock | 23.375 | 23.4325 | 23.27 | 23.3825 | 222420.0 |
| 2014-07-18 08:05:00 | AAPL | Stock | 23.3825 | 23.4175 | 23.3825 | 23.395 | 47268.0 |
| 2014-07-18 08:10:00 | AAPL | Stock | 23.395 | 23.42 | 23.395 | 23.4 | 54572.0 |
| 2014-07-18 08:15:00 | AAPL | Stock | 23.39 | 23.4 | 23.38 | 23.4 | 47724.0 |
| 2014-07-18 08:20:00 | AAPL | Stock | 23.4 | 23.415 | 23.395 | 23.3975 | 85732.0 |
| 2014-07-18 08:25:00 | AAPL | Stock | 23.3975 | 23.4025 | 23.3925 | 23.3938 | 77172.0 |
| 2014-07-18 08:30:00 | AAPL | Stock | 23.395 | 23.4 | 23.3925 | 23.395 | 38356.0 |
| 2014-07-18 08:35:00 | AAPL | Stock | 23.395 | 23.3975 | 23.3925 | 23.3925 | 18880.0 |
| 2014-07-18 08:40:00 | AAPL | Stock | 23.3925 | 23.3925 | 23.385 | 23.3875 | 37240.0 |
| 2014-07-18 08:45:00 | AAPL | Stock | 23.3875 | 23.3925 | 23.3875 | 23.39 | 25060.0 |
| 2014-07-18 08:50:00 | AAPL | Stock | 23.3875 | 23.39 | 23.3675 | 23.375 | 58116.0 |
| 2014-07-18 08:55:00 | AAPL | Stock | 23.375 | 23.3875 | 23.3725 | 23.3725 | 89912.0 |
| 2014-07-18 09:00:00 | AAPL | Stock | 23.3775 | 23.3775 | 23.35 | 23.35 | 40616.0 |
| 2014-07-18 09:05:00 | AAPL | Stock | 23.36 | 23.3625 | 23.35 | 23.36 | 27892.0 |
| 2014-07-18 09:10:00 | AAPL | Stock | 23.3625 | 23.3625 | 23.355 | 23.3625 | 48936.0 |
| 2014-07-18 09:15:00 | AAPL | Stock | 23.3675 | 23.375 | 23.3625 | 23.37 | 27372.0 |
| 2014-07-18 09:20:00 | AAPL | Stock | 23.37 | 23.385 | 23.37 | 23.385 | 83228.0 |
| 2014-07-18 09:25:00 | AAPL | Stock | 23.3775 | 23.4225 | 23.3775 | 23.405 | 661372.0 |
| 2014-07-18 09:30:00 | AAPL | Stock | 23.405 | 23.4175 | 23.2962 | 23.3922 | 20358144.0 |
| 2014-07-18 09:35:00 | AAPL | Stock | 23.395 | 23.45 | 23.37 | 23.4 | 4678904.0 |
| 2014-07-18 09:40:00 | AAPL | Stock | 23.4025 | 23.4025 | 23.325 | 23.325 | 2845376.0 |
| 2014-07-18 09:45:00 | AAPL | Stock | 23.3275 | 23.3475 | 23.275 | 23.325 | 3686324.0 |
> showing 50 of 353,577 rows — these rows as CSV