PREVIEW / stock_5min / 2023-05-12
file: by_date/stock_5min/2023/2023-05-12.parquet size: 6.6 MB rows: 402,768 symbols: 1,638
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-12 04:00:00 | AAPL | Stock | 174.0 | 174.0 | 173.77 | 173.77 | 2507.0 |
| 2023-05-12 04:05:00 | AAPL | Stock | 173.86 | 173.87 | 173.78 | 173.87 | 1159.0 |
| 2023-05-12 04:10:00 | AAPL | Stock | 173.95 | 173.95 | 173.9 | 173.9 | 1107.0 |
| 2023-05-12 04:15:00 | AAPL | Stock | 173.95 | 174.0 | 173.95 | 174.0 | 1835.0 |
| 2023-05-12 04:20:00 | AAPL | Stock | 174.0 | 174.05 | 174.0 | 174.05 | 1629.0 |
| 2023-05-12 04:25:00 | AAPL | Stock | 174.05 | 174.05 | 174.0 | 174.0 | 549.0 |
| 2023-05-12 04:35:00 | AAPL | Stock | 173.94 | 173.94 | 173.79 | 173.8 | 2357.0 |
| 2023-05-12 04:45:00 | AAPL | Stock | 173.82 | 173.82 | 173.82 | 173.82 | 153.0 |
| 2023-05-12 04:50:00 | AAPL | Stock | 173.85 | 173.85 | 173.82 | 173.82 | 1085.0 |
| 2023-05-12 04:55:00 | AAPL | Stock | 173.86 | 173.86 | 173.86 | 173.86 | 400.0 |
| 2023-05-12 05:00:00 | AAPL | Stock | 173.86 | 173.86 | 173.86 | 173.86 | 381.0 |
| 2023-05-12 05:05:00 | AAPL | Stock | 173.86 | 173.95 | 173.86 | 173.95 | 830.0 |
| 2023-05-12 05:25:00 | AAPL | Stock | 173.78 | 173.81 | 173.78 | 173.81 | 200.0 |
| 2023-05-12 05:30:00 | AAPL | Stock | 173.81 | 173.81 | 173.8 | 173.81 | 300.0 |
| 2023-05-12 05:35:00 | AAPL | Stock | 173.8 | 173.81 | 173.8 | 173.8 | 1212.0 |
| 2023-05-12 05:40:00 | AAPL | Stock | 173.75 | 173.8 | 173.75 | 173.8 | 720.0 |
| 2023-05-12 05:45:00 | AAPL | Stock | 173.72 | 173.72 | 173.6 | 173.6 | 1357.0 |
| 2023-05-12 05:55:00 | AAPL | Stock | 173.55 | 173.56 | 173.5 | 173.5 | 1366.0 |
| 2023-05-12 06:00:00 | AAPL | Stock | 173.57 | 173.59 | 173.57 | 173.59 | 589.0 |
| 2023-05-12 06:20:00 | AAPL | Stock | 173.58 | 173.58 | 173.58 | 173.58 | 100.0 |
| 2023-05-12 06:25:00 | AAPL | Stock | 173.54 | 173.54 | 173.54 | 173.54 | 500.0 |
| 2023-05-12 06:30:00 | AAPL | Stock | 173.59 | 173.65 | 173.59 | 173.59 | 1751.0 |
| 2023-05-12 06:45:00 | AAPL | Stock | 173.6 | 173.81 | 173.6 | 173.81 | 650.0 |
| 2023-05-12 06:50:00 | AAPL | Stock | 173.69 | 173.69 | 173.69 | 173.69 | 339.0 |
| 2023-05-12 07:00:00 | AAPL | Stock | 173.83 | 173.87 | 173.8 | 173.8 | 7078.0 |
| 2023-05-12 07:05:00 | AAPL | Stock | 173.82 | 173.82 | 173.76 | 173.78 | 5096.0 |
| 2023-05-12 07:10:00 | AAPL | Stock | 173.72 | 173.73 | 173.72 | 173.73 | 400.0 |
| 2023-05-12 07:15:00 | AAPL | Stock | 173.77 | 173.77 | 173.71 | 173.71 | 1772.0 |
| 2023-05-12 07:25:00 | AAPL | Stock | 173.7 | 173.76 | 173.7 | 173.76 | 925.0 |
| 2023-05-12 07:30:00 | AAPL | Stock | 173.7 | 173.7 | 173.7 | 173.7 | 494.0 |
| 2023-05-12 07:35:00 | AAPL | Stock | 173.68 | 173.7 | 173.68 | 173.7 | 610.0 |
| 2023-05-12 07:40:00 | AAPL | Stock | 173.69 | 173.73 | 173.69 | 173.7 | 1906.0 |
| 2023-05-12 07:45:00 | AAPL | Stock | 173.69 | 173.7 | 173.65 | 173.65 | 4400.0 |
| 2023-05-12 07:55:00 | AAPL | Stock | 173.67 | 173.68 | 173.55 | 173.6 | 5726.0 |
| 2023-05-12 08:00:00 | AAPL | Stock | 173.74 | 173.85 | 173.38 | 173.59 | 23968.0 |
| 2023-05-12 08:05:00 | AAPL | Stock | 173.54 | 173.63 | 173.51 | 173.63 | 8262.0 |
| 2023-05-12 08:10:00 | AAPL | Stock | 173.5899 | 173.5899 | 173.52 | 173.52 | 2556.0 |
| 2023-05-12 08:15:00 | AAPL | Stock | 173.56 | 173.56 | 173.5 | 173.51 | 4158.0 |
| 2023-05-12 08:20:00 | AAPL | Stock | 173.4701 | 173.5 | 173.45 | 173.45 | 3465.0 |
| 2023-05-12 08:25:00 | AAPL | Stock | 173.5 | 173.5 | 173.4 | 173.4 | 4008.0 |
| 2023-05-12 08:30:00 | AAPL | Stock | 173.38 | 173.49 | 173.34 | 173.49 | 12490.0 |
| 2023-05-12 08:35:00 | AAPL | Stock | 173.51 | 173.57 | 173.5 | 173.5698 | 3630.0 |
| 2023-05-12 08:40:00 | AAPL | Stock | 173.55 | 173.68 | 173.55 | 173.68 | 11240.0 |
| 2023-05-12 08:45:00 | AAPL | Stock | 173.67 | 173.67 | 173.5357 | 173.62 | 5584.0 |
| 2023-05-12 08:50:00 | AAPL | Stock | 173.62 | 173.64 | 173.59 | 173.59 | 7138.0 |
| 2023-05-12 08:55:00 | AAPL | Stock | 173.5501 | 173.59 | 173.5 | 173.5 | 14854.0 |
| 2023-05-12 09:00:00 | AAPL | Stock | 173.47 | 173.56 | 173.45 | 173.55 | 8568.0 |
| 2023-05-12 09:05:00 | AAPL | Stock | 173.56 | 173.66 | 173.55 | 173.64 | 14756.0 |
| 2023-05-12 09:10:00 | AAPL | Stock | 173.64 | 173.75 | 173.56 | 173.68 | 34066.0 |
| 2023-05-12 09:15:00 | AAPL | Stock | 173.68 | 173.75 | 173.66 | 173.75 | 22378.0 |
> showing 50 of 402,768 rows — these rows as CSV