PREVIEW / etf_1hour / 2002-06-11
file: by_date/etf_1hour/2002/2002-06-11.parquet size: 15 KB rows: 318
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-11 09:00:00 | SPY | ETF | 104.13 | 104.44 | 103.88 | 104.04 | 2198300.0 |
| 2002-06-11 10:00:00 | SPY | ETF | 103.98 | 104.47 | 103.77 | 104.31 | 2121800.0 |
| 2002-06-11 11:00:00 | SPY | ETF | 104.32 | 104.54 | 103.9 | 103.96 | 1118200.0 |
| 2002-06-11 12:00:00 | SPY | ETF | 103.94 | 104.07 | 103.19 | 103.22 | 1734900.0 |
| 2002-06-11 13:00:00 | SPY | ETF | 103.23 | 103.37 | 102.91 | 103.19 | 2131600.0 |
| 2002-06-11 14:00:00 | SPY | ETF | 103.19 | 103.33 | 102.57 | 102.71 | 2633600.0 |
| 2002-06-11 15:00:00 | SPY | ETF | 102.7 | 102.7 | 101.76 | 101.82 | 4867300.0 |
| 2002-06-11 16:00:00 | SPY | ETF | 101.87 | 102.05 | 101.73 | 101.96 | 2453000.0 |
| 2002-06-11 17:00:00 | SPY | ETF | 101.92 | 101.92 | 101.92 | 101.92 | 200.0 |
| 2002-06-11 18:00:00 | SPY | ETF | 101.87 | 101.96 | 101.87 | 101.96 | 1500.0 |
| 2002-06-11 09:00:00 | QQQ | ETF | 28.6 | 28.69 | 28.35 | 28.43 | 8662000.0 |
| 2002-06-11 10:00:00 | QQQ | ETF | 28.43 | 28.66 | 28.26 | 28.54 | 12363300.0 |
| 2002-06-11 11:00:00 | QQQ | ETF | 28.55 | 28.62 | 28.42 | 28.44 | 5378000.0 |
| 2002-06-11 12:00:00 | QQQ | ETF | 28.44 | 28.5 | 28.11 | 28.14 | 9230500.0 |
| 2002-06-11 13:00:00 | QQQ | ETF | 28.15 | 28.18 | 27.95 | 28.08 | 9132600.0 |
| 2002-06-11 14:00:00 | QQQ | ETF | 28.07 | 28.15 | 27.64 | 27.71 | 13136400.0 |
| 2002-06-11 15:00:00 | QQQ | ETF | 27.67 | 27.74 | 27.36 | 27.41 | 20459500.0 |
| 2002-06-11 16:00:00 | QQQ | ETF | 27.41 | 27.97 | 27.3 | 27.43 | 3025600.0 |
| 2002-06-11 17:00:00 | QQQ | ETF | 27.43 | 27.46 | 27.4 | 27.4 | 56100.0 |
| 2002-06-11 18:00:00 | QQQ | ETF | 27.4 | 27.44 | 27.36 | 27.42 | 15900.0 |
| 2002-06-11 09:00:00 | IWM | ETF | 47.0 | 47.095 | 46.88 | 46.93 | 58400.0 |
| 2002-06-11 10:00:00 | IWM | ETF | 46.89 | 47.03 | 46.78 | 46.945 | 314200.0 |
| 2002-06-11 11:00:00 | IWM | ETF | 46.955 | 47.0 | 46.745 | 46.745 | 264400.0 |
| 2002-06-11 12:00:00 | IWM | ETF | 46.745 | 46.82 | 46.525 | 46.525 | 138600.0 |
| 2002-06-11 13:00:00 | IWM | ETF | 46.51 | 46.565 | 46.385 | 46.505 | 107600.0 |
| 2002-06-11 14:00:00 | IWM | ETF | 46.535 | 46.535 | 46.235 | 46.235 | 175600.0 |
| 2002-06-11 15:00:00 | IWM | ETF | 46.27 | 46.29 | 46.07 | 46.075 | 765800.0 |
| 2002-06-11 16:00:00 | IWM | ETF | 46.07 | 46.075 | 46.0 | 46.05 | 277000.0 |
| 2002-06-11 17:00:00 | IWM | ETF | 46.135 | 46.135 | 46.135 | 46.135 | 765000.0 |
| 2002-06-11 09:00:00 | DIA | ETF | 97.15 | 97.55 | 97.08 | 97.23 | 639100.0 |
| 2002-06-11 10:00:00 | DIA | ETF | 97.17 | 97.77 | 96.96 | 97.64 | 402200.0 |
| 2002-06-11 11:00:00 | DIA | ETF | 97.62 | 97.85 | 97.14 | 97.14 | 409700.0 |
| 2002-06-11 12:00:00 | DIA | ETF | 97.22 | 97.34 | 96.44 | 96.5 | 306100.0 |
| 2002-06-11 13:00:00 | DIA | ETF | 96.5 | 96.69 | 96.2 | 96.5 | 470200.0 |
| 2002-06-11 14:00:00 | DIA | ETF | 96.59 | 96.66 | 96.05 | 96.14 | 728000.0 |
| 2002-06-11 15:00:00 | DIA | ETF | 96.17 | 96.17 | 95.25 | 95.34 | 901400.0 |
| 2002-06-11 16:00:00 | DIA | ETF | 95.3 | 96.25 | 95.26 | 96.25 | 142000.0 |
| 2002-06-11 17:00:00 | DIA | ETF | 95.39 | 95.39 | 95.35 | 95.35 | 700.0 |
> showing 38 of 318 rows — these rows as CSV