PREVIEW / etf_1hour / 2002-12-12
file: by_date/etf_1hour/2002/2002-12-12.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-12 08:00:00 | SPY | ETF | 90.39 | 91.17 | 90.35 | 91.15 | 170000.0 |
| 2002-12-12 09:00:00 | SPY | ETF | 91.15 | 91.4 | 90.52 | 90.65 | 4836000.0 |
| 2002-12-12 10:00:00 | SPY | ETF | 90.65 | 91.49 | 90.56 | 91.3 | 5992200.0 |
| 2002-12-12 11:00:00 | SPY | ETF | 91.25 | 91.33 | 90.35 | 90.37 | 3831900.0 |
| 2002-12-12 12:00:00 | SPY | ETF | 90.39 | 90.65 | 90.2 | 90.58 | 4665800.0 |
| 2002-12-12 13:00:00 | SPY | ETF | 90.6 | 90.91 | 90.43 | 90.45 | 1877600.0 |
| 2002-12-12 14:00:00 | SPY | ETF | 90.45 | 90.89 | 90.4 | 90.85 | 2534800.0 |
| 2002-12-12 15:00:00 | SPY | ETF | 90.84 | 91.0 | 90.59 | 90.73 | 5979600.0 |
| 2002-12-12 16:00:00 | SPY | ETF | 90.72 | 90.89 | 90.6 | 90.65 | 1897700.0 |
| 2002-12-12 17:00:00 | SPY | ETF | 90.68 | 90.76 | 90.65 | 90.75 | 208500.0 |
| 2002-12-12 18:00:00 | SPY | ETF | 90.81 | 90.83 | 90.65 | 90.83 | 5500.0 |
| 2002-12-12 19:00:00 | SPY | ETF | 90.83 | 90.85 | 90.83 | 90.85 | 1300.0 |
| 2002-12-12 08:00:00 | QQQ | ETF | 25.51 | 26.1 | 25.51 | 26.09 | 195600.0 |
| 2002-12-12 09:00:00 | QQQ | ETF | 26.1 | 26.16 | 25.86 | 25.91 | 9602500.0 |
| 2002-12-12 10:00:00 | QQQ | ETF | 25.92 | 26.17 | 25.79 | 26.05 | 10268300.0 |
| 2002-12-12 11:00:00 | QQQ | ETF | 26.05 | 26.09 | 25.68 | 25.71 | 7647300.0 |
| 2002-12-12 12:00:00 | QQQ | ETF | 25.7 | 25.79 | 25.56 | 25.7 | 6907700.0 |
| 2002-12-12 13:00:00 | QQQ | ETF | 25.7 | 25.84 | 25.64 | 25.7 | 3557700.0 |
| 2002-12-12 14:00:00 | QQQ | ETF | 25.67 | 25.85 | 25.64 | 25.8 | 5873100.0 |
| 2002-12-12 15:00:00 | QQQ | ETF | 25.82 | 25.88 | 25.73 | 25.83 | 6397300.0 |
| 2002-12-12 16:00:00 | QQQ | ETF | 25.81 | 25.92 | 25.76 | 25.85 | 2503100.0 |
| 2002-12-12 17:00:00 | QQQ | ETF | 25.85 | 25.86 | 25.82 | 25.85 | 287500.0 |
| 2002-12-12 18:00:00 | QQQ | ETF | 25.84 | 25.88 | 25.84 | 25.87 | 33600.0 |
| 2002-12-12 19:00:00 | QQQ | ETF | 25.83 | 25.87 | 25.81 | 25.87 | 8100.0 |
| 2002-12-12 09:00:00 | IWM | ETF | 39.52 | 39.575 | 39.33 | 39.365 | 464800.0 |
| 2002-12-12 10:00:00 | IWM | ETF | 39.405 | 39.64 | 39.34 | 39.575 | 191000.0 |
| 2002-12-12 11:00:00 | IWM | ETF | 39.55 | 39.59 | 39.385 | 39.385 | 195000.0 |
| 2002-12-12 12:00:00 | IWM | ETF | 39.4 | 39.45 | 39.24 | 39.28 | 214000.0 |
| 2002-12-12 13:00:00 | IWM | ETF | 39.26 | 39.42 | 39.26 | 39.375 | 121600.0 |
| 2002-12-12 14:00:00 | IWM | ETF | 39.355 | 39.625 | 39.325 | 39.61 | 290800.0 |
| 2002-12-12 15:00:00 | IWM | ETF | 39.64 | 39.68 | 39.475 | 39.525 | 326400.0 |
| 2002-12-12 16:00:00 | IWM | ETF | 39.54 | 39.54 | 39.43 | 39.455 | 6600.0 |
| 2002-12-12 08:00:00 | DIA | ETF | 85.51 | 86.29 | 85.51 | 86.29 | 9200.0 |
| 2002-12-12 09:00:00 | DIA | ETF | 86.25 | 86.4 | 85.5 | 85.6 | 653300.0 |
| 2002-12-12 10:00:00 | DIA | ETF | 85.6 | 86.4 | 85.47 | 86.25 | 1198600.0 |
| 2002-12-12 11:00:00 | DIA | ETF | 86.25 | 86.3 | 85.47 | 85.47 | 548000.0 |
| 2002-12-12 12:00:00 | DIA | ETF | 85.5 | 85.7 | 85.36 | 85.63 | 796500.0 |
| 2002-12-12 13:00:00 | DIA | ETF | 85.63 | 85.88 | 85.46 | 85.47 | 425400.0 |
| 2002-12-12 14:00:00 | DIA | ETF | 85.45 | 85.79 | 85.42 | 85.78 | 427300.0 |
| 2002-12-12 15:00:00 | DIA | ETF | 85.76 | 85.93 | 85.52 | 85.59 | 669100.0 |
| 2002-12-12 16:00:00 | DIA | ETF | 85.63 | 85.75 | 85.55 | 85.62 | 174300.0 |
| 2002-12-12 17:00:00 | DIA | ETF | 85.64 | 85.65 | 85.63 | 85.65 | 1300.0 |
| 2002-12-12 18:00:00 | DIA | ETF | 85.75 | 85.75 | 85.75 | 85.75 | 100.0 |
| 2002-12-12 09:00:00 | TLT | ETF | 87.06 | 87.38 | 87.06 | 87.38 | 17500.0 |
| 2002-12-12 10:00:00 | TLT | ETF | 87.27 | 87.39 | 87.2 | 87.25 | 30100.0 |
| 2002-12-12 11:00:00 | TLT | ETF | 87.26 | 87.35 | 87.26 | 87.35 | 8300.0 |
| 2002-12-12 12:00:00 | TLT | ETF | 87.37 | 87.45 | 87.33 | 87.45 | 8500.0 |
| 2002-12-12 13:00:00 | TLT | ETF | 87.47 | 87.6 | 87.47 | 87.6 | 3800.0 |
| 2002-12-12 14:00:00 | TLT | ETF | 87.6 | 87.6 | 87.51 | 87.51 | 51900.0 |
| 2002-12-12 15:00:00 | TLT | ETF | 87.47 | 87.48 | 87.38 | 87.4 | 13100.0 |
> showing 50 of 367 rows — these rows as CSV