PREVIEW / etf_1hour / 2003-02-07
file: by_date/etf_1hour/2003/2003-02-07.parquet size: 16 KB rows: 382
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-02-07 08:00:00 | SPY | ETF | 84.65 | 85.37 | 84.48 | 85.04 | 224400.0 |
| 2003-02-07 09:00:00 | SPY | ETF | 85.09 | 85.11 | 84.16 | 84.33 | 7399100.0 |
| 2003-02-07 10:00:00 | SPY | ETF | 84.25 | 84.49 | 83.4 | 83.77 | 8865000.0 |
| 2003-02-07 11:00:00 | SPY | ETF | 83.75 | 84.0 | 83.5 | 83.89 | 3663400.0 |
| 2003-02-07 12:00:00 | SPY | ETF | 83.89 | 83.94 | 83.47 | 83.54 | 2721100.0 |
| 2003-02-07 13:00:00 | SPY | ETF | 83.54 | 83.58 | 83.19 | 83.33 | 3113200.0 |
| 2003-02-07 14:00:00 | SPY | ETF | 83.32 | 83.45 | 83.02 | 83.02 | 3534200.0 |
| 2003-02-07 15:00:00 | SPY | ETF | 83.05 | 83.48 | 82.97 | 83.27 | 7735800.0 |
| 2003-02-07 16:00:00 | SPY | ETF | 83.27 | 83.59 | 83.19 | 83.35 | 2363600.0 |
| 2003-02-07 17:00:00 | SPY | ETF | 83.35 | 83.35 | 83.21 | 83.24 | 4900.0 |
| 2003-02-07 18:00:00 | SPY | ETF | 83.32 | 83.32 | 83.32 | 83.32 | 200.0 |
| 2003-02-07 19:00:00 | SPY | ETF | 83.3 | 83.32 | 83.24 | 83.24 | 1700.0 |
| 2003-02-07 20:00:00 | SPY | ETF | 83.23 | 83.23 | 83.23 | 83.23 | 100.0 |
| 2003-02-07 08:00:00 | QQQ | ETF | 24.25 | 24.55 | 24.19 | 24.48 | 237100.0 |
| 2003-02-07 09:00:00 | QQQ | ETF | 24.48 | 24.48 | 23.95 | 24.09 | 10257900.0 |
| 2003-02-07 10:00:00 | QQQ | ETF | 24.08 | 24.19 | 23.82 | 24.0 | 18732500.0 |
| 2003-02-07 11:00:00 | QQQ | ETF | 23.98 | 24.06 | 23.87 | 24.03 | 6494900.0 |
| 2003-02-07 12:00:00 | QQQ | ETF | 24.03 | 24.06 | 23.9 | 23.91 | 4090200.0 |
| 2003-02-07 13:00:00 | QQQ | ETF | 23.91 | 23.95 | 23.75 | 23.82 | 8563200.0 |
| 2003-02-07 14:00:00 | QQQ | ETF | 23.82 | 23.87 | 23.68 | 23.68 | 6676600.0 |
| 2003-02-07 15:00:00 | QQQ | ETF | 23.68 | 23.86 | 23.65 | 23.79 | 10274100.0 |
| 2003-02-07 16:00:00 | QQQ | ETF | 23.8 | 23.86 | 23.71 | 23.86 | 2370400.0 |
| 2003-02-07 17:00:00 | QQQ | ETF | 23.83 | 23.86 | 23.78 | 23.78 | 48700.0 |
| 2003-02-07 18:00:00 | QQQ | ETF | 23.77 | 23.8 | 23.76 | 23.79 | 12800.0 |
| 2003-02-07 19:00:00 | QQQ | ETF | 23.79 | 23.82 | 23.76 | 23.82 | 9400.0 |
| 2003-02-07 08:00:00 | IWM | ETF | 36.44 | 36.44 | 36.44 | 36.44 | 1000.0 |
| 2003-02-07 09:00:00 | IWM | ETF | 36.52 | 36.6 | 36.235 | 36.25 | 258400.0 |
| 2003-02-07 10:00:00 | IWM | ETF | 36.23 | 36.305 | 35.905 | 36.0 | 526000.0 |
| 2003-02-07 11:00:00 | IWM | ETF | 35.985 | 36.085 | 35.935 | 36.015 | 303800.0 |
| 2003-02-07 12:00:00 | IWM | ETF | 36.015 | 36.06 | 35.98 | 35.985 | 473800.0 |
| 2003-02-07 13:00:00 | IWM | ETF | 36.01 | 36.01 | 35.915 | 35.97 | 179800.0 |
| 2003-02-07 14:00:00 | IWM | ETF | 35.945 | 35.955 | 35.835 | 35.835 | 2383800.0 |
| 2003-02-07 15:00:00 | IWM | ETF | 35.815 | 35.9 | 35.7 | 35.775 | 591400.0 |
| 2003-02-07 16:00:00 | IWM | ETF | 35.73 | 35.75 | 35.64 | 35.66 | 498200.0 |
| 2003-02-07 17:00:00 | IWM | ETF | 35.735 | 35.735 | 35.735 | 35.735 | 2602000.0 |
| 2003-02-07 08:00:00 | DIA | ETF | 79.92 | 80.6 | 79.76 | 80.19 | 33300.0 |
| 2003-02-07 09:00:00 | DIA | ETF | 80.19 | 80.25 | 79.5 | 79.67 | 1216100.0 |
| 2003-02-07 10:00:00 | DIA | ETF | 79.7 | 79.95 | 78.65 | 79.17 | 1766800.0 |
| 2003-02-07 11:00:00 | DIA | ETF | 79.09 | 79.33 | 78.85 | 79.2 | 568100.0 |
| 2003-02-07 12:00:00 | DIA | ETF | 79.18 | 79.25 | 78.79 | 78.9 | 623900.0 |
| 2003-02-07 13:00:00 | DIA | ETF | 78.9 | 78.91 | 78.61 | 78.74 | 558900.0 |
| 2003-02-07 14:00:00 | DIA | ETF | 78.71 | 78.86 | 78.49 | 78.5 | 840000.0 |
| 2003-02-07 15:00:00 | DIA | ETF | 78.5 | 78.98 | 78.4 | 78.82 | 1323100.0 |
| 2003-02-07 16:00:00 | DIA | ETF | 78.79 | 79.02 | 78.71 | 78.95 | 109600.0 |
| 2003-02-07 17:00:00 | DIA | ETF | 78.85 | 78.85 | 78.85 | 78.85 | 500.0 |
| 2003-02-07 18:00:00 | DIA | ETF | 78.8 | 78.8 | 78.8 | 78.8 | 200.0 |
| 2003-02-07 09:00:00 | TLT | ETF | 87.77 | 87.97 | 87.63 | 87.97 | 10600.0 |
| 2003-02-07 10:00:00 | TLT | ETF | 88.01 | 88.16 | 87.91 | 88.01 | 25300.0 |
| 2003-02-07 11:00:00 | TLT | ETF | 87.97 | 88.05 | 87.94 | 87.99 | 126500.0 |
| 2003-02-07 12:00:00 | TLT | ETF | 88.07 | 88.07 | 88.0 | 88.0 | 31800.0 |
> showing 50 of 382 rows — these rows as CSV