PREVIEW / stock_5min / 2017-12-29
file: by_date/stock_5min/2017/2017-12-29.parquet size: 5.7 MB rows: 370,113 symbols: 2,927
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-12-29 05:00:00 | AAPL | Stock | 42.7 | 42.7 | 42.7 | 42.7 | 3600.0 |
| 2017-12-29 06:00:00 | AAPL | Stock | 42.7 | 42.7 | 42.7 | 42.7 | 400.0 |
| 2017-12-29 06:05:00 | AAPL | Stock | 42.725 | 42.725 | 42.725 | 42.725 | 440.0 |
| 2017-12-29 06:10:00 | AAPL | Stock | 42.725 | 42.725 | 42.725 | 42.725 | 2000.0 |
| 2017-12-29 06:15:00 | AAPL | Stock | 42.725 | 42.725 | 42.725 | 42.725 | 1280.0 |
| 2017-12-29 06:30:00 | AAPL | Stock | 42.73 | 42.73 | 42.73 | 42.73 | 3560.0 |
| 2017-12-29 06:40:00 | AAPL | Stock | 42.7625 | 42.7625 | 42.7625 | 42.7625 | 4000.0 |
| 2017-12-29 06:45:00 | AAPL | Stock | 42.7625 | 42.7675 | 42.7625 | 42.7675 | 11452.0 |
| 2017-12-29 06:55:00 | AAPL | Stock | 42.735 | 42.735 | 42.735 | 42.735 | 400.0 |
| 2017-12-29 07:00:00 | AAPL | Stock | 42.735 | 42.77 | 42.735 | 42.77 | 12380.0 |
| 2017-12-29 07:05:00 | AAPL | Stock | 42.775 | 42.775 | 42.775 | 42.775 | 2024.0 |
| 2017-12-29 07:10:00 | AAPL | Stock | 42.775 | 42.7875 | 42.775 | 42.7775 | 5900.0 |
| 2017-12-29 07:15:00 | AAPL | Stock | 42.795 | 42.795 | 42.795 | 42.795 | 5600.0 |
| 2017-12-29 07:20:00 | AAPL | Stock | 42.7875 | 42.825 | 42.7875 | 42.825 | 1124.0 |
| 2017-12-29 07:25:00 | AAPL | Stock | 42.8 | 42.825 | 42.7875 | 42.825 | 31760.0 |
| 2017-12-29 07:30:00 | AAPL | Stock | 42.8175 | 42.8375 | 42.795 | 42.795 | 4920.0 |
| 2017-12-29 07:35:00 | AAPL | Stock | 42.8075 | 42.8075 | 42.8075 | 42.8075 | 12000.0 |
| 2017-12-29 07:40:00 | AAPL | Stock | 42.8075 | 42.8225 | 42.8075 | 42.8225 | 1624.0 |
| 2017-12-29 07:45:00 | AAPL | Stock | 42.81 | 42.81 | 42.8075 | 42.8075 | 6800.0 |
| 2017-12-29 07:50:00 | AAPL | Stock | 42.8075 | 42.8075 | 42.8075 | 42.8075 | 2800.0 |
| 2017-12-29 07:55:00 | AAPL | Stock | 42.8075 | 42.8075 | 42.8075 | 42.8075 | 7848.0 |
| 2017-12-29 08:00:00 | AAPL | Stock | 42.8125 | 42.8125 | 42.75 | 42.8075 | 15548.0 |
| 2017-12-29 08:05:00 | AAPL | Stock | 42.795 | 42.8075 | 42.795 | 42.8075 | 7372.0 |
| 2017-12-29 08:10:00 | AAPL | Stock | 42.7925 | 42.7925 | 42.75 | 42.75 | 63220.0 |
| 2017-12-29 08:15:00 | AAPL | Stock | 42.75 | 42.77 | 42.73 | 42.73 | 31728.0 |
| 2017-12-29 08:20:00 | AAPL | Stock | 42.72 | 42.7325 | 42.7175 | 42.72 | 14652.0 |
| 2017-12-29 08:25:00 | AAPL | Stock | 42.7225 | 42.735 | 42.7225 | 42.7325 | 6540.0 |
| 2017-12-29 08:30:00 | AAPL | Stock | 42.7375 | 42.745 | 42.7325 | 42.7325 | 11912.0 |
| 2017-12-29 08:35:00 | AAPL | Stock | 42.7325 | 42.7325 | 42.715 | 42.7175 | 28520.0 |
| 2017-12-29 08:40:00 | AAPL | Stock | 42.715 | 42.725 | 42.7075 | 42.7125 | 52412.0 |
| 2017-12-29 08:45:00 | AAPL | Stock | 42.7125 | 42.725 | 42.7 | 42.7 | 2580.0 |
| 2017-12-29 08:50:00 | AAPL | Stock | 42.7025 | 42.7125 | 42.7 | 42.7075 | 13020.0 |
| 2017-12-29 08:55:00 | AAPL | Stock | 42.7125 | 42.7125 | 42.7 | 42.7 | 10680.0 |
| 2017-12-29 09:00:00 | AAPL | Stock | 42.7 | 42.725 | 42.7 | 42.7075 | 26196.0 |
| 2017-12-29 09:05:00 | AAPL | Stock | 42.7075 | 42.7075 | 42.7075 | 42.7075 | 400.0 |
| 2017-12-29 09:10:00 | AAPL | Stock | 42.725 | 42.725 | 42.71 | 42.71 | 13912.0 |
| 2017-12-29 09:15:00 | AAPL | Stock | 42.725 | 42.725 | 42.725 | 42.725 | 9396.0 |
| 2017-12-29 09:20:00 | AAPL | Stock | 42.7375 | 42.7375 | 42.7325 | 42.7375 | 2800.0 |
| 2017-12-29 09:25:00 | AAPL | Stock | 42.735 | 42.7375 | 42.53 | 42.6775 | 357968.0 |
| 2017-12-29 09:30:00 | AAPL | Stock | 42.6775 | 42.6775 | 42.4875 | 42.5212 | 6931556.0 |
| 2017-12-29 09:35:00 | AAPL | Stock | 42.5225 | 42.5375 | 42.4625 | 42.48 | 3104624.0 |
| 2017-12-29 09:40:00 | AAPL | Stock | 42.4825 | 42.525 | 42.4275 | 42.4772 | 2635004.0 |
| 2017-12-29 09:45:00 | AAPL | Stock | 42.4768 | 42.525 | 42.455 | 42.5225 | 2350804.0 |
| 2017-12-29 09:50:00 | AAPL | Stock | 42.5225 | 42.53 | 42.4425 | 42.4725 | 1734004.0 |
| 2017-12-29 09:55:00 | AAPL | Stock | 42.4715 | 42.495 | 42.45 | 42.4825 | 1355684.0 |
| 2017-12-29 10:00:00 | AAPL | Stock | 42.48 | 42.4825 | 42.3875 | 42.4075 | 1996456.0 |
| 2017-12-29 10:05:00 | AAPL | Stock | 42.405 | 42.42 | 42.3275 | 42.365 | 2586352.0 |
| 2017-12-29 10:10:00 | AAPL | Stock | 42.3662 | 42.375 | 42.3325 | 42.3575 | 1311312.0 |
| 2017-12-29 10:15:00 | AAPL | Stock | 42.3588 | 42.4502 | 42.3325 | 42.4495 | 2716884.0 |
| 2017-12-29 10:20:00 | AAPL | Stock | 42.4475 | 42.4625 | 42.4112 | 42.4212 | 1015920.0 |
> showing 50 of 370,113 rows — these rows as CSV