PREVIEW / stock_5min / 2023-06-28
file: by_date/stock_5min/2023/2023-06-28.parquet size: 6.6 MB rows: 408,659 symbols: 1,567
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-28 04:00:00 | AAPL | Stock | 187.98 | 188.06 | 187.86 | 187.91 | 1015.0 |
| 2023-06-28 04:05:00 | AAPL | Stock | 188.02 | 188.3 | 187.88 | 188.03 | 3580.0 |
| 2023-06-28 04:15:00 | AAPL | Stock | 188.03 | 188.03 | 188.02 | 188.03 | 1932.0 |
| 2023-06-28 04:20:00 | AAPL | Stock | 187.93 | 188.09 | 187.93 | 188.09 | 1312.0 |
| 2023-06-28 04:25:00 | AAPL | Stock | 188.2 | 188.2 | 188.13 | 188.13 | 1197.0 |
| 2023-06-28 04:30:00 | AAPL | Stock | 188.14 | 188.14 | 188.02 | 188.03 | 500.0 |
| 2023-06-28 04:35:00 | AAPL | Stock | 187.89 | 188.06 | 187.88 | 187.93 | 2054.0 |
| 2023-06-28 04:55:00 | AAPL | Stock | 187.89 | 187.95 | 187.89 | 187.91 | 990.0 |
| 2023-06-28 05:05:00 | AAPL | Stock | 187.9 | 187.9 | 187.9 | 187.9 | 199.0 |
| 2023-06-28 05:10:00 | AAPL | Stock | 187.95 | 187.95 | 187.94 | 187.94 | 300.0 |
| 2023-06-28 05:15:00 | AAPL | Stock | 187.94 | 187.94 | 187.92 | 187.92 | 250.0 |
| 2023-06-28 05:20:00 | AAPL | Stock | 187.88 | 187.88 | 187.88 | 187.88 | 320.0 |
| 2023-06-28 05:25:00 | AAPL | Stock | 187.86 | 187.88 | 187.8 | 187.84 | 3455.0 |
| 2023-06-28 05:30:00 | AAPL | Stock | 187.82 | 187.82 | 187.72 | 187.73 | 1784.0 |
| 2023-06-28 05:35:00 | AAPL | Stock | 187.75 | 187.83 | 187.75 | 187.8 | 6720.0 |
| 2023-06-28 05:45:00 | AAPL | Stock | 187.8 | 187.8 | 187.8 | 187.8 | 464.0 |
| 2023-06-28 05:55:00 | AAPL | Stock | 187.8 | 187.8 | 187.8 | 187.8 | 881.0 |
| 2023-06-28 06:00:00 | AAPL | Stock | 187.8 | 187.8 | 187.8 | 187.8 | 1350.0 |
| 2023-06-28 06:05:00 | AAPL | Stock | 187.8 | 187.8 | 187.8 | 187.8 | 799.0 |
| 2023-06-28 06:10:00 | AAPL | Stock | 187.75 | 187.8 | 187.75 | 187.8 | 3296.0 |
| 2023-06-28 06:15:00 | AAPL | Stock | 187.8 | 187.8 | 187.78 | 187.78 | 2400.0 |
| 2023-06-28 06:25:00 | AAPL | Stock | 187.8 | 187.8 | 187.8 | 187.8 | 2044.0 |
| 2023-06-28 06:30:00 | AAPL | Stock | 187.79 | 187.79 | 187.79 | 187.79 | 1100.0 |
| 2023-06-28 06:40:00 | AAPL | Stock | 187.75 | 187.76 | 187.72 | 187.72 | 581.0 |
| 2023-06-28 06:45:00 | AAPL | Stock | 187.74 | 187.74 | 187.7 | 187.7 | 4464.0 |
| 2023-06-28 06:50:00 | AAPL | Stock | 187.77 | 187.78 | 187.77 | 187.78 | 460.0 |
| 2023-06-28 07:00:00 | AAPL | Stock | 187.9 | 187.93 | 187.87 | 187.89 | 3355.0 |
| 2023-06-28 07:05:00 | AAPL | Stock | 187.9 | 187.9 | 187.8 | 187.85 | 4726.0 |
| 2023-06-28 07:10:00 | AAPL | Stock | 187.85 | 187.85 | 187.85 | 187.85 | 143.0 |
| 2023-06-28 07:15:00 | AAPL | Stock | 187.86 | 187.86 | 187.81 | 187.81 | 1712.0 |
| 2023-06-28 07:20:00 | AAPL | Stock | 187.82 | 187.82 | 187.75 | 187.75 | 1901.0 |
| 2023-06-28 07:25:00 | AAPL | Stock | 187.8 | 187.8 | 187.75 | 187.75 | 2968.0 |
| 2023-06-28 07:30:00 | AAPL | Stock | 187.75 | 187.8 | 187.7 | 187.8 | 6959.0 |
| 2023-06-28 07:35:00 | AAPL | Stock | 187.76 | 187.76 | 187.66 | 187.7 | 3009.0 |
| 2023-06-28 07:40:00 | AAPL | Stock | 187.71 | 187.73 | 187.6 | 187.73 | 4022.0 |
| 2023-06-28 07:45:00 | AAPL | Stock | 187.71 | 187.71 | 187.7 | 187.7 | 1547.0 |
| 2023-06-28 07:50:00 | AAPL | Stock | 187.7 | 187.7 | 187.65 | 187.66 | 1730.0 |
| 2023-06-28 07:55:00 | AAPL | Stock | 187.67 | 187.76 | 187.6 | 187.6 | 12447.0 |
| 2023-06-28 08:00:00 | AAPL | Stock | 187.9 | 188.14 | 187.6 | 187.66 | 40759.0 |
| 2023-06-28 08:05:00 | AAPL | Stock | 187.6701 | 187.8 | 187.6701 | 187.7603 | 3956.0 |
| 2023-06-28 08:10:00 | AAPL | Stock | 187.77 | 187.83 | 187.75 | 187.82 | 4270.0 |
| 2023-06-28 08:15:00 | AAPL | Stock | 187.82 | 187.98 | 187.82 | 187.95 | 9340.0 |
| 2023-06-28 08:20:00 | AAPL | Stock | 187.95 | 187.95 | 187.85 | 187.94 | 11549.0 |
| 2023-06-28 08:25:00 | AAPL | Stock | 187.95 | 187.98 | 187.92 | 187.98 | 15617.0 |
| 2023-06-28 08:30:00 | AAPL | Stock | 187.99 | 188.01 | 187.78 | 187.89 | 26131.0 |
| 2023-06-28 08:35:00 | AAPL | Stock | 187.93 | 187.93 | 187.78 | 187.81 | 4828.0 |
| 2023-06-28 08:40:00 | AAPL | Stock | 187.8 | 187.8 | 187.66 | 187.72 | 14172.0 |
| 2023-06-28 08:45:00 | AAPL | Stock | 187.81 | 187.81 | 187.77 | 187.79 | 3573.0 |
| 2023-06-28 08:50:00 | AAPL | Stock | 187.79 | 187.88 | 187.79 | 187.86 | 7342.0 |
| 2023-06-28 08:55:00 | AAPL | Stock | 187.85 | 187.85 | 187.79 | 187.81 | 4905.0 |
> showing 50 of 408,659 rows — these rows as CSV