PREVIEW / stock_5min / 2024-11-12
file: by_date/stock_5min/2024/2024-11-12.parquet size: 7.3 MB rows: 437,302 symbols: 727
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-11-12 04:00:00 | AAPL | Stock | 223.2 | 223.61 | 223.2 | 223.4 | 1784.0 |
| 2024-11-12 04:05:00 | AAPL | Stock | 223.32 | 223.32 | 223.06 | 223.06 | 1957.0 |
| 2024-11-12 04:10:00 | AAPL | Stock | 223.07 | 223.37 | 223.07 | 223.37 | 2039.0 |
| 2024-11-12 04:15:00 | AAPL | Stock | 223.18 | 223.29 | 223.18 | 223.29 | 687.0 |
| 2024-11-12 04:20:00 | AAPL | Stock | 223.27 | 223.45 | 223.27 | 223.43 | 2618.0 |
| 2024-11-12 04:25:00 | AAPL | Stock | 223.35 | 223.43 | 223.34 | 223.4 | 2661.0 |
| 2024-11-12 04:30:00 | AAPL | Stock | 223.38 | 223.57 | 223.36 | 223.57 | 874.0 |
| 2024-11-12 04:35:00 | AAPL | Stock | 223.56 | 223.56 | 223.56 | 223.56 | 100.0 |
| 2024-11-12 04:40:00 | AAPL | Stock | 223.47 | 223.75 | 223.47 | 223.75 | 1218.0 |
| 2024-11-12 04:50:00 | AAPL | Stock | 223.6 | 223.6 | 223.48 | 223.6 | 1092.0 |
| 2024-11-12 04:55:00 | AAPL | Stock | 223.45 | 223.56 | 223.01 | 223.2 | 3178.0 |
| 2024-11-12 05:00:00 | AAPL | Stock | 223.28 | 223.66 | 223.28 | 223.58 | 1887.0 |
| 2024-11-12 05:05:00 | AAPL | Stock | 223.47 | 223.74 | 223.42 | 223.58 | 7464.0 |
| 2024-11-12 05:10:00 | AAPL | Stock | 223.69 | 223.76 | 223.59 | 223.61 | 2122.0 |
| 2024-11-12 05:20:00 | AAPL | Stock | 223.88 | 223.93 | 223.82 | 223.82 | 1961.0 |
| 2024-11-12 05:25:00 | AAPL | Stock | 223.85 | 223.86 | 223.57 | 223.65 | 2416.0 |
| 2024-11-12 05:30:00 | AAPL | Stock | 223.65 | 223.81 | 223.65 | 223.81 | 306.0 |
| 2024-11-12 05:35:00 | AAPL | Stock | 223.82 | 223.83 | 223.69 | 223.7 | 1616.0 |
| 2024-11-12 05:40:00 | AAPL | Stock | 223.79 | 223.8 | 223.68 | 223.68 | 757.0 |
| 2024-11-12 05:45:00 | AAPL | Stock | 223.8 | 223.96 | 223.8 | 223.91 | 762.0 |
| 2024-11-12 05:50:00 | AAPL | Stock | 223.96 | 224.0 | 223.9 | 223.92 | 801.0 |
| 2024-11-12 05:55:00 | AAPL | Stock | 223.94 | 223.97 | 223.94 | 223.97 | 200.0 |
| 2024-11-12 06:00:00 | AAPL | Stock | 223.99 | 224.02 | 223.99 | 224.02 | 1600.0 |
| 2024-11-12 06:05:00 | AAPL | Stock | 224.02 | 224.04 | 224.02 | 224.04 | 200.0 |
| 2024-11-12 06:10:00 | AAPL | Stock | 223.99 | 224.01 | 223.97 | 224.01 | 774.0 |
| 2024-11-12 06:20:00 | AAPL | Stock | 223.82 | 223.82 | 223.82 | 223.82 | 425.0 |
| 2024-11-12 06:25:00 | AAPL | Stock | 223.9 | 223.9 | 223.9 | 223.9 | 147.0 |
| 2024-11-12 06:35:00 | AAPL | Stock | 223.75 | 223.75 | 223.75 | 223.75 | 700.0 |
| 2024-11-12 06:40:00 | AAPL | Stock | 223.72 | 223.72 | 223.72 | 223.72 | 117.0 |
| 2024-11-12 06:45:00 | AAPL | Stock | 223.63 | 223.7 | 223.61 | 223.7 | 684.0 |
| 2024-11-12 06:50:00 | AAPL | Stock | 223.91 | 223.91 | 223.91 | 223.91 | 3121.0 |
| 2024-11-12 06:55:00 | AAPL | Stock | 223.87 | 224.19 | 223.87 | 224.19 | 2162.0 |
| 2024-11-12 07:00:00 | AAPL | Stock | 224.19 | 224.19 | 223.89 | 223.95 | 4102.0 |
| 2024-11-12 07:05:00 | AAPL | Stock | 223.87 | 224.24 | 223.86 | 224.23 | 4289.0 |
| 2024-11-12 07:10:00 | AAPL | Stock | 224.21 | 224.25 | 224.21 | 224.25 | 7188.0 |
| 2024-11-12 07:15:00 | AAPL | Stock | 224.23 | 224.26 | 224.04 | 224.04 | 2322.0 |
| 2024-11-12 07:20:00 | AAPL | Stock | 224.06 | 224.06 | 224.06 | 224.06 | 200.0 |
| 2024-11-12 07:25:00 | AAPL | Stock | 224.02 | 224.06 | 223.9 | 224.06 | 850.0 |
| 2024-11-12 07:30:00 | AAPL | Stock | 224.06 | 224.12 | 224.06 | 224.12 | 300.0 |
| 2024-11-12 07:35:00 | AAPL | Stock | 224.16 | 224.23 | 224.16 | 224.23 | 1847.0 |
| 2024-11-12 07:40:00 | AAPL | Stock | 224.25 | 224.35 | 224.23 | 224.35 | 1554.0 |
| 2024-11-12 07:45:00 | AAPL | Stock | 224.39 | 224.5 | 224.38 | 224.46 | 4889.0 |
| 2024-11-12 07:50:00 | AAPL | Stock | 224.5 | 224.5 | 224.4 | 224.4 | 2513.0 |
| 2024-11-12 07:55:00 | AAPL | Stock | 224.27 | 224.27 | 224.23 | 224.23 | 600.0 |
| 2024-11-12 08:00:00 | AAPL | Stock | 224.25 | 224.54 | 223.45 | 224.09 | 34745.0 |
| 2024-11-12 08:05:00 | AAPL | Stock | 224.0881 | 224.1 | 223.89 | 223.9699 | 2991.0 |
| 2024-11-12 08:10:00 | AAPL | Stock | 223.9 | 223.99 | 223.8501 | 223.89 | 4815.0 |
| 2024-11-12 08:15:00 | AAPL | Stock | 223.99 | 223.99 | 223.85 | 223.98 | 1546.0 |
| 2024-11-12 08:20:00 | AAPL | Stock | 223.99 | 224.06 | 223.95 | 224.06 | 4158.0 |
| 2024-11-12 08:25:00 | AAPL | Stock | 224.0 | 224.07 | 224.0 | 224.07 | 1168.0 |
> showing 50 of 437,302 rows — these rows as CSV