PREVIEW / stock_5min / 2018-11-23
file: by_date/stock_5min/2018/2018-11-23.parquet size: 3.2 MB rows: 193,212 symbols: 2,622
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-11-23 04:00:00 | AAPL | Stock | 43.9725 | 43.9725 | 43.875 | 43.875 | 9628.0 |
| 2018-11-23 04:05:00 | AAPL | Stock | 43.875 | 43.875 | 43.875 | 43.875 | 1508.0 |
| 2018-11-23 04:15:00 | AAPL | Stock | 43.875 | 43.875 | 43.875 | 43.875 | 400.0 |
| 2018-11-23 04:20:00 | AAPL | Stock | 43.875 | 43.875 | 43.875 | 43.875 | 3620.0 |
| 2018-11-23 04:50:00 | AAPL | Stock | 43.9 | 43.9 | 43.9 | 43.9 | 3200.0 |
| 2018-11-23 04:55:00 | AAPL | Stock | 43.9 | 43.925 | 43.9 | 43.925 | 4184.0 |
| 2018-11-23 05:00:00 | AAPL | Stock | 43.925 | 43.925 | 43.925 | 43.925 | 1200.0 |
| 2018-11-23 05:30:00 | AAPL | Stock | 43.8775 | 43.8775 | 43.8525 | 43.8525 | 960.0 |
| 2018-11-23 05:35:00 | AAPL | Stock | 43.79 | 43.91 | 43.7 | 43.7 | 4700.0 |
| 2018-11-23 05:45:00 | AAPL | Stock | 43.675 | 43.7 | 43.675 | 43.7 | 2080.0 |
| 2018-11-23 05:55:00 | AAPL | Stock | 43.7775 | 43.7775 | 43.7775 | 43.7775 | 400.0 |
| 2018-11-23 06:00:00 | AAPL | Stock | 43.75 | 43.75 | 43.75 | 43.75 | 400.0 |
| 2018-11-23 06:05:00 | AAPL | Stock | 43.7375 | 43.7525 | 43.7375 | 43.7525 | 1096.0 |
| 2018-11-23 06:10:00 | AAPL | Stock | 43.825 | 43.825 | 43.775 | 43.775 | 2016.0 |
| 2018-11-23 06:20:00 | AAPL | Stock | 43.7375 | 43.7375 | 43.7375 | 43.7375 | 400.0 |
| 2018-11-23 06:30:00 | AAPL | Stock | 43.775 | 43.775 | 43.775 | 43.775 | 400.0 |
| 2018-11-23 06:55:00 | AAPL | Stock | 43.775 | 43.7875 | 43.77 | 43.7875 | 1940.0 |
| 2018-11-23 07:00:00 | AAPL | Stock | 43.8225 | 43.925 | 43.7875 | 43.8975 | 31940.0 |
| 2018-11-23 07:05:00 | AAPL | Stock | 43.9 | 43.9 | 43.8375 | 43.8875 | 5292.0 |
| 2018-11-23 07:10:00 | AAPL | Stock | 43.8725 | 43.8725 | 43.825 | 43.8625 | 1800.0 |
| 2018-11-23 07:15:00 | AAPL | Stock | 43.8725 | 43.875 | 43.8725 | 43.875 | 2320.0 |
| 2018-11-23 07:20:00 | AAPL | Stock | 43.8975 | 43.91 | 43.8975 | 43.9 | 4024.0 |
| 2018-11-23 07:25:00 | AAPL | Stock | 43.9 | 43.915 | 43.9 | 43.915 | 10280.0 |
| 2018-11-23 07:30:00 | AAPL | Stock | 43.8825 | 43.9025 | 43.8825 | 43.9 | 4664.0 |
| 2018-11-23 07:35:00 | AAPL | Stock | 43.925 | 43.925 | 43.925 | 43.925 | 13836.0 |
| 2018-11-23 07:40:00 | AAPL | Stock | 43.95 | 43.97 | 43.9475 | 43.95 | 7732.0 |
| 2018-11-23 07:45:00 | AAPL | Stock | 43.9625 | 43.9625 | 43.9375 | 43.95 | 9744.0 |
| 2018-11-23 07:50:00 | AAPL | Stock | 43.95 | 43.9875 | 43.95 | 43.975 | 10176.0 |
| 2018-11-23 07:55:00 | AAPL | Stock | 43.98 | 43.9875 | 43.98 | 43.9875 | 3608.0 |
| 2018-11-23 08:00:00 | AAPL | Stock | 43.93 | 44.0 | 43.8 | 44.0 | 58688.0 |
| 2018-11-23 08:05:00 | AAPL | Stock | 43.9875 | 43.9875 | 43.9125 | 43.9128 | 26612.0 |
| 2018-11-23 08:10:00 | AAPL | Stock | 43.9125 | 43.95 | 43.865 | 43.9125 | 14616.0 |
| 2018-11-23 08:15:00 | AAPL | Stock | 43.9025 | 43.94 | 43.875 | 43.9 | 47284.0 |
| 2018-11-23 08:20:00 | AAPL | Stock | 43.88 | 43.88 | 43.8475 | 43.86 | 12640.0 |
| 2018-11-23 08:25:00 | AAPL | Stock | 43.85 | 43.86 | 43.795 | 43.85 | 14968.0 |
| 2018-11-23 08:30:00 | AAPL | Stock | 43.85 | 43.86 | 43.75 | 43.7525 | 71024.0 |
| 2018-11-23 08:35:00 | AAPL | Stock | 43.75 | 43.7625 | 43.675 | 43.725 | 67000.0 |
| 2018-11-23 08:40:00 | AAPL | Stock | 43.725 | 43.75 | 43.625 | 43.6625 | 87744.0 |
| 2018-11-23 08:45:00 | AAPL | Stock | 43.6525 | 43.705 | 43.6375 | 43.705 | 28624.0 |
| 2018-11-23 08:50:00 | AAPL | Stock | 43.7125 | 43.75 | 43.675 | 43.6875 | 44116.0 |
| 2018-11-23 08:55:00 | AAPL | Stock | 43.72 | 43.725 | 43.6225 | 43.725 | 33336.0 |
| 2018-11-23 09:00:00 | AAPL | Stock | 43.7425 | 43.7425 | 43.6975 | 43.73 | 51676.0 |
| 2018-11-23 09:05:00 | AAPL | Stock | 43.723 | 43.7325 | 43.6675 | 43.69 | 79100.0 |
| 2018-11-23 09:10:00 | AAPL | Stock | 43.675 | 43.705 | 43.6575 | 43.6875 | 38616.0 |
| 2018-11-23 09:15:00 | AAPL | Stock | 43.7 | 43.715 | 43.6675 | 43.67 | 35568.0 |
| 2018-11-23 09:20:00 | AAPL | Stock | 43.675 | 43.7075 | 43.625 | 43.68 | 53772.0 |
| 2018-11-23 09:25:00 | AAPL | Stock | 43.6875 | 43.75 | 43.6625 | 43.73 | 377736.0 |
| 2018-11-23 09:30:00 | AAPL | Stock | 43.725 | 44.0225 | 43.5 | 44.0125 | 7316304.0 |
| 2018-11-23 09:35:00 | AAPL | Stock | 43.9975 | 44.1075 | 43.8925 | 44.0125 | 2643120.0 |
| 2018-11-23 09:40:00 | AAPL | Stock | 44.0225 | 44.0425 | 43.8375 | 43.96 | 2028776.0 |
> showing 50 of 193,212 rows — these rows as CSV