PREVIEW / stock_5min / 2016-03-18
file: by_date/stock_5min/2016/2016-03-18.parquet size: 5.5 MB rows: 367,171 symbols: 3,350
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-03-18 04:50:00 | AAPL | Stock | 26.48 | 26.48 | 26.48 | 26.48 | 440.0 |
| 2016-03-18 05:05:00 | AAPL | Stock | 26.48 | 26.48 | 26.48 | 26.48 | 2840.0 |
| 2016-03-18 06:25:00 | AAPL | Stock | 26.48 | 26.48 | 26.48 | 26.48 | 680.0 |
| 2016-03-18 06:35:00 | AAPL | Stock | 26.48 | 26.48 | 26.48 | 26.48 | 4268.0 |
| 2016-03-18 06:55:00 | AAPL | Stock | 26.48 | 26.48 | 26.48 | 26.48 | 1200.0 |
| 2016-03-18 07:00:00 | AAPL | Stock | 26.48 | 26.515 | 26.48 | 26.515 | 15600.0 |
| 2016-03-18 07:05:00 | AAPL | Stock | 26.515 | 26.525 | 26.515 | 26.525 | 1080.0 |
| 2016-03-18 07:10:00 | AAPL | Stock | 26.525 | 26.5375 | 26.525 | 26.5375 | 3884.0 |
| 2016-03-18 07:15:00 | AAPL | Stock | 26.575 | 26.575 | 26.575 | 26.575 | 4400.0 |
| 2016-03-18 07:20:00 | AAPL | Stock | 26.5625 | 26.6125 | 26.5625 | 26.6125 | 14800.0 |
| 2016-03-18 07:25:00 | AAPL | Stock | 26.6125 | 26.6125 | 26.6 | 26.6 | 12640.0 |
| 2016-03-18 07:30:00 | AAPL | Stock | 26.5875 | 26.5875 | 26.5625 | 26.5625 | 19872.0 |
| 2016-03-18 07:40:00 | AAPL | Stock | 26.5575 | 26.5575 | 26.5575 | 26.5575 | 800.0 |
| 2016-03-18 07:45:00 | AAPL | Stock | 26.5625 | 26.5625 | 26.5625 | 26.5625 | 880.0 |
| 2016-03-18 07:50:00 | AAPL | Stock | 26.5625 | 26.5625 | 26.5625 | 26.5625 | 600.0 |
| 2016-03-18 07:55:00 | AAPL | Stock | 26.5625 | 26.5625 | 26.5625 | 26.5625 | 3000.0 |
| 2016-03-18 08:00:00 | AAPL | Stock | 26.55 | 26.55 | 26.5 | 26.515 | 75736.0 |
| 2016-03-18 08:05:00 | AAPL | Stock | 26.52 | 26.5375 | 26.52 | 26.535 | 5400.0 |
| 2016-03-18 08:10:00 | AAPL | Stock | 26.535 | 26.5425 | 26.5275 | 26.5275 | 11432.0 |
| 2016-03-18 08:15:00 | AAPL | Stock | 26.5275 | 26.54 | 26.5275 | 26.54 | 7600.0 |
| 2016-03-18 08:20:00 | AAPL | Stock | 26.5425 | 26.5725 | 26.5425 | 26.5675 | 12392.0 |
| 2016-03-18 08:25:00 | AAPL | Stock | 26.5725 | 26.5825 | 26.57 | 26.5825 | 20184.0 |
| 2016-03-18 08:30:00 | AAPL | Stock | 26.5825 | 26.5875 | 26.575 | 26.5875 | 35480.0 |
| 2016-03-18 08:35:00 | AAPL | Stock | 26.58 | 26.6 | 26.5775 | 26.5775 | 10208.0 |
| 2016-03-18 08:40:00 | AAPL | Stock | 26.5775 | 26.58 | 26.575 | 26.58 | 11380.0 |
| 2016-03-18 08:45:00 | AAPL | Stock | 26.5825 | 26.5825 | 26.5675 | 26.5675 | 15340.0 |
| 2016-03-18 08:50:00 | AAPL | Stock | 26.5625 | 26.5675 | 26.5625 | 26.5625 | 12768.0 |
| 2016-03-18 08:55:00 | AAPL | Stock | 26.56 | 26.5675 | 26.55 | 26.5675 | 5600.0 |
| 2016-03-18 09:00:00 | AAPL | Stock | 26.5625 | 26.5875 | 26.5625 | 26.5775 | 28288.0 |
| 2016-03-18 09:05:00 | AAPL | Stock | 26.58 | 26.5825 | 26.575 | 26.5825 | 12080.0 |
| 2016-03-18 09:10:00 | AAPL | Stock | 26.5775 | 26.58 | 26.56 | 26.5625 | 43592.0 |
| 2016-03-18 09:15:00 | AAPL | Stock | 26.5625 | 26.5625 | 26.55 | 26.55 | 52060.0 |
| 2016-03-18 09:20:00 | AAPL | Stock | 26.5525 | 26.5525 | 26.54 | 26.54 | 80580.0 |
| 2016-03-18 09:25:00 | AAPL | Stock | 26.5625 | 26.6625 | 26.5625 | 26.6 | 2158716.0 |
| 2016-03-18 09:30:00 | AAPL | Stock | 26.59 | 26.625 | 26.4725 | 26.4825 | 37399908.0 |
| 2016-03-18 09:35:00 | AAPL | Stock | 26.4825 | 26.51 | 26.42 | 26.4325 | 2398884.0 |
| 2016-03-18 09:40:00 | AAPL | Stock | 26.4302 | 26.4925 | 26.3975 | 26.3975 | 2753672.0 |
| 2016-03-18 09:45:00 | AAPL | Stock | 26.395 | 26.4375 | 26.3528 | 26.3685 | 2443544.0 |
| 2016-03-18 09:50:00 | AAPL | Stock | 26.37 | 26.4325 | 26.36 | 26.4 | 2094456.0 |
| 2016-03-18 09:55:00 | AAPL | Stock | 26.4025 | 26.4275 | 26.36 | 26.3775 | 2265152.0 |
| 2016-03-18 10:00:00 | AAPL | Stock | 26.3752 | 26.4575 | 26.37 | 26.44 | 2822904.0 |
| 2016-03-18 10:05:00 | AAPL | Stock | 26.4412 | 26.4725 | 26.4275 | 26.4625 | 1533700.0 |
| 2016-03-18 10:10:00 | AAPL | Stock | 26.465 | 26.4725 | 26.44 | 26.4475 | 1024116.0 |
| 2016-03-18 10:15:00 | AAPL | Stock | 26.449 | 26.4625 | 26.4075 | 26.4075 | 1228468.0 |
| 2016-03-18 10:20:00 | AAPL | Stock | 26.4088 | 26.435 | 26.4075 | 26.4175 | 998920.0 |
| 2016-03-18 10:25:00 | AAPL | Stock | 26.4175 | 26.4375 | 26.4025 | 26.4325 | 968156.0 |
| 2016-03-18 10:30:00 | AAPL | Stock | 26.4325 | 26.495 | 26.43 | 26.4875 | 1545412.0 |
| 2016-03-18 10:35:00 | AAPL | Stock | 26.488 | 26.4925 | 26.405 | 26.4052 | 1268180.0 |
| 2016-03-18 10:40:00 | AAPL | Stock | 26.4052 | 26.4525 | 26.405 | 26.4475 | 1117776.0 |
| 2016-03-18 10:45:00 | AAPL | Stock | 26.4475 | 26.4525 | 26.415 | 26.4175 | 888700.0 |
> showing 50 of 367,171 rows — these rows as CSV