PREVIEW / etf_30min / 2002-07-09
file: by_date/etf_30min/2002/2002-07-09.parquet size: 18 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-07-09 09:30:00 | SPY | ETF | 97.73 | 98.27 | 97.68 | 98.05 | 2456400.0 |
| 2002-07-09 10:00:00 | SPY | ETF | 97.92 | 98.0 | 97.32 | 97.51 | 2433500.0 |
| 2002-07-09 10:30:00 | SPY | ETF | 97.48 | 98.09 | 97.48 | 97.79 | 1455600.0 |
| 2002-07-09 11:00:00 | SPY | ETF | 97.81 | 98.34 | 97.64 | 98.08 | 1432400.0 |
| 2002-07-09 11:30:00 | SPY | ETF | 98.08 | 98.13 | 97.23 | 97.31 | 2414100.0 |
| 2002-07-09 12:00:00 | SPY | ETF | 97.33 | 97.77 | 97.23 | 97.5 | 1212300.0 |
| 2002-07-09 12:30:00 | SPY | ETF | 97.5 | 97.71 | 97.3 | 97.4 | 1582900.0 |
| 2002-07-09 13:00:00 | SPY | ETF | 97.44 | 97.73 | 97.38 | 97.51 | 774400.0 |
| 2002-07-09 13:30:00 | SPY | ETF | 97.51 | 97.53 | 96.92 | 97.11 | 1035600.0 |
| 2002-07-09 14:00:00 | SPY | ETF | 97.08 | 97.16 | 96.62 | 96.76 | 1067000.0 |
| 2002-07-09 14:30:00 | SPY | ETF | 96.8 | 96.84 | 96.13 | 96.26 | 2153600.0 |
| 2002-07-09 15:00:00 | SPY | ETF | 96.24 | 96.43 | 95.8 | 95.84 | 2070200.0 |
| 2002-07-09 15:30:00 | SPY | ETF | 95.83 | 96.04 | 95.4 | 95.61 | 4268800.0 |
| 2002-07-09 16:00:00 | SPY | ETF | 95.55 | 95.79 | 95.52 | 95.65 | 2182400.0 |
| 2002-07-09 16:30:00 | SPY | ETF | 95.65 | 97.04 | 95.57 | 95.57 | 1022400.0 |
| 2002-07-09 17:00:00 | SPY | ETF | 95.58 | 95.75 | 95.57 | 95.75 | 58100.0 |
| 2002-07-09 17:30:00 | SPY | ETF | 95.7 | 96.0 | 95.7 | 95.93 | 2900.0 |
| 2002-07-09 18:00:00 | SPY | ETF | 95.9 | 95.9 | 95.0 | 95.47 | 12700.0 |
| 2002-07-09 09:30:00 | QQQ | ETF | 25.25 | 25.45 | 25.14 | 25.33 | 12363500.0 |
| 2002-07-09 10:00:00 | QQQ | ETF | 25.33 | 25.35 | 24.88 | 25.05 | 12474700.0 |
| 2002-07-09 10:30:00 | QQQ | ETF | 25.04 | 25.37 | 25.02 | 25.24 | 7955700.0 |
| 2002-07-09 11:00:00 | QQQ | ETF | 25.23 | 25.48 | 25.16 | 25.36 | 6737300.0 |
| 2002-07-09 11:30:00 | QQQ | ETF | 25.31 | 25.36 | 25.0 | 25.07 | 7049800.0 |
| 2002-07-09 12:00:00 | QQQ | ETF | 25.06 | 25.22 | 25.01 | 25.14 | 3557400.0 |
| 2002-07-09 12:30:00 | QQQ | ETF | 25.14 | 25.29 | 25.12 | 25.15 | 2436000.0 |
| 2002-07-09 13:00:00 | QQQ | ETF | 25.15 | 25.33 | 25.13 | 25.2 | 2653200.0 |
| 2002-07-09 13:30:00 | QQQ | ETF | 25.21 | 25.23 | 25.04 | 25.09 | 3742100.0 |
| 2002-07-09 14:00:00 | QQQ | ETF | 25.11 | 25.14 | 24.85 | 24.91 | 6053300.0 |
| 2002-07-09 14:30:00 | QQQ | ETF | 24.94 | 24.97 | 24.77 | 24.84 | 5181600.0 |
| 2002-07-09 15:00:00 | QQQ | ETF | 24.84 | 24.95 | 24.75 | 24.78 | 6255100.0 |
| 2002-07-09 15:30:00 | QQQ | ETF | 24.8 | 24.88 | 24.59 | 24.68 | 9105700.0 |
| 2002-07-09 16:00:00 | QQQ | ETF | 24.66 | 24.76 | 24.52 | 24.55 | 2996700.0 |
| 2002-07-09 16:30:00 | QQQ | ETF | 24.55 | 24.68 | 24.55 | 24.64 | 146100.0 |
| 2002-07-09 17:00:00 | QQQ | ETF | 24.65 | 24.66 | 24.56 | 24.6 | 72000.0 |
| 2002-07-09 17:30:00 | QQQ | ETF | 24.59 | 24.68 | 24.59 | 24.67 | 32200.0 |
| 2002-07-09 18:00:00 | QQQ | ETF | 24.66 | 25.49 | 24.55 | 24.55 | 51100.0 |
| 2002-07-09 09:30:00 | IWM | ETF | 43.1 | 43.355 | 43.05 | 43.285 | 93400.0 |
| 2002-07-09 10:00:00 | IWM | ETF | 43.3 | 43.3 | 42.965 | 43.09 | 118000.0 |
| 2002-07-09 10:30:00 | IWM | ETF | 43.1 | 43.21 | 43.07 | 43.1 | 97800.0 |
| 2002-07-09 11:00:00 | IWM | ETF | 43.195 | 43.435 | 43.175 | 43.435 | 98400.0 |
| 2002-07-09 11:30:00 | IWM | ETF | 43.375 | 43.375 | 43.15 | 43.225 | 97800.0 |
| 2002-07-09 12:00:00 | IWM | ETF | 43.15 | 43.265 | 43.14 | 43.24 | 87000.0 |
| 2002-07-09 12:30:00 | IWM | ETF | 43.225 | 43.285 | 43.225 | 43.27 | 98600.0 |
| 2002-07-09 13:00:00 | IWM | ETF | 43.23 | 43.425 | 43.23 | 43.27 | 18400.0 |
| 2002-07-09 13:30:00 | IWM | ETF | 43.39 | 43.39 | 43.18 | 43.275 | 61200.0 |
| 2002-07-09 14:00:00 | IWM | ETF | 43.2 | 43.2 | 43.09 | 43.09 | 131400.0 |
| 2002-07-09 14:30:00 | IWM | ETF | 43.1 | 43.1 | 42.895 | 42.9 | 245400.0 |
| 2002-07-09 15:00:00 | IWM | ETF | 42.895 | 43.035 | 42.755 | 42.775 | 286200.0 |
| 2002-07-09 15:30:00 | IWM | ETF | 42.775 | 42.895 | 42.65 | 42.775 | 168000.0 |
| 2002-07-09 16:00:00 | IWM | ETF | 42.825 | 42.885 | 42.82 | 42.885 | 9400.0 |
> showing 50 of 502 rows — these rows as CSV