PREVIEW / etf_1hour / 2002-12-04
file: by_date/etf_1hour/2002/2002-12-04.parquet size: 16 KB rows: 384
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-04 08:00:00 | SPY | ETF | 92.24 | 92.24 | 91.8 | 91.93 | 65000.0 |
| 2002-12-04 09:00:00 | SPY | ETF | 91.93 | 92.03 | 91.62 | 91.8 | 8287100.0 |
| 2002-12-04 10:00:00 | SPY | ETF | 91.78 | 92.48 | 91.43 | 92.13 | 10107000.0 |
| 2002-12-04 11:00:00 | SPY | ETF | 92.12 | 92.17 | 91.57 | 92.03 | 5867200.0 |
| 2002-12-04 12:00:00 | SPY | ETF | 92.03 | 92.37 | 92.01 | 92.3 | 4511300.0 |
| 2002-12-04 13:00:00 | SPY | ETF | 92.27 | 92.55 | 91.77 | 91.78 | 4686300.0 |
| 2002-12-04 14:00:00 | SPY | ETF | 91.76 | 93.0 | 91.75 | 92.81 | 8518100.0 |
| 2002-12-04 15:00:00 | SPY | ETF | 92.8 | 93.14 | 92.23 | 92.37 | 11556900.0 |
| 2002-12-04 16:00:00 | SPY | ETF | 92.36 | 92.58 | 91.8 | 92.31 | 3531000.0 |
| 2002-12-04 17:00:00 | SPY | ETF | 92.3 | 92.35 | 92.22 | 92.23 | 94000.0 |
| 2002-12-04 18:00:00 | SPY | ETF | 92.23 | 92.38 | 92.23 | 92.38 | 26100.0 |
| 2002-12-04 19:00:00 | SPY | ETF | 92.33 | 92.33 | 92.28 | 92.3 | 8800.0 |
| 2002-12-04 08:00:00 | QQQ | ETF | 26.82 | 26.84 | 26.65 | 26.67 | 73500.0 |
| 2002-12-04 09:00:00 | QQQ | ETF | 26.67 | 26.7 | 26.31 | 26.4 | 21078200.0 |
| 2002-12-04 10:00:00 | QQQ | ETF | 26.37 | 26.63 | 26.21 | 26.42 | 17118500.0 |
| 2002-12-04 11:00:00 | QQQ | ETF | 26.43 | 26.46 | 26.22 | 26.4 | 11152100.0 |
| 2002-12-04 12:00:00 | QQQ | ETF | 26.4 | 26.53 | 26.38 | 26.47 | 7890200.0 |
| 2002-12-04 13:00:00 | QQQ | ETF | 26.48 | 26.6 | 26.28 | 26.28 | 12338600.0 |
| 2002-12-04 14:00:00 | QQQ | ETF | 26.29 | 26.91 | 26.27 | 26.82 | 17791700.0 |
| 2002-12-04 15:00:00 | QQQ | ETF | 26.83 | 26.95 | 26.56 | 26.6 | 18493800.0 |
| 2002-12-04 16:00:00 | QQQ | ETF | 26.59 | 26.68 | 26.37 | 26.59 | 7516100.0 |
| 2002-12-04 17:00:00 | QQQ | ETF | 26.6 | 26.62 | 26.55 | 26.58 | 116000.0 |
| 2002-12-04 18:00:00 | QQQ | ETF | 26.6 | 26.65 | 26.56 | 26.63 | 173200.0 |
| 2002-12-04 19:00:00 | QQQ | ETF | 26.61 | 26.62 | 26.5 | 26.56 | 138900.0 |
| 2002-12-04 09:00:00 | IWM | ETF | 39.675 | 39.675 | 39.35 | 39.35 | 478000.0 |
| 2002-12-04 10:00:00 | IWM | ETF | 39.34 | 39.55 | 39.325 | 39.52 | 380800.0 |
| 2002-12-04 11:00:00 | IWM | ETF | 39.51 | 39.52 | 39.34 | 39.52 | 214600.0 |
| 2002-12-04 12:00:00 | IWM | ETF | 39.5 | 39.6 | 39.5 | 39.575 | 86000.0 |
| 2002-12-04 13:00:00 | IWM | ETF | 39.575 | 39.72 | 39.485 | 39.485 | 205000.0 |
| 2002-12-04 14:00:00 | IWM | ETF | 39.475 | 39.98 | 39.465 | 39.925 | 326400.0 |
| 2002-12-04 15:00:00 | IWM | ETF | 39.96 | 40.075 | 39.645 | 39.705 | 343000.0 |
| 2002-12-04 16:00:00 | IWM | ETF | 39.575 | 39.895 | 39.575 | 39.64 | 15600.0 |
| 2002-12-04 17:00:00 | IWM | ETF | 39.64 | 39.685 | 39.64 | 39.685 | 378000.0 |
| 2002-12-04 08:00:00 | DIA | ETF | 87.35 | 87.35 | 86.97 | 87.0 | 9700.0 |
| 2002-12-04 09:00:00 | DIA | ETF | 87.0 | 87.16 | 86.8 | 87.06 | 1591900.0 |
| 2002-12-04 10:00:00 | DIA | ETF | 87.1 | 87.62 | 86.7 | 87.31 | 1847200.0 |
| 2002-12-04 11:00:00 | DIA | ETF | 87.34 | 87.34 | 86.85 | 87.3 | 635900.0 |
| 2002-12-04 12:00:00 | DIA | ETF | 87.28 | 87.57 | 87.27 | 87.55 | 663700.0 |
| 2002-12-04 13:00:00 | DIA | ETF | 87.54 | 87.68 | 87.01 | 87.05 | 565100.0 |
| 2002-12-04 14:00:00 | DIA | ETF | 87.05 | 88.19 | 86.97 | 88.0 | 1459000.0 |
| 2002-12-04 15:00:00 | DIA | ETF | 88.05 | 88.4 | 87.53 | 87.66 | 1469800.0 |
| 2002-12-04 16:00:00 | DIA | ETF | 87.66 | 87.85 | 87.1 | 87.75 | 301900.0 |
| 2002-12-04 17:00:00 | DIA | ETF | 87.75 | 87.8 | 87.69 | 87.75 | 8700.0 |
| 2002-12-04 19:00:00 | DIA | ETF | 87.7 | 87.75 | 87.7 | 87.75 | 1000.0 |
| 2002-12-04 09:00:00 | TLT | ETF | 85.9 | 85.92 | 85.7 | 85.8 | 52000.0 |
| 2002-12-04 10:00:00 | TLT | ETF | 85.7 | 85.83 | 85.68 | 85.69 | 6300.0 |
| 2002-12-04 11:00:00 | TLT | ETF | 85.89 | 85.97 | 85.83 | 85.88 | 19700.0 |
| 2002-12-04 12:00:00 | TLT | ETF | 85.77 | 86.0 | 85.76 | 85.93 | 8900.0 |
| 2002-12-04 13:00:00 | TLT | ETF | 85.77 | 85.85 | 85.67 | 85.85 | 9700.0 |
| 2002-12-04 14:00:00 | TLT | ETF | 85.84 | 85.85 | 85.56 | 85.6 | 6800.0 |
> showing 50 of 384 rows — these rows as CSV