PREVIEW / stock_5min / 2024-10-28
file: by_date/stock_5min/2024/2024-10-28.parquet size: 6.9 MB rows: 412,455 symbols: 741
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-10-28 04:00:00 | AAPL | Stock | 232.91 | 232.91 | 232.52 | 232.65 | 3744.0 |
| 2024-10-28 04:05:00 | AAPL | Stock | 232.66 | 232.66 | 232.35 | 232.35 | 5806.0 |
| 2024-10-28 04:10:00 | AAPL | Stock | 232.37 | 232.55 | 232.36 | 232.55 | 450.0 |
| 2024-10-28 04:15:00 | AAPL | Stock | 232.46 | 232.86 | 232.46 | 232.86 | 4858.0 |
| 2024-10-28 04:20:00 | AAPL | Stock | 232.83 | 232.83 | 232.83 | 232.83 | 369.0 |
| 2024-10-28 04:25:00 | AAPL | Stock | 232.78 | 232.78 | 232.78 | 232.78 | 599.0 |
| 2024-10-28 04:35:00 | AAPL | Stock | 232.82 | 233.06 | 232.82 | 233.06 | 3837.0 |
| 2024-10-28 04:40:00 | AAPL | Stock | 233.09 | 233.09 | 233.01 | 233.01 | 1509.0 |
| 2024-10-28 04:45:00 | AAPL | Stock | 233.01 | 233.05 | 233.01 | 233.04 | 634.0 |
| 2024-10-28 04:50:00 | AAPL | Stock | 233.09 | 233.1 | 233.04 | 233.04 | 599.0 |
| 2024-10-28 05:00:00 | AAPL | Stock | 233.04 | 233.11 | 233.0 | 233.0 | 4730.0 |
| 2024-10-28 05:05:00 | AAPL | Stock | 232.98 | 232.98 | 232.82 | 232.87 | 1492.0 |
| 2024-10-28 05:10:00 | AAPL | Stock | 232.9 | 232.9 | 232.9 | 232.9 | 700.0 |
| 2024-10-28 05:15:00 | AAPL | Stock | 232.9 | 232.9 | 232.88 | 232.9 | 2557.0 |
| 2024-10-28 05:25:00 | AAPL | Stock | 232.9 | 233.09 | 232.87 | 233.09 | 2385.0 |
| 2024-10-28 05:30:00 | AAPL | Stock | 232.98 | 232.98 | 232.98 | 232.98 | 173.0 |
| 2024-10-28 05:35:00 | AAPL | Stock | 233.0 | 233.0 | 233.0 | 233.0 | 800.0 |
| 2024-10-28 05:40:00 | AAPL | Stock | 233.0 | 233.0 | 233.0 | 233.0 | 200.0 |
| 2024-10-28 05:45:00 | AAPL | Stock | 232.95 | 232.95 | 232.95 | 232.95 | 200.0 |
| 2024-10-28 05:50:00 | AAPL | Stock | 232.92 | 232.92 | 232.9 | 232.9 | 1861.0 |
| 2024-10-28 05:55:00 | AAPL | Stock | 232.92 | 232.92 | 232.92 | 232.92 | 200.0 |
| 2024-10-28 06:00:00 | AAPL | Stock | 233.0 | 233.0 | 232.88 | 232.9 | 4544.0 |
| 2024-10-28 06:05:00 | AAPL | Stock | 232.79 | 232.79 | 232.71 | 232.75 | 1615.0 |
| 2024-10-28 06:10:00 | AAPL | Stock | 232.77 | 232.8 | 232.68 | 232.79 | 4278.0 |
| 2024-10-28 06:15:00 | AAPL | Stock | 232.77 | 232.8 | 232.7 | 232.8 | 7890.0 |
| 2024-10-28 06:20:00 | AAPL | Stock | 232.99 | 232.99 | 232.74 | 232.95 | 7591.0 |
| 2024-10-28 06:25:00 | AAPL | Stock | 232.9 | 232.9 | 232.75 | 232.75 | 2501.0 |
| 2024-10-28 06:30:00 | AAPL | Stock | 232.8 | 232.82 | 232.71 | 232.82 | 1515.0 |
| 2024-10-28 06:35:00 | AAPL | Stock | 232.76 | 232.76 | 232.3 | 232.4 | 5836.0 |
| 2024-10-28 06:40:00 | AAPL | Stock | 232.35 | 232.35 | 232.35 | 232.35 | 184.0 |
| 2024-10-28 06:45:00 | AAPL | Stock | 232.39 | 232.48 | 232.39 | 232.48 | 1866.0 |
| 2024-10-28 06:50:00 | AAPL | Stock | 232.47 | 232.48 | 232.41 | 232.46 | 900.0 |
| 2024-10-28 06:55:00 | AAPL | Stock | 232.41 | 232.41 | 232.2 | 232.2 | 2042.0 |
| 2024-10-28 07:00:00 | AAPL | Stock | 232.21 | 232.29 | 232.11 | 232.22 | 3224.0 |
| 2024-10-28 07:05:00 | AAPL | Stock | 232.2 | 232.23 | 231.91 | 232.09 | 9669.0 |
| 2024-10-28 07:10:00 | AAPL | Stock | 232.02 | 232.06 | 231.72 | 231.8 | 8584.0 |
| 2024-10-28 07:15:00 | AAPL | Stock | 231.92 | 231.95 | 231.9 | 231.95 | 2052.0 |
| 2024-10-28 07:20:00 | AAPL | Stock | 231.91 | 232.23 | 231.86 | 232.23 | 2731.0 |
| 2024-10-28 07:25:00 | AAPL | Stock | 232.12 | 232.12 | 232.1 | 232.1 | 350.0 |
| 2024-10-28 07:30:00 | AAPL | Stock | 231.99 | 232.11 | 231.99 | 232.1 | 4276.0 |
| 2024-10-28 07:35:00 | AAPL | Stock | 232.05 | 232.2 | 232.05 | 232.2 | 3746.0 |
| 2024-10-28 07:40:00 | AAPL | Stock | 232.2 | 232.27 | 232.2 | 232.24 | 1919.0 |
| 2024-10-28 07:45:00 | AAPL | Stock | 232.21 | 232.21 | 232.2 | 232.2 | 975.0 |
| 2024-10-28 07:50:00 | AAPL | Stock | 232.28 | 232.35 | 232.25 | 232.25 | 8635.0 |
| 2024-10-28 07:55:00 | AAPL | Stock | 232.3 | 232.37 | 232.3 | 232.37 | 1537.0 |
| 2024-10-28 08:00:00 | AAPL | Stock | 232.14 | 232.99 | 231.8253 | 232.0 | 51285.0 |
| 2024-10-28 08:05:00 | AAPL | Stock | 232.09 | 232.11 | 230.832 | 232.11 | 5145.0 |
| 2024-10-28 08:10:00 | AAPL | Stock | 232.11 | 232.28 | 232.0 | 232.28 | 5770.0 |
| 2024-10-28 08:15:00 | AAPL | Stock | 232.39 | 232.4 | 232.35 | 232.35 | 2379.0 |
| 2024-10-28 08:20:00 | AAPL | Stock | 232.4 | 232.49 | 232.3216 | 232.3216 | 4493.0 |
> showing 50 of 412,455 rows — these rows as CSV