PREVIEW / etf_1hour / 2002-04-26
file: by_date/etf_1hour/2002/2002-04-26.parquet size: 14 KB rows: 315
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-04-26 09:00:00 | SPY | ETF | 109.79 | 110.01 | 109.54 | 109.68 | 2355500.0 |
| 2002-04-26 10:00:00 | SPY | ETF | 109.65 | 109.71 | 108.61 | 108.81 | 4489900.0 |
| 2002-04-26 11:00:00 | SPY | ETF | 108.81 | 109.06 | 108.34 | 108.96 | 2375700.0 |
| 2002-04-26 12:00:00 | SPY | ETF | 108.95 | 109.0 | 108.43 | 108.53 | 878700.0 |
| 2002-04-26 13:00:00 | SPY | ETF | 108.52 | 108.86 | 108.33 | 108.76 | 1856000.0 |
| 2002-04-26 14:00:00 | SPY | ETF | 108.76 | 109.07 | 108.51 | 108.54 | 1204400.0 |
| 2002-04-26 15:00:00 | SPY | ETF | 108.5 | 108.59 | 107.9 | 107.95 | 3013600.0 |
| 2002-04-26 16:00:00 | SPY | ETF | 107.9 | 108.01 | 107.29 | 107.31 | 2522700.0 |
| 2002-04-26 17:00:00 | SPY | ETF | 107.35 | 107.59 | 107.3 | 107.59 | 14200.0 |
| 2002-04-26 18:00:00 | SPY | ETF | 107.39 | 107.39 | 107.39 | 107.39 | 100.0 |
| 2002-04-26 09:00:00 | QQQ | ETF | 32.66 | 32.78 | 32.45 | 32.5 | 11079300.0 |
| 2002-04-26 10:00:00 | QQQ | ETF | 32.53 | 32.56 | 31.91 | 32.01 | 22144400.0 |
| 2002-04-26 11:00:00 | QQQ | ETF | 32.01 | 32.05 | 31.74 | 31.93 | 13426100.0 |
| 2002-04-26 12:00:00 | QQQ | ETF | 31.91 | 31.96 | 31.51 | 31.57 | 9090700.0 |
| 2002-04-26 13:00:00 | QQQ | ETF | 31.56 | 31.73 | 31.4 | 31.7 | 11728000.0 |
| 2002-04-26 14:00:00 | QQQ | ETF | 31.7 | 31.85 | 31.5 | 31.51 | 7465100.0 |
| 2002-04-26 15:00:00 | QQQ | ETF | 31.53 | 31.59 | 31.17 | 31.17 | 17131800.0 |
| 2002-04-26 16:00:00 | QQQ | ETF | 31.2 | 31.36 | 31.0 | 31.06 | 4877400.0 |
| 2002-04-26 17:00:00 | QQQ | ETF | 31.05 | 31.07 | 30.95 | 31.01 | 76400.0 |
| 2002-04-26 18:00:00 | QQQ | ETF | 30.9 | 30.98 | 30.9 | 30.95 | 16600.0 |
| 2002-04-26 09:00:00 | IWM | ETF | 50.81 | 50.945 | 50.615 | 50.615 | 80000.0 |
| 2002-04-26 10:00:00 | IWM | ETF | 50.645 | 50.67 | 50.25 | 50.335 | 178000.0 |
| 2002-04-26 11:00:00 | IWM | ETF | 50.27 | 50.27 | 50.085 | 50.225 | 178800.0 |
| 2002-04-26 12:00:00 | IWM | ETF | 50.245 | 50.245 | 50.045 | 50.125 | 136800.0 |
| 2002-04-26 13:00:00 | IWM | ETF | 50.075 | 50.285 | 50.0 | 50.26 | 363200.0 |
| 2002-04-26 14:00:00 | IWM | ETF | 50.285 | 50.35 | 50.15 | 50.155 | 290600.0 |
| 2002-04-26 15:00:00 | IWM | ETF | 50.15 | 50.5 | 49.805 | 49.805 | 470600.0 |
| 2002-04-26 16:00:00 | IWM | ETF | 49.91 | 50.19 | 49.685 | 50.19 | 415000.0 |
| 2002-04-26 09:00:00 | DIA | ETF | 100.9 | 100.97 | 100.52 | 100.57 | 477900.0 |
| 2002-04-26 10:00:00 | DIA | ETF | 100.71 | 100.72 | 99.9 | 100.04 | 574800.0 |
| 2002-04-26 11:00:00 | DIA | ETF | 99.98 | 100.24 | 99.6 | 100.12 | 942900.0 |
| 2002-04-26 12:00:00 | DIA | ETF | 100.14 | 100.19 | 99.79 | 99.83 | 117900.0 |
| 2002-04-26 13:00:00 | DIA | ETF | 99.8 | 100.1 | 99.68 | 99.91 | 519100.0 |
| 2002-04-26 14:00:00 | DIA | ETF | 100.04 | 100.28 | 99.7 | 99.76 | 236100.0 |
| 2002-04-26 15:00:00 | DIA | ETF | 99.71 | 99.84 | 99.2 | 99.25 | 1077900.0 |
| 2002-04-26 16:00:00 | DIA | ETF | 99.25 | 99.3 | 98.71 | 98.9 | 181300.0 |
| 2002-04-26 17:00:00 | DIA | ETF | 99.0 | 99.15 | 99.0 | 99.15 | 2000.0 |
> showing 37 of 315 rows — these rows as CSV