PREVIEW / etf_1hour / 2002-02-25
file: by_date/etf_1hour/2002/2002-02-25.parquet size: 13 KB rows: 290
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-25 09:00:00 | SPY | ETF | 109.74 | 110.39 | 109.7 | 110.29 | 2678200.0 |
| 2002-02-25 10:00:00 | SPY | ETF | 110.29 | 110.61 | 110.1 | 110.26 | 2376600.0 |
| 2002-02-25 11:00:00 | SPY | ETF | 110.22 | 110.61 | 110.2 | 110.45 | 1981800.0 |
| 2002-02-25 12:00:00 | SPY | ETF | 110.46 | 110.74 | 110.3 | 110.46 | 1389100.0 |
| 2002-02-25 13:00:00 | SPY | ETF | 110.42 | 110.88 | 110.35 | 110.7 | 938100.0 |
| 2002-02-25 14:00:00 | SPY | ETF | 110.72 | 111.45 | 110.65 | 111.37 | 2060800.0 |
| 2002-02-25 15:00:00 | SPY | ETF | 111.38 | 111.81 | 111.35 | 111.5 | 3503600.0 |
| 2002-02-25 16:00:00 | SPY | ETF | 111.53 | 111.7 | 111.31 | 111.44 | 1080500.0 |
| 2002-02-25 17:00:00 | SPY | ETF | 111.43 | 111.44 | 111.42 | 111.44 | 10200.0 |
| 2002-02-25 18:00:00 | SPY | ETF | 111.44 | 111.44 | 111.44 | 111.44 | 400.0 |
| 2002-02-25 09:00:00 | QQQ | ETF | 34.0 | 34.32 | 33.95 | 34.17 | 13318800.0 |
| 2002-02-25 10:00:00 | QQQ | ETF | 34.22 | 34.35 | 33.96 | 34.15 | 11558900.0 |
| 2002-02-25 11:00:00 | QQQ | ETF | 34.15 | 34.47 | 34.12 | 34.38 | 9787900.0 |
| 2002-02-25 12:00:00 | QQQ | ETF | 34.4 | 34.56 | 34.22 | 34.44 | 10663800.0 |
| 2002-02-25 13:00:00 | QQQ | ETF | 34.45 | 34.76 | 34.4 | 34.7 | 8488900.0 |
| 2002-02-25 14:00:00 | QQQ | ETF | 34.72 | 35.14 | 34.63 | 35.08 | 14056000.0 |
| 2002-02-25 15:00:00 | QQQ | ETF | 35.08 | 35.24 | 34.96 | 35.01 | 16904100.0 |
| 2002-02-25 16:00:00 | QQQ | ETF | 35.04 | 35.08 | 34.93 | 35.0 | 1667500.0 |
| 2002-02-25 17:00:00 | QQQ | ETF | 35.0 | 35.05 | 34.98 | 35.04 | 52000.0 |
| 2002-02-25 18:00:00 | QQQ | ETF | 35.05 | 35.1 | 35.04 | 35.07 | 9000.0 |
| 2002-02-25 09:00:00 | IWM | ETF | 46.375 | 46.545 | 46.35 | 46.495 | 29400.0 |
| 2002-02-25 10:00:00 | IWM | ETF | 46.39 | 46.465 | 46.175 | 46.22 | 205600.0 |
| 2002-02-25 11:00:00 | IWM | ETF | 46.305 | 46.375 | 46.22 | 46.26 | 24800.0 |
| 2002-02-25 12:00:00 | IWM | ETF | 46.34 | 46.375 | 46.22 | 46.25 | 49400.0 |
| 2002-02-25 13:00:00 | IWM | ETF | 46.3 | 46.4 | 46.285 | 46.39 | 53800.0 |
| 2002-02-25 14:00:00 | IWM | ETF | 46.36 | 46.62 | 46.335 | 46.525 | 111000.0 |
| 2002-02-25 15:00:00 | IWM | ETF | 46.55 | 46.605 | 46.45 | 46.59 | 235000.0 |
| 2002-02-25 16:00:00 | IWM | ETF | 46.5 | 46.665 | 46.5 | 46.665 | 16800.0 |
| 2002-02-25 09:00:00 | DIA | ETF | 100.06 | 100.75 | 99.98 | 100.62 | 2221300.0 |
| 2002-02-25 10:00:00 | DIA | ETF | 100.64 | 101.06 | 100.59 | 100.85 | 1383100.0 |
| 2002-02-25 11:00:00 | DIA | ETF | 100.85 | 101.0 | 100.58 | 100.8 | 1607300.0 |
| 2002-02-25 12:00:00 | DIA | ETF | 100.9 | 101.05 | 100.62 | 100.72 | 277000.0 |
| 2002-02-25 13:00:00 | DIA | ETF | 100.71 | 101.07 | 100.63 | 100.95 | 542200.0 |
| 2002-02-25 14:00:00 | DIA | ETF | 100.86 | 101.54 | 100.86 | 101.54 | 612700.0 |
| 2002-02-25 15:00:00 | DIA | ETF | 101.46 | 101.94 | 101.46 | 101.64 | 1623700.0 |
| 2002-02-25 16:00:00 | DIA | ETF | 101.61 | 101.95 | 101.57 | 101.95 | 324200.0 |
> showing 36 of 290 rows — these rows as CSV