PREVIEW / etf_1hour / 2002-12-27
file: by_date/etf_1hour/2002/2002-12-27.parquet size: 16 KB rows: 378
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-27 08:00:00 | SPY | ETF | 89.07 | 89.16 | 89.05 | 89.1 | 35700.0 |
| 2002-12-27 09:00:00 | SPY | ETF | 89.09 | 89.29 | 88.83 | 88.93 | 2424700.0 |
| 2002-12-27 10:00:00 | SPY | ETF | 88.87 | 89.19 | 88.39 | 88.46 | 3666400.0 |
| 2002-12-27 11:00:00 | SPY | ETF | 88.45 | 88.58 | 88.22 | 88.35 | 2167400.0 |
| 2002-12-27 12:00:00 | SPY | ETF | 88.35 | 88.39 | 88.06 | 88.37 | 1471700.0 |
| 2002-12-27 13:00:00 | SPY | ETF | 88.33 | 88.33 | 87.9 | 87.96 | 2293000.0 |
| 2002-12-27 14:00:00 | SPY | ETF | 87.96 | 87.99 | 87.53 | 87.65 | 2616700.0 |
| 2002-12-27 15:00:00 | SPY | ETF | 87.63 | 88.02 | 87.52 | 87.68 | 4015600.0 |
| 2002-12-27 16:00:00 | SPY | ETF | 87.7 | 87.71 | 87.26 | 87.37 | 1295100.0 |
| 2002-12-27 17:00:00 | SPY | ETF | 87.36 | 87.42 | 87.35 | 87.42 | 5400.0 |
| 2002-12-27 18:00:00 | SPY | ETF | 87.47 | 87.49 | 87.41 | 87.41 | 5000.0 |
| 2002-12-27 08:00:00 | QQQ | ETF | 25.24 | 25.27 | 25.2 | 25.2 | 13000.0 |
| 2002-12-27 09:00:00 | QQQ | ETF | 25.19 | 25.3 | 25.12 | 25.21 | 3475200.0 |
| 2002-12-27 10:00:00 | QQQ | ETF | 25.21 | 25.33 | 25.06 | 25.08 | 6058000.0 |
| 2002-12-27 11:00:00 | QQQ | ETF | 25.06 | 25.11 | 24.97 | 25.05 | 5344400.0 |
| 2002-12-27 12:00:00 | QQQ | ETF | 25.03 | 25.1 | 24.97 | 25.05 | 2888800.0 |
| 2002-12-27 13:00:00 | QQQ | ETF | 25.06 | 25.08 | 24.87 | 24.9 | 4531000.0 |
| 2002-12-27 14:00:00 | QQQ | ETF | 24.9 | 24.92 | 24.77 | 24.82 | 5884500.0 |
| 2002-12-27 15:00:00 | QQQ | ETF | 24.81 | 24.89 | 24.75 | 24.82 | 7410800.0 |
| 2002-12-27 16:00:00 | QQQ | ETF | 24.82 | 24.83 | 24.75 | 24.8 | 2563000.0 |
| 2002-12-27 17:00:00 | QQQ | ETF | 24.8 | 24.82 | 24.79 | 24.79 | 47300.0 |
| 2002-12-27 18:00:00 | QQQ | ETF | 24.8 | 24.82 | 24.77 | 24.8 | 32200.0 |
| 2002-12-27 19:00:00 | QQQ | ETF | 24.83 | 24.83 | 24.82 | 24.83 | 8000.0 |
| 2002-12-27 09:00:00 | IWM | ETF | 38.625 | 38.625 | 38.48 | 38.51 | 194600.0 |
| 2002-12-27 10:00:00 | IWM | ETF | 38.55 | 38.615 | 38.335 | 38.41 | 362400.0 |
| 2002-12-27 11:00:00 | IWM | ETF | 38.355 | 38.4 | 38.305 | 38.305 | 160800.0 |
| 2002-12-27 12:00:00 | IWM | ETF | 38.325 | 38.41 | 38.28 | 38.365 | 358000.0 |
| 2002-12-27 13:00:00 | IWM | ETF | 38.325 | 38.35 | 38.17 | 38.17 | 360400.0 |
| 2002-12-27 14:00:00 | IWM | ETF | 38.185 | 38.245 | 38.14 | 38.185 | 175000.0 |
| 2002-12-27 15:00:00 | IWM | ETF | 38.195 | 38.3 | 38.145 | 38.195 | 367400.0 |
| 2002-12-27 16:00:00 | IWM | ETF | 38.145 | 38.145 | 38.07 | 38.07 | 22600.0 |
| 2002-12-27 08:00:00 | DIA | ETF | 84.28 | 84.28 | 84.22 | 84.22 | 1000.0 |
| 2002-12-27 09:00:00 | DIA | ETF | 84.22 | 84.6 | 84.1 | 84.32 | 498500.0 |
| 2002-12-27 10:00:00 | DIA | ETF | 84.25 | 84.59 | 83.81 | 83.91 | 1059200.0 |
| 2002-12-27 11:00:00 | DIA | ETF | 83.92 | 84.02 | 83.66 | 83.77 | 604100.0 |
| 2002-12-27 12:00:00 | DIA | ETF | 83.8 | 83.83 | 83.53 | 83.78 | 505500.0 |
| 2002-12-27 13:00:00 | DIA | ETF | 83.78 | 83.78 | 83.32 | 83.36 | 582600.0 |
| 2002-12-27 14:00:00 | DIA | ETF | 83.38 | 83.38 | 82.92 | 83.09 | 927700.0 |
| 2002-12-27 15:00:00 | DIA | ETF | 83.07 | 83.49 | 82.92 | 83.1 | 951100.0 |
| 2002-12-27 16:00:00 | DIA | ETF | 83.12 | 83.12 | 82.95 | 83.12 | 205000.0 |
| 2002-12-27 17:00:00 | DIA | ETF | 82.95 | 83.05 | 82.9 | 83.05 | 1000.0 |
| 2002-12-27 18:00:00 | DIA | ETF | 83.02 | 83.02 | 83.02 | 83.02 | 200.0 |
| 2002-12-27 19:00:00 | DIA | ETF | 83.0 | 83.0 | 83.0 | 83.0 | 100.0 |
| 2002-12-27 09:00:00 | TLT | ETF | 88.55 | 88.55 | 88.34 | 88.34 | 9200.0 |
| 2002-12-27 10:00:00 | TLT | ETF | 88.38 | 88.39 | 88.36 | 88.36 | 5000.0 |
| 2002-12-27 11:00:00 | TLT | ETF | 88.3 | 88.35 | 88.28 | 88.35 | 25000.0 |
| 2002-12-27 12:00:00 | TLT | ETF | 88.36 | 88.39 | 88.32 | 88.32 | 1700.0 |
| 2002-12-27 13:00:00 | TLT | ETF | 88.39 | 88.43 | 88.39 | 88.43 | 4500.0 |
| 2002-12-27 14:00:00 | TLT | ETF | 88.5 | 88.85 | 88.5 | 88.85 | 39400.0 |
| 2002-12-27 15:00:00 | TLT | ETF | 88.92 | 88.95 | 88.82 | 88.83 | 40600.0 |
> showing 50 of 378 rows — these rows as CSV