PREVIEW / etf_30min / 2002-07-02
file: by_date/etf_30min/2002/2002-07-02.parquet size: 19 KB rows: 541
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-02 09:30:00 | SPY | ETF | 96.86 | 97.2 | 96.58 | 96.91 | 2936800.0 |
| 2002-07-02 10:00:00 | SPY | ETF | 96.95 | 96.96 | 95.84 | 96.25 | 2882200.0 |
| 2002-07-02 10:30:00 | SPY | ETF | 96.2 | 96.27 | 95.63 | 95.96 | 1711800.0 |
| 2002-07-02 11:00:00 | SPY | ETF | 95.96 | 96.08 | 95.5 | 95.92 | 2984000.0 |
| 2002-07-02 11:30:00 | SPY | ETF | 95.92 | 96.0 | 95.11 | 95.2 | 2043000.0 |
| 2002-07-02 12:00:00 | SPY | ETF | 95.2 | 95.57 | 94.86 | 95.55 | 2676200.0 |
| 2002-07-02 12:30:00 | SPY | ETF | 95.55 | 95.58 | 95.19 | 95.3 | 1786800.0 |
| 2002-07-02 13:00:00 | SPY | ETF | 95.29 | 95.48 | 94.77 | 95.43 | 1927600.0 |
| 2002-07-02 13:30:00 | SPY | ETF | 95.41 | 96.13 | 95.23 | 95.78 | 3402900.0 |
| 2002-07-02 14:00:00 | SPY | ETF | 95.76 | 96.25 | 95.67 | 95.94 | 2434100.0 |
| 2002-07-02 14:30:00 | SPY | ETF | 95.98 | 96.24 | 95.52 | 95.7 | 1815600.0 |
| 2002-07-02 15:00:00 | SPY | ETF | 95.67 | 95.97 | 95.21 | 95.28 | 1693700.0 |
| 2002-07-02 15:30:00 | SPY | ETF | 95.29 | 95.54 | 94.9 | 95.02 | 3207100.0 |
| 2002-07-02 16:00:00 | SPY | ETF | 95.08 | 95.23 | 94.93 | 94.95 | 1265400.0 |
| 2002-07-02 16:30:00 | SPY | ETF | 94.9 | 95.06 | 94.9 | 95.03 | 16900.0 |
| 2002-07-02 17:00:00 | SPY | ETF | 95.04 | 95.07 | 95.01 | 95.05 | 1900.0 |
| 2002-07-02 17:30:00 | SPY | ETF | 95.07 | 95.07 | 95.07 | 95.07 | 400.0 |
| 2002-07-02 18:00:00 | SPY | ETF | 95.07 | 95.15 | 95.06 | 95.14 | 4800.0 |
| 2002-07-02 09:30:00 | QQQ | ETF | 24.6 | 24.75 | 24.38 | 24.61 | 14645500.0 |
| 2002-07-02 10:00:00 | QQQ | ETF | 24.61 | 24.65 | 24.2 | 24.4 | 11671700.0 |
| 2002-07-02 10:30:00 | QQQ | ETF | 24.4 | 24.43 | 24.18 | 24.25 | 5171300.0 |
| 2002-07-02 11:00:00 | QQQ | ETF | 24.25 | 24.3 | 24.05 | 24.27 | 9624600.0 |
| 2002-07-02 11:30:00 | QQQ | ETF | 24.25 | 24.31 | 23.96 | 24.0 | 7673900.0 |
| 2002-07-02 12:00:00 | QQQ | ETF | 24.02 | 24.3 | 23.95 | 24.27 | 6533800.0 |
| 2002-07-02 12:30:00 | QQQ | ETF | 24.28 | 24.35 | 24.15 | 24.2 | 4426900.0 |
| 2002-07-02 13:00:00 | QQQ | ETF | 24.19 | 24.28 | 23.95 | 24.23 | 5286400.0 |
| 2002-07-02 13:30:00 | QQQ | ETF | 24.23 | 24.5 | 24.14 | 24.36 | 6158100.0 |
| 2002-07-02 14:00:00 | QQQ | ETF | 24.34 | 24.57 | 24.3 | 24.49 | 9033200.0 |
| 2002-07-02 14:30:00 | QQQ | ETF | 24.48 | 24.55 | 24.1 | 24.18 | 7376200.0 |
| 2002-07-02 15:00:00 | QQQ | ETF | 24.17 | 24.28 | 23.98 | 24.06 | 6500400.0 |
| 2002-07-02 15:30:00 | QQQ | ETF | 24.06 | 24.16 | 23.89 | 24.01 | 11356400.0 |
| 2002-07-02 16:00:00 | QQQ | ETF | 24.0 | 24.08 | 23.91 | 24.0 | 2508200.0 |
| 2002-07-02 16:30:00 | QQQ | ETF | 24.0 | 24.13 | 23.96 | 24.05 | 506100.0 |
| 2002-07-02 17:00:00 | QQQ | ETF | 24.02 | 24.1 | 24.0 | 24.04 | 77700.0 |
| 2002-07-02 17:30:00 | QQQ | ETF | 24.03 | 24.06 | 24.02 | 24.05 | 9800.0 |
| 2002-07-02 18:00:00 | QQQ | ETF | 24.04 | 24.05 | 24.0 | 24.0 | 22200.0 |
| 2002-07-02 09:30:00 | IWM | ETF | 44.28 | 44.3 | 43.975 | 44.225 | 195000.0 |
| 2002-07-02 10:00:00 | IWM | ETF | 44.225 | 44.25 | 43.65 | 43.74 | 185800.0 |
| 2002-07-02 10:30:00 | IWM | ETF | 43.74 | 43.76 | 43.525 | 43.56 | 128000.0 |
| 2002-07-02 11:00:00 | IWM | ETF | 43.55 | 43.575 | 43.25 | 43.35 | 101200.0 |
| 2002-07-02 11:30:00 | IWM | ETF | 43.37 | 43.385 | 43.15 | 43.195 | 83800.0 |
| 2002-07-02 12:00:00 | IWM | ETF | 43.255 | 43.295 | 43.08 | 43.245 | 52600.0 |
| 2002-07-02 12:30:00 | IWM | ETF | 43.19 | 43.365 | 43.19 | 43.285 | 143600.0 |
| 2002-07-02 13:00:00 | IWM | ETF | 43.29 | 43.3 | 43.16 | 43.3 | 34800.0 |
| 2002-07-02 13:30:00 | IWM | ETF | 43.31 | 43.565 | 43.275 | 43.505 | 137400.0 |
| 2002-07-02 14:00:00 | IWM | ETF | 43.52 | 43.675 | 43.51 | 43.66 | 63000.0 |
| 2002-07-02 14:30:00 | IWM | ETF | 43.67 | 43.675 | 43.42 | 43.45 | 38600.0 |
| 2002-07-02 15:00:00 | IWM | ETF | 43.42 | 43.47 | 43.19 | 43.22 | 172000.0 |
| 2002-07-02 15:30:00 | IWM | ETF | 43.21 | 43.225 | 43.0 | 43.0 | 183400.0 |
| 2002-07-02 16:00:00 | IWM | ETF | 43.06 | 43.065 | 43.06 | 43.065 | 4400.0 |
> showing 50 of 541 rows — these rows as CSV