PREVIEW / etf_30min / 2025-02-14
file: by_date/etf_30min/2025/2025-02-14.parquet size: 945 KB rows: 37,769
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-02-14 04:00:00 | SPY | ETF | 609.97 | 610.36 | 609.91 | 610.25 | 23060.0 |
| 2025-02-14 04:30:00 | SPY | ETF | 610.5 | 610.5 | 609.85 | 609.95 | 5899.0 |
| 2025-02-14 05:00:00 | SPY | ETF | 609.92 | 609.92 | 609.41 | 609.77 | 18906.0 |
| 2025-02-14 05:30:00 | SPY | ETF | 609.71 | 609.71 | 609.26 | 609.35 | 2904.0 |
| 2025-02-14 06:00:00 | SPY | ETF | 609.21 | 609.23 | 608.76 | 608.76 | 21715.0 |
| 2025-02-14 06:30:00 | SPY | ETF | 608.73 | 609.02 | 608.62 | 608.99 | 9571.0 |
| 2025-02-14 07:00:00 | SPY | ETF | 608.96 | 609.3 | 608.94 | 609.12 | 32849.0 |
| 2025-02-14 07:30:00 | SPY | ETF | 609.18 | 609.34 | 609.0 | 609.34 | 23111.0 |
| 2025-02-14 08:00:00 | SPY | ETF | 609.27 | 611.02 | 608.9981 | 609.32 | 93049.0 |
| 2025-02-14 08:30:00 | SPY | ETF | 609.45 | 609.88 | 609.07 | 609.72 | 87730.0 |
| 2025-02-14 09:00:00 | SPY | ETF | 609.75 | 610.25 | 609.65 | 609.93 | 142670.0 |
| 2025-02-14 09:30:00 | SPY | ETF | 609.94 | 610.64 | 609.76 | 610.465 | 2403544.0 |
| 2025-02-14 10:00:00 | SPY | ETF | 610.48 | 610.99 | 610.02 | 610.24 | 1349058.0 |
| 2025-02-14 10:30:00 | SPY | ETF | 610.24 | 610.665 | 609.73 | 610.51 | 885353.0 |
| 2025-02-14 11:00:00 | SPY | ETF | 610.53 | 610.85 | 609.4 | 609.99 | 1199997.0 |
| 2025-02-14 11:30:00 | SPY | ETF | 610.01 | 610.295 | 609.5 | 610.23 | 813590.0 |
| 2025-02-14 12:00:00 | SPY | ETF | 610.22 | 610.245 | 609.27 | 609.3202 | 723850.0 |
| 2025-02-14 12:30:00 | SPY | ETF | 609.35 | 610.04 | 609.07 | 609.92 | 617877.0 |
| 2025-02-14 13:00:00 | SPY | ETF | 609.92 | 610.09 | 609.7 | 609.9298 | 378195.0 |
| 2025-02-14 13:30:00 | SPY | ETF | 609.93 | 610.7506 | 609.88 | 610.48 | 619008.0 |
| 2025-02-14 14:00:00 | SPY | ETF | 610.49 | 610.72 | 610.06 | 610.13 | 910387.0 |
| 2025-02-14 14:30:00 | SPY | ETF | 610.15 | 610.3024 | 609.83 | 610.22 | 697912.0 |
| 2025-02-14 15:00:00 | SPY | ETF | 610.21 | 610.2448 | 609.59 | 609.67 | 832405.0 |
| 2025-02-14 15:30:00 | SPY | ETF | 609.66 | 610.29 | 609.545 | 609.7 | 4378489.0 |
| 2025-02-14 16:00:00 | SPY | ETF | 609.69 | 610.0901 | 609.42 | 609.77 | 1824000.0 |
| 2025-02-14 16:30:00 | SPY | ETF | 609.77 | 610.06 | 609.49 | 609.98 | 151824.0 |
| 2025-02-14 17:00:00 | SPY | ETF | 609.93 | 609.95 | 609.76 | 609.76 | 14557.0 |
| 2025-02-14 17:30:00 | SPY | ETF | 609.76 | 609.88 | 609.7 | 609.87 | 8706.0 |
| 2025-02-14 18:00:00 | SPY | ETF | 609.78 | 609.8 | 609.48 | 609.5 | 26474.0 |
| 2025-02-14 18:30:00 | SPY | ETF | 609.7 | 609.7 | 609.52 | 609.55 | 2502.0 |
| 2025-02-14 19:00:00 | SPY | ETF | 609.55 | 609.6688 | 609.55 | 609.6 | 901.0 |
| 2025-02-14 19:30:00 | SPY | ETF | 609.61 | 609.83 | 609.61 | 609.78 | 19971.0 |
| 2025-02-14 04:00:00 | QQQ | ETF | 536.27 | 536.98 | 536.1 | 536.74 | 41482.0 |
| 2025-02-14 04:30:00 | QQQ | ETF | 536.73 | 537.0 | 536.37 | 536.53 | 21212.0 |
| 2025-02-14 05:00:00 | QQQ | ETF | 536.5 | 536.53 | 536.05 | 536.29 | 22300.0 |
| 2025-02-14 05:30:00 | QQQ | ETF | 536.34 | 536.4 | 535.81 | 536.09 | 15976.0 |
| 2025-02-14 06:00:00 | QQQ | ETF | 536.01 | 536.01 | 534.85 | 534.91 | 37198.0 |
| 2025-02-14 06:30:00 | QQQ | ETF | 534.98 | 535.27 | 534.53 | 535.02 | 48846.0 |
| 2025-02-14 07:00:00 | QQQ | ETF | 535.04 | 535.57 | 534.89 | 535.34 | 34946.0 |
| 2025-02-14 07:30:00 | QQQ | ETF | 535.36 | 535.55 | 535.12 | 535.54 | 17663.0 |
| 2025-02-14 08:00:00 | QQQ | ETF | 535.2 | 537.36 | 534.91 | 535.4 | 80856.0 |
| 2025-02-14 08:30:00 | QQQ | ETF | 535.76 | 536.25 | 535.22 | 536.05 | 83447.0 |
| 2025-02-14 09:00:00 | QQQ | ETF | 536.04 | 536.38 | 535.75 | 536.08 | 83720.0 |
| 2025-02-14 09:30:00 | QQQ | ETF | 536.08 | 536.89 | 535.67 | 536.53 | 1465597.0 |
| 2025-02-14 10:00:00 | QQQ | ETF | 536.54 | 537.34 | 535.85 | 536.82 | 1292220.0 |
| 2025-02-14 10:30:00 | QQQ | ETF | 536.83 | 537.6 | 535.94 | 537.44 | 862620.0 |
| 2025-02-14 11:00:00 | QQQ | ETF | 537.45 | 537.58 | 535.99 | 536.8543 | 882920.0 |
| 2025-02-14 11:30:00 | QQQ | ETF | 536.9 | 536.9149 | 536.15 | 536.84 | 455160.0 |
| 2025-02-14 12:00:00 | QQQ | ETF | 536.82 | 536.928 | 535.89 | 535.91 | 385134.0 |
| 2025-02-14 12:30:00 | QQQ | ETF | 535.9573 | 537.38 | 535.71 | 537.265 | 636453.0 |
> showing 50 of 37,769 rows — these rows as CSV