PREVIEW / etf_1hour / 2003-02-20
file: by_date/etf_1hour/2003/2003-02-20.parquet size: 15 KB rows: 359
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-02-20 08:00:00 | SPY | ETF | 85.51 | 85.66 | 85.11 | 85.17 | 67700.0 |
| 2003-02-20 09:00:00 | SPY | ETF | 85.19 | 85.42 | 84.91 | 85.03 | 3437200.0 |
| 2003-02-20 10:00:00 | SPY | ETF | 85.01 | 85.2 | 84.32 | 84.44 | 4635600.0 |
| 2003-02-20 11:00:00 | SPY | ETF | 84.43 | 84.86 | 84.38 | 84.75 | 3240200.0 |
| 2003-02-20 12:00:00 | SPY | ETF | 84.75 | 84.78 | 84.32 | 84.39 | 3176400.0 |
| 2003-02-20 13:00:00 | SPY | ETF | 84.38 | 84.48 | 84.07 | 84.27 | 3294200.0 |
| 2003-02-20 14:00:00 | SPY | ETF | 84.3 | 84.47 | 84.05 | 84.15 | 2749000.0 |
| 2003-02-20 15:00:00 | SPY | ETF | 84.14 | 84.54 | 84.06 | 84.09 | 4624400.0 |
| 2003-02-20 16:00:00 | SPY | ETF | 84.08 | 84.6 | 84.05 | 84.25 | 1241400.0 |
| 2003-02-20 17:00:00 | SPY | ETF | 84.23 | 84.28 | 84.18 | 84.2 | 8400.0 |
| 2003-02-20 18:00:00 | SPY | ETF | 84.2 | 84.32 | 84.2 | 84.3 | 9200.0 |
| 2003-02-20 19:00:00 | SPY | ETF | 84.35 | 84.35 | 84.35 | 84.35 | 700.0 |
| 2003-02-20 08:00:00 | QQQ | ETF | 25.3 | 25.34 | 25.15 | 25.17 | 157600.0 |
| 2003-02-20 09:00:00 | QQQ | ETF | 25.17 | 25.27 | 25.05 | 25.12 | 9109900.0 |
| 2003-02-20 10:00:00 | QQQ | ETF | 25.13 | 25.18 | 24.86 | 24.92 | 11843200.0 |
| 2003-02-20 11:00:00 | QQQ | ETF | 24.89 | 25.05 | 24.87 | 25.04 | 6634100.0 |
| 2003-02-20 12:00:00 | QQQ | ETF | 25.04 | 25.08 | 24.92 | 24.96 | 4532000.0 |
| 2003-02-20 13:00:00 | QQQ | ETF | 24.96 | 25.0 | 24.84 | 24.93 | 3618000.0 |
| 2003-02-20 14:00:00 | QQQ | ETF | 24.92 | 25.0 | 24.86 | 24.89 | 5447400.0 |
| 2003-02-20 15:00:00 | QQQ | ETF | 24.89 | 25.09 | 24.88 | 24.88 | 9746200.0 |
| 2003-02-20 16:00:00 | QQQ | ETF | 24.88 | 24.98 | 24.87 | 24.94 | 2564000.0 |
| 2003-02-20 17:00:00 | QQQ | ETF | 24.93 | 24.95 | 24.93 | 24.93 | 332500.0 |
| 2003-02-20 18:00:00 | QQQ | ETF | 24.94 | 24.96 | 24.91 | 24.95 | 41100.0 |
| 2003-02-20 19:00:00 | QQQ | ETF | 24.96 | 24.96 | 24.96 | 24.96 | 2000.0 |
| 2003-02-20 09:00:00 | IWM | ETF | 35.86 | 35.985 | 35.825 | 35.83 | 229000.0 |
| 2003-02-20 10:00:00 | IWM | ETF | 35.83 | 35.88 | 35.7 | 35.705 | 538000.0 |
| 2003-02-20 11:00:00 | IWM | ETF | 35.7 | 35.8 | 35.7 | 35.8 | 244000.0 |
| 2003-02-20 12:00:00 | IWM | ETF | 35.785 | 35.8 | 35.73 | 35.75 | 140200.0 |
| 2003-02-20 13:00:00 | IWM | ETF | 35.75 | 35.79 | 35.71 | 35.745 | 242800.0 |
| 2003-02-20 14:00:00 | IWM | ETF | 35.76 | 35.83 | 35.74 | 35.77 | 506000.0 |
| 2003-02-20 15:00:00 | IWM | ETF | 35.76 | 35.875 | 35.745 | 35.775 | 583800.0 |
| 2003-02-20 16:00:00 | IWM | ETF | 35.775 | 35.85 | 35.775 | 35.825 | 142600.0 |
| 2003-02-20 17:00:00 | IWM | ETF | 35.825 | 35.825 | 35.825 | 35.825 | 20000.0 |
| 2003-02-20 08:00:00 | DIA | ETF | 80.99 | 80.99 | 80.63 | 80.63 | 7400.0 |
| 2003-02-20 09:00:00 | DIA | ETF | 80.6 | 80.72 | 80.15 | 80.23 | 566800.0 |
| 2003-02-20 10:00:00 | DIA | ETF | 80.24 | 80.37 | 79.5 | 79.67 | 897500.0 |
| 2003-02-20 11:00:00 | DIA | ETF | 79.69 | 79.98 | 79.63 | 79.88 | 661700.0 |
| 2003-02-20 12:00:00 | DIA | ETF | 79.88 | 79.94 | 79.52 | 79.56 | 660500.0 |
| 2003-02-20 13:00:00 | DIA | ETF | 79.53 | 79.6 | 79.25 | 79.51 | 556800.0 |
| 2003-02-20 14:00:00 | DIA | ETF | 79.47 | 79.63 | 79.3 | 79.35 | 331600.0 |
| 2003-02-20 15:00:00 | DIA | ETF | 79.35 | 79.79 | 79.32 | 79.44 | 762200.0 |
| 2003-02-20 16:00:00 | DIA | ETF | 79.44 | 79.64 | 79.4 | 79.6 | 142100.0 |
| 2003-02-20 17:00:00 | DIA | ETF | 79.59 | 79.59 | 79.59 | 79.59 | 800.0 |
| 2003-02-20 19:00:00 | DIA | ETF | 79.59 | 79.59 | 79.59 | 79.59 | 300.0 |
| 2003-02-20 09:00:00 | TLT | ETF | 88.34 | 88.61 | 88.34 | 88.51 | 209800.0 |
| 2003-02-20 10:00:00 | TLT | ETF | 88.59 | 88.75 | 88.59 | 88.66 | 32100.0 |
| 2003-02-20 11:00:00 | TLT | ETF | 88.6 | 88.64 | 88.6 | 88.64 | 12400.0 |
| 2003-02-20 12:00:00 | TLT | ETF | 88.7 | 88.73 | 88.61 | 88.73 | 15000.0 |
| 2003-02-20 13:00:00 | TLT | ETF | 88.75 | 88.88 | 88.74 | 88.88 | 80600.0 |
| 2003-02-20 14:00:00 | TLT | ETF | 88.9 | 88.9 | 88.82 | 88.85 | 21100.0 |
> showing 50 of 359 rows — these rows as CSV