PREVIEW / stock_5min / 2014-12-23
file: by_date/stock_5min/2014/2014-12-23.parquet size: 5.5 MB rows: 367,553 symbols: 3,569
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-12-23 06:05:00 | AAPL | Stock | 28.1875 | 28.1875 | 28.1875 | 28.1875 | 400.0 |
| 2014-12-23 06:15:00 | AAPL | Stock | 28.1875 | 28.1875 | 28.1875 | 28.1875 | 800.0 |
| 2014-12-23 06:20:00 | AAPL | Stock | 28.1875 | 28.1875 | 28.1875 | 28.1875 | 800.0 |
| 2014-12-23 06:25:00 | AAPL | Stock | 28.2125 | 28.2125 | 28.2125 | 28.2125 | 1200.0 |
| 2014-12-23 06:45:00 | AAPL | Stock | 28.2125 | 28.2125 | 28.2125 | 28.2125 | 1200.0 |
| 2014-12-23 07:00:00 | AAPL | Stock | 28.2275 | 28.2275 | 28.225 | 28.225 | 18400.0 |
| 2014-12-23 07:05:00 | AAPL | Stock | 28.245 | 28.245 | 28.225 | 28.2325 | 13200.0 |
| 2014-12-23 07:10:00 | AAPL | Stock | 28.2575 | 28.2575 | 28.2575 | 28.2575 | 11200.0 |
| 2014-12-23 07:15:00 | AAPL | Stock | 28.2575 | 28.2575 | 28.25 | 28.25 | 1200.0 |
| 2014-12-23 07:20:00 | AAPL | Stock | 28.25 | 28.2575 | 28.2475 | 28.2575 | 26400.0 |
| 2014-12-23 07:25:00 | AAPL | Stock | 28.26 | 28.27 | 28.26 | 28.27 | 4980.0 |
| 2014-12-23 07:30:00 | AAPL | Stock | 28.2725 | 28.2825 | 28.2675 | 28.2675 | 9400.0 |
| 2014-12-23 07:35:00 | AAPL | Stock | 28.2575 | 28.2725 | 28.2575 | 28.2725 | 3628.0 |
| 2014-12-23 07:40:00 | AAPL | Stock | 28.2725 | 28.2725 | 28.265 | 28.265 | 4400.0 |
| 2014-12-23 07:45:00 | AAPL | Stock | 28.275 | 28.3625 | 28.275 | 28.28 | 12916.0 |
| 2014-12-23 07:50:00 | AAPL | Stock | 28.285 | 28.285 | 28.275 | 28.285 | 10400.0 |
| 2014-12-23 07:55:00 | AAPL | Stock | 28.2775 | 28.2775 | 28.27 | 28.27 | 12800.0 |
| 2014-12-23 08:00:00 | AAPL | Stock | 28.275 | 28.285 | 28.25 | 28.28 | 91536.0 |
| 2014-12-23 08:05:00 | AAPL | Stock | 28.2825 | 28.29 | 28.28 | 28.285 | 29828.0 |
| 2014-12-23 08:10:00 | AAPL | Stock | 28.285 | 28.295 | 28.285 | 28.2875 | 30408.0 |
| 2014-12-23 08:15:00 | AAPL | Stock | 28.295 | 28.295 | 28.285 | 28.29 | 15200.0 |
| 2014-12-23 08:20:00 | AAPL | Stock | 28.2925 | 28.2975 | 28.2875 | 28.2875 | 34100.0 |
| 2014-12-23 08:25:00 | AAPL | Stock | 28.2875 | 28.2925 | 28.265 | 28.265 | 19336.0 |
| 2014-12-23 08:30:00 | AAPL | Stock | 28.2825 | 28.3175 | 28.275 | 28.3125 | 86220.0 |
| 2014-12-23 08:35:00 | AAPL | Stock | 28.3125 | 28.3175 | 28.2925 | 28.2925 | 92656.0 |
| 2014-12-23 08:40:00 | AAPL | Stock | 28.31 | 28.3125 | 28.2925 | 28.305 | 13904.0 |
| 2014-12-23 08:45:00 | AAPL | Stock | 28.3075 | 28.3125 | 28.3 | 28.3125 | 14488.0 |
| 2014-12-23 08:50:00 | AAPL | Stock | 28.315 | 28.325 | 28.3025 | 28.315 | 66748.0 |
| 2014-12-23 08:55:00 | AAPL | Stock | 28.3225 | 28.325 | 28.315 | 28.325 | 18900.0 |
| 2014-12-23 09:00:00 | AAPL | Stock | 28.325 | 28.33 | 28.32 | 28.325 | 27400.0 |
| 2014-12-23 09:05:00 | AAPL | Stock | 28.3225 | 28.33 | 28.3075 | 28.3075 | 46100.0 |
| 2014-12-23 09:10:00 | AAPL | Stock | 28.305 | 28.315 | 28.3025 | 28.3025 | 61928.0 |
| 2014-12-23 09:15:00 | AAPL | Stock | 28.31 | 28.325 | 28.31 | 28.32 | 13832.0 |
| 2014-12-23 09:20:00 | AAPL | Stock | 28.325 | 28.33 | 28.32 | 28.3275 | 30152.0 |
| 2014-12-23 09:25:00 | AAPL | Stock | 28.3275 | 28.3525 | 28.3125 | 28.3225 | 113532.0 |
| 2014-12-23 09:30:00 | AAPL | Stock | 28.3125 | 28.3325 | 28.2 | 28.25 | 5951008.0 |
| 2014-12-23 09:35:00 | AAPL | Stock | 28.25 | 28.2878 | 28.175 | 28.18 | 2945384.0 |
| 2014-12-23 09:40:00 | AAPL | Stock | 28.18 | 28.26 | 28.18 | 28.244 | 2307140.0 |
| 2014-12-23 09:45:00 | AAPL | Stock | 28.2425 | 28.2725 | 28.205 | 28.2225 | 2167824.0 |
| 2014-12-23 09:50:00 | AAPL | Stock | 28.215 | 28.225 | 28.1775 | 28.1825 | 2345148.0 |
| 2014-12-23 09:55:00 | AAPL | Stock | 28.1835 | 28.1875 | 28.13 | 28.1775 | 3007452.0 |
| 2014-12-23 10:00:00 | AAPL | Stock | 28.175 | 28.18 | 28.1625 | 28.175 | 1801984.0 |
| 2014-12-23 10:05:00 | AAPL | Stock | 28.1775 | 28.1925 | 28.1525 | 28.1875 | 1892600.0 |
| 2014-12-23 10:10:00 | AAPL | Stock | 28.1875 | 28.234 | 28.1575 | 28.19 | 2184436.0 |
| 2014-12-23 10:15:00 | AAPL | Stock | 28.1882 | 28.2725 | 28.1882 | 28.23 | 2113708.0 |
| 2014-12-23 10:20:00 | AAPL | Stock | 28.2278 | 28.255 | 28.2222 | 28.245 | 1299072.0 |
| 2014-12-23 10:25:00 | AAPL | Stock | 28.2475 | 28.275 | 28.2225 | 28.2475 | 1811408.0 |
| 2014-12-23 10:30:00 | AAPL | Stock | 28.2475 | 28.2475 | 28.2075 | 28.2325 | 1160172.0 |
| 2014-12-23 10:35:00 | AAPL | Stock | 28.235 | 28.25 | 28.2175 | 28.219 | 1204852.0 |
| 2014-12-23 10:40:00 | AAPL | Stock | 28.22 | 28.2375 | 28.2175 | 28.2325 | 946868.0 |
> showing 50 of 367,553 rows — these rows as CSV