PREVIEW / etf_30min / 2002-06-10
file: by_date/etf_30min/2002/2002-06-10.parquet size: 18 KB rows: 477
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-06-10 09:30:00 | SPY | ETF | 103.24 | 103.5 | 103.1 | 103.36 | 2082000.0 |
| 2002-06-10 10:00:00 | SPY | ETF | 103.3 | 104.05 | 103.14 | 103.66 | 2985400.0 |
| 2002-06-10 10:30:00 | SPY | ETF | 103.62 | 103.71 | 103.02 | 103.71 | 3558600.0 |
| 2002-06-10 11:00:00 | SPY | ETF | 103.71 | 103.73 | 103.4 | 103.41 | 370000.0 |
| 2002-06-10 11:30:00 | SPY | ETF | 103.4 | 103.68 | 103.26 | 103.55 | 473000.0 |
| 2002-06-10 12:00:00 | SPY | ETF | 103.59 | 103.98 | 103.44 | 103.94 | 536200.0 |
| 2002-06-10 12:30:00 | SPY | ETF | 103.88 | 104.24 | 103.85 | 104.2 | 749600.0 |
| 2002-06-10 13:00:00 | SPY | ETF | 104.2 | 104.24 | 103.97 | 104.09 | 766200.0 |
| 2002-06-10 13:30:00 | SPY | ETF | 104.09 | 104.13 | 103.78 | 103.88 | 458900.0 |
| 2002-06-10 14:00:00 | SPY | ETF | 103.88 | 104.24 | 103.78 | 104.24 | 715100.0 |
| 2002-06-10 14:30:00 | SPY | ETF | 104.17 | 104.4 | 104.0 | 104.4 | 661400.0 |
| 2002-06-10 15:00:00 | SPY | ETF | 104.4 | 104.46 | 103.95 | 104.04 | 1881100.0 |
| 2002-06-10 15:30:00 | SPY | ETF | 104.05 | 104.06 | 103.42 | 103.56 | 1971000.0 |
| 2002-06-10 16:00:00 | SPY | ETF | 103.56 | 103.75 | 103.34 | 103.67 | 941600.0 |
| 2002-06-10 16:30:00 | SPY | ETF | 103.73 | 103.8 | 103.73 | 103.73 | 900.0 |
| 2002-06-10 17:00:00 | SPY | ETF | 103.73 | 103.73 | 103.73 | 103.73 | 500.0 |
| 2002-06-10 18:00:00 | SPY | ETF | 103.69 | 103.72 | 103.61 | 103.61 | 300.0 |
| 2002-06-10 09:30:00 | QQQ | ETF | 28.36 | 28.49 | 28.18 | 28.33 | 10683800.0 |
| 2002-06-10 10:00:00 | QQQ | ETF | 28.35 | 28.75 | 28.26 | 28.59 | 11010800.0 |
| 2002-06-10 10:30:00 | QQQ | ETF | 28.57 | 28.62 | 28.3 | 28.59 | 8435500.0 |
| 2002-06-10 11:00:00 | QQQ | ETF | 28.6 | 28.62 | 28.45 | 28.48 | 2649200.0 |
| 2002-06-10 11:30:00 | QQQ | ETF | 28.48 | 28.53 | 28.35 | 28.46 | 3591500.0 |
| 2002-06-10 12:00:00 | QQQ | ETF | 28.46 | 28.67 | 28.37 | 28.61 | 2269600.0 |
| 2002-06-10 12:30:00 | QQQ | ETF | 28.61 | 28.75 | 28.54 | 28.72 | 3363900.0 |
| 2002-06-10 13:00:00 | QQQ | ETF | 28.7 | 28.74 | 28.58 | 28.63 | 3010300.0 |
| 2002-06-10 13:30:00 | QQQ | ETF | 28.63 | 28.69 | 28.5 | 28.54 | 2701900.0 |
| 2002-06-10 14:00:00 | QQQ | ETF | 28.54 | 28.73 | 28.45 | 28.7 | 4174200.0 |
| 2002-06-10 14:30:00 | QQQ | ETF | 28.7 | 28.73 | 28.57 | 28.7 | 3497100.0 |
| 2002-06-10 15:00:00 | QQQ | ETF | 28.7 | 28.74 | 28.37 | 28.44 | 5759500.0 |
| 2002-06-10 15:30:00 | QQQ | ETF | 28.41 | 28.45 | 28.14 | 28.27 | 9718100.0 |
| 2002-06-10 16:00:00 | QQQ | ETF | 28.24 | 28.7 | 28.22 | 28.28 | 1066700.0 |
| 2002-06-10 16:30:00 | QQQ | ETF | 28.27 | 28.33 | 28.24 | 28.3 | 84600.0 |
| 2002-06-10 17:00:00 | QQQ | ETF | 28.29 | 28.3 | 28.24 | 28.25 | 38700.0 |
| 2002-06-10 17:30:00 | QQQ | ETF | 28.26 | 28.27 | 28.24 | 28.27 | 38500.0 |
| 2002-06-10 18:00:00 | QQQ | ETF | 28.24 | 28.26 | 28.24 | 28.25 | 8900.0 |
| 2002-06-10 09:30:00 | IWM | ETF | 46.9 | 47.015 | 46.775 | 46.995 | 369600.0 |
| 2002-06-10 10:00:00 | IWM | ETF | 46.985 | 47.225 | 46.955 | 47.1 | 153400.0 |
| 2002-06-10 10:30:00 | IWM | ETF | 47.16 | 47.16 | 46.875 | 47.01 | 249200.0 |
| 2002-06-10 11:00:00 | IWM | ETF | 47.035 | 47.065 | 46.955 | 47.035 | 292400.0 |
| 2002-06-10 11:30:00 | IWM | ETF | 47.0 | 47.0 | 46.89 | 46.985 | 114400.0 |
| 2002-06-10 12:00:00 | IWM | ETF | 46.985 | 47.08 | 46.88 | 47.08 | 53600.0 |
| 2002-06-10 12:30:00 | IWM | ETF | 47.08 | 47.095 | 47.075 | 47.095 | 97000.0 |
| 2002-06-10 13:00:00 | IWM | ETF | 47.085 | 47.125 | 47.08 | 47.125 | 288600.0 |
| 2002-06-10 13:30:00 | IWM | ETF | 47.105 | 47.105 | 47.0 | 47.005 | 50600.0 |
| 2002-06-10 14:00:00 | IWM | ETF | 47.01 | 47.11 | 46.975 | 47.11 | 66400.0 |
| 2002-06-10 14:30:00 | IWM | ETF | 47.1 | 47.135 | 47.045 | 47.135 | 117800.0 |
| 2002-06-10 15:00:00 | IWM | ETF | 47.135 | 47.17 | 47.075 | 47.075 | 59400.0 |
| 2002-06-10 15:30:00 | IWM | ETF | 47.02 | 47.065 | 46.6 | 46.725 | 263800.0 |
| 2002-06-10 16:00:00 | IWM | ETF | 46.745 | 46.75 | 46.745 | 46.75 | 23000.0 |
| 2002-06-10 09:30:00 | DIA | ETF | 96.25 | 96.26 | 95.94 | 96.12 | 450500.0 |
> showing 50 of 477 rows — these rows as CSV