PREVIEW / stock_5min / 2023-09-18
file: by_date/stock_5min/2023/2023-09-18.parquet size: 6.4 MB rows: 391,891 symbols: 1,438
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-09-18 04:00:00 | AAPL | Stock | 175.9 | 175.9 | 175.64 | 175.67 | 10121.0 |
| 2023-09-18 04:05:00 | AAPL | Stock | 175.66 | 175.66 | 175.55 | 175.64 | 9610.0 |
| 2023-09-18 04:10:00 | AAPL | Stock | 175.65 | 175.73 | 175.64 | 175.7 | 8124.0 |
| 2023-09-18 04:15:00 | AAPL | Stock | 175.7 | 175.76 | 175.65 | 175.65 | 5474.0 |
| 2023-09-18 04:20:00 | AAPL | Stock | 175.66 | 175.69 | 175.65 | 175.69 | 648.0 |
| 2023-09-18 04:25:00 | AAPL | Stock | 175.69 | 175.69 | 175.69 | 175.69 | 700.0 |
| 2023-09-18 04:30:00 | AAPL | Stock | 175.69 | 175.7 | 175.69 | 175.69 | 1471.0 |
| 2023-09-18 04:35:00 | AAPL | Stock | 175.65 | 175.65 | 175.65 | 175.65 | 128.0 |
| 2023-09-18 04:40:00 | AAPL | Stock | 175.69 | 175.83 | 175.69 | 175.8 | 10166.0 |
| 2023-09-18 04:45:00 | AAPL | Stock | 175.83 | 175.83 | 175.82 | 175.82 | 200.0 |
| 2023-09-18 04:50:00 | AAPL | Stock | 175.84 | 175.85 | 175.78 | 175.78 | 2929.0 |
| 2023-09-18 04:55:00 | AAPL | Stock | 175.79 | 175.81 | 175.74 | 175.75 | 7333.0 |
| 2023-09-18 05:00:00 | AAPL | Stock | 175.73 | 175.75 | 175.67 | 175.75 | 7594.0 |
| 2023-09-18 05:05:00 | AAPL | Stock | 175.78 | 175.81 | 175.78 | 175.79 | 2103.0 |
| 2023-09-18 05:10:00 | AAPL | Stock | 175.78 | 175.9 | 175.78 | 175.9 | 1239.0 |
| 2023-09-18 05:20:00 | AAPL | Stock | 175.8 | 175.8 | 175.68 | 175.68 | 2514.0 |
| 2023-09-18 05:25:00 | AAPL | Stock | 175.7 | 175.76 | 175.7 | 175.7 | 1267.0 |
| 2023-09-18 05:30:00 | AAPL | Stock | 175.76 | 175.9 | 175.76 | 175.85 | 3799.0 |
| 2023-09-18 05:35:00 | AAPL | Stock | 175.88 | 175.88 | 175.81 | 175.81 | 1095.0 |
| 2023-09-18 05:40:00 | AAPL | Stock | 175.81 | 175.81 | 175.81 | 175.81 | 100.0 |
| 2023-09-18 05:45:00 | AAPL | Stock | 175.83 | 175.88 | 175.83 | 175.88 | 1238.0 |
| 2023-09-18 05:50:00 | AAPL | Stock | 175.86 | 175.86 | 175.81 | 175.81 | 1035.0 |
| 2023-09-18 05:55:00 | AAPL | Stock | 175.84 | 175.84 | 175.84 | 175.84 | 100.0 |
| 2023-09-18 06:00:00 | AAPL | Stock | 175.82 | 175.86 | 175.78 | 175.86 | 6287.0 |
| 2023-09-18 06:05:00 | AAPL | Stock | 175.85 | 175.88 | 175.8 | 175.88 | 5591.0 |
| 2023-09-18 06:10:00 | AAPL | Stock | 175.875 | 175.875 | 175.64 | 175.71 | 6344.0 |
| 2023-09-18 06:15:00 | AAPL | Stock | 175.64 | 175.73 | 175.63 | 175.73 | 1791.0 |
| 2023-09-18 06:20:00 | AAPL | Stock | 175.71 | 175.73 | 175.71 | 175.73 | 3156.0 |
| 2023-09-18 06:25:00 | AAPL | Stock | 175.74 | 175.8 | 175.73 | 175.8 | 2700.0 |
| 2023-09-18 06:30:00 | AAPL | Stock | 175.8 | 175.9 | 175.8 | 175.9 | 5992.0 |
| 2023-09-18 06:35:00 | AAPL | Stock | 175.9 | 175.96 | 175.86 | 175.96 | 11606.0 |
| 2023-09-18 06:40:00 | AAPL | Stock | 175.96 | 175.96 | 175.8 | 175.85 | 5369.0 |
| 2023-09-18 06:45:00 | AAPL | Stock | 175.87 | 175.91 | 175.87 | 175.9 | 7521.0 |
| 2023-09-18 06:50:00 | AAPL | Stock | 175.9 | 175.9 | 175.85 | 175.85 | 35007.0 |
| 2023-09-18 06:55:00 | AAPL | Stock | 175.81 | 175.84 | 175.77 | 175.77 | 5674.0 |
| 2023-09-18 07:00:00 | AAPL | Stock | 175.84 | 175.84 | 175.62 | 175.7 | 19983.0 |
| 2023-09-18 07:05:00 | AAPL | Stock | 175.7 | 175.75 | 175.43 | 175.43 | 12868.0 |
| 2023-09-18 07:10:00 | AAPL | Stock | 175.43 | 175.52 | 175.42 | 175.47 | 13272.0 |
| 2023-09-18 07:15:00 | AAPL | Stock | 175.46 | 175.51 | 175.45 | 175.47 | 15093.0 |
| 2023-09-18 07:20:00 | AAPL | Stock | 175.47 | 175.64 | 175.46 | 175.51 | 12235.0 |
| 2023-09-18 07:25:00 | AAPL | Stock | 175.46 | 175.54 | 175.46 | 175.47 | 2665.0 |
| 2023-09-18 07:30:00 | AAPL | Stock | 175.46 | 175.46 | 175.14 | 175.15 | 9460.0 |
| 2023-09-18 07:35:00 | AAPL | Stock | 175.1 | 175.18 | 174.75 | 174.8 | 23754.0 |
| 2023-09-18 07:40:00 | AAPL | Stock | 174.75 | 174.82 | 174.7 | 174.74 | 27410.0 |
| 2023-09-18 07:45:00 | AAPL | Stock | 174.74 | 174.75 | 174.64 | 174.65 | 1954.0 |
| 2023-09-18 07:50:00 | AAPL | Stock | 174.63 | 174.81 | 174.6 | 174.75 | 15065.0 |
| 2023-09-18 07:55:00 | AAPL | Stock | 174.75 | 174.82 | 174.71 | 174.72 | 8062.0 |
| 2023-09-18 08:00:00 | AAPL | Stock | 175.65 | 176.07 | 174.6 | 175.02 | 103188.0 |
| 2023-09-18 08:05:00 | AAPL | Stock | 175.0 | 175.05 | 174.87 | 174.97 | 24705.0 |
| 2023-09-18 08:10:00 | AAPL | Stock | 174.97 | 175.15 | 174.97 | 175.11 | 12517.0 |
> showing 50 of 391,891 rows — these rows as CSV