PREVIEW / stock_5min / 2020-05-18
file: by_date/stock_5min/2020/2020-05-18.parquet size: 6.7 MB rows: 424,673 symbols: 2,382
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-05-18 04:00:00 | AAPL | Stock | 77.465 | 77.465 | 77.465 | 77.465 | 5988.0 |
| 2020-05-18 04:05:00 | AAPL | Stock | 77.5275 | 77.54 | 77.5275 | 77.54 | 3000.0 |
| 2020-05-18 04:10:00 | AAPL | Stock | 77.55 | 77.55 | 77.55 | 77.55 | 1096.0 |
| 2020-05-18 04:15:00 | AAPL | Stock | 77.6825 | 77.6825 | 77.6825 | 77.6825 | 460.0 |
| 2020-05-18 04:20:00 | AAPL | Stock | 77.6075 | 77.6075 | 77.6075 | 77.6075 | 400.0 |
| 2020-05-18 04:25:00 | AAPL | Stock | 77.6625 | 77.6625 | 77.6625 | 77.6625 | 1680.0 |
| 2020-05-18 04:30:00 | AAPL | Stock | 77.7 | 77.7 | 77.65 | 77.65 | 6356.0 |
| 2020-05-18 04:35:00 | AAPL | Stock | 77.6275 | 77.7 | 77.6275 | 77.7 | 2164.0 |
| 2020-05-18 04:40:00 | AAPL | Stock | 77.65 | 77.65 | 77.65 | 77.65 | 800.0 |
| 2020-05-18 04:45:00 | AAPL | Stock | 77.6925 | 77.6925 | 77.65 | 77.65 | 2472.0 |
| 2020-05-18 04:55:00 | AAPL | Stock | 77.5775 | 77.5775 | 77.5775 | 77.5775 | 800.0 |
| 2020-05-18 05:00:00 | AAPL | Stock | 77.625 | 77.625 | 77.575 | 77.575 | 6604.0 |
| 2020-05-18 05:05:00 | AAPL | Stock | 77.55 | 77.55 | 77.55 | 77.55 | 3660.0 |
| 2020-05-18 05:10:00 | AAPL | Stock | 77.5225 | 77.5225 | 77.4525 | 77.475 | 9000.0 |
| 2020-05-18 05:15:00 | AAPL | Stock | 77.5 | 77.5 | 77.2425 | 77.25 | 16260.0 |
| 2020-05-18 05:20:00 | AAPL | Stock | 77.25 | 77.3675 | 77.25 | 77.3675 | 4948.0 |
| 2020-05-18 05:25:00 | AAPL | Stock | 77.3125 | 77.3125 | 77.2225 | 77.2225 | 4480.0 |
| 2020-05-18 05:30:00 | AAPL | Stock | 77.1925 | 77.1925 | 77.1925 | 77.1925 | 400.0 |
| 2020-05-18 05:35:00 | AAPL | Stock | 77.15 | 77.15 | 77.1425 | 77.15 | 7720.0 |
| 2020-05-18 05:40:00 | AAPL | Stock | 77.1875 | 77.1875 | 77.1875 | 77.1875 | 1000.0 |
| 2020-05-18 05:45:00 | AAPL | Stock | 77.2525 | 77.275 | 77.2525 | 77.275 | 1200.0 |
| 2020-05-18 05:55:00 | AAPL | Stock | 77.32 | 77.32 | 77.32 | 77.32 | 800.0 |
| 2020-05-18 06:00:00 | AAPL | Stock | 77.3625 | 77.3625 | 77.3625 | 77.3625 | 716.0 |
| 2020-05-18 06:05:00 | AAPL | Stock | 77.345 | 77.3625 | 77.345 | 77.3625 | 2160.0 |
| 2020-05-18 06:10:00 | AAPL | Stock | 77.3625 | 77.3875 | 77.3625 | 77.3875 | 16768.0 |
| 2020-05-18 06:15:00 | AAPL | Stock | 77.33 | 77.33 | 77.33 | 77.33 | 400.0 |
| 2020-05-18 06:20:00 | AAPL | Stock | 77.2525 | 77.2525 | 77.2525 | 77.2525 | 400.0 |
| 2020-05-18 06:30:00 | AAPL | Stock | 77.2375 | 77.2375 | 77.235 | 77.235 | 960.0 |
| 2020-05-18 06:35:00 | AAPL | Stock | 77.25 | 77.29 | 77.25 | 77.29 | 4324.0 |
| 2020-05-18 06:40:00 | AAPL | Stock | 77.25 | 77.3775 | 77.25 | 77.3775 | 1568.0 |
| 2020-05-18 06:50:00 | AAPL | Stock | 77.3125 | 77.3125 | 77.3125 | 77.3125 | 4000.0 |
| 2020-05-18 06:55:00 | AAPL | Stock | 77.4925 | 77.5 | 77.4925 | 77.5 | 984.0 |
| 2020-05-18 07:00:00 | AAPL | Stock | 77.4925 | 77.7375 | 77.3925 | 77.6825 | 52720.0 |
| 2020-05-18 07:05:00 | AAPL | Stock | 77.6925 | 77.7875 | 77.645 | 77.7225 | 43624.0 |
| 2020-05-18 07:10:00 | AAPL | Stock | 77.72 | 77.7375 | 77.6625 | 77.6925 | 18300.0 |
| 2020-05-18 07:15:00 | AAPL | Stock | 77.665 | 77.725 | 77.665 | 77.72 | 19836.0 |
| 2020-05-18 07:20:00 | AAPL | Stock | 77.725 | 77.725 | 77.705 | 77.71 | 7060.0 |
| 2020-05-18 07:25:00 | AAPL | Stock | 77.7125 | 77.72 | 77.675 | 77.6875 | 26952.0 |
| 2020-05-18 07:30:00 | AAPL | Stock | 77.7025 | 77.7625 | 77.6475 | 77.65 | 42960.0 |
| 2020-05-18 07:35:00 | AAPL | Stock | 77.7125 | 77.7675 | 77.6875 | 77.7675 | 33228.0 |
| 2020-05-18 07:40:00 | AAPL | Stock | 77.7725 | 78.0 | 77.7725 | 78.0 | 36968.0 |
| 2020-05-18 07:45:00 | AAPL | Stock | 77.995 | 78.25 | 77.9875 | 78.2425 | 51944.0 |
| 2020-05-18 07:50:00 | AAPL | Stock | 78.245 | 78.325 | 78.2175 | 78.3 | 54816.0 |
| 2020-05-18 07:55:00 | AAPL | Stock | 78.28 | 78.3 | 78.1225 | 78.3 | 42324.0 |
| 2020-05-18 08:00:00 | AAPL | Stock | 77.725 | 78.3875 | 77.1175 | 78.3375 | 300892.0 |
| 2020-05-18 08:05:00 | AAPL | Stock | 78.3375 | 78.3575 | 78.25 | 78.325 | 109584.0 |
| 2020-05-18 08:10:00 | AAPL | Stock | 78.325 | 78.5625 | 78.325 | 78.535 | 53524.0 |
| 2020-05-18 08:15:00 | AAPL | Stock | 78.605 | 78.605 | 78.465 | 78.5375 | 120656.0 |
| 2020-05-18 08:20:00 | AAPL | Stock | 78.538 | 78.575 | 78.425 | 78.4475 | 66380.0 |
| 2020-05-18 08:25:00 | AAPL | Stock | 78.43 | 78.475 | 78.4 | 78.41 | 60200.0 |
> showing 50 of 424,673 rows — these rows as CSV