PREVIEW / stock_5min / 2015-11-06
file: by_date/stock_5min/2015/2015-11-06.parquet size: 5.5 MB rows: 363,600 symbols: 3,419
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-11-06 04:00:00 | AAPL | Stock | 30.315 | 30.315 | 30.315 | 30.315 | 400.0 |
| 2015-11-06 04:05:00 | AAPL | Stock | 30.25 | 30.25 | 30.25 | 30.25 | 6220.0 |
| 2015-11-06 04:10:00 | AAPL | Stock | 30.26 | 30.26 | 30.25 | 30.25 | 6220.0 |
| 2015-11-06 04:25:00 | AAPL | Stock | 30.2525 | 30.2525 | 30.25 | 30.25 | 3200.0 |
| 2015-11-06 04:30:00 | AAPL | Stock | 30.275 | 30.275 | 30.275 | 30.275 | 800.0 |
| 2015-11-06 05:05:00 | AAPL | Stock | 30.2725 | 30.275 | 30.2725 | 30.275 | 1960.0 |
| 2015-11-06 05:40:00 | AAPL | Stock | 30.275 | 30.275 | 30.275 | 30.275 | 1276.0 |
| 2015-11-06 06:05:00 | AAPL | Stock | 30.275 | 30.275 | 30.275 | 30.275 | 1000.0 |
| 2015-11-06 06:25:00 | AAPL | Stock | 30.3 | 30.3325 | 30.295 | 30.3325 | 26168.0 |
| 2015-11-06 06:35:00 | AAPL | Stock | 30.3175 | 30.3175 | 30.3175 | 30.3175 | 752.0 |
| 2015-11-06 06:55:00 | AAPL | Stock | 30.3125 | 30.3175 | 30.3125 | 30.3175 | 5200.0 |
| 2015-11-06 07:00:00 | AAPL | Stock | 30.3175 | 30.35 | 30.3125 | 30.3125 | 13644.0 |
| 2015-11-06 07:10:00 | AAPL | Stock | 30.3325 | 30.35 | 30.33 | 30.35 | 2384.0 |
| 2015-11-06 07:15:00 | AAPL | Stock | 30.35 | 30.35 | 30.35 | 30.35 | 4400.0 |
| 2015-11-06 07:20:00 | AAPL | Stock | 30.3375 | 30.3375 | 30.3375 | 30.3375 | 5612.0 |
| 2015-11-06 07:25:00 | AAPL | Stock | 30.3425 | 30.3425 | 30.3375 | 30.3425 | 3360.0 |
| 2015-11-06 07:30:00 | AAPL | Stock | 30.3375 | 30.3375 | 30.325 | 30.325 | 2200.0 |
| 2015-11-06 07:50:00 | AAPL | Stock | 30.31 | 30.31 | 30.3 | 30.3 | 6000.0 |
| 2015-11-06 07:55:00 | AAPL | Stock | 30.305 | 30.3175 | 30.2975 | 30.315 | 7600.0 |
| 2015-11-06 08:00:00 | AAPL | Stock | 30.2975 | 30.3475 | 30.175 | 30.3325 | 49960.0 |
| 2015-11-06 08:05:00 | AAPL | Stock | 30.3325 | 30.3375 | 30.3175 | 30.3375 | 42400.0 |
| 2015-11-06 08:10:00 | AAPL | Stock | 30.335 | 30.3375 | 30.33 | 30.3325 | 9232.0 |
| 2015-11-06 08:15:00 | AAPL | Stock | 30.33 | 30.354 | 30.33 | 30.354 | 4844.0 |
| 2015-11-06 08:20:00 | AAPL | Stock | 30.3425 | 30.35 | 30.32 | 30.3465 | 39532.0 |
| 2015-11-06 08:25:00 | AAPL | Stock | 30.34 | 30.35 | 30.34 | 30.3475 | 12348.0 |
| 2015-11-06 08:30:00 | AAPL | Stock | 30.3475 | 30.4 | 30.19 | 30.375 | 422288.0 |
| 2015-11-06 08:35:00 | AAPL | Stock | 30.365 | 30.4 | 30.33 | 30.34 | 238148.0 |
| 2015-11-06 08:40:00 | AAPL | Stock | 30.34 | 30.355 | 30.3 | 30.3225 | 67972.0 |
| 2015-11-06 08:45:00 | AAPL | Stock | 30.3225 | 30.3225 | 30.29 | 30.3135 | 58452.0 |
| 2015-11-06 08:50:00 | AAPL | Stock | 30.315 | 30.345 | 30.3125 | 30.325 | 65120.0 |
| 2015-11-06 08:55:00 | AAPL | Stock | 30.325 | 30.3375 | 30.2875 | 30.3075 | 193320.0 |
| 2015-11-06 09:00:00 | AAPL | Stock | 30.3075 | 30.325 | 30.2875 | 30.2925 | 66744.0 |
| 2015-11-06 09:05:00 | AAPL | Stock | 30.2925 | 30.3065 | 30.2625 | 30.275 | 88748.0 |
| 2015-11-06 09:10:00 | AAPL | Stock | 30.275 | 30.3 | 30.2725 | 30.295 | 68824.0 |
| 2015-11-06 09:15:00 | AAPL | Stock | 30.295 | 30.33 | 30.2725 | 30.33 | 321000.0 |
| 2015-11-06 09:20:00 | AAPL | Stock | 30.33 | 30.345 | 30.3025 | 30.3125 | 38952.0 |
| 2015-11-06 09:25:00 | AAPL | Stock | 30.305 | 30.32 | 30.2775 | 30.3 | 46204.0 |
| 2015-11-06 09:30:00 | AAPL | Stock | 30.2775 | 30.3725 | 30.23 | 30.307 | 5312496.0 |
| 2015-11-06 09:35:00 | AAPL | Stock | 30.3025 | 30.38 | 30.2675 | 30.3665 | 2911232.0 |
| 2015-11-06 09:40:00 | AAPL | Stock | 30.365 | 30.4525 | 30.355 | 30.3975 | 4025636.0 |
| 2015-11-06 09:45:00 | AAPL | Stock | 30.395 | 30.425 | 30.32 | 30.3232 | 2489120.0 |
| 2015-11-06 09:50:00 | AAPL | Stock | 30.3225 | 30.35 | 30.2625 | 30.3025 | 2912020.0 |
| 2015-11-06 09:55:00 | AAPL | Stock | 30.3 | 30.3005 | 30.22 | 30.2525 | 3111108.0 |
| 2015-11-06 10:00:00 | AAPL | Stock | 30.25 | 30.31 | 30.235 | 30.2622 | 2552568.0 |
| 2015-11-06 10:05:00 | AAPL | Stock | 30.2625 | 30.2625 | 30.155 | 30.2275 | 2817320.0 |
| 2015-11-06 10:10:00 | AAPL | Stock | 30.2275 | 30.2925 | 30.2002 | 30.2875 | 4754528.0 |
| 2015-11-06 10:15:00 | AAPL | Stock | 30.2875 | 30.2925 | 30.245 | 30.285 | 1365668.0 |
| 2015-11-06 10:20:00 | AAPL | Stock | 30.2875 | 30.2875 | 30.25 | 30.275 | 1686228.0 |
| 2015-11-06 10:25:00 | AAPL | Stock | 30.275 | 30.3025 | 30.2525 | 30.3025 | 1606948.0 |
| 2015-11-06 10:30:00 | AAPL | Stock | 30.3025 | 30.3675 | 30.2875 | 30.3425 | 1958408.0 |
> showing 50 of 363,600 rows — these rows as CSV