PREVIEW / stock_5min / 2024-01-19
file: by_date/stock_5min/2024/2024-01-19.parquet size: 6.6 MB rows: 395,007 symbols: 1,169
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-19 04:00:00 | AAPL | Stock | 188.89 | 189.79 | 188.89 | 189.55 | 8399.0 |
| 2024-01-19 04:05:00 | AAPL | Stock | 189.55 | 189.55 | 189.16 | 189.39 | 5190.0 |
| 2024-01-19 04:10:00 | AAPL | Stock | 189.43 | 189.49 | 189.43 | 189.49 | 2047.0 |
| 2024-01-19 04:15:00 | AAPL | Stock | 189.55 | 189.55 | 189.55 | 189.55 | 427.0 |
| 2024-01-19 04:20:00 | AAPL | Stock | 189.66 | 189.95 | 189.66 | 189.95 | 5356.0 |
| 2024-01-19 04:25:00 | AAPL | Stock | 189.8 | 189.8 | 189.68 | 189.68 | 4461.0 |
| 2024-01-19 04:30:00 | AAPL | Stock | 189.67 | 189.67 | 189.32 | 189.43 | 1693.0 |
| 2024-01-19 04:35:00 | AAPL | Stock | 189.41 | 189.46 | 189.32 | 189.32 | 4642.0 |
| 2024-01-19 04:40:00 | AAPL | Stock | 189.27 | 189.27 | 189.0 | 189.07 | 1318.0 |
| 2024-01-19 04:45:00 | AAPL | Stock | 189.1 | 189.13 | 189.08 | 189.08 | 901.0 |
| 2024-01-19 04:50:00 | AAPL | Stock | 189.1 | 189.47 | 189.1 | 189.47 | 2652.0 |
| 2024-01-19 04:55:00 | AAPL | Stock | 189.3 | 189.45 | 189.3 | 189.45 | 1440.0 |
| 2024-01-19 05:00:00 | AAPL | Stock | 189.47 | 189.47 | 189.37 | 189.38 | 1967.0 |
| 2024-01-19 05:05:00 | AAPL | Stock | 189.42 | 189.42 | 189.27 | 189.27 | 3195.0 |
| 2024-01-19 05:10:00 | AAPL | Stock | 189.3 | 189.35 | 189.3 | 189.32 | 1058.0 |
| 2024-01-19 05:15:00 | AAPL | Stock | 189.3 | 189.3 | 189.21 | 189.21 | 2188.0 |
| 2024-01-19 05:20:00 | AAPL | Stock | 189.33 | 189.33 | 189.33 | 189.33 | 200.0 |
| 2024-01-19 05:25:00 | AAPL | Stock | 189.3 | 189.3 | 189.3 | 189.3 | 100.0 |
| 2024-01-19 05:35:00 | AAPL | Stock | 189.37 | 189.4 | 189.3 | 189.4 | 1688.0 |
| 2024-01-19 05:40:00 | AAPL | Stock | 189.41 | 189.5 | 189.41 | 189.5 | 2522.0 |
| 2024-01-19 05:45:00 | AAPL | Stock | 189.54 | 189.64 | 189.54 | 189.59 | 2706.0 |
| 2024-01-19 05:50:00 | AAPL | Stock | 189.59 | 189.73 | 189.59 | 189.7 | 2773.0 |
| 2024-01-19 05:55:00 | AAPL | Stock | 189.7 | 189.79 | 189.66 | 189.66 | 8236.0 |
| 2024-01-19 06:00:00 | AAPL | Stock | 189.6 | 189.95 | 189.55 | 189.95 | 18503.0 |
| 2024-01-19 06:05:00 | AAPL | Stock | 189.94 | 189.99 | 189.85 | 189.85 | 5228.0 |
| 2024-01-19 06:10:00 | AAPL | Stock | 189.78 | 189.93 | 189.78 | 189.93 | 2371.0 |
| 2024-01-19 06:15:00 | AAPL | Stock | 189.88 | 189.92 | 189.8 | 189.92 | 2239.0 |
| 2024-01-19 06:20:00 | AAPL | Stock | 189.92 | 189.93 | 189.92 | 189.93 | 865.0 |
| 2024-01-19 06:25:00 | AAPL | Stock | 189.94 | 189.95 | 189.93 | 189.93 | 2117.0 |
| 2024-01-19 06:30:00 | AAPL | Stock | 189.9 | 190.35 | 189.9 | 190.21 | 47750.0 |
| 2024-01-19 06:35:00 | AAPL | Stock | 190.29 | 190.49 | 190.29 | 190.49 | 13521.0 |
| 2024-01-19 06:40:00 | AAPL | Stock | 190.5 | 190.58 | 190.38 | 190.38 | 7295.0 |
| 2024-01-19 06:45:00 | AAPL | Stock | 190.4 | 190.4 | 190.35 | 190.36 | 360.0 |
| 2024-01-19 06:50:00 | AAPL | Stock | 190.3 | 190.3 | 190.2 | 190.2 | 2381.0 |
| 2024-01-19 06:55:00 | AAPL | Stock | 190.2 | 190.25 | 190.15 | 190.25 | 2397.0 |
| 2024-01-19 07:00:00 | AAPL | Stock | 190.16 | 190.2 | 190.02 | 190.1 | 15985.0 |
| 2024-01-19 07:05:00 | AAPL | Stock | 190.03 | 190.15 | 190.01 | 190.04 | 6437.0 |
| 2024-01-19 07:10:00 | AAPL | Stock | 190.04 | 190.04 | 189.82 | 189.94 | 13145.0 |
| 2024-01-19 07:15:00 | AAPL | Stock | 189.87 | 189.92 | 189.85 | 189.9 | 6366.0 |
| 2024-01-19 07:20:00 | AAPL | Stock | 189.87 | 189.88 | 189.7 | 189.83 | 8209.0 |
| 2024-01-19 07:25:00 | AAPL | Stock | 189.83 | 189.95 | 189.76 | 189.8 | 9817.0 |
| 2024-01-19 07:30:00 | AAPL | Stock | 189.81 | 189.83 | 189.75 | 189.79 | 7098.0 |
| 2024-01-19 07:35:00 | AAPL | Stock | 189.78 | 189.89 | 189.76 | 189.76 | 3761.0 |
| 2024-01-19 07:40:00 | AAPL | Stock | 189.8 | 189.8 | 189.55 | 189.6 | 6371.0 |
| 2024-01-19 07:45:00 | AAPL | Stock | 189.58 | 189.68 | 189.58 | 189.68 | 817.0 |
| 2024-01-19 07:50:00 | AAPL | Stock | 189.72 | 189.79 | 189.72 | 189.78 | 4555.0 |
| 2024-01-19 07:55:00 | AAPL | Stock | 189.76 | 189.86 | 189.75 | 189.84 | 3878.0 |
| 2024-01-19 08:00:00 | AAPL | Stock | 190.0 | 190.2 | 189.17 | 189.2 | 79202.0 |
| 2024-01-19 08:05:00 | AAPL | Stock | 189.8599 | 189.88 | 189.78 | 189.88 | 10971.0 |
| 2024-01-19 08:10:00 | AAPL | Stock | 189.88 | 189.99 | 189.8 | 189.93 | 17307.0 |
> showing 50 of 395,007 rows — these rows as CSV