PREVIEW / etf_1hour / 2002-12-11
file: by_date/etf_1hour/2002/2002-12-11.parquet size: 16 KB rows: 367
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 |
|---|---|---|---|---|---|---|---|
| 2002-12-11 08:00:00 | SPY | ETF | 90.52 | 90.7 | 90.52 | 90.6 | 10400.0 |
| 2002-12-11 09:00:00 | SPY | ETF | 90.6 | 90.62 | 90.16 | 90.38 | 3476000.0 |
| 2002-12-11 10:00:00 | SPY | ETF | 90.37 | 91.23 | 90.2 | 91.0 | 7332500.0 |
| 2002-12-11 11:00:00 | SPY | ETF | 91.0 | 91.62 | 90.92 | 91.39 | 4909100.0 |
| 2002-12-11 12:00:00 | SPY | ETF | 91.38 | 91.49 | 91.22 | 91.26 | 2290600.0 |
| 2002-12-11 13:00:00 | SPY | ETF | 91.25 | 91.28 | 90.93 | 91.22 | 3296800.0 |
| 2002-12-11 14:00:00 | SPY | ETF | 91.22 | 91.25 | 90.64 | 90.91 | 3727800.0 |
| 2002-12-11 15:00:00 | SPY | ETF | 90.91 | 91.45 | 90.79 | 91.06 | 7802300.0 |
| 2002-12-11 16:00:00 | SPY | ETF | 91.02 | 91.16 | 90.76 | 90.9 | 1719900.0 |
| 2002-12-11 17:00:00 | SPY | ETF | 90.95 | 91.06 | 90.91 | 90.95 | 32300.0 |
| 2002-12-11 18:00:00 | SPY | ETF | 90.97 | 91.0 | 90.91 | 91.0 | 2100.0 |
| 2002-12-11 19:00:00 | SPY | ETF | 91.01 | 91.01 | 90.93 | 90.97 | 1800.0 |
| 2002-12-11 08:00:00 | QQQ | ETF | 25.63 | 25.66 | 25.54 | 25.54 | 29300.0 |
| 2002-12-11 09:00:00 | QQQ | ETF | 25.51 | 25.6 | 25.32 | 25.49 | 10034000.0 |
| 2002-12-11 10:00:00 | QQQ | ETF | 25.49 | 25.95 | 25.38 | 25.76 | 11314900.0 |
| 2002-12-11 11:00:00 | QQQ | ETF | 25.77 | 26.07 | 25.7 | 25.91 | 9647200.0 |
| 2002-12-11 12:00:00 | QQQ | ETF | 25.91 | 26.0 | 25.8 | 25.87 | 5732600.0 |
| 2002-12-11 13:00:00 | QQQ | ETF | 25.87 | 25.97 | 25.73 | 25.91 | 3857800.0 |
| 2002-12-11 14:00:00 | QQQ | ETF | 25.92 | 25.96 | 25.55 | 25.69 | 8630400.0 |
| 2002-12-11 15:00:00 | QQQ | ETF | 25.7 | 25.88 | 25.6 | 25.76 | 7939300.0 |
| 2002-12-11 16:00:00 | QQQ | ETF | 25.76 | 25.8 | 25.7 | 25.76 | 1586800.0 |
| 2002-12-11 17:00:00 | QQQ | ETF | 25.78 | 25.84 | 25.77 | 25.82 | 405500.0 |
| 2002-12-11 18:00:00 | QQQ | ETF | 25.82 | 25.82 | 25.8 | 25.8 | 29600.0 |
| 2002-12-11 19:00:00 | QQQ | ETF | 25.8 | 25.84 | 25.8 | 25.83 | 11900.0 |
| 2002-12-11 09:00:00 | IWM | ETF | 39.21 | 39.3 | 39.05 | 39.23 | 821600.0 |
| 2002-12-11 10:00:00 | IWM | ETF | 39.2 | 39.485 | 39.105 | 39.4 | 472400.0 |
| 2002-12-11 11:00:00 | IWM | ETF | 39.375 | 39.575 | 39.35 | 39.47 | 180400.0 |
| 2002-12-11 12:00:00 | IWM | ETF | 39.46 | 39.54 | 39.385 | 39.455 | 239400.0 |
| 2002-12-11 13:00:00 | IWM | ETF | 39.45 | 39.45 | 39.335 | 39.425 | 178200.0 |
| 2002-12-11 14:00:00 | IWM | ETF | 39.38 | 39.41 | 39.165 | 39.28 | 353200.0 |
| 2002-12-11 15:00:00 | IWM | ETF | 39.29 | 39.41 | 39.19 | 39.3 | 388600.0 |
| 2002-12-11 16:00:00 | IWM | ETF | 39.25 | 39.385 | 39.24 | 39.27 | 89400.0 |
| 2002-12-11 08:00:00 | DIA | ETF | 85.68 | 85.68 | 85.55 | 85.63 | 4800.0 |
| 2002-12-11 09:00:00 | DIA | ETF | 85.6 | 85.6 | 85.2 | 85.27 | 940000.0 |
| 2002-12-11 10:00:00 | DIA | ETF | 85.26 | 85.99 | 85.13 | 85.85 | 1041300.0 |
| 2002-12-11 11:00:00 | DIA | ETF | 85.81 | 86.48 | 85.7 | 86.25 | 758100.0 |
| 2002-12-11 12:00:00 | DIA | ETF | 86.22 | 86.36 | 86.1 | 86.16 | 314800.0 |
| 2002-12-11 13:00:00 | DIA | ETF | 86.16 | 86.17 | 85.82 | 86.11 | 526400.0 |
| 2002-12-11 14:00:00 | DIA | ETF | 86.12 | 86.15 | 85.7 | 85.93 | 624800.0 |
| 2002-12-11 15:00:00 | DIA | ETF | 85.99 | 86.5 | 85.8 | 86.16 | 1019000.0 |
| 2002-12-11 16:00:00 | DIA | ETF | 86.13 | 86.16 | 85.85 | 86.01 | 118600.0 |
| 2002-12-11 17:00:00 | DIA | ETF | 86.15 | 86.24 | 86.09 | 86.24 | 1800.0 |
| 2002-12-11 18:00:00 | DIA | ETF | 86.07 | 86.07 | 86.07 | 86.07 | 1000.0 |
| 2002-12-11 19:00:00 | DIA | ETF | 86.28 | 86.38 | 86.28 | 86.38 | 400.0 |
| 2002-12-11 09:00:00 | TLT | ETF | 87.15 | 87.26 | 87.15 | 87.15 | 19400.0 |
| 2002-12-11 10:00:00 | TLT | ETF | 87.12 | 87.12 | 86.96 | 87.05 | 15500.0 |
| 2002-12-11 11:00:00 | TLT | ETF | 87.1 | 87.15 | 87.1 | 87.12 | 27900.0 |
| 2002-12-11 12:00:00 | TLT | ETF | 87.15 | 87.24 | 87.15 | 87.24 | 1900.0 |
| 2002-12-11 13:00:00 | TLT | ETF | 87.31 | 87.55 | 87.31 | 87.5 | 24400.0 |
| 2002-12-11 14:00:00 | TLT | ETF | 87.5 | 87.65 | 87.5 | 87.6 | 25900.0 |
> showing 50 of 367 rows — these rows as CSV