PREVIEW / etf_1hour / 2003-05-21
file: by_date/etf_1hour/2003/2003-05-21.parquet size: 16 KB rows: 386
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-05-21 08:00:00 | SPY | ETF | 91.88 | 92.3 | 91.88 | 92.14 | 83200.0 |
| 2003-05-21 09:00:00 | SPY | ETF | 92.1 | 92.36 | 91.91 | 92.0 | 5411100.0 |
| 2003-05-21 10:00:00 | SPY | ETF | 92.0 | 92.77 | 91.96 | 92.49 | 10419000.0 |
| 2003-05-21 11:00:00 | SPY | ETF | 92.49 | 92.51 | 92.0 | 92.11 | 2876800.0 |
| 2003-05-21 12:00:00 | SPY | ETF | 92.11 | 92.88 | 92.05 | 92.72 | 4001800.0 |
| 2003-05-21 13:00:00 | SPY | ETF | 92.72 | 92.82 | 92.36 | 92.43 | 2644500.0 |
| 2003-05-21 14:00:00 | SPY | ETF | 92.43 | 92.82 | 92.33 | 92.73 | 3789500.0 |
| 2003-05-21 15:00:00 | SPY | ETF | 92.71 | 92.83 | 92.49 | 92.77 | 7104700.0 |
| 2003-05-21 16:00:00 | SPY | ETF | 92.78 | 92.81 | 92.61 | 92.67 | 2424700.0 |
| 2003-05-21 17:00:00 | SPY | ETF | 92.67 | 92.71 | 92.48 | 92.51 | 436900.0 |
| 2003-05-21 18:00:00 | SPY | ETF | 92.53 | 92.6 | 92.48 | 92.53 | 22800.0 |
| 2003-05-21 19:00:00 | SPY | ETF | 92.48 | 92.56 | 92.48 | 92.56 | 7000.0 |
| 2003-05-21 08:00:00 | QQQ | ETF | 27.57 | 27.76 | 27.56 | 27.69 | 144500.0 |
| 2003-05-21 09:00:00 | QQQ | ETF | 27.68 | 27.74 | 27.46 | 27.47 | 8667400.0 |
| 2003-05-21 10:00:00 | QQQ | ETF | 27.48 | 27.75 | 27.45 | 27.57 | 11506000.0 |
| 2003-05-21 11:00:00 | QQQ | ETF | 27.57 | 27.59 | 27.45 | 27.5 | 6181800.0 |
| 2003-05-21 12:00:00 | QQQ | ETF | 27.5 | 27.69 | 27.44 | 27.63 | 7150800.0 |
| 2003-05-21 13:00:00 | QQQ | ETF | 27.63 | 27.69 | 27.5 | 27.52 | 5553400.0 |
| 2003-05-21 14:00:00 | QQQ | ETF | 27.5 | 27.7 | 27.47 | 27.64 | 6530900.0 |
| 2003-05-21 15:00:00 | QQQ | ETF | 27.64 | 27.73 | 27.55 | 27.71 | 7158400.0 |
| 2003-05-21 16:00:00 | QQQ | ETF | 27.71 | 27.73 | 27.66 | 27.7 | 957800.0 |
| 2003-05-21 17:00:00 | QQQ | ETF | 27.7 | 27.71 | 27.62 | 27.63 | 338800.0 |
| 2003-05-21 18:00:00 | QQQ | ETF | 27.63 | 27.64 | 27.59 | 27.6 | 161500.0 |
| 2003-05-21 19:00:00 | QQQ | ETF | 27.62 | 27.62 | 27.57 | 27.59 | 32200.0 |
| 2003-05-21 20:00:00 | QQQ | ETF | 27.59 | 27.59 | 27.58 | 27.58 | 600.0 |
| 2003-05-21 09:00:00 | IWM | ETF | 40.705 | 40.775 | 40.585 | 40.595 | 256200.0 |
| 2003-05-21 10:00:00 | IWM | ETF | 40.59 | 40.755 | 40.59 | 40.705 | 898200.0 |
| 2003-05-21 11:00:00 | IWM | ETF | 40.695 | 40.71 | 40.605 | 40.65 | 499800.0 |
| 2003-05-21 12:00:00 | IWM | ETF | 40.65 | 40.91 | 40.63 | 40.88 | 216000.0 |
| 2003-05-21 13:00:00 | IWM | ETF | 40.87 | 40.905 | 40.8 | 40.8 | 82600.0 |
| 2003-05-21 14:00:00 | IWM | ETF | 40.795 | 40.965 | 40.795 | 40.935 | 201400.0 |
| 2003-05-21 15:00:00 | IWM | ETF | 40.92 | 41.05 | 40.88 | 40.97 | 364600.0 |
| 2003-05-21 16:00:00 | IWM | ETF | 40.955 | 40.955 | 40.945 | 40.945 | 11600.0 |
| 2003-05-21 08:00:00 | DIA | ETF | 84.71 | 84.95 | 84.71 | 84.9 | 13100.0 |
| 2003-05-21 09:00:00 | DIA | ETF | 84.92 | 85.0 | 84.51 | 84.6 | 1318600.0 |
| 2003-05-21 10:00:00 | DIA | ETF | 84.58 | 85.35 | 84.55 | 85.12 | 2052000.0 |
| 2003-05-21 11:00:00 | DIA | ETF | 85.07 | 85.07 | 84.69 | 84.79 | 542100.0 |
| 2003-05-21 12:00:00 | DIA | ETF | 84.75 | 85.43 | 84.68 | 85.25 | 1024900.0 |
| 2003-05-21 13:00:00 | DIA | ETF | 85.21 | 85.35 | 84.97 | 84.99 | 520400.0 |
| 2003-05-21 14:00:00 | DIA | ETF | 84.99 | 85.34 | 84.93 | 85.24 | 379100.0 |
| 2003-05-21 15:00:00 | DIA | ETF | 85.22 | 85.4 | 85.05 | 85.28 | 764700.0 |
| 2003-05-21 16:00:00 | DIA | ETF | 85.25 | 85.27 | 85.18 | 85.21 | 104100.0 |
| 2003-05-21 17:00:00 | DIA | ETF | 85.24 | 85.25 | 85.09 | 85.1 | 4000.0 |
| 2003-05-21 18:00:00 | DIA | ETF | 85.09 | 85.14 | 85.0 | 85.07 | 3500.0 |
| 2003-05-21 19:00:00 | DIA | ETF | 85.05 | 85.05 | 85.05 | 85.05 | 700.0 |
| 2003-05-21 09:00:00 | TLT | ETF | 94.25 | 95.19 | 94.12 | 95.19 | 300400.0 |
| 2003-05-21 10:00:00 | TLT | ETF | 95.06 | 95.28 | 94.84 | 95.09 | 367100.0 |
| 2003-05-21 11:00:00 | TLT | ETF | 95.1 | 95.55 | 95.1 | 95.47 | 266600.0 |
| 2003-05-21 12:00:00 | TLT | ETF | 95.49 | 95.66 | 95.22 | 95.4 | 240300.0 |
| 2003-05-21 13:00:00 | TLT | ETF | 95.35 | 95.4 | 95.02 | 95.15 | 74600.0 |
> showing 50 of 386 rows — these rows as CSV