PREVIEW / stock_5min / 2020-06-12
file: by_date/stock_5min/2020/2020-06-12.parquet size: 6.8 MB rows: 434,982 symbols: 2,412
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 |
|---|---|---|---|---|---|---|---|
| 2020-06-12 04:00:00 | AAPL | Stock | 85.25 | 85.265 | 85.245 | 85.265 | 10780.0 |
| 2020-06-12 04:05:00 | AAPL | Stock | 85.29 | 85.345 | 85.265 | 85.345 | 10316.0 |
| 2020-06-12 04:10:00 | AAPL | Stock | 85.3875 | 85.625 | 85.3875 | 85.6225 | 4028.0 |
| 2020-06-12 04:15:00 | AAPL | Stock | 85.625 | 85.6375 | 85.595 | 85.6375 | 1764.0 |
| 2020-06-12 04:20:00 | AAPL | Stock | 85.7075 | 85.7225 | 85.7 | 85.7 | 5328.0 |
| 2020-06-12 04:25:00 | AAPL | Stock | 85.7025 | 85.725 | 85.7 | 85.725 | 3632.0 |
| 2020-06-12 04:30:00 | AAPL | Stock | 85.67 | 85.6925 | 85.67 | 85.6925 | 1420.0 |
| 2020-06-12 04:40:00 | AAPL | Stock | 85.7 | 85.7725 | 85.7 | 85.755 | 7040.0 |
| 2020-06-12 04:45:00 | AAPL | Stock | 85.76 | 85.85 | 85.76 | 85.85 | 1200.0 |
| 2020-06-12 04:50:00 | AAPL | Stock | 85.75 | 85.81 | 85.75 | 85.785 | 1912.0 |
| 2020-06-12 04:55:00 | AAPL | Stock | 85.87 | 85.9775 | 85.825 | 85.9 | 4244.0 |
| 2020-06-12 05:00:00 | AAPL | Stock | 85.9 | 85.9475 | 85.725 | 85.725 | 14824.0 |
| 2020-06-12 05:05:00 | AAPL | Stock | 85.725 | 85.8 | 85.725 | 85.8 | 5820.0 |
| 2020-06-12 05:10:00 | AAPL | Stock | 85.725 | 85.725 | 85.725 | 85.725 | 732.0 |
| 2020-06-12 05:15:00 | AAPL | Stock | 85.7425 | 85.7425 | 85.7425 | 85.7425 | 400.0 |
| 2020-06-12 05:20:00 | AAPL | Stock | 85.7525 | 85.7525 | 85.7225 | 85.7225 | 2432.0 |
| 2020-06-12 05:25:00 | AAPL | Stock | 85.7175 | 85.7175 | 85.7175 | 85.7175 | 752.0 |
| 2020-06-12 05:30:00 | AAPL | Stock | 85.66 | 85.66 | 85.66 | 85.66 | 548.0 |
| 2020-06-12 05:40:00 | AAPL | Stock | 85.7125 | 85.7125 | 85.7125 | 85.7125 | 1200.0 |
| 2020-06-12 05:45:00 | AAPL | Stock | 85.725 | 85.7925 | 85.725 | 85.7925 | 1680.0 |
| 2020-06-12 05:50:00 | AAPL | Stock | 85.875 | 85.875 | 85.8 | 85.8 | 4992.0 |
| 2020-06-12 05:55:00 | AAPL | Stock | 85.8725 | 85.8875 | 85.8725 | 85.8875 | 1040.0 |
| 2020-06-12 06:00:00 | AAPL | Stock | 85.91 | 85.91 | 85.875 | 85.9075 | 2384.0 |
| 2020-06-12 06:05:00 | AAPL | Stock | 85.9125 | 85.95 | 85.8825 | 85.8825 | 7036.0 |
| 2020-06-12 06:10:00 | AAPL | Stock | 85.87 | 85.8875 | 85.87 | 85.8875 | 7068.0 |
| 2020-06-12 06:15:00 | AAPL | Stock | 85.8675 | 85.8675 | 85.8375 | 85.8375 | 1200.0 |
| 2020-06-12 06:20:00 | AAPL | Stock | 85.8375 | 85.8375 | 85.8375 | 85.8375 | 1000.0 |
| 2020-06-12 06:25:00 | AAPL | Stock | 85.8375 | 85.8375 | 85.8125 | 85.8275 | 2148.0 |
| 2020-06-12 06:30:00 | AAPL | Stock | 85.8425 | 85.8425 | 85.75 | 85.75 | 3000.0 |
| 2020-06-12 06:35:00 | AAPL | Stock | 85.7025 | 85.7025 | 85.2925 | 85.2925 | 27688.0 |
| 2020-06-12 06:40:00 | AAPL | Stock | 85.415 | 85.415 | 85.4125 | 85.4125 | 1872.0 |
| 2020-06-12 06:45:00 | AAPL | Stock | 85.3925 | 85.3925 | 85.3 | 85.3625 | 5600.0 |
| 2020-06-12 06:50:00 | AAPL | Stock | 85.375 | 85.395 | 85.375 | 85.375 | 7636.0 |
| 2020-06-12 06:55:00 | AAPL | Stock | 85.375 | 85.625 | 85.375 | 85.625 | 10728.0 |
| 2020-06-12 07:00:00 | AAPL | Stock | 85.5875 | 85.87 | 85.5 | 85.87 | 86652.0 |
| 2020-06-12 07:05:00 | AAPL | Stock | 85.87 | 85.9325 | 85.8375 | 85.905 | 121340.0 |
| 2020-06-12 07:10:00 | AAPL | Stock | 85.9 | 85.9375 | 85.81 | 85.81 | 28488.0 |
| 2020-06-12 07:15:00 | AAPL | Stock | 85.8075 | 85.9 | 85.8075 | 85.8925 | 11828.0 |
| 2020-06-12 07:20:00 | AAPL | Stock | 85.8975 | 85.935 | 85.75 | 85.75 | 42096.0 |
| 2020-06-12 07:25:00 | AAPL | Stock | 85.75 | 85.8125 | 85.74 | 85.8 | 35776.0 |
| 2020-06-12 07:30:00 | AAPL | Stock | 85.795 | 85.9175 | 85.75 | 85.9175 | 29472.0 |
| 2020-06-12 07:35:00 | AAPL | Stock | 85.88 | 85.88 | 85.71 | 85.71 | 15972.0 |
| 2020-06-12 07:40:00 | AAPL | Stock | 85.705 | 85.75 | 85.675 | 85.69 | 22136.0 |
| 2020-06-12 07:45:00 | AAPL | Stock | 85.6975 | 85.75 | 85.6975 | 85.7225 | 17156.0 |
| 2020-06-12 07:50:00 | AAPL | Stock | 85.7225 | 85.75 | 85.7025 | 85.75 | 17232.0 |
| 2020-06-12 07:55:00 | AAPL | Stock | 85.745 | 85.775 | 85.675 | 85.7375 | 9464.0 |
| 2020-06-12 08:00:00 | AAPL | Stock | 85.675 | 85.9325 | 85.4625 | 85.6125 | 244712.0 |
| 2020-06-12 08:05:00 | AAPL | Stock | 85.5275 | 85.5825 | 85.4425 | 85.4975 | 30676.0 |
| 2020-06-12 08:10:00 | AAPL | Stock | 85.4925 | 85.515 | 85.3 | 85.3225 | 36108.0 |
| 2020-06-12 08:15:00 | AAPL | Stock | 85.3475 | 85.4475 | 85.2857 | 85.4 | 32116.0 |
> showing 50 of 434,982 rows — these rows as CSV