PREVIEW / stock_5min / 2023-05-11
file: by_date/stock_5min/2023/2023-05-11.parquet size: 6.7 MB rows: 408,897 symbols: 1,662
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-05-11 04:00:00 | AAPL | Stock | 173.42 | 173.99 | 173.42 | 173.92 | 3024.0 |
| 2023-05-11 04:05:00 | AAPL | Stock | 173.86 | 173.92 | 173.86 | 173.91 | 1503.0 |
| 2023-05-11 04:10:00 | AAPL | Stock | 173.89 | 173.94 | 173.89 | 173.94 | 2127.0 |
| 2023-05-11 04:15:00 | AAPL | Stock | 173.95 | 173.95 | 173.93 | 173.93 | 913.0 |
| 2023-05-11 04:35:00 | AAPL | Stock | 173.83 | 173.83 | 173.81 | 173.81 | 309.0 |
| 2023-05-11 04:45:00 | AAPL | Stock | 173.73 | 173.73 | 173.73 | 173.73 | 135.0 |
| 2023-05-11 04:50:00 | AAPL | Stock | 173.75 | 173.75 | 173.68 | 173.68 | 271.0 |
| 2023-05-11 05:00:00 | AAPL | Stock | 173.74 | 173.74 | 173.74 | 173.74 | 187.0 |
| 2023-05-11 05:05:00 | AAPL | Stock | 173.71 | 173.71 | 173.71 | 173.71 | 150.0 |
| 2023-05-11 05:10:00 | AAPL | Stock | 173.72 | 173.75 | 173.72 | 173.75 | 300.0 |
| 2023-05-11 05:15:00 | AAPL | Stock | 173.73 | 173.73 | 173.73 | 173.73 | 133.0 |
| 2023-05-11 05:20:00 | AAPL | Stock | 173.73 | 173.9 | 173.73 | 173.9 | 4166.0 |
| 2023-05-11 05:25:00 | AAPL | Stock | 173.7 | 173.7 | 173.7 | 173.7 | 200.0 |
| 2023-05-11 05:30:00 | AAPL | Stock | 173.8 | 173.8 | 173.8 | 173.8 | 737.0 |
| 2023-05-11 05:35:00 | AAPL | Stock | 173.79 | 173.79 | 173.79 | 173.79 | 130.0 |
| 2023-05-11 05:40:00 | AAPL | Stock | 173.84 | 173.86 | 173.83 | 173.83 | 338.0 |
| 2023-05-11 05:45:00 | AAPL | Stock | 173.86 | 173.88 | 173.82 | 173.88 | 600.0 |
| 2023-05-11 05:50:00 | AAPL | Stock | 173.78 | 173.78 | 173.78 | 173.78 | 679.0 |
| 2023-05-11 06:10:00 | AAPL | Stock | 173.76 | 173.8 | 173.7 | 173.7 | 2228.0 |
| 2023-05-11 06:15:00 | AAPL | Stock | 173.69 | 173.69 | 173.69 | 173.69 | 106.0 |
| 2023-05-11 06:20:00 | AAPL | Stock | 173.62 | 173.62 | 173.62 | 173.62 | 100.0 |
| 2023-05-11 06:30:00 | AAPL | Stock | 173.65 | 173.65 | 173.65 | 173.65 | 300.0 |
| 2023-05-11 06:35:00 | AAPL | Stock | 173.66 | 173.66 | 173.66 | 173.66 | 211.0 |
| 2023-05-11 06:40:00 | AAPL | Stock | 173.58 | 173.58 | 173.58 | 173.58 | 100.0 |
| 2023-05-11 06:50:00 | AAPL | Stock | 173.65 | 173.65 | 173.65 | 173.65 | 181.0 |
| 2023-05-11 06:55:00 | AAPL | Stock | 173.58 | 173.58 | 173.58 | 173.58 | 100.0 |
| 2023-05-11 07:00:00 | AAPL | Stock | 173.65 | 173.74 | 173.62 | 173.69 | 4621.0 |
| 2023-05-11 07:05:00 | AAPL | Stock | 173.75 | 173.75 | 173.7 | 173.74 | 1595.0 |
| 2023-05-11 07:10:00 | AAPL | Stock | 173.7 | 173.7 | 173.6 | 173.6 | 1336.0 |
| 2023-05-11 07:15:00 | AAPL | Stock | 173.61 | 173.62 | 173.45 | 173.45 | 10180.0 |
| 2023-05-11 07:20:00 | AAPL | Stock | 173.44 | 173.52 | 173.37 | 173.37 | 5218.0 |
| 2023-05-11 07:25:00 | AAPL | Stock | 173.4 | 173.67 | 173.4 | 173.67 | 9366.0 |
| 2023-05-11 07:30:00 | AAPL | Stock | 173.6 | 173.61 | 173.57 | 173.57 | 1450.0 |
| 2023-05-11 07:35:00 | AAPL | Stock | 173.55 | 173.55 | 173.55 | 173.55 | 1000.0 |
| 2023-05-11 07:40:00 | AAPL | Stock | 173.53 | 173.57 | 173.53 | 173.53 | 967.0 |
| 2023-05-11 07:45:00 | AAPL | Stock | 173.53 | 173.55 | 173.5 | 173.51 | 1545.0 |
| 2023-05-11 07:50:00 | AAPL | Stock | 173.5 | 173.52 | 173.42 | 173.46 | 4200.0 |
| 2023-05-11 07:55:00 | AAPL | Stock | 173.51 | 173.51 | 173.48 | 173.48 | 1354.0 |
| 2023-05-11 08:00:00 | AAPL | Stock | 173.7486 | 174.03 | 173.42 | 173.52 | 36080.0 |
| 2023-05-11 08:05:00 | AAPL | Stock | 173.51 | 173.6 | 173.49 | 173.6 | 1610.0 |
| 2023-05-11 08:10:00 | AAPL | Stock | 173.59 | 173.63 | 173.56 | 173.6 | 5229.0 |
| 2023-05-11 08:15:00 | AAPL | Stock | 173.62 | 173.9 | 173.6 | 173.65 | 23045.0 |
| 2023-05-11 08:20:00 | AAPL | Stock | 173.66 | 173.66 | 173.51 | 173.56 | 18712.0 |
| 2023-05-11 08:25:00 | AAPL | Stock | 173.6 | 173.65 | 173.5402 | 173.65 | 4489.0 |
| 2023-05-11 08:30:00 | AAPL | Stock | 173.66 | 173.9 | 173.56 | 173.7 | 24162.0 |
| 2023-05-11 08:35:00 | AAPL | Stock | 173.65 | 173.7998 | 173.51 | 173.7 | 18082.0 |
| 2023-05-11 08:40:00 | AAPL | Stock | 173.7 | 173.74 | 173.58 | 173.59 | 8610.0 |
| 2023-05-11 08:45:00 | AAPL | Stock | 173.59 | 173.6796 | 173.51 | 173.65 | 7391.0 |
| 2023-05-11 08:50:00 | AAPL | Stock | 173.61 | 173.71 | 173.61 | 173.7 | 9733.0 |
| 2023-05-11 08:55:00 | AAPL | Stock | 173.65 | 173.7276 | 173.65 | 173.6899 | 5874.0 |
> showing 50 of 408,897 rows — these rows as CSV