PREVIEW / etf_30min / 2003-10-28
file: by_date/etf_30min/2003/2003-10-28.parquet size: 26 KB rows: 783
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-28 08:00:00 | SPY | ETF | 103.91 | 104.08 | 103.91 | 104.08 | 12000.0 |
| 2003-10-28 08:30:00 | SPY | ETF | 103.99 | 104.11 | 103.97 | 104.04 | 94900.0 |
| 2003-10-28 09:00:00 | SPY | ETF | 104.03 | 104.03 | 103.93 | 103.96 | 18600.0 |
| 2003-10-28 09:30:00 | SPY | ETF | 103.98 | 104.15 | 103.82 | 104.14 | 2726400.0 |
| 2003-10-28 10:00:00 | SPY | ETF | 104.14 | 104.33 | 104.07 | 104.16 | 4132100.0 |
| 2003-10-28 10:30:00 | SPY | ETF | 104.18 | 104.23 | 103.98 | 104.09 | 1320600.0 |
| 2003-10-28 11:00:00 | SPY | ETF | 104.09 | 104.16 | 103.93 | 104.05 | 2385900.0 |
| 2003-10-28 11:30:00 | SPY | ETF | 104.05 | 104.14 | 103.97 | 104.03 | 971300.0 |
| 2003-10-28 12:00:00 | SPY | ETF | 104.03 | 104.16 | 103.94 | 103.97 | 833400.0 |
| 2003-10-28 12:30:00 | SPY | ETF | 103.98 | 104.09 | 103.92 | 104.06 | 466600.0 |
| 2003-10-28 13:00:00 | SPY | ETF | 104.07 | 104.08 | 103.98 | 104.04 | 278700.0 |
| 2003-10-28 13:30:00 | SPY | ETF | 104.04 | 104.19 | 103.98 | 104.15 | 1142200.0 |
| 2003-10-28 14:00:00 | SPY | ETF | 104.14 | 104.39 | 103.96 | 104.2 | 3276500.0 |
| 2003-10-28 14:30:00 | SPY | ETF | 104.202 | 104.55 | 104.01 | 104.52 | 2579800.0 |
| 2003-10-28 15:00:00 | SPY | ETF | 104.52 | 104.68 | 104.44 | 104.6 | 3170200.0 |
| 2003-10-28 15:30:00 | SPY | ETF | 104.64 | 105.069 | 104.6 | 105.02 | 4160000.0 |
| 2003-10-28 16:00:00 | SPY | ETF | 105.07 | 105.15 | 104.94 | 105.02 | 1833500.0 |
| 2003-10-28 16:30:00 | SPY | ETF | 105.03 | 105.0648 | 104.1978 | 104.84 | 312600.0 |
| 2003-10-28 17:00:00 | SPY | ETF | 104.84 | 104.84 | 101.84 | 104.8 | 209500.0 |
| 2003-10-28 17:30:00 | SPY | ETF | 104.77 | 104.89 | 104.77 | 104.89 | 4800.0 |
| 2003-10-28 18:00:00 | SPY | ETF | 104.85 | 104.86 | 104.8 | 104.84 | 4800.0 |
| 2003-10-28 18:30:00 | SPY | ETF | 104.84 | 104.88 | 104.84 | 104.88 | 3400.0 |
| 2003-10-28 19:00:00 | SPY | ETF | 104.87 | 104.9 | 104.87 | 104.9 | 900.0 |
| 2003-10-28 19:30:00 | SPY | ETF | 104.9 | 104.9 | 104.86 | 104.86 | 500.0 |
| 2003-10-28 08:00:00 | QQQ | ETF | 34.38 | 34.45 | 34.38 | 34.45 | 49400.0 |
| 2003-10-28 08:30:00 | QQQ | ETF | 34.44 | 34.45 | 34.4 | 34.43 | 119000.0 |
| 2003-10-28 09:00:00 | QQQ | ETF | 34.41 | 34.43 | 34.38 | 34.42 | 79200.0 |
| 2003-10-28 09:30:00 | QQQ | ETF | 34.43 | 34.54 | 34.37 | 34.54 | 8145600.0 |
| 2003-10-28 10:00:00 | QQQ | ETF | 34.52 | 34.66 | 34.5 | 34.592 | 11256100.0 |
| 2003-10-28 10:30:00 | QQQ | ETF | 34.592 | 34.62 | 34.49 | 34.56 | 4710600.0 |
| 2003-10-28 11:00:00 | QQQ | ETF | 34.56 | 34.622 | 34.48 | 34.59 | 4508800.0 |
| 2003-10-28 11:30:00 | QQQ | ETF | 34.59 | 34.63 | 34.56 | 34.606 | 3849400.0 |
| 2003-10-28 12:00:00 | QQQ | ETF | 34.61 | 34.72 | 34.6 | 34.632 | 4264400.0 |
| 2003-10-28 12:30:00 | QQQ | ETF | 34.636 | 34.69 | 34.62 | 34.67 | 1259200.0 |
| 2003-10-28 13:00:00 | QQQ | ETF | 34.67 | 34.7 | 34.65 | 34.7 | 1896600.0 |
| 2003-10-28 13:30:00 | QQQ | ETF | 34.7 | 34.79 | 34.66 | 34.76 | 5400400.0 |
| 2003-10-28 14:00:00 | QQQ | ETF | 34.76 | 34.85 | 34.63 | 34.76 | 10845200.0 |
| 2003-10-28 14:30:00 | QQQ | ETF | 34.78 | 34.96 | 34.67 | 34.937 | 9372400.0 |
| 2003-10-28 15:00:00 | QQQ | ETF | 34.94 | 35.02 | 34.9 | 35.0 | 8089900.0 |
| 2003-10-28 15:30:00 | QQQ | ETF | 34.99 | 35.3 | 34.98 | 35.29 | 16220400.0 |
| 2003-10-28 16:00:00 | QQQ | ETF | 35.28 | 35.41 | 35.27 | 35.39 | 4587600.0 |
| 2003-10-28 16:30:00 | QQQ | ETF | 35.39 | 35.39 | 34.2565 | 35.315 | 3891800.0 |
| 2003-10-28 17:00:00 | QQQ | ETF | 35.3 | 35.32 | 35.253 | 35.253 | 171100.0 |
| 2003-10-28 17:30:00 | QQQ | ETF | 35.254 | 35.3 | 35.25 | 35.26 | 77300.0 |
| 2003-10-28 18:00:00 | QQQ | ETF | 35.28 | 35.3 | 35.25 | 35.29 | 31400.0 |
| 2003-10-28 18:30:00 | QQQ | ETF | 35.31 | 35.31 | 35.26 | 35.28 | 13400.0 |
| 2003-10-28 19:00:00 | QQQ | ETF | 35.28 | 35.29 | 35.27 | 35.27 | 10100.0 |
| 2003-10-28 19:30:00 | QQQ | ETF | 35.29 | 35.3 | 35.25 | 35.3 | 21900.0 |
| 2003-10-28 08:30:00 | IWM | ETF | 51.425 | 51.625 | 51.125 | 51.625 | 2600.0 |
| 2003-10-28 09:00:00 | IWM | ETF | 51.63 | 51.655 | 51.63 | 51.655 | 2600.0 |
> showing 50 of 783 rows — these rows as CSV