PREVIEW / etf_30min / 2003-07-10
file: by_date/etf_30min/2003/2003-07-10.parquet size: 24 KB rows: 699
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-07-10 08:00:00 | SPY | ETF | 100.06 | 100.1 | 99.97 | 100.07 | 15900.0 |
| 2003-07-10 08:30:00 | SPY | ETF | 100.03 | 100.03 | 99.77 | 99.83 | 70200.0 |
| 2003-07-10 09:00:00 | SPY | ETF | 99.83 | 99.83 | 99.79 | 99.83 | 9400.0 |
| 2003-07-10 09:30:00 | SPY | ETF | 99.84 | 100.04 | 99.66 | 99.74 | 5407900.0 |
| 2003-07-10 10:00:00 | SPY | ETF | 99.71 | 99.86 | 99.51 | 99.63 | 3826200.0 |
| 2003-07-10 10:30:00 | SPY | ETF | 99.625 | 99.8 | 99.32 | 99.5 | 3395000.0 |
| 2003-07-10 11:00:00 | SPY | ETF | 99.52 | 99.65 | 99.44 | 99.6 | 2258800.0 |
| 2003-07-10 11:30:00 | SPY | ETF | 99.6 | 99.64 | 99.0 | 99.04 | 5745800.0 |
| 2003-07-10 12:00:00 | SPY | ETF | 99.05 | 99.23 | 99.0 | 99.16 | 2143300.0 |
| 2003-07-10 12:30:00 | SPY | ETF | 99.17 | 99.21 | 98.8 | 98.83 | 4268800.0 |
| 2003-07-10 13:00:00 | SPY | ETF | 98.85 | 99.03 | 98.75 | 98.98 | 2802700.0 |
| 2003-07-10 13:30:00 | SPY | ETF | 98.97 | 99.06 | 98.85 | 98.96 | 1998600.0 |
| 2003-07-10 14:00:00 | SPY | ETF | 98.9 | 98.98 | 98.67 | 98.8 | 1329800.0 |
| 2003-07-10 14:30:00 | SPY | ETF | 98.8 | 98.93 | 98.63 | 98.84 | 2639900.0 |
| 2003-07-10 15:00:00 | SPY | ETF | 98.83 | 99.14 | 98.797 | 99.05 | 3460400.0 |
| 2003-07-10 15:30:00 | SPY | ETF | 99.056 | 99.32 | 98.95 | 99.22 | 3115900.0 |
| 2003-07-10 16:00:00 | SPY | ETF | 99.22 | 99.34 | 99.15 | 99.25 | 1862100.0 |
| 2003-07-10 16:30:00 | SPY | ETF | 99.3 | 99.33 | 99.24 | 99.31 | 27900.0 |
| 2003-07-10 17:00:00 | SPY | ETF | 99.31 | 99.33 | 99.19 | 99.24 | 86000.0 |
| 2003-07-10 17:30:00 | SPY | ETF | 99.22 | 99.25 | 99.18 | 99.18 | 34000.0 |
| 2003-07-10 18:00:00 | SPY | ETF | 99.19 | 99.2 | 99.16 | 99.163 | 8900.0 |
| 2003-07-10 18:30:00 | SPY | ETF | 99.18 | 99.26 | 99.18 | 99.26 | 2400.0 |
| 2003-07-10 19:00:00 | SPY | ETF | 99.3 | 99.33 | 99.25 | 99.3 | 34000.0 |
| 2003-07-10 08:00:00 | QQQ | ETF | 31.89 | 31.9 | 31.82 | 31.83 | 133100.0 |
| 2003-07-10 08:30:00 | QQQ | ETF | 31.84 | 31.84 | 31.74 | 31.8 | 289400.0 |
| 2003-07-10 09:00:00 | QQQ | ETF | 31.8 | 31.84 | 31.8 | 31.83 | 57800.0 |
| 2003-07-10 09:30:00 | QQQ | ETF | 31.85 | 31.99 | 31.747 | 31.76 | 11420300.0 |
| 2003-07-10 10:00:00 | QQQ | ETF | 31.76 | 31.89 | 31.7 | 31.801 | 9252200.0 |
| 2003-07-10 10:30:00 | QQQ | ETF | 31.78 | 31.83 | 31.623 | 31.71 | 6787600.0 |
| 2003-07-10 11:00:00 | QQQ | ETF | 31.73 | 31.77 | 31.64 | 31.75 | 3629900.0 |
| 2003-07-10 11:30:00 | QQQ | ETF | 31.75 | 31.78 | 31.52 | 31.57 | 7985500.0 |
| 2003-07-10 12:00:00 | QQQ | ETF | 31.56 | 31.64 | 31.52 | 31.63 | 3383400.0 |
| 2003-07-10 12:30:00 | QQQ | ETF | 31.61 | 31.64 | 31.4 | 31.43 | 9115700.0 |
| 2003-07-10 13:00:00 | QQQ | ETF | 31.43 | 31.5 | 31.35 | 31.48 | 5881700.0 |
| 2003-07-10 13:30:00 | QQQ | ETF | 31.46 | 31.53 | 31.41 | 31.456 | 4978700.0 |
| 2003-07-10 14:00:00 | QQQ | ETF | 31.453 | 31.46 | 31.33 | 31.4 | 6009200.0 |
| 2003-07-10 14:30:00 | QQQ | ETF | 31.433 | 31.5 | 31.34 | 31.45 | 3638200.0 |
| 2003-07-10 15:00:00 | QQQ | ETF | 31.45 | 31.58 | 31.41 | 31.53 | 4985600.0 |
| 2003-07-10 15:30:00 | QQQ | ETF | 31.53 | 31.63 | 31.45 | 31.56 | 8240400.0 |
| 2003-07-10 16:00:00 | QQQ | ETF | 31.55 | 31.61 | 31.5 | 31.61 | 4402000.0 |
| 2003-07-10 16:30:00 | QQQ | ETF | 31.6 | 31.64 | 31.58 | 31.606 | 223000.0 |
| 2003-07-10 17:00:00 | QQQ | ETF | 31.606 | 31.61 | 31.46 | 31.49 | 764500.0 |
| 2003-07-10 17:30:00 | QQQ | ETF | 31.483 | 31.5 | 31.44 | 31.45 | 303600.0 |
| 2003-07-10 18:00:00 | QQQ | ETF | 31.45 | 31.47 | 31.44 | 31.45 | 36000.0 |
| 2003-07-10 18:30:00 | QQQ | ETF | 31.46 | 31.46 | 31.45 | 31.45 | 10000.0 |
| 2003-07-10 19:00:00 | QQQ | ETF | 31.48 | 31.5 | 31.48 | 31.49 | 2200.0 |
| 2003-07-10 19:30:00 | QQQ | ETF | 31.5 | 31.52 | 31.47 | 31.47 | 10500.0 |
| 2003-07-10 09:30:00 | IWM | ETF | 47.35 | 47.355 | 47.055 | 47.185 | 703000.0 |
| 2003-07-10 10:00:00 | IWM | ETF | 47.13 | 47.175 | 46.965 | 47.03 | 467800.0 |
| 2003-07-10 10:30:00 | IWM | ETF | 47.03 | 47.03 | 46.805 | 46.85 | 467000.0 |
> showing 50 of 699 rows — these rows as CSV