PREVIEW / etf_30min / 2002-11-20
file: by_date/etf_30min/2002/2002-11-20.parquet size: 22 KB rows: 636
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-20 08:30:00 | SPY | ETF | 90.11 | 90.11 | 89.95 | 89.96 | 27100.0 |
| 2002-11-20 09:00:00 | SPY | ETF | 89.99 | 90.1 | 89.99 | 90.01 | 4700.0 |
| 2002-11-20 09:30:00 | SPY | ETF | 89.98 | 90.33 | 89.95 | 90.14 | 3872800.0 |
| 2002-11-20 10:00:00 | SPY | ETF | 90.18 | 90.82 | 90.18 | 90.73 | 3719100.0 |
| 2002-11-20 10:30:00 | SPY | ETF | 90.74 | 90.94 | 90.53 | 90.79 | 2442800.0 |
| 2002-11-20 11:00:00 | SPY | ETF | 90.8 | 90.99 | 90.63 | 90.73 | 1499300.0 |
| 2002-11-20 11:30:00 | SPY | ETF | 90.72 | 91.34 | 90.72 | 91.26 | 2382100.0 |
| 2002-11-20 12:00:00 | SPY | ETF | 91.35 | 91.52 | 91.2 | 91.31 | 2148900.0 |
| 2002-11-20 12:30:00 | SPY | ETF | 91.36 | 91.62 | 91.27 | 91.35 | 1778800.0 |
| 2002-11-20 13:00:00 | SPY | ETF | 91.35 | 91.88 | 91.31 | 91.76 | 1949000.0 |
| 2002-11-20 13:30:00 | SPY | ETF | 91.75 | 91.95 | 91.58 | 91.7 | 1406100.0 |
| 2002-11-20 14:00:00 | SPY | ETF | 91.7 | 92.01 | 91.68 | 91.89 | 1932200.0 |
| 2002-11-20 14:30:00 | SPY | ETF | 91.89 | 92.07 | 91.65 | 91.95 | 2297400.0 |
| 2002-11-20 15:00:00 | SPY | ETF | 91.95 | 91.99 | 91.35 | 91.37 | 2060000.0 |
| 2002-11-20 15:30:00 | SPY | ETF | 91.4 | 91.98 | 91.23 | 91.94 | 4661200.0 |
| 2002-11-20 16:00:00 | SPY | ETF | 91.95 | 92.42 | 91.59 | 92.35 | 2155000.0 |
| 2002-11-20 16:30:00 | SPY | ETF | 92.37 | 92.65 | 92.3 | 92.37 | 57600.0 |
| 2002-11-20 17:00:00 | SPY | ETF | 92.39 | 92.42 | 92.33 | 92.38 | 371800.0 |
| 2002-11-20 17:30:00 | SPY | ETF | 92.42 | 92.42 | 92.36 | 92.41 | 3300.0 |
| 2002-11-20 18:00:00 | SPY | ETF | 92.42 | 92.5 | 92.38 | 92.5 | 4400.0 |
| 2002-11-20 18:30:00 | SPY | ETF | 92.6 | 92.6 | 92.6 | 92.6 | 800.0 |
| 2002-11-20 19:00:00 | SPY | ETF | 92.51 | 92.52 | 92.51 | 92.52 | 2000.0 |
| 2002-11-20 19:30:00 | SPY | ETF | 92.55 | 92.55 | 92.48 | 92.55 | 5400.0 |
| 2002-11-20 08:00:00 | QQQ | ETF | 25.63 | 25.65 | 25.62 | 25.65 | 14500.0 |
| 2002-11-20 08:30:00 | QQQ | ETF | 25.65 | 25.66 | 25.56 | 25.59 | 48400.0 |
| 2002-11-20 09:00:00 | QQQ | ETF | 25.59 | 25.63 | 25.59 | 25.59 | 15800.0 |
| 2002-11-20 09:30:00 | QQQ | ETF | 25.56 | 25.8 | 25.54 | 25.74 | 7649600.0 |
| 2002-11-20 10:00:00 | QQQ | ETF | 25.74 | 26.04 | 25.72 | 26.0 | 6702100.0 |
| 2002-11-20 10:30:00 | QQQ | ETF | 26.01 | 26.18 | 25.94 | 26.11 | 5816900.0 |
| 2002-11-20 11:00:00 | QQQ | ETF | 26.12 | 26.22 | 26.05 | 26.1 | 3413100.0 |
| 2002-11-20 11:30:00 | QQQ | ETF | 26.1 | 26.3 | 26.08 | 26.28 | 3372300.0 |
| 2002-11-20 12:00:00 | QQQ | ETF | 26.26 | 26.42 | 26.21 | 26.32 | 4459400.0 |
| 2002-11-20 12:30:00 | QQQ | ETF | 26.31 | 26.49 | 26.3 | 26.37 | 4995900.0 |
| 2002-11-20 13:00:00 | QQQ | ETF | 26.37 | 26.55 | 26.36 | 26.5 | 4797200.0 |
| 2002-11-20 13:30:00 | QQQ | ETF | 26.46 | 26.52 | 26.37 | 26.47 | 3795100.0 |
| 2002-11-20 14:00:00 | QQQ | ETF | 26.47 | 26.6 | 26.45 | 26.58 | 3767100.0 |
| 2002-11-20 14:30:00 | QQQ | ETF | 26.56 | 26.66 | 26.5 | 26.59 | 4714600.0 |
| 2002-11-20 15:00:00 | QQQ | ETF | 26.59 | 26.64 | 26.41 | 26.45 | 4083900.0 |
| 2002-11-20 15:30:00 | QQQ | ETF | 26.45 | 26.67 | 26.35 | 26.65 | 7278000.0 |
| 2002-11-20 16:00:00 | QQQ | ETF | 26.62 | 26.85 | 26.62 | 26.83 | 4429400.0 |
| 2002-11-20 16:30:00 | QQQ | ETF | 26.85 | 26.96 | 26.74 | 26.86 | 1119500.0 |
| 2002-11-20 17:00:00 | QQQ | ETF | 26.87 | 26.88 | 26.82 | 26.85 | 716700.0 |
| 2002-11-20 17:30:00 | QQQ | ETF | 26.84 | 26.91 | 26.84 | 26.9 | 144500.0 |
| 2002-11-20 18:00:00 | QQQ | ETF | 26.9 | 26.97 | 26.88 | 26.92 | 49300.0 |
| 2002-11-20 18:30:00 | QQQ | ETF | 26.94 | 26.97 | 26.93 | 26.96 | 23500.0 |
| 2002-11-20 19:00:00 | QQQ | ETF | 26.95 | 26.96 | 26.93 | 26.94 | 15700.0 |
| 2002-11-20 19:30:00 | QQQ | ETF | 26.93 | 26.94 | 26.92 | 26.92 | 2300.0 |
| 2002-11-20 09:30:00 | IWM | ETF | 37.85 | 38.07 | 37.76 | 38.0 | 252200.0 |
| 2002-11-20 10:00:00 | IWM | ETF | 38.07 | 38.29 | 38.03 | 38.275 | 98800.0 |
| 2002-11-20 10:30:00 | IWM | ETF | 38.3 | 38.44 | 38.235 | 38.4 | 123800.0 |
> showing 50 of 636 rows — these rows as CSV