PREVIEW / stock_5min / 2016-07-25
file: by_date/stock_5min/2016/2016-07-25.parquet size: 5.2 MB rows: 345,048 symbols: 3,268
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-07-25 04:00:00 | AAPL | Stock | 24.665 | 24.665 | 24.665 | 24.665 | 492.0 |
| 2016-07-25 04:20:00 | AAPL | Stock | 24.6375 | 24.6375 | 24.6375 | 24.6375 | 400.0 |
| 2016-07-25 04:25:00 | AAPL | Stock | 24.63 | 24.63 | 24.63 | 24.63 | 400.0 |
| 2016-07-25 04:40:00 | AAPL | Stock | 24.665 | 24.665 | 24.665 | 24.665 | 400.0 |
| 2016-07-25 05:00:00 | AAPL | Stock | 24.655 | 24.655 | 24.655 | 24.655 | 880.0 |
| 2016-07-25 05:30:00 | AAPL | Stock | 24.665 | 24.675 | 24.665 | 24.675 | 2760.0 |
| 2016-07-25 05:45:00 | AAPL | Stock | 24.65 | 24.65 | 24.65 | 24.65 | 400.0 |
| 2016-07-25 05:50:00 | AAPL | Stock | 24.625 | 24.625 | 24.625 | 24.625 | 2216.0 |
| 2016-07-25 06:00:00 | AAPL | Stock | 24.625 | 24.625 | 24.6 | 24.6 | 3240.0 |
| 2016-07-25 06:05:00 | AAPL | Stock | 24.595 | 24.595 | 24.595 | 24.595 | 760.0 |
| 2016-07-25 07:00:00 | AAPL | Stock | 24.6 | 24.6125 | 24.6 | 24.6125 | 2500.0 |
| 2016-07-25 07:10:00 | AAPL | Stock | 24.6 | 24.6225 | 24.6 | 24.6225 | 2400.0 |
| 2016-07-25 07:20:00 | AAPL | Stock | 24.6 | 24.6 | 24.6 | 24.6 | 400.0 |
| 2016-07-25 07:25:00 | AAPL | Stock | 24.6175 | 24.6175 | 24.6175 | 24.6175 | 3640.0 |
| 2016-07-25 07:30:00 | AAPL | Stock | 24.6 | 24.6175 | 24.6 | 24.6175 | 1400.0 |
| 2016-07-25 07:35:00 | AAPL | Stock | 24.6225 | 24.625 | 24.6225 | 24.625 | 7600.0 |
| 2016-07-25 07:40:00 | AAPL | Stock | 24.605 | 24.605 | 24.605 | 24.605 | 8440.0 |
| 2016-07-25 07:45:00 | AAPL | Stock | 24.6025 | 24.605 | 24.6025 | 24.605 | 824.0 |
| 2016-07-25 07:50:00 | AAPL | Stock | 24.5875 | 24.5875 | 24.5875 | 24.5875 | 800.0 |
| 2016-07-25 07:55:00 | AAPL | Stock | 24.5975 | 24.6 | 24.5975 | 24.6 | 2164.0 |
| 2016-07-25 08:00:00 | AAPL | Stock | 24.6 | 24.625 | 24.5625 | 24.6225 | 46096.0 |
| 2016-07-25 08:05:00 | AAPL | Stock | 24.61 | 24.61 | 24.6075 | 24.6075 | 14584.0 |
| 2016-07-25 08:10:00 | AAPL | Stock | 24.6075 | 24.615 | 24.6075 | 24.615 | 3400.0 |
| 2016-07-25 08:15:00 | AAPL | Stock | 24.605 | 24.605 | 24.605 | 24.605 | 8400.0 |
| 2016-07-25 08:20:00 | AAPL | Stock | 24.6125 | 24.6125 | 24.6075 | 24.6075 | 6988.0 |
| 2016-07-25 08:25:00 | AAPL | Stock | 24.6075 | 24.61 | 24.605 | 24.6075 | 8808.0 |
| 2016-07-25 08:30:00 | AAPL | Stock | 24.61 | 24.6175 | 24.6075 | 24.6075 | 27376.0 |
| 2016-07-25 08:35:00 | AAPL | Stock | 24.6075 | 24.6075 | 24.6075 | 24.6075 | 13240.0 |
| 2016-07-25 08:40:00 | AAPL | Stock | 24.6075 | 24.615 | 24.6075 | 24.615 | 26964.0 |
| 2016-07-25 08:45:00 | AAPL | Stock | 24.605 | 24.615 | 24.6 | 24.6 | 18676.0 |
| 2016-07-25 08:50:00 | AAPL | Stock | 24.6 | 24.615 | 24.6 | 24.615 | 14504.0 |
| 2016-07-25 08:55:00 | AAPL | Stock | 24.605 | 24.6125 | 24.6025 | 24.6125 | 7200.0 |
| 2016-07-25 09:00:00 | AAPL | Stock | 24.6 | 24.6 | 24.5875 | 24.5875 | 18576.0 |
| 2016-07-25 09:05:00 | AAPL | Stock | 24.5925 | 24.625 | 24.5925 | 24.6225 | 23244.0 |
| 2016-07-25 09:10:00 | AAPL | Stock | 24.6 | 24.625 | 24.6 | 24.625 | 7000.0 |
| 2016-07-25 09:15:00 | AAPL | Stock | 24.6 | 24.6 | 24.595 | 24.595 | 4916.0 |
| 2016-07-25 09:20:00 | AAPL | Stock | 24.6075 | 24.625 | 24.6075 | 24.625 | 14840.0 |
| 2016-07-25 09:25:00 | AAPL | Stock | 24.625 | 24.625 | 24.5625 | 24.5625 | 457364.0 |
| 2016-07-25 09:30:00 | AAPL | Stock | 24.5625 | 24.665 | 24.54 | 24.612 | 6467088.0 |
| 2016-07-25 09:35:00 | AAPL | Stock | 24.6135 | 24.6225 | 24.575 | 24.5763 | 2703864.0 |
| 2016-07-25 09:40:00 | AAPL | Stock | 24.575 | 24.62 | 24.5575 | 24.6188 | 2766300.0 |
| 2016-07-25 09:45:00 | AAPL | Stock | 24.618 | 24.71 | 24.61 | 24.7 | 4132264.0 |
| 2016-07-25 09:50:00 | AAPL | Stock | 24.7018 | 24.7025 | 24.6575 | 24.6775 | 2740544.0 |
| 2016-07-25 09:55:00 | AAPL | Stock | 24.6775 | 24.6775 | 24.5475 | 24.581 | 4118380.0 |
| 2016-07-25 10:00:00 | AAPL | Stock | 24.581 | 24.595 | 24.555 | 24.58 | 1967840.0 |
| 2016-07-25 10:05:00 | AAPL | Stock | 24.5788 | 24.5825 | 24.505 | 24.5325 | 2858724.0 |
| 2016-07-25 10:10:00 | AAPL | Stock | 24.535 | 24.5413 | 24.4725 | 24.4975 | 3242752.0 |
| 2016-07-25 10:15:00 | AAPL | Stock | 24.495 | 24.515 | 24.4725 | 24.5135 | 1772500.0 |
| 2016-07-25 10:20:00 | AAPL | Stock | 24.5128 | 24.5175 | 24.495 | 24.5 | 1214472.0 |
| 2016-07-25 10:25:00 | AAPL | Stock | 24.5 | 24.505 | 24.4912 | 24.495 | 1720568.0 |
> showing 50 of 345,048 rows — these rows as CSV