PREVIEW / etf_30min / 2002-07-25
file: by_date/etf_30min/2002/2002-07-25.parquet size: 20 KB rows: 546
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-25 09:30:00 | SPY | ETF | 84.27 | 84.34 | 83.12 | 84.03 | 7372000.0 |
| 2002-07-25 10:00:00 | SPY | ETF | 84.1 | 85.85 | 83.9 | 85.58 | 11338200.0 |
| 2002-07-25 10:30:00 | SPY | ETF | 85.57 | 85.76 | 84.21 | 84.28 | 5939100.0 |
| 2002-07-25 11:00:00 | SPY | ETF | 84.26 | 85.05 | 84.12 | 84.8 | 3307900.0 |
| 2002-07-25 11:30:00 | SPY | ETF | 84.95 | 85.6 | 84.53 | 85.15 | 3242500.0 |
| 2002-07-25 12:00:00 | SPY | ETF | 85.08 | 85.29 | 84.05 | 84.14 | 4441700.0 |
| 2002-07-25 12:30:00 | SPY | ETF | 84.15 | 84.61 | 83.5 | 84.14 | 7651800.0 |
| 2002-07-25 13:00:00 | SPY | ETF | 84.07 | 84.74 | 83.55 | 83.99 | 3433000.0 |
| 2002-07-25 13:30:00 | SPY | ETF | 83.95 | 84.2 | 83.3 | 83.46 | 2830400.0 |
| 2002-07-25 14:00:00 | SPY | ETF | 83.45 | 83.64 | 82.85 | 83.13 | 4784800.0 |
| 2002-07-25 14:30:00 | SPY | ETF | 83.14 | 83.35 | 81.6 | 83.04 | 11575800.0 |
| 2002-07-25 15:00:00 | SPY | ETF | 83.01 | 84.11 | 82.35 | 84.03 | 7310000.0 |
| 2002-07-25 15:30:00 | SPY | ETF | 84.05 | 85.05 | 84.0 | 84.2 | 7847600.0 |
| 2002-07-25 16:00:00 | SPY | ETF | 84.22 | 84.3 | 83.9 | 84.0 | 2118000.0 |
| 2002-07-25 09:30:00 | QQQ | ETF | 23.25 | 23.28 | 22.98 | 23.22 | 17850100.0 |
| 2002-07-25 10:00:00 | QQQ | ETF | 23.22 | 23.4 | 22.86 | 23.32 | 18416100.0 |
| 2002-07-25 10:30:00 | QQQ | ETF | 23.28 | 23.36 | 22.65 | 22.7 | 11036500.0 |
| 2002-07-25 11:00:00 | QQQ | ETF | 22.72 | 22.82 | 22.52 | 22.73 | 12844400.0 |
| 2002-07-25 11:30:00 | QQQ | ETF | 22.73 | 22.94 | 22.63 | 22.66 | 7673200.0 |
| 2002-07-25 12:00:00 | QQQ | ETF | 22.65 | 22.7 | 22.2 | 22.26 | 9951300.0 |
| 2002-07-25 12:30:00 | QQQ | ETF | 22.27 | 22.56 | 22.13 | 22.4 | 10856200.0 |
| 2002-07-25 13:00:00 | QQQ | ETF | 22.42 | 22.65 | 22.22 | 22.35 | 5659400.0 |
| 2002-07-25 13:30:00 | QQQ | ETF | 22.4 | 22.54 | 22.13 | 22.25 | 5798100.0 |
| 2002-07-25 14:00:00 | QQQ | ETF | 22.24 | 22.32 | 22.01 | 22.11 | 7390000.0 |
| 2002-07-25 14:30:00 | QQQ | ETF | 22.12 | 22.19 | 21.8 | 22.08 | 14282200.0 |
| 2002-07-25 15:00:00 | QQQ | ETF | 22.06 | 22.47 | 21.9 | 22.4 | 9289300.0 |
| 2002-07-25 15:30:00 | QQQ | ETF | 22.42 | 22.76 | 22.23 | 22.23 | 15823400.0 |
| 2002-07-25 16:00:00 | QQQ | ETF | 22.22 | 22.28 | 22.2 | 22.25 | 804200.0 |
| 2002-07-25 09:30:00 | IWM | ETF | 37.0 | 37.875 | 37.0 | 37.875 | 362200.0 |
| 2002-07-25 10:00:00 | IWM | ETF | 37.77 | 38.6 | 37.5 | 38.45 | 660800.0 |
| 2002-07-25 10:30:00 | IWM | ETF | 38.55 | 38.55 | 37.95 | 37.95 | 626600.0 |
| 2002-07-25 11:00:00 | IWM | ETF | 37.92 | 38.0 | 37.75 | 37.93 | 544200.0 |
| 2002-07-25 11:30:00 | IWM | ETF | 37.945 | 38.265 | 37.815 | 38.145 | 350800.0 |
| 2002-07-25 12:00:00 | IWM | ETF | 38.14 | 38.175 | 37.815 | 37.815 | 288200.0 |
| 2002-07-25 12:30:00 | IWM | ETF | 37.815 | 37.87 | 37.56 | 37.785 | 687400.0 |
| 2002-07-25 13:00:00 | IWM | ETF | 37.725 | 37.85 | 37.685 | 37.75 | 74200.0 |
| 2002-07-25 13:30:00 | IWM | ETF | 37.75 | 37.79 | 37.425 | 37.45 | 139200.0 |
| 2002-07-25 14:00:00 | IWM | ETF | 37.45 | 37.49 | 37.175 | 37.19 | 148200.0 |
| 2002-07-25 14:30:00 | IWM | ETF | 37.235 | 37.325 | 36.75 | 37.15 | 497800.0 |
| 2002-07-25 15:00:00 | IWM | ETF | 37.235 | 37.735 | 37.045 | 37.63 | 420400.0 |
| 2002-07-25 15:30:00 | IWM | ETF | 37.62 | 37.95 | 37.35 | 37.8 | 972000.0 |
| 2002-07-25 16:00:00 | IWM | ETF | 37.75 | 37.875 | 37.7 | 37.7 | 226800.0 |
| 2002-07-25 09:30:00 | DIA | ETF | 81.75 | 81.76 | 80.8 | 81.6 | 1595400.0 |
| 2002-07-25 10:00:00 | DIA | ETF | 81.6 | 83.02 | 81.25 | 82.82 | 2683000.0 |
| 2002-07-25 10:30:00 | DIA | ETF | 82.83 | 82.99 | 81.55 | 81.61 | 1340300.0 |
| 2002-07-25 11:00:00 | DIA | ETF | 81.59 | 82.54 | 81.5 | 82.43 | 912500.0 |
| 2002-07-25 11:30:00 | DIA | ETF | 82.45 | 83.2 | 82.05 | 82.85 | 1223100.0 |
| 2002-07-25 12:00:00 | DIA | ETF | 82.86 | 83.02 | 81.7 | 81.9 | 1125700.0 |
| 2002-07-25 12:30:00 | DIA | ETF | 81.9 | 82.35 | 81.33 | 81.9 | 1818200.0 |
| 2002-07-25 13:00:00 | DIA | ETF | 81.85 | 82.53 | 81.26 | 81.6 | 726000.0 |
> showing 50 of 546 rows — these rows as CSV