PREVIEW / etf_30min / 2002-11-27
file: by_date/etf_30min/2002/2002-11-27.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-27 08:00:00 | SPY | ETF | 92.24 | 92.27 | 92.22 | 92.23 | 8100.0 |
| 2002-11-27 08:30:00 | SPY | ETF | 92.25 | 92.48 | 92.2 | 92.44 | 92500.0 |
| 2002-11-27 09:00:00 | SPY | ETF | 92.45 | 92.59 | 92.44 | 92.58 | 57000.0 |
| 2002-11-27 09:30:00 | SPY | ETF | 92.52 | 92.95 | 92.52 | 92.81 | 3654500.0 |
| 2002-11-27 10:00:00 | SPY | ETF | 92.84 | 94.0 | 92.82 | 93.82 | 7389700.0 |
| 2002-11-27 10:30:00 | SPY | ETF | 93.8 | 94.03 | 93.65 | 93.88 | 3070300.0 |
| 2002-11-27 11:00:00 | SPY | ETF | 93.86 | 94.22 | 93.83 | 94.04 | 2324900.0 |
| 2002-11-27 11:30:00 | SPY | ETF | 94.08 | 94.28 | 93.97 | 94.08 | 1325000.0 |
| 2002-11-27 12:00:00 | SPY | ETF | 94.12 | 94.44 | 94.07 | 94.34 | 1847600.0 |
| 2002-11-27 12:30:00 | SPY | ETF | 94.33 | 94.41 | 94.07 | 94.25 | 1494100.0 |
| 2002-11-27 13:00:00 | SPY | ETF | 94.24 | 94.41 | 94.16 | 94.4 | 796000.0 |
| 2002-11-27 13:30:00 | SPY | ETF | 94.35 | 94.49 | 94.3 | 94.36 | 862700.0 |
| 2002-11-27 14:00:00 | SPY | ETF | 94.35 | 94.57 | 94.33 | 94.47 | 1514100.0 |
| 2002-11-27 14:30:00 | SPY | ETF | 94.45 | 94.49 | 94.15 | 94.4 | 2177500.0 |
| 2002-11-27 15:00:00 | SPY | ETF | 94.45 | 94.52 | 94.18 | 94.24 | 1523300.0 |
| 2002-11-27 15:30:00 | SPY | ETF | 94.29 | 94.65 | 94.24 | 94.33 | 3278500.0 |
| 2002-11-27 16:00:00 | SPY | ETF | 94.35 | 94.5 | 94.13 | 94.49 | 3250100.0 |
| 2002-11-27 16:30:00 | SPY | ETF | 94.53 | 94.53 | 94.03 | 94.33 | 420000.0 |
| 2002-11-27 17:00:00 | SPY | ETF | 94.3 | 94.31 | 94.29 | 94.31 | 1000.0 |
| 2002-11-27 18:00:00 | SPY | ETF | 94.34 | 94.38 | 94.33 | 94.33 | 8100.0 |
| 2002-11-27 18:30:00 | SPY | ETF | 94.34 | 94.38 | 94.33 | 94.38 | 700.0 |
| 2002-11-27 19:00:00 | SPY | ETF | 94.38 | 94.38 | 94.38 | 94.38 | 300.0 |
| 2002-11-27 19:30:00 | SPY | ETF | 94.38 | 94.4 | 94.33 | 94.4 | 1200.0 |
| 2002-11-27 08:00:00 | QQQ | ETF | 27.25 | 27.31 | 27.24 | 27.26 | 19400.0 |
| 2002-11-27 08:30:00 | QQQ | ETF | 27.32 | 27.48 | 27.32 | 27.47 | 209800.0 |
| 2002-11-27 09:00:00 | QQQ | ETF | 27.47 | 27.58 | 27.47 | 27.54 | 139500.0 |
| 2002-11-27 09:30:00 | QQQ | ETF | 27.53 | 27.65 | 27.48 | 27.59 | 11537600.0 |
| 2002-11-27 10:00:00 | QQQ | ETF | 27.61 | 28.18 | 27.59 | 27.9 | 14064800.0 |
| 2002-11-27 10:30:00 | QQQ | ETF | 27.9 | 27.99 | 27.85 | 27.88 | 4892100.0 |
| 2002-11-27 11:00:00 | QQQ | ETF | 27.88 | 27.99 | 27.88 | 27.93 | 3877700.0 |
| 2002-11-27 11:30:00 | QQQ | ETF | 27.92 | 27.98 | 27.86 | 27.94 | 3562400.0 |
| 2002-11-27 12:00:00 | QQQ | ETF | 27.94 | 28.07 | 27.88 | 28.05 | 5074500.0 |
| 2002-11-27 12:30:00 | QQQ | ETF | 28.03 | 28.08 | 27.95 | 28.04 | 3202500.0 |
| 2002-11-27 13:00:00 | QQQ | ETF | 28.04 | 28.11 | 27.98 | 28.08 | 3093100.0 |
| 2002-11-27 13:30:00 | QQQ | ETF | 28.08 | 28.11 | 28.02 | 28.07 | 2030800.0 |
| 2002-11-27 14:00:00 | QQQ | ETF | 28.07 | 28.2 | 28.06 | 28.12 | 4157400.0 |
| 2002-11-27 14:30:00 | QQQ | ETF | 28.11 | 28.13 | 27.99 | 28.1 | 3863900.0 |
| 2002-11-27 15:00:00 | QQQ | ETF | 28.09 | 28.12 | 27.96 | 28.01 | 2739300.0 |
| 2002-11-27 15:30:00 | QQQ | ETF | 28.02 | 28.15 | 27.96 | 28.01 | 5097500.0 |
| 2002-11-27 16:00:00 | QQQ | ETF | 27.98 | 28.07 | 27.9 | 27.95 | 2755900.0 |
| 2002-11-27 16:30:00 | QQQ | ETF | 27.95 | 28.0 | 27.91 | 27.93 | 92700.0 |
| 2002-11-27 17:00:00 | QQQ | ETF | 27.93 | 27.95 | 27.92 | 27.92 | 57200.0 |
| 2002-11-27 17:30:00 | QQQ | ETF | 27.93 | 27.94 | 27.91 | 27.92 | 29300.0 |
| 2002-11-27 18:00:00 | QQQ | ETF | 27.92 | 27.94 | 27.9 | 27.94 | 31500.0 |
| 2002-11-27 18:30:00 | QQQ | ETF | 27.96 | 27.96 | 27.94 | 27.94 | 6700.0 |
| 2002-11-27 19:00:00 | QQQ | ETF | 27.93 | 27.93 | 27.93 | 27.93 | 1000.0 |
| 2002-11-27 19:30:00 | QQQ | ETF | 27.95 | 27.95 | 27.93 | 27.93 | 2300.0 |
| 2002-11-27 09:30:00 | IWM | ETF | 40.2 | 40.34 | 40.08 | 40.32 | 354600.0 |
| 2002-11-27 10:00:00 | IWM | ETF | 40.395 | 40.71 | 40.33 | 40.6 | 408800.0 |
| 2002-11-27 10:30:00 | IWM | ETF | 40.595 | 40.7 | 40.525 | 40.55 | 118800.0 |
> showing 50 of 636 rows — these rows as CSV