PREVIEW / stock_5min / 2017-11-21
file: by_date/stock_5min/2017/2017-11-21.parquet size: 5.7 MB rows: 368,633 symbols: 2,972
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-11-21 04:00:00 | AAPL | Stock | 42.58 | 42.58 | 42.58 | 42.58 | 500.0 |
| 2017-11-21 04:05:00 | AAPL | Stock | 42.4775 | 42.4775 | 42.4775 | 42.4775 | 400.0 |
| 2017-11-21 05:25:00 | AAPL | Stock | 42.6 | 42.6225 | 42.595 | 42.6225 | 6000.0 |
| 2017-11-21 06:00:00 | AAPL | Stock | 42.6225 | 42.6225 | 42.6225 | 42.6225 | 2800.0 |
| 2017-11-21 06:20:00 | AAPL | Stock | 42.625 | 42.625 | 42.625 | 42.625 | 1080.0 |
| 2017-11-21 06:25:00 | AAPL | Stock | 42.57 | 42.57 | 42.57 | 42.57 | 1052.0 |
| 2017-11-21 06:30:00 | AAPL | Stock | 42.5875 | 42.5875 | 42.5875 | 42.5875 | 2944.0 |
| 2017-11-21 06:40:00 | AAPL | Stock | 42.6125 | 42.625 | 42.6125 | 42.625 | 2452.0 |
| 2017-11-21 06:45:00 | AAPL | Stock | 42.6 | 42.605 | 42.5875 | 42.605 | 3600.0 |
| 2017-11-21 06:50:00 | AAPL | Stock | 42.605 | 42.62 | 42.605 | 42.62 | 992.0 |
| 2017-11-21 06:55:00 | AAPL | Stock | 42.6125 | 42.6125 | 42.6125 | 42.6125 | 572.0 |
| 2017-11-21 07:00:00 | AAPL | Stock | 42.6225 | 42.6325 | 42.58 | 42.615 | 44700.0 |
| 2017-11-21 07:05:00 | AAPL | Stock | 42.625 | 42.625 | 42.625 | 42.625 | 404.0 |
| 2017-11-21 07:10:00 | AAPL | Stock | 42.6 | 42.625 | 42.6 | 42.625 | 6484.0 |
| 2017-11-21 07:15:00 | AAPL | Stock | 42.6475 | 42.65 | 42.6475 | 42.65 | 3800.0 |
| 2017-11-21 07:20:00 | AAPL | Stock | 42.65 | 42.6675 | 42.65 | 42.6625 | 3600.0 |
| 2017-11-21 07:25:00 | AAPL | Stock | 42.65 | 42.65 | 42.65 | 42.65 | 400.0 |
| 2017-11-21 07:30:00 | AAPL | Stock | 42.63 | 42.63 | 42.625 | 42.625 | 4624.0 |
| 2017-11-21 07:35:00 | AAPL | Stock | 42.6375 | 42.6375 | 42.6375 | 42.6375 | 400.0 |
| 2017-11-21 07:40:00 | AAPL | Stock | 42.645 | 42.645 | 42.6425 | 42.6425 | 5928.0 |
| 2017-11-21 07:45:00 | AAPL | Stock | 42.645 | 42.6475 | 42.645 | 42.6475 | 2504.0 |
| 2017-11-21 07:50:00 | AAPL | Stock | 42.6575 | 42.6575 | 42.65 | 42.65 | 3680.0 |
| 2017-11-21 08:00:00 | AAPL | Stock | 42.6375 | 42.67 | 42.62 | 42.655 | 40456.0 |
| 2017-11-21 08:05:00 | AAPL | Stock | 42.6625 | 42.675 | 42.6625 | 42.675 | 35920.0 |
| 2017-11-21 08:10:00 | AAPL | Stock | 42.675 | 42.675 | 42.65 | 42.665 | 8852.0 |
| 2017-11-21 08:15:00 | AAPL | Stock | 42.665 | 42.665 | 42.6375 | 42.6375 | 54440.0 |
| 2017-11-21 08:20:00 | AAPL | Stock | 42.6625 | 42.6625 | 42.6575 | 42.6625 | 5796.0 |
| 2017-11-21 08:25:00 | AAPL | Stock | 42.66 | 42.665 | 42.6575 | 42.6575 | 11288.0 |
| 2017-11-21 08:30:00 | AAPL | Stock | 42.66 | 42.6875 | 42.66 | 42.6625 | 62308.0 |
| 2017-11-21 08:35:00 | AAPL | Stock | 42.6825 | 42.7125 | 42.6725 | 42.68 | 45208.0 |
| 2017-11-21 08:40:00 | AAPL | Stock | 42.68 | 42.6875 | 42.675 | 42.6875 | 9960.0 |
| 2017-11-21 08:45:00 | AAPL | Stock | 42.68 | 42.685 | 42.6725 | 42.685 | 19960.0 |
| 2017-11-21 08:50:00 | AAPL | Stock | 42.68 | 42.69 | 42.6775 | 42.68 | 6204.0 |
| 2017-11-21 08:55:00 | AAPL | Stock | 42.68 | 42.68 | 42.6675 | 42.675 | 11156.0 |
| 2017-11-21 09:00:00 | AAPL | Stock | 42.6725 | 42.6725 | 42.65 | 42.6625 | 114940.0 |
| 2017-11-21 09:05:00 | AAPL | Stock | 42.6725 | 42.675 | 42.67 | 42.67 | 24800.0 |
| 2017-11-21 09:10:00 | AAPL | Stock | 42.6725 | 42.6825 | 42.6725 | 42.68 | 30868.0 |
| 2017-11-21 09:15:00 | AAPL | Stock | 42.685 | 42.685 | 42.67 | 42.67 | 22932.0 |
| 2017-11-21 09:20:00 | AAPL | Stock | 42.675 | 42.675 | 42.6625 | 42.6625 | 4972.0 |
| 2017-11-21 09:25:00 | AAPL | Stock | 42.64 | 42.75 | 42.64 | 42.7225 | 197004.0 |
| 2017-11-21 09:30:00 | AAPL | Stock | 42.695 | 42.9275 | 42.695 | 42.9175 | 4955008.0 |
| 2017-11-21 09:35:00 | AAPL | Stock | 42.9225 | 42.99 | 42.8925 | 42.9805 | 2524264.0 |
| 2017-11-21 09:40:00 | AAPL | Stock | 42.985 | 43.095 | 42.95 | 43.0725 | 2886576.0 |
| 2017-11-21 09:45:00 | AAPL | Stock | 43.075 | 43.165 | 43.0625 | 43.1475 | 2630552.0 |
| 2017-11-21 09:50:00 | AAPL | Stock | 43.145 | 43.16 | 43.095 | 43.115 | 1660616.0 |
| 2017-11-21 09:55:00 | AAPL | Stock | 43.1168 | 43.215 | 43.1032 | 43.2125 | 2383444.0 |
| 2017-11-21 10:00:00 | AAPL | Stock | 43.2112 | 43.255 | 43.2 | 43.2343 | 2132628.0 |
| 2017-11-21 10:05:00 | AAPL | Stock | 43.23 | 43.2475 | 43.195 | 43.2475 | 1604160.0 |
| 2017-11-21 10:10:00 | AAPL | Stock | 43.2463 | 43.305 | 43.2252 | 43.2962 | 1990656.0 |
| 2017-11-21 10:15:00 | AAPL | Stock | 43.2975 | 43.36 | 43.275 | 43.35 | 2140372.0 |
> showing 50 of 368,633 rows — these rows as CSV