PREVIEW / etf_1hour / 2002-12-30
file: by_date/etf_1hour/2002/2002-12-30.parquet size: 16 KB rows: 375
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-12-30 08:00:00 | SPY | ETF | 87.8 | 88.03 | 87.8 | 87.88 | 6100.0 |
| 2002-12-30 09:00:00 | SPY | ETF | 87.93 | 88.05 | 87.57 | 87.64 | 3685100.0 |
| 2002-12-30 10:00:00 | SPY | ETF | 87.66 | 88.08 | 87.41 | 87.52 | 5494600.0 |
| 2002-12-30 11:00:00 | SPY | ETF | 87.53 | 87.63 | 87.22 | 87.59 | 3759500.0 |
| 2002-12-30 12:00:00 | SPY | ETF | 87.58 | 87.94 | 87.56 | 87.7 | 2872500.0 |
| 2002-12-30 13:00:00 | SPY | ETF | 87.7 | 88.19 | 87.61 | 88.03 | 2115400.0 |
| 2002-12-30 14:00:00 | SPY | ETF | 88.07 | 88.13 | 87.85 | 88.07 | 2150100.0 |
| 2002-12-30 15:00:00 | SPY | ETF | 88.06 | 88.47 | 88.04 | 88.09 | 4503800.0 |
| 2002-12-30 16:00:00 | SPY | ETF | 88.09 | 88.55 | 87.94 | 88.15 | 1997300.0 |
| 2002-12-30 17:00:00 | SPY | ETF | 88.06 | 88.08 | 87.99 | 88.02 | 4100.0 |
| 2002-12-30 18:00:00 | SPY | ETF | 88.03 | 88.13 | 88.03 | 88.13 | 2800.0 |
| 2002-12-30 08:00:00 | QQQ | ETF | 24.5 | 24.96 | 24.5 | 24.92 | 48200.0 |
| 2002-12-30 09:00:00 | QQQ | ETF | 24.92 | 24.97 | 24.75 | 24.76 | 6495000.0 |
| 2002-12-30 10:00:00 | QQQ | ETF | 24.75 | 24.94 | 24.5 | 24.55 | 10593400.0 |
| 2002-12-30 11:00:00 | QQQ | ETF | 24.52 | 24.58 | 24.36 | 24.47 | 9205900.0 |
| 2002-12-30 12:00:00 | QQQ | ETF | 24.47 | 24.56 | 24.44 | 24.48 | 6326200.0 |
| 2002-12-30 13:00:00 | QQQ | ETF | 24.48 | 24.66 | 24.42 | 24.6 | 4108600.0 |
| 2002-12-30 14:00:00 | QQQ | ETF | 24.61 | 24.63 | 24.5 | 24.59 | 5310800.0 |
| 2002-12-30 15:00:00 | QQQ | ETF | 24.57 | 24.77 | 24.56 | 24.6 | 7241500.0 |
| 2002-12-30 16:00:00 | QQQ | ETF | 24.61 | 24.65 | 24.54 | 24.58 | 1366400.0 |
| 2002-12-30 17:00:00 | QQQ | ETF | 24.57 | 24.57 | 24.54 | 24.56 | 40400.0 |
| 2002-12-30 18:00:00 | QQQ | ETF | 24.55 | 24.6 | 24.55 | 24.57 | 33300.0 |
| 2002-12-30 19:00:00 | QQQ | ETF | 24.57 | 24.57 | 24.54 | 24.55 | 9500.0 |
| 2002-12-30 09:00:00 | IWM | ETF | 38.15 | 38.32 | 38.07 | 38.1 | 522800.0 |
| 2002-12-30 10:00:00 | IWM | ETF | 38.03 | 38.15 | 37.8 | 37.875 | 517800.0 |
| 2002-12-30 11:00:00 | IWM | ETF | 37.835 | 37.835 | 37.65 | 37.75 | 578200.0 |
| 2002-12-30 12:00:00 | IWM | ETF | 37.765 | 37.82 | 37.7 | 37.775 | 416000.0 |
| 2002-12-30 13:00:00 | IWM | ETF | 37.725 | 37.87 | 37.715 | 37.835 | 150600.0 |
| 2002-12-30 14:00:00 | IWM | ETF | 37.84 | 37.94 | 37.805 | 37.91 | 301200.0 |
| 2002-12-30 15:00:00 | IWM | ETF | 37.92 | 38.13 | 37.875 | 37.935 | 668400.0 |
| 2002-12-30 16:00:00 | IWM | ETF | 37.95 | 38.03 | 37.95 | 38.03 | 3800.0 |
| 2002-12-30 08:00:00 | DIA | ETF | 83.4 | 83.4 | 83.35 | 83.35 | 4500.0 |
| 2002-12-30 09:00:00 | DIA | ETF | 83.35 | 83.42 | 82.84 | 82.91 | 855700.0 |
| 2002-12-30 10:00:00 | DIA | ETF | 82.91 | 83.4 | 82.65 | 82.97 | 989500.0 |
| 2002-12-30 11:00:00 | DIA | ETF | 82.99 | 83.08 | 82.64 | 83.03 | 637700.0 |
| 2002-12-30 12:00:00 | DIA | ETF | 83.06 | 83.33 | 83.01 | 83.1 | 498500.0 |
| 2002-12-30 13:00:00 | DIA | ETF | 83.11 | 83.5 | 83.0 | 83.43 | 673800.0 |
| 2002-12-30 14:00:00 | DIA | ETF | 83.41 | 83.46 | 83.21 | 83.39 | 308300.0 |
| 2002-12-30 15:00:00 | DIA | ETF | 83.38 | 83.79 | 83.32 | 83.38 | 1019100.0 |
| 2002-12-30 16:00:00 | DIA | ETF | 83.38 | 83.42 | 83.26 | 83.39 | 271500.0 |
| 2002-12-30 09:00:00 | TLT | ETF | 88.9 | 88.91 | 88.76 | 88.9 | 112700.0 |
| 2002-12-30 10:00:00 | TLT | ETF | 89.0 | 89.0 | 88.63 | 88.8 | 14600.0 |
| 2002-12-30 11:00:00 | TLT | ETF | 88.97 | 89.05 | 88.97 | 89.05 | 1200.0 |
| 2002-12-30 12:00:00 | TLT | ETF | 89.01 | 89.05 | 88.91 | 89.05 | 12100.0 |
| 2002-12-30 13:00:00 | TLT | ETF | 89.1 | 89.14 | 89.1 | 89.14 | 1400.0 |
| 2002-12-30 14:00:00 | TLT | ETF | 89.12 | 89.21 | 89.12 | 89.16 | 7900.0 |
| 2002-12-30 15:00:00 | TLT | ETF | 89.16 | 89.24 | 89.14 | 89.24 | 120700.0 |
> showing 47 of 375 rows — these rows as CSV