PREVIEW / etf_30min / 2002-07-01
file: by_date/etf_30min/2002/2002-07-01.parquet size: 18 KB rows: 503
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-01 09:30:00 | SPY | ETF | 99.18 | 99.8 | 99.09 | 99.48 | 1788200.0 |
| 2002-07-01 10:00:00 | SPY | ETF | 99.47 | 99.77 | 98.8 | 99.0 | 1659500.0 |
| 2002-07-01 10:30:00 | SPY | ETF | 99.02 | 99.36 | 98.89 | 99.09 | 732900.0 |
| 2002-07-01 11:00:00 | SPY | ETF | 99.12 | 99.15 | 98.55 | 98.74 | 1244100.0 |
| 2002-07-01 11:30:00 | SPY | ETF | 98.73 | 98.88 | 98.52 | 98.56 | 688100.0 |
| 2002-07-01 12:00:00 | SPY | ETF | 98.55 | 98.58 | 98.17 | 98.35 | 1600800.0 |
| 2002-07-01 12:30:00 | SPY | ETF | 98.3 | 98.65 | 98.23 | 98.37 | 652900.0 |
| 2002-07-01 13:00:00 | SPY | ETF | 98.37 | 98.67 | 98.05 | 98.58 | 973800.0 |
| 2002-07-01 13:30:00 | SPY | ETF | 98.6 | 98.8 | 98.4 | 98.62 | 930700.0 |
| 2002-07-01 14:00:00 | SPY | ETF | 98.66 | 98.79 | 98.33 | 98.34 | 744300.0 |
| 2002-07-01 14:30:00 | SPY | ETF | 98.33 | 98.42 | 97.95 | 98.04 | 1916000.0 |
| 2002-07-01 15:00:00 | SPY | ETF | 98.01 | 98.07 | 97.56 | 97.57 | 1632200.0 |
| 2002-07-01 15:30:00 | SPY | ETF | 97.6 | 97.63 | 96.95 | 97.0 | 3318100.0 |
| 2002-07-01 16:00:00 | SPY | ETF | 97.06 | 97.14 | 96.85 | 97.14 | 1744600.0 |
| 2002-07-01 16:30:00 | SPY | ETF | 97.08 | 97.24 | 97.0 | 97.2 | 122000.0 |
| 2002-07-01 17:00:00 | SPY | ETF | 97.15 | 97.15 | 96.8 | 97.12 | 26300.0 |
| 2002-07-01 17:30:00 | SPY | ETF | 97.14 | 97.23 | 97.14 | 97.17 | 4500.0 |
| 2002-07-01 18:00:00 | SPY | ETF | 97.19 | 97.19 | 97.15 | 97.19 | 1600.0 |
| 2002-07-01 09:30:00 | QQQ | ETF | 25.97 | 26.14 | 25.83 | 26.01 | 9392000.0 |
| 2002-07-01 10:00:00 | QQQ | ETF | 26.03 | 26.1 | 25.73 | 25.83 | 7515100.0 |
| 2002-07-01 10:30:00 | QQQ | ETF | 25.82 | 25.9 | 25.65 | 25.75 | 3661500.0 |
| 2002-07-01 11:00:00 | QQQ | ETF | 25.76 | 25.8 | 25.44 | 25.59 | 4901800.0 |
| 2002-07-01 11:30:00 | QQQ | ETF | 25.59 | 25.65 | 25.4 | 25.42 | 3659000.0 |
| 2002-07-01 12:00:00 | QQQ | ETF | 25.41 | 25.46 | 25.32 | 25.39 | 3784200.0 |
| 2002-07-01 12:30:00 | QQQ | ETF | 25.38 | 25.51 | 25.33 | 25.44 | 3171500.0 |
| 2002-07-01 13:00:00 | QQQ | ETF | 25.42 | 25.6 | 25.3 | 25.58 | 3497600.0 |
| 2002-07-01 13:30:00 | QQQ | ETF | 25.56 | 25.58 | 25.37 | 25.47 | 2252200.0 |
| 2002-07-01 14:00:00 | QQQ | ETF | 25.47 | 25.56 | 25.36 | 25.36 | 2196300.0 |
| 2002-07-01 14:30:00 | QQQ | ETF | 25.4 | 25.4 | 25.17 | 25.18 | 5000900.0 |
| 2002-07-01 15:00:00 | QQQ | ETF | 25.18 | 25.2 | 24.91 | 24.96 | 4623300.0 |
| 2002-07-01 15:30:00 | QQQ | ETF | 24.93 | 25.03 | 24.81 | 24.86 | 7347100.0 |
| 2002-07-01 16:00:00 | QQQ | ETF | 24.84 | 26.75 | 24.75 | 24.8 | 2460400.0 |
| 2002-07-01 16:30:00 | QQQ | ETF | 24.8 | 24.88 | 24.8 | 24.85 | 78900.0 |
| 2002-07-01 17:00:00 | QQQ | ETF | 24.85 | 24.86 | 24.8 | 24.83 | 49800.0 |
| 2002-07-01 17:30:00 | QQQ | ETF | 24.85 | 24.87 | 24.8 | 24.83 | 22200.0 |
| 2002-07-01 18:00:00 | QQQ | ETF | 24.82 | 24.84 | 24.8 | 24.83 | 20900.0 |
| 2002-07-01 09:30:00 | IWM | ETF | 45.45 | 45.8 | 45.35 | 45.53 | 133200.0 |
| 2002-07-01 10:00:00 | IWM | ETF | 45.53 | 45.625 | 45.175 | 45.2 | 192200.0 |
| 2002-07-01 10:30:00 | IWM | ETF | 45.19 | 45.5 | 45.19 | 45.39 | 192000.0 |
| 2002-07-01 11:00:00 | IWM | ETF | 45.345 | 45.35 | 45.055 | 45.185 | 83600.0 |
| 2002-07-01 11:30:00 | IWM | ETF | 45.14 | 45.185 | 45.055 | 45.08 | 97000.0 |
| 2002-07-01 12:00:00 | IWM | ETF | 45.075 | 45.075 | 44.88 | 45.02 | 150800.0 |
| 2002-07-01 12:30:00 | IWM | ETF | 44.95 | 45.14 | 44.93 | 45.105 | 79000.0 |
| 2002-07-01 13:00:00 | IWM | ETF | 45.1 | 45.1 | 44.97 | 45.085 | 124000.0 |
| 2002-07-01 13:30:00 | IWM | ETF | 45.125 | 45.14 | 45.045 | 45.075 | 110400.0 |
| 2002-07-01 14:00:00 | IWM | ETF | 45.035 | 45.095 | 44.97 | 44.97 | 33800.0 |
| 2002-07-01 14:30:00 | IWM | ETF | 44.95 | 44.965 | 44.795 | 44.795 | 59800.0 |
| 2002-07-01 15:00:00 | IWM | ETF | 44.805 | 44.805 | 44.575 | 44.575 | 133200.0 |
| 2002-07-01 15:30:00 | IWM | ETF | 44.555 | 44.6 | 44.35 | 44.395 | 286200.0 |
| 2002-07-01 16:00:00 | IWM | ETF | 44.415 | 44.65 | 44.3 | 44.4 | 40200.0 |
> showing 50 of 503 rows — these rows as CSV