PREVIEW / etf_30min / 2002-06-07
file: by_date/etf_30min/2002/2002-06-07.parquet size: 19 KB rows: 502
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-07 09:30:00 | SPY | ETF | 101.78 | 102.5 | 101.72 | 101.85 | 2917900.0 |
| 2002-06-07 10:00:00 | SPY | ETF | 101.85 | 102.65 | 101.75 | 102.57 | 2334300.0 |
| 2002-06-07 10:30:00 | SPY | ETF | 102.58 | 102.7 | 102.11 | 102.21 | 1824300.0 |
| 2002-06-07 11:00:00 | SPY | ETF | 102.2 | 102.77 | 102.13 | 102.74 | 876800.0 |
| 2002-06-07 11:30:00 | SPY | ETF | 102.74 | 102.98 | 102.55 | 102.68 | 966300.0 |
| 2002-06-07 12:00:00 | SPY | ETF | 102.67 | 103.12 | 102.62 | 102.93 | 1006100.0 |
| 2002-06-07 12:30:00 | SPY | ETF | 102.91 | 102.96 | 102.65 | 102.78 | 756100.0 |
| 2002-06-07 13:00:00 | SPY | ETF | 102.74 | 103.15 | 102.72 | 102.81 | 673700.0 |
| 2002-06-07 13:30:00 | SPY | ETF | 102.8 | 103.37 | 102.75 | 103.2 | 1030000.0 |
| 2002-06-07 14:00:00 | SPY | ETF | 103.2 | 103.92 | 103.19 | 103.71 | 1557200.0 |
| 2002-06-07 14:30:00 | SPY | ETF | 103.65 | 103.92 | 103.03 | 103.23 | 2636200.0 |
| 2002-06-07 15:00:00 | SPY | ETF | 103.2 | 103.7 | 103.02 | 103.18 | 2054600.0 |
| 2002-06-07 15:30:00 | SPY | ETF | 103.18 | 103.5 | 103.06 | 103.26 | 1746700.0 |
| 2002-06-07 16:00:00 | SPY | ETF | 103.25 | 103.62 | 103.12 | 103.62 | 2306100.0 |
| 2002-06-07 16:30:00 | SPY | ETF | 103.3 | 103.34 | 103.3 | 103.3 | 1300.0 |
| 2002-06-07 09:30:00 | QQQ | ETF | 27.63 | 27.99 | 27.52 | 27.6 | 17700200.0 |
| 2002-06-07 10:00:00 | QQQ | ETF | 27.6 | 28.0 | 27.55 | 27.99 | 10414600.0 |
| 2002-06-07 10:30:00 | QQQ | ETF | 27.98 | 28.12 | 27.78 | 27.91 | 10061000.0 |
| 2002-06-07 11:00:00 | QQQ | ETF | 27.91 | 28.23 | 27.84 | 28.18 | 6878400.0 |
| 2002-06-07 11:30:00 | QQQ | ETF | 28.18 | 28.3 | 28.06 | 28.07 | 6532800.0 |
| 2002-06-07 12:00:00 | QQQ | ETF | 28.07 | 28.32 | 28.06 | 28.22 | 4403500.0 |
| 2002-06-07 12:30:00 | QQQ | ETF | 28.23 | 28.25 | 28.06 | 28.16 | 3117500.0 |
| 2002-06-07 13:00:00 | QQQ | ETF | 28.13 | 28.29 | 28.1 | 28.18 | 2853100.0 |
| 2002-06-07 13:30:00 | QQQ | ETF | 28.19 | 28.48 | 28.15 | 28.36 | 5902200.0 |
| 2002-06-07 14:00:00 | QQQ | ETF | 28.36 | 28.78 | 28.32 | 28.64 | 7302200.0 |
| 2002-06-07 14:30:00 | QQQ | ETF | 28.67 | 28.79 | 28.25 | 28.35 | 8708300.0 |
| 2002-06-07 15:00:00 | QQQ | ETF | 28.35 | 28.6 | 28.24 | 28.36 | 5980600.0 |
| 2002-06-07 15:30:00 | QQQ | ETF | 28.36 | 28.49 | 28.24 | 28.37 | 7335700.0 |
| 2002-06-07 16:00:00 | QQQ | ETF | 28.37 | 28.46 | 28.28 | 28.32 | 1480500.0 |
| 2002-06-07 16:30:00 | QQQ | ETF | 28.33 | 28.33 | 27.55 | 28.33 | 22600.0 |
| 2002-06-07 17:00:00 | QQQ | ETF | 28.34 | 28.39 | 27.87 | 28.37 | 77400.0 |
| 2002-06-07 17:30:00 | QQQ | ETF | 28.37 | 28.39 | 28.31 | 28.35 | 6400.0 |
| 2002-06-07 18:00:00 | QQQ | ETF | 28.35 | 28.37 | 28.35 | 28.35 | 6200.0 |
| 2002-06-07 09:30:00 | IWM | ETF | 45.625 | 45.93 | 45.605 | 45.785 | 359800.0 |
| 2002-06-07 10:00:00 | IWM | ETF | 45.73 | 46.09 | 45.725 | 46.05 | 234800.0 |
| 2002-06-07 10:30:00 | IWM | ETF | 46.065 | 46.17 | 45.85 | 45.97 | 149800.0 |
| 2002-06-07 11:00:00 | IWM | ETF | 45.875 | 46.19 | 45.855 | 46.19 | 157400.0 |
| 2002-06-07 11:30:00 | IWM | ETF | 46.125 | 46.3 | 46.05 | 46.095 | 95400.0 |
| 2002-06-07 12:00:00 | IWM | ETF | 46.1 | 46.365 | 46.1 | 46.27 | 131400.0 |
| 2002-06-07 12:30:00 | IWM | ETF | 46.25 | 46.275 | 46.18 | 46.25 | 84400.0 |
| 2002-06-07 13:00:00 | IWM | ETF | 46.25 | 46.38 | 46.22 | 46.325 | 78000.0 |
| 2002-06-07 13:30:00 | IWM | ETF | 46.325 | 46.645 | 46.325 | 46.5 | 269000.0 |
| 2002-06-07 14:00:00 | IWM | ETF | 46.565 | 46.94 | 46.505 | 46.905 | 221400.0 |
| 2002-06-07 14:30:00 | IWM | ETF | 47.0 | 47.0 | 46.45 | 46.63 | 200600.0 |
| 2002-06-07 15:00:00 | IWM | ETF | 46.61 | 46.75 | 46.425 | 46.655 | 162400.0 |
| 2002-06-07 15:30:00 | IWM | ETF | 46.615 | 46.875 | 46.6 | 46.775 | 172600.0 |
| 2002-06-07 16:00:00 | IWM | ETF | 46.825 | 46.975 | 46.75 | 46.775 | 108200.0 |
| 2002-06-07 09:30:00 | DIA | ETF | 95.32 | 95.64 | 94.87 | 94.94 | 1084400.0 |
| 2002-06-07 10:00:00 | DIA | ETF | 95.0 | 95.7 | 94.92 | 95.55 | 705100.0 |
| 2002-06-07 10:30:00 | DIA | ETF | 95.52 | 95.64 | 95.1 | 95.25 | 486200.0 |
> showing 50 of 502 rows — these rows as CSV