PREVIEW / stock_5min / 2021-10-22
file: by_date/stock_5min/2021/2021-10-22.parquet size: 7.4 MB rows: 451,823 symbols: 2,647
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-10-22 04:00:00 | AAPL | Stock | 149.23 | 149.93 | 149.13 | 149.16 | 3360.0 |
| 2021-10-22 04:05:00 | AAPL | Stock | 149.22 | 149.22 | 149.22 | 149.22 | 100.0 |
| 2021-10-22 04:10:00 | AAPL | Stock | 149.25 | 149.27 | 149.25 | 149.27 | 1038.0 |
| 2021-10-22 04:15:00 | AAPL | Stock | 149.32 | 149.39 | 149.29 | 149.39 | 1231.0 |
| 2021-10-22 04:20:00 | AAPL | Stock | 149.38 | 149.38 | 149.38 | 149.38 | 200.0 |
| 2021-10-22 04:25:00 | AAPL | Stock | 149.44 | 149.46 | 149.39 | 149.39 | 868.0 |
| 2021-10-22 04:30:00 | AAPL | Stock | 149.46 | 149.48 | 149.46 | 149.48 | 674.0 |
| 2021-10-22 04:35:00 | AAPL | Stock | 149.5 | 149.5 | 149.5 | 149.5 | 400.0 |
| 2021-10-22 04:40:00 | AAPL | Stock | 149.5 | 149.51 | 149.41 | 149.51 | 1219.0 |
| 2021-10-22 04:45:00 | AAPL | Stock | 149.5 | 149.53 | 149.5 | 149.53 | 2978.0 |
| 2021-10-22 04:50:00 | AAPL | Stock | 149.5 | 149.51 | 149.5 | 149.51 | 1109.0 |
| 2021-10-22 04:55:00 | AAPL | Stock | 149.51 | 149.59 | 149.5 | 149.59 | 3304.0 |
| 2021-10-22 05:00:00 | AAPL | Stock | 149.54 | 149.6 | 149.54 | 149.6 | 789.0 |
| 2021-10-22 05:05:00 | AAPL | Stock | 149.57 | 149.63 | 149.57 | 149.63 | 200.0 |
| 2021-10-22 05:10:00 | AAPL | Stock | 149.65 | 149.75 | 149.6 | 149.62 | 3273.0 |
| 2021-10-22 05:15:00 | AAPL | Stock | 149.62 | 149.62 | 149.5 | 149.5 | 1033.0 |
| 2021-10-22 05:20:00 | AAPL | Stock | 149.51 | 149.51 | 149.5 | 149.51 | 1628.0 |
| 2021-10-22 05:25:00 | AAPL | Stock | 149.51 | 149.51 | 149.51 | 149.51 | 117.0 |
| 2021-10-22 05:35:00 | AAPL | Stock | 149.5 | 149.51 | 149.46 | 149.51 | 3005.0 |
| 2021-10-22 05:45:00 | AAPL | Stock | 149.62 | 149.64 | 149.62 | 149.64 | 736.0 |
| 2021-10-22 05:50:00 | AAPL | Stock | 149.64 | 149.64 | 149.64 | 149.64 | 479.0 |
| 2021-10-22 05:55:00 | AAPL | Stock | 149.69 | 149.74 | 149.69 | 149.69 | 1428.0 |
| 2021-10-22 06:05:00 | AAPL | Stock | 149.66 | 149.68 | 149.65 | 149.68 | 1100.0 |
| 2021-10-22 06:10:00 | AAPL | Stock | 149.72 | 149.72 | 149.7 | 149.7 | 700.0 |
| 2021-10-22 06:15:00 | AAPL | Stock | 149.68 | 149.73 | 149.68 | 149.73 | 596.0 |
| 2021-10-22 06:20:00 | AAPL | Stock | 149.62 | 149.62 | 149.61 | 149.62 | 713.0 |
| 2021-10-22 06:30:00 | AAPL | Stock | 149.61 | 149.67 | 149.6 | 149.6 | 2565.0 |
| 2021-10-22 06:35:00 | AAPL | Stock | 149.64 | 149.71 | 149.64 | 149.71 | 2986.0 |
| 2021-10-22 06:40:00 | AAPL | Stock | 149.7 | 149.7 | 149.7 | 149.7 | 251.0 |
| 2021-10-22 06:45:00 | AAPL | Stock | 149.75 | 149.75 | 149.75 | 149.75 | 329.0 |
| 2021-10-22 06:50:00 | AAPL | Stock | 149.75 | 149.75 | 149.7 | 149.7 | 575.0 |
| 2021-10-22 06:55:00 | AAPL | Stock | 149.75 | 149.75 | 149.75 | 149.75 | 800.0 |
| 2021-10-22 07:00:00 | AAPL | Stock | 149.71 | 149.75 | 149.6 | 149.67 | 10483.0 |
| 2021-10-22 07:05:00 | AAPL | Stock | 149.66 | 149.75 | 149.65 | 149.74 | 7586.0 |
| 2021-10-22 07:10:00 | AAPL | Stock | 149.73 | 149.83 | 149.72 | 149.8 | 20121.0 |
| 2021-10-22 07:15:00 | AAPL | Stock | 149.8 | 149.8 | 149.74 | 149.79 | 7646.0 |
| 2021-10-22 07:20:00 | AAPL | Stock | 149.81 | 150.1 | 149.81 | 150.0 | 60868.0 |
| 2021-10-22 07:25:00 | AAPL | Stock | 149.95 | 150.08 | 149.95 | 150.06 | 9792.0 |
| 2021-10-22 07:30:00 | AAPL | Stock | 150.06 | 150.06 | 149.99 | 149.99 | 2898.0 |
| 2021-10-22 07:35:00 | AAPL | Stock | 149.98 | 150.02 | 149.98 | 150.02 | 3468.0 |
| 2021-10-22 07:40:00 | AAPL | Stock | 150.01 | 150.01 | 149.9 | 149.94 | 7549.0 |
| 2021-10-22 07:45:00 | AAPL | Stock | 149.93 | 149.93 | 149.88 | 149.9 | 1400.0 |
| 2021-10-22 07:50:00 | AAPL | Stock | 149.88 | 149.89 | 149.88 | 149.889 | 1200.0 |
| 2021-10-22 07:55:00 | AAPL | Stock | 149.88 | 149.88 | 149.71 | 149.72 | 23763.0 |
| 2021-10-22 08:00:00 | AAPL | Stock | 149.9799 | 150.1129 | 149.107 | 149.78 | 187328.0 |
| 2021-10-22 08:05:00 | AAPL | Stock | 149.77 | 149.77 | 149.7 | 149.75 | 7302.0 |
| 2021-10-22 08:10:00 | AAPL | Stock | 149.7501 | 149.78 | 149.75 | 149.77 | 2946.0 |
| 2021-10-22 08:15:00 | AAPL | Stock | 149.78 | 149.87 | 149.78 | 149.81 | 8516.0 |
| 2021-10-22 08:20:00 | AAPL | Stock | 149.86 | 149.87 | 149.83 | 149.85 | 5992.0 |
| 2021-10-22 08:25:00 | AAPL | Stock | 149.86 | 149.8701 | 149.83 | 149.87 | 12633.0 |
> showing 50 of 451,823 rows — these rows as CSV