PREVIEW / etf_1hour / 2002-06-03
file: by_date/etf_1hour/2002/2002-06-03.parquet size: 14 KB rows: 321
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-03 09:00:00 | SPY | ETF | 107.09 | 107.32 | 106.89 | 107.13 | 2321400.0 |
| 2002-06-03 10:00:00 | SPY | ETF | 107.15 | 107.6 | 106.06 | 106.1 | 5359600.0 |
| 2002-06-03 11:00:00 | SPY | ETF | 106.1 | 106.26 | 105.75 | 106.02 | 1415700.0 |
| 2002-06-03 12:00:00 | SPY | ETF | 105.95 | 106.06 | 105.55 | 105.96 | 2054800.0 |
| 2002-06-03 13:00:00 | SPY | ETF | 105.97 | 106.09 | 105.5 | 105.91 | 2102000.0 |
| 2002-06-03 14:00:00 | SPY | ETF | 105.97 | 106.18 | 105.74 | 105.82 | 2510200.0 |
| 2002-06-03 15:00:00 | SPY | ETF | 105.84 | 105.97 | 104.25 | 104.3 | 6556900.0 |
| 2002-06-03 16:00:00 | SPY | ETF | 104.25 | 105.2 | 104.13 | 104.42 | 1852100.0 |
| 2002-06-03 17:00:00 | SPY | ETF | 104.38 | 104.48 | 104.37 | 104.37 | 68900.0 |
| 2002-06-03 18:00:00 | SPY | ETF | 104.52 | 104.61 | 104.47 | 104.61 | 800.0 |
| 2002-06-03 09:00:00 | QQQ | ETF | 30.0 | 30.06 | 29.86 | 29.93 | 7496700.0 |
| 2002-06-03 10:00:00 | QQQ | ETF | 29.93 | 30.25 | 29.36 | 29.39 | 19326700.0 |
| 2002-06-03 11:00:00 | QQQ | ETF | 29.44 | 29.5 | 29.27 | 29.41 | 6969400.0 |
| 2002-06-03 12:00:00 | QQQ | ETF | 29.4 | 29.44 | 29.2 | 29.41 | 7431900.0 |
| 2002-06-03 13:00:00 | QQQ | ETF | 29.4 | 29.48 | 29.2 | 29.38 | 6130400.0 |
| 2002-06-03 14:00:00 | QQQ | ETF | 29.38 | 29.54 | 29.26 | 29.3 | 7241200.0 |
| 2002-06-03 15:00:00 | QQQ | ETF | 29.31 | 29.36 | 28.79 | 28.85 | 15528900.0 |
| 2002-06-03 16:00:00 | QQQ | ETF | 28.86 | 29.0 | 28.81 | 28.95 | 3097800.0 |
| 2002-06-03 17:00:00 | QQQ | ETF | 28.92 | 28.96 | 28.89 | 28.89 | 50000.0 |
| 2002-06-03 18:00:00 | QQQ | ETF | 28.9 | 28.98 | 28.9 | 28.96 | 29200.0 |
| 2002-06-03 09:00:00 | IWM | ETF | 48.475 | 48.475 | 48.21 | 48.4 | 42800.0 |
| 2002-06-03 10:00:00 | IWM | ETF | 48.365 | 48.475 | 47.6 | 47.725 | 649200.0 |
| 2002-06-03 11:00:00 | IWM | ETF | 47.7 | 47.775 | 47.6 | 47.65 | 96400.0 |
| 2002-06-03 12:00:00 | IWM | ETF | 47.6 | 47.63 | 47.525 | 47.625 | 382600.0 |
| 2002-06-03 13:00:00 | IWM | ETF | 47.615 | 47.715 | 47.58 | 47.675 | 341400.0 |
| 2002-06-03 14:00:00 | IWM | ETF | 47.72 | 47.79 | 47.655 | 47.68 | 55200.0 |
| 2002-06-03 15:00:00 | IWM | ETF | 47.7 | 47.7 | 47.145 | 47.145 | 142800.0 |
| 2002-06-03 16:00:00 | IWM | ETF | 47.08 | 47.5 | 47.08 | 47.125 | 130200.0 |
| 2002-06-03 09:00:00 | DIA | ETF | 99.28 | 99.82 | 99.28 | 99.66 | 389300.0 |
| 2002-06-03 10:00:00 | DIA | ETF | 99.74 | 100.11 | 98.61 | 98.67 | 945000.0 |
| 2002-06-03 11:00:00 | DIA | ETF | 98.67 | 98.76 | 98.4 | 98.65 | 607100.0 |
| 2002-06-03 12:00:00 | DIA | ETF | 98.65 | 98.7 | 98.21 | 98.55 | 595700.0 |
| 2002-06-03 13:00:00 | DIA | ETF | 98.57 | 98.75 | 98.23 | 98.63 | 653700.0 |
| 2002-06-03 14:00:00 | DIA | ETF | 98.62 | 98.85 | 98.43 | 98.54 | 338500.0 |
| 2002-06-03 15:00:00 | DIA | ETF | 98.5 | 98.71 | 97.0 | 97.11 | 1452500.0 |
| 2002-06-03 16:00:00 | DIA | ETF | 97.1 | 97.14 | 96.91 | 97.05 | 153100.0 |
| 2002-06-03 17:00:00 | DIA | ETF | 97.1 | 97.15 | 97.1 | 97.1 | 1500.0 |
| 2002-06-03 18:00:00 | DIA | ETF | 97.15 | 97.15 | 97.15 | 97.15 | 100.0 |
> showing 38 of 321 rows — these rows as CSV