PREVIEW / etf_1hour / 2003-02-06
file: by_date/etf_1hour/2003/2003-02-06.parquet size: 15 KB rows: 370
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-06 08:00:00 | SPY | ETF | 84.74 | 84.74 | 84.18 | 84.28 | 53200.0 |
| 2003-02-06 09:00:00 | SPY | ETF | 84.28 | 84.89 | 83.72 | 83.87 | 8576400.0 |
| 2003-02-06 10:00:00 | SPY | ETF | 83.86 | 84.33 | 83.65 | 84.1 | 9305800.0 |
| 2003-02-06 11:00:00 | SPY | ETF | 84.12 | 84.75 | 83.84 | 84.56 | 8021600.0 |
| 2003-02-06 12:00:00 | SPY | ETF | 84.52 | 84.61 | 84.15 | 84.28 | 5484800.0 |
| 2003-02-06 13:00:00 | SPY | ETF | 84.27 | 84.59 | 84.08 | 84.29 | 3089800.0 |
| 2003-02-06 14:00:00 | SPY | ETF | 84.29 | 84.66 | 84.19 | 84.43 | 3136300.0 |
| 2003-02-06 15:00:00 | SPY | ETF | 84.4 | 84.45 | 83.66 | 84.2 | 10819200.0 |
| 2003-02-06 16:00:00 | SPY | ETF | 84.19 | 84.54 | 84.0 | 84.37 | 1106600.0 |
| 2003-02-06 17:00:00 | SPY | ETF | 84.41 | 84.51 | 84.4 | 84.51 | 21500.0 |
| 2003-02-06 18:00:00 | SPY | ETF | 84.55 | 84.73 | 84.5 | 84.65 | 8500.0 |
| 2003-02-06 19:00:00 | SPY | ETF | 84.65 | 84.66 | 84.52 | 84.62 | 4600.0 |
| 2003-02-06 08:00:00 | QQQ | ETF | 24.05 | 24.08 | 23.89 | 23.95 | 138300.0 |
| 2003-02-06 09:00:00 | QQQ | ETF | 23.94 | 24.3 | 23.86 | 23.95 | 28931800.0 |
| 2003-02-06 10:00:00 | QQQ | ETF | 23.96 | 24.24 | 23.88 | 24.17 | 18913600.0 |
| 2003-02-06 11:00:00 | QQQ | ETF | 24.15 | 24.35 | 24.05 | 24.3 | 13143700.0 |
| 2003-02-06 12:00:00 | QQQ | ETF | 24.3 | 24.33 | 24.1 | 24.17 | 4484000.0 |
| 2003-02-06 13:00:00 | QQQ | ETF | 24.16 | 24.29 | 24.11 | 24.17 | 2717700.0 |
| 2003-02-06 14:00:00 | QQQ | ETF | 24.19 | 24.33 | 24.16 | 24.27 | 5052200.0 |
| 2003-02-06 15:00:00 | QQQ | ETF | 24.23 | 24.25 | 23.86 | 24.15 | 14958700.0 |
| 2003-02-06 16:00:00 | QQQ | ETF | 24.14 | 24.3 | 24.14 | 24.18 | 5061800.0 |
| 2003-02-06 17:00:00 | QQQ | ETF | 24.17 | 24.19 | 24.1 | 24.15 | 477600.0 |
| 2003-02-06 18:00:00 | QQQ | ETF | 24.16 | 24.26 | 24.15 | 24.25 | 32100.0 |
| 2003-02-06 19:00:00 | QQQ | ETF | 24.26 | 24.26 | 24.15 | 24.21 | 5400.0 |
| 2003-02-06 08:00:00 | IWM | ETF | 36.515 | 36.515 | 36.515 | 36.515 | 1000.0 |
| 2003-02-06 09:00:00 | IWM | ETF | 36.415 | 36.61 | 36.27 | 36.285 | 287200.0 |
| 2003-02-06 10:00:00 | IWM | ETF | 36.295 | 36.42 | 36.21 | 36.355 | 765600.0 |
| 2003-02-06 11:00:00 | IWM | ETF | 36.34 | 36.505 | 36.265 | 36.45 | 689200.0 |
| 2003-02-06 12:00:00 | IWM | ETF | 36.46 | 36.475 | 36.355 | 36.395 | 110000.0 |
| 2003-02-06 13:00:00 | IWM | ETF | 36.465 | 36.495 | 36.395 | 36.435 | 1449600.0 |
| 2003-02-06 14:00:00 | IWM | ETF | 36.45 | 36.5 | 36.225 | 36.375 | 275600.0 |
| 2003-02-06 15:00:00 | IWM | ETF | 36.295 | 36.36 | 36.135 | 36.275 | 634400.0 |
| 2003-02-06 16:00:00 | IWM | ETF | 36.32 | 36.38 | 36.315 | 36.325 | 52400.0 |
| 2003-02-06 17:00:00 | IWM | ETF | 36.35 | 36.35 | 36.35 | 36.35 | 1000.0 |
| 2003-02-06 08:00:00 | DIA | ETF | 80.0 | 80.06 | 79.59 | 79.63 | 34300.0 |
| 2003-02-06 09:00:00 | DIA | ETF | 79.72 | 80.15 | 79.15 | 79.33 | 1383900.0 |
| 2003-02-06 10:00:00 | DIA | ETF | 79.3 | 79.7 | 79.01 | 79.51 | 1585100.0 |
| 2003-02-06 11:00:00 | DIA | ETF | 79.51 | 80.08 | 79.28 | 79.95 | 1480700.0 |
| 2003-02-06 12:00:00 | DIA | ETF | 79.92 | 79.95 | 79.52 | 79.61 | 535300.0 |
| 2003-02-06 13:00:00 | DIA | ETF | 79.59 | 79.9 | 79.39 | 79.54 | 730000.0 |
| 2003-02-06 14:00:00 | DIA | ETF | 79.58 | 79.9 | 79.47 | 79.66 | 680300.0 |
| 2003-02-06 15:00:00 | DIA | ETF | 79.63 | 79.7 | 79.0 | 79.47 | 1617500.0 |
| 2003-02-06 16:00:00 | DIA | ETF | 79.5 | 79.79 | 79.33 | 79.62 | 152900.0 |
| 2003-02-06 17:00:00 | DIA | ETF | 79.6 | 79.76 | 79.6 | 79.71 | 6500.0 |
| 2003-02-06 18:00:00 | DIA | ETF | 79.77 | 79.88 | 79.75 | 79.88 | 2300.0 |
| 2003-02-06 19:00:00 | DIA | ETF | 79.88 | 79.88 | 79.77 | 79.84 | 1000.0 |
| 2003-02-06 09:00:00 | TLT | ETF | 87.84 | 88.02 | 87.79 | 88.02 | 4400.0 |
| 2003-02-06 10:00:00 | TLT | ETF | 87.97 | 88.05 | 87.85 | 87.85 | 11100.0 |
| 2003-02-06 11:00:00 | TLT | ETF | 88.0 | 88.0 | 87.84 | 87.87 | 2700.0 |
| 2003-02-06 12:00:00 | TLT | ETF | 87.87 | 88.02 | 87.87 | 88.02 | 5600.0 |
> showing 50 of 370 rows — these rows as CSV