PREVIEW / etf_1hour / 2003-04-08
file: by_date/etf_1hour/2003/2003-04-08.parquet size: 16 KB rows: 387
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-04-08 08:00:00 | SPY | ETF | 88.84 | 88.84 | 88.4 | 88.45 | 116700.0 |
| 2003-04-08 09:00:00 | SPY | ETF | 88.43 | 88.48 | 87.83 | 87.9 | 5802300.0 |
| 2003-04-08 10:00:00 | SPY | ETF | 87.93 | 88.5 | 87.71 | 88.44 | 6849000.0 |
| 2003-04-08 11:00:00 | SPY | ETF | 88.46 | 88.51 | 87.79 | 88.16 | 6751400.0 |
| 2003-04-08 12:00:00 | SPY | ETF | 88.15 | 88.46 | 87.95 | 88.27 | 3142900.0 |
| 2003-04-08 13:00:00 | SPY | ETF | 88.27 | 88.45 | 88.1 | 88.35 | 2418400.0 |
| 2003-04-08 14:00:00 | SPY | ETF | 88.33 | 88.65 | 88.02 | 88.09 | 4630000.0 |
| 2003-04-08 15:00:00 | SPY | ETF | 88.08 | 88.33 | 87.95 | 88.13 | 5205300.0 |
| 2003-04-08 16:00:00 | SPY | ETF | 88.09 | 88.26 | 88.06 | 88.25 | 2160200.0 |
| 2003-04-08 17:00:00 | SPY | ETF | 88.25 | 88.28 | 88.16 | 88.23 | 20700.0 |
| 2003-04-08 18:00:00 | SPY | ETF | 88.24 | 88.25 | 88.13 | 88.17 | 16700.0 |
| 2003-04-08 19:00:00 | SPY | ETF | 88.13 | 88.24 | 88.13 | 88.13 | 11300.0 |
| 2003-04-08 08:00:00 | QQQ | ETF | 26.35 | 26.41 | 26.11 | 26.16 | 235700.0 |
| 2003-04-08 09:00:00 | QQQ | ETF | 26.16 | 26.2 | 25.93 | 25.95 | 9526800.0 |
| 2003-04-08 10:00:00 | QQQ | ETF | 25.96 | 26.21 | 25.88 | 26.2 | 11340200.0 |
| 2003-04-08 11:00:00 | QQQ | ETF | 26.17 | 26.22 | 25.98 | 26.1 | 6086300.0 |
| 2003-04-08 12:00:00 | QQQ | ETF | 26.1 | 26.2 | 26.01 | 26.15 | 3168600.0 |
| 2003-04-08 13:00:00 | QQQ | ETF | 26.14 | 26.19 | 26.07 | 26.16 | 3564800.0 |
| 2003-04-08 14:00:00 | QQQ | ETF | 26.16 | 26.29 | 26.02 | 26.03 | 7867600.0 |
| 2003-04-08 15:00:00 | QQQ | ETF | 26.03 | 26.12 | 25.96 | 26.0 | 5920300.0 |
| 2003-04-08 16:00:00 | QQQ | ETF | 26.0 | 26.14 | 25.07 | 26.08 | 1146300.0 |
| 2003-04-08 17:00:00 | QQQ | ETF | 26.09 | 26.09 | 26.05 | 26.06 | 56500.0 |
| 2003-04-08 18:00:00 | QQQ | ETF | 26.07 | 26.07 | 26.05 | 26.06 | 18400.0 |
| 2003-04-08 19:00:00 | QQQ | ETF | 26.07 | 26.09 | 26.04 | 26.05 | 8100.0 |
| 2003-04-08 09:00:00 | IWM | ETF | 37.35 | 37.45 | 37.275 | 37.275 | 228200.0 |
| 2003-04-08 10:00:00 | IWM | ETF | 37.295 | 37.375 | 37.18 | 37.375 | 505400.0 |
| 2003-04-08 11:00:00 | IWM | ETF | 37.365 | 37.4 | 37.22 | 37.275 | 433200.0 |
| 2003-04-08 12:00:00 | IWM | ETF | 37.31 | 37.4 | 37.235 | 37.4 | 161600.0 |
| 2003-04-08 13:00:00 | IWM | ETF | 37.38 | 37.47 | 37.365 | 37.43 | 159400.0 |
| 2003-04-08 14:00:00 | IWM | ETF | 37.46 | 37.5 | 37.345 | 37.355 | 216600.0 |
| 2003-04-08 15:00:00 | IWM | ETF | 37.375 | 37.395 | 37.265 | 37.32 | 223200.0 |
| 2003-04-08 16:00:00 | IWM | ETF | 37.315 | 37.345 | 37.315 | 37.345 | 3600.0 |
| 2003-04-08 08:00:00 | DIA | ETF | 83.52 | 83.6 | 83.35 | 83.35 | 6100.0 |
| 2003-04-08 09:00:00 | DIA | ETF | 83.24 | 83.32 | 82.76 | 82.8 | 1493700.0 |
| 2003-04-08 10:00:00 | DIA | ETF | 82.8 | 83.46 | 82.73 | 83.45 | 1322200.0 |
| 2003-04-08 11:00:00 | DIA | ETF | 83.4 | 83.45 | 82.85 | 83.11 | 961500.0 |
| 2003-04-08 12:00:00 | DIA | ETF | 83.1 | 83.45 | 83.0 | 83.28 | 457800.0 |
| 2003-04-08 13:00:00 | DIA | ETF | 83.3 | 83.43 | 83.15 | 83.33 | 812300.0 |
| 2003-04-08 14:00:00 | DIA | ETF | 83.32 | 83.56 | 83.04 | 83.1 | 1049500.0 |
| 2003-04-08 15:00:00 | DIA | ETF | 83.11 | 83.35 | 82.97 | 83.14 | 906100.0 |
| 2003-04-08 16:00:00 | DIA | ETF | 83.14 | 83.33 | 83.1 | 83.33 | 57300.0 |
| 2003-04-08 17:00:00 | DIA | ETF | 83.31 | 83.31 | 83.25 | 83.3 | 5500.0 |
| 2003-04-08 18:00:00 | DIA | ETF | 83.27 | 83.27 | 83.2 | 83.27 | 600.0 |
| 2003-04-08 19:00:00 | DIA | ETF | 83.25 | 83.25 | 83.25 | 83.25 | 200.0 |
| 2003-04-08 09:00:00 | TLT | ETF | 87.05 | 87.25 | 87.01 | 87.25 | 26400.0 |
| 2003-04-08 10:00:00 | TLT | ETF | 87.29 | 87.3 | 87.0 | 87.0 | 54100.0 |
| 2003-04-08 11:00:00 | TLT | ETF | 87.0 | 87.28 | 86.99 | 87.26 | 64100.0 |
| 2003-04-08 12:00:00 | TLT | ETF | 87.26 | 87.26 | 87.2 | 87.2 | 1500.0 |
| 2003-04-08 13:00:00 | TLT | ETF | 87.2 | 87.31 | 87.2 | 87.29 | 1000.0 |
| 2003-04-08 14:00:00 | TLT | ETF | 87.29 | 87.46 | 87.16 | 87.44 | 7000.0 |
> showing 50 of 387 rows — these rows as CSV