PREVIEW / stock_5min / 2024-11-06
file: by_date/stock_5min/2024/2024-11-06.parquet size: 7.6 MB rows: 456,727 symbols: 717
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-06 04:00:00 | AAPL | Stock | 226.9 | 226.9 | 224.66 | 224.85 | 14900.0 |
| 2024-11-06 04:05:00 | AAPL | Stock | 224.8 | 224.97 | 224.04 | 224.04 | 5327.0 |
| 2024-11-06 04:10:00 | AAPL | Stock | 224.08 | 224.58 | 224.08 | 224.4 | 5451.0 |
| 2024-11-06 04:15:00 | AAPL | Stock | 224.31 | 224.34 | 224.12 | 224.2 | 3549.0 |
| 2024-11-06 04:20:00 | AAPL | Stock | 224.22 | 224.88 | 224.22 | 224.76 | 5342.0 |
| 2024-11-06 04:25:00 | AAPL | Stock | 224.6 | 224.84 | 224.5 | 224.83 | 1196.0 |
| 2024-11-06 04:30:00 | AAPL | Stock | 224.9 | 225.08 | 224.79 | 224.82 | 3187.0 |
| 2024-11-06 04:35:00 | AAPL | Stock | 224.82 | 224.82 | 224.26 | 224.26 | 4859.0 |
| 2024-11-06 04:40:00 | AAPL | Stock | 224.39 | 224.5 | 224.39 | 224.5 | 1407.0 |
| 2024-11-06 04:45:00 | AAPL | Stock | 224.41 | 224.41 | 223.66 | 223.78 | 9872.0 |
| 2024-11-06 04:50:00 | AAPL | Stock | 223.8 | 224.0 | 223.78 | 224.0 | 3427.0 |
| 2024-11-06 04:55:00 | AAPL | Stock | 224.2 | 224.51 | 224.06 | 224.49 | 9129.0 |
| 2024-11-06 05:00:00 | AAPL | Stock | 224.31 | 224.31 | 224.12 | 224.2 | 1638.0 |
| 2024-11-06 05:05:00 | AAPL | Stock | 224.2 | 224.2 | 224.0 | 224.0 | 1527.0 |
| 2024-11-06 05:10:00 | AAPL | Stock | 223.8 | 224.0 | 223.71 | 223.71 | 4997.0 |
| 2024-11-06 05:15:00 | AAPL | Stock | 223.75 | 223.96 | 223.75 | 223.96 | 3576.0 |
| 2024-11-06 05:20:00 | AAPL | Stock | 223.93 | 223.95 | 223.8 | 223.8 | 1478.0 |
| 2024-11-06 05:25:00 | AAPL | Stock | 223.81 | 224.04 | 223.79 | 223.9 | 9315.0 |
| 2024-11-06 05:30:00 | AAPL | Stock | 223.9 | 224.04 | 223.8 | 224.04 | 6102.0 |
| 2024-11-06 05:35:00 | AAPL | Stock | 224.06 | 224.1 | 223.85 | 223.85 | 1486.0 |
| 2024-11-06 05:40:00 | AAPL | Stock | 223.86 | 223.86 | 223.51 | 223.71 | 8665.0 |
| 2024-11-06 05:45:00 | AAPL | Stock | 223.75 | 223.91 | 223.5 | 223.7 | 5778.0 |
| 2024-11-06 05:50:00 | AAPL | Stock | 223.81 | 223.9 | 223.6 | 223.6 | 10504.0 |
| 2024-11-06 05:55:00 | AAPL | Stock | 223.51 | 223.72 | 223.31 | 223.31 | 14638.0 |
| 2024-11-06 06:00:00 | AAPL | Stock | 223.49 | 223.49 | 223.0 | 223.29 | 15080.0 |
| 2024-11-06 06:05:00 | AAPL | Stock | 223.31 | 223.32 | 223.15 | 223.15 | 3630.0 |
| 2024-11-06 06:10:00 | AAPL | Stock | 223.2 | 223.2 | 223.18 | 223.18 | 200.0 |
| 2024-11-06 06:15:00 | AAPL | Stock | 223.29 | 223.4 | 223.26 | 223.26 | 1369.0 |
| 2024-11-06 06:20:00 | AAPL | Stock | 223.36 | 223.4 | 223.25 | 223.4 | 1640.0 |
| 2024-11-06 06:25:00 | AAPL | Stock | 223.32 | 223.5 | 223.32 | 223.42 | 2018.0 |
| 2024-11-06 06:30:00 | AAPL | Stock | 223.42 | 223.56 | 223.42 | 223.56 | 2008.0 |
| 2024-11-06 06:35:00 | AAPL | Stock | 223.6 | 223.6 | 223.55 | 223.55 | 4396.0 |
| 2024-11-06 06:40:00 | AAPL | Stock | 223.47 | 223.53 | 223.27 | 223.38 | 9338.0 |
| 2024-11-06 06:45:00 | AAPL | Stock | 223.33 | 223.45 | 223.27 | 223.32 | 2332.0 |
| 2024-11-06 06:50:00 | AAPL | Stock | 223.26 | 223.26 | 222.51 | 222.74 | 10147.0 |
| 2024-11-06 06:55:00 | AAPL | Stock | 223.03 | 223.08 | 222.41 | 223.0 | 23681.0 |
| 2024-11-06 07:00:00 | AAPL | Stock | 223.0 | 223.6 | 223.0 | 223.19 | 17542.0 |
| 2024-11-06 07:05:00 | AAPL | Stock | 223.2 | 223.99 | 223.16 | 223.88 | 22221.0 |
| 2024-11-06 07:10:00 | AAPL | Stock | 223.98 | 224.1 | 223.66 | 223.67 | 14356.0 |
| 2024-11-06 07:15:00 | AAPL | Stock | 223.61 | 224.22 | 223.61 | 224.16 | 30116.0 |
| 2024-11-06 07:20:00 | AAPL | Stock | 224.13 | 224.17 | 223.5 | 223.95 | 22759.0 |
| 2024-11-06 07:25:00 | AAPL | Stock | 224.0 | 224.18 | 223.9 | 224.18 | 4261.0 |
| 2024-11-06 07:30:00 | AAPL | Stock | 224.18 | 224.6 | 224.18 | 224.57 | 20408.0 |
| 2024-11-06 07:35:00 | AAPL | Stock | 224.57 | 224.57 | 224.26 | 224.4 | 6698.0 |
| 2024-11-06 07:40:00 | AAPL | Stock | 224.4 | 224.48 | 224.22 | 224.48 | 8375.0 |
| 2024-11-06 07:45:00 | AAPL | Stock | 224.51 | 224.58 | 224.3 | 224.55 | 10692.0 |
| 2024-11-06 07:50:00 | AAPL | Stock | 224.55 | 224.55 | 224.2 | 224.2 | 5230.0 |
| 2024-11-06 07:55:00 | AAPL | Stock | 224.25 | 224.25 | 224.0 | 224.0 | 13719.0 |
| 2024-11-06 08:00:00 | AAPL | Stock | 224.05 | 228.78 | 223.1 | 224.04 | 151060.0 |
| 2024-11-06 08:05:00 | AAPL | Stock | 224.05 | 224.21 | 224.04 | 224.2001 | 23002.0 |
> showing 50 of 456,727 rows — these rows as CSV