PREVIEW / stock_5min / 2016-09-09
file: by_date/stock_5min/2016/2016-09-09.parquet size: 5.6 MB rows: 363,920 symbols: 3,251
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-09-09 04:00:00 | AAPL | Stock | 26.3475 | 26.3475 | 26.3475 | 26.3475 | 1200.0 |
| 2016-09-09 04:15:00 | AAPL | Stock | 26.3375 | 26.3375 | 26.3375 | 26.3375 | 1200.0 |
| 2016-09-09 04:25:00 | AAPL | Stock | 26.325 | 26.3575 | 26.325 | 26.3575 | 1496.0 |
| 2016-09-09 04:45:00 | AAPL | Stock | 26.3525 | 26.3525 | 26.35 | 26.35 | 2156.0 |
| 2016-09-09 05:05:00 | AAPL | Stock | 26.35 | 26.35 | 26.35 | 26.35 | 1344.0 |
| 2016-09-09 05:10:00 | AAPL | Stock | 26.35 | 26.35 | 26.35 | 26.35 | 400.0 |
| 2016-09-09 06:05:00 | AAPL | Stock | 26.3575 | 26.3575 | 26.3575 | 26.3575 | 1456.0 |
| 2016-09-09 06:10:00 | AAPL | Stock | 26.3575 | 26.3575 | 26.3575 | 26.3575 | 6000.0 |
| 2016-09-09 06:40:00 | AAPL | Stock | 26.3375 | 26.3375 | 26.3375 | 26.3375 | 400.0 |
| 2016-09-09 06:45:00 | AAPL | Stock | 26.3125 | 26.3475 | 26.2925 | 26.3475 | 2000.0 |
| 2016-09-09 07:00:00 | AAPL | Stock | 26.32 | 26.325 | 26.3125 | 26.3125 | 2808.0 |
| 2016-09-09 07:05:00 | AAPL | Stock | 26.3 | 26.3 | 26.285 | 26.285 | 4696.0 |
| 2016-09-09 07:10:00 | AAPL | Stock | 26.28 | 26.2875 | 26.275 | 26.2875 | 5600.0 |
| 2016-09-09 07:15:00 | AAPL | Stock | 26.2925 | 26.2925 | 26.2775 | 26.2825 | 3000.0 |
| 2016-09-09 07:20:00 | AAPL | Stock | 26.285 | 26.2875 | 26.285 | 26.285 | 2100.0 |
| 2016-09-09 07:25:00 | AAPL | Stock | 26.285 | 26.285 | 26.28 | 26.285 | 7100.0 |
| 2016-09-09 07:30:00 | AAPL | Stock | 26.2875 | 26.295 | 26.2825 | 26.2825 | 16704.0 |
| 2016-09-09 07:35:00 | AAPL | Stock | 26.2825 | 26.305 | 26.2825 | 26.3 | 6124.0 |
| 2016-09-09 07:40:00 | AAPL | Stock | 26.2875 | 26.2875 | 26.2725 | 26.2725 | 21576.0 |
| 2016-09-09 07:45:00 | AAPL | Stock | 26.2625 | 26.2625 | 26.2375 | 26.25 | 56896.0 |
| 2016-09-09 07:50:00 | AAPL | Stock | 26.26 | 26.2675 | 26.26 | 26.2675 | 3988.0 |
| 2016-09-09 07:55:00 | AAPL | Stock | 26.2725 | 26.2875 | 26.2725 | 26.2875 | 3588.0 |
| 2016-09-09 08:00:00 | AAPL | Stock | 26.2675 | 26.3125 | 26.26 | 26.285 | 82120.0 |
| 2016-09-09 08:05:00 | AAPL | Stock | 26.29 | 26.305 | 26.285 | 26.29 | 52776.0 |
| 2016-09-09 08:10:00 | AAPL | Stock | 26.2875 | 26.2975 | 26.25 | 26.275 | 80516.0 |
| 2016-09-09 08:15:00 | AAPL | Stock | 26.275 | 26.2875 | 26.2725 | 26.275 | 50256.0 |
| 2016-09-09 08:20:00 | AAPL | Stock | 26.275 | 26.275 | 26.2275 | 26.2625 | 87556.0 |
| 2016-09-09 08:25:00 | AAPL | Stock | 26.2675 | 26.275 | 26.2475 | 26.25 | 29760.0 |
| 2016-09-09 08:30:00 | AAPL | Stock | 26.2425 | 26.25 | 26.215 | 26.215 | 50744.0 |
| 2016-09-09 08:35:00 | AAPL | Stock | 26.215 | 26.22 | 26.2 | 26.2175 | 65472.0 |
| 2016-09-09 08:40:00 | AAPL | Stock | 26.22 | 26.2475 | 26.22 | 26.225 | 44952.0 |
| 2016-09-09 08:45:00 | AAPL | Stock | 26.225 | 26.2375 | 26.215 | 26.2225 | 83216.0 |
| 2016-09-09 08:50:00 | AAPL | Stock | 26.2175 | 26.23 | 26.205 | 26.23 | 50600.0 |
| 2016-09-09 08:55:00 | AAPL | Stock | 26.23 | 26.23 | 26.2125 | 26.22 | 52808.0 |
| 2016-09-09 09:00:00 | AAPL | Stock | 26.225 | 26.25 | 26.22 | 26.25 | 43292.0 |
| 2016-09-09 09:05:00 | AAPL | Stock | 26.25 | 26.265 | 26.2475 | 26.25 | 46404.0 |
| 2016-09-09 09:10:00 | AAPL | Stock | 26.2525 | 26.2675 | 26.2525 | 26.2575 | 14512.0 |
| 2016-09-09 09:15:00 | AAPL | Stock | 26.2375 | 26.2375 | 26.225 | 26.225 | 39496.0 |
| 2016-09-09 09:20:00 | AAPL | Stock | 26.22 | 26.235 | 26.22 | 26.225 | 40820.0 |
| 2016-09-09 09:25:00 | AAPL | Stock | 26.225 | 26.23 | 26.1575 | 26.16 | 361364.0 |
| 2016-09-09 09:30:00 | AAPL | Stock | 26.16 | 26.3475 | 26.1125 | 26.2588 | 9873964.0 |
| 2016-09-09 09:35:00 | AAPL | Stock | 26.26 | 26.3725 | 26.21 | 26.3275 | 4404324.0 |
| 2016-09-09 09:40:00 | AAPL | Stock | 26.3275 | 26.43 | 26.3175 | 26.3275 | 4614768.0 |
| 2016-09-09 09:45:00 | AAPL | Stock | 26.33 | 26.345 | 26.26 | 26.335 | 3290264.0 |
| 2016-09-09 09:50:00 | AAPL | Stock | 26.3345 | 26.345 | 26.2925 | 26.3378 | 2223912.0 |
| 2016-09-09 09:55:00 | AAPL | Stock | 26.3375 | 26.3375 | 26.265 | 26.2812 | 1950760.0 |
| 2016-09-09 10:00:00 | AAPL | Stock | 26.2812 | 26.3025 | 26.2412 | 26.275 | 2262608.0 |
| 2016-09-09 10:05:00 | AAPL | Stock | 26.275 | 26.295 | 26.2575 | 26.2675 | 1747036.0 |
| 2016-09-09 10:10:00 | AAPL | Stock | 26.27 | 26.2825 | 26.25 | 26.28 | 1930852.0 |
| 2016-09-09 10:15:00 | AAPL | Stock | 26.2815 | 26.3225 | 26.2725 | 26.285 | 1777744.0 |
> showing 50 of 363,920 rows — these rows as CSV