PREVIEW / etf_30min / 2003-04-22
file: by_date/etf_30min/2003/2003-04-22.parquet size: 24 KB rows: 684
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-04-22 08:00:00 | SPY | ETF | 89.34 | 89.38 | 89.29 | 89.3 | 6200.0 |
| 2003-04-22 08:30:00 | SPY | ETF | 89.32 | 89.33 | 89.18 | 89.29 | 6500.0 |
| 2003-04-22 09:00:00 | SPY | ETF | 89.22 | 89.22 | 89.09 | 89.1 | 24800.0 |
| 2003-04-22 09:30:00 | SPY | ETF | 89.1 | 89.27 | 88.89 | 89.14 | 5001600.0 |
| 2003-04-22 10:00:00 | SPY | ETF | 89.16 | 89.52 | 89.04 | 89.52 | 2431400.0 |
| 2003-04-22 10:30:00 | SPY | ETF | 89.53 | 90.45 | 89.51 | 90.26 | 8369500.0 |
| 2003-04-22 11:00:00 | SPY | ETF | 90.27 | 90.39 | 89.82 | 89.89 | 3576800.0 |
| 2003-04-22 11:30:00 | SPY | ETF | 89.9 | 90.43 | 89.8 | 90.36 | 2525000.0 |
| 2003-04-22 12:00:00 | SPY | ETF | 90.4 | 90.69 | 90.27 | 90.63 | 3629200.0 |
| 2003-04-22 12:30:00 | SPY | ETF | 90.64 | 90.83 | 90.55 | 90.72 | 2136500.0 |
| 2003-04-22 13:00:00 | SPY | ETF | 90.72 | 91.11 | 90.69 | 90.87 | 3673700.0 |
| 2003-04-22 13:30:00 | SPY | ETF | 90.87 | 91.01 | 90.8 | 90.97 | 1286700.0 |
| 2003-04-22 14:00:00 | SPY | ETF | 91.01 | 91.31 | 90.97 | 91.26 | 3392000.0 |
| 2003-04-22 14:30:00 | SPY | ETF | 91.25 | 91.48 | 91.2 | 91.43 | 4216700.0 |
| 2003-04-22 15:00:00 | SPY | ETF | 91.43 | 91.55 | 91.25 | 91.5 | 3761300.0 |
| 2003-04-22 15:30:00 | SPY | ETF | 91.48 | 91.56 | 91.24 | 91.51 | 5412200.0 |
| 2003-04-22 16:00:00 | SPY | ETF | 91.48 | 91.55 | 90.7 | 91.34 | 2425900.0 |
| 2003-04-22 16:30:00 | SPY | ETF | 91.42 | 91.56 | 91.38 | 91.56 | 991300.0 |
| 2003-04-22 17:00:00 | SPY | ETF | 91.53 | 91.58 | 91.52 | 91.55 | 57400.0 |
| 2003-04-22 17:30:00 | SPY | ETF | 91.54 | 91.54 | 91.45 | 91.47 | 11500.0 |
| 2003-04-22 18:00:00 | SPY | ETF | 91.49 | 91.53 | 91.47 | 91.52 | 27300.0 |
| 2003-04-22 18:30:00 | SPY | ETF | 91.48 | 91.55 | 91.48 | 91.55 | 4100.0 |
| 2003-04-22 19:00:00 | SPY | ETF | 91.55 | 91.55 | 91.49 | 91.5 | 700.0 |
| 2003-04-22 19:30:00 | SPY | ETF | 91.55 | 91.6 | 91.47 | 91.47 | 4200.0 |
| 2003-04-22 08:00:00 | QQQ | ETF | 26.8 | 26.81 | 26.79 | 26.79 | 10900.0 |
| 2003-04-22 08:30:00 | QQQ | ETF | 26.79 | 26.8 | 26.75 | 26.8 | 31700.0 |
| 2003-04-22 09:00:00 | QQQ | ETF | 26.8 | 26.8 | 26.71 | 26.73 | 101300.0 |
| 2003-04-22 09:30:00 | QQQ | ETF | 26.73 | 26.79 | 26.65 | 26.7 | 7309900.0 |
| 2003-04-22 10:00:00 | QQQ | ETF | 26.72 | 26.85 | 26.66 | 26.84 | 5179100.0 |
| 2003-04-22 10:30:00 | QQQ | ETF | 26.84 | 27.14 | 26.82 | 27.06 | 8722200.0 |
| 2003-04-22 11:00:00 | QQQ | ETF | 27.05 | 27.13 | 26.9 | 26.91 | 3850200.0 |
| 2003-04-22 11:30:00 | QQQ | ETF | 26.91 | 27.07 | 26.87 | 27.05 | 3187900.0 |
| 2003-04-22 12:00:00 | QQQ | ETF | 27.04 | 27.19 | 27.01 | 27.15 | 3976500.0 |
| 2003-04-22 12:30:00 | QQQ | ETF | 27.15 | 27.27 | 27.11 | 27.18 | 3848300.0 |
| 2003-04-22 13:00:00 | QQQ | ETF | 27.18 | 27.29 | 27.17 | 27.2 | 3668700.0 |
| 2003-04-22 13:30:00 | QQQ | ETF | 27.22 | 27.24 | 27.15 | 27.22 | 2112400.0 |
| 2003-04-22 14:00:00 | QQQ | ETF | 27.22 | 27.34 | 27.22 | 27.3 | 3982800.0 |
| 2003-04-22 14:30:00 | QQQ | ETF | 27.3 | 27.44 | 27.27 | 27.4 | 4742400.0 |
| 2003-04-22 15:00:00 | QQQ | ETF | 27.39 | 27.46 | 27.32 | 27.43 | 2689000.0 |
| 2003-04-22 15:30:00 | QQQ | ETF | 27.45 | 27.46 | 27.32 | 27.4 | 5324900.0 |
| 2003-04-22 16:00:00 | QQQ | ETF | 27.39 | 27.43 | 27.35 | 27.41 | 1990100.0 |
| 2003-04-22 16:30:00 | QQQ | ETF | 27.41 | 27.51 | 27.41 | 27.46 | 274200.0 |
| 2003-04-22 17:00:00 | QQQ | ETF | 27.46 | 27.51 | 27.45 | 27.49 | 175200.0 |
| 2003-04-22 17:30:00 | QQQ | ETF | 27.5 | 27.51 | 27.45 | 27.5 | 58800.0 |
| 2003-04-22 18:00:00 | QQQ | ETF | 27.51 | 27.51 | 27.47 | 27.48 | 28600.0 |
| 2003-04-22 18:30:00 | QQQ | ETF | 27.47 | 27.5 | 27.47 | 27.5 | 6200.0 |
| 2003-04-22 19:00:00 | QQQ | ETF | 27.51 | 27.51 | 27.48 | 27.48 | 4300.0 |
| 2003-04-22 19:30:00 | QQQ | ETF | 27.49 | 27.5 | 27.47 | 27.5 | 21100.0 |
| 2003-04-22 09:30:00 | IWM | ETF | 38.1 | 38.395 | 38.1 | 38.375 | 192400.0 |
| 2003-04-22 10:00:00 | IWM | ETF | 38.325 | 38.45 | 38.27 | 38.45 | 181800.0 |
> showing 50 of 684 rows — these rows as CSV