PREVIEW / stock_5min / 2017-05-10
file: by_date/stock_5min/2017/2017-05-10.parquet size: 5.5 MB rows: 358,745 symbols: 3,026
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 |
|---|---|---|---|---|---|---|---|
| 2017-05-10 04:00:00 | AAPL | Stock | 38.395 | 38.395 | 38.395 | 38.395 | 400.0 |
| 2017-05-10 05:00:00 | AAPL | Stock | 38.3175 | 38.3175 | 38.3175 | 38.3175 | 5836.0 |
| 2017-05-10 05:10:00 | AAPL | Stock | 38.3175 | 38.3175 | 38.3175 | 38.3175 | 800.0 |
| 2017-05-10 05:15:00 | AAPL | Stock | 38.275 | 38.275 | 38.275 | 38.275 | 15416.0 |
| 2017-05-10 05:45:00 | AAPL | Stock | 38.3175 | 38.3175 | 38.3175 | 38.3175 | 400.0 |
| 2017-05-10 06:10:00 | AAPL | Stock | 38.33 | 38.33 | 38.33 | 38.33 | 7920.0 |
| 2017-05-10 06:25:00 | AAPL | Stock | 38.325 | 38.325 | 38.325 | 38.325 | 2000.0 |
| 2017-05-10 06:35:00 | AAPL | Stock | 38.325 | 38.33 | 38.325 | 38.33 | 2000.0 |
| 2017-05-10 06:45:00 | AAPL | Stock | 38.3575 | 38.3575 | 38.3275 | 38.3275 | 15188.0 |
| 2017-05-10 06:50:00 | AAPL | Stock | 38.3175 | 38.3175 | 38.305 | 38.305 | 2180.0 |
| 2017-05-10 06:55:00 | AAPL | Stock | 38.3175 | 38.3175 | 38.3175 | 38.3175 | 1200.0 |
| 2017-05-10 07:00:00 | AAPL | Stock | 38.325 | 38.325 | 38.3 | 38.3 | 50364.0 |
| 2017-05-10 07:05:00 | AAPL | Stock | 38.3 | 38.3175 | 38.3 | 38.3175 | 10376.0 |
| 2017-05-10 07:10:00 | AAPL | Stock | 38.3175 | 38.3375 | 38.305 | 38.305 | 11524.0 |
| 2017-05-10 07:15:00 | AAPL | Stock | 38.305 | 38.31 | 38.305 | 38.31 | 2460.0 |
| 2017-05-10 07:20:00 | AAPL | Stock | 38.31 | 38.31 | 38.3 | 38.3 | 20000.0 |
| 2017-05-10 07:25:00 | AAPL | Stock | 38.3 | 38.3125 | 38.3 | 38.3125 | 18732.0 |
| 2017-05-10 07:30:00 | AAPL | Stock | 38.3125 | 38.3125 | 38.29 | 38.29 | 39780.0 |
| 2017-05-10 07:35:00 | AAPL | Stock | 38.3075 | 38.3075 | 38.2675 | 38.2675 | 14320.0 |
| 2017-05-10 07:40:00 | AAPL | Stock | 38.275 | 38.2875 | 38.275 | 38.2875 | 12912.0 |
| 2017-05-10 07:45:00 | AAPL | Stock | 38.2875 | 38.3 | 38.275 | 38.275 | 27084.0 |
| 2017-05-10 07:50:00 | AAPL | Stock | 38.275 | 38.275 | 38.2625 | 38.275 | 12832.0 |
| 2017-05-10 07:55:00 | AAPL | Stock | 38.3075 | 38.3075 | 38.305 | 38.305 | 2000.0 |
| 2017-05-10 08:00:00 | AAPL | Stock | 38.3175 | 38.3175 | 38.2625 | 38.3025 | 162360.0 |
| 2017-05-10 08:05:00 | AAPL | Stock | 38.3025 | 38.3025 | 38.3 | 38.3 | 22268.0 |
| 2017-05-10 08:10:00 | AAPL | Stock | 38.295 | 38.3 | 38.23 | 38.23 | 98912.0 |
| 2017-05-10 08:15:00 | AAPL | Stock | 38.27 | 38.4975 | 38.2275 | 38.2325 | 260844.0 |
| 2017-05-10 08:20:00 | AAPL | Stock | 38.2325 | 38.245 | 38.1875 | 38.2025 | 90336.0 |
| 2017-05-10 08:25:00 | AAPL | Stock | 38.21 | 38.2475 | 38.205 | 38.2475 | 52332.0 |
| 2017-05-10 08:30:00 | AAPL | Stock | 38.2475 | 38.2925 | 38.2475 | 38.2925 | 75108.0 |
| 2017-05-10 08:35:00 | AAPL | Stock | 38.2925 | 38.3 | 38.24 | 38.2675 | 73344.0 |
| 2017-05-10 08:40:00 | AAPL | Stock | 38.4975 | 38.4975 | 38.25 | 38.2675 | 33176.0 |
| 2017-05-10 08:45:00 | AAPL | Stock | 38.2625 | 38.2625 | 38.255 | 38.255 | 2900.0 |
| 2017-05-10 08:50:00 | AAPL | Stock | 38.2525 | 38.2525 | 38.225 | 38.2275 | 17716.0 |
| 2017-05-10 08:55:00 | AAPL | Stock | 38.2275 | 38.2625 | 38.2275 | 38.2625 | 14720.0 |
| 2017-05-10 09:00:00 | AAPL | Stock | 38.2625 | 38.2825 | 38.26 | 38.2675 | 32624.0 |
| 2017-05-10 09:05:00 | AAPL | Stock | 38.2625 | 38.3 | 38.25 | 38.29 | 39640.0 |
| 2017-05-10 09:10:00 | AAPL | Stock | 38.29 | 38.3375 | 38.2875 | 38.3375 | 58784.0 |
| 2017-05-10 09:15:00 | AAPL | Stock | 38.3375 | 38.365 | 38.3375 | 38.365 | 37564.0 |
| 2017-05-10 09:20:00 | AAPL | Stock | 38.365 | 38.395 | 38.35 | 38.3925 | 76176.0 |
| 2017-05-10 09:25:00 | AAPL | Stock | 38.395 | 38.4125 | 38.375 | 38.4025 | 54896.0 |
| 2017-05-10 09:30:00 | AAPL | Stock | 38.4075 | 38.485 | 38.365 | 38.3675 | 4460308.0 |
| 2017-05-10 09:35:00 | AAPL | Stock | 38.3675 | 38.395 | 38.3 | 38.3005 | 2146908.0 |
| 2017-05-10 09:40:00 | AAPL | Stock | 38.301 | 38.3875 | 38.27 | 38.378 | 2340316.0 |
| 2017-05-10 09:45:00 | AAPL | Stock | 38.3775 | 38.3905 | 38.3125 | 38.3175 | 1565632.0 |
| 2017-05-10 09:50:00 | AAPL | Stock | 38.3175 | 38.3175 | 38.225 | 38.2825 | 2488088.0 |
| 2017-05-10 09:55:00 | AAPL | Stock | 38.285 | 38.3075 | 38.2537 | 38.255 | 1404220.0 |
| 2017-05-10 10:00:00 | AAPL | Stock | 38.2525 | 38.255 | 38.1325 | 38.14 | 3162808.0 |
| 2017-05-10 10:05:00 | AAPL | Stock | 38.146 | 38.1975 | 38.105 | 38.1725 | 2320924.0 |
| 2017-05-10 10:10:00 | AAPL | Stock | 38.1725 | 38.1975 | 38.13 | 38.135 | 1251412.0 |
> showing 50 of 358,745 rows — these rows as CSV