PREVIEW / etf_1hour / 2004-02-10
file: by_date/etf_1hour/2004/2004-02-10.parquet size: 24 KB rows: 693
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-10 08:00:00 | SPY | ETF | 114.4 | 114.4 | 114.38 | 114.38 | 13000.0 |
| 2004-02-10 09:00:00 | SPY | ETF | 114.4 | 114.51 | 114.26 | 114.48 | 3128900.0 |
| 2004-02-10 10:00:00 | SPY | ETF | 114.49 | 114.84 | 114.41 | 114.79 | 3711400.0 |
| 2004-02-10 11:00:00 | SPY | ETF | 114.79 | 114.83 | 114.62 | 114.68 | 1862400.0 |
| 2004-02-10 12:00:00 | SPY | ETF | 114.68 | 115.14 | 114.64 | 115.08 | 2327900.0 |
| 2004-02-10 13:00:00 | SPY | ETF | 115.09 | 115.09 | 114.92 | 115.0 | 1741400.0 |
| 2004-02-10 14:00:00 | SPY | ETF | 114.97 | 115.08 | 114.52 | 114.61 | 4955000.0 |
| 2004-02-10 15:00:00 | SPY | ETF | 114.63 | 114.97 | 114.57 | 114.9 | 3886900.0 |
| 2004-02-10 16:00:00 | SPY | ETF | 114.9 | 114.97 | 114.77 | 114.79 | 1644200.0 |
| 2004-02-10 17:00:00 | SPY | ETF | 114.79 | 114.87 | 114.79 | 114.86 | 17400.0 |
| 2004-02-10 18:00:00 | SPY | ETF | 114.86 | 114.88 | 114.86 | 114.87 | 25100.0 |
| 2004-02-10 08:00:00 | QQQ | ETF | 37.11 | 37.15 | 37.1 | 37.11 | 45000.0 |
| 2004-02-10 09:00:00 | QQQ | ETF | 37.1 | 37.157 | 37.03 | 37.14 | 6399200.0 |
| 2004-02-10 10:00:00 | QQQ | ETF | 37.15 | 37.35 | 37.116 | 37.33 | 12002400.0 |
| 2004-02-10 11:00:00 | QQQ | ETF | 37.323 | 37.36 | 37.2 | 37.247 | 8234200.0 |
| 2004-02-10 12:00:00 | QQQ | ETF | 37.24 | 37.41 | 37.23 | 37.38 | 7001000.0 |
| 2004-02-10 13:00:00 | QQQ | ETF | 37.37 | 37.39 | 37.27 | 37.3 | 4693000.0 |
| 2004-02-10 14:00:00 | QQQ | ETF | 37.3 | 37.34 | 37.112 | 37.12 | 9435400.0 |
| 2004-02-10 15:00:00 | QQQ | ETF | 37.13 | 37.241 | 37.08 | 37.23 | 12822100.0 |
| 2004-02-10 16:00:00 | QQQ | ETF | 37.23 | 37.265 | 37.17 | 37.204 | 2185100.0 |
| 2004-02-10 17:00:00 | QQQ | ETF | 37.201 | 37.3 | 37.191 | 37.23 | 237000.0 |
| 2004-02-10 18:00:00 | QQQ | ETF | 37.24 | 37.25 | 37.23 | 37.24 | 34300.0 |
| 2004-02-10 19:00:00 | QQQ | ETF | 37.23 | 37.25 | 37.23 | 37.24 | 5000.0 |
| 2004-02-10 09:00:00 | IWM | ETF | 58.34 | 58.45 | 58.23 | 58.35 | 1189000.0 |
| 2004-02-10 10:00:00 | IWM | ETF | 58.37 | 58.6 | 58.18 | 58.575 | 964600.0 |
| 2004-02-10 11:00:00 | IWM | ETF | 58.58 | 58.65 | 58.465 | 58.465 | 297600.0 |
| 2004-02-10 12:00:00 | IWM | ETF | 58.47 | 58.675 | 58.47 | 58.665 | 208800.0 |
| 2004-02-10 13:00:00 | IWM | ETF | 58.665 | 58.67 | 58.575 | 58.585 | 310200.0 |
| 2004-02-10 14:00:00 | IWM | ETF | 58.585 | 58.66 | 58.415 | 58.435 | 451800.0 |
| 2004-02-10 15:00:00 | IWM | ETF | 58.45 | 58.965 | 58.4375 | 58.955 | 884600.0 |
| 2004-02-10 16:00:00 | IWM | ETF | 58.98 | 59.07 | 58.94 | 58.95 | 392800.0 |
| 2004-02-10 17:00:00 | IWM | ETF | 58.945 | 59.07 | 58.945 | 59.07 | 112000.0 |
| 2004-02-10 18:00:00 | IWM | ETF | 58.95 | 58.95 | 58.95 | 58.95 | 200.0 |
| 2004-02-10 08:00:00 | DIA | ETF | 106.06 | 106.06 | 105.99 | 106.0 | 6700.0 |
| 2004-02-10 09:00:00 | DIA | ETF | 106.0 | 106.04 | 105.82 | 106.02 | 388200.0 |
| 2004-02-10 10:00:00 | DIA | ETF | 105.98 | 106.29 | 105.92 | 106.27 | 559600.0 |
| 2004-02-10 11:00:00 | DIA | ETF | 106.25 | 106.276 | 106.079 | 106.12 | 413500.0 |
| 2004-02-10 12:00:00 | DIA | ETF | 106.13 | 106.56 | 106.12 | 106.476 | 542500.0 |
| 2004-02-10 13:00:00 | DIA | ETF | 106.42 | 106.43 | 106.259 | 106.35 | 150100.0 |
| 2004-02-10 14:00:00 | DIA | ETF | 106.35 | 106.44 | 105.97 | 106.02 | 637200.0 |
| 2004-02-10 15:00:00 | DIA | ETF | 106.061 | 106.36 | 106.02 | 106.33 | 388900.0 |
| 2004-02-10 16:00:00 | DIA | ETF | 106.34 | 106.35 | 106.24 | 106.25 | 62600.0 |
| 2004-02-10 17:00:00 | DIA | ETF | 106.32 | 106.35 | 106.32 | 106.35 | 3700.0 |
| 2004-02-10 09:00:00 | TLT | ETF | 87.48 | 87.55 | 87.48 | 87.5 | 4400.0 |
| 2004-02-10 10:00:00 | TLT | ETF | 87.49 | 87.49 | 87.22 | 87.26 | 28800.0 |
| 2004-02-10 11:00:00 | TLT | ETF | 87.26 | 87.31 | 87.19 | 87.24 | 9800.0 |
| 2004-02-10 12:00:00 | TLT | ETF | 87.29 | 87.29 | 87.19 | 87.22 | 6900.0 |
| 2004-02-10 13:00:00 | TLT | ETF | 87.22 | 87.34 | 87.04 | 87.14 | 49800.0 |
| 2004-02-10 14:00:00 | TLT | ETF | 87.19 | 87.19 | 87.05 | 87.14 | 55200.0 |
| 2004-02-10 15:00:00 | TLT | ETF | 87.14 | 87.21 | 87.1 | 87.15 | 47600.0 |
> showing 50 of 693 rows — these rows as CSV