PREVIEW / etf_1hour / 2003-03-21
file: by_date/etf_1hour/2003/2003-03-21.parquet size: 17 KB rows: 413
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-03-21 08:00:00 | SPY | ETF | 88.7 | 88.76 | 88.5 | 88.76 | 107700.0 |
| 2003-03-21 09:00:00 | SPY | ETF | 88.76 | 88.85 | 88.21 | 88.25 | 7528700.0 |
| 2003-03-21 10:00:00 | SPY | ETF | 88.27 | 88.68 | 88.13 | 88.35 | 6410200.0 |
| 2003-03-21 11:00:00 | SPY | ETF | 88.35 | 89.04 | 87.93 | 88.63 | 9342700.0 |
| 2003-03-21 12:00:00 | SPY | ETF | 88.64 | 89.64 | 88.5 | 89.45 | 9061400.0 |
| 2003-03-21 13:00:00 | SPY | ETF | 89.44 | 89.54 | 88.87 | 89.0 | 11786800.0 |
| 2003-03-21 14:00:00 | SPY | ETF | 89.0 | 89.38 | 88.7 | 89.16 | 6122800.0 |
| 2003-03-21 15:00:00 | SPY | ETF | 89.18 | 89.88 | 89.16 | 89.74 | 11194400.0 |
| 2003-03-21 16:00:00 | SPY | ETF | 89.77 | 89.86 | 89.39 | 89.82 | 4286000.0 |
| 2003-03-21 17:00:00 | SPY | ETF | 89.8 | 89.92 | 89.78 | 89.92 | 89200.0 |
| 2003-03-21 18:00:00 | SPY | ETF | 89.92 | 89.95 | 89.85 | 89.86 | 50500.0 |
| 2003-03-21 19:00:00 | SPY | ETF | 89.85 | 89.95 | 89.85 | 89.85 | 2200.0 |
| 2003-03-21 08:00:00 | QQQ | ETF | 27.11 | 27.15 | 27.05 | 27.15 | 105500.0 |
| 2003-03-21 09:00:00 | QQQ | ETF | 27.15 | 27.24 | 26.95 | 26.98 | 15410500.0 |
| 2003-03-21 10:00:00 | QQQ | ETF | 26.99 | 27.09 | 26.94 | 27.0 | 9619600.0 |
| 2003-03-21 11:00:00 | QQQ | ETF | 26.99 | 27.2 | 26.77 | 27.01 | 11817300.0 |
| 2003-03-21 12:00:00 | QQQ | ETF | 27.04 | 27.38 | 26.95 | 27.3 | 13850700.0 |
| 2003-03-21 13:00:00 | QQQ | ETF | 27.3 | 27.31 | 26.98 | 27.05 | 11353100.0 |
| 2003-03-21 14:00:00 | QQQ | ETF | 27.05 | 27.16 | 26.91 | 27.12 | 9461500.0 |
| 2003-03-21 15:00:00 | QQQ | ETF | 27.1 | 27.22 | 27.06 | 27.16 | 12761900.0 |
| 2003-03-21 16:00:00 | QQQ | ETF | 27.16 | 27.2 | 27.1 | 27.18 | 3493900.0 |
| 2003-03-21 17:00:00 | QQQ | ETF | 27.18 | 27.28 | 27.15 | 27.21 | 178600.0 |
| 2003-03-21 18:00:00 | QQQ | ETF | 27.21 | 27.24 | 27.2 | 27.22 | 64200.0 |
| 2003-03-21 19:00:00 | QQQ | ETF | 27.21 | 27.26 | 27.21 | 27.24 | 12300.0 |
| 2003-03-21 09:00:00 | IWM | ETF | 37.165 | 37.215 | 36.95 | 37.0 | 240600.0 |
| 2003-03-21 10:00:00 | IWM | ETF | 36.965 | 37.14 | 36.965 | 37.03 | 1154000.0 |
| 2003-03-21 11:00:00 | IWM | ETF | 37.025 | 37.135 | 36.89 | 37.06 | 3324200.0 |
| 2003-03-21 12:00:00 | IWM | ETF | 37.07 | 37.395 | 37.07 | 37.38 | 811200.0 |
| 2003-03-21 13:00:00 | IWM | ETF | 37.38 | 37.38 | 37.21 | 37.255 | 121400.0 |
| 2003-03-21 14:00:00 | IWM | ETF | 37.255 | 37.315 | 37.2 | 37.295 | 193200.0 |
| 2003-03-21 15:00:00 | IWM | ETF | 37.28 | 37.5 | 37.28 | 37.45 | 676000.0 |
| 2003-03-21 16:00:00 | IWM | ETF | 37.46 | 37.46 | 37.385 | 37.385 | 67600.0 |
| 2003-03-21 08:00:00 | DIA | ETF | 83.72 | 83.8 | 83.48 | 83.8 | 25000.0 |
| 2003-03-21 09:00:00 | DIA | ETF | 83.79 | 83.95 | 83.5 | 83.55 | 2075400.0 |
| 2003-03-21 10:00:00 | DIA | ETF | 83.57 | 83.89 | 83.46 | 83.7 | 1440500.0 |
| 2003-03-21 11:00:00 | DIA | ETF | 83.65 | 84.2 | 83.3 | 83.98 | 2108700.0 |
| 2003-03-21 12:00:00 | DIA | ETF | 83.95 | 84.92 | 83.85 | 84.75 | 2924300.0 |
| 2003-03-21 13:00:00 | DIA | ETF | 84.75 | 84.81 | 84.31 | 84.47 | 1813400.0 |
| 2003-03-21 14:00:00 | DIA | ETF | 84.45 | 84.82 | 84.23 | 84.73 | 1772000.0 |
| 2003-03-21 15:00:00 | DIA | ETF | 84.65 | 85.36 | 84.65 | 85.3 | 3329500.0 |
| 2003-03-21 16:00:00 | DIA | ETF | 85.27 | 85.34 | 85.0 | 85.07 | 393600.0 |
| 2003-03-21 17:00:00 | DIA | ETF | 85.1 | 85.15 | 85.02 | 85.15 | 20000.0 |
| 2003-03-21 18:00:00 | DIA | ETF | 85.14 | 85.19 | 85.09 | 85.19 | 3300.0 |
| 2003-03-21 19:00:00 | DIA | ETF | 85.15 | 85.2 | 85.12 | 85.14 | 2600.0 |
| 2003-03-21 09:00:00 | TLT | ETF | 86.92 | 87.05 | 86.85 | 86.92 | 70900.0 |
| 2003-03-21 10:00:00 | TLT | ETF | 86.8 | 86.85 | 86.42 | 86.5 | 280500.0 |
| 2003-03-21 11:00:00 | TLT | ETF | 86.58 | 86.7 | 86.3 | 86.35 | 227600.0 |
| 2003-03-21 12:00:00 | TLT | ETF | 86.43 | 86.43 | 86.12 | 86.18 | 36100.0 |
| 2003-03-21 13:00:00 | TLT | ETF | 86.16 | 86.37 | 86.15 | 86.37 | 110500.0 |
| 2003-03-21 14:00:00 | TLT | ETF | 86.35 | 86.4 | 86.17 | 86.25 | 9400.0 |
> showing 50 of 413 rows — these rows as CSV