PREVIEW / etf_1hour / 2002-05-15
file: by_date/etf_1hour/2002/2002-05-15.parquet size: 14 KB rows: 325
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-15 09:00:00 | SPY | ETF | 109.5 | 109.73 | 109.29 | 109.67 | 2263300.0 |
| 2002-05-15 10:00:00 | SPY | ETF | 109.67 | 109.9 | 109.44 | 109.79 | 2113300.0 |
| 2002-05-15 11:00:00 | SPY | ETF | 109.77 | 110.35 | 109.77 | 110.01 | 2926600.0 |
| 2002-05-15 12:00:00 | SPY | ETF | 110.0 | 110.03 | 109.57 | 109.97 | 2619800.0 |
| 2002-05-15 13:00:00 | SPY | ETF | 109.96 | 110.84 | 109.92 | 110.68 | 2747900.0 |
| 2002-05-15 14:00:00 | SPY | ETF | 110.7 | 110.91 | 109.55 | 109.89 | 7114900.0 |
| 2002-05-15 15:00:00 | SPY | ETF | 109.87 | 109.95 | 109.4 | 109.55 | 6100900.0 |
| 2002-05-15 16:00:00 | SPY | ETF | 109.54 | 109.92 | 109.48 | 109.92 | 1779900.0 |
| 2002-05-15 17:00:00 | SPY | ETF | 109.91 | 109.91 | 109.8 | 109.9 | 3100.0 |
| 2002-05-15 18:00:00 | SPY | ETF | 109.95 | 109.95 | 109.8 | 109.8 | 1500.0 |
| 2002-05-15 09:00:00 | QQQ | ETF | 32.08 | 32.18 | 31.85 | 32.16 | 12627700.0 |
| 2002-05-15 10:00:00 | QQQ | ETF | 32.16 | 32.59 | 32.07 | 32.44 | 22268000.0 |
| 2002-05-15 11:00:00 | QQQ | ETF | 32.44 | 32.91 | 32.43 | 32.83 | 19176200.0 |
| 2002-05-15 12:00:00 | QQQ | ETF | 32.83 | 33.08 | 32.55 | 32.96 | 16193000.0 |
| 2002-05-15 13:00:00 | QQQ | ETF | 32.99 | 33.5 | 32.98 | 33.43 | 15071700.0 |
| 2002-05-15 14:00:00 | QQQ | ETF | 33.43 | 33.63 | 32.61 | 32.81 | 30896800.0 |
| 2002-05-15 15:00:00 | QQQ | ETF | 32.84 | 32.91 | 32.55 | 32.63 | 23359600.0 |
| 2002-05-15 16:00:00 | QQQ | ETF | 32.63 | 33.0 | 32.58 | 32.75 | 2756300.0 |
| 2002-05-15 17:00:00 | QQQ | ETF | 32.75 | 32.94 | 32.73 | 32.78 | 53955900.0 |
| 2002-05-15 18:00:00 | QQQ | ETF | 32.78 | 32.81 | 32.74 | 32.78 | 112200.0 |
| 2002-05-15 09:00:00 | IWM | ETF | 50.875 | 50.9 | 50.58 | 50.9 | 239000.0 |
| 2002-05-15 10:00:00 | IWM | ETF | 50.875 | 51.295 | 50.86 | 51.135 | 547600.0 |
| 2002-05-15 11:00:00 | IWM | ETF | 51.14 | 51.315 | 51.07 | 51.105 | 235800.0 |
| 2002-05-15 12:00:00 | IWM | ETF | 51.115 | 51.145 | 50.965 | 51.1 | 80200.0 |
| 2002-05-15 13:00:00 | IWM | ETF | 51.11 | 51.39 | 51.1 | 51.39 | 73400.0 |
| 2002-05-15 14:00:00 | IWM | ETF | 51.37 | 51.41 | 50.975 | 51.06 | 309600.0 |
| 2002-05-15 15:00:00 | IWM | ETF | 51.06 | 51.14 | 50.9 | 50.94 | 278000.0 |
| 2002-05-15 16:00:00 | IWM | ETF | 50.97 | 51.15 | 50.95 | 51.15 | 18400.0 |
| 2002-05-15 17:00:00 | IWM | ETF | 51.14 | 51.14 | 51.14 | 51.14 | 606200.0 |
| 2002-05-15 09:00:00 | DIA | ETF | 102.66 | 102.82 | 102.39 | 102.73 | 330000.0 |
| 2002-05-15 10:00:00 | DIA | ETF | 102.75 | 102.78 | 102.4 | 102.7 | 626400.0 |
| 2002-05-15 11:00:00 | DIA | ETF | 102.71 | 103.16 | 102.71 | 102.85 | 503000.0 |
| 2002-05-15 12:00:00 | DIA | ETF | 102.89 | 102.89 | 102.55 | 102.76 | 112700.0 |
| 2002-05-15 13:00:00 | DIA | ETF | 102.78 | 103.7 | 102.78 | 103.6 | 639300.0 |
| 2002-05-15 14:00:00 | DIA | ETF | 103.57 | 103.73 | 102.61 | 102.84 | 628000.0 |
| 2002-05-15 15:00:00 | DIA | ETF | 102.81 | 102.99 | 102.4 | 102.6 | 696600.0 |
| 2002-05-15 16:00:00 | DIA | ETF | 102.64 | 102.95 | 102.55 | 102.95 | 75700.0 |
> showing 37 of 325 rows — these rows as CSV