PREVIEW / stock_5min / 2019-02-07
file: by_date/stock_5min/2019/2019-02-07.parquet size: 5.6 MB rows: 350,722 symbols: 2,645
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-07 04:05:00 | AAPL | Stock | 43.4025 | 43.4025 | 43.4025 | 43.4025 | 400.0 |
| 2019-02-07 05:10:00 | AAPL | Stock | 43.4225 | 43.445 | 43.3875 | 43.3875 | 2600.0 |
| 2019-02-07 05:15:00 | AAPL | Stock | 43.3975 | 43.3975 | 43.3975 | 43.3975 | 400.0 |
| 2019-02-07 05:20:00 | AAPL | Stock | 43.3375 | 43.34 | 43.305 | 43.34 | 1784.0 |
| 2019-02-07 05:25:00 | AAPL | Stock | 43.3 | 43.3 | 43.265 | 43.265 | 7168.0 |
| 2019-02-07 06:00:00 | AAPL | Stock | 43.305 | 43.305 | 43.275 | 43.275 | 7968.0 |
| 2019-02-07 06:05:00 | AAPL | Stock | 43.325 | 43.3275 | 43.325 | 43.3275 | 1872.0 |
| 2019-02-07 06:10:00 | AAPL | Stock | 43.28 | 43.28 | 43.25 | 43.25 | 8000.0 |
| 2019-02-07 06:25:00 | AAPL | Stock | 43.225 | 43.2275 | 43.225 | 43.2275 | 1164.0 |
| 2019-02-07 06:30:00 | AAPL | Stock | 43.25 | 43.25 | 43.25 | 43.25 | 400.0 |
| 2019-02-07 06:35:00 | AAPL | Stock | 43.255 | 43.255 | 43.2175 | 43.2175 | 7376.0 |
| 2019-02-07 06:40:00 | AAPL | Stock | 43.2175 | 43.2175 | 43.2175 | 43.2175 | 400.0 |
| 2019-02-07 06:50:00 | AAPL | Stock | 43.2575 | 43.2625 | 43.255 | 43.255 | 5116.0 |
| 2019-02-07 06:55:00 | AAPL | Stock | 43.2725 | 43.2725 | 43.24 | 43.24 | 1088.0 |
| 2019-02-07 07:00:00 | AAPL | Stock | 43.275 | 43.3 | 43.2425 | 43.3 | 14232.0 |
| 2019-02-07 07:05:00 | AAPL | Stock | 43.265 | 43.3125 | 43.2625 | 43.2875 | 17008.0 |
| 2019-02-07 07:10:00 | AAPL | Stock | 43.2625 | 43.3125 | 43.26 | 43.295 | 9868.0 |
| 2019-02-07 07:15:00 | AAPL | Stock | 43.3125 | 43.3125 | 43.3 | 43.3 | 2900.0 |
| 2019-02-07 07:20:00 | AAPL | Stock | 43.3125 | 43.345 | 43.3 | 43.345 | 11964.0 |
| 2019-02-07 07:25:00 | AAPL | Stock | 43.3325 | 43.3325 | 43.3 | 43.3 | 4060.0 |
| 2019-02-07 07:30:00 | AAPL | Stock | 43.3 | 43.3 | 43.2875 | 43.3 | 14280.0 |
| 2019-02-07 07:35:00 | AAPL | Stock | 43.3025 | 43.3125 | 43.25 | 43.255 | 16952.0 |
| 2019-02-07 07:40:00 | AAPL | Stock | 43.2625 | 43.2725 | 43.2175 | 43.2175 | 33288.0 |
| 2019-02-07 07:45:00 | AAPL | Stock | 43.2225 | 43.2275 | 43.1225 | 43.1225 | 92792.0 |
| 2019-02-07 07:50:00 | AAPL | Stock | 43.125 | 43.125 | 43.09 | 43.1125 | 36268.0 |
| 2019-02-07 07:55:00 | AAPL | Stock | 43.1 | 43.1225 | 43.0725 | 43.1 | 51308.0 |
| 2019-02-07 08:00:00 | AAPL | Stock | 43.3 | 43.6675 | 43.08 | 43.15 | 135212.0 |
| 2019-02-07 08:05:00 | AAPL | Stock | 43.15 | 43.15 | 43.1225 | 43.125 | 12164.0 |
| 2019-02-07 08:10:00 | AAPL | Stock | 43.12 | 43.125 | 43.025 | 43.025 | 32176.0 |
| 2019-02-07 08:15:00 | AAPL | Stock | 43.03 | 43.05 | 43.0 | 43.025 | 32996.0 |
| 2019-02-07 08:20:00 | AAPL | Stock | 43.025 | 43.0375 | 43.0175 | 43.03 | 49288.0 |
| 2019-02-07 08:25:00 | AAPL | Stock | 43.0325 | 43.0875 | 43.025 | 43.0875 | 81960.0 |
| 2019-02-07 08:30:00 | AAPL | Stock | 43.075 | 43.12 | 43.075 | 43.09 | 40464.0 |
| 2019-02-07 08:35:00 | AAPL | Stock | 43.1125 | 43.1125 | 43.075 | 43.075 | 41776.0 |
| 2019-02-07 08:40:00 | AAPL | Stock | 43.0775 | 43.1125 | 43.0775 | 43.085 | 41668.0 |
| 2019-02-07 08:45:00 | AAPL | Stock | 43.085 | 43.1125 | 43.085 | 43.085 | 31456.0 |
| 2019-02-07 08:50:00 | AAPL | Stock | 43.0818 | 43.125 | 43.0818 | 43.125 | 27232.0 |
| 2019-02-07 08:55:00 | AAPL | Stock | 43.1125 | 43.1125 | 43.0875 | 43.0875 | 31200.0 |
| 2019-02-07 09:00:00 | AAPL | Stock | 43.1 | 43.1 | 43.025 | 43.095 | 53356.0 |
| 2019-02-07 09:05:00 | AAPL | Stock | 43.1 | 43.1125 | 43.0825 | 43.1125 | 19936.0 |
| 2019-02-07 09:10:00 | AAPL | Stock | 43.1 | 43.125 | 43.0875 | 43.125 | 21400.0 |
| 2019-02-07 09:15:00 | AAPL | Stock | 43.11 | 43.135 | 43.075 | 43.125 | 35308.0 |
| 2019-02-07 09:20:00 | AAPL | Stock | 43.1 | 43.1325 | 43.075 | 43.075 | 22196.0 |
| 2019-02-07 09:25:00 | AAPL | Stock | 43.07 | 43.0825 | 43.0625 | 43.0625 | 12152.0 |
| 2019-02-07 09:30:00 | AAPL | Stock | 43.0925 | 43.2025 | 42.95 | 43.195 | 4878892.0 |
| 2019-02-07 09:35:00 | AAPL | Stock | 43.19 | 43.1942 | 43.02 | 43.0275 | 1983104.0 |
| 2019-02-07 09:40:00 | AAPL | Stock | 43.025 | 43.18 | 43.005 | 43.0825 | 2204856.0 |
| 2019-02-07 09:45:00 | AAPL | Stock | 43.0875 | 43.125 | 43.0275 | 43.04 | 1958560.0 |
| 2019-02-07 09:50:00 | AAPL | Stock | 43.0395 | 43.1725 | 43.03 | 43.1612 | 1466644.0 |
| 2019-02-07 09:55:00 | AAPL | Stock | 43.16 | 43.2975 | 43.1575 | 43.28 | 1887156.0 |
> showing 50 of 350,722 rows — these rows as CSV