PREVIEW / etf_1hour / 2003-12-30
file: by_date/etf_1hour/2003/2003-12-30.parquet size: 19 KB rows: 506
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-30 08:00:00 | SPY | ETF | 111.09 | 111.16 | 111.06 | 111.15 | 10400.0 |
| 2003-12-30 09:00:00 | SPY | ETF | 111.06 | 111.24 | 111.01 | 111.05 | 3205900.0 |
| 2003-12-30 10:00:00 | SPY | ETF | 111.06 | 111.23 | 110.88 | 111.14 | 4638800.0 |
| 2003-12-30 11:00:00 | SPY | ETF | 111.14 | 111.27 | 111.06 | 111.15 | 2038700.0 |
| 2003-12-30 12:00:00 | SPY | ETF | 111.15 | 111.2 | 111.0 | 111.06 | 1197500.0 |
| 2003-12-30 13:00:00 | SPY | ETF | 111.05 | 111.15 | 110.98 | 111.05 | 1496700.0 |
| 2003-12-30 14:00:00 | SPY | ETF | 111.06 | 111.19 | 110.99 | 111.06 | 1163500.0 |
| 2003-12-30 15:00:00 | SPY | ETF | 111.09 | 111.22 | 110.93 | 111.12 | 2442200.0 |
| 2003-12-30 16:00:00 | SPY | ETF | 111.17 | 111.23 | 111.1048 | 111.16 | 2019000.0 |
| 2003-12-30 17:00:00 | SPY | ETF | 111.16 | 111.23 | 111.16 | 111.19 | 38000.0 |
| 2003-12-30 18:00:00 | SPY | ETF | 111.18 | 111.21 | 111.18 | 111.19 | 18000.0 |
| 2003-12-30 19:00:00 | SPY | ETF | 111.23 | 111.25 | 111.23 | 111.25 | 2700.0 |
| 2003-12-30 08:00:00 | QQQ | ETF | 36.62 | 36.62 | 36.55 | 36.57 | 53400.0 |
| 2003-12-30 09:00:00 | QQQ | ETF | 36.57 | 36.57 | 36.385 | 36.391 | 7773800.0 |
| 2003-12-30 10:00:00 | QQQ | ETF | 36.39 | 36.55 | 36.3 | 36.48 | 16346900.0 |
| 2003-12-30 11:00:00 | QQQ | ETF | 36.48 | 36.51 | 36.41 | 36.44 | 3884600.0 |
| 2003-12-30 12:00:00 | QQQ | ETF | 36.45 | 36.46 | 36.34 | 36.36 | 2932800.0 |
| 2003-12-30 13:00:00 | QQQ | ETF | 36.367 | 36.45 | 36.33 | 36.422 | 2805700.0 |
| 2003-12-30 14:00:00 | QQQ | ETF | 36.41 | 36.49 | 36.39 | 36.442 | 3070000.0 |
| 2003-12-30 15:00:00 | QQQ | ETF | 36.44 | 36.5 | 36.34 | 36.476 | 7594800.0 |
| 2003-12-30 16:00:00 | QQQ | ETF | 36.47 | 36.58 | 36.46 | 36.55 | 1361100.0 |
| 2003-12-30 17:00:00 | QQQ | ETF | 36.55 | 36.562 | 36.54 | 36.55 | 25300.0 |
| 2003-12-30 18:00:00 | QQQ | ETF | 36.56 | 36.57 | 36.55 | 36.56 | 12500.0 |
| 2003-12-30 19:00:00 | QQQ | ETF | 36.56 | 36.57 | 36.55 | 36.57 | 11200.0 |
| 2003-12-30 08:00:00 | IWM | ETF | 56.095 | 56.095 | 56.095 | 56.095 | 5000.0 |
| 2003-12-30 09:00:00 | IWM | ETF | 56.0 | 56.205 | 55.905 | 56.1 | 1184600.0 |
| 2003-12-30 10:00:00 | IWM | ETF | 56.1075 | 56.35 | 55.975 | 56.295 | 847600.0 |
| 2003-12-30 11:00:00 | IWM | ETF | 56.29 | 56.315 | 56.19 | 56.235 | 325200.0 |
| 2003-12-30 12:00:00 | IWM | ETF | 56.225 | 56.265 | 56.1 | 56.12 | 219600.0 |
| 2003-12-30 13:00:00 | IWM | ETF | 56.12 | 56.225 | 56.06 | 56.12 | 461400.0 |
| 2003-12-30 14:00:00 | IWM | ETF | 56.14 | 56.295 | 56.115 | 56.225 | 243200.0 |
| 2003-12-30 15:00:00 | IWM | ETF | 56.22 | 56.23 | 56.03 | 56.185 | 916600.0 |
| 2003-12-30 16:00:00 | IWM | ETF | 56.15 | 56.25 | 56.15 | 56.15 | 525800.0 |
| 2003-12-30 17:00:00 | IWM | ETF | 56.225 | 56.225 | 56.225 | 56.225 | 400.0 |
| 2003-12-30 18:00:00 | IWM | ETF | 56.235 | 56.235 | 56.23 | 56.23 | 1200.0 |
| 2003-12-30 08:00:00 | DIA | ETF | 104.58 | 104.66 | 104.58 | 104.62 | 2700.0 |
| 2003-12-30 09:00:00 | DIA | ETF | 104.53 | 104.74 | 104.47 | 104.53 | 1190400.0 |
| 2003-12-30 10:00:00 | DIA | ETF | 104.555 | 104.58 | 104.211 | 104.51 | 1283200.0 |
| 2003-12-30 11:00:00 | DIA | ETF | 104.47 | 104.53 | 104.357 | 104.43 | 354500.0 |
| 2003-12-30 12:00:00 | DIA | ETF | 104.45 | 104.52 | 104.31 | 104.37 | 222800.0 |
| 2003-12-30 13:00:00 | DIA | ETF | 104.37 | 104.45 | 104.31 | 104.37 | 200700.0 |
| 2003-12-30 14:00:00 | DIA | ETF | 104.4 | 104.48 | 104.3 | 104.36 | 302400.0 |
| 2003-12-30 15:00:00 | DIA | ETF | 104.33 | 104.41 | 104.16 | 104.325 | 997000.0 |
| 2003-12-30 16:00:00 | DIA | ETF | 104.31 | 104.6281 | 104.2 | 104.36 | 682500.0 |
| 2003-12-30 17:00:00 | DIA | ETF | 104.4 | 104.4 | 104.35 | 104.35 | 300.0 |
| 2003-12-30 18:00:00 | DIA | ETF | 104.36 | 104.36 | 104.36 | 104.36 | 1000.0 |
| 2003-12-30 19:00:00 | DIA | ETF | 104.41 | 104.41 | 104.41 | 104.41 | 200.0 |
| 2003-12-30 09:00:00 | TLT | ETF | 85.8 | 85.85 | 85.64 | 85.8 | 67400.0 |
| 2003-12-30 10:00:00 | TLT | ETF | 85.85 | 86.14 | 85.85 | 85.94 | 59800.0 |
| 2003-12-30 11:00:00 | TLT | ETF | 85.94 | 86.02 | 85.82 | 85.82 | 52100.0 |
> showing 50 of 506 rows — these rows as CSV