PREVIEW / etf_30min / 2002-11-07
file: by_date/etf_30min/2002/2002-11-07.parquet size: 22 KB rows: 634
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 |
|---|---|---|---|---|---|---|---|
| 2002-11-07 08:00:00 | SPY | ETF | 92.29 | 92.29 | 92.0 | 92.0 | 3200.0 |
| 2002-11-07 08:30:00 | SPY | ETF | 92.14 | 92.14 | 91.85 | 92.06 | 7200.0 |
| 2002-11-07 09:00:00 | SPY | ETF | 92.02 | 92.02 | 91.93 | 91.93 | 4200.0 |
| 2002-11-07 09:30:00 | SPY | ETF | 92.02 | 92.22 | 91.42 | 91.6 | 5374300.0 |
| 2002-11-07 10:00:00 | SPY | ETF | 91.6 | 91.91 | 91.35 | 91.56 | 3873000.0 |
| 2002-11-07 10:30:00 | SPY | ETF | 91.56 | 91.69 | 91.18 | 91.25 | 2672000.0 |
| 2002-11-07 11:00:00 | SPY | ETF | 91.24 | 91.44 | 91.05 | 91.16 | 2432700.0 |
| 2002-11-07 11:30:00 | SPY | ETF | 91.18 | 91.18 | 90.79 | 90.91 | 4653700.0 |
| 2002-11-07 12:00:00 | SPY | ETF | 90.89 | 90.99 | 90.35 | 90.65 | 3892000.0 |
| 2002-11-07 12:30:00 | SPY | ETF | 90.66 | 90.97 | 90.56 | 90.81 | 1214800.0 |
| 2002-11-07 13:00:00 | SPY | ETF | 90.8 | 90.98 | 90.62 | 90.78 | 1041600.0 |
| 2002-11-07 13:30:00 | SPY | ETF | 90.76 | 91.08 | 90.66 | 90.9 | 1327800.0 |
| 2002-11-07 14:00:00 | SPY | ETF | 90.9 | 91.26 | 90.75 | 91.15 | 2440700.0 |
| 2002-11-07 14:30:00 | SPY | ETF | 91.15 | 91.2 | 90.55 | 90.65 | 1993500.0 |
| 2002-11-07 15:00:00 | SPY | ETF | 90.63 | 90.88 | 90.4 | 90.68 | 3909500.0 |
| 2002-11-07 15:30:00 | SPY | ETF | 90.66 | 90.71 | 90.22 | 90.57 | 4575600.0 |
| 2002-11-07 16:00:00 | SPY | ETF | 90.61 | 90.85 | 90.5 | 90.75 | 2795900.0 |
| 2002-11-07 16:30:00 | SPY | ETF | 90.8 | 90.96 | 90.59 | 90.81 | 652800.0 |
| 2002-11-07 17:00:00 | SPY | ETF | 90.81 | 90.84 | 90.76 | 90.84 | 420100.0 |
| 2002-11-07 17:30:00 | SPY | ETF | 90.85 | 90.85 | 90.78 | 90.84 | 2700.0 |
| 2002-11-07 18:00:00 | SPY | ETF | 90.84 | 90.9 | 90.84 | 90.9 | 7500.0 |
| 2002-11-07 18:30:00 | SPY | ETF | 90.85 | 90.85 | 90.8 | 90.8 | 300.0 |
| 2002-11-07 19:00:00 | SPY | ETF | 90.88 | 90.88 | 90.88 | 90.88 | 100.0 |
| 2002-11-07 08:00:00 | QQQ | ETF | 26.17 | 26.17 | 26.0 | 26.0 | 34700.0 |
| 2002-11-07 08:30:00 | QQQ | ETF | 26.0 | 26.0 | 25.9 | 25.94 | 16100.0 |
| 2002-11-07 09:00:00 | QQQ | ETF | 25.94 | 26.0 | 25.93 | 25.98 | 34400.0 |
| 2002-11-07 09:30:00 | QQQ | ETF | 25.99 | 26.05 | 25.8 | 25.93 | 13902900.0 |
| 2002-11-07 10:00:00 | QQQ | ETF | 25.92 | 26.1 | 25.82 | 25.97 | 7393300.0 |
| 2002-11-07 10:30:00 | QQQ | ETF | 25.95 | 25.99 | 25.71 | 25.72 | 6581000.0 |
| 2002-11-07 11:00:00 | QQQ | ETF | 25.72 | 25.76 | 25.6 | 25.62 | 6409300.0 |
| 2002-11-07 11:30:00 | QQQ | ETF | 25.6 | 25.69 | 25.5 | 25.57 | 5710800.0 |
| 2002-11-07 12:00:00 | QQQ | ETF | 25.59 | 25.6 | 25.45 | 25.54 | 4441800.0 |
| 2002-11-07 12:30:00 | QQQ | ETF | 25.54 | 25.65 | 25.47 | 25.57 | 2833300.0 |
| 2002-11-07 13:00:00 | QQQ | ETF | 25.56 | 25.62 | 25.5 | 25.6 | 1671400.0 |
| 2002-11-07 13:30:00 | QQQ | ETF | 25.6 | 25.7 | 25.51 | 25.64 | 3035700.0 |
| 2002-11-07 14:00:00 | QQQ | ETF | 25.64 | 25.76 | 25.56 | 25.7 | 3978900.0 |
| 2002-11-07 14:30:00 | QQQ | ETF | 25.7 | 25.72 | 25.46 | 25.5 | 3603000.0 |
| 2002-11-07 15:00:00 | QQQ | ETF | 25.49 | 25.56 | 25.42 | 25.47 | 4713300.0 |
| 2002-11-07 15:30:00 | QQQ | ETF | 25.46 | 25.52 | 25.31 | 25.49 | 9462200.0 |
| 2002-11-07 16:00:00 | QQQ | ETF | 25.49 | 25.62 | 25.42 | 25.54 | 2333800.0 |
| 2002-11-07 16:30:00 | QQQ | ETF | 25.54 | 25.72 | 25.42 | 25.63 | 991300.0 |
| 2002-11-07 17:00:00 | QQQ | ETF | 25.6 | 25.65 | 25.57 | 25.61 | 67700.0 |
| 2002-11-07 17:30:00 | QQQ | ETF | 25.63 | 25.64 | 25.57 | 25.57 | 58800.0 |
| 2002-11-07 18:00:00 | QQQ | ETF | 25.6 | 25.64 | 25.55 | 25.57 | 33600.0 |
| 2002-11-07 18:30:00 | QQQ | ETF | 25.57 | 25.57 | 25.56 | 25.57 | 4500.0 |
| 2002-11-07 19:30:00 | QQQ | ETF | 25.56 | 25.56 | 25.56 | 25.56 | 100.0 |
| 2002-11-07 09:30:00 | IWM | ETF | 38.925 | 38.925 | 38.58 | 38.605 | 268400.0 |
| 2002-11-07 10:00:00 | IWM | ETF | 38.575 | 38.65 | 38.45 | 38.555 | 107000.0 |
| 2002-11-07 10:30:00 | IWM | ETF | 38.545 | 38.615 | 38.42 | 38.5 | 106400.0 |
| 2002-11-07 11:00:00 | IWM | ETF | 38.42 | 38.53 | 38.4 | 38.43 | 81400.0 |
> showing 50 of 634 rows — these rows as CSV