PREVIEW / etf_1hour / 2003-02-04
file: by_date/etf_1hour/2003/2003-02-04.parquet size: 16 KB rows: 374
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-04 08:00:00 | SPY | ETF | 85.67 | 85.7 | 85.52 | 85.62 | 15400.0 |
| 2003-02-04 09:00:00 | SPY | ETF | 85.6 | 85.6 | 84.68 | 84.93 | 6855200.0 |
| 2003-02-04 10:00:00 | SPY | ETF | 84.92 | 85.1 | 84.47 | 84.68 | 6306700.0 |
| 2003-02-04 11:00:00 | SPY | ETF | 84.68 | 84.77 | 84.3 | 84.61 | 4822400.0 |
| 2003-02-04 12:00:00 | SPY | ETF | 84.61 | 84.86 | 84.48 | 84.65 | 3188300.0 |
| 2003-02-04 13:00:00 | SPY | ETF | 84.66 | 85.22 | 84.6 | 85.04 | 4126800.0 |
| 2003-02-04 14:00:00 | SPY | ETF | 85.0 | 85.19 | 84.66 | 84.75 | 4296600.0 |
| 2003-02-04 15:00:00 | SPY | ETF | 84.71 | 85.23 | 84.59 | 85.14 | 7898900.0 |
| 2003-02-04 16:00:00 | SPY | ETF | 85.11 | 86.84 | 85.1 | 85.25 | 2416100.0 |
| 2003-02-04 17:00:00 | SPY | ETF | 85.27 | 85.99 | 85.14 | 85.33 | 495900.0 |
| 2003-02-04 18:00:00 | SPY | ETF | 85.33 | 85.4 | 85.24 | 85.25 | 12200.0 |
| 2003-02-04 19:00:00 | SPY | ETF | 85.25 | 85.35 | 85.25 | 85.35 | 3700.0 |
| 2003-02-04 08:00:00 | QQQ | ETF | 24.25 | 24.27 | 24.16 | 24.18 | 42300.0 |
| 2003-02-04 09:00:00 | QQQ | ETF | 24.2 | 24.22 | 24.06 | 24.19 | 11260100.0 |
| 2003-02-04 10:00:00 | QQQ | ETF | 24.18 | 24.29 | 24.03 | 24.05 | 11395500.0 |
| 2003-02-04 11:00:00 | QQQ | ETF | 24.05 | 24.06 | 23.82 | 23.94 | 8991500.0 |
| 2003-02-04 12:00:00 | QQQ | ETF | 23.94 | 24.04 | 23.9 | 23.97 | 5691700.0 |
| 2003-02-04 13:00:00 | QQQ | ETF | 24.0 | 24.18 | 23.95 | 24.09 | 4392400.0 |
| 2003-02-04 14:00:00 | QQQ | ETF | 24.09 | 24.18 | 23.95 | 23.98 | 7919000.0 |
| 2003-02-04 15:00:00 | QQQ | ETF | 23.98 | 24.15 | 23.91 | 24.14 | 6377300.0 |
| 2003-02-04 16:00:00 | QQQ | ETF | 24.17 | 24.3 | 24.0 | 24.07 | 5005500.0 |
| 2003-02-04 17:00:00 | QQQ | ETF | 24.06 | 24.27 | 23.94 | 24.2 | 4650500.0 |
| 2003-02-04 18:00:00 | QQQ | ETF | 24.2 | 24.24 | 24.08 | 24.1 | 114900.0 |
| 2003-02-04 19:00:00 | QQQ | ETF | 24.13 | 24.21 | 24.08 | 24.21 | 79300.0 |
| 2003-02-04 09:00:00 | IWM | ETF | 36.67 | 36.67 | 36.45 | 36.47 | 1273600.0 |
| 2003-02-04 10:00:00 | IWM | ETF | 36.47 | 36.575 | 36.38 | 36.395 | 804400.0 |
| 2003-02-04 11:00:00 | IWM | ETF | 36.38 | 36.415 | 36.225 | 36.415 | 590600.0 |
| 2003-02-04 12:00:00 | IWM | ETF | 36.375 | 36.51 | 36.375 | 36.45 | 127800.0 |
| 2003-02-04 13:00:00 | IWM | ETF | 36.45 | 36.63 | 36.45 | 36.6 | 391200.0 |
| 2003-02-04 14:00:00 | IWM | ETF | 36.555 | 36.74 | 36.545 | 36.57 | 540400.0 |
| 2003-02-04 15:00:00 | IWM | ETF | 36.55 | 36.665 | 36.5 | 36.64 | 368200.0 |
| 2003-02-04 16:00:00 | IWM | ETF | 36.65 | 37.05 | 36.635 | 36.665 | 18800.0 |
| 2003-02-04 17:00:00 | IWM | ETF | 36.615 | 36.715 | 36.61 | 36.715 | 198800.0 |
| 2003-02-04 08:00:00 | DIA | ETF | 80.64 | 80.8 | 80.55 | 80.6 | 22900.0 |
| 2003-02-04 09:00:00 | DIA | ETF | 80.6 | 80.6 | 79.85 | 80.01 | 1195500.0 |
| 2003-02-04 10:00:00 | DIA | ETF | 80.1 | 80.16 | 79.62 | 79.76 | 1047400.0 |
| 2003-02-04 11:00:00 | DIA | ETF | 79.75 | 79.85 | 79.4 | 79.77 | 811400.0 |
| 2003-02-04 12:00:00 | DIA | ETF | 79.77 | 79.94 | 79.65 | 79.8 | 448800.0 |
| 2003-02-04 13:00:00 | DIA | ETF | 79.77 | 80.25 | 79.72 | 80.08 | 681800.0 |
| 2003-02-04 14:00:00 | DIA | ETF | 80.1 | 80.3 | 79.9 | 79.93 | 990800.0 |
| 2003-02-04 15:00:00 | DIA | ETF | 80.0 | 80.35 | 79.81 | 80.3 | 939700.0 |
| 2003-02-04 16:00:00 | DIA | ETF | 80.3 | 80.75 | 80.21 | 80.45 | 169700.0 |
| 2003-02-04 17:00:00 | DIA | ETF | 80.46 | 80.47 | 80.41 | 80.46 | 5500.0 |
| 2003-02-04 18:00:00 | DIA | ETF | 80.41 | 80.41 | 80.41 | 80.41 | 100.0 |
| 2003-02-04 19:00:00 | DIA | ETF | 80.35 | 80.35 | 80.35 | 80.35 | 400.0 |
| 2003-02-04 09:00:00 | TLT | ETF | 88.37 | 88.4 | 88.16 | 88.3 | 13400.0 |
| 2003-02-04 10:00:00 | TLT | ETF | 88.33 | 88.33 | 88.21 | 88.29 | 2000.0 |
| 2003-02-04 11:00:00 | TLT | ETF | 88.32 | 88.34 | 88.24 | 88.26 | 3700.0 |
| 2003-02-04 12:00:00 | TLT | ETF | 88.25 | 88.25 | 88.13 | 88.13 | 1700.0 |
| 2003-02-04 13:00:00 | TLT | ETF | 88.21 | 88.21 | 88.11 | 88.11 | 2400.0 |
> showing 50 of 374 rows — these rows as CSV