PREVIEW / etf_1hour / 2003-02-18
file: by_date/etf_1hour/2003/2003-02-18.parquet size: 16 KB rows: 396
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-18 08:00:00 | SPY | ETF | 84.5 | 84.64 | 84.2 | 84.62 | 46500.0 |
| 2003-02-18 09:00:00 | SPY | ETF | 84.62 | 85.19 | 84.49 | 85.03 | 7170400.0 |
| 2003-02-18 10:00:00 | SPY | ETF | 85.07 | 85.56 | 85.06 | 85.45 | 6686100.0 |
| 2003-02-18 11:00:00 | SPY | ETF | 85.47 | 85.57 | 85.22 | 85.35 | 3587600.0 |
| 2003-02-18 12:00:00 | SPY | ETF | 85.36 | 85.66 | 85.3 | 85.61 | 2214800.0 |
| 2003-02-18 13:00:00 | SPY | ETF | 85.61 | 85.75 | 85.32 | 85.52 | 2505900.0 |
| 2003-02-18 14:00:00 | SPY | ETF | 85.53 | 85.69 | 85.29 | 85.38 | 3726600.0 |
| 2003-02-18 15:00:00 | SPY | ETF | 85.39 | 85.54 | 84.99 | 85.5 | 6890600.0 |
| 2003-02-18 16:00:00 | SPY | ETF | 85.55 | 85.8 | 85.14 | 85.6 | 3025900.0 |
| 2003-02-18 17:00:00 | SPY | ETF | 85.6 | 85.65 | 85.54 | 85.59 | 27800.0 |
| 2003-02-18 18:00:00 | SPY | ETF | 85.62 | 85.65 | 85.54 | 85.65 | 15400.0 |
| 2003-02-18 19:00:00 | SPY | ETF | 85.56 | 85.63 | 85.54 | 85.58 | 8700.0 |
| 2003-02-18 08:00:00 | QQQ | ETF | 24.6 | 24.76 | 24.57 | 24.73 | 151600.0 |
| 2003-02-18 09:00:00 | QQQ | ETF | 24.71 | 25.01 | 24.68 | 24.91 | 14781100.0 |
| 2003-02-18 10:00:00 | QQQ | ETF | 24.93 | 25.1 | 24.84 | 25.04 | 15421500.0 |
| 2003-02-18 11:00:00 | QQQ | ETF | 25.04 | 25.1 | 24.9 | 24.99 | 5992000.0 |
| 2003-02-18 12:00:00 | QQQ | ETF | 24.99 | 25.1 | 24.94 | 25.1 | 4041500.0 |
| 2003-02-18 13:00:00 | QQQ | ETF | 25.1 | 25.16 | 25.01 | 25.08 | 7306900.0 |
| 2003-02-18 14:00:00 | QQQ | ETF | 25.08 | 25.23 | 25.06 | 25.11 | 6397400.0 |
| 2003-02-18 15:00:00 | QQQ | ETF | 25.11 | 25.22 | 24.93 | 25.2 | 10928700.0 |
| 2003-02-18 16:00:00 | QQQ | ETF | 25.21 | 25.34 | 25.17 | 25.31 | 3369000.0 |
| 2003-02-18 17:00:00 | QQQ | ETF | 25.31 | 25.35 | 25.28 | 25.29 | 91500.0 |
| 2003-02-18 18:00:00 | QQQ | ETF | 25.3 | 25.33 | 25.28 | 25.28 | 33200.0 |
| 2003-02-18 19:00:00 | QQQ | ETF | 25.29 | 25.32 | 25.28 | 25.3 | 12500.0 |
| 2003-02-18 09:00:00 | IWM | ETF | 35.925 | 36.07 | 35.925 | 36.015 | 292600.0 |
| 2003-02-18 10:00:00 | IWM | ETF | 36.025 | 36.16 | 35.95 | 36.125 | 347400.0 |
| 2003-02-18 11:00:00 | IWM | ETF | 36.125 | 36.18 | 36.095 | 36.135 | 177200.0 |
| 2003-02-18 12:00:00 | IWM | ETF | 36.175 | 36.25 | 36.145 | 36.23 | 274200.0 |
| 2003-02-18 13:00:00 | IWM | ETF | 36.245 | 36.28 | 36.155 | 36.2 | 248600.0 |
| 2003-02-18 14:00:00 | IWM | ETF | 36.16 | 36.27 | 36.16 | 36.185 | 119000.0 |
| 2003-02-18 15:00:00 | IWM | ETF | 36.18 | 36.35 | 36.055 | 36.35 | 246200.0 |
| 2003-02-18 16:00:00 | IWM | ETF | 36.295 | 36.4 | 36.275 | 36.285 | 26800.0 |
| 2003-02-18 08:00:00 | DIA | ETF | 80.0 | 80.0 | 79.6 | 79.96 | 6200.0 |
| 2003-02-18 09:00:00 | DIA | ETF | 80.0 | 80.65 | 79.85 | 80.47 | 1834800.0 |
| 2003-02-18 10:00:00 | DIA | ETF | 80.55 | 81.03 | 80.47 | 80.9 | 1414600.0 |
| 2003-02-18 11:00:00 | DIA | ETF | 80.91 | 81.0 | 80.61 | 80.7 | 467800.0 |
| 2003-02-18 12:00:00 | DIA | ETF | 80.71 | 80.99 | 80.61 | 80.99 | 404700.0 |
| 2003-02-18 13:00:00 | DIA | ETF | 80.94 | 81.02 | 80.66 | 80.8 | 509800.0 |
| 2003-02-18 14:00:00 | DIA | ETF | 80.8 | 81.0 | 80.58 | 80.7 | 1234800.0 |
| 2003-02-18 15:00:00 | DIA | ETF | 80.65 | 80.72 | 80.23 | 80.71 | 1435500.0 |
| 2003-02-18 16:00:00 | DIA | ETF | 80.7 | 80.87 | 80.6 | 80.85 | 148300.0 |
| 2003-02-18 17:00:00 | DIA | ETF | 80.82 | 80.87 | 80.76 | 80.76 | 1800.0 |
| 2003-02-18 18:00:00 | DIA | ETF | 80.82 | 80.82 | 80.76 | 80.77 | 2000.0 |
| 2003-02-18 19:00:00 | DIA | ETF | 80.8 | 80.8 | 80.8 | 80.8 | 100.0 |
| 2003-02-18 09:00:00 | TLT | ETF | 87.56 | 87.56 | 87.34 | 87.41 | 41500.0 |
| 2003-02-18 10:00:00 | TLT | ETF | 87.38 | 87.51 | 87.36 | 87.44 | 15800.0 |
| 2003-02-18 11:00:00 | TLT | ETF | 87.57 | 87.59 | 87.5 | 87.5 | 88200.0 |
| 2003-02-18 12:00:00 | TLT | ETF | 87.55 | 87.6 | 87.45 | 87.6 | 17500.0 |
| 2003-02-18 13:00:00 | TLT | ETF | 87.6 | 87.7 | 87.58 | 87.7 | 40800.0 |
| 2003-02-18 14:00:00 | TLT | ETF | 87.75 | 87.85 | 87.75 | 87.85 | 3700.0 |
> showing 50 of 396 rows — these rows as CSV