PREVIEW / stock_5min / 2015-01-26
file: by_date/stock_5min/2015/2015-01-26.parquet size: 5.4 MB rows: 361,730 symbols: 3,532
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-01-26 04:00:00 | AAPL | Stock | 28.1375 | 28.165 | 28.1375 | 28.165 | 5900.0 |
| 2015-01-26 04:10:00 | AAPL | Stock | 28.1775 | 28.1825 | 28.1775 | 28.1825 | 1200.0 |
| 2015-01-26 04:15:00 | AAPL | Stock | 28.1875 | 28.19 | 28.1875 | 28.19 | 10000.0 |
| 2015-01-26 04:20:00 | AAPL | Stock | 28.17 | 28.17 | 28.17 | 28.17 | 1200.0 |
| 2015-01-26 04:25:00 | AAPL | Stock | 28.2075 | 28.2875 | 28.2075 | 28.2875 | 20244.0 |
| 2015-01-26 04:30:00 | AAPL | Stock | 28.25 | 28.25 | 28.25 | 28.25 | 43600.0 |
| 2015-01-26 04:35:00 | AAPL | Stock | 28.255 | 28.275 | 28.245 | 28.25 | 12400.0 |
| 2015-01-26 04:40:00 | AAPL | Stock | 28.275 | 28.275 | 28.2525 | 28.275 | 4400.0 |
| 2015-01-26 04:45:00 | AAPL | Stock | 28.275 | 28.32 | 28.275 | 28.32 | 23520.0 |
| 2015-01-26 04:50:00 | AAPL | Stock | 28.3475 | 28.395 | 28.3475 | 28.395 | 36300.0 |
| 2015-01-26 05:00:00 | AAPL | Stock | 28.3575 | 28.3575 | 28.3575 | 28.3575 | 400.0 |
| 2015-01-26 05:05:00 | AAPL | Stock | 28.395 | 28.3975 | 28.395 | 28.3975 | 2000.0 |
| 2015-01-26 05:10:00 | AAPL | Stock | 28.3975 | 28.3975 | 28.3975 | 28.3975 | 400.0 |
| 2015-01-26 05:15:00 | AAPL | Stock | 28.3975 | 28.3975 | 28.3975 | 28.3975 | 800.0 |
| 2015-01-26 05:20:00 | AAPL | Stock | 28.395 | 28.395 | 28.395 | 28.395 | 800.0 |
| 2015-01-26 05:25:00 | AAPL | Stock | 28.395 | 28.395 | 28.365 | 28.365 | 2000.0 |
| 2015-01-26 05:30:00 | AAPL | Stock | 28.395 | 28.395 | 28.395 | 28.395 | 1600.0 |
| 2015-01-26 05:35:00 | AAPL | Stock | 28.3725 | 28.3725 | 28.3725 | 28.3725 | 800.0 |
| 2015-01-26 05:40:00 | AAPL | Stock | 28.3525 | 28.3525 | 28.3525 | 28.3525 | 400.0 |
| 2015-01-26 05:45:00 | AAPL | Stock | 28.3275 | 28.3375 | 28.3275 | 28.3375 | 6400.0 |
| 2015-01-26 05:50:00 | AAPL | Stock | 28.3475 | 28.3475 | 28.3475 | 28.3475 | 440.0 |
| 2015-01-26 05:55:00 | AAPL | Stock | 28.3375 | 28.3375 | 28.3375 | 28.3375 | 3112.0 |
| 2015-01-26 06:00:00 | AAPL | Stock | 28.3525 | 28.3875 | 28.3525 | 28.3875 | 11840.0 |
| 2015-01-26 06:05:00 | AAPL | Stock | 28.3975 | 28.4325 | 28.3625 | 28.4325 | 10140.0 |
| 2015-01-26 06:10:00 | AAPL | Stock | 28.4 | 28.4 | 28.39 | 28.39 | 2000.0 |
| 2015-01-26 06:15:00 | AAPL | Stock | 28.4 | 28.4 | 28.39 | 28.39 | 2000.0 |
| 2015-01-26 06:20:00 | AAPL | Stock | 28.415 | 28.4375 | 28.4125 | 28.425 | 15416.0 |
| 2015-01-26 06:25:00 | AAPL | Stock | 28.4625 | 28.4625 | 28.425 | 28.425 | 10800.0 |
| 2015-01-26 06:40:00 | AAPL | Stock | 28.3925 | 28.3925 | 28.3725 | 28.3725 | 4060.0 |
| 2015-01-26 06:45:00 | AAPL | Stock | 28.3625 | 28.375 | 28.3625 | 28.375 | 21052.0 |
| 2015-01-26 06:50:00 | AAPL | Stock | 28.375 | 28.375 | 28.3625 | 28.375 | 15852.0 |
| 2015-01-26 06:55:00 | AAPL | Stock | 28.3725 | 28.3725 | 28.3175 | 28.325 | 23252.0 |
| 2015-01-26 07:00:00 | AAPL | Stock | 28.325 | 28.375 | 28.325 | 28.3725 | 36740.0 |
| 2015-01-26 07:05:00 | AAPL | Stock | 28.3775 | 28.3875 | 28.37 | 28.37 | 40960.0 |
| 2015-01-26 07:10:00 | AAPL | Stock | 28.355 | 28.375 | 28.355 | 28.3725 | 7400.0 |
| 2015-01-26 07:15:00 | AAPL | Stock | 28.3725 | 28.3875 | 28.3725 | 28.3825 | 11140.0 |
| 2015-01-26 07:20:00 | AAPL | Stock | 28.385 | 28.415 | 28.385 | 28.4 | 17476.0 |
| 2015-01-26 07:25:00 | AAPL | Stock | 28.3875 | 28.42 | 28.375 | 28.4 | 41032.0 |
| 2015-01-26 07:30:00 | AAPL | Stock | 28.4 | 28.4025 | 28.3975 | 28.4 | 24528.0 |
| 2015-01-26 07:35:00 | AAPL | Stock | 28.4175 | 28.425 | 28.4175 | 28.425 | 15928.0 |
| 2015-01-26 07:40:00 | AAPL | Stock | 28.42 | 28.4375 | 28.4125 | 28.425 | 26268.0 |
| 2015-01-26 07:45:00 | AAPL | Stock | 28.425 | 28.4425 | 28.425 | 28.4375 | 31688.0 |
| 2015-01-26 07:50:00 | AAPL | Stock | 28.4375 | 28.485 | 28.4375 | 28.48 | 65844.0 |
| 2015-01-26 07:55:00 | AAPL | Stock | 28.4825 | 28.485 | 28.4675 | 28.485 | 45548.0 |
| 2015-01-26 08:00:00 | AAPL | Stock | 28.485 | 28.485 | 28.245 | 28.4575 | 241044.0 |
| 2015-01-26 08:05:00 | AAPL | Stock | 28.4575 | 28.4625 | 28.4175 | 28.4575 | 134536.0 |
| 2015-01-26 08:10:00 | AAPL | Stock | 28.45 | 28.45 | 28.4125 | 28.425 | 110868.0 |
| 2015-01-26 08:15:00 | AAPL | Stock | 28.425 | 28.425 | 28.4125 | 28.4125 | 47808.0 |
| 2015-01-26 08:20:00 | AAPL | Stock | 28.405 | 28.425 | 28.4 | 28.425 | 46772.0 |
| 2015-01-26 08:25:00 | AAPL | Stock | 28.4175 | 28.4375 | 28.4125 | 28.4375 | 361772.0 |
> showing 50 of 361,730 rows — these rows as CSV