PREVIEW / etf_30min / 2002-06-12
file: by_date/etf_30min/2002/2002-06-12.parquet size: 19 KB rows: 508
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-06-12 09:30:00 | SPY | ETF | 101.71 | 102.38 | 101.58 | 102.37 | 2591300.0 |
| 2002-06-12 10:00:00 | SPY | ETF | 102.4 | 102.47 | 101.9 | 102.3 | 2261000.0 |
| 2002-06-12 10:30:00 | SPY | ETF | 102.32 | 102.47 | 101.71 | 101.71 | 1495500.0 |
| 2002-06-12 11:00:00 | SPY | ETF | 101.78 | 102.13 | 101.45 | 101.89 | 2837900.0 |
| 2002-06-12 11:30:00 | SPY | ETF | 101.86 | 101.94 | 100.94 | 100.94 | 2083600.0 |
| 2002-06-12 12:00:00 | SPY | ETF | 100.97 | 101.26 | 100.78 | 101.24 | 1093400.0 |
| 2002-06-12 12:30:00 | SPY | ETF | 101.17 | 101.48 | 100.91 | 101.47 | 1272100.0 |
| 2002-06-12 13:00:00 | SPY | ETF | 101.43 | 102.45 | 101.37 | 102.18 | 2907100.0 |
| 2002-06-12 13:30:00 | SPY | ETF | 102.19 | 102.38 | 101.8 | 102.1 | 1783600.0 |
| 2002-06-12 14:00:00 | SPY | ETF | 102.1 | 102.35 | 101.41 | 101.5 | 2652400.0 |
| 2002-06-12 14:30:00 | SPY | ETF | 101.54 | 102.06 | 101.4 | 101.74 | 1340000.0 |
| 2002-06-12 15:00:00 | SPY | ETF | 101.77 | 102.24 | 101.6 | 102.06 | 1720500.0 |
| 2002-06-12 15:30:00 | SPY | ETF | 102.12 | 102.81 | 102.05 | 102.61 | 3437100.0 |
| 2002-06-12 16:00:00 | SPY | ETF | 102.64 | 102.65 | 102.45 | 102.6 | 2467300.0 |
| 2002-06-12 16:30:00 | SPY | ETF | 102.59 | 102.8 | 102.55 | 102.8 | 46200.0 |
| 2002-06-12 17:00:00 | SPY | ETF | 102.81 | 103.15 | 102.81 | 103.06 | 199000.0 |
| 2002-06-12 17:30:00 | SPY | ETF | 103.17 | 103.19 | 103.12 | 103.15 | 6400.0 |
| 2002-06-12 18:00:00 | SPY | ETF | 103.2 | 103.2 | 103.05 | 103.19 | 6500.0 |
| 2002-06-12 09:30:00 | QQQ | ETF | 27.24 | 27.57 | 27.11 | 27.57 | 13356500.0 |
| 2002-06-12 10:00:00 | QQQ | ETF | 27.57 | 27.67 | 27.27 | 27.59 | 13648600.0 |
| 2002-06-12 10:30:00 | QQQ | ETF | 27.59 | 27.67 | 27.15 | 27.18 | 8571100.0 |
| 2002-06-12 11:00:00 | QQQ | ETF | 27.18 | 27.43 | 27.09 | 27.35 | 7505500.0 |
| 2002-06-12 11:30:00 | QQQ | ETF | 27.35 | 27.89 | 26.85 | 26.9 | 16543900.0 |
| 2002-06-12 12:00:00 | QQQ | ETF | 26.88 | 27.13 | 26.83 | 27.1 | 9708400.0 |
| 2002-06-12 12:30:00 | QQQ | ETF | 27.08 | 27.41 | 27.0 | 27.39 | 5766100.0 |
| 2002-06-12 13:00:00 | QQQ | ETF | 27.37 | 27.87 | 27.37 | 27.69 | 15867800.0 |
| 2002-06-12 13:30:00 | QQQ | ETF | 27.69 | 27.77 | 27.51 | 27.65 | 10027700.0 |
| 2002-06-12 14:00:00 | QQQ | ETF | 27.66 | 27.72 | 27.2 | 27.35 | 10818400.0 |
| 2002-06-12 14:30:00 | QQQ | ETF | 27.32 | 27.65 | 27.28 | 27.5 | 8522700.0 |
| 2002-06-12 15:00:00 | QQQ | ETF | 27.51 | 27.69 | 27.35 | 27.59 | 8664300.0 |
| 2002-06-12 15:30:00 | QQQ | ETF | 27.59 | 27.96 | 27.59 | 27.92 | 15323600.0 |
| 2002-06-12 16:00:00 | QQQ | ETF | 27.93 | 27.95 | 27.78 | 27.9 | 2759800.0 |
| 2002-06-12 16:30:00 | QQQ | ETF | 27.93 | 27.96 | 27.83 | 27.96 | 130300.0 |
| 2002-06-12 17:00:00 | QQQ | ETF | 27.97 | 28.12 | 27.92 | 28.05 | 761200.0 |
| 2002-06-12 17:30:00 | QQQ | ETF | 28.04 | 28.14 | 28.03 | 28.12 | 117800.0 |
| 2002-06-12 18:00:00 | QQQ | ETF | 28.1 | 28.14 | 28.08 | 28.11 | 74100.0 |
| 2002-06-12 09:30:00 | IWM | ETF | 46.005 | 46.12 | 45.925 | 46.12 | 89800.0 |
| 2002-06-12 10:00:00 | IWM | ETF | 46.145 | 46.345 | 46.05 | 46.295 | 281600.0 |
| 2002-06-12 10:30:00 | IWM | ETF | 46.26 | 46.315 | 46.065 | 46.065 | 447000.0 |
| 2002-06-12 11:00:00 | IWM | ETF | 46.0 | 46.015 | 45.805 | 45.89 | 133200.0 |
| 2002-06-12 11:30:00 | IWM | ETF | 45.9 | 45.965 | 45.475 | 45.52 | 82200.0 |
| 2002-06-12 12:00:00 | IWM | ETF | 45.555 | 45.67 | 45.505 | 45.66 | 41200.0 |
| 2002-06-12 12:30:00 | IWM | ETF | 45.66 | 45.79 | 45.62 | 45.75 | 93400.0 |
| 2002-06-12 13:00:00 | IWM | ETF | 45.81 | 46.065 | 45.81 | 45.985 | 204800.0 |
| 2002-06-12 13:30:00 | IWM | ETF | 45.975 | 46.055 | 45.865 | 45.89 | 65000.0 |
| 2002-06-12 14:00:00 | IWM | ETF | 45.885 | 45.885 | 45.61 | 45.61 | 44800.0 |
| 2002-06-12 14:30:00 | IWM | ETF | 45.595 | 45.705 | 45.595 | 45.65 | 10200.0 |
| 2002-06-12 15:00:00 | IWM | ETF | 45.64 | 45.8 | 45.59 | 45.8 | 189800.0 |
| 2002-06-12 15:30:00 | IWM | ETF | 45.795 | 46.185 | 45.795 | 46.1 | 732000.0 |
| 2002-06-12 16:00:00 | IWM | ETF | 46.09 | 46.19 | 46.05 | 46.095 | 209400.0 |
> showing 50 of 508 rows — these rows as CSV