PREVIEW / etf_30min / 2003-09-22
file: by_date/etf_30min/2003/2003-09-22.parquet size: 24 KB rows: 732
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-22 08:00:00 | SPY | ETF | 102.74 | 102.85 | 102.72 | 102.82 | 28400.0 |
| 2003-09-22 08:30:00 | SPY | ETF | 102.85 | 102.98 | 102.84 | 102.92 | 57800.0 |
| 2003-09-22 09:00:00 | SPY | ETF | 102.91 | 102.96 | 102.87 | 102.87 | 57600.0 |
| 2003-09-22 09:30:00 | SPY | ETF | 102.85 | 102.96 | 102.42 | 102.45 | 6954900.0 |
| 2003-09-22 10:00:00 | SPY | ETF | 102.45 | 102.55 | 102.22 | 102.42 | 4044700.0 |
| 2003-09-22 10:30:00 | SPY | ETF | 102.41 | 102.61 | 102.33 | 102.45 | 2687500.0 |
| 2003-09-22 11:00:00 | SPY | ETF | 102.46 | 102.72 | 102.34 | 102.62 | 1813300.0 |
| 2003-09-22 11:30:00 | SPY | ETF | 102.61 | 102.72 | 102.38 | 102.45 | 1488100.0 |
| 2003-09-22 12:00:00 | SPY | ETF | 102.47 | 102.54 | 102.268 | 102.41 | 1151800.0 |
| 2003-09-22 12:30:00 | SPY | ETF | 102.42 | 102.5 | 102.34 | 102.41 | 1018400.0 |
| 2003-09-22 13:00:00 | SPY | ETF | 102.43 | 102.55 | 102.33 | 102.42 | 650700.0 |
| 2003-09-22 13:30:00 | SPY | ETF | 102.42 | 102.56 | 102.38 | 102.41 | 815100.0 |
| 2003-09-22 14:00:00 | SPY | ETF | 102.41 | 102.49 | 102.06 | 102.09 | 3018300.0 |
| 2003-09-22 14:30:00 | SPY | ETF | 102.082 | 102.25 | 102.03 | 102.212 | 1983300.0 |
| 2003-09-22 15:00:00 | SPY | ETF | 102.22 | 102.43 | 102.2 | 102.37 | 1477300.0 |
| 2003-09-22 15:30:00 | SPY | ETF | 102.35 | 102.58 | 102.25 | 102.49 | 2230500.0 |
| 2003-09-22 16:00:00 | SPY | ETF | 102.46 | 102.62 | 102.45 | 102.52 | 927500.0 |
| 2003-09-22 16:30:00 | SPY | ETF | 102.48 | 102.55 | 102.45 | 102.55 | 245700.0 |
| 2003-09-22 17:00:00 | SPY | ETF | 102.56 | 102.58 | 102.52 | 102.57 | 11600.0 |
| 2003-09-22 17:30:00 | SPY | ETF | 102.57 | 102.6 | 102.53 | 102.6 | 12200.0 |
| 2003-09-22 18:00:00 | SPY | ETF | 102.56 | 102.64 | 102.56 | 102.64 | 8400.0 |
| 2003-09-22 18:30:00 | SPY | ETF | 102.6 | 102.64 | 102.6 | 102.64 | 700.0 |
| 2003-09-22 19:00:00 | SPY | ETF | 102.63 | 102.64 | 102.63 | 102.64 | 1400.0 |
| 2003-09-22 19:30:00 | SPY | ETF | 102.66 | 102.7 | 102.66 | 102.7 | 2000.0 |
| 2003-09-22 08:00:00 | QQQ | ETF | 34.1 | 34.11 | 34.06 | 34.07 | 97000.0 |
| 2003-09-22 08:30:00 | QQQ | ETF | 34.08 | 34.16 | 34.08 | 34.15 | 221600.0 |
| 2003-09-22 09:00:00 | QQQ | ETF | 34.14 | 34.16 | 34.11 | 34.12 | 209000.0 |
| 2003-09-22 09:30:00 | QQQ | ETF | 34.13 | 34.2 | 33.9 | 33.93 | 19944200.0 |
| 2003-09-22 10:00:00 | QQQ | ETF | 33.93 | 34.07 | 33.85 | 33.96 | 9488300.0 |
| 2003-09-22 10:30:00 | QQQ | ETF | 33.97 | 34.097 | 33.91 | 34.03 | 5832400.0 |
| 2003-09-22 11:00:00 | QQQ | ETF | 34.02 | 34.148 | 33.96 | 34.088 | 5169700.0 |
| 2003-09-22 11:30:00 | QQQ | ETF | 34.11 | 34.14 | 33.95 | 34.0 | 5392900.0 |
| 2003-09-22 12:00:00 | QQQ | ETF | 34.0 | 34.04 | 33.917 | 34.01 | 3996500.0 |
| 2003-09-22 12:30:00 | QQQ | ETF | 33.987 | 34.05 | 33.933 | 33.99 | 2397300.0 |
| 2003-09-22 13:00:00 | QQQ | ETF | 33.98 | 34.05 | 33.95 | 33.98 | 3437500.0 |
| 2003-09-22 13:30:00 | QQQ | ETF | 33.97 | 34.02 | 33.92 | 33.95 | 2427400.0 |
| 2003-09-22 14:00:00 | QQQ | ETF | 33.94 | 33.98 | 33.77 | 33.79 | 7343300.0 |
| 2003-09-22 14:30:00 | QQQ | ETF | 33.791 | 33.85 | 33.77 | 33.82 | 6512500.0 |
| 2003-09-22 15:00:00 | QQQ | ETF | 33.819 | 33.92 | 33.81 | 33.888 | 4403600.0 |
| 2003-09-22 15:30:00 | QQQ | ETF | 33.888 | 33.98 | 33.8 | 33.95 | 7259100.0 |
| 2003-09-22 16:00:00 | QQQ | ETF | 33.941 | 33.96 | 33.87 | 33.89 | 1475200.0 |
| 2003-09-22 16:30:00 | QQQ | ETF | 33.9 | 33.96 | 33.87 | 33.96 | 115800.0 |
| 2003-09-22 17:00:00 | QQQ | ETF | 33.95 | 33.96 | 33.93 | 33.93 | 13000.0 |
| 2003-09-22 17:30:00 | QQQ | ETF | 33.92 | 33.95 | 33.92 | 33.93 | 9100.0 |
| 2003-09-22 18:00:00 | QQQ | ETF | 33.93 | 33.94 | 33.93 | 33.93 | 5300.0 |
| 2003-09-22 18:30:00 | QQQ | ETF | 33.94 | 33.94 | 33.93 | 33.93 | 2500.0 |
| 2003-09-22 19:00:00 | QQQ | ETF | 33.94 | 33.95 | 33.94 | 33.94 | 3100.0 |
| 2003-09-22 19:30:00 | QQQ | ETF | 33.94 | 33.96 | 33.94 | 33.96 | 3600.0 |
| 2003-09-22 09:30:00 | IWM | ETF | 51.1 | 51.135 | 50.925 | 50.95 | 951400.0 |
| 2003-09-22 10:00:00 | IWM | ETF | 50.935 | 51.015 | 50.87 | 50.955 | 375000.0 |
> showing 50 of 732 rows — these rows as CSV