PREVIEW / etf_1hour / 2002-03-11
file: by_date/etf_1hour/2002/2002-03-11.parquet size: 14 KB rows: 310
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-03-11 09:00:00 | SPY | ETF | 116.89 | 116.92 | 116.45 | 116.71 | 2667800.0 |
| 2002-03-11 10:00:00 | SPY | ETF | 116.7 | 117.04 | 116.51 | 117.04 | 1894500.0 |
| 2002-03-11 11:00:00 | SPY | ETF | 117.02 | 117.09 | 116.62 | 116.68 | 1075700.0 |
| 2002-03-11 12:00:00 | SPY | ETF | 116.65 | 116.92 | 116.62 | 116.85 | 937900.0 |
| 2002-03-11 13:00:00 | SPY | ETF | 116.86 | 117.07 | 116.7 | 117.06 | 1388000.0 |
| 2002-03-11 14:00:00 | SPY | ETF | 117.07 | 117.8 | 117.06 | 117.74 | 3091900.0 |
| 2002-03-11 15:00:00 | SPY | ETF | 117.72 | 117.9 | 117.3 | 117.34 | 2067600.0 |
| 2002-03-11 16:00:00 | SPY | ETF | 117.3 | 117.39 | 117.06 | 117.18 | 1764100.0 |
| 2002-03-11 17:00:00 | SPY | ETF | 117.1 | 117.1 | 117.1 | 117.1 | 10000.0 |
| 2002-03-11 18:00:00 | SPY | ETF | 117.18 | 117.18 | 117.15 | 117.15 | 300.0 |
| 2002-03-11 09:00:00 | QQQ | ETF | 38.35 | 38.43 | 38.17 | 38.26 | 8887300.0 |
| 2002-03-11 10:00:00 | QQQ | ETF | 38.25 | 38.54 | 38.06 | 38.45 | 11650700.0 |
| 2002-03-11 11:00:00 | QQQ | ETF | 38.46 | 38.52 | 38.13 | 38.16 | 6922800.0 |
| 2002-03-11 12:00:00 | QQQ | ETF | 38.16 | 38.38 | 38.13 | 38.33 | 3385600.0 |
| 2002-03-11 13:00:00 | QQQ | ETF | 38.33 | 38.58 | 38.25 | 38.58 | 4129600.0 |
| 2002-03-11 14:00:00 | QQQ | ETF | 38.55 | 39.06 | 38.5 | 38.97 | 13947000.0 |
| 2002-03-11 15:00:00 | QQQ | ETF | 39.0 | 39.19 | 38.61 | 38.66 | 18130900.0 |
| 2002-03-11 16:00:00 | QQQ | ETF | 38.65 | 38.73 | 38.51 | 38.56 | 1360600.0 |
| 2002-03-11 17:00:00 | QQQ | ETF | 38.56 | 38.57 | 38.5 | 38.53 | 38000.0 |
| 2002-03-11 18:00:00 | QQQ | ETF | 38.53 | 38.54 | 38.48 | 38.53 | 32700.0 |
| 2002-03-11 09:00:00 | IWM | ETF | 49.69 | 49.69 | 49.375 | 49.47 | 85200.0 |
| 2002-03-11 10:00:00 | IWM | ETF | 49.45 | 49.47 | 49.27 | 49.45 | 205400.0 |
| 2002-03-11 11:00:00 | IWM | ETF | 49.475 | 49.5 | 49.415 | 49.43 | 51400.0 |
| 2002-03-11 12:00:00 | IWM | ETF | 49.42 | 49.43 | 49.315 | 49.34 | 126200.0 |
| 2002-03-11 13:00:00 | IWM | ETF | 49.4 | 49.42 | 49.38 | 49.41 | 28000.0 |
| 2002-03-11 14:00:00 | IWM | ETF | 49.435 | 49.875 | 49.435 | 49.875 | 173200.0 |
| 2002-03-11 15:00:00 | IWM | ETF | 49.94 | 49.99 | 49.735 | 49.815 | 165400.0 |
| 2002-03-11 16:00:00 | IWM | ETF | 49.78 | 49.8 | 49.7 | 49.775 | 264800.0 |
| 2002-03-11 09:00:00 | DIA | ETF | 105.75 | 105.87 | 105.39 | 105.54 | 1195300.0 |
| 2002-03-11 10:00:00 | DIA | ETF | 105.49 | 106.0 | 105.33 | 106.0 | 943600.0 |
| 2002-03-11 11:00:00 | DIA | ETF | 106.05 | 106.05 | 105.65 | 105.65 | 298400.0 |
| 2002-03-11 12:00:00 | DIA | ETF | 105.65 | 105.91 | 105.61 | 105.74 | 344900.0 |
| 2002-03-11 13:00:00 | DIA | ETF | 105.79 | 105.95 | 105.6 | 105.94 | 102300.0 |
| 2002-03-11 14:00:00 | DIA | ETF | 105.95 | 106.59 | 105.95 | 106.52 | 481000.0 |
| 2002-03-11 15:00:00 | DIA | ETF | 106.51 | 106.72 | 106.17 | 106.25 | 925400.0 |
| 2002-03-11 16:00:00 | DIA | ETF | 106.27 | 106.3 | 106.0 | 106.0 | 87700.0 |
| 2002-03-11 17:00:00 | DIA | ETF | 106.2 | 106.2 | 106.2 | 106.2 | 100.0 |
| 2002-03-11 18:00:00 | DIA | ETF | 106.2 | 106.2 | 106.2 | 106.2 | 900.0 |
> showing 38 of 310 rows — these rows as CSV