PREVIEW / etf_1hour / 2002-06-24
file: by_date/etf_1hour/2002/2002-06-24.parquet size: 15 KB rows: 322
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-06-24 09:00:00 | SPY | ETF | 98.61 | 99.4 | 98.4 | 98.57 | 3059500.0 |
| 2002-06-24 10:00:00 | SPY | ETF | 98.52 | 98.88 | 98.19 | 98.32 | 3580700.0 |
| 2002-06-24 11:00:00 | SPY | ETF | 98.39 | 98.69 | 97.43 | 97.58 | 2974900.0 |
| 2002-06-24 12:00:00 | SPY | ETF | 97.61 | 97.99 | 97.25 | 97.63 | 2978300.0 |
| 2002-06-24 13:00:00 | SPY | ETF | 97.59 | 99.75 | 97.59 | 99.4 | 7096500.0 |
| 2002-06-24 14:00:00 | SPY | ETF | 99.49 | 100.69 | 99.4 | 100.32 | 4670900.0 |
| 2002-06-24 15:00:00 | SPY | ETF | 100.3 | 100.37 | 98.9 | 99.68 | 3972000.0 |
| 2002-06-24 16:00:00 | SPY | ETF | 99.7 | 99.9 | 99.5 | 99.9 | 2284000.0 |
| 2002-06-24 17:00:00 | SPY | ETF | 99.9 | 99.99 | 99.9 | 99.99 | 5200.0 |
| 2002-06-24 18:00:00 | SPY | ETF | 99.89 | 100.04 | 99.89 | 100.04 | 400.0 |
| 2002-06-24 09:00:00 | QQQ | ETF | 25.45 | 25.87 | 25.35 | 25.46 | 12359900.0 |
| 2002-06-24 10:00:00 | QQQ | ETF | 25.46 | 25.74 | 25.36 | 25.5 | 14327500.0 |
| 2002-06-24 11:00:00 | QQQ | ETF | 25.5 | 25.69 | 25.21 | 25.3 | 10754000.0 |
| 2002-06-24 12:00:00 | QQQ | ETF | 25.31 | 25.47 | 25.24 | 25.44 | 5630900.0 |
| 2002-06-24 13:00:00 | QQQ | ETF | 25.44 | 26.4 | 25.42 | 26.3 | 22055100.0 |
| 2002-06-24 14:00:00 | QQQ | ETF | 26.23 | 26.79 | 26.23 | 26.71 | 23438900.0 |
| 2002-06-24 15:00:00 | QQQ | ETF | 26.72 | 26.75 | 26.03 | 26.35 | 19661000.0 |
| 2002-06-24 16:00:00 | QQQ | ETF | 26.35 | 26.46 | 25.4 | 26.36 | 1954900.0 |
| 2002-06-24 17:00:00 | QQQ | ETF | 26.37 | 26.44 | 26.37 | 26.41 | 142100.0 |
| 2002-06-24 18:00:00 | QQQ | ETF | 26.41 | 26.54 | 26.4 | 26.45 | 51500.0 |
| 2002-06-24 09:00:00 | IWM | ETF | 45.625 | 45.89 | 45.51 | 45.56 | 113400.0 |
| 2002-06-24 10:00:00 | IWM | ETF | 45.63 | 45.735 | 45.465 | 45.505 | 93600.0 |
| 2002-06-24 11:00:00 | IWM | ETF | 45.51 | 45.595 | 45.2 | 45.245 | 215600.0 |
| 2002-06-24 12:00:00 | IWM | ETF | 45.16 | 45.295 | 44.93 | 45.0 | 139400.0 |
| 2002-06-24 13:00:00 | IWM | ETF | 45.095 | 45.56 | 45.09 | 45.56 | 550600.0 |
| 2002-06-24 14:00:00 | IWM | ETF | 45.59 | 46.1 | 45.55 | 45.995 | 422800.0 |
| 2002-06-24 15:00:00 | IWM | ETF | 46.0 | 46.195 | 45.47 | 45.755 | 634200.0 |
| 2002-06-24 16:00:00 | IWM | ETF | 45.755 | 45.775 | 45.655 | 45.655 | 9000.0 |
| 2002-06-24 09:00:00 | DIA | ETF | 92.01 | 92.74 | 91.15 | 92.15 | 586800.0 |
| 2002-06-24 10:00:00 | DIA | ETF | 92.11 | 92.4 | 91.77 | 91.81 | 484800.0 |
| 2002-06-24 11:00:00 | DIA | ETF | 91.85 | 92.2 | 91.01 | 91.2 | 527400.0 |
| 2002-06-24 12:00:00 | DIA | ETF | 91.2 | 91.52 | 90.82 | 91.14 | 406500.0 |
| 2002-06-24 13:00:00 | DIA | ETF | 91.16 | 93.0 | 91.09 | 92.74 | 1032400.0 |
| 2002-06-24 14:00:00 | DIA | ETF | 92.7 | 94.0 | 92.66 | 93.58 | 1806300.0 |
| 2002-06-24 15:00:00 | DIA | ETF | 93.56 | 93.62 | 92.34 | 93.02 | 664200.0 |
| 2002-06-24 16:00:00 | DIA | ETF | 92.95 | 93.3 | 92.6 | 93.0 | 57100.0 |
> showing 36 of 322 rows — these rows as CSV