PREVIEW / stock_5min / 2021-11-19
file: by_date/stock_5min/2021/2021-11-19.parquet size: 7.7 MB rows: 470,164 symbols: 2,701
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 |
|---|---|---|---|---|---|---|---|
| 2021-11-19 04:00:00 | AAPL | Stock | 158.5 | 158.62 | 158.22 | 158.43 | 10336.0 |
| 2021-11-19 04:05:00 | AAPL | Stock | 158.35 | 158.39 | 158.27 | 158.28 | 10106.0 |
| 2021-11-19 04:10:00 | AAPL | Stock | 158.3 | 158.4 | 158.28 | 158.3 | 6355.0 |
| 2021-11-19 04:15:00 | AAPL | Stock | 158.3 | 158.34 | 158.28 | 158.34 | 10180.0 |
| 2021-11-19 04:20:00 | AAPL | Stock | 158.35 | 158.35 | 158.3 | 158.3 | 4556.0 |
| 2021-11-19 04:25:00 | AAPL | Stock | 158.28 | 158.35 | 158.28 | 158.32 | 3849.0 |
| 2021-11-19 04:30:00 | AAPL | Stock | 158.32 | 158.32 | 158.28 | 158.3 | 700.0 |
| 2021-11-19 04:35:00 | AAPL | Stock | 158.31 | 158.32 | 158.28 | 158.3 | 6016.0 |
| 2021-11-19 04:40:00 | AAPL | Stock | 158.3 | 158.3 | 158.02 | 158.19 | 2942.0 |
| 2021-11-19 04:45:00 | AAPL | Stock | 158.1 | 158.15 | 158.1 | 158.15 | 1011.0 |
| 2021-11-19 04:50:00 | AAPL | Stock | 158.17 | 158.2 | 158.09 | 158.09 | 1507.0 |
| 2021-11-19 04:55:00 | AAPL | Stock | 158.08 | 158.1 | 158.05 | 158.1 | 5314.0 |
| 2021-11-19 05:00:00 | AAPL | Stock | 158.03 | 158.03 | 157.9 | 157.9 | 955.0 |
| 2021-11-19 05:05:00 | AAPL | Stock | 157.87 | 157.92 | 157.82 | 157.85 | 3213.0 |
| 2021-11-19 05:10:00 | AAPL | Stock | 157.83 | 157.83 | 157.5 | 157.55 | 7802.0 |
| 2021-11-19 05:15:00 | AAPL | Stock | 157.55 | 157.92 | 157.51 | 157.92 | 9696.0 |
| 2021-11-19 05:20:00 | AAPL | Stock | 157.9 | 157.98 | 157.9 | 157.98 | 7236.0 |
| 2021-11-19 05:25:00 | AAPL | Stock | 157.94 | 157.96 | 157.9 | 157.9 | 1526.0 |
| 2021-11-19 05:30:00 | AAPL | Stock | 157.87 | 157.87 | 157.79 | 157.79 | 2112.0 |
| 2021-11-19 05:35:00 | AAPL | Stock | 157.73 | 157.73 | 157.58 | 157.68 | 3220.0 |
| 2021-11-19 05:40:00 | AAPL | Stock | 157.79 | 158.01 | 157.78 | 157.9 | 9400.0 |
| 2021-11-19 05:45:00 | AAPL | Stock | 157.95 | 157.95 | 157.94 | 157.94 | 498.0 |
| 2021-11-19 05:50:00 | AAPL | Stock | 157.89 | 157.95 | 157.89 | 157.89 | 1558.0 |
| 2021-11-19 05:55:00 | AAPL | Stock | 157.76 | 157.87 | 157.76 | 157.87 | 6308.0 |
| 2021-11-19 06:00:00 | AAPL | Stock | 157.91 | 157.91 | 157.78 | 157.78 | 2453.0 |
| 2021-11-19 06:05:00 | AAPL | Stock | 157.75 | 157.78 | 157.66 | 157.66 | 5929.0 |
| 2021-11-19 06:10:00 | AAPL | Stock | 157.66 | 157.69 | 157.57 | 157.69 | 2075.0 |
| 2021-11-19 06:15:00 | AAPL | Stock | 157.75 | 157.8 | 157.75 | 157.8 | 7427.0 |
| 2021-11-19 06:20:00 | AAPL | Stock | 157.75 | 157.75 | 157.74 | 157.74 | 1011.0 |
| 2021-11-19 06:25:00 | AAPL | Stock | 157.74 | 157.8 | 157.73 | 157.79 | 8260.0 |
| 2021-11-19 06:30:00 | AAPL | Stock | 157.79 | 157.79 | 157.56 | 157.56 | 3888.0 |
| 2021-11-19 06:35:00 | AAPL | Stock | 157.61 | 157.65 | 157.61 | 157.61 | 1710.0 |
| 2021-11-19 06:40:00 | AAPL | Stock | 157.6 | 157.6 | 157.39 | 157.5 | 8701.0 |
| 2021-11-19 06:45:00 | AAPL | Stock | 157.48 | 157.48 | 157.48 | 157.48 | 358.0 |
| 2021-11-19 06:50:00 | AAPL | Stock | 157.43 | 157.52 | 157.38 | 157.52 | 6692.0 |
| 2021-11-19 06:55:00 | AAPL | Stock | 157.4 | 157.48 | 157.4 | 157.48 | 2225.0 |
| 2021-11-19 07:00:00 | AAPL | Stock | 157.58 | 157.7 | 157.35 | 157.49 | 57513.0 |
| 2021-11-19 07:05:00 | AAPL | Stock | 157.45 | 157.68 | 157.4 | 157.68 | 31250.0 |
| 2021-11-19 07:10:00 | AAPL | Stock | 157.7 | 157.7 | 157.46 | 157.62 | 18703.0 |
| 2021-11-19 07:15:00 | AAPL | Stock | 157.61 | 157.61 | 157.31 | 157.33 | 34491.0 |
| 2021-11-19 07:20:00 | AAPL | Stock | 157.35 | 157.5 | 157.27 | 157.48 | 24965.0 |
| 2021-11-19 07:25:00 | AAPL | Stock | 157.45 | 157.48 | 157.4 | 157.43 | 16769.0 |
| 2021-11-19 07:30:00 | AAPL | Stock | 157.43 | 157.62 | 157.42 | 157.61 | 16826.0 |
| 2021-11-19 07:35:00 | AAPL | Stock | 157.61 | 157.7 | 157.58 | 157.61 | 30816.0 |
| 2021-11-19 07:40:00 | AAPL | Stock | 157.62 | 157.64 | 157.5 | 157.5 | 10454.0 |
| 2021-11-19 07:45:00 | AAPL | Stock | 157.49 | 157.53 | 157.45 | 157.49 | 32483.0 |
| 2021-11-19 07:50:00 | AAPL | Stock | 157.49 | 157.55 | 157.37 | 157.41 | 17629.0 |
| 2021-11-19 07:55:00 | AAPL | Stock | 157.39 | 157.45 | 157.34 | 157.43 | 39956.0 |
| 2021-11-19 08:00:00 | AAPL | Stock | 157.4 | 157.7 | 157.28 | 157.47 | 239907.0 |
| 2021-11-19 08:05:00 | AAPL | Stock | 157.5 | 157.5 | 157.42 | 157.47 | 42269.0 |
> showing 50 of 470,164 rows — these rows as CSV