PREVIEW / etf_1hour / 2003-05-16
file: by_date/etf_1hour/2003/2003-05-16.parquet size: 16 KB rows: 393
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-16 08:00:00 | SPY | ETF | 95.0 | 95.08 | 94.73 | 94.74 | 99900.0 |
| 2003-05-16 09:00:00 | SPY | ETF | 94.75 | 95.43 | 94.75 | 94.97 | 7924300.0 |
| 2003-05-16 10:00:00 | SPY | ETF | 94.95 | 95.0 | 94.26 | 94.57 | 7510600.0 |
| 2003-05-16 11:00:00 | SPY | ETF | 94.57 | 94.69 | 94.45 | 94.5 | 2122200.0 |
| 2003-05-16 12:00:00 | SPY | ETF | 94.52 | 94.94 | 94.45 | 94.86 | 1855000.0 |
| 2003-05-16 13:00:00 | SPY | ETF | 94.84 | 95.15 | 94.7 | 95.09 | 2671800.0 |
| 2003-05-16 14:00:00 | SPY | ETF | 95.1 | 95.3 | 95.01 | 95.17 | 3932100.0 |
| 2003-05-16 15:00:00 | SPY | ETF | 95.17 | 95.24 | 94.82 | 94.86 | 2928300.0 |
| 2003-05-16 16:00:00 | SPY | ETF | 94.86 | 94.94 | 93.8 | 94.9 | 3115500.0 |
| 2003-05-16 17:00:00 | SPY | ETF | 94.87 | 94.93 | 94.87 | 94.93 | 25100.0 |
| 2003-05-16 18:00:00 | SPY | ETF | 94.9 | 94.9 | 94.9 | 94.9 | 800.0 |
| 2003-05-16 19:00:00 | SPY | ETF | 94.9 | 94.9 | 94.86 | 94.86 | 7600.0 |
| 2003-05-16 08:00:00 | QQQ | ETF | 28.82 | 28.82 | 28.69 | 28.72 | 72100.0 |
| 2003-05-16 09:00:00 | QQQ | ETF | 28.73 | 28.94 | 28.64 | 28.69 | 11916800.0 |
| 2003-05-16 10:00:00 | QQQ | ETF | 28.69 | 28.76 | 28.48 | 28.61 | 13704000.0 |
| 2003-05-16 11:00:00 | QQQ | ETF | 28.61 | 28.69 | 28.52 | 28.57 | 3969100.0 |
| 2003-05-16 12:00:00 | QQQ | ETF | 28.55 | 28.73 | 28.52 | 28.68 | 4645000.0 |
| 2003-05-16 13:00:00 | QQQ | ETF | 28.68 | 28.78 | 28.61 | 28.76 | 3149300.0 |
| 2003-05-16 14:00:00 | QQQ | ETF | 28.77 | 28.85 | 28.72 | 28.78 | 12794700.0 |
| 2003-05-16 15:00:00 | QQQ | ETF | 28.78 | 28.82 | 28.63 | 28.66 | 8236400.0 |
| 2003-05-16 16:00:00 | QQQ | ETF | 28.66 | 28.75 | 28.65 | 28.69 | 3174100.0 |
| 2003-05-16 17:00:00 | QQQ | ETF | 28.69 | 28.71 | 28.64 | 28.67 | 89800.0 |
| 2003-05-16 18:00:00 | QQQ | ETF | 28.67 | 28.75 | 28.67 | 28.69 | 40800.0 |
| 2003-05-16 19:00:00 | QQQ | ETF | 28.72 | 28.74 | 28.7 | 28.71 | 10300.0 |
| 2003-05-16 09:00:00 | IWM | ETF | 42.055 | 42.09 | 41.91 | 42.025 | 544600.0 |
| 2003-05-16 10:00:00 | IWM | ETF | 42.005 | 42.005 | 41.765 | 41.84 | 1102200.0 |
| 2003-05-16 11:00:00 | IWM | ETF | 41.865 | 41.885 | 41.83 | 41.86 | 107800.0 |
| 2003-05-16 12:00:00 | IWM | ETF | 41.865 | 41.92 | 41.83 | 41.915 | 48400.0 |
| 2003-05-16 13:00:00 | IWM | ETF | 41.9 | 41.925 | 41.82 | 41.895 | 167000.0 |
| 2003-05-16 14:00:00 | IWM | ETF | 41.895 | 41.975 | 41.85 | 41.89 | 130600.0 |
| 2003-05-16 15:00:00 | IWM | ETF | 41.88 | 41.91 | 41.6 | 41.635 | 853000.0 |
| 2003-05-16 16:00:00 | IWM | ETF | 41.61 | 41.635 | 41.525 | 41.535 | 96600.0 |
| 2003-05-16 08:00:00 | DIA | ETF | 87.35 | 87.35 | 86.92 | 86.95 | 30600.0 |
| 2003-05-16 09:00:00 | DIA | ETF | 86.99 | 87.56 | 86.99 | 87.14 | 1262100.0 |
| 2003-05-16 10:00:00 | DIA | ETF | 87.12 | 87.16 | 86.53 | 86.82 | 1326800.0 |
| 2003-05-16 11:00:00 | DIA | ETF | 86.82 | 86.93 | 86.7 | 86.74 | 361300.0 |
| 2003-05-16 12:00:00 | DIA | ETF | 86.73 | 87.04 | 86.68 | 87.0 | 494100.0 |
| 2003-05-16 13:00:00 | DIA | ETF | 87.0 | 87.19 | 86.84 | 87.18 | 393800.0 |
| 2003-05-16 14:00:00 | DIA | ETF | 87.17 | 87.39 | 87.08 | 87.22 | 584600.0 |
| 2003-05-16 15:00:00 | DIA | ETF | 87.22 | 87.3 | 86.9 | 86.98 | 740900.0 |
| 2003-05-16 16:00:00 | DIA | ETF | 86.96 | 87.05 | 86.85 | 86.99 | 747700.0 |
| 2003-05-16 17:00:00 | DIA | ETF | 86.92 | 87.0 | 86.92 | 86.99 | 500.0 |
| 2003-05-16 18:00:00 | DIA | ETF | 86.99 | 87.1 | 86.99 | 87.1 | 1100.0 |
| 2003-05-16 09:00:00 | TLT | ETF | 93.48 | 93.6 | 93.16 | 93.41 | 125100.0 |
| 2003-05-16 10:00:00 | TLT | ETF | 93.46 | 93.76 | 93.41 | 93.5 | 154900.0 |
| 2003-05-16 11:00:00 | TLT | ETF | 93.5 | 93.5 | 93.32 | 93.32 | 36200.0 |
| 2003-05-16 12:00:00 | TLT | ETF | 93.32 | 93.4 | 92.95 | 92.95 | 74400.0 |
| 2003-05-16 13:00:00 | TLT | ETF | 93.03 | 93.38 | 92.98 | 93.35 | 15000.0 |
| 2003-05-16 14:00:00 | TLT | ETF | 93.3 | 93.68 | 93.29 | 93.6 | 50800.0 |
| 2003-05-16 15:00:00 | TLT | ETF | 93.59 | 93.66 | 93.48 | 93.61 | 148700.0 |
> showing 50 of 393 rows — these rows as CSV