PREVIEW / etf_1hour / 2003-06-10
file: by_date/etf_1hour/2003/2003-06-10.parquet size: 17 KB rows: 417
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 |
|---|---|---|---|---|---|---|---|
| 2003-06-10 08:00:00 | SPY | ETF | 98.65 | 98.65 | 98.54 | 98.61 | 24500.0 |
| 2003-06-10 09:00:00 | SPY | ETF | 98.62 | 98.84 | 98.39 | 98.55 | 5107000.0 |
| 2003-06-10 10:00:00 | SPY | ETF | 98.56 | 98.87 | 98.19 | 98.42 | 9233800.0 |
| 2003-06-10 11:00:00 | SPY | ETF | 98.45 | 98.75 | 98.25 | 98.53 | 2275400.0 |
| 2003-06-10 12:00:00 | SPY | ETF | 98.55 | 98.82 | 98.52 | 98.72 | 2032500.0 |
| 2003-06-10 13:00:00 | SPY | ETF | 98.75 | 98.89 | 98.48 | 98.64 | 2009300.0 |
| 2003-06-10 14:00:00 | SPY | ETF | 98.61 | 98.66 | 98.29 | 98.39 | 1858500.0 |
| 2003-06-10 15:00:00 | SPY | ETF | 98.4 | 99.06 | 98.25 | 99.05 | 3144900.0 |
| 2003-06-10 16:00:00 | SPY | ETF | 99.03 | 99.26 | 99.01 | 99.13 | 1783400.0 |
| 2003-06-10 17:00:00 | SPY | ETF | 99.14 | 99.26 | 99.05 | 99.1 | 444100.0 |
| 2003-06-10 18:00:00 | SPY | ETF | 99.1 | 99.12 | 99.06 | 99.1 | 7800.0 |
| 2003-06-10 19:00:00 | SPY | ETF | 99.09 | 99.18 | 99.07 | 99.17 | 9700.0 |
| 2003-06-10 08:00:00 | QQQ | ETF | 29.91 | 29.92 | 29.82 | 29.87 | 47700.0 |
| 2003-06-10 09:00:00 | QQQ | ETF | 29.86 | 30.03 | 29.7 | 29.83 | 14846400.0 |
| 2003-06-10 10:00:00 | QQQ | ETF | 29.83 | 30.0 | 29.68 | 29.76 | 12106400.0 |
| 2003-06-10 11:00:00 | QQQ | ETF | 29.76 | 29.95 | 29.68 | 29.84 | 7603200.0 |
| 2003-06-10 12:00:00 | QQQ | ETF | 29.84 | 29.97 | 29.84 | 29.92 | 3313300.0 |
| 2003-06-10 13:00:00 | QQQ | ETF | 29.92 | 29.98 | 29.82 | 29.88 | 5171900.0 |
| 2003-06-10 14:00:00 | QQQ | ETF | 29.88 | 29.9 | 29.77 | 29.83 | 4685500.0 |
| 2003-06-10 15:00:00 | QQQ | ETF | 29.85 | 30.18 | 29.77 | 30.15 | 10234200.0 |
| 2003-06-10 16:00:00 | QQQ | ETF | 30.15 | 30.2 | 30.05 | 30.09 | 4979200.0 |
| 2003-06-10 17:00:00 | QQQ | ETF | 30.08 | 30.11 | 29.98 | 30.02 | 1858400.0 |
| 2003-06-10 18:00:00 | QQQ | ETF | 30.02 | 30.05 | 30.02 | 30.03 | 43900.0 |
| 2003-06-10 19:00:00 | QQQ | ETF | 30.04 | 30.08 | 30.04 | 30.05 | 18600.0 |
| 2003-06-10 09:00:00 | IWM | ETF | 44.49 | 44.81 | 44.49 | 44.675 | 218400.0 |
| 2003-06-10 10:00:00 | IWM | ETF | 44.685 | 44.765 | 44.5 | 44.54 | 1121000.0 |
| 2003-06-10 11:00:00 | IWM | ETF | 44.54 | 44.68 | 44.48 | 44.64 | 299800.0 |
| 2003-06-10 12:00:00 | IWM | ETF | 44.65 | 44.84 | 44.65 | 44.805 | 370600.0 |
| 2003-06-10 13:00:00 | IWM | ETF | 44.83 | 44.91 | 44.76 | 44.8 | 328200.0 |
| 2003-06-10 14:00:00 | IWM | ETF | 44.805 | 44.845 | 44.765 | 44.82 | 55400.0 |
| 2003-06-10 15:00:00 | IWM | ETF | 44.815 | 45.075 | 44.755 | 45.05 | 303400.0 |
| 2003-06-10 16:00:00 | IWM | ETF | 45.095 | 45.095 | 45.005 | 45.025 | 146400.0 |
| 2003-06-10 08:00:00 | DIA | ETF | 90.55 | 90.55 | 90.38 | 90.55 | 4200.0 |
| 2003-06-10 09:00:00 | DIA | ETF | 90.51 | 90.86 | 90.45 | 90.65 | 1358500.0 |
| 2003-06-10 10:00:00 | DIA | ETF | 90.65 | 90.9 | 90.26 | 90.41 | 1551700.0 |
| 2003-06-10 11:00:00 | DIA | ETF | 90.4 | 90.69 | 90.23 | 90.5 | 663500.0 |
| 2003-06-10 12:00:00 | DIA | ETF | 90.55 | 90.71 | 90.55 | 90.62 | 392000.0 |
| 2003-06-10 13:00:00 | DIA | ETF | 90.61 | 90.76 | 90.43 | 90.54 | 409600.0 |
| 2003-06-10 14:00:00 | DIA | ETF | 90.52 | 90.58 | 90.26 | 90.35 | 545800.0 |
| 2003-06-10 15:00:00 | DIA | ETF | 90.37 | 90.85 | 90.16 | 90.84 | 878400.0 |
| 2003-06-10 16:00:00 | DIA | ETF | 90.81 | 91.1 | 90.79 | 90.95 | 274300.0 |
| 2003-06-10 17:00:00 | DIA | ETF | 90.93 | 90.97 | 90.85 | 90.85 | 8400.0 |
| 2003-06-10 18:00:00 | DIA | ETF | 90.89 | 90.89 | 90.89 | 90.89 | 200.0 |
| 2003-06-10 09:00:00 | TLT | ETF | 95.08 | 95.25 | 95.07 | 95.23 | 94600.0 |
| 2003-06-10 10:00:00 | TLT | ETF | 95.17 | 95.33 | 95.13 | 95.19 | 12800.0 |
| 2003-06-10 11:00:00 | TLT | ETF | 95.23 | 95.67 | 95.18 | 95.65 | 44300.0 |
| 2003-06-10 12:00:00 | TLT | ETF | 95.7 | 95.7 | 95.51 | 95.55 | 44200.0 |
| 2003-06-10 13:00:00 | TLT | ETF | 95.62 | 95.62 | 95.54 | 95.58 | 59800.0 |
| 2003-06-10 14:00:00 | TLT | ETF | 95.58 | 95.89 | 95.58 | 95.84 | 195700.0 |
| 2003-06-10 15:00:00 | TLT | ETF | 95.82 | 95.93 | 95.8 | 95.91 | 72800.0 |
> showing 50 of 417 rows — these rows as CSV