PREVIEW / etf_30min / 2025-10-02
file: by_date/etf_30min/2025/2025-10-02.parquet size: 1.1 MB rows: 44,644
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-02 04:00:00 | SPY | ETF | 669.26 | 670.0 | 669.24 | 669.8 | 21413.0 |
| 2025-10-02 04:30:00 | SPY | ETF | 669.78 | 669.92 | 669.69 | 669.92 | 21332.0 |
| 2025-10-02 05:00:00 | SPY | ETF | 669.89 | 669.96 | 669.61 | 669.61 | 5817.0 |
| 2025-10-02 05:30:00 | SPY | ETF | 669.51 | 669.65 | 669.16 | 669.59 | 9859.0 |
| 2025-10-02 06:00:00 | SPY | ETF | 669.66 | 670.03 | 669.66 | 669.77 | 8446.0 |
| 2025-10-02 06:30:00 | SPY | ETF | 669.78 | 669.95 | 669.71 | 669.73 | 2800.0 |
| 2025-10-02 07:00:00 | SPY | ETF | 669.73 | 670.16 | 669.72 | 670.11 | 78332.0 |
| 2025-10-02 07:30:00 | SPY | ETF | 670.06 | 670.35 | 669.98 | 670.32 | 45065.0 |
| 2025-10-02 08:00:00 | SPY | ETF | 669.93 | 670.62 | 668.97 | 670.41 | 143634.0 |
| 2025-10-02 08:30:00 | SPY | ETF | 670.431 | 670.6 | 670.25 | 670.46 | 108304.0 |
| 2025-10-02 09:00:00 | SPY | ETF | 670.47 | 670.74 | 670.35 | 670.47 | 220232.0 |
| 2025-10-02 09:30:00 | SPY | ETF | 670.47 | 670.565 | 668.75 | 669.42 | 6930781.0 |
| 2025-10-02 10:00:00 | SPY | ETF | 669.41 | 669.5299 | 668.29 | 668.7113 | 3466076.0 |
| 2025-10-02 10:30:00 | SPY | ETF | 668.72 | 669.02 | 667.54 | 667.565 | 2929503.0 |
| 2025-10-02 11:00:00 | SPY | ETF | 667.57 | 668.12 | 667.02 | 667.67 | 2863059.0 |
| 2025-10-02 11:30:00 | SPY | ETF | 667.6488 | 668.42 | 666.78 | 668.35 | 2105385.0 |
| 2025-10-02 12:00:00 | SPY | ETF | 668.35 | 668.35 | 667.61 | 668.1389 | 1557421.0 |
| 2025-10-02 12:30:00 | SPY | ETF | 668.13 | 668.59 | 667.55 | 668.42 | 1461332.0 |
| 2025-10-02 13:00:00 | SPY | ETF | 668.415 | 668.71 | 667.94 | 668.5099 | 1510307.0 |
| 2025-10-02 13:30:00 | SPY | ETF | 668.51 | 669.08 | 668.3319 | 668.895 | 1996693.0 |
| 2025-10-02 14:00:00 | SPY | ETF | 668.89 | 669.67 | 668.85 | 669.58 | 2111383.0 |
| 2025-10-02 14:30:00 | SPY | ETF | 669.58 | 669.73 | 669.2202 | 669.39 | 1831403.0 |
| 2025-10-02 15:00:00 | SPY | ETF | 669.38 | 669.63 | 669.22 | 669.475 | 1905105.0 |
| 2025-10-02 15:30:00 | SPY | ETF | 669.48 | 669.49 | 668.82 | 669.17 | 7669013.0 |
| 2025-10-02 16:00:00 | SPY | ETF | 669.15 | 669.4 | 668.95 | 669.06 | 2701267.0 |
| 2025-10-02 16:30:00 | SPY | ETF | 669.07 | 669.12 | 668.9 | 669.04 | 204321.0 |
| 2025-10-02 17:00:00 | SPY | ETF | 669.04 | 669.08 | 668.97 | 669.0 | 12031.0 |
| 2025-10-02 17:30:00 | SPY | ETF | 669.02 | 669.22 | 669.01 | 669.0409 | 22280.0 |
| 2025-10-02 18:00:00 | SPY | ETF | 669.05 | 669.14 | 668.85 | 668.85 | 24383.0 |
| 2025-10-02 18:30:00 | SPY | ETF | 668.77 | 669.07 | 668.5 | 669.07 | 14973.0 |
| 2025-10-02 19:00:00 | SPY | ETF | 669.06 | 669.31 | 668.95 | 669.31 | 11018.0 |
| 2025-10-02 19:30:00 | SPY | ETF | 669.28 | 669.5 | 669.26 | 669.45 | 20662.0 |
| 2025-10-02 04:00:00 | QQQ | ETF | 604.95 | 605.76 | 604.17 | 605.71 | 54614.0 |
| 2025-10-02 04:30:00 | QQQ | ETF | 605.72 | 605.78 | 605.49 | 605.78 | 67259.0 |
| 2025-10-02 05:00:00 | QQQ | ETF | 605.79 | 605.87 | 605.39 | 605.39 | 52358.0 |
| 2025-10-02 05:30:00 | QQQ | ETF | 605.34 | 605.45 | 604.96 | 605.37 | 65608.0 |
| 2025-10-02 06:00:00 | QQQ | ETF | 605.35 | 606.02 | 605.32 | 605.63 | 50048.0 |
| 2025-10-02 06:30:00 | QQQ | ETF | 605.66 | 605.9 | 605.61 | 605.73 | 28378.0 |
| 2025-10-02 07:00:00 | QQQ | ETF | 605.74 | 606.31 | 605.68 | 606.3 | 36643.0 |
| 2025-10-02 07:30:00 | QQQ | ETF | 606.27 | 606.7 | 606.21 | 606.66 | 41281.0 |
| 2025-10-02 08:00:00 | QQQ | ETF | 605.8 | 606.99 | 603.702 | 606.82 | 213483.0 |
| 2025-10-02 08:30:00 | QQQ | ETF | 606.81 | 607.0 | 606.67 | 606.96 | 130121.0 |
| 2025-10-02 09:00:00 | QQQ | ETF | 606.98 | 607.39 | 606.96 | 607.04 | 281725.0 |
| 2025-10-02 09:30:00 | QQQ | ETF | 607.06 | 607.16 | 603.44 | 604.645 | 4780342.0 |
| 2025-10-02 10:00:00 | QQQ | ETF | 604.63 | 605.31 | 604.1 | 604.92 | 2720108.0 |
| 2025-10-02 10:30:00 | QQQ | ETF | 604.95 | 605.28 | 603.54 | 603.5905 | 2133542.0 |
| 2025-10-02 11:00:00 | QQQ | ETF | 603.59 | 604.39 | 602.93 | 604.12 | 2203871.0 |
| 2025-10-02 11:30:00 | QQQ | ETF | 604.09 | 605.085 | 603.14 | 604.97 | 1730857.0 |
| 2025-10-02 12:00:00 | QQQ | ETF | 604.96 | 604.97 | 604.12 | 604.59 | 1169472.0 |
| 2025-10-02 12:30:00 | QQQ | ETF | 604.58 | 605.03 | 603.97 | 604.97 | 1273273.0 |
> showing 50 of 44,644 rows — these rows as CSV