PREVIEW / etf_30min / 2003-09-26
file: by_date/etf_30min/2003/2003-09-26.parquet size: 24 KB rows: 708
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-09-26 08:00:00 | SPY | ETF | 100.04 | 100.14 | 100.0 | 100.13 | 21100.0 |
| 2003-09-26 08:30:00 | SPY | ETF | 100.15 | 100.35 | 100.11 | 100.34 | 119600.0 |
| 2003-09-26 09:00:00 | SPY | ETF | 100.33 | 100.46 | 100.3 | 100.46 | 67200.0 |
| 2003-09-26 09:30:00 | SPY | ETF | 100.44 | 100.54 | 100.02 | 100.38 | 6574000.0 |
| 2003-09-26 10:00:00 | SPY | ETF | 100.38 | 100.63 | 99.97 | 100.45 | 4092400.0 |
| 2003-09-26 10:30:00 | SPY | ETF | 100.45 | 100.66 | 100.17 | 100.37 | 2961700.0 |
| 2003-09-26 11:00:00 | SPY | ETF | 100.37 | 100.65 | 100.12 | 100.19 | 2373300.0 |
| 2003-09-26 11:30:00 | SPY | ETF | 100.16 | 100.31 | 100.04 | 100.13 | 2827100.0 |
| 2003-09-26 12:00:00 | SPY | ETF | 100.12 | 100.23 | 99.88 | 100.17 | 2218700.0 |
| 2003-09-26 12:30:00 | SPY | ETF | 100.17 | 100.39 | 99.99 | 100.31 | 1669500.0 |
| 2003-09-26 13:00:00 | SPY | ETF | 100.29 | 100.53 | 100.27 | 100.43 | 1410300.0 |
| 2003-09-26 13:30:00 | SPY | ETF | 100.44 | 100.59 | 100.197 | 100.33 | 1763100.0 |
| 2003-09-26 14:00:00 | SPY | ETF | 100.31 | 100.42 | 100.07 | 100.25 | 1367900.0 |
| 2003-09-26 14:30:00 | SPY | ETF | 100.24 | 100.41 | 99.9 | 99.99 | 1467100.0 |
| 2003-09-26 15:00:00 | SPY | ETF | 99.99 | 100.36 | 99.85 | 100.34 | 2745700.0 |
| 2003-09-26 15:30:00 | SPY | ETF | 100.33 | 100.37 | 99.95 | 99.98 | 3028300.0 |
| 2003-09-26 16:00:00 | SPY | ETF | 100.02 | 100.5854 | 99.88 | 99.9 | 2637200.0 |
| 2003-09-26 16:30:00 | SPY | ETF | 100.12 | 100.12 | 99.9 | 99.94 | 77700.0 |
| 2003-09-26 17:00:00 | SPY | ETF | 99.95 | 100.03 | 99.93 | 100.0 | 50600.0 |
| 2003-09-26 17:30:00 | SPY | ETF | 99.95 | 100.0 | 99.95 | 100.0 | 500.0 |
| 2003-09-26 18:00:00 | SPY | ETF | 100.0 | 100.0 | 100.0 | 100.0 | 200.0 |
| 2003-09-26 18:30:00 | SPY | ETF | 100.05 | 100.05 | 100.05 | 100.05 | 100.0 |
| 2003-09-26 08:00:00 | QQQ | ETF | 32.7 | 32.78 | 32.66 | 32.76 | 109100.0 |
| 2003-09-26 08:30:00 | QQQ | ETF | 32.76 | 32.91 | 32.73 | 32.86 | 115400.0 |
| 2003-09-26 09:00:00 | QQQ | ETF | 32.89 | 32.91 | 32.87 | 32.89 | 216700.0 |
| 2003-09-26 09:30:00 | QQQ | ETF | 32.89 | 33.09 | 32.78 | 32.97 | 11447500.0 |
| 2003-09-26 10:00:00 | QQQ | ETF | 32.98 | 33.17 | 32.78 | 33.13 | 13441700.0 |
| 2003-09-26 10:30:00 | QQQ | ETF | 33.12 | 33.17 | 32.92 | 33.04 | 7068300.0 |
| 2003-09-26 11:00:00 | QQQ | ETF | 33.001 | 33.14 | 32.808 | 32.84 | 4751200.0 |
| 2003-09-26 11:30:00 | QQQ | ETF | 32.843 | 32.97 | 32.71 | 32.76 | 10502300.0 |
| 2003-09-26 12:00:00 | QQQ | ETF | 32.77 | 32.83 | 32.62 | 32.785 | 4232900.0 |
| 2003-09-26 12:30:00 | QQQ | ETF | 32.785 | 32.901 | 32.69 | 32.85 | 4193800.0 |
| 2003-09-26 13:00:00 | QQQ | ETF | 32.84 | 32.996 | 32.83 | 32.95 | 4307200.0 |
| 2003-09-26 13:30:00 | QQQ | ETF | 32.94 | 33.02 | 32.79 | 32.85 | 4267000.0 |
| 2003-09-26 14:00:00 | QQQ | ETF | 32.84 | 32.95 | 32.75 | 32.82 | 6876400.0 |
| 2003-09-26 14:30:00 | QQQ | ETF | 32.82 | 32.92 | 32.61 | 32.65 | 4124700.0 |
| 2003-09-26 15:00:00 | QQQ | ETF | 32.65 | 32.87 | 32.59 | 32.83 | 8568500.0 |
| 2003-09-26 15:30:00 | QQQ | ETF | 32.838 | 32.87 | 32.56 | 32.58 | 8480500.0 |
| 2003-09-26 16:00:00 | QQQ | ETF | 32.59 | 32.64 | 32.52 | 32.54 | 3237700.0 |
| 2003-09-26 16:30:00 | QQQ | ETF | 32.54 | 32.56 | 32.46 | 32.55 | 177700.0 |
| 2003-09-26 17:00:00 | QQQ | ETF | 32.54 | 32.55 | 32.5 | 32.51 | 56100.0 |
| 2003-09-26 17:30:00 | QQQ | ETF | 32.53 | 32.58 | 32.51 | 32.58 | 30000.0 |
| 2003-09-26 18:00:00 | QQQ | ETF | 32.58 | 32.6 | 32.55 | 32.6 | 36100.0 |
| 2003-09-26 18:30:00 | QQQ | ETF | 32.6 | 32.64 | 32.59 | 32.6 | 5400.0 |
| 2003-09-26 19:00:00 | QQQ | ETF | 32.6 | 32.6 | 32.58 | 32.6 | 11800.0 |
| 2003-09-26 19:30:00 | QQQ | ETF | 32.6 | 32.62 | 32.59 | 32.61 | 6400.0 |
| 2003-09-26 09:00:00 | IWM | ETF | 49.235 | 49.235 | 49.235 | 49.235 | 800.0 |
| 2003-09-26 09:30:00 | IWM | ETF | 49.21 | 49.305 | 48.8 | 48.9 | 1220800.0 |
| 2003-09-26 10:00:00 | IWM | ETF | 48.915 | 48.94 | 48.5 | 48.88 | 1885200.0 |
| 2003-09-26 10:30:00 | IWM | ETF | 48.905 | 49.075 | 48.865 | 48.925 | 614600.0 |
> showing 50 of 708 rows — these rows as CSV