PREVIEW / etf_30min / 2002-11-06
file: by_date/etf_30min/2002/2002-11-06.parquet size: 23 KB rows: 670
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-06 08:00:00 | SPY | ETF | 92.72 | 92.73 | 92.58 | 92.65 | 15600.0 |
| 2002-11-06 08:30:00 | SPY | ETF | 92.51 | 92.51 | 92.3 | 92.3 | 3300.0 |
| 2002-11-06 09:00:00 | SPY | ETF | 92.25 | 92.48 | 92.25 | 92.48 | 12900.0 |
| 2002-11-06 09:30:00 | SPY | ETF | 92.48 | 92.48 | 91.6 | 91.74 | 5594900.0 |
| 2002-11-06 10:00:00 | SPY | ETF | 91.7 | 92.23 | 91.64 | 92.16 | 3734700.0 |
| 2002-11-06 10:30:00 | SPY | ETF | 92.16 | 92.37 | 92.03 | 92.18 | 3031600.0 |
| 2002-11-06 11:00:00 | SPY | ETF | 92.13 | 92.28 | 91.94 | 92.16 | 1670200.0 |
| 2002-11-06 11:30:00 | SPY | ETF | 92.15 | 92.27 | 91.75 | 91.8 | 1713400.0 |
| 2002-11-06 12:00:00 | SPY | ETF | 91.8 | 91.87 | 91.4 | 91.6 | 2153300.0 |
| 2002-11-06 12:30:00 | SPY | ETF | 91.55 | 91.73 | 91.41 | 91.67 | 1358200.0 |
| 2002-11-06 13:00:00 | SPY | ETF | 91.66 | 91.78 | 91.57 | 91.65 | 1123200.0 |
| 2002-11-06 13:30:00 | SPY | ETF | 91.62 | 91.86 | 91.59 | 91.78 | 1446700.0 |
| 2002-11-06 14:00:00 | SPY | ETF | 91.76 | 92.9 | 91.65 | 92.0 | 12372100.0 |
| 2002-11-06 14:30:00 | SPY | ETF | 92.0 | 92.45 | 90.79 | 92.07 | 10462500.0 |
| 2002-11-06 15:00:00 | SPY | ETF | 92.0 | 92.68 | 91.87 | 92.29 | 5874400.0 |
| 2002-11-06 15:30:00 | SPY | ETF | 92.26 | 93.07 | 92.2 | 92.77 | 4954100.0 |
| 2002-11-06 16:00:00 | SPY | ETF | 92.79 | 93.1 | 92.2 | 93.1 | 3339600.0 |
| 2002-11-06 16:30:00 | SPY | ETF | 93.15 | 93.15 | 92.3 | 92.98 | 121600.0 |
| 2002-11-06 17:00:00 | SPY | ETF | 93.04 | 93.08 | 91.99 | 92.57 | 182700.0 |
| 2002-11-06 17:30:00 | SPY | ETF | 92.6 | 92.67 | 92.52 | 92.57 | 233700.0 |
| 2002-11-06 18:00:00 | SPY | ETF | 92.55 | 92.63 | 92.4 | 92.57 | 78600.0 |
| 2002-11-06 08:00:00 | QQQ | ETF | 26.52 | 26.52 | 26.41 | 26.41 | 9800.0 |
| 2002-11-06 08:30:00 | QQQ | ETF | 26.41 | 26.41 | 26.22 | 26.22 | 18900.0 |
| 2002-11-06 09:00:00 | QQQ | ETF | 26.22 | 26.34 | 26.22 | 26.3 | 68800.0 |
| 2002-11-06 09:30:00 | QQQ | ETF | 26.29 | 26.36 | 25.91 | 25.96 | 13020300.0 |
| 2002-11-06 10:00:00 | QQQ | ETF | 25.95 | 26.27 | 25.89 | 26.22 | 8236500.0 |
| 2002-11-06 10:30:00 | QQQ | ETF | 26.21 | 26.3 | 26.1 | 26.15 | 4189300.0 |
| 2002-11-06 11:00:00 | QQQ | ETF | 26.16 | 26.29 | 26.09 | 26.22 | 2361500.0 |
| 2002-11-06 11:30:00 | QQQ | ETF | 26.22 | 26.26 | 26.03 | 26.06 | 3285700.0 |
| 2002-11-06 12:00:00 | QQQ | ETF | 26.06 | 26.07 | 25.87 | 25.95 | 3438900.0 |
| 2002-11-06 12:30:00 | QQQ | ETF | 25.95 | 26.03 | 25.92 | 25.97 | 1720800.0 |
| 2002-11-06 13:00:00 | QQQ | ETF | 25.99 | 26.06 | 25.95 | 26.0 | 1956500.0 |
| 2002-11-06 13:30:00 | QQQ | ETF | 26.0 | 26.08 | 25.92 | 25.98 | 4439400.0 |
| 2002-11-06 14:00:00 | QQQ | ETF | 25.99 | 26.42 | 25.96 | 26.14 | 22439900.0 |
| 2002-11-06 14:30:00 | QQQ | ETF | 26.12 | 26.32 | 25.64 | 26.16 | 16530600.0 |
| 2002-11-06 15:00:00 | QQQ | ETF | 26.21 | 26.4 | 26.11 | 26.29 | 10509400.0 |
| 2002-11-06 15:30:00 | QQQ | ETF | 26.27 | 26.5 | 26.22 | 26.48 | 9539400.0 |
| 2002-11-06 16:00:00 | QQQ | ETF | 26.47 | 26.65 | 26.01 | 26.64 | 5069900.0 |
| 2002-11-06 16:30:00 | QQQ | ETF | 26.66 | 26.7 | 26.07 | 26.62 | 696200.0 |
| 2002-11-06 17:00:00 | QQQ | ETF | 26.65 | 26.7 | 25.23 | 26.29 | 1372900.0 |
| 2002-11-06 17:30:00 | QQQ | ETF | 26.32 | 26.47 | 26.18 | 26.33 | 664500.0 |
| 2002-11-06 18:00:00 | QQQ | ETF | 26.32 | 26.33 | 26.2 | 26.3 | 176100.0 |
| 2002-11-06 19:30:00 | QQQ | ETF | 26.23 | 26.23 | 26.23 | 26.23 | 100.0 |
| 2002-11-06 09:30:00 | IWM | ETF | 38.85 | 38.875 | 38.525 | 38.55 | 147200.0 |
| 2002-11-06 10:00:00 | IWM | ETF | 38.55 | 38.995 | 38.55 | 38.985 | 91800.0 |
| 2002-11-06 10:30:00 | IWM | ETF | 38.985 | 39.115 | 38.95 | 39.035 | 116600.0 |
| 2002-11-06 11:00:00 | IWM | ETF | 39.03 | 39.03 | 38.98 | 38.98 | 67200.0 |
| 2002-11-06 11:30:00 | IWM | ETF | 38.985 | 39.005 | 38.86 | 38.86 | 73600.0 |
| 2002-11-06 12:00:00 | IWM | ETF | 38.87 | 38.88 | 38.725 | 38.8 | 68000.0 |
| 2002-11-06 12:30:00 | IWM | ETF | 38.82 | 38.86 | 38.75 | 38.845 | 70200.0 |
> showing 50 of 670 rows — these rows as CSV