PREVIEW / etf_30min / 2025-03-11
file: by_date/etf_30min/2025/2025-03-11.parquet size: 999 KB rows: 41,520
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-03-11 04:00:00 | SPY | ETF | 561.79 | 562.78 | 561.31 | 562.7 | 45293.0 |
| 2025-03-11 04:30:00 | SPY | ETF | 562.56 | 562.85 | 562.13 | 562.81 | 21138.0 |
| 2025-03-11 05:00:00 | SPY | ETF | 562.78 | 563.11 | 562.28 | 562.91 | 53809.0 |
| 2025-03-11 05:30:00 | SPY | ETF | 562.7 | 562.87 | 562.2 | 562.53 | 32385.0 |
| 2025-03-11 06:00:00 | SPY | ETF | 562.59 | 562.89 | 561.7 | 562.78 | 66402.0 |
| 2025-03-11 06:30:00 | SPY | ETF | 562.81 | 562.86 | 562.22 | 562.4 | 44960.0 |
| 2025-03-11 07:00:00 | SPY | ETF | 562.37 | 562.57 | 561.2 | 562.47 | 95959.0 |
| 2025-03-11 07:30:00 | SPY | ETF | 562.4 | 563.75 | 562.4 | 563.58 | 148365.0 |
| 2025-03-11 08:00:00 | SPY | ETF | 562.32 | 563.6 | 560.1 | 561.8 | 377593.0 |
| 2025-03-11 08:30:00 | SPY | ETF | 561.81 | 561.81 | 560.11 | 560.5 | 270424.0 |
| 2025-03-11 09:00:00 | SPY | ETF | 560.37 | 561.051 | 559.2 | 559.39 | 367902.0 |
| 2025-03-11 09:30:00 | SPY | ETF | 559.4 | 561.74 | 558.3 | 559.79 | 5243408.0 |
| 2025-03-11 10:00:00 | SPY | ETF | 559.75 | 562.12 | 555.65 | 555.9858 | 6287053.0 |
| 2025-03-11 10:30:00 | SPY | ETF | 555.95 | 557.24 | 554.05 | 554.77 | 4273696.0 |
| 2025-03-11 11:00:00 | SPY | ETF | 554.74 | 558.86 | 554.17 | 557.17 | 3998027.0 |
| 2025-03-11 11:30:00 | SPY | ETF | 557.1 | 559.98 | 556.86 | 557.17 | 2514639.0 |
| 2025-03-11 12:00:00 | SPY | ETF | 557.15 | 557.65 | 554.75 | 555.81 | 2440838.0 |
| 2025-03-11 12:30:00 | SPY | ETF | 555.85 | 556.93 | 553.57 | 554.32 | 2471435.0 |
| 2025-03-11 13:00:00 | SPY | ETF | 554.3199 | 554.355 | 552.04 | 552.2 | 2461497.0 |
| 2025-03-11 13:30:00 | SPY | ETF | 552.16 | 555.39 | 552.02 | 554.28 | 3344413.0 |
| 2025-03-11 14:00:00 | SPY | ETF | 554.26 | 559.32 | 554.14 | 558.44 | 4007270.0 |
| 2025-03-11 14:30:00 | SPY | ETF | 558.41 | 562.87 | 557.34 | 561.546 | 5395346.0 |
| 2025-03-11 15:00:00 | SPY | ETF | 561.55 | 564.02 | 558.61 | 559.57 | 4605737.0 |
| 2025-03-11 15:30:00 | SPY | ETF | 559.5815 | 560.32 | 556.01 | 556.12 | 8364600.0 |
| 2025-03-11 16:00:00 | SPY | ETF | 556.1198 | 557.45 | 555.82 | 556.39 | 4891927.0 |
| 2025-03-11 16:30:00 | SPY | ETF | 556.41 | 556.6 | 555.8 | 556.27 | 403943.0 |
| 2025-03-11 17:00:00 | SPY | ETF | 556.22 | 556.53 | 556.0945 | 556.21 | 58602.0 |
| 2025-03-11 17:30:00 | SPY | ETF | 556.19 | 556.47 | 556.15 | 556.36 | 244025.0 |
| 2025-03-11 18:00:00 | SPY | ETF | 556.36 | 557.2304 | 556.08 | 556.96 | 76894.0 |
| 2025-03-11 18:30:00 | SPY | ETF | 556.93 | 558.0 | 556.69 | 557.78 | 30438.0 |
| 2025-03-11 19:00:00 | SPY | ETF | 557.6 | 557.72 | 557.0819 | 557.12 | 65018.0 |
| 2025-03-11 19:30:00 | SPY | ETF | 557.2 | 557.87 | 556.8 | 557.8 | 45173.0 |
| 2025-03-11 04:00:00 | QQQ | ETF | 474.48 | 475.89 | 473.48 | 475.87 | 164431.0 |
| 2025-03-11 04:30:00 | QQQ | ETF | 475.87 | 475.87 | 474.99 | 475.85 | 54219.0 |
| 2025-03-11 05:00:00 | QQQ | ETF | 475.86 | 476.23 | 475.08 | 475.81 | 109598.0 |
| 2025-03-11 05:30:00 | QQQ | ETF | 475.7 | 475.8 | 475.14 | 475.35 | 40896.0 |
| 2025-03-11 06:00:00 | QQQ | ETF | 475.29 | 475.71 | 474.49 | 475.71 | 62197.0 |
| 2025-03-11 06:30:00 | QQQ | ETF | 475.62 | 475.68 | 474.62 | 475.18 | 39148.0 |
| 2025-03-11 07:00:00 | QQQ | ETF | 475.05 | 475.15 | 473.59 | 474.84 | 144651.0 |
| 2025-03-11 07:30:00 | QQQ | ETF | 474.82 | 476.12 | 474.82 | 476.09 | 105993.0 |
| 2025-03-11 08:00:00 | QQQ | ETF | 476.04 | 476.2 | 472.0 | 474.2399 | 370327.0 |
| 2025-03-11 08:30:00 | QQQ | ETF | 474.13 | 474.17 | 472.8 | 473.1098 | 376269.0 |
| 2025-03-11 09:00:00 | QQQ | ETF | 473.11 | 473.84 | 472.15 | 472.24 | 228192.0 |
| 2025-03-11 09:30:00 | QQQ | ETF | 472.35 | 476.69 | 471.4915 | 474.82 | 5624585.0 |
| 2025-03-11 10:00:00 | QQQ | ETF | 474.79 | 477.08 | 469.75 | 469.94 | 5649254.0 |
| 2025-03-11 10:30:00 | QQQ | ETF | 469.94 | 472.25 | 468.54 | 469.73 | 3995482.0 |
| 2025-03-11 11:00:00 | QQQ | ETF | 469.63 | 474.44 | 469.06 | 472.5746 | 3536945.0 |
| 2025-03-11 11:30:00 | QQQ | ETF | 472.53 | 475.35 | 472.15 | 472.4 | 2777377.0 |
| 2025-03-11 12:00:00 | QQQ | ETF | 472.37 | 472.97 | 470.25 | 471.46 | 2576992.0 |
| 2025-03-11 12:30:00 | QQQ | ETF | 471.61 | 472.65 | 469.31 | 469.96 | 1647413.0 |
> showing 50 of 41,520 rows — these rows as CSV