PREVIEW / etf_30min / 2025-10-06
file: by_date/etf_30min/2025/2025-10-06.parquet size: 1.1 MB rows: 45,837
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 |
|---|---|---|---|---|---|---|---|
| 2025-10-06 04:00:00 | SPY | ETF | 670.66 | 671.24 | 669.72 | 670.94 | 30424.0 |
| 2025-10-06 04:30:00 | SPY | ETF | 671.06 | 671.09 | 670.83 | 671.09 | 4845.0 |
| 2025-10-06 05:00:00 | SPY | ETF | 671.04 | 671.38 | 670.98 | 671.38 | 5937.0 |
| 2025-10-06 05:30:00 | SPY | ETF | 671.38 | 671.65 | 671.3 | 671.6 | 15868.0 |
| 2025-10-06 06:00:00 | SPY | ETF | 671.65 | 671.72 | 671.42 | 671.63 | 10771.0 |
| 2025-10-06 06:30:00 | SPY | ETF | 671.68 | 672.57 | 671.67 | 671.74 | 43802.0 |
| 2025-10-06 07:00:00 | SPY | ETF | 671.7 | 671.72 | 671.03 | 671.24 | 27451.0 |
| 2025-10-06 07:30:00 | SPY | ETF | 671.26 | 671.56 | 670.95 | 671.55 | 163390.0 |
| 2025-10-06 08:00:00 | SPY | ETF | 671.57 | 672.14 | 670.15 | 671.72 | 224708.0 |
| 2025-10-06 08:30:00 | SPY | ETF | 671.72 | 671.72 | 671.05 | 671.0681 | 120649.0 |
| 2025-10-06 09:00:00 | SPY | ETF | 671.02 | 671.8 | 670.94 | 671.68 | 118675.0 |
| 2025-10-06 09:30:00 | SPY | ETF | 671.63 | 671.65 | 669.89 | 670.015 | 7187407.0 |
| 2025-10-06 10:00:00 | SPY | ETF | 670.01 | 670.7099 | 669.455 | 670.515 | 4187182.0 |
| 2025-10-06 10:30:00 | SPY | ETF | 670.515 | 670.855 | 670.145 | 670.76 | 2380330.0 |
| 2025-10-06 11:00:00 | SPY | ETF | 670.77 | 671.375 | 670.7101 | 671.15 | 2028487.0 |
| 2025-10-06 11:30:00 | SPY | ETF | 671.15 | 671.925 | 671.045 | 671.81 | 2232804.0 |
| 2025-10-06 12:00:00 | SPY | ETF | 671.8 | 671.885 | 671.2917 | 671.8207 | 1577995.0 |
| 2025-10-06 12:30:00 | SPY | ETF | 671.83 | 671.845 | 671.36 | 671.72 | 1295840.0 |
| 2025-10-06 13:00:00 | SPY | ETF | 671.715 | 672.32 | 671.33 | 672.06 | 1947160.0 |
| 2025-10-06 13:30:00 | SPY | ETF | 672.08 | 672.35 | 671.79 | 672.27 | 1890087.0 |
| 2025-10-06 14:00:00 | SPY | ETF | 672.27 | 672.47 | 672.04 | 672.24 | 2098491.0 |
| 2025-10-06 14:30:00 | SPY | ETF | 672.2484 | 672.51 | 672.0001 | 672.11 | 1835397.0 |
| 2025-10-06 15:00:00 | SPY | ETF | 672.1101 | 672.15 | 671.65 | 671.755 | 2152448.0 |
| 2025-10-06 15:30:00 | SPY | ETF | 671.75 | 672.09 | 671.54 | 671.59 | 6374504.0 |
| 2025-10-06 16:00:00 | SPY | ETF | 671.59 | 671.77 | 671.4 | 671.73 | 1745165.0 |
| 2025-10-06 16:30:00 | SPY | ETF | 671.72 | 671.86 | 671.72 | 671.78 | 84053.0 |
| 2025-10-06 17:00:00 | SPY | ETF | 671.85 | 671.85 | 671.64 | 671.84 | 14562.0 |
| 2025-10-06 17:30:00 | SPY | ETF | 671.73 | 671.85 | 671.66 | 671.7 | 14153.0 |
| 2025-10-06 18:00:00 | SPY | ETF | 671.7 | 671.99 | 671.7 | 671.75 | 25813.0 |
| 2025-10-06 18:30:00 | SPY | ETF | 671.76 | 671.76 | 670.54 | 670.6499 | 43600.0 |
| 2025-10-06 19:00:00 | SPY | ETF | 670.64 | 670.9 | 670.4874 | 670.84 | 32695.0 |
| 2025-10-06 19:30:00 | SPY | ETF | 670.73 | 670.91 | 670.6198 | 670.68 | 25362.0 |
| 2025-10-06 04:00:00 | QQQ | ETF | 604.5 | 606.1 | 604.5 | 605.75 | 50708.0 |
| 2025-10-06 04:30:00 | QQQ | ETF | 605.78 | 605.96 | 605.61 | 605.91 | 23112.0 |
| 2025-10-06 05:00:00 | QQQ | ETF | 605.91 | 606.42 | 605.85 | 606.39 | 43530.0 |
| 2025-10-06 05:30:00 | QQQ | ETF | 606.36 | 606.67 | 606.23 | 606.57 | 26788.0 |
| 2025-10-06 06:00:00 | QQQ | ETF | 606.52 | 606.75 | 606.33 | 606.57 | 28337.0 |
| 2025-10-06 06:30:00 | QQQ | ETF | 606.65 | 607.74 | 606.63 | 607.43 | 63526.0 |
| 2025-10-06 07:00:00 | QQQ | ETF | 607.44 | 607.44 | 606.4 | 606.97 | 90844.0 |
| 2025-10-06 07:30:00 | QQQ | ETF | 606.981 | 607.75 | 606.86 | 607.73 | 83477.0 |
| 2025-10-06 08:00:00 | QQQ | ETF | 607.1 | 609.06 | 604.44 | 608.36 | 299897.0 |
| 2025-10-06 08:30:00 | QQQ | ETF | 608.42 | 608.42 | 607.79 | 607.88 | 136615.0 |
| 2025-10-06 09:00:00 | QQQ | ETF | 607.84 | 608.5 | 607.58 | 608.42 | 195569.0 |
| 2025-10-06 09:30:00 | QQQ | ETF | 608.43 | 608.6103 | 606.09 | 607.03 | 5002269.0 |
| 2025-10-06 10:00:00 | QQQ | ETF | 607.03 | 607.73 | 606.555 | 606.745 | 2413961.0 |
| 2025-10-06 10:30:00 | QQQ | ETF | 606.74 | 607.095 | 605.97 | 606.9793 | 1973115.0 |
| 2025-10-06 11:00:00 | QQQ | ETF | 606.97 | 607.56 | 606.76 | 607.1986 | 1250972.0 |
| 2025-10-06 11:30:00 | QQQ | ETF | 607.2 | 608.495 | 607.1344 | 608.305 | 1731315.0 |
| 2025-10-06 12:00:00 | QQQ | ETF | 608.3 | 608.385 | 607.7099 | 608.185 | 1433388.0 |
| 2025-10-06 12:30:00 | QQQ | ETF | 608.2 | 608.23 | 607.83 | 608.18 | 905111.0 |
> showing 50 of 45,837 rows — these rows as CSV