PREVIEW / stock_5min / 2016-11-16
file: by_date/stock_5min/2016/2016-11-16.parquet size: 5.5 MB rows: 363,379 symbols: 3,184
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-11-16 04:15:00 | AAPL | Stock | 26.7775 | 26.8525 | 26.75 | 26.8525 | 4228.0 |
| 2016-11-16 04:40:00 | AAPL | Stock | 26.7525 | 26.7525 | 26.7525 | 26.7525 | 460.0 |
| 2016-11-16 04:50:00 | AAPL | Stock | 26.79 | 26.79 | 26.79 | 26.79 | 1600.0 |
| 2016-11-16 04:55:00 | AAPL | Stock | 26.755 | 26.755 | 26.73 | 26.73 | 1520.0 |
| 2016-11-16 05:05:00 | AAPL | Stock | 26.715 | 26.715 | 26.715 | 26.715 | 400.0 |
| 2016-11-16 05:20:00 | AAPL | Stock | 26.715 | 26.715 | 26.715 | 26.715 | 812.0 |
| 2016-11-16 05:35:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 1216.0 |
| 2016-11-16 06:00:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 400.0 |
| 2016-11-16 06:05:00 | AAPL | Stock | 26.7375 | 26.7375 | 26.7375 | 26.7375 | 800.0 |
| 2016-11-16 06:10:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 2800.0 |
| 2016-11-16 06:20:00 | AAPL | Stock | 26.725 | 26.725 | 26.725 | 26.725 | 1076.0 |
| 2016-11-16 06:25:00 | AAPL | Stock | 26.725 | 26.725 | 26.7225 | 26.7225 | 2400.0 |
| 2016-11-16 06:30:00 | AAPL | Stock | 26.7225 | 26.7225 | 26.7125 | 26.7125 | 3284.0 |
| 2016-11-16 06:35:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 4400.0 |
| 2016-11-16 06:45:00 | AAPL | Stock | 26.7125 | 26.7125 | 26.7125 | 26.7125 | 400.0 |
| 2016-11-16 07:05:00 | AAPL | Stock | 26.7025 | 26.7025 | 26.7025 | 26.7025 | 2800.0 |
| 2016-11-16 07:10:00 | AAPL | Stock | 26.695 | 26.695 | 26.63 | 26.63 | 6344.0 |
| 2016-11-16 07:20:00 | AAPL | Stock | 26.63 | 26.64 | 26.63 | 26.64 | 4200.0 |
| 2016-11-16 07:25:00 | AAPL | Stock | 26.64 | 26.64 | 26.625 | 26.625 | 7564.0 |
| 2016-11-16 07:30:00 | AAPL | Stock | 26.6275 | 26.6275 | 26.625 | 26.625 | 3800.0 |
| 2016-11-16 07:45:00 | AAPL | Stock | 26.66 | 26.6625 | 26.64 | 26.64 | 2000.0 |
| 2016-11-16 08:00:00 | AAPL | Stock | 26.665 | 26.7125 | 26.625 | 26.65 | 33852.0 |
| 2016-11-16 08:05:00 | AAPL | Stock | 26.65 | 26.65 | 26.65 | 26.65 | 3600.0 |
| 2016-11-16 08:10:00 | AAPL | Stock | 26.6675 | 26.6675 | 26.6675 | 26.6675 | 1200.0 |
| 2016-11-16 08:15:00 | AAPL | Stock | 26.6675 | 26.6725 | 26.66 | 26.66 | 9200.0 |
| 2016-11-16 08:20:00 | AAPL | Stock | 26.6525 | 26.6525 | 26.6375 | 26.65 | 18528.0 |
| 2016-11-16 08:25:00 | AAPL | Stock | 26.65 | 26.65 | 26.6375 | 26.65 | 3600.0 |
| 2016-11-16 08:30:00 | AAPL | Stock | 26.6475 | 26.65 | 26.645 | 26.645 | 3936.0 |
| 2016-11-16 08:35:00 | AAPL | Stock | 26.63 | 26.645 | 26.58 | 26.635 | 10520.0 |
| 2016-11-16 08:40:00 | AAPL | Stock | 26.65 | 26.65 | 26.635 | 26.635 | 2584.0 |
| 2016-11-16 08:45:00 | AAPL | Stock | 26.6475 | 26.6475 | 26.595 | 26.595 | 19096.0 |
| 2016-11-16 08:50:00 | AAPL | Stock | 26.595 | 26.595 | 26.585 | 26.5875 | 12500.0 |
| 2016-11-16 08:55:00 | AAPL | Stock | 26.5875 | 26.5875 | 26.575 | 26.585 | 17488.0 |
| 2016-11-16 09:00:00 | AAPL | Stock | 26.575 | 26.605 | 26.575 | 26.5775 | 24004.0 |
| 2016-11-16 09:05:00 | AAPL | Stock | 26.5775 | 26.6 | 26.575 | 26.6 | 19976.0 |
| 2016-11-16 09:10:00 | AAPL | Stock | 26.585 | 26.6125 | 26.585 | 26.6 | 37164.0 |
| 2016-11-16 09:15:00 | AAPL | Stock | 26.6 | 26.61 | 26.595 | 26.61 | 28892.0 |
| 2016-11-16 09:20:00 | AAPL | Stock | 26.6 | 26.6125 | 26.595 | 26.6125 | 16780.0 |
| 2016-11-16 09:25:00 | AAPL | Stock | 26.625 | 26.7125 | 26.625 | 26.71 | 36100.0 |
| 2016-11-16 09:30:00 | AAPL | Stock | 26.675 | 26.7775 | 26.65 | 26.7775 | 4411940.0 |
| 2016-11-16 09:35:00 | AAPL | Stock | 26.7772 | 26.91 | 26.7768 | 26.9022 | 4685296.0 |
| 2016-11-16 09:40:00 | AAPL | Stock | 26.9 | 27.0725 | 26.885 | 27.0075 | 4885568.0 |
| 2016-11-16 09:45:00 | AAPL | Stock | 27.005 | 27.07 | 26.9275 | 27.035 | 3662404.0 |
| 2016-11-16 09:50:00 | AAPL | Stock | 27.0325 | 27.0475 | 26.99 | 27.005 | 3033992.0 |
| 2016-11-16 09:55:00 | AAPL | Stock | 27.005 | 27.0125 | 26.93 | 26.9362 | 2304112.0 |
| 2016-11-16 10:00:00 | AAPL | Stock | 26.9362 | 26.99 | 26.9275 | 26.9875 | 1669284.0 |
| 2016-11-16 10:05:00 | AAPL | Stock | 26.99 | 27.05 | 26.99 | 27.0325 | 2556356.0 |
| 2016-11-16 10:10:00 | AAPL | Stock | 27.0302 | 27.1325 | 27.0302 | 27.105 | 3494924.0 |
| 2016-11-16 10:15:00 | AAPL | Stock | 27.1062 | 27.16 | 27.0902 | 27.14 | 2525184.0 |
| 2016-11-16 10:20:00 | AAPL | Stock | 27.14 | 27.24 | 27.14 | 27.235 | 2522112.0 |
> showing 50 of 363,379 rows — these rows as CSV