PREVIEW / etf_1hour / 2003-03-19
file: by_date/etf_1hour/2003/2003-03-19.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-03-19 08:00:00 | SPY | ETF | 87.8 | 87.98 | 87.62 | 87.62 | 207300.0 |
| 2003-03-19 09:00:00 | SPY | ETF | 87.5 | 87.7 | 87.14 | 87.29 | 5443100.0 |
| 2003-03-19 10:00:00 | SPY | ETF | 87.34 | 87.65 | 87.15 | 87.31 | 5403200.0 |
| 2003-03-19 11:00:00 | SPY | ETF | 87.3 | 87.33 | 86.68 | 86.73 | 6873400.0 |
| 2003-03-19 12:00:00 | SPY | ETF | 86.72 | 87.47 | 86.7 | 87.32 | 6285500.0 |
| 2003-03-19 13:00:00 | SPY | ETF | 87.34 | 87.51 | 87.07 | 87.32 | 3976200.0 |
| 2003-03-19 14:00:00 | SPY | ETF | 87.34 | 87.89 | 86.92 | 87.73 | 7441200.0 |
| 2003-03-19 15:00:00 | SPY | ETF | 87.75 | 88.16 | 87.39 | 87.95 | 8160600.0 |
| 2003-03-19 16:00:00 | SPY | ETF | 88.01 | 88.01 | 87.81 | 88.0 | 2755100.0 |
| 2003-03-19 17:00:00 | SPY | ETF | 87.98 | 88.18 | 87.94 | 88.17 | 75900.0 |
| 2003-03-19 18:00:00 | SPY | ETF | 88.15 | 88.22 | 88.08 | 88.22 | 22500.0 |
| 2003-03-19 19:00:00 | SPY | ETF | 88.19 | 88.3 | 88.17 | 88.25 | 8400.0 |
| 2003-03-19 20:00:00 | SPY | ETF | 88.25 | 88.25 | 88.25 | 88.25 | 100.0 |
| 2003-03-19 08:00:00 | QQQ | ETF | 27.1 | 27.15 | 26.97 | 26.97 | 177500.0 |
| 2003-03-19 09:00:00 | QQQ | ETF | 26.95 | 26.98 | 26.61 | 26.69 | 12261500.0 |
| 2003-03-19 10:00:00 | QQQ | ETF | 26.66 | 26.77 | 26.56 | 26.57 | 12912200.0 |
| 2003-03-19 11:00:00 | QQQ | ETF | 26.57 | 26.62 | 26.33 | 26.37 | 12236000.0 |
| 2003-03-19 12:00:00 | QQQ | ETF | 26.36 | 26.65 | 26.34 | 26.59 | 11694800.0 |
| 2003-03-19 13:00:00 | QQQ | ETF | 26.6 | 26.65 | 26.46 | 26.55 | 6567500.0 |
| 2003-03-19 14:00:00 | QQQ | ETF | 26.56 | 26.78 | 26.43 | 26.71 | 9478600.0 |
| 2003-03-19 15:00:00 | QQQ | ETF | 26.71 | 26.88 | 26.53 | 26.7 | 15202400.0 |
| 2003-03-19 16:00:00 | QQQ | ETF | 26.71 | 26.74 | 26.63 | 26.64 | 5875300.0 |
| 2003-03-19 17:00:00 | QQQ | ETF | 26.65 | 26.73 | 26.65 | 26.73 | 106200.0 |
| 2003-03-19 18:00:00 | QQQ | ETF | 26.74 | 26.81 | 26.68 | 26.79 | 80100.0 |
| 2003-03-19 19:00:00 | QQQ | ETF | 26.8 | 26.85 | 26.77 | 26.78 | 62300.0 |
| 2003-03-19 09:00:00 | IWM | ETF | 36.725 | 36.725 | 36.44 | 36.48 | 182200.0 |
| 2003-03-19 10:00:00 | IWM | ETF | 36.505 | 36.625 | 36.48 | 36.575 | 898200.0 |
| 2003-03-19 11:00:00 | IWM | ETF | 36.53 | 36.535 | 36.31 | 36.31 | 401400.0 |
| 2003-03-19 12:00:00 | IWM | ETF | 36.31 | 36.475 | 36.3 | 36.475 | 333800.0 |
| 2003-03-19 13:00:00 | IWM | ETF | 36.455 | 36.515 | 36.45 | 36.475 | 332400.0 |
| 2003-03-19 14:00:00 | IWM | ETF | 36.475 | 36.65 | 36.425 | 36.6 | 455000.0 |
| 2003-03-19 15:00:00 | IWM | ETF | 36.61 | 36.73 | 36.485 | 36.685 | 786400.0 |
| 2003-03-19 16:00:00 | IWM | ETF | 36.675 | 36.69 | 36.61 | 36.63 | 116800.0 |
| 2003-03-19 08:00:00 | DIA | ETF | 82.55 | 82.93 | 82.5 | 82.6 | 36900.0 |
| 2003-03-19 09:00:00 | DIA | ETF | 82.53 | 82.54 | 82.05 | 82.25 | 1472300.0 |
| 2003-03-19 10:00:00 | DIA | ETF | 82.28 | 82.5 | 82.13 | 82.16 | 940400.0 |
| 2003-03-19 11:00:00 | DIA | ETF | 82.15 | 82.19 | 81.6 | 81.67 | 1407900.0 |
| 2003-03-19 12:00:00 | DIA | ETF | 81.68 | 82.27 | 81.65 | 82.16 | 759100.0 |
| 2003-03-19 13:00:00 | DIA | ETF | 82.17 | 82.35 | 82.01 | 82.22 | 582100.0 |
| 2003-03-19 14:00:00 | DIA | ETF | 82.2 | 82.74 | 81.9 | 82.64 | 1717400.0 |
| 2003-03-19 15:00:00 | DIA | ETF | 82.64 | 83.0 | 82.27 | 82.89 | 1804200.0 |
| 2003-03-19 16:00:00 | DIA | ETF | 82.92 | 82.95 | 82.78 | 82.95 | 210800.0 |
| 2003-03-19 17:00:00 | DIA | ETF | 83.0 | 83.0 | 82.83 | 83.0 | 14800.0 |
| 2003-03-19 18:00:00 | DIA | ETF | 83.15 | 83.15 | 83.0 | 83.06 | 2200.0 |
| 2003-03-19 19:00:00 | DIA | ETF | 83.08 | 83.08 | 82.95 | 82.95 | 2400.0 |
| 2003-03-19 09:00:00 | TLT | ETF | 88.04 | 88.07 | 87.76 | 88.01 | 124800.0 |
| 2003-03-19 10:00:00 | TLT | ETF | 88.0 | 88.0 | 87.68 | 87.75 | 44400.0 |
| 2003-03-19 11:00:00 | TLT | ETF | 87.77 | 87.93 | 87.66 | 87.92 | 58400.0 |
| 2003-03-19 12:00:00 | TLT | ETF | 87.92 | 87.93 | 87.65 | 87.65 | 7400.0 |
| 2003-03-19 13:00:00 | TLT | ETF | 87.55 | 87.55 | 87.36 | 87.51 | 59400.0 |
> showing 50 of 386 rows — these rows as CSV