PREVIEW / etf_30min / 2003-01-31
file: by_date/etf_30min/2003/2003-01-31.parquet size: 21 KB rows: 617
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-01-31 08:00:00 | SPY | ETF | 84.91 | 84.91 | 84.67 | 84.76 | 31300.0 |
| 2003-01-31 08:30:00 | SPY | ETF | 84.85 | 84.99 | 84.8 | 84.83 | 25500.0 |
| 2003-01-31 09:00:00 | SPY | ETF | 84.81 | 84.89 | 84.14 | 84.14 | 75800.0 |
| 2003-01-31 09:30:00 | SPY | ETF | 84.15 | 85.37 | 84.15 | 85.14 | 8154600.0 |
| 2003-01-31 10:00:00 | SPY | ETF | 85.34 | 85.7 | 84.65 | 84.76 | 7308200.0 |
| 2003-01-31 10:30:00 | SPY | ETF | 84.76 | 85.15 | 84.6 | 85.14 | 2757700.0 |
| 2003-01-31 11:00:00 | SPY | ETF | 85.14 | 85.3 | 84.76 | 85.18 | 1747900.0 |
| 2003-01-31 11:30:00 | SPY | ETF | 85.16 | 85.7 | 85.11 | 85.47 | 2636800.0 |
| 2003-01-31 12:00:00 | SPY | ETF | 85.46 | 85.89 | 85.26 | 85.75 | 1992700.0 |
| 2003-01-31 12:30:00 | SPY | ETF | 85.74 | 86.07 | 85.67 | 85.71 | 1995400.0 |
| 2003-01-31 13:00:00 | SPY | ETF | 85.7 | 86.12 | 85.62 | 86.0 | 1534700.0 |
| 2003-01-31 13:30:00 | SPY | ETF | 85.99 | 86.14 | 85.62 | 85.76 | 2244100.0 |
| 2003-01-31 14:00:00 | SPY | ETF | 85.76 | 86.21 | 85.65 | 86.07 | 3513100.0 |
| 2003-01-31 14:30:00 | SPY | ETF | 86.08 | 86.16 | 85.8 | 85.83 | 2006600.0 |
| 2003-01-31 15:00:00 | SPY | ETF | 85.82 | 85.97 | 85.28 | 85.31 | 3026100.0 |
| 2003-01-31 15:30:00 | SPY | ETF | 85.32 | 86.0 | 85.16 | 85.81 | 4267800.0 |
| 2003-01-31 16:00:00 | SPY | ETF | 85.81 | 86.1 | 85.76 | 86.04 | 3275300.0 |
| 2003-01-31 16:30:00 | SPY | ETF | 86.03 | 86.15 | 85.49 | 86.0 | 306800.0 |
| 2003-01-31 17:00:00 | SPY | ETF | 86.0 | 86.0 | 85.9 | 85.99 | 5400.0 |
| 2003-01-31 17:30:00 | SPY | ETF | 86.05 | 86.12 | 86.05 | 86.12 | 4500.0 |
| 2003-01-31 18:00:00 | SPY | ETF | 86.1 | 86.1 | 86.1 | 86.1 | 100.0 |
| 2003-01-31 18:30:00 | SPY | ETF | 86.1 | 86.1 | 86.1 | 86.1 | 300.0 |
| 2003-01-31 19:30:00 | SPY | ETF | 86.05 | 86.05 | 86.04 | 86.04 | 1100.0 |
| 2003-01-31 08:00:00 | QQQ | ETF | 24.57 | 24.57 | 24.48 | 24.53 | 50500.0 |
| 2003-01-31 08:30:00 | QQQ | ETF | 24.53 | 24.6 | 24.53 | 24.55 | 103800.0 |
| 2003-01-31 09:00:00 | QQQ | ETF | 24.54 | 24.63 | 24.08 | 24.08 | 283500.0 |
| 2003-01-31 09:30:00 | QQQ | ETF | 24.06 | 24.46 | 24.01 | 24.35 | 16420700.0 |
| 2003-01-31 10:00:00 | QQQ | ETF | 24.42 | 24.5 | 24.11 | 24.18 | 9345400.0 |
| 2003-01-31 10:30:00 | QQQ | ETF | 24.17 | 24.34 | 24.05 | 24.32 | 7098700.0 |
| 2003-01-31 11:00:00 | QQQ | ETF | 24.32 | 24.37 | 24.17 | 24.34 | 4109900.0 |
| 2003-01-31 11:30:00 | QQQ | ETF | 24.33 | 24.63 | 24.31 | 24.54 | 6162800.0 |
| 2003-01-31 12:00:00 | QQQ | ETF | 24.54 | 24.7 | 24.37 | 24.62 | 6045300.0 |
| 2003-01-31 12:30:00 | QQQ | ETF | 24.6 | 24.75 | 24.6 | 24.62 | 3965300.0 |
| 2003-01-31 13:00:00 | QQQ | ETF | 24.62 | 24.76 | 24.58 | 24.71 | 2627200.0 |
| 2003-01-31 13:30:00 | QQQ | ETF | 24.7 | 24.73 | 24.49 | 24.56 | 3716900.0 |
| 2003-01-31 14:00:00 | QQQ | ETF | 24.58 | 24.68 | 24.49 | 24.62 | 2151600.0 |
| 2003-01-31 14:30:00 | QQQ | ETF | 24.6 | 24.66 | 24.52 | 24.57 | 1774100.0 |
| 2003-01-31 15:00:00 | QQQ | ETF | 24.57 | 24.6 | 24.34 | 24.39 | 4733500.0 |
| 2003-01-31 15:30:00 | QQQ | ETF | 24.38 | 24.49 | 24.26 | 24.41 | 8548300.0 |
| 2003-01-31 16:00:00 | QQQ | ETF | 24.4 | 24.5 | 24.36 | 24.43 | 2437900.0 |
| 2003-01-31 16:30:00 | QQQ | ETF | 24.43 | 24.48 | 24.4 | 24.46 | 117700.0 |
| 2003-01-31 17:00:00 | QQQ | ETF | 24.48 | 24.5 | 24.42 | 24.44 | 38000.0 |
| 2003-01-31 17:30:00 | QQQ | ETF | 24.44 | 24.5 | 24.44 | 24.49 | 28300.0 |
| 2003-01-31 18:00:00 | QQQ | ETF | 24.49 | 24.5 | 24.49 | 24.5 | 5200.0 |
| 2003-01-31 18:30:00 | QQQ | ETF | 24.5 | 24.5 | 24.47 | 24.47 | 2700.0 |
| 2003-01-31 19:00:00 | QQQ | ETF | 24.49 | 24.5 | 24.49 | 24.5 | 2100.0 |
| 2003-01-31 19:30:00 | QQQ | ETF | 24.5 | 24.5 | 24.45 | 24.46 | 7800.0 |
| 2003-01-31 09:30:00 | IWM | ETF | 36.425 | 36.74 | 36.325 | 36.68 | 348800.0 |
| 2003-01-31 10:00:00 | IWM | ETF | 36.775 | 36.85 | 36.51 | 36.565 | 328400.0 |
| 2003-01-31 10:30:00 | IWM | ETF | 36.515 | 36.65 | 36.51 | 36.645 | 150400.0 |
> showing 50 of 617 rows — these rows as CSV