PREVIEW / etf_1hour / 2003-06-13
file: by_date/etf_1hour/2003/2003-06-13.parquet size: 17 KB rows: 436
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-06-13 08:00:00 | SPY | ETF | 100.5 | 100.77 | 100.5 | 100.72 | 37700.0 |
| 2003-06-13 09:00:00 | SPY | ETF | 100.7 | 100.75 | 99.97 | 100.12 | 8528900.0 |
| 2003-06-13 10:00:00 | SPY | ETF | 100.12 | 100.21 | 99.43 | 99.47 | 9186100.0 |
| 2003-06-13 11:00:00 | SPY | ETF | 99.47 | 99.53 | 99.14 | 99.32 | 5899100.0 |
| 2003-06-13 12:00:00 | SPY | ETF | 99.32 | 99.51 | 99.16 | 99.37 | 3249600.0 |
| 2003-06-13 13:00:00 | SPY | ETF | 99.37 | 99.47 | 98.95 | 99.02 | 3781100.0 |
| 2003-06-13 14:00:00 | SPY | ETF | 99.02 | 99.37 | 98.96 | 99.19 | 2622000.0 |
| 2003-06-13 15:00:00 | SPY | ETF | 99.17 | 99.62 | 99.03 | 99.43 | 4894700.0 |
| 2003-06-13 16:00:00 | SPY | ETF | 99.44 | 99.59 | 99.2 | 99.59 | 5600000.0 |
| 2003-06-13 17:00:00 | SPY | ETF | 99.52 | 99.55 | 99.38 | 99.38 | 19300.0 |
| 2003-06-13 18:00:00 | SPY | ETF | 99.43 | 99.46 | 99.4 | 99.4 | 2600.0 |
| 2003-06-13 19:00:00 | SPY | ETF | 99.4 | 99.45 | 99.32 | 99.45 | 4100.0 |
| 2003-06-13 20:00:00 | SPY | ETF | 99.46 | 99.46 | 99.46 | 99.46 | 100.0 |
| 2003-06-13 08:00:00 | QQQ | ETF | 30.61 | 30.67 | 30.6 | 30.64 | 65500.0 |
| 2003-06-13 09:00:00 | QQQ | ETF | 30.66 | 30.73 | 30.37 | 30.44 | 11163100.0 |
| 2003-06-13 10:00:00 | QQQ | ETF | 30.44 | 30.48 | 30.05 | 30.08 | 20182200.0 |
| 2003-06-13 11:00:00 | QQQ | ETF | 30.08 | 30.14 | 29.92 | 30.02 | 10263200.0 |
| 2003-06-13 12:00:00 | QQQ | ETF | 30.02 | 30.1 | 29.97 | 30.03 | 4437300.0 |
| 2003-06-13 13:00:00 | QQQ | ETF | 30.04 | 30.07 | 29.88 | 29.92 | 5205100.0 |
| 2003-06-13 14:00:00 | QQQ | ETF | 29.92 | 30.04 | 29.88 | 29.92 | 7152100.0 |
| 2003-06-13 15:00:00 | QQQ | ETF | 29.93 | 30.1 | 29.86 | 29.98 | 11653300.0 |
| 2003-06-13 16:00:00 | QQQ | ETF | 29.94 | 30.01 | 29.92 | 29.98 | 1596200.0 |
| 2003-06-13 17:00:00 | QQQ | ETF | 29.97 | 30.0 | 29.96 | 29.96 | 29900.0 |
| 2003-06-13 18:00:00 | QQQ | ETF | 29.96 | 30.01 | 29.92 | 29.97 | 37700.0 |
| 2003-06-13 19:00:00 | QQQ | ETF | 29.97 | 29.97 | 29.93 | 29.96 | 11300.0 |
| 2003-06-13 09:00:00 | IWM | ETF | 45.675 | 45.695 | 45.3 | 45.395 | 239800.0 |
| 2003-06-13 10:00:00 | IWM | ETF | 45.395 | 45.395 | 44.945 | 44.95 | 914600.0 |
| 2003-06-13 11:00:00 | IWM | ETF | 44.95 | 44.97 | 44.785 | 44.86 | 419800.0 |
| 2003-06-13 12:00:00 | IWM | ETF | 44.86 | 44.92 | 44.82 | 44.91 | 321800.0 |
| 2003-06-13 13:00:00 | IWM | ETF | 44.91 | 44.955 | 44.8 | 44.835 | 178200.0 |
| 2003-06-13 14:00:00 | IWM | ETF | 44.83 | 45.035 | 44.825 | 44.975 | 293000.0 |
| 2003-06-13 15:00:00 | IWM | ETF | 44.975 | 45.07 | 44.91 | 44.935 | 348600.0 |
| 2003-06-13 16:00:00 | IWM | ETF | 44.925 | 44.945 | 44.82 | 44.89 | 123000.0 |
| 2003-06-13 08:00:00 | DIA | ETF | 92.27 | 92.55 | 92.27 | 92.5 | 4800.0 |
| 2003-06-13 09:00:00 | DIA | ETF | 92.55 | 92.56 | 91.85 | 92.01 | 880300.0 |
| 2003-06-13 10:00:00 | DIA | ETF | 92.03 | 92.08 | 91.47 | 91.48 | 1448600.0 |
| 2003-06-13 11:00:00 | DIA | ETF | 91.5 | 91.56 | 91.21 | 91.43 | 1258100.0 |
| 2003-06-13 12:00:00 | DIA | ETF | 91.44 | 91.53 | 91.27 | 91.39 | 279300.0 |
| 2003-06-13 13:00:00 | DIA | ETF | 91.42 | 91.47 | 91.06 | 91.09 | 521900.0 |
| 2003-06-13 14:00:00 | DIA | ETF | 91.1 | 91.48 | 91.05 | 91.21 | 483800.0 |
| 2003-06-13 15:00:00 | DIA | ETF | 91.24 | 91.66 | 91.11 | 91.49 | 840700.0 |
| 2003-06-13 16:00:00 | DIA | ETF | 91.48 | 91.7 | 91.47 | 91.7 | 69600.0 |
| 2003-06-13 17:00:00 | DIA | ETF | 91.58 | 91.6 | 91.56 | 91.58 | 5800.0 |
| 2003-06-13 18:00:00 | DIA | ETF | 91.56 | 91.61 | 91.56 | 91.61 | 900.0 |
| 2003-06-13 19:00:00 | DIA | ETF | 91.54 | 91.63 | 91.54 | 91.63 | 800.0 |
| 2003-06-13 09:00:00 | TLT | ETF | 96.93 | 97.06 | 96.76 | 96.9 | 45100.0 |
| 2003-06-13 10:00:00 | TLT | ETF | 96.87 | 97.08 | 96.8 | 97.05 | 212900.0 |
| 2003-06-13 11:00:00 | TLT | ETF | 97.05 | 97.16 | 97.02 | 97.15 | 73000.0 |
| 2003-06-13 12:00:00 | TLT | ETF | 97.17 | 97.17 | 97.05 | 97.15 | 11300.0 |
| 2003-06-13 13:00:00 | TLT | ETF | 97.15 | 97.28 | 97.09 | 97.2 | 40700.0 |
> showing 50 of 436 rows — these rows as CSV