PREVIEW / etf_30min / 2004-10-07
file: by_date/etf_30min/2004/2004-10-07.parquet size: 36 KB rows: 1,202
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-07 08:00:00 | SPY | ETF | 114.4 | 114.4 | 114.35 | 114.37 | 13600.0 |
| 2004-10-07 08:30:00 | SPY | ETF | 114.39 | 114.5 | 114.39 | 114.45 | 55100.0 |
| 2004-10-07 09:00:00 | SPY | ETF | 114.43 | 114.43 | 114.32 | 114.38 | 16000.0 |
| 2004-10-07 09:30:00 | SPY | ETF | 114.38 | 114.4 | 114.17 | 114.24 | 4032400.0 |
| 2004-10-07 10:00:00 | SPY | ETF | 114.23 | 114.24 | 114.06 | 114.18 | 3319000.0 |
| 2004-10-07 10:30:00 | SPY | ETF | 114.18 | 114.27 | 114.09 | 114.12 | 2304800.0 |
| 2004-10-07 11:00:00 | SPY | ETF | 114.11 | 114.13 | 113.8 | 113.83 | 3964400.0 |
| 2004-10-07 11:30:00 | SPY | ETF | 113.83 | 113.86 | 113.73 | 113.82 | 2296900.0 |
| 2004-10-07 12:00:00 | SPY | ETF | 113.83 | 113.92 | 113.78 | 113.85 | 1061500.0 |
| 2004-10-07 12:30:00 | SPY | ETF | 113.84 | 113.84 | 113.59 | 113.74 | 3116700.0 |
| 2004-10-07 13:00:00 | SPY | ETF | 113.75 | 113.77 | 113.66 | 113.71 | 1401600.0 |
| 2004-10-07 13:30:00 | SPY | ETF | 113.7 | 113.86 | 113.7 | 113.81 | 1994200.0 |
| 2004-10-07 14:00:00 | SPY | ETF | 113.81 | 113.97 | 113.8 | 113.91 | 2081000.0 |
| 2004-10-07 14:30:00 | SPY | ETF | 113.91 | 113.94 | 113.79 | 113.81 | 1501500.0 |
| 2004-10-07 15:00:00 | SPY | ETF | 113.82 | 113.83 | 113.5 | 113.5 | 3191200.0 |
| 2004-10-07 15:30:00 | SPY | ETF | 113.51 | 113.65 | 113.36 | 113.38 | 4032600.0 |
| 2004-10-07 16:00:00 | SPY | ETF | 113.38 | 113.51 | 113.38 | 113.48 | 1685300.0 |
| 2004-10-07 16:30:00 | SPY | ETF | 113.48 | 114.5848 | 113.43 | 113.45 | 2029300.0 |
| 2004-10-07 17:00:00 | SPY | ETF | 113.45 | 113.47 | 113.42 | 113.47 | 12000.0 |
| 2004-10-07 17:30:00 | SPY | ETF | 113.43 | 113.45 | 113.43 | 113.45 | 1500.0 |
| 2004-10-07 18:00:00 | SPY | ETF | 113.47 | 113.48 | 113.43 | 113.43 | 5500.0 |
| 2004-10-07 18:30:00 | SPY | ETF | 113.44 | 113.44 | 113.43 | 113.43 | 2000.0 |
| 2004-10-07 19:30:00 | SPY | ETF | 113.49 | 113.49 | 113.49 | 113.49 | 300.0 |
| 2004-10-07 08:00:00 | QQQ | ETF | 36.55 | 36.56 | 36.54 | 36.55 | 39000.0 |
| 2004-10-07 08:30:00 | QQQ | ETF | 36.56 | 36.63 | 36.56 | 36.61 | 117300.0 |
| 2004-10-07 09:00:00 | QQQ | ETF | 36.59 | 36.6 | 36.5 | 36.53 | 427200.0 |
| 2004-10-07 09:30:00 | QQQ | ETF | 36.54 | 36.641 | 36.5 | 36.56 | 11666300.0 |
| 2004-10-07 10:00:00 | QQQ | ETF | 36.56 | 36.65 | 36.47 | 36.61 | 6836400.0 |
| 2004-10-07 10:30:00 | QQQ | ETF | 36.61 | 36.67 | 36.52 | 36.55 | 5951000.0 |
| 2004-10-07 11:00:00 | QQQ | ETF | 36.54 | 36.56 | 36.38 | 36.41 | 10526700.0 |
| 2004-10-07 11:30:00 | QQQ | ETF | 36.41 | 36.412 | 36.33 | 36.4 | 6350400.0 |
| 2004-10-07 12:00:00 | QQQ | ETF | 36.4 | 36.47 | 36.39 | 36.42 | 2410100.0 |
| 2004-10-07 12:30:00 | QQQ | ETF | 36.42 | 36.42 | 36.31 | 36.36 | 5381400.0 |
| 2004-10-07 13:00:00 | QQQ | ETF | 36.36 | 36.4 | 36.34 | 36.359 | 2189000.0 |
| 2004-10-07 13:30:00 | QQQ | ETF | 36.354 | 36.47 | 36.34 | 36.41 | 4090100.0 |
| 2004-10-07 14:00:00 | QQQ | ETF | 36.4 | 36.5 | 36.4 | 36.444 | 3528900.0 |
| 2004-10-07 14:30:00 | QQQ | ETF | 36.45 | 36.461 | 36.38 | 36.392 | 3324200.0 |
| 2004-10-07 15:00:00 | QQQ | ETF | 36.393 | 36.41 | 36.23 | 36.24 | 7579900.0 |
| 2004-10-07 15:30:00 | QQQ | ETF | 36.25 | 36.33 | 36.17 | 36.207 | 8113900.0 |
| 2004-10-07 16:00:00 | QQQ | ETF | 36.206 | 36.295 | 36.17 | 36.24 | 1863800.0 |
| 2004-10-07 16:30:00 | QQQ | ETF | 36.259 | 36.298 | 36.25 | 36.29 | 211100.0 |
| 2004-10-07 17:00:00 | QQQ | ETF | 36.28 | 36.29 | 36.26 | 36.29 | 18800.0 |
| 2004-10-07 17:30:00 | QQQ | ETF | 36.28 | 36.3 | 36.24 | 36.24 | 15300.0 |
| 2004-10-07 18:00:00 | QQQ | ETF | 36.24 | 36.27 | 36.21 | 36.21 | 62900.0 |
| 2004-10-07 18:30:00 | QQQ | ETF | 36.25 | 36.25 | 36.25 | 36.25 | 3400.0 |
| 2004-10-07 19:00:00 | QQQ | ETF | 36.25 | 36.25 | 36.25 | 36.25 | 4000.0 |
| 2004-10-07 19:30:00 | QQQ | ETF | 36.25 | 36.25 | 36.25 | 36.25 | 8600.0 |
| 2004-10-07 09:00:00 | IWM | ETF | 58.925 | 58.925 | 58.875 | 58.915 | 3400.0 |
| 2004-10-07 09:30:00 | IWM | ETF | 58.875 | 58.935 | 58.77 | 58.845 | 1246200.0 |
| 2004-10-07 10:00:00 | IWM | ETF | 58.835 | 58.88 | 58.69 | 58.785 | 557200.0 |
> showing 50 of 1,202 rows — these rows as CSV