PREVIEW / etf_1hour / 2002-12-02
file: by_date/etf_1hour/2002/2002-12-02.parquet size: 17 KB rows: 399
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-02 08:00:00 | SPY | ETF | 95.23 | 95.59 | 95.23 | 95.55 | 42600.0 |
| 2002-12-02 09:00:00 | SPY | ETF | 95.52 | 96.0 | 95.36 | 95.98 | 4454900.0 |
| 2002-12-02 10:00:00 | SPY | ETF | 95.96 | 96.05 | 94.14 | 94.21 | 11248400.0 |
| 2002-12-02 11:00:00 | SPY | ETF | 94.2 | 94.43 | 93.83 | 94.18 | 4811800.0 |
| 2002-12-02 12:00:00 | SPY | ETF | 94.2 | 94.55 | 94.11 | 94.26 | 3007500.0 |
| 2002-12-02 13:00:00 | SPY | ETF | 94.26 | 94.45 | 93.6 | 93.66 | 5235900.0 |
| 2002-12-02 14:00:00 | SPY | ETF | 93.65 | 93.76 | 93.22 | 93.73 | 4405400.0 |
| 2002-12-02 15:00:00 | SPY | ETF | 93.73 | 94.12 | 93.48 | 93.89 | 4840000.0 |
| 2002-12-02 16:00:00 | SPY | ETF | 93.92 | 94.18 | 93.77 | 94.15 | 4054700.0 |
| 2002-12-02 17:00:00 | SPY | ETF | 94.17 | 94.48 | 94.16 | 94.45 | 577600.0 |
| 2002-12-02 18:00:00 | SPY | ETF | 94.43 | 94.48 | 94.34 | 94.48 | 8200.0 |
| 2002-12-02 19:00:00 | SPY | ETF | 94.48 | 94.48 | 94.48 | 94.48 | 800.0 |
| 2002-12-02 08:00:00 | QQQ | ETF | 28.31 | 28.46 | 28.31 | 28.42 | 149000.0 |
| 2002-12-02 09:00:00 | QQQ | ETF | 28.4 | 28.76 | 28.37 | 28.72 | 12746900.0 |
| 2002-12-02 10:00:00 | QQQ | ETF | 28.74 | 28.79 | 27.98 | 28.0 | 19987700.0 |
| 2002-12-02 11:00:00 | QQQ | ETF | 28.0 | 28.2 | 27.85 | 28.13 | 11648200.0 |
| 2002-12-02 12:00:00 | QQQ | ETF | 28.14 | 28.29 | 28.01 | 28.2 | 4860300.0 |
| 2002-12-02 13:00:00 | QQQ | ETF | 28.21 | 28.28 | 27.85 | 27.9 | 6059600.0 |
| 2002-12-02 14:00:00 | QQQ | ETF | 27.89 | 27.91 | 27.57 | 27.81 | 9702900.0 |
| 2002-12-02 15:00:00 | QQQ | ETF | 27.8 | 27.96 | 27.66 | 27.85 | 10993700.0 |
| 2002-12-02 16:00:00 | QQQ | ETF | 27.85 | 28.07 | 27.8 | 28.0 | 3579200.0 |
| 2002-12-02 17:00:00 | QQQ | ETF | 28.02 | 28.23 | 28.02 | 28.22 | 1354900.0 |
| 2002-12-02 18:00:00 | QQQ | ETF | 28.22 | 28.23 | 28.15 | 28.16 | 65300.0 |
| 2002-12-02 19:00:00 | QQQ | ETF | 28.16 | 28.19 | 28.15 | 28.18 | 4400.0 |
| 2002-12-02 09:00:00 | IWM | ETF | 41.25 | 41.34 | 41.07 | 41.34 | 166400.0 |
| 2002-12-02 10:00:00 | IWM | ETF | 41.25 | 41.38 | 40.615 | 40.615 | 298200.0 |
| 2002-12-02 11:00:00 | IWM | ETF | 40.615 | 40.805 | 40.535 | 40.79 | 285200.0 |
| 2002-12-02 12:00:00 | IWM | ETF | 40.805 | 40.96 | 40.755 | 40.9 | 200800.0 |
| 2002-12-02 13:00:00 | IWM | ETF | 40.85 | 40.89 | 40.685 | 40.7 | 429800.0 |
| 2002-12-02 14:00:00 | IWM | ETF | 40.675 | 40.685 | 40.46 | 40.585 | 731000.0 |
| 2002-12-02 15:00:00 | IWM | ETF | 40.595 | 40.78 | 40.565 | 40.7 | 203000.0 |
| 2002-12-02 16:00:00 | IWM | ETF | 40.65 | 40.79 | 40.65 | 40.695 | 554200.0 |
| 2002-12-02 08:00:00 | DIA | ETF | 90.21 | 90.51 | 90.2 | 90.4 | 9400.0 |
| 2002-12-02 09:00:00 | DIA | ETF | 90.4 | 90.65 | 90.1 | 90.59 | 1292600.0 |
| 2002-12-02 10:00:00 | DIA | ETF | 90.59 | 90.66 | 89.05 | 89.08 | 2082200.0 |
| 2002-12-02 11:00:00 | DIA | ETF | 89.05 | 89.27 | 88.75 | 89.03 | 999900.0 |
| 2002-12-02 12:00:00 | DIA | ETF | 89.01 | 89.25 | 88.91 | 89.06 | 619300.0 |
| 2002-12-02 13:00:00 | DIA | ETF | 89.04 | 89.15 | 88.29 | 88.37 | 1116000.0 |
| 2002-12-02 14:00:00 | DIA | ETF | 88.36 | 88.54 | 88.03 | 88.48 | 891700.0 |
| 2002-12-02 15:00:00 | DIA | ETF | 88.49 | 88.92 | 88.23 | 88.74 | 1138400.0 |
| 2002-12-02 16:00:00 | DIA | ETF | 88.73 | 89.18 | 88.65 | 89.01 | 156600.0 |
| 2002-12-02 17:00:00 | DIA | ETF | 89.0 | 89.18 | 89.0 | 89.05 | 51400.0 |
| 2002-12-02 19:00:00 | DIA | ETF | 89.15 | 89.15 | 88.95 | 88.95 | 1800.0 |
| 2002-12-02 09:00:00 | TLT | ETF | 84.36 | 84.4 | 84.15 | 84.2 | 154100.0 |
| 2002-12-02 10:00:00 | TLT | ETF | 84.4 | 85.18 | 84.4 | 85.12 | 55900.0 |
| 2002-12-02 11:00:00 | TLT | ETF | 85.27 | 85.27 | 85.09 | 85.1 | 6500.0 |
| 2002-12-02 12:00:00 | TLT | ETF | 85.09 | 85.3 | 84.94 | 85.3 | 8300.0 |
| 2002-12-02 13:00:00 | TLT | ETF | 84.89 | 85.15 | 84.89 | 85.04 | 2700.0 |
| 2002-12-02 14:00:00 | TLT | ETF | 85.37 | 85.4 | 85.27 | 85.33 | 27000.0 |
| 2002-12-02 15:00:00 | TLT | ETF | 85.22 | 85.38 | 85.22 | 85.24 | 1400.0 |
> showing 50 of 399 rows — these rows as CSV