PREVIEW / stock_5min / 2022-10-19
file: by_date/stock_5min/2022/2022-10-19.parquet size: 6.7 MB rows: 412,955 symbols: 2,152
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-10-19 04:00:00 | AAPL | Stock | 144.06 | 144.15 | 143.22 | 143.35 | 12166.0 |
| 2022-10-19 04:05:00 | AAPL | Stock | 143.29 | 143.35 | 142.99 | 143.03 | 11438.0 |
| 2022-10-19 04:10:00 | AAPL | Stock | 142.94 | 143.1 | 142.77 | 142.93 | 8530.0 |
| 2022-10-19 04:15:00 | AAPL | Stock | 142.91 | 142.91 | 142.69 | 142.69 | 6781.0 |
| 2022-10-19 04:20:00 | AAPL | Stock | 142.65 | 142.65 | 142.4 | 142.53 | 5328.0 |
| 2022-10-19 04:25:00 | AAPL | Stock | 142.52 | 142.55 | 142.4 | 142.55 | 2804.0 |
| 2022-10-19 04:30:00 | AAPL | Stock | 142.55 | 142.79 | 142.55 | 142.76 | 2756.0 |
| 2022-10-19 04:35:00 | AAPL | Stock | 142.92 | 142.92 | 142.59 | 142.61 | 2704.0 |
| 2022-10-19 04:40:00 | AAPL | Stock | 142.87 | 142.87 | 142.87 | 142.87 | 300.0 |
| 2022-10-19 04:45:00 | AAPL | Stock | 142.87 | 142.88 | 142.79 | 142.8 | 3423.0 |
| 2022-10-19 04:50:00 | AAPL | Stock | 142.8 | 143.1 | 142.8 | 143.1 | 1077.0 |
| 2022-10-19 04:55:00 | AAPL | Stock | 143.02 | 143.02 | 143.02 | 143.02 | 355.0 |
| 2022-10-19 05:00:00 | AAPL | Stock | 143.0 | 143.2 | 143.0 | 143.2 | 1453.0 |
| 2022-10-19 05:05:00 | AAPL | Stock | 143.19 | 143.33 | 143.19 | 143.33 | 474.0 |
| 2022-10-19 05:10:00 | AAPL | Stock | 143.28 | 143.31 | 143.25 | 143.31 | 1965.0 |
| 2022-10-19 05:15:00 | AAPL | Stock | 143.35 | 143.35 | 143.19 | 143.19 | 1890.0 |
| 2022-10-19 05:20:00 | AAPL | Stock | 143.19 | 143.24 | 143.11 | 143.24 | 4530.0 |
| 2022-10-19 05:25:00 | AAPL | Stock | 143.2 | 143.4 | 143.11 | 143.31 | 8316.0 |
| 2022-10-19 05:30:00 | AAPL | Stock | 143.48 | 143.75 | 143.48 | 143.75 | 5514.0 |
| 2022-10-19 05:35:00 | AAPL | Stock | 143.72 | 143.8 | 143.63 | 143.63 | 12401.0 |
| 2022-10-19 05:40:00 | AAPL | Stock | 143.8 | 144.0 | 143.8 | 144.0 | 13520.0 |
| 2022-10-19 05:45:00 | AAPL | Stock | 144.02 | 144.47 | 144.0 | 144.47 | 21840.0 |
| 2022-10-19 05:50:00 | AAPL | Stock | 144.48 | 144.5 | 144.26 | 144.4 | 2721.0 |
| 2022-10-19 05:55:00 | AAPL | Stock | 144.39 | 144.42 | 144.39 | 144.41 | 2288.0 |
| 2022-10-19 06:00:00 | AAPL | Stock | 144.29 | 144.38 | 144.18 | 144.38 | 3378.0 |
| 2022-10-19 06:05:00 | AAPL | Stock | 144.15 | 144.15 | 144.11 | 144.11 | 3039.0 |
| 2022-10-19 06:10:00 | AAPL | Stock | 144.1 | 144.25 | 143.84 | 143.86 | 3648.0 |
| 2022-10-19 06:15:00 | AAPL | Stock | 143.85 | 144.2 | 143.85 | 144.0 | 5916.0 |
| 2022-10-19 06:20:00 | AAPL | Stock | 143.88 | 143.95 | 143.85 | 143.85 | 1302.0 |
| 2022-10-19 06:25:00 | AAPL | Stock | 143.85 | 143.85 | 143.65 | 143.65 | 2350.0 |
| 2022-10-19 06:30:00 | AAPL | Stock | 143.71 | 143.79 | 143.66 | 143.79 | 1429.0 |
| 2022-10-19 06:35:00 | AAPL | Stock | 143.78 | 143.91 | 143.58 | 143.59 | 7862.0 |
| 2022-10-19 06:40:00 | AAPL | Stock | 143.59 | 143.59 | 143.22 | 143.22 | 13033.0 |
| 2022-10-19 06:45:00 | AAPL | Stock | 143.22 | 143.39 | 143.22 | 143.31 | 1870.0 |
| 2022-10-19 06:50:00 | AAPL | Stock | 143.4 | 143.43 | 143.21 | 143.25 | 8723.0 |
| 2022-10-19 06:55:00 | AAPL | Stock | 143.26 | 143.26 | 143.21 | 143.22 | 1983.0 |
| 2022-10-19 07:00:00 | AAPL | Stock | 143.46 | 143.59 | 143.4 | 143.59 | 7907.0 |
| 2022-10-19 07:05:00 | AAPL | Stock | 143.58 | 143.58 | 143.29 | 143.29 | 4306.0 |
| 2022-10-19 07:10:00 | AAPL | Stock | 143.29 | 143.29 | 142.51 | 142.51 | 16226.0 |
| 2022-10-19 07:15:00 | AAPL | Stock | 142.61 | 142.79 | 142.33 | 142.43 | 14476.0 |
| 2022-10-19 07:20:00 | AAPL | Stock | 142.58 | 142.7 | 142.5 | 142.65 | 1982.0 |
| 2022-10-19 07:25:00 | AAPL | Stock | 142.6 | 142.6 | 142.11 | 142.11 | 15803.0 |
| 2022-10-19 07:30:00 | AAPL | Stock | 142.18 | 142.29 | 141.95 | 141.99 | 30726.0 |
| 2022-10-19 07:35:00 | AAPL | Stock | 141.99 | 142.35 | 141.99 | 142.33 | 9994.0 |
| 2022-10-19 07:40:00 | AAPL | Stock | 142.35 | 142.44 | 142.16 | 142.3 | 12309.0 |
| 2022-10-19 07:45:00 | AAPL | Stock | 142.17 | 142.33 | 142.02 | 142.28 | 43416.0 |
| 2022-10-19 07:50:00 | AAPL | Stock | 142.28 | 142.32 | 142.18 | 142.23 | 4300.0 |
| 2022-10-19 07:55:00 | AAPL | Stock | 142.24 | 142.52 | 142.22 | 142.52 | 8788.0 |
| 2022-10-19 08:00:00 | AAPL | Stock | 143.5275 | 143.63 | 141.9104 | 142.18 | 86302.0 |
| 2022-10-19 08:05:00 | AAPL | Stock | 142.18 | 142.2 | 141.51 | 141.77 | 51545.0 |
> showing 50 of 412,955 rows — these rows as CSV