PREVIEW / stock_5min / 2018-10-17
file: by_date/stock_5min/2018/2018-10-17.parquet size: 5.6 MB rows: 352,819 symbols: 2,758
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-17 04:00:00 | AAPL | Stock | 55.7875 | 55.9825 | 55.7875 | 55.9825 | 6000.0 |
| 2018-10-17 04:05:00 | AAPL | Stock | 55.98 | 55.9825 | 55.98 | 55.9825 | 800.0 |
| 2018-10-17 04:10:00 | AAPL | Stock | 55.9825 | 55.9825 | 55.95 | 55.95 | 1200.0 |
| 2018-10-17 04:15:00 | AAPL | Stock | 55.9475 | 55.9475 | 55.875 | 55.875 | 9200.0 |
| 2018-10-17 04:20:00 | AAPL | Stock | 55.875 | 55.875 | 55.865 | 55.865 | 4000.0 |
| 2018-10-17 04:30:00 | AAPL | Stock | 55.945 | 55.945 | 55.945 | 55.945 | 400.0 |
| 2018-10-17 04:35:00 | AAPL | Stock | 55.9275 | 55.9475 | 55.9275 | 55.9475 | 4720.0 |
| 2018-10-17 04:40:00 | AAPL | Stock | 55.9275 | 55.9275 | 55.9275 | 55.9275 | 400.0 |
| 2018-10-17 04:45:00 | AAPL | Stock | 55.92 | 55.92 | 55.92 | 55.92 | 400.0 |
| 2018-10-17 04:50:00 | AAPL | Stock | 55.915 | 55.915 | 55.91 | 55.91 | 2800.0 |
| 2018-10-17 04:55:00 | AAPL | Stock | 55.875 | 55.875 | 55.86 | 55.86 | 6464.0 |
| 2018-10-17 05:00:00 | AAPL | Stock | 55.925 | 55.925 | 55.925 | 55.925 | 400.0 |
| 2018-10-17 05:05:00 | AAPL | Stock | 55.9175 | 55.9175 | 55.9175 | 55.9175 | 400.0 |
| 2018-10-17 05:25:00 | AAPL | Stock | 55.8475 | 55.8475 | 55.8475 | 55.8475 | 1608.0 |
| 2018-10-17 05:30:00 | AAPL | Stock | 55.8475 | 55.8475 | 55.8475 | 55.8475 | 892.0 |
| 2018-10-17 05:35:00 | AAPL | Stock | 55.8375 | 55.8475 | 55.8375 | 55.8475 | 1892.0 |
| 2018-10-17 05:55:00 | AAPL | Stock | 55.8375 | 55.8425 | 55.8375 | 55.8425 | 856.0 |
| 2018-10-17 06:05:00 | AAPL | Stock | 55.7875 | 55.7875 | 55.7875 | 55.7875 | 400.0 |
| 2018-10-17 06:10:00 | AAPL | Stock | 55.75 | 55.75 | 55.6875 | 55.725 | 2824.0 |
| 2018-10-17 06:20:00 | AAPL | Stock | 55.69 | 55.69 | 55.69 | 55.69 | 800.0 |
| 2018-10-17 06:25:00 | AAPL | Stock | 55.69 | 55.69 | 55.69 | 55.69 | 768.0 |
| 2018-10-17 06:30:00 | AAPL | Stock | 55.69 | 55.725 | 55.69 | 55.725 | 4540.0 |
| 2018-10-17 06:35:00 | AAPL | Stock | 55.7075 | 55.71 | 55.7075 | 55.71 | 3600.0 |
| 2018-10-17 06:40:00 | AAPL | Stock | 55.715 | 55.7375 | 55.715 | 55.7375 | 40784.0 |
| 2018-10-17 06:45:00 | AAPL | Stock | 55.7475 | 55.7475 | 55.7475 | 55.7475 | 400.0 |
| 2018-10-17 06:50:00 | AAPL | Stock | 55.795 | 55.8 | 55.75 | 55.8 | 4996.0 |
| 2018-10-17 06:55:00 | AAPL | Stock | 55.7575 | 55.7575 | 55.715 | 55.715 | 3708.0 |
| 2018-10-17 07:00:00 | AAPL | Stock | 55.75 | 55.7925 | 55.75 | 55.7925 | 8244.0 |
| 2018-10-17 07:05:00 | AAPL | Stock | 55.79 | 55.795 | 55.7575 | 55.7775 | 5616.0 |
| 2018-10-17 07:10:00 | AAPL | Stock | 55.7775 | 55.7775 | 55.7775 | 55.7775 | 800.0 |
| 2018-10-17 07:15:00 | AAPL | Stock | 55.75 | 55.77 | 55.75 | 55.75 | 11632.0 |
| 2018-10-17 07:20:00 | AAPL | Stock | 55.7475 | 55.75 | 55.69 | 55.7 | 11444.0 |
| 2018-10-17 07:25:00 | AAPL | Stock | 55.6875 | 55.6875 | 55.65 | 55.65 | 4908.0 |
| 2018-10-17 07:30:00 | AAPL | Stock | 55.65 | 55.65 | 55.5875 | 55.5875 | 29956.0 |
| 2018-10-17 07:35:00 | AAPL | Stock | 55.5875 | 55.6125 | 55.575 | 55.5875 | 12412.0 |
| 2018-10-17 07:45:00 | AAPL | Stock | 55.5875 | 55.6 | 55.5525 | 55.5525 | 8800.0 |
| 2018-10-17 07:50:00 | AAPL | Stock | 55.5625 | 55.5625 | 55.5075 | 55.5275 | 19188.0 |
| 2018-10-17 07:55:00 | AAPL | Stock | 55.5375 | 55.54 | 55.4625 | 55.4975 | 36336.0 |
| 2018-10-17 08:00:00 | AAPL | Stock | 55.525 | 55.8125 | 55.45 | 55.465 | 80668.0 |
| 2018-10-17 08:05:00 | AAPL | Stock | 55.4675 | 55.525 | 55.4375 | 55.51 | 105284.0 |
| 2018-10-17 08:10:00 | AAPL | Stock | 55.5 | 55.5 | 55.4375 | 55.45 | 7632.0 |
| 2018-10-17 08:15:00 | AAPL | Stock | 55.3925 | 55.4375 | 55.3625 | 55.43 | 16136.0 |
| 2018-10-17 08:20:00 | AAPL | Stock | 55.4225 | 55.4225 | 55.3875 | 55.4125 | 17540.0 |
| 2018-10-17 08:25:00 | AAPL | Stock | 55.4125 | 55.4625 | 55.4125 | 55.4625 | 19068.0 |
| 2018-10-17 08:30:00 | AAPL | Stock | 55.4625 | 55.49 | 55.3875 | 55.425 | 22468.0 |
| 2018-10-17 08:35:00 | AAPL | Stock | 55.45 | 55.48 | 55.425 | 55.4625 | 19776.0 |
| 2018-10-17 08:40:00 | AAPL | Stock | 55.465 | 55.4975 | 55.465 | 55.4875 | 17124.0 |
| 2018-10-17 08:45:00 | AAPL | Stock | 55.4875 | 55.495 | 55.46 | 55.495 | 18116.0 |
| 2018-10-17 08:50:00 | AAPL | Stock | 55.485 | 55.56 | 55.485 | 55.5575 | 28344.0 |
| 2018-10-17 08:55:00 | AAPL | Stock | 55.555 | 55.555 | 55.525 | 55.55 | 4800.0 |
> showing 50 of 352,819 rows — these rows as CSV