PREVIEW / stock_5min / 2019-02-20
file: by_date/stock_5min/2019/2019-02-20.parquet size: 5.7 MB rows: 360,368 symbols: 2,693
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-20 04:25:00 | AAPL | Stock | 42.7375 | 42.7375 | 42.7375 | 42.7375 | 544.0 |
| 2019-02-20 04:35:00 | AAPL | Stock | 42.675 | 42.7425 | 42.675 | 42.7425 | 5528.0 |
| 2019-02-20 04:45:00 | AAPL | Stock | 42.6825 | 42.6825 | 42.675 | 42.675 | 1816.0 |
| 2019-02-20 04:55:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 800.0 |
| 2019-02-20 05:15:00 | AAPL | Stock | 42.69 | 42.69 | 42.69 | 42.69 | 400.0 |
| 2019-02-20 05:30:00 | AAPL | Stock | 42.7425 | 42.7425 | 42.7425 | 42.7425 | 400.0 |
| 2019-02-20 05:35:00 | AAPL | Stock | 42.74 | 42.74 | 42.74 | 42.74 | 400.0 |
| 2019-02-20 06:05:00 | AAPL | Stock | 42.6875 | 42.6875 | 42.675 | 42.675 | 3660.0 |
| 2019-02-20 06:15:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 1116.0 |
| 2019-02-20 06:25:00 | AAPL | Stock | 42.675 | 42.675 | 42.675 | 42.675 | 800.0 |
| 2019-02-20 06:35:00 | AAPL | Stock | 42.6525 | 42.6525 | 42.6 | 42.6 | 6012.0 |
| 2019-02-20 06:40:00 | AAPL | Stock | 42.58 | 42.58 | 42.58 | 42.58 | 400.0 |
| 2019-02-20 07:00:00 | AAPL | Stock | 42.685 | 42.6975 | 42.6625 | 42.6625 | 25488.0 |
| 2019-02-20 07:05:00 | AAPL | Stock | 42.6625 | 42.675 | 42.6625 | 42.675 | 4400.0 |
| 2019-02-20 07:15:00 | AAPL | Stock | 42.665 | 42.675 | 42.66 | 42.675 | 11196.0 |
| 2019-02-20 07:20:00 | AAPL | Stock | 42.675 | 42.685 | 42.675 | 42.685 | 2000.0 |
| 2019-02-20 07:25:00 | AAPL | Stock | 42.7 | 42.7 | 42.7 | 42.7 | 1600.0 |
| 2019-02-20 07:35:00 | AAPL | Stock | 42.6875 | 42.72 | 42.6875 | 42.7175 | 3644.0 |
| 2019-02-20 07:40:00 | AAPL | Stock | 42.7125 | 42.7125 | 42.7125 | 42.7125 | 1916.0 |
| 2019-02-20 07:45:00 | AAPL | Stock | 42.71 | 42.71 | 42.6725 | 42.6725 | 7576.0 |
| 2019-02-20 07:50:00 | AAPL | Stock | 42.6725 | 42.6725 | 42.6625 | 42.6625 | 6364.0 |
| 2019-02-20 07:55:00 | AAPL | Stock | 42.655 | 42.6675 | 42.655 | 42.6675 | 2100.0 |
| 2019-02-20 08:00:00 | AAPL | Stock | 42.6625 | 42.725 | 42.625 | 42.625 | 19212.0 |
| 2019-02-20 08:05:00 | AAPL | Stock | 42.8375 | 42.8375 | 42.6225 | 42.625 | 11652.0 |
| 2019-02-20 08:10:00 | AAPL | Stock | 42.6375 | 42.6375 | 42.6075 | 42.6175 | 15868.0 |
| 2019-02-20 08:15:00 | AAPL | Stock | 42.6375 | 42.6375 | 42.625 | 42.625 | 3120.0 |
| 2019-02-20 08:20:00 | AAPL | Stock | 42.625 | 42.63 | 42.625 | 42.625 | 4700.0 |
| 2019-02-20 08:25:00 | AAPL | Stock | 42.625 | 42.625 | 42.6225 | 42.625 | 13048.0 |
| 2019-02-20 08:30:00 | AAPL | Stock | 42.6375 | 42.6425 | 42.625 | 42.6425 | 2800.0 |
| 2019-02-20 08:35:00 | AAPL | Stock | 42.64 | 42.685 | 42.64 | 42.685 | 10764.0 |
| 2019-02-20 08:40:00 | AAPL | Stock | 42.695 | 42.72 | 42.6925 | 42.715 | 18440.0 |
| 2019-02-20 08:45:00 | AAPL | Stock | 42.7225 | 42.8 | 42.7225 | 42.7975 | 42400.0 |
| 2019-02-20 08:50:00 | AAPL | Stock | 42.77 | 42.8 | 42.7525 | 42.7525 | 24256.0 |
| 2019-02-20 08:55:00 | AAPL | Stock | 42.7525 | 42.7575 | 42.725 | 42.725 | 16200.0 |
| 2019-02-20 09:00:00 | AAPL | Stock | 42.7325 | 42.75 | 42.695 | 42.75 | 6896.0 |
| 2019-02-20 09:05:00 | AAPL | Stock | 42.745 | 42.745 | 42.725 | 42.725 | 4016.0 |
| 2019-02-20 09:10:00 | AAPL | Stock | 42.745 | 42.75 | 42.745 | 42.745 | 2600.0 |
| 2019-02-20 09:15:00 | AAPL | Stock | 42.75 | 42.8025 | 42.75 | 42.7775 | 32980.0 |
| 2019-02-20 09:20:00 | AAPL | Stock | 42.7975 | 42.81 | 42.7775 | 42.81 | 17444.0 |
| 2019-02-20 09:25:00 | AAPL | Stock | 42.8125 | 42.85 | 42.7775 | 42.7775 | 30080.0 |
| 2019-02-20 09:30:00 | AAPL | Stock | 42.7975 | 43.0 | 42.7475 | 42.8875 | 3605800.0 |
| 2019-02-20 09:35:00 | AAPL | Stock | 42.8925 | 42.9925 | 42.855 | 42.96 | 2054472.0 |
| 2019-02-20 09:40:00 | AAPL | Stock | 42.9575 | 43.0225 | 42.895 | 42.95 | 2155088.0 |
| 2019-02-20 09:45:00 | AAPL | Stock | 42.955 | 43.0075 | 42.9075 | 42.99 | 1498968.0 |
| 2019-02-20 09:50:00 | AAPL | Stock | 42.9925 | 43.055 | 42.9825 | 43.025 | 1819248.0 |
| 2019-02-20 09:55:00 | AAPL | Stock | 43.0275 | 43.0375 | 42.965 | 43.02 | 1486968.0 |
| 2019-02-20 10:00:00 | AAPL | Stock | 43.0212 | 43.081 | 42.9675 | 43.065 | 1411056.0 |
| 2019-02-20 10:05:00 | AAPL | Stock | 43.0675 | 43.135 | 43.0025 | 43.1238 | 1821224.0 |
| 2019-02-20 10:10:00 | AAPL | Stock | 43.125 | 43.1675 | 43.065 | 43.1125 | 2227036.0 |
| 2019-02-20 10:15:00 | AAPL | Stock | 43.1125 | 43.2225 | 43.1125 | 43.17 | 1213424.0 |
> showing 50 of 360,368 rows — these rows as CSV