PREVIEW / etf_30min / 2003-08-04
file: by_date/etf_30min/2003/2003-08-04.parquet size: 24 KB rows: 692
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-08-04 08:00:00 | SPY | ETF | 98.68 | 98.7 | 98.6 | 98.61 | 32200.0 |
| 2003-08-04 08:30:00 | SPY | ETF | 98.61 | 98.61 | 98.43 | 98.43 | 55600.0 |
| 2003-08-04 09:00:00 | SPY | ETF | 98.43 | 98.46 | 98.35 | 98.35 | 14400.0 |
| 2003-08-04 09:30:00 | SPY | ETF | 98.31 | 98.42 | 97.39 | 97.58 | 6802300.0 |
| 2003-08-04 10:00:00 | SPY | ETF | 97.59 | 97.7 | 97.11 | 97.15 | 4734100.0 |
| 2003-08-04 10:30:00 | SPY | ETF | 97.15 | 97.43 | 97.024 | 97.38 | 4019100.0 |
| 2003-08-04 11:00:00 | SPY | ETF | 97.338 | 97.45 | 97.26 | 97.4 | 1690000.0 |
| 2003-08-04 11:30:00 | SPY | ETF | 97.39 | 97.55 | 97.37 | 97.396 | 2532000.0 |
| 2003-08-04 12:00:00 | SPY | ETF | 97.39 | 98.18 | 97.35 | 97.84 | 3120600.0 |
| 2003-08-04 12:30:00 | SPY | ETF | 97.85 | 97.94 | 97.7 | 97.85 | 1761700.0 |
| 2003-08-04 13:00:00 | SPY | ETF | 97.87 | 98.43 | 97.85 | 98.25 | 3739300.0 |
| 2003-08-04 13:30:00 | SPY | ETF | 98.32 | 98.34 | 97.9 | 97.9 | 2672600.0 |
| 2003-08-04 14:00:00 | SPY | ETF | 97.91 | 98.3 | 97.84 | 98.23 | 1522500.0 |
| 2003-08-04 14:30:00 | SPY | ETF | 98.21 | 98.98 | 98.21 | 98.76 | 8563100.0 |
| 2003-08-04 15:00:00 | SPY | ETF | 98.75 | 99.0 | 98.67 | 98.79 | 3397100.0 |
| 2003-08-04 15:30:00 | SPY | ETF | 98.809 | 98.86 | 98.46 | 98.71 | 2952700.0 |
| 2003-08-04 16:00:00 | SPY | ETF | 98.72 | 98.73 | 98.51 | 98.55 | 939100.0 |
| 2003-08-04 16:30:00 | SPY | ETF | 98.59 | 98.69 | 98.52 | 98.57 | 1241500.0 |
| 2003-08-04 17:00:00 | SPY | ETF | 98.59 | 98.59 | 98.55 | 98.56 | 8500.0 |
| 2003-08-04 17:30:00 | SPY | ETF | 98.58 | 98.64 | 98.56 | 98.62 | 295800.0 |
| 2003-08-04 18:00:00 | SPY | ETF | 98.62 | 98.62 | 98.55 | 98.55 | 7200.0 |
| 2003-08-04 18:30:00 | SPY | ETF | 98.6 | 98.65 | 98.6 | 98.65 | 600.0 |
| 2003-08-04 19:00:00 | SPY | ETF | 98.6 | 98.6 | 98.57 | 98.57 | 1500.0 |
| 2003-08-04 19:30:00 | SPY | ETF | 98.62 | 98.65 | 98.62 | 98.62 | 700.0 |
| 2003-08-04 08:00:00 | QQQ | ETF | 31.58 | 31.58 | 31.52 | 31.52 | 22900.0 |
| 2003-08-04 08:30:00 | QQQ | ETF | 31.52 | 31.52 | 31.46 | 31.47 | 28900.0 |
| 2003-08-04 09:00:00 | QQQ | ETF | 31.47 | 31.47 | 31.4 | 31.41 | 48000.0 |
| 2003-08-04 09:30:00 | QQQ | ETF | 31.42 | 31.5 | 31.06 | 31.15 | 10383200.0 |
| 2003-08-04 10:00:00 | QQQ | ETF | 31.154 | 31.21 | 30.93 | 30.942 | 11147700.0 |
| 2003-08-04 10:30:00 | QQQ | ETF | 30.941 | 31.0 | 30.84 | 30.95 | 7074500.0 |
| 2003-08-04 11:00:00 | QQQ | ETF | 30.97 | 31.054 | 30.93 | 31.006 | 4943100.0 |
| 2003-08-04 11:30:00 | QQQ | ETF | 31.01 | 31.1 | 30.99 | 30.996 | 4047300.0 |
| 2003-08-04 12:00:00 | QQQ | ETF | 31.0 | 31.226 | 30.959 | 31.15 | 4018800.0 |
| 2003-08-04 12:30:00 | QQQ | ETF | 31.15 | 31.17 | 31.07 | 31.15 | 3327100.0 |
| 2003-08-04 13:00:00 | QQQ | ETF | 31.14 | 31.37 | 31.13 | 31.27 | 6632500.0 |
| 2003-08-04 13:30:00 | QQQ | ETF | 31.27 | 31.3 | 31.15 | 31.15 | 4527100.0 |
| 2003-08-04 14:00:00 | QQQ | ETF | 31.16 | 31.29 | 31.12 | 31.26 | 2786700.0 |
| 2003-08-04 14:30:00 | QQQ | ETF | 31.263 | 31.8 | 31.255 | 31.66 | 12179700.0 |
| 2003-08-04 15:00:00 | QQQ | ETF | 31.655 | 31.75 | 31.52 | 31.58 | 5643300.0 |
| 2003-08-04 15:30:00 | QQQ | ETF | 31.59 | 31.64 | 31.38 | 31.51 | 6392400.0 |
| 2003-08-04 16:00:00 | QQQ | ETF | 31.509 | 31.54 | 31.422 | 31.48 | 2084400.0 |
| 2003-08-04 16:30:00 | QQQ | ETF | 31.48 | 31.49 | 31.43 | 31.44 | 62400.0 |
| 2003-08-04 17:00:00 | QQQ | ETF | 31.46 | 31.46 | 31.44 | 31.44 | 5900.0 |
| 2003-08-04 17:30:00 | QQQ | ETF | 31.461 | 31.47 | 31.45 | 31.45 | 9100.0 |
| 2003-08-04 18:00:00 | QQQ | ETF | 31.46 | 31.49 | 31.46 | 31.48 | 9900.0 |
| 2003-08-04 18:30:00 | QQQ | ETF | 31.47 | 31.47 | 31.47 | 31.47 | 1200.0 |
| 2003-08-04 19:00:00 | QQQ | ETF | 31.46 | 31.47 | 31.46 | 31.47 | 800.0 |
| 2003-08-04 19:30:00 | QQQ | ETF | 31.47 | 31.52 | 31.47 | 31.52 | 6800.0 |
| 2003-08-04 09:30:00 | IWM | ETF | 46.57 | 46.752 | 46.285 | 46.285 | 1957000.0 |
| 2003-08-04 10:00:00 | IWM | ETF | 46.275 | 46.305 | 45.88 | 45.955 | 370400.0 |
> showing 50 of 692 rows — these rows as CSV