PREVIEW / etf_30min / 2025-10-16
file: by_date/etf_30min/2025/2025-10-16.parquet size: 1.1 MB rows: 45,905
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-16 04:00:00 | SPY | ETF | 666.89 | 667.35 | 666.42 | 666.42 | 46607.0 |
| 2025-10-16 04:30:00 | SPY | ETF | 666.46 | 666.83 | 666.35 | 666.61 | 16138.0 |
| 2025-10-16 05:00:00 | SPY | ETF | 666.65 | 667.09 | 666.65 | 667.03 | 10448.0 |
| 2025-10-16 05:30:00 | SPY | ETF | 667.04 | 667.36 | 666.55 | 667.31 | 20141.0 |
| 2025-10-16 06:00:00 | SPY | ETF | 667.36 | 667.89 | 667.29 | 667.87 | 13854.0 |
| 2025-10-16 06:30:00 | SPY | ETF | 667.84 | 667.99 | 667.46 | 667.59 | 77783.0 |
| 2025-10-16 07:00:00 | SPY | ETF | 667.55 | 668.12 | 667.53 | 668.05 | 154229.0 |
| 2025-10-16 07:30:00 | SPY | ETF | 668.06 | 668.17 | 667.52 | 667.66 | 64946.0 |
| 2025-10-16 08:00:00 | SPY | ETF | 667.62 | 668.1 | 664.8 | 667.32 | 139536.0 |
| 2025-10-16 08:30:00 | SPY | ETF | 667.48 | 668.32 | 667.13 | 667.85 | 292474.0 |
| 2025-10-16 09:00:00 | SPY | ETF | 667.9 | 668.03 | 666.8 | 666.84 | 193341.0 |
| 2025-10-16 09:30:00 | SPY | ETF | 666.82 | 668.08 | 666.11 | 666.635 | 6185849.0 |
| 2025-10-16 10:00:00 | SPY | ETF | 666.635 | 667.57 | 665.42 | 666.93 | 5052412.0 |
| 2025-10-16 10:30:00 | SPY | ETF | 666.95 | 668.71 | 666.79 | 667.09 | 3837207.0 |
| 2025-10-16 11:00:00 | SPY | ETF | 667.09 | 668.04 | 665.47 | 665.815 | 3251049.0 |
| 2025-10-16 11:30:00 | SPY | ETF | 665.81 | 666.78 | 663.93 | 664.52 | 5001986.0 |
| 2025-10-16 12:00:00 | SPY | ETF | 664.51 | 665.15 | 662.29 | 662.47 | 4091198.0 |
| 2025-10-16 12:30:00 | SPY | ETF | 662.48 | 663.5 | 659.33 | 663.37 | 7874266.0 |
| 2025-10-16 13:00:00 | SPY | ETF | 663.37 | 664.26 | 661.34 | 663.502 | 5145374.0 |
| 2025-10-16 13:30:00 | SPY | ETF | 663.49 | 664.0 | 661.12 | 661.81 | 3390274.0 |
| 2025-10-16 14:00:00 | SPY | ETF | 661.81 | 661.9495 | 657.45 | 658.385 | 6307357.0 |
| 2025-10-16 14:30:00 | SPY | ETF | 658.39 | 660.69 | 657.11 | 660.523 | 4918231.0 |
| 2025-10-16 15:00:00 | SPY | ETF | 660.51 | 660.9298 | 657.99 | 658.91 | 4482698.0 |
| 2025-10-16 15:30:00 | SPY | ETF | 658.92 | 661.25 | 658.14 | 660.65 | 10457290.0 |
| 2025-10-16 16:00:00 | SPY | ETF | 660.67 | 661.15 | 658.92 | 659.42 | 3273541.0 |
| 2025-10-16 16:30:00 | SPY | ETF | 659.46 | 660.03 | 659.13 | 659.73 | 112387.0 |
| 2025-10-16 17:00:00 | SPY | ETF | 659.71 | 659.74 | 659.06 | 659.5 | 48792.0 |
| 2025-10-16 17:30:00 | SPY | ETF | 659.4004 | 660.15 | 659.39 | 659.5 | 59418.0 |
| 2025-10-16 18:00:00 | SPY | ETF | 659.45 | 660.6704 | 659.42 | 659.85 | 74254.0 |
| 2025-10-16 18:30:00 | SPY | ETF | 659.87 | 660.04 | 658.31 | 658.3299 | 48498.0 |
| 2025-10-16 19:00:00 | SPY | ETF | 658.27 | 658.98 | 658.08 | 658.26 | 28443.0 |
| 2025-10-16 19:30:00 | SPY | ETF | 658.14 | 658.96 | 658.07 | 658.96 | 41405.0 |
| 2025-10-16 04:00:00 | QQQ | ETF | 605.0 | 605.42 | 604.34 | 604.38 | 91790.0 |
| 2025-10-16 04:30:00 | QQQ | ETF | 604.4 | 604.82 | 604.17 | 604.51 | 42388.0 |
| 2025-10-16 05:00:00 | QQQ | ETF | 604.62 | 605.0 | 604.38 | 604.97 | 35976.0 |
| 2025-10-16 05:30:00 | QQQ | ETF | 604.93 | 605.14 | 604.2 | 605.05 | 60740.0 |
| 2025-10-16 06:00:00 | QQQ | ETF | 605.07 | 605.7 | 605.0 | 605.64 | 74779.0 |
| 2025-10-16 06:30:00 | QQQ | ETF | 605.62 | 605.74 | 605.07 | 605.33 | 108163.0 |
| 2025-10-16 07:00:00 | QQQ | ETF | 605.32 | 606.05 | 605.15 | 605.96 | 72383.0 |
| 2025-10-16 07:30:00 | QQQ | ETF | 605.96 | 605.97 | 605.45 | 605.63 | 45836.0 |
| 2025-10-16 08:00:00 | QQQ | ETF | 605.57 | 606.049 | 601.769 | 605.14 | 381302.0 |
| 2025-10-16 08:30:00 | QQQ | ETF | 605.23 | 606.37 | 604.8 | 605.93 | 273074.0 |
| 2025-10-16 09:00:00 | QQQ | ETF | 605.93 | 606.14 | 605.11 | 605.11 | 275273.0 |
| 2025-10-16 09:30:00 | QQQ | ETF | 605.1 | 607.02 | 604.66 | 605.5151 | 3979757.0 |
| 2025-10-16 10:00:00 | QQQ | ETF | 605.52 | 606.74 | 604.36 | 605.96 | 2619380.0 |
| 2025-10-16 10:30:00 | QQQ | ETF | 605.98 | 608.31 | 605.98 | 606.589 | 2546221.0 |
| 2025-10-16 11:00:00 | QQQ | ETF | 606.64 | 607.16 | 604.48 | 604.9462 | 1812412.0 |
| 2025-10-16 11:30:00 | QQQ | ETF | 604.93 | 605.77 | 602.76 | 603.375 | 2770692.0 |
| 2025-10-16 12:00:00 | QQQ | ETF | 603.34 | 603.96 | 600.9 | 601.075 | 2502454.0 |
| 2025-10-16 12:30:00 | QQQ | ETF | 601.07 | 602.46 | 597.64 | 602.33 | 4119845.0 |
> showing 50 of 45,905 rows — these rows as CSV