PREVIEW / etf_1hour / 2002-05-02
file: by_date/etf_1hour/2002/2002-05-02.parquet size: 14 KB rows: 306
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-05-02 09:00:00 | SPY | ETF | 109.1 | 109.5 | 108.76 | 109.25 | 2917100.0 |
| 2002-05-02 10:00:00 | SPY | ETF | 109.25 | 109.53 | 108.78 | 109.15 | 3391400.0 |
| 2002-05-02 11:00:00 | SPY | ETF | 109.15 | 109.21 | 108.53 | 108.89 | 1999900.0 |
| 2002-05-02 12:00:00 | SPY | ETF | 108.86 | 108.95 | 108.56 | 108.58 | 1139900.0 |
| 2002-05-02 13:00:00 | SPY | ETF | 108.59 | 109.08 | 108.57 | 108.92 | 1130800.0 |
| 2002-05-02 14:00:00 | SPY | ETF | 108.93 | 108.95 | 108.36 | 108.7 | 1790600.0 |
| 2002-05-02 15:00:00 | SPY | ETF | 108.73 | 109.0 | 108.2 | 108.8 | 2126400.0 |
| 2002-05-02 16:00:00 | SPY | ETF | 108.78 | 108.86 | 108.48 | 108.76 | 1077600.0 |
| 2002-05-02 17:00:00 | SPY | ETF | 108.77 | 108.77 | 108.77 | 108.77 | 100.0 |
| 2002-05-02 18:00:00 | SPY | ETF | 108.9 | 109.0 | 108.9 | 109.0 | 400.0 |
| 2002-05-02 09:00:00 | QQQ | ETF | 31.39 | 31.92 | 31.25 | 31.72 | 10425400.0 |
| 2002-05-02 10:00:00 | QQQ | ETF | 31.72 | 31.99 | 31.29 | 31.46 | 16663300.0 |
| 2002-05-02 11:00:00 | QQQ | ETF | 31.46 | 31.53 | 31.05 | 31.16 | 10043100.0 |
| 2002-05-02 12:00:00 | QQQ | ETF | 31.19 | 31.2 | 30.71 | 30.72 | 9849000.0 |
| 2002-05-02 13:00:00 | QQQ | ETF | 30.77 | 31.06 | 30.68 | 30.94 | 8402200.0 |
| 2002-05-02 14:00:00 | QQQ | ETF | 30.96 | 31.1 | 30.61 | 30.83 | 11968800.0 |
| 2002-05-02 15:00:00 | QQQ | ETF | 30.84 | 30.85 | 30.46 | 30.58 | 15265700.0 |
| 2002-05-02 16:00:00 | QQQ | ETF | 30.53 | 30.6 | 30.47 | 30.53 | 2083000.0 |
| 2002-05-02 17:00:00 | QQQ | ETF | 30.53 | 30.92 | 30.5 | 30.52 | 72800.0 |
| 2002-05-02 18:00:00 | QQQ | ETF | 30.51 | 30.55 | 30.45 | 30.51 | 16300.0 |
| 2002-05-02 09:00:00 | IWM | ETF | 50.95 | 51.225 | 50.82 | 51.225 | 79000.0 |
| 2002-05-02 10:00:00 | IWM | ETF | 51.18 | 51.245 | 51.03 | 51.2 | 81200.0 |
| 2002-05-02 11:00:00 | IWM | ETF | 51.25 | 51.275 | 51.03 | 51.15 | 112800.0 |
| 2002-05-02 12:00:00 | IWM | ETF | 51.065 | 51.2 | 50.96 | 51.1 | 110200.0 |
| 2002-05-02 13:00:00 | IWM | ETF | 51.06 | 51.25 | 51.0 | 51.2 | 50000.0 |
| 2002-05-02 14:00:00 | IWM | ETF | 51.18 | 51.25 | 50.915 | 51.11 | 117200.0 |
| 2002-05-02 15:00:00 | IWM | ETF | 51.085 | 51.3 | 50.91 | 51.175 | 378400.0 |
| 2002-05-02 16:00:00 | IWM | ETF | 51.2 | 51.225 | 51.2 | 51.225 | 400.0 |
| 2002-05-02 09:00:00 | DIA | ETF | 100.69 | 101.23 | 100.48 | 100.94 | 323500.0 |
| 2002-05-02 10:00:00 | DIA | ETF | 101.06 | 101.35 | 100.61 | 101.07 | 619700.0 |
| 2002-05-02 11:00:00 | DIA | ETF | 101.07 | 101.11 | 100.48 | 100.98 | 144700.0 |
| 2002-05-02 12:00:00 | DIA | ETF | 100.97 | 100.97 | 100.65 | 100.68 | 104600.0 |
| 2002-05-02 13:00:00 | DIA | ETF | 100.71 | 101.14 | 100.65 | 101.06 | 314400.0 |
| 2002-05-02 14:00:00 | DIA | ETF | 101.0 | 101.06 | 100.5 | 100.85 | 335500.0 |
| 2002-05-02 15:00:00 | DIA | ETF | 100.82 | 101.17 | 100.41 | 100.93 | 633300.0 |
| 2002-05-02 16:00:00 | DIA | ETF | 100.95 | 101.06 | 100.81 | 101.0 | 33800.0 |
> showing 36 of 306 rows — these rows as CSV