PREVIEW / etf_30min / 2002-12-20
file: by_date/etf_30min/2002/2002-12-20.parquet size: 22 KB rows: 667
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-12-20 08:00:00 | SPY | ETF | 89.4 | 89.5 | 89.38 | 89.42 | 18400.0 |
| 2002-12-20 08:30:00 | SPY | ETF | 89.38 | 89.68 | 89.35 | 89.41 | 17300.0 |
| 2002-12-20 09:00:00 | SPY | ETF | 89.37 | 89.44 | 89.3 | 89.44 | 29400.0 |
| 2002-12-20 09:30:00 | SPY | ETF | 89.2 | 89.52 | 89.1 | 89.5 | 4741000.0 |
| 2002-12-20 10:00:00 | SPY | ETF | 89.47 | 89.63 | 89.3 | 89.43 | 1910500.0 |
| 2002-12-20 10:30:00 | SPY | ETF | 89.5 | 89.65 | 89.31 | 89.41 | 1454900.0 |
| 2002-12-20 11:00:00 | SPY | ETF | 89.44 | 89.49 | 89.23 | 89.45 | 910400.0 |
| 2002-12-20 11:30:00 | SPY | ETF | 89.45 | 89.65 | 89.41 | 89.64 | 864200.0 |
| 2002-12-20 12:00:00 | SPY | ETF | 89.65 | 89.93 | 89.51 | 89.83 | 1664000.0 |
| 2002-12-20 12:30:00 | SPY | ETF | 89.81 | 90.02 | 89.74 | 89.8 | 1219300.0 |
| 2002-12-20 13:00:00 | SPY | ETF | 89.8 | 89.9 | 89.8 | 89.89 | 588600.0 |
| 2002-12-20 13:30:00 | SPY | ETF | 89.85 | 89.95 | 89.71 | 89.72 | 713300.0 |
| 2002-12-20 14:00:00 | SPY | ETF | 89.7 | 89.83 | 89.41 | 89.58 | 1643000.0 |
| 2002-12-20 14:30:00 | SPY | ETF | 89.57 | 89.62 | 89.31 | 89.39 | 2807500.0 |
| 2002-12-20 15:00:00 | SPY | ETF | 89.37 | 89.68 | 89.3 | 89.61 | 1689900.0 |
| 2002-12-20 15:30:00 | SPY | ETF | 89.63 | 89.88 | 89.56 | 89.69 | 2664500.0 |
| 2002-12-20 16:00:00 | SPY | ETF | 89.71 | 89.99 | 89.67 | 89.88 | 3440700.0 |
| 2002-12-20 16:30:00 | SPY | ETF | 89.95 | 90.0 | 89.82 | 89.83 | 61000.0 |
| 2002-12-20 17:00:00 | SPY | ETF | 89.83 | 89.91 | 89.83 | 89.91 | 3500.0 |
| 2002-12-20 17:30:00 | SPY | ETF | 89.91 | 89.91 | 89.9 | 89.9 | 1100.0 |
| 2002-12-20 18:00:00 | SPY | ETF | 89.92 | 89.94 | 89.9 | 89.94 | 2900.0 |
| 2002-12-20 18:30:00 | SPY | ETF | 89.9 | 89.9 | 89.9 | 89.9 | 300.0 |
| 2002-12-20 19:00:00 | SPY | ETF | 89.93 | 89.94 | 89.9 | 89.94 | 2300.0 |
| 2002-12-20 19:30:00 | SPY | ETF | 90.03 | 90.03 | 90.03 | 90.03 | 100.0 |
| 2002-12-20 08:00:00 | QQQ | ETF | 25.22 | 25.25 | 25.21 | 25.25 | 28400.0 |
| 2002-12-20 08:30:00 | QQQ | ETF | 25.25 | 25.35 | 25.22 | 25.26 | 84300.0 |
| 2002-12-20 09:00:00 | QQQ | ETF | 25.25 | 25.35 | 25.24 | 25.35 | 95600.0 |
| 2002-12-20 09:30:00 | QQQ | ETF | 25.33 | 25.45 | 25.13 | 25.39 | 10190600.0 |
| 2002-12-20 10:00:00 | QQQ | ETF | 25.37 | 25.43 | 25.25 | 25.35 | 4332800.0 |
| 2002-12-20 10:30:00 | QQQ | ETF | 25.34 | 25.42 | 25.17 | 25.25 | 5046300.0 |
| 2002-12-20 11:00:00 | QQQ | ETF | 25.24 | 25.31 | 25.19 | 25.27 | 2962000.0 |
| 2002-12-20 11:30:00 | QQQ | ETF | 25.25 | 25.38 | 25.24 | 25.32 | 3585600.0 |
| 2002-12-20 12:00:00 | QQQ | ETF | 25.33 | 25.41 | 25.27 | 25.38 | 2513800.0 |
| 2002-12-20 12:30:00 | QQQ | ETF | 25.38 | 25.43 | 25.28 | 25.31 | 2999700.0 |
| 2002-12-20 13:00:00 | QQQ | ETF | 25.31 | 25.38 | 25.3 | 25.36 | 810600.0 |
| 2002-12-20 13:30:00 | QQQ | ETF | 25.37 | 25.39 | 25.27 | 25.27 | 1732700.0 |
| 2002-12-20 14:00:00 | QQQ | ETF | 25.27 | 25.28 | 25.1 | 25.2 | 4669400.0 |
| 2002-12-20 14:30:00 | QQQ | ETF | 25.2 | 25.22 | 25.1 | 25.12 | 2772900.0 |
| 2002-12-20 15:00:00 | QQQ | ETF | 25.12 | 25.25 | 25.07 | 25.16 | 3438000.0 |
| 2002-12-20 15:30:00 | QQQ | ETF | 25.15 | 25.29 | 25.15 | 25.23 | 5376400.0 |
| 2002-12-20 16:00:00 | QQQ | ETF | 25.24 | 25.42 | 25.2 | 25.36 | 7797700.0 |
| 2002-12-20 16:30:00 | QQQ | ETF | 25.36 | 25.4 | 25.35 | 25.38 | 200100.0 |
| 2002-12-20 17:00:00 | QQQ | ETF | 25.39 | 25.39 | 25.35 | 25.37 | 11300.0 |
| 2002-12-20 17:30:00 | QQQ | ETF | 25.36 | 25.4 | 25.35 | 25.37 | 35800.0 |
| 2002-12-20 18:00:00 | QQQ | ETF | 25.37 | 25.39 | 25.37 | 25.38 | 13600.0 |
| 2002-12-20 18:30:00 | QQQ | ETF | 25.38 | 25.38 | 25.35 | 25.35 | 8500.0 |
| 2002-12-20 19:00:00 | QQQ | ETF | 25.37 | 25.37 | 25.37 | 25.37 | 1700.0 |
| 2002-12-20 19:30:00 | QQQ | ETF | 25.36 | 25.38 | 25.36 | 25.37 | 4100.0 |
| 2002-12-20 09:30:00 | IWM | ETF | 38.37 | 38.45 | 38.185 | 38.3 | 281200.0 |
| 2002-12-20 10:00:00 | IWM | ETF | 38.31 | 38.375 | 38.225 | 38.375 | 149000.0 |
> showing 50 of 667 rows — these rows as CSV