PREVIEW / stock_5min / 2023-06-07
file: by_date/stock_5min/2023/2023-06-07.parquet size: 6.9 MB rows: 422,196 symbols: 1,617
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 |
|---|---|---|---|---|---|---|---|
| 2023-06-07 04:00:00 | AAPL | Stock | 179.07 | 179.07 | 178.78 | 178.83 | 3095.0 |
| 2023-06-07 04:05:00 | AAPL | Stock | 178.85 | 178.85 | 178.85 | 178.85 | 256.0 |
| 2023-06-07 04:10:00 | AAPL | Stock | 178.7 | 178.8 | 178.7 | 178.75 | 1043.0 |
| 2023-06-07 04:20:00 | AAPL | Stock | 178.75 | 178.76 | 178.69 | 178.75 | 1038.0 |
| 2023-06-07 04:25:00 | AAPL | Stock | 178.76 | 178.8 | 178.75 | 178.8 | 1780.0 |
| 2023-06-07 04:30:00 | AAPL | Stock | 178.76 | 178.81 | 178.76 | 178.81 | 1078.0 |
| 2023-06-07 04:35:00 | AAPL | Stock | 178.75 | 178.75 | 178.75 | 178.75 | 114.0 |
| 2023-06-07 04:45:00 | AAPL | Stock | 178.84 | 178.84 | 178.79 | 178.8 | 717.0 |
| 2023-06-07 04:50:00 | AAPL | Stock | 178.8 | 178.8 | 178.75 | 178.75 | 207.0 |
| 2023-06-07 05:05:00 | AAPL | Stock | 178.75 | 178.75 | 178.75 | 178.75 | 503.0 |
| 2023-06-07 05:10:00 | AAPL | Stock | 178.79 | 178.79 | 178.79 | 178.79 | 592.0 |
| 2023-06-07 05:15:00 | AAPL | Stock | 178.76 | 178.76 | 178.75 | 178.75 | 646.0 |
| 2023-06-07 05:25:00 | AAPL | Stock | 178.79 | 178.79 | 178.79 | 178.79 | 383.0 |
| 2023-06-07 05:30:00 | AAPL | Stock | 178.86 | 178.9 | 178.86 | 178.87 | 1161.0 |
| 2023-06-07 05:50:00 | AAPL | Stock | 178.98 | 178.98 | 178.95 | 178.95 | 209.0 |
| 2023-06-07 05:55:00 | AAPL | Stock | 178.95 | 178.98 | 178.93 | 178.98 | 538.0 |
| 2023-06-07 06:00:00 | AAPL | Stock | 179.0 | 179.0 | 178.99 | 179.0 | 481.0 |
| 2023-06-07 06:05:00 | AAPL | Stock | 179.0 | 179.06 | 179.0 | 179.06 | 393.0 |
| 2023-06-07 06:10:00 | AAPL | Stock | 179.07 | 179.08 | 179.07 | 179.08 | 314.0 |
| 2023-06-07 06:15:00 | AAPL | Stock | 179.1 | 179.1 | 179.1 | 179.1 | 147.0 |
| 2023-06-07 06:20:00 | AAPL | Stock | 179.13 | 179.2 | 179.13 | 179.2 | 2441.0 |
| 2023-06-07 06:25:00 | AAPL | Stock | 179.14 | 179.14 | 179.14 | 179.14 | 580.0 |
| 2023-06-07 06:30:00 | AAPL | Stock | 179.08 | 179.08 | 178.2 | 178.2 | 10267.0 |
| 2023-06-07 06:35:00 | AAPL | Stock | 178.37 | 178.78 | 178.33 | 178.78 | 2265.0 |
| 2023-06-07 06:40:00 | AAPL | Stock | 178.73 | 178.82 | 178.73 | 178.8 | 823.0 |
| 2023-06-07 06:45:00 | AAPL | Stock | 178.75 | 178.82 | 178.73 | 178.73 | 1755.0 |
| 2023-06-07 06:50:00 | AAPL | Stock | 178.79 | 178.89 | 178.75 | 178.89 | 1828.0 |
| 2023-06-07 06:55:00 | AAPL | Stock | 178.82 | 178.82 | 178.73 | 178.81 | 1205.0 |
| 2023-06-07 07:00:00 | AAPL | Stock | 178.81 | 178.95 | 178.78 | 178.95 | 3636.0 |
| 2023-06-07 07:05:00 | AAPL | Stock | 178.93 | 179.0 | 178.88 | 178.93 | 3908.0 |
| 2023-06-07 07:10:00 | AAPL | Stock | 178.97 | 179.15 | 178.91 | 179.04 | 6873.0 |
| 2023-06-07 07:15:00 | AAPL | Stock | 179.0 | 179.0 | 178.79 | 178.8 | 11277.0 |
| 2023-06-07 07:20:00 | AAPL | Stock | 178.82 | 178.85 | 178.78 | 178.78 | 12896.0 |
| 2023-06-07 07:25:00 | AAPL | Stock | 178.77 | 178.77 | 178.58 | 178.65 | 7836.0 |
| 2023-06-07 07:30:00 | AAPL | Stock | 178.65 | 178.75 | 178.65 | 178.75 | 2656.0 |
| 2023-06-07 07:35:00 | AAPL | Stock | 178.76 | 178.88 | 178.76 | 178.88 | 5932.0 |
| 2023-06-07 07:40:00 | AAPL | Stock | 178.88 | 178.89 | 178.84 | 178.84 | 10710.0 |
| 2023-06-07 07:45:00 | AAPL | Stock | 178.84 | 178.85 | 178.8 | 178.85 | 1898.0 |
| 2023-06-07 07:50:00 | AAPL | Stock | 178.85 | 179.0 | 178.82 | 178.98 | 5794.0 |
| 2023-06-07 07:55:00 | AAPL | Stock | 179.0 | 179.06 | 179.0 | 179.06 | 724.0 |
| 2023-06-07 08:00:00 | AAPL | Stock | 178.87 | 179.1999 | 178.5801 | 179.03 | 59411.0 |
| 2023-06-07 08:05:00 | AAPL | Stock | 179.07 | 179.09 | 179.0 | 179.09 | 4922.0 |
| 2023-06-07 08:10:00 | AAPL | Stock | 179.0867 | 179.09 | 179.0 | 179.05 | 11204.0 |
| 2023-06-07 08:15:00 | AAPL | Stock | 179.0022 | 179.12 | 179.0 | 179.11 | 8780.0 |
| 2023-06-07 08:20:00 | AAPL | Stock | 179.1184 | 179.16 | 179.08 | 179.15 | 8798.0 |
| 2023-06-07 08:25:00 | AAPL | Stock | 179.12 | 179.16 | 179.0 | 179.13 | 24316.0 |
| 2023-06-07 08:30:00 | AAPL | Stock | 179.11 | 179.1383 | 178.91 | 179.1383 | 19924.0 |
| 2023-06-07 08:35:00 | AAPL | Stock | 179.1 | 179.15 | 178.99 | 179.0 | 10797.0 |
| 2023-06-07 08:40:00 | AAPL | Stock | 178.92 | 178.98 | 178.9 | 178.9 | 3479.0 |
| 2023-06-07 08:45:00 | AAPL | Stock | 178.88 | 178.92 | 178.81 | 178.87 | 14191.0 |
> showing 50 of 422,196 rows — these rows as CSV