PREVIEW / etf_1hour / 2003-05-13
file: by_date/etf_1hour/2003/2003-05-13.parquet size: 17 KB rows: 411
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-13 08:00:00 | SPY | ETF | 94.44 | 94.58 | 94.37 | 94.45 | 64100.0 |
| 2003-05-13 09:00:00 | SPY | ETF | 94.46 | 94.72 | 94.33 | 94.55 | 4429000.0 |
| 2003-05-13 10:00:00 | SPY | ETF | 94.55 | 94.81 | 94.3 | 94.7 | 5785700.0 |
| 2003-05-13 11:00:00 | SPY | ETF | 94.7 | 94.87 | 94.53 | 94.86 | 3152800.0 |
| 2003-05-13 12:00:00 | SPY | ETF | 94.87 | 95.1 | 94.7 | 95.07 | 6167000.0 |
| 2003-05-13 13:00:00 | SPY | ETF | 95.08 | 95.18 | 94.57 | 94.6 | 4061100.0 |
| 2003-05-13 14:00:00 | SPY | ETF | 94.61 | 94.67 | 94.26 | 94.53 | 5617200.0 |
| 2003-05-13 15:00:00 | SPY | ETF | 94.55 | 94.69 | 94.37 | 94.64 | 3802500.0 |
| 2003-05-13 16:00:00 | SPY | ETF | 94.63 | 94.81 | 94.57 | 94.66 | 2541400.0 |
| 2003-05-13 17:00:00 | SPY | ETF | 94.66 | 94.71 | 94.58 | 94.68 | 106000.0 |
| 2003-05-13 18:00:00 | SPY | ETF | 94.67 | 94.7 | 94.66 | 94.7 | 7500.0 |
| 2003-05-13 19:00:00 | SPY | ETF | 94.7 | 94.7 | 94.66 | 94.66 | 2000.0 |
| 2003-05-13 08:00:00 | QQQ | ETF | 28.6 | 28.63 | 28.56 | 28.6 | 107200.0 |
| 2003-05-13 09:00:00 | QQQ | ETF | 28.59 | 28.76 | 28.55 | 28.66 | 9174100.0 |
| 2003-05-13 10:00:00 | QQQ | ETF | 28.65 | 28.76 | 28.54 | 28.72 | 10946500.0 |
| 2003-05-13 11:00:00 | QQQ | ETF | 28.73 | 28.85 | 28.65 | 28.83 | 6306100.0 |
| 2003-05-13 12:00:00 | QQQ | ETF | 28.84 | 28.95 | 28.79 | 28.93 | 6826700.0 |
| 2003-05-13 13:00:00 | QQQ | ETF | 28.93 | 28.99 | 28.71 | 28.73 | 8558000.0 |
| 2003-05-13 14:00:00 | QQQ | ETF | 28.73 | 28.77 | 28.61 | 28.74 | 7468000.0 |
| 2003-05-13 15:00:00 | QQQ | ETF | 28.74 | 28.79 | 28.63 | 28.72 | 6384300.0 |
| 2003-05-13 16:00:00 | QQQ | ETF | 28.73 | 28.76 | 28.62 | 28.63 | 3524000.0 |
| 2003-05-13 17:00:00 | QQQ | ETF | 28.63 | 28.63 | 28.56 | 28.62 | 1290800.0 |
| 2003-05-13 18:00:00 | QQQ | ETF | 28.6 | 28.63 | 28.58 | 28.62 | 55300.0 |
| 2003-05-13 19:00:00 | QQQ | ETF | 28.61 | 28.64 | 28.61 | 28.62 | 17000.0 |
| 2003-05-13 09:00:00 | IWM | ETF | 41.685 | 41.685 | 41.375 | 41.55 | 484000.0 |
| 2003-05-13 10:00:00 | IWM | ETF | 41.555 | 41.63 | 41.47 | 41.59 | 220000.0 |
| 2003-05-13 11:00:00 | IWM | ETF | 41.59 | 41.71 | 41.57 | 41.71 | 179400.0 |
| 2003-05-13 12:00:00 | IWM | ETF | 41.72 | 41.935 | 41.705 | 41.905 | 113800.0 |
| 2003-05-13 13:00:00 | IWM | ETF | 41.92 | 41.99 | 41.8 | 41.81 | 626000.0 |
| 2003-05-13 14:00:00 | IWM | ETF | 41.795 | 41.835 | 41.715 | 41.8 | 491400.0 |
| 2003-05-13 15:00:00 | IWM | ETF | 41.8 | 41.855 | 41.755 | 41.845 | 406200.0 |
| 2003-05-13 16:00:00 | IWM | ETF | 41.845 | 41.925 | 41.805 | 41.805 | 118200.0 |
| 2003-05-13 08:00:00 | DIA | ETF | 86.92 | 87.1 | 86.9 | 87.04 | 4000.0 |
| 2003-05-13 09:00:00 | DIA | ETF | 87.01 | 87.18 | 86.85 | 86.98 | 956400.0 |
| 2003-05-13 10:00:00 | DIA | ETF | 86.99 | 87.19 | 86.67 | 87.05 | 1439500.0 |
| 2003-05-13 11:00:00 | DIA | ETF | 87.05 | 87.15 | 86.84 | 87.13 | 676500.0 |
| 2003-05-13 12:00:00 | DIA | ETF | 87.15 | 87.31 | 87.0 | 87.28 | 705800.0 |
| 2003-05-13 13:00:00 | DIA | ETF | 87.3 | 87.39 | 86.89 | 86.89 | 786400.0 |
| 2003-05-13 14:00:00 | DIA | ETF | 86.89 | 87.03 | 86.61 | 86.83 | 870000.0 |
| 2003-05-13 15:00:00 | DIA | ETF | 86.84 | 87.0 | 86.73 | 86.9 | 826600.0 |
| 2003-05-13 16:00:00 | DIA | ETF | 86.94 | 87.06 | 86.9 | 87.03 | 178600.0 |
| 2003-05-13 17:00:00 | DIA | ETF | 86.91 | 87.01 | 86.91 | 86.93 | 4100.0 |
| 2003-05-13 18:00:00 | DIA | ETF | 87.04 | 87.06 | 87.04 | 87.06 | 2000.0 |
| 2003-05-13 19:00:00 | DIA | ETF | 87.1 | 87.1 | 87.06 | 87.06 | 1100.0 |
| 2003-05-13 09:00:00 | TLT | ETF | 90.9 | 90.98 | 90.83 | 90.98 | 12300.0 |
| 2003-05-13 10:00:00 | TLT | ETF | 90.97 | 91.18 | 90.95 | 91.12 | 55200.0 |
| 2003-05-13 11:00:00 | TLT | ETF | 91.17 | 91.34 | 91.17 | 91.26 | 47300.0 |
| 2003-05-13 12:00:00 | TLT | ETF | 91.26 | 91.37 | 91.2 | 91.37 | 54100.0 |
| 2003-05-13 13:00:00 | TLT | ETF | 91.3 | 91.35 | 91.26 | 91.34 | 26700.0 |
| 2003-05-13 14:00:00 | TLT | ETF | 91.35 | 91.35 | 91.13 | 91.25 | 3500.0 |
> showing 50 of 411 rows — these rows as CSV