PREVIEW / stock_5min / 2016-01-14
file: by_date/stock_5min/2016/2016-01-14.parquet size: 5.7 MB rows: 376,507 symbols: 3,406
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 |
|---|---|---|---|---|---|---|---|
| 2016-01-14 04:00:00 | AAPL | Stock | 24.385 | 24.395 | 24.3825 | 24.395 | 3600.0 |
| 2016-01-14 04:05:00 | AAPL | Stock | 24.3925 | 24.3925 | 24.3775 | 24.3775 | 2400.0 |
| 2016-01-14 04:10:00 | AAPL | Stock | 24.275 | 24.32 | 24.275 | 24.32 | 800.0 |
| 2016-01-14 04:20:00 | AAPL | Stock | 24.3175 | 24.3175 | 24.3175 | 24.3175 | 1600.0 |
| 2016-01-14 04:30:00 | AAPL | Stock | 24.3125 | 24.3125 | 24.3125 | 24.3125 | 8464.0 |
| 2016-01-14 04:35:00 | AAPL | Stock | 24.2875 | 24.375 | 24.2875 | 24.375 | 12756.0 |
| 2016-01-14 04:40:00 | AAPL | Stock | 24.375 | 24.39 | 24.365 | 24.365 | 3140.0 |
| 2016-01-14 04:45:00 | AAPL | Stock | 24.375 | 24.3775 | 24.345 | 24.345 | 7788.0 |
| 2016-01-14 05:00:00 | AAPL | Stock | 24.35 | 24.39 | 24.35 | 24.375 | 14800.0 |
| 2016-01-14 05:10:00 | AAPL | Stock | 24.3275 | 24.3525 | 24.3275 | 24.3525 | 2800.0 |
| 2016-01-14 05:20:00 | AAPL | Stock | 24.345 | 24.345 | 24.345 | 24.345 | 400.0 |
| 2016-01-14 05:25:00 | AAPL | Stock | 24.3025 | 24.3425 | 24.25 | 24.25 | 14032.0 |
| 2016-01-14 05:40:00 | AAPL | Stock | 24.25 | 24.25 | 24.25 | 24.25 | 3636.0 |
| 2016-01-14 05:50:00 | AAPL | Stock | 24.2875 | 24.345 | 24.2875 | 24.2875 | 3236.0 |
| 2016-01-14 05:55:00 | AAPL | Stock | 24.2875 | 24.2875 | 24.2775 | 24.28 | 8176.0 |
| 2016-01-14 06:00:00 | AAPL | Stock | 24.3125 | 24.3125 | 24.2325 | 24.2325 | 12576.0 |
| 2016-01-14 06:05:00 | AAPL | Stock | 24.2325 | 24.235 | 24.1875 | 24.2025 | 7800.0 |
| 2016-01-14 06:10:00 | AAPL | Stock | 24.1875 | 24.1875 | 24.1875 | 24.1875 | 2592.0 |
| 2016-01-14 06:15:00 | AAPL | Stock | 24.175 | 24.175 | 24.175 | 24.175 | 800.0 |
| 2016-01-14 06:20:00 | AAPL | Stock | 24.2075 | 24.2075 | 24.2075 | 24.2075 | 400.0 |
| 2016-01-14 06:25:00 | AAPL | Stock | 24.19 | 24.2125 | 24.19 | 24.2125 | 5800.0 |
| 2016-01-14 06:30:00 | AAPL | Stock | 24.22 | 24.22 | 24.205 | 24.205 | 800.0 |
| 2016-01-14 06:35:00 | AAPL | Stock | 24.205 | 24.205 | 24.175 | 24.175 | 9200.0 |
| 2016-01-14 06:40:00 | AAPL | Stock | 24.175 | 24.2075 | 24.175 | 24.2075 | 2400.0 |
| 2016-01-14 06:50:00 | AAPL | Stock | 24.1975 | 24.25 | 24.1975 | 24.25 | 18824.0 |
| 2016-01-14 06:55:00 | AAPL | Stock | 24.23 | 24.23 | 24.215 | 24.215 | 3400.0 |
| 2016-01-14 07:00:00 | AAPL | Stock | 24.23 | 24.2575 | 24.225 | 24.2575 | 24380.0 |
| 2016-01-14 07:05:00 | AAPL | Stock | 24.27 | 24.295 | 24.245 | 24.2525 | 28948.0 |
| 2016-01-14 07:10:00 | AAPL | Stock | 24.25 | 24.2725 | 24.2475 | 24.2725 | 7600.0 |
| 2016-01-14 07:15:00 | AAPL | Stock | 24.265 | 24.2675 | 24.23 | 24.23 | 14804.0 |
| 2016-01-14 07:20:00 | AAPL | Stock | 24.2225 | 24.2425 | 24.2225 | 24.2425 | 4480.0 |
| 2016-01-14 07:25:00 | AAPL | Stock | 24.24 | 24.25 | 24.2375 | 24.25 | 5784.0 |
| 2016-01-14 07:30:00 | AAPL | Stock | 24.255 | 24.3125 | 24.2425 | 24.31 | 73580.0 |
| 2016-01-14 07:35:00 | AAPL | Stock | 24.305 | 24.33 | 24.305 | 24.33 | 12000.0 |
| 2016-01-14 07:40:00 | AAPL | Stock | 24.325 | 24.325 | 24.285 | 24.2875 | 17680.0 |
| 2016-01-14 07:45:00 | AAPL | Stock | 24.2875 | 24.2875 | 24.2725 | 24.2725 | 25332.0 |
| 2016-01-14 07:50:00 | AAPL | Stock | 24.2975 | 24.3075 | 24.29 | 24.3025 | 13560.0 |
| 2016-01-14 07:55:00 | AAPL | Stock | 24.3025 | 24.355 | 24.3025 | 24.345 | 3800.0 |
| 2016-01-14 08:00:00 | AAPL | Stock | 24.34 | 24.34 | 24.235 | 24.2825 | 102400.0 |
| 2016-01-14 08:05:00 | AAPL | Stock | 24.275 | 24.2875 | 24.2575 | 24.2575 | 37208.0 |
| 2016-01-14 08:10:00 | AAPL | Stock | 24.2575 | 24.2775 | 24.2575 | 24.2675 | 32004.0 |
| 2016-01-14 08:15:00 | AAPL | Stock | 24.2825 | 24.3025 | 24.275 | 24.2875 | 36496.0 |
| 2016-01-14 08:20:00 | AAPL | Stock | 24.2825 | 24.3 | 24.2725 | 24.2725 | 13288.0 |
| 2016-01-14 08:25:00 | AAPL | Stock | 24.265 | 24.345 | 24.265 | 24.345 | 79120.0 |
| 2016-01-14 08:30:00 | AAPL | Stock | 24.345 | 24.4 | 24.3125 | 24.3875 | 88892.0 |
| 2016-01-14 08:35:00 | AAPL | Stock | 24.3975 | 24.4125 | 24.3675 | 24.4075 | 42476.0 |
| 2016-01-14 08:40:00 | AAPL | Stock | 24.4 | 24.435 | 24.39 | 24.4075 | 63660.0 |
| 2016-01-14 08:45:00 | AAPL | Stock | 24.3875 | 24.415 | 24.385 | 24.415 | 55120.0 |
| 2016-01-14 08:50:00 | AAPL | Stock | 24.4125 | 24.415 | 24.375 | 24.405 | 70632.0 |
| 2016-01-14 08:55:00 | AAPL | Stock | 24.4075 | 24.4375 | 24.3475 | 24.415 | 753400.0 |
> showing 50 of 376,507 rows — these rows as CSV