PREVIEW / etf_30min / 2025-10-15
file: by_date/etf_30min/2025/2025-10-15.parquet size: 1.1 MB rows: 44,825
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-15 04:00:00 | SPY | ETF | 665.09 | 665.75 | 665.09 | 665.45 | 44876.0 |
| 2025-10-15 04:30:00 | SPY | ETF | 665.55 | 665.55 | 665.12 | 665.4 | 12627.0 |
| 2025-10-15 05:00:00 | SPY | ETF | 665.4 | 666.74 | 665.37 | 665.9 | 28272.0 |
| 2025-10-15 05:30:00 | SPY | ETF | 665.88 | 666.55 | 665.87 | 666.44 | 15202.0 |
| 2025-10-15 06:00:00 | SPY | ETF | 666.51 | 666.51 | 666.07 | 666.23 | 26256.0 |
| 2025-10-15 06:30:00 | SPY | ETF | 666.25 | 666.79 | 666.01 | 666.52 | 28949.0 |
| 2025-10-15 07:00:00 | SPY | ETF | 666.51 | 666.7 | 666.18 | 666.38 | 71196.0 |
| 2025-10-15 07:30:00 | SPY | ETF | 666.32 | 666.72 | 666.1 | 666.6 | 175559.0 |
| 2025-10-15 08:00:00 | SPY | ETF | 666.46 | 667.7 | 663.75 | 667.05 | 256969.0 |
| 2025-10-15 08:30:00 | SPY | ETF | 667.1 | 667.58 | 666.8 | 667.49 | 208883.0 |
| 2025-10-15 09:00:00 | SPY | ETF | 667.49 | 667.49 | 666.7003 | 666.82 | 221602.0 |
| 2025-10-15 09:30:00 | SPY | ETF | 666.82 | 668.58 | 666.05 | 668.31 | 7943850.0 |
| 2025-10-15 10:00:00 | SPY | ETF | 668.34 | 670.23 | 668.31 | 669.61 | 3681009.0 |
| 2025-10-15 10:30:00 | SPY | ETF | 669.63 | 669.895 | 668.63 | 669.02 | 2074813.0 |
| 2025-10-15 11:00:00 | SPY | ETF | 669.03 | 669.17 | 667.65 | 667.71 | 2047400.0 |
| 2025-10-15 11:30:00 | SPY | ETF | 667.69 | 667.84 | 663.915 | 665.2 | 4393234.0 |
| 2025-10-15 12:00:00 | SPY | ETF | 665.22 | 666.4582 | 664.91 | 665.59 | 2772499.0 |
| 2025-10-15 12:30:00 | SPY | ETF | 665.58 | 665.76 | 663.93 | 664.0957 | 1778356.0 |
| 2025-10-15 13:00:00 | SPY | ETF | 664.09 | 664.11 | 658.93 | 660.86 | 7314588.0 |
| 2025-10-15 13:30:00 | SPY | ETF | 660.89 | 664.51 | 660.7 | 664.31 | 2941080.0 |
| 2025-10-15 14:00:00 | SPY | ETF | 664.32 | 664.91 | 663.45 | 664.311 | 2236857.0 |
| 2025-10-15 14:30:00 | SPY | ETF | 664.32 | 665.8365 | 664.19 | 665.725 | 1964586.0 |
| 2025-10-15 15:00:00 | SPY | ETF | 665.725 | 665.825 | 664.61 | 665.36 | 2492494.0 |
| 2025-10-15 15:30:00 | SPY | ETF | 665.37 | 665.46 | 663.25 | 665.08 | 10122494.0 |
| 2025-10-15 16:00:00 | SPY | ETF | 665.09 | 666.03 | 664.8 | 665.0 | 2511905.0 |
| 2025-10-15 16:30:00 | SPY | ETF | 664.99 | 665.26 | 664.58 | 665.03 | 402891.0 |
| 2025-10-15 17:00:00 | SPY | ETF | 664.97 | 665.09 | 664.95 | 665.08 | 30986.0 |
| 2025-10-15 17:30:00 | SPY | ETF | 665.02 | 665.15 | 664.88 | 665.14 | 64739.0 |
| 2025-10-15 18:00:00 | SPY | ETF | 665.15 | 666.19 | 665.15 | 665.8 | 65203.0 |
| 2025-10-15 18:30:00 | SPY | ETF | 665.89 | 665.9587 | 665.21 | 665.85 | 25494.0 |
| 2025-10-15 19:00:00 | SPY | ETF | 665.859 | 665.859 | 665.0 | 665.0 | 14445.0 |
| 2025-10-15 19:30:00 | SPY | ETF | 665.1 | 665.19 | 664.74 | 665.111 | 22446.0 |
| 2025-10-15 04:00:00 | QQQ | ETF | 601.5 | 602.42 | 600.67 | 602.11 | 66032.0 |
| 2025-10-15 04:30:00 | QQQ | ETF | 602.21 | 602.32 | 601.79 | 602.29 | 40180.0 |
| 2025-10-15 05:00:00 | QQQ | ETF | 602.28 | 603.75 | 602.22 | 602.76 | 104076.0 |
| 2025-10-15 05:30:00 | QQQ | ETF | 602.7 | 603.45 | 602.68 | 603.31 | 54848.0 |
| 2025-10-15 06:00:00 | QQQ | ETF | 603.34 | 603.4 | 602.86 | 603.18 | 46783.0 |
| 2025-10-15 06:30:00 | QQQ | ETF | 603.18 | 603.51 | 602.77 | 603.23 | 56856.0 |
| 2025-10-15 07:00:00 | QQQ | ETF | 603.15 | 603.26 | 602.57 | 602.76 | 118257.0 |
| 2025-10-15 07:30:00 | QQQ | ETF | 602.69 | 603.26 | 602.54 | 603.05 | 115951.0 |
| 2025-10-15 08:00:00 | QQQ | ETF | 603.06 | 604.54 | 597.552 | 603.82 | 450688.0 |
| 2025-10-15 08:30:00 | QQQ | ETF | 604.09 | 604.67 | 603.6 | 604.49 | 310872.0 |
| 2025-10-15 09:00:00 | QQQ | ETF | 604.51 | 604.51 | 603.85 | 604.01 | 321187.0 |
| 2025-10-15 09:30:00 | QQQ | ETF | 604.01 | 604.52 | 601.51 | 604.29 | 4648714.0 |
| 2025-10-15 10:00:00 | QQQ | ETF | 604.33 | 606.67 | 604.28 | 606.39 | 3580577.0 |
| 2025-10-15 10:30:00 | QQQ | ETF | 606.4 | 606.7 | 605.75 | 606.34 | 1917707.0 |
| 2025-10-15 11:00:00 | QQQ | ETF | 606.39 | 606.5999 | 605.1 | 605.2156 | 1515651.0 |
| 2025-10-15 11:30:00 | QQQ | ETF | 605.22 | 605.38 | 601.025 | 602.43 | 3233757.0 |
| 2025-10-15 12:00:00 | QQQ | ETF | 602.43 | 603.8 | 602.18 | 603.0284 | 1845162.0 |
| 2025-10-15 12:30:00 | QQQ | ETF | 603.01 | 603.21 | 601.42 | 601.6413 | 1260053.0 |
> showing 50 of 44,825 rows — these rows as CSV