PREVIEW / stock_5min / 2022-11-10
file: by_date/stock_5min/2022/2022-11-10.parquet size: 7.3 MB rows: 446,899 symbols: 2,161
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-10 04:00:00 | AAPL | Stock | 134.87 | 135.8 | 134.87 | 135.5 | 7920.0 |
| 2022-11-10 04:05:00 | AAPL | Stock | 135.45 | 135.78 | 135.45 | 135.78 | 2381.0 |
| 2022-11-10 04:10:00 | AAPL | Stock | 135.8 | 135.8 | 135.63 | 135.63 | 2886.0 |
| 2022-11-10 04:15:00 | AAPL | Stock | 135.67 | 135.67 | 135.48 | 135.51 | 5142.0 |
| 2022-11-10 04:20:00 | AAPL | Stock | 135.51 | 135.63 | 135.5 | 135.63 | 4568.0 |
| 2022-11-10 04:25:00 | AAPL | Stock | 135.6 | 135.6 | 135.59 | 135.6 | 2014.0 |
| 2022-11-10 04:30:00 | AAPL | Stock | 135.65 | 135.65 | 135.52 | 135.52 | 3003.0 |
| 2022-11-10 04:35:00 | AAPL | Stock | 135.55 | 135.75 | 135.55 | 135.7 | 2579.0 |
| 2022-11-10 04:40:00 | AAPL | Stock | 135.65 | 135.65 | 135.59 | 135.59 | 265.0 |
| 2022-11-10 04:45:00 | AAPL | Stock | 135.65 | 135.69 | 135.65 | 135.65 | 726.0 |
| 2022-11-10 04:50:00 | AAPL | Stock | 135.63 | 135.63 | 135.51 | 135.51 | 488.0 |
| 2022-11-10 04:55:00 | AAPL | Stock | 135.52 | 135.52 | 135.52 | 135.52 | 428.0 |
| 2022-11-10 05:00:00 | AAPL | Stock | 135.6 | 135.6 | 135.48 | 135.48 | 1272.0 |
| 2022-11-10 05:05:00 | AAPL | Stock | 135.52 | 135.58 | 135.48 | 135.5 | 658.0 |
| 2022-11-10 05:10:00 | AAPL | Stock | 135.5 | 135.55 | 135.38 | 135.45 | 5239.0 |
| 2022-11-10 05:15:00 | AAPL | Stock | 135.45 | 135.46 | 135.45 | 135.45 | 6103.0 |
| 2022-11-10 05:20:00 | AAPL | Stock | 135.4 | 135.5 | 135.4 | 135.5 | 425.0 |
| 2022-11-10 05:25:00 | AAPL | Stock | 135.49 | 135.59 | 135.4 | 135.59 | 4384.0 |
| 2022-11-10 05:35:00 | AAPL | Stock | 135.56 | 135.56 | 135.55 | 135.55 | 1276.0 |
| 2022-11-10 05:40:00 | AAPL | Stock | 135.56 | 135.7 | 135.56 | 135.7 | 2065.0 |
| 2022-11-10 05:50:00 | AAPL | Stock | 135.63 | 135.65 | 135.6 | 135.65 | 1192.0 |
| 2022-11-10 05:55:00 | AAPL | Stock | 135.6 | 135.98 | 135.6 | 135.98 | 3146.0 |
| 2022-11-10 06:00:00 | AAPL | Stock | 135.83 | 135.83 | 135.62 | 135.62 | 1326.0 |
| 2022-11-10 06:05:00 | AAPL | Stock | 135.8 | 135.8 | 135.8 | 135.8 | 375.0 |
| 2022-11-10 06:10:00 | AAPL | Stock | 135.89 | 135.89 | 135.85 | 135.85 | 609.0 |
| 2022-11-10 06:15:00 | AAPL | Stock | 135.92 | 135.94 | 135.85 | 135.85 | 1104.0 |
| 2022-11-10 06:20:00 | AAPL | Stock | 135.96 | 136.0 | 135.95 | 136.0 | 6494.0 |
| 2022-11-10 06:25:00 | AAPL | Stock | 135.96 | 136.05 | 135.86 | 135.86 | 2059.0 |
| 2022-11-10 06:30:00 | AAPL | Stock | 135.98 | 135.98 | 135.95 | 135.95 | 1390.0 |
| 2022-11-10 06:35:00 | AAPL | Stock | 136.04 | 136.05 | 135.95 | 135.95 | 1248.0 |
| 2022-11-10 06:40:00 | AAPL | Stock | 135.97 | 136.05 | 135.97 | 136.04 | 1233.0 |
| 2022-11-10 06:45:00 | AAPL | Stock | 136.1 | 136.19 | 136.1 | 136.19 | 1416.0 |
| 2022-11-10 06:50:00 | AAPL | Stock | 136.09 | 136.09 | 136.08 | 136.09 | 667.0 |
| 2022-11-10 06:55:00 | AAPL | Stock | 136.06 | 136.06 | 136.0 | 136.0 | 881.0 |
| 2022-11-10 07:00:00 | AAPL | Stock | 136.0 | 136.05 | 135.75 | 135.75 | 10227.0 |
| 2022-11-10 07:05:00 | AAPL | Stock | 135.8 | 135.83 | 135.73 | 135.75 | 10632.0 |
| 2022-11-10 07:10:00 | AAPL | Stock | 135.83 | 136.0 | 135.83 | 135.97 | 3865.0 |
| 2022-11-10 07:15:00 | AAPL | Stock | 135.95 | 135.95 | 135.91 | 135.91 | 281.0 |
| 2022-11-10 07:20:00 | AAPL | Stock | 135.89 | 135.91 | 135.8 | 135.81 | 2073.0 |
| 2022-11-10 07:25:00 | AAPL | Stock | 135.73 | 135.8 | 135.7 | 135.75 | 4605.0 |
| 2022-11-10 07:30:00 | AAPL | Stock | 135.78 | 135.8 | 135.71 | 135.71 | 2640.0 |
| 2022-11-10 07:35:00 | AAPL | Stock | 135.7 | 135.73 | 135.65 | 135.66 | 1572.0 |
| 2022-11-10 07:40:00 | AAPL | Stock | 135.64 | 135.69 | 135.57 | 135.6 | 5370.0 |
| 2022-11-10 07:45:00 | AAPL | Stock | 135.58 | 135.7 | 135.55 | 135.6 | 3672.0 |
| 2022-11-10 07:50:00 | AAPL | Stock | 135.61 | 135.63 | 135.6 | 135.63 | 4216.0 |
| 2022-11-10 07:55:00 | AAPL | Stock | 135.56 | 135.74 | 135.56 | 135.74 | 4084.0 |
| 2022-11-10 08:00:00 | AAPL | Stock | 135.9216 | 136.0499 | 135.4515 | 135.63 | 58393.0 |
| 2022-11-10 08:05:00 | AAPL | Stock | 135.664 | 135.69 | 135.47 | 135.5 | 32934.0 |
| 2022-11-10 08:10:00 | AAPL | Stock | 135.5799 | 135.9 | 135.51 | 135.8165 | 24478.0 |
| 2022-11-10 08:15:00 | AAPL | Stock | 135.77 | 135.77 | 135.63 | 135.71 | 24326.0 |
> showing 50 of 446,899 rows — these rows as CSV