PREVIEW / etf_1hour / 2004-02-11
file: by_date/etf_1hour/2004/2004-02-11.parquet size: 26 KB rows: 709
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 |
|---|---|---|---|---|---|---|---|
| 2004-02-11 08:00:00 | SPY | ETF | 115.0 | 115.01 | 114.87 | 114.93 | 47100.0 |
| 2004-02-11 09:00:00 | SPY | ETF | 114.85 | 114.9 | 114.71 | 114.869 | 2263100.0 |
| 2004-02-11 10:00:00 | SPY | ETF | 114.88 | 114.91 | 114.66 | 114.81 | 2684100.0 |
| 2004-02-11 11:00:00 | SPY | ETF | 114.81 | 115.8 | 114.79 | 115.73 | 12818100.0 |
| 2004-02-11 12:00:00 | SPY | ETF | 115.73 | 115.86 | 115.54 | 115.71 | 2536600.0 |
| 2004-02-11 13:00:00 | SPY | ETF | 115.68 | 116.18 | 115.6 | 116.13 | 5827800.0 |
| 2004-02-11 14:00:00 | SPY | ETF | 116.12 | 116.39 | 116.05 | 116.17 | 5242900.0 |
| 2004-02-11 15:00:00 | SPY | ETF | 116.17 | 116.35 | 115.98 | 116.19 | 6115200.0 |
| 2004-02-11 16:00:00 | SPY | ETF | 116.19 | 116.22 | 116.0 | 116.12 | 1647000.0 |
| 2004-02-11 17:00:00 | SPY | ETF | 116.12 | 116.14 | 116.0 | 116.0 | 27500.0 |
| 2004-02-11 18:00:00 | SPY | ETF | 116.12 | 116.14 | 116.1 | 116.13 | 3400.0 |
| 2004-02-11 19:00:00 | SPY | ETF | 116.13 | 116.14 | 116.11 | 116.11 | 1900.0 |
| 2004-02-11 08:00:00 | QQQ | ETF | 37.32 | 37.35 | 37.27 | 37.3 | 114900.0 |
| 2004-02-11 09:00:00 | QQQ | ETF | 37.28 | 37.3 | 37.0 | 37.28 | 5879400.0 |
| 2004-02-11 10:00:00 | QQQ | ETF | 37.28 | 37.29 | 37.07 | 37.123 | 9481600.0 |
| 2004-02-11 11:00:00 | QQQ | ETF | 37.12 | 37.55 | 37.11 | 37.53 | 26611000.0 |
| 2004-02-11 12:00:00 | QQQ | ETF | 37.53 | 37.61 | 37.49 | 37.529 | 8923000.0 |
| 2004-02-11 13:00:00 | QQQ | ETF | 37.53 | 37.6 | 37.46 | 37.561 | 8287800.0 |
| 2004-02-11 14:00:00 | QQQ | ETF | 37.57 | 37.67 | 37.52 | 37.57 | 10952900.0 |
| 2004-02-11 15:00:00 | QQQ | ETF | 37.56 | 37.67 | 37.47 | 37.58 | 16225600.0 |
| 2004-02-11 16:00:00 | QQQ | ETF | 37.58 | 37.61 | 37.56 | 37.6 | 2558000.0 |
| 2004-02-11 17:00:00 | QQQ | ETF | 37.607 | 37.63 | 37.58 | 37.62 | 56100.0 |
| 2004-02-11 18:00:00 | QQQ | ETF | 37.61 | 37.61 | 37.58 | 37.58 | 37400.0 |
| 2004-02-11 19:00:00 | QQQ | ETF | 37.59 | 37.6 | 37.58 | 37.59 | 19700.0 |
| 2004-02-11 08:00:00 | IWM | ETF | 58.995 | 58.995 | 58.995 | 58.995 | 2000.0 |
| 2004-02-11 09:00:00 | IWM | ETF | 59.007 | 59.05 | 58.895 | 59.025 | 940600.0 |
| 2004-02-11 10:00:00 | IWM | ETF | 59.045 | 59.055 | 58.75 | 58.85 | 1095000.0 |
| 2004-02-11 11:00:00 | IWM | ETF | 58.85 | 59.3 | 58.85 | 59.21 | 1288400.0 |
| 2004-02-11 12:00:00 | IWM | ETF | 59.21 | 59.285 | 59.085 | 59.14 | 233000.0 |
| 2004-02-11 13:00:00 | IWM | ETF | 59.12 | 59.37 | 59.1 | 59.34 | 792800.0 |
| 2004-02-11 14:00:00 | IWM | ETF | 59.35 | 59.44 | 59.25 | 59.35 | 433400.0 |
| 2004-02-11 15:00:00 | IWM | ETF | 59.35 | 59.465 | 59.25 | 59.375 | 1475600.0 |
| 2004-02-11 16:00:00 | IWM | ETF | 59.38 | 59.395 | 59.0 | 59.325 | 730000.0 |
| 2004-02-11 17:00:00 | IWM | ETF | 59.39 | 59.4 | 59.385 | 59.4 | 8400.0 |
| 2004-02-11 08:00:00 | DIA | ETF | 106.58 | 106.58 | 106.45 | 106.53 | 5700.0 |
| 2004-02-11 09:00:00 | DIA | ETF | 106.5 | 106.51 | 106.25 | 106.49 | 375200.0 |
| 2004-02-11 10:00:00 | DIA | ETF | 106.49 | 106.5 | 106.28 | 106.42 | 407600.0 |
| 2004-02-11 11:00:00 | DIA | ETF | 106.38 | 107.23 | 106.36 | 107.1 | 2058300.0 |
| 2004-02-11 12:00:00 | DIA | ETF | 107.1 | 107.2 | 106.85 | 107.05 | 520600.0 |
| 2004-02-11 13:00:00 | DIA | ETF | 107.05 | 107.63 | 107.02 | 107.57 | 846500.0 |
| 2004-02-11 14:00:00 | DIA | ETF | 107.58 | 107.78 | 107.44 | 107.58 | 602800.0 |
| 2004-02-11 15:00:00 | DIA | ETF | 107.6 | 107.75 | 107.44 | 107.61 | 1088000.0 |
| 2004-02-11 16:00:00 | DIA | ETF | 107.61 | 107.66 | 107.38 | 107.54 | 734800.0 |
| 2004-02-11 17:00:00 | DIA | ETF | 107.51 | 107.58 | 107.48 | 107.48 | 6400.0 |
| 2004-02-11 18:00:00 | DIA | ETF | 107.45 | 107.5 | 107.45 | 107.5 | 400.0 |
| 2004-02-11 19:00:00 | DIA | ETF | 107.54 | 107.54 | 107.47 | 107.47 | 1000.0 |
| 2004-02-11 09:00:00 | TLT | ETF | 87.02 | 87.05 | 86.91 | 87.04 | 56500.0 |
| 2004-02-11 10:00:00 | TLT | ETF | 87.0 | 87.06 | 86.95 | 86.95 | 97800.0 |
| 2004-02-11 11:00:00 | TLT | ETF | 86.97 | 87.93 | 86.97 | 87.83 | 494400.0 |
| 2004-02-11 12:00:00 | TLT | ETF | 87.89 | 88.11 | 87.83 | 87.93 | 155500.0 |
> showing 50 of 709 rows — these rows as CSV