PREVIEW / stock_5min / 2022-10-31
file: by_date/stock_5min/2022/2022-10-31.parquet size: 6.8 MB rows: 421,346 symbols: 2,133
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-31 04:00:00 | AAPL | Stock | 155.0 | 155.66 | 154.54 | 154.69 | 26911.0 |
| 2022-10-31 04:05:00 | AAPL | Stock | 154.66 | 154.8 | 154.64 | 154.7 | 12623.0 |
| 2022-10-31 04:10:00 | AAPL | Stock | 154.65 | 154.82 | 154.65 | 154.75 | 11329.0 |
| 2022-10-31 04:15:00 | AAPL | Stock | 154.75 | 154.9 | 154.7 | 154.8 | 4312.0 |
| 2022-10-31 04:20:00 | AAPL | Stock | 154.8 | 154.82 | 154.75 | 154.82 | 2252.0 |
| 2022-10-31 04:25:00 | AAPL | Stock | 154.82 | 154.89 | 154.71 | 154.71 | 3939.0 |
| 2022-10-31 04:30:00 | AAPL | Stock | 154.68 | 154.68 | 154.45 | 154.45 | 5957.0 |
| 2022-10-31 04:35:00 | AAPL | Stock | 154.51 | 154.62 | 154.51 | 154.6 | 1340.0 |
| 2022-10-31 04:40:00 | AAPL | Stock | 154.62 | 154.65 | 154.58 | 154.62 | 1745.0 |
| 2022-10-31 04:45:00 | AAPL | Stock | 154.61 | 154.65 | 154.58 | 154.58 | 2106.0 |
| 2022-10-31 04:50:00 | AAPL | Stock | 154.6 | 154.64 | 154.56 | 154.56 | 6084.0 |
| 2022-10-31 04:55:00 | AAPL | Stock | 154.6 | 154.75 | 154.6 | 154.68 | 2575.0 |
| 2022-10-31 05:00:00 | AAPL | Stock | 154.72 | 154.8 | 154.67 | 154.67 | 3265.0 |
| 2022-10-31 05:05:00 | AAPL | Stock | 154.67 | 154.67 | 154.67 | 154.67 | 111.0 |
| 2022-10-31 05:10:00 | AAPL | Stock | 154.75 | 154.75 | 154.69 | 154.71 | 2484.0 |
| 2022-10-31 05:15:00 | AAPL | Stock | 154.8 | 154.8 | 154.76 | 154.8 | 1939.0 |
| 2022-10-31 05:20:00 | AAPL | Stock | 154.8 | 154.99 | 154.8 | 154.99 | 4747.0 |
| 2022-10-31 05:25:00 | AAPL | Stock | 154.95 | 154.98 | 154.88 | 154.88 | 1748.0 |
| 2022-10-31 05:30:00 | AAPL | Stock | 154.88 | 154.99 | 154.88 | 154.93 | 3358.0 |
| 2022-10-31 05:35:00 | AAPL | Stock | 154.96 | 154.96 | 154.96 | 154.96 | 200.0 |
| 2022-10-31 05:40:00 | AAPL | Stock | 154.97 | 155.0 | 154.92 | 154.95 | 1508.0 |
| 2022-10-31 05:45:00 | AAPL | Stock | 154.97 | 155.03 | 154.97 | 155.03 | 3344.0 |
| 2022-10-31 05:50:00 | AAPL | Stock | 155.09 | 155.1 | 154.95 | 154.95 | 3214.0 |
| 2022-10-31 05:55:00 | AAPL | Stock | 154.95 | 154.95 | 154.78 | 154.78 | 4057.0 |
| 2022-10-31 06:00:00 | AAPL | Stock | 154.78 | 154.79 | 154.75 | 154.78 | 2152.0 |
| 2022-10-31 06:05:00 | AAPL | Stock | 154.79 | 154.93 | 154.79 | 154.93 | 744.0 |
| 2022-10-31 06:10:00 | AAPL | Stock | 154.87 | 154.87 | 154.87 | 154.87 | 2850.0 |
| 2022-10-31 06:15:00 | AAPL | Stock | 154.83 | 154.83 | 154.81 | 154.81 | 334.0 |
| 2022-10-31 06:20:00 | AAPL | Stock | 154.81 | 154.85 | 154.78 | 154.85 | 10398.0 |
| 2022-10-31 06:25:00 | AAPL | Stock | 154.8 | 154.8 | 154.79 | 154.79 | 2027.0 |
| 2022-10-31 06:30:00 | AAPL | Stock | 154.85 | 154.85 | 154.77 | 154.77 | 1593.0 |
| 2022-10-31 06:35:00 | AAPL | Stock | 154.74 | 154.79 | 154.69 | 154.79 | 2767.0 |
| 2022-10-31 06:40:00 | AAPL | Stock | 154.78 | 154.78 | 154.78 | 154.78 | 100.0 |
| 2022-10-31 06:45:00 | AAPL | Stock | 154.72 | 154.72 | 154.6 | 154.6 | 1949.0 |
| 2022-10-31 06:50:00 | AAPL | Stock | 154.64 | 154.64 | 154.58 | 154.58 | 2445.0 |
| 2022-10-31 06:55:00 | AAPL | Stock | 154.64 | 154.8 | 154.64 | 154.8 | 3772.0 |
| 2022-10-31 07:00:00 | AAPL | Stock | 154.89 | 155.02 | 154.75 | 154.9 | 27453.0 |
| 2022-10-31 07:05:00 | AAPL | Stock | 154.85 | 154.86 | 154.77 | 154.81 | 6136.0 |
| 2022-10-31 07:10:00 | AAPL | Stock | 154.85 | 154.91 | 154.8 | 154.8 | 5977.0 |
| 2022-10-31 07:15:00 | AAPL | Stock | 154.84 | 154.87 | 154.81 | 154.85 | 7135.0 |
| 2022-10-31 07:20:00 | AAPL | Stock | 154.8 | 154.87 | 154.57 | 154.6 | 12794.0 |
| 2022-10-31 07:25:00 | AAPL | Stock | 154.65 | 154.85 | 154.63 | 154.83 | 12963.0 |
| 2022-10-31 07:30:00 | AAPL | Stock | 154.81 | 154.87 | 154.8 | 154.8 | 5139.0 |
| 2022-10-31 07:35:00 | AAPL | Stock | 154.8 | 154.82 | 154.64 | 154.73 | 8233.0 |
| 2022-10-31 07:40:00 | AAPL | Stock | 154.79 | 154.81 | 154.77 | 154.77 | 2519.0 |
| 2022-10-31 07:45:00 | AAPL | Stock | 154.81 | 154.87 | 154.7 | 154.76 | 10896.0 |
| 2022-10-31 07:50:00 | AAPL | Stock | 154.73 | 154.73 | 154.59 | 154.63 | 10184.0 |
| 2022-10-31 07:55:00 | AAPL | Stock | 154.63 | 154.65 | 154.61 | 154.61 | 12301.0 |
| 2022-10-31 08:00:00 | AAPL | Stock | 154.9778 | 155.0526 | 154.58 | 154.68 | 122564.0 |
| 2022-10-31 08:05:00 | AAPL | Stock | 154.7 | 154.74 | 154.6 | 154.66 | 29107.0 |
> showing 50 of 421,346 rows — these rows as CSV