PREVIEW / etf_1hour / 2002-05-29
file: by_date/etf_1hour/2002/2002-05-29.parquet size: 14 KB rows: 310
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-29 09:00:00 | SPY | ETF | 107.62 | 107.94 | 107.53 | 107.85 | 1095600.0 |
| 2002-05-29 10:00:00 | SPY | ETF | 107.89 | 108.02 | 107.29 | 107.48 | 3824800.0 |
| 2002-05-29 11:00:00 | SPY | ETF | 107.5 | 107.9 | 107.4 | 107.82 | 917300.0 |
| 2002-05-29 12:00:00 | SPY | ETF | 107.87 | 107.94 | 107.52 | 107.58 | 1826900.0 |
| 2002-05-29 13:00:00 | SPY | ETF | 107.57 | 107.68 | 107.31 | 107.53 | 2528500.0 |
| 2002-05-29 14:00:00 | SPY | ETF | 107.58 | 107.82 | 107.39 | 107.53 | 1275300.0 |
| 2002-05-29 15:00:00 | SPY | ETF | 107.53 | 107.7 | 107.25 | 107.25 | 2422000.0 |
| 2002-05-29 16:00:00 | SPY | ETF | 107.26 | 107.34 | 107.13 | 107.26 | 867000.0 |
| 2002-05-29 17:00:00 | SPY | ETF | 107.32 | 107.36 | 107.25 | 107.36 | 9100.0 |
| 2002-05-29 18:00:00 | SPY | ETF | 107.43 | 107.43 | 107.43 | 107.43 | 200.0 |
| 2002-05-29 09:00:00 | QQQ | ETF | 30.66 | 30.81 | 30.54 | 30.75 | 12148600.0 |
| 2002-05-29 10:00:00 | QQQ | ETF | 30.75 | 30.9 | 30.39 | 30.55 | 19892600.0 |
| 2002-05-29 11:00:00 | QQQ | ETF | 30.55 | 30.71 | 30.5 | 30.7 | 8073000.0 |
| 2002-05-29 12:00:00 | QQQ | ETF | 30.69 | 30.72 | 30.45 | 30.54 | 3747400.0 |
| 2002-05-29 13:00:00 | QQQ | ETF | 30.51 | 30.56 | 30.35 | 30.44 | 7017800.0 |
| 2002-05-29 14:00:00 | QQQ | ETF | 30.45 | 30.67 | 30.36 | 30.51 | 8164100.0 |
| 2002-05-29 15:00:00 | QQQ | ETF | 30.52 | 30.6 | 30.3 | 30.34 | 10100000.0 |
| 2002-05-29 16:00:00 | QQQ | ETF | 30.32 | 30.35 | 30.22 | 30.33 | 4268700.0 |
| 2002-05-29 17:00:00 | QQQ | ETF | 30.33 | 30.35 | 30.28 | 30.33 | 35700.0 |
| 2002-05-29 18:00:00 | QQQ | ETF | 30.32 | 30.34 | 30.27 | 30.32 | 8500.0 |
| 2002-05-29 09:00:00 | IWM | ETF | 48.95 | 48.95 | 48.74 | 48.805 | 148000.0 |
| 2002-05-29 10:00:00 | IWM | ETF | 48.85 | 48.925 | 48.4 | 48.47 | 681000.0 |
| 2002-05-29 11:00:00 | IWM | ETF | 48.47 | 48.61 | 48.46 | 48.61 | 348200.0 |
| 2002-05-29 12:00:00 | IWM | ETF | 48.56 | 48.66 | 48.49 | 48.57 | 44400.0 |
| 2002-05-29 13:00:00 | IWM | ETF | 48.49 | 48.52 | 48.45 | 48.49 | 216800.0 |
| 2002-05-29 14:00:00 | IWM | ETF | 48.495 | 48.59 | 48.45 | 48.45 | 89600.0 |
| 2002-05-29 15:00:00 | IWM | ETF | 48.475 | 48.515 | 48.34 | 48.5 | 418600.0 |
| 2002-05-29 16:00:00 | IWM | ETF | 48.435 | 48.765 | 48.435 | 48.5 | 3000.0 |
| 2002-05-29 09:00:00 | DIA | ETF | 99.66 | 100.05 | 99.62 | 99.92 | 431500.0 |
| 2002-05-29 10:00:00 | DIA | ETF | 99.94 | 100.06 | 99.4 | 99.57 | 770000.0 |
| 2002-05-29 11:00:00 | DIA | ETF | 99.56 | 100.01 | 99.54 | 99.92 | 410400.0 |
| 2002-05-29 12:00:00 | DIA | ETF | 99.92 | 100.06 | 99.65 | 99.73 | 230600.0 |
| 2002-05-29 13:00:00 | DIA | ETF | 99.67 | 99.73 | 99.45 | 99.69 | 167800.0 |
| 2002-05-29 14:00:00 | DIA | ETF | 99.65 | 99.96 | 99.54 | 99.6 | 345200.0 |
| 2002-05-29 15:00:00 | DIA | ETF | 99.76 | 99.84 | 99.41 | 99.43 | 321100.0 |
| 2002-05-29 16:00:00 | DIA | ETF | 99.4 | 99.47 | 99.31 | 99.35 | 133600.0 |
| 2002-05-29 18:00:00 | DIA | ETF | 99.38 | 99.38 | 99.38 | 99.38 | 200.0 |
> showing 37 of 310 rows — these rows as CSV