PREVIEW / etf_1hour / 2002-02-22
file: by_date/etf_1hour/2002/2002-02-22.parquet size: 13 KB rows: 283
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-22 09:00:00 | SPY | ETF | 108.35 | 108.83 | 108.04 | 108.55 | 4126100.0 |
| 2002-02-22 10:00:00 | SPY | ETF | 108.5 | 108.91 | 107.88 | 108.32 | 4484800.0 |
| 2002-02-22 11:00:00 | SPY | ETF | 108.33 | 108.67 | 108.08 | 108.25 | 2317500.0 |
| 2002-02-22 12:00:00 | SPY | ETF | 108.22 | 108.43 | 107.87 | 108.2 | 2658600.0 |
| 2002-02-22 13:00:00 | SPY | ETF | 108.12 | 108.64 | 108.0 | 108.31 | 2241400.0 |
| 2002-02-22 14:00:00 | SPY | ETF | 108.28 | 109.65 | 108.28 | 109.61 | 3765100.0 |
| 2002-02-22 15:00:00 | SPY | ETF | 109.64 | 109.94 | 109.0 | 109.37 | 5230500.0 |
| 2002-02-22 16:00:00 | SPY | ETF | 109.4 | 110.6 | 109.27 | 109.5 | 1096900.0 |
| 2002-02-22 09:00:00 | QQQ | ETF | 33.61 | 33.86 | 33.35 | 33.66 | 11216900.0 |
| 2002-02-22 10:00:00 | QQQ | ETF | 33.65 | 33.84 | 33.09 | 33.35 | 16142000.0 |
| 2002-02-22 11:00:00 | QQQ | ETF | 33.35 | 33.59 | 33.23 | 33.26 | 8886300.0 |
| 2002-02-22 12:00:00 | QQQ | ETF | 33.29 | 33.43 | 33.13 | 33.18 | 7176400.0 |
| 2002-02-22 13:00:00 | QQQ | ETF | 33.17 | 33.43 | 33.12 | 33.21 | 7778500.0 |
| 2002-02-22 14:00:00 | QQQ | ETF | 33.23 | 34.1 | 33.21 | 34.08 | 17910400.0 |
| 2002-02-22 15:00:00 | QQQ | ETF | 34.08 | 34.2 | 33.52 | 33.75 | 20624100.0 |
| 2002-02-22 16:00:00 | QQQ | ETF | 33.75 | 33.91 | 33.56 | 33.8 | 6297700.0 |
| 2002-02-22 17:00:00 | QQQ | ETF | 33.8 | 33.8 | 32.84 | 33.65 | 43300.0 |
| 2002-02-22 18:00:00 | QQQ | ETF | 33.66 | 33.79 | 33.6 | 33.73 | 17500.0 |
| 2002-02-22 09:00:00 | IWM | ETF | 45.6 | 45.825 | 45.39 | 45.65 | 61800.0 |
| 2002-02-22 10:00:00 | IWM | ETF | 45.735 | 45.745 | 45.41 | 45.5 | 162600.0 |
| 2002-02-22 11:00:00 | IWM | ETF | 45.5 | 45.635 | 45.48 | 45.615 | 144600.0 |
| 2002-02-22 12:00:00 | IWM | ETF | 45.49 | 45.7 | 45.45 | 45.68 | 189000.0 |
| 2002-02-22 13:00:00 | IWM | ETF | 45.67 | 45.785 | 45.61 | 45.725 | 89600.0 |
| 2002-02-22 14:00:00 | IWM | ETF | 45.715 | 46.255 | 45.705 | 46.255 | 241000.0 |
| 2002-02-22 15:00:00 | IWM | ETF | 46.285 | 46.325 | 46.1 | 46.25 | 423600.0 |
| 2002-02-22 16:00:00 | IWM | ETF | 46.355 | 46.375 | 46.27 | 46.27 | 11600.0 |
| 2002-02-22 09:00:00 | DIA | ETF | 98.5 | 98.85 | 98.04 | 98.6 | 1554900.0 |
| 2002-02-22 10:00:00 | DIA | ETF | 98.6 | 99.0 | 98.22 | 98.67 | 1174000.0 |
| 2002-02-22 11:00:00 | DIA | ETF | 98.73 | 99.0 | 98.57 | 98.77 | 333000.0 |
| 2002-02-22 12:00:00 | DIA | ETF | 98.73 | 98.95 | 98.42 | 98.75 | 356300.0 |
| 2002-02-22 13:00:00 | DIA | ETF | 98.7 | 99.12 | 98.6 | 98.8 | 680200.0 |
| 2002-02-22 14:00:00 | DIA | ETF | 98.84 | 99.98 | 98.84 | 99.97 | 1277800.0 |
| 2002-02-22 15:00:00 | DIA | ETF | 99.85 | 100.25 | 99.4 | 99.7 | 2600100.0 |
| 2002-02-22 16:00:00 | DIA | ETF | 99.76 | 100.24 | 99.66 | 99.98 | 178300.0 |
> showing 34 of 283 rows — these rows as CSV