PREVIEW / etf_1hour / 2002-02-15
file: by_date/etf_1hour/2002/2002-02-15.parquet size: 13 KB rows: 273
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-02-15 09:00:00 | SPY | ETF | 112.15 | 112.24 | 111.44 | 111.45 | 3664000.0 |
| 2002-02-15 10:00:00 | SPY | ETF | 111.45 | 111.87 | 111.02 | 111.66 | 4164600.0 |
| 2002-02-15 11:00:00 | SPY | ETF | 111.67 | 111.7 | 111.18 | 111.24 | 2089300.0 |
| 2002-02-15 12:00:00 | SPY | ETF | 111.23 | 111.53 | 111.12 | 111.42 | 1024800.0 |
| 2002-02-15 13:00:00 | SPY | ETF | 111.42 | 111.47 | 110.91 | 111.0 | 1996400.0 |
| 2002-02-15 14:00:00 | SPY | ETF | 110.96 | 111.4 | 110.95 | 111.12 | 1347100.0 |
| 2002-02-15 15:00:00 | SPY | ETF | 111.11 | 111.3 | 110.71 | 110.83 | 3154700.0 |
| 2002-02-15 16:00:00 | SPY | ETF | 110.91 | 111.0 | 110.75 | 110.85 | 956500.0 |
| 2002-02-15 17:00:00 | SPY | ETF | 110.99 | 110.99 | 110.85 | 110.85 | 600.0 |
| 2002-02-15 18:00:00 | SPY | ETF | 110.86 | 110.86 | 110.85 | 110.85 | 2500.0 |
| 2002-02-15 09:00:00 | QQQ | ETF | 36.83 | 36.91 | 36.38 | 36.39 | 8708000.0 |
| 2002-02-15 10:00:00 | QQQ | ETF | 36.4 | 36.46 | 36.1 | 36.23 | 13015700.0 |
| 2002-02-15 11:00:00 | QQQ | ETF | 36.24 | 36.25 | 35.92 | 35.96 | 8216900.0 |
| 2002-02-15 12:00:00 | QQQ | ETF | 35.95 | 35.99 | 35.76 | 35.9 | 6251700.0 |
| 2002-02-15 13:00:00 | QQQ | ETF | 35.91 | 35.95 | 35.66 | 35.7 | 6498400.0 |
| 2002-02-15 14:00:00 | QQQ | ETF | 35.69 | 36.03 | 35.65 | 35.92 | 7883000.0 |
| 2002-02-15 15:00:00 | QQQ | ETF | 35.87 | 36.0 | 35.64 | 35.78 | 11358000.0 |
| 2002-02-15 16:00:00 | QQQ | ETF | 35.77 | 35.84 | 35.76 | 35.78 | 17474400.0 |
| 2002-02-15 17:00:00 | QQQ | ETF | 35.78 | 35.83 | 35.77 | 35.78 | 75100.0 |
| 2002-02-15 18:00:00 | QQQ | ETF | 35.79 | 35.8 | 35.77 | 35.77 | 4200.0 |
| 2002-02-15 09:00:00 | IWM | ETF | 46.87 | 46.87 | 46.54 | 46.555 | 47000.0 |
| 2002-02-15 10:00:00 | IWM | ETF | 46.6 | 46.875 | 46.4 | 46.875 | 236200.0 |
| 2002-02-15 11:00:00 | IWM | ETF | 46.865 | 46.865 | 46.68 | 46.68 | 81200.0 |
| 2002-02-15 12:00:00 | IWM | ETF | 46.67 | 46.785 | 46.655 | 46.765 | 83200.0 |
| 2002-02-15 13:00:00 | IWM | ETF | 46.75 | 46.82 | 46.695 | 46.72 | 80600.0 |
| 2002-02-15 14:00:00 | IWM | ETF | 46.75 | 46.945 | 46.705 | 46.945 | 93200.0 |
| 2002-02-15 15:00:00 | IWM | ETF | 46.945 | 46.945 | 46.65 | 46.65 | 110600.0 |
| 2002-02-15 16:00:00 | IWM | ETF | 46.68 | 46.68 | 46.675 | 46.675 | 113000.0 |
| 2002-02-15 09:00:00 | DIA | ETF | 100.1 | 100.18 | 99.67 | 99.67 | 675900.0 |
| 2002-02-15 10:00:00 | DIA | ETF | 99.71 | 100.12 | 99.31 | 99.93 | 409200.0 |
| 2002-02-15 11:00:00 | DIA | ETF | 99.95 | 100.05 | 99.56 | 99.68 | 395000.0 |
| 2002-02-15 12:00:00 | DIA | ETF | 99.57 | 99.85 | 99.5 | 99.68 | 398000.0 |
| 2002-02-15 13:00:00 | DIA | ETF | 99.76 | 99.76 | 99.18 | 99.24 | 571500.0 |
| 2002-02-15 14:00:00 | DIA | ETF | 99.2 | 99.6 | 99.2 | 99.33 | 215200.0 |
| 2002-02-15 15:00:00 | DIA | ETF | 99.38 | 99.43 | 99.03 | 99.13 | 576500.0 |
| 2002-02-15 16:00:00 | DIA | ETF | 99.14 | 100.08 | 99.08 | 100.08 | 558800.0 |
| 2002-02-15 17:00:00 | DIA | ETF | 99.15 | 99.15 | 99.15 | 99.15 | 100.0 |
> showing 37 of 273 rows — these rows as CSV