PREVIEW / stock_5min / 2022-03-17
file: by_date/stock_5min/2022/2022-03-17.parquet size: 7.4 MB rows: 454,431 symbols: 2,480
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-03-17 04:00:00 | AAPL | Stock | 159.83 | 160.1 | 159.73 | 160.0 | 11410.0 |
| 2022-03-17 04:05:00 | AAPL | Stock | 159.99 | 160.0 | 159.39 | 159.39 | 3574.0 |
| 2022-03-17 04:10:00 | AAPL | Stock | 159.35 | 159.5 | 159.35 | 159.49 | 1811.0 |
| 2022-03-17 04:15:00 | AAPL | Stock | 159.46 | 159.55 | 159.46 | 159.5 | 999.0 |
| 2022-03-17 04:20:00 | AAPL | Stock | 159.54 | 159.55 | 159.35 | 159.55 | 642.0 |
| 2022-03-17 04:25:00 | AAPL | Stock | 159.51 | 159.7 | 159.51 | 159.7 | 2450.0 |
| 2022-03-17 04:30:00 | AAPL | Stock | 159.6 | 159.69 | 159.6 | 159.66 | 2006.0 |
| 2022-03-17 04:35:00 | AAPL | Stock | 159.61 | 159.69 | 159.52 | 159.59 | 2484.0 |
| 2022-03-17 04:40:00 | AAPL | Stock | 159.59 | 159.64 | 159.5 | 159.5 | 2916.0 |
| 2022-03-17 04:45:00 | AAPL | Stock | 159.54 | 159.55 | 159.49 | 159.5 | 2058.0 |
| 2022-03-17 04:50:00 | AAPL | Stock | 159.42 | 159.46 | 159.28 | 159.28 | 1467.0 |
| 2022-03-17 04:55:00 | AAPL | Stock | 159.3 | 159.36 | 159.26 | 159.36 | 1971.0 |
| 2022-03-17 05:00:00 | AAPL | Stock | 159.31 | 159.31 | 159.27 | 159.3 | 759.0 |
| 2022-03-17 05:05:00 | AAPL | Stock | 159.26 | 159.26 | 158.98 | 159.0 | 6282.0 |
| 2022-03-17 05:10:00 | AAPL | Stock | 158.91 | 159.08 | 158.91 | 159.08 | 614.0 |
| 2022-03-17 05:15:00 | AAPL | Stock | 159.01 | 159.04 | 158.97 | 158.97 | 1703.0 |
| 2022-03-17 05:20:00 | AAPL | Stock | 158.97 | 159.2 | 158.96 | 159.2 | 1616.0 |
| 2022-03-17 05:25:00 | AAPL | Stock | 159.2 | 159.2 | 159.15 | 159.15 | 1039.0 |
| 2022-03-17 05:30:00 | AAPL | Stock | 159.15 | 159.15 | 159.1 | 159.1 | 1187.0 |
| 2022-03-17 05:35:00 | AAPL | Stock | 159.05 | 159.05 | 158.85 | 158.9 | 2589.0 |
| 2022-03-17 05:40:00 | AAPL | Stock | 159.0 | 159.0 | 159.0 | 159.0 | 1016.0 |
| 2022-03-17 05:45:00 | AAPL | Stock | 159.08 | 159.08 | 158.92 | 158.92 | 4154.0 |
| 2022-03-17 05:50:00 | AAPL | Stock | 159.05 | 159.1 | 159.05 | 159.1 | 955.0 |
| 2022-03-17 05:55:00 | AAPL | Stock | 159.14 | 159.2 | 159.14 | 159.2 | 574.0 |
| 2022-03-17 06:00:00 | AAPL | Stock | 159.2 | 159.2 | 158.49 | 158.49 | 5961.0 |
| 2022-03-17 06:05:00 | AAPL | Stock | 158.6 | 158.6 | 158.45 | 158.45 | 3658.0 |
| 2022-03-17 06:10:00 | AAPL | Stock | 158.3 | 158.62 | 158.23 | 158.62 | 2908.0 |
| 2022-03-17 06:15:00 | AAPL | Stock | 158.42 | 158.8 | 158.34 | 158.8 | 2231.0 |
| 2022-03-17 06:20:00 | AAPL | Stock | 158.77 | 158.97 | 158.72 | 158.97 | 2711.0 |
| 2022-03-17 06:25:00 | AAPL | Stock | 158.79 | 158.79 | 158.73 | 158.73 | 300.0 |
| 2022-03-17 06:30:00 | AAPL | Stock | 158.8 | 159.1 | 158.8 | 159.1 | 1318.0 |
| 2022-03-17 06:35:00 | AAPL | Stock | 158.9 | 158.99 | 158.9 | 158.99 | 1004.0 |
| 2022-03-17 06:40:00 | AAPL | Stock | 159.0 | 159.0 | 158.87 | 158.99 | 906.0 |
| 2022-03-17 06:45:00 | AAPL | Stock | 158.99 | 159.1 | 158.99 | 159.1 | 1842.0 |
| 2022-03-17 06:50:00 | AAPL | Stock | 159.03 | 159.1 | 159.03 | 159.1 | 1561.0 |
| 2022-03-17 06:55:00 | AAPL | Stock | 159.07 | 159.2 | 159.01 | 159.19 | 4063.0 |
| 2022-03-17 07:00:00 | AAPL | Stock | 159.23 | 159.24 | 158.9 | 159.24 | 14121.0 |
| 2022-03-17 07:05:00 | AAPL | Stock | 159.16 | 159.19 | 158.93 | 158.93 | 4028.0 |
| 2022-03-17 07:10:00 | AAPL | Stock | 158.98 | 158.99 | 158.93 | 158.93 | 1590.0 |
| 2022-03-17 07:15:00 | AAPL | Stock | 158.97 | 159.04 | 158.83 | 158.83 | 6730.0 |
| 2022-03-17 07:20:00 | AAPL | Stock | 158.82 | 158.83 | 158.65 | 158.83 | 5003.0 |
| 2022-03-17 07:25:00 | AAPL | Stock | 158.83 | 158.83 | 158.61 | 158.8 | 7106.0 |
| 2022-03-17 07:30:00 | AAPL | Stock | 158.66 | 158.9 | 158.66 | 158.82 | 5758.0 |
| 2022-03-17 07:35:00 | AAPL | Stock | 158.86 | 158.86 | 158.67 | 158.67 | 3136.0 |
| 2022-03-17 07:40:00 | AAPL | Stock | 158.67 | 158.72 | 158.5 | 158.52 | 8320.0 |
| 2022-03-17 07:45:00 | AAPL | Stock | 158.56 | 158.69 | 158.5 | 158.67 | 3021.0 |
| 2022-03-17 07:50:00 | AAPL | Stock | 158.64 | 158.74 | 158.64 | 158.7 | 2485.0 |
| 2022-03-17 07:55:00 | AAPL | Stock | 158.72 | 158.98 | 158.72 | 158.89 | 3729.0 |
| 2022-03-17 08:00:00 | AAPL | Stock | 159.0301 | 160.0 | 158.52 | 159.07 | 168157.0 |
| 2022-03-17 08:05:00 | AAPL | Stock | 159.09 | 159.21 | 159.0 | 159.0 | 23505.0 |
> showing 50 of 454,431 rows — these rows as CSV