PREVIEW / etf_1hour / 2003-06-11
file: by_date/etf_1hour/2003/2003-06-11.parquet size: 17 KB rows: 424
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-11 08:00:00 | SPY | ETF | 99.0 | 99.29 | 99.0 | 99.17 | 42400.0 |
| 2003-06-11 09:00:00 | SPY | ETF | 99.19 | 99.22 | 98.71 | 99.07 | 5033000.0 |
| 2003-06-11 10:00:00 | SPY | ETF | 99.06 | 99.59 | 98.88 | 99.52 | 6600300.0 |
| 2003-06-11 11:00:00 | SPY | ETF | 99.5 | 99.64 | 99.07 | 99.22 | 3719800.0 |
| 2003-06-11 12:00:00 | SPY | ETF | 99.23 | 99.59 | 99.1 | 99.49 | 2112600.0 |
| 2003-06-11 13:00:00 | SPY | ETF | 99.5 | 99.62 | 99.26 | 99.36 | 2968000.0 |
| 2003-06-11 14:00:00 | SPY | ETF | 99.36 | 100.04 | 99.29 | 99.95 | 6818700.0 |
| 2003-06-11 15:00:00 | SPY | ETF | 99.95 | 100.38 | 99.9 | 100.33 | 6653200.0 |
| 2003-06-11 16:00:00 | SPY | ETF | 100.33 | 100.39 | 100.27 | 100.29 | 2057600.0 |
| 2003-06-11 17:00:00 | SPY | ETF | 100.29 | 100.38 | 100.29 | 100.35 | 9400.0 |
| 2003-06-11 18:00:00 | SPY | ETF | 100.36 | 100.38 | 100.32 | 100.36 | 6100.0 |
| 2003-06-11 19:00:00 | SPY | ETF | 100.36 | 100.41 | 100.36 | 100.38 | 22600.0 |
| 2003-06-11 08:00:00 | QQQ | ETF | 29.96 | 30.06 | 29.95 | 30.04 | 106300.0 |
| 2003-06-11 09:00:00 | QQQ | ETF | 30.04 | 30.09 | 29.8 | 30.06 | 11422000.0 |
| 2003-06-11 10:00:00 | QQQ | ETF | 30.02 | 30.35 | 29.95 | 30.27 | 17462900.0 |
| 2003-06-11 11:00:00 | QQQ | ETF | 30.28 | 30.34 | 29.97 | 30.01 | 10298400.0 |
| 2003-06-11 12:00:00 | QQQ | ETF | 30.02 | 30.23 | 29.98 | 30.16 | 5401200.0 |
| 2003-06-11 13:00:00 | QQQ | ETF | 30.18 | 30.22 | 30.03 | 30.09 | 4514700.0 |
| 2003-06-11 14:00:00 | QQQ | ETF | 30.09 | 30.43 | 30.05 | 30.36 | 13088600.0 |
| 2003-06-11 15:00:00 | QQQ | ETF | 30.38 | 30.64 | 30.34 | 30.53 | 16967600.0 |
| 2003-06-11 16:00:00 | QQQ | ETF | 30.52 | 30.56 | 30.49 | 30.51 | 1151000.0 |
| 2003-06-11 17:00:00 | QQQ | ETF | 30.53 | 30.56 | 30.52 | 30.53 | 74300.0 |
| 2003-06-11 18:00:00 | QQQ | ETF | 30.54 | 30.56 | 30.51 | 30.54 | 51800.0 |
| 2003-06-11 19:00:00 | QQQ | ETF | 30.53 | 30.6 | 30.53 | 30.59 | 30200.0 |
| 2003-06-11 09:00:00 | IWM | ETF | 45.0 | 45.05 | 44.64 | 44.845 | 370800.0 |
| 2003-06-11 10:00:00 | IWM | ETF | 44.845 | 45.15 | 44.805 | 45.07 | 762200.0 |
| 2003-06-11 11:00:00 | IWM | ETF | 45.09 | 45.15 | 45.0 | 45.05 | 503600.0 |
| 2003-06-11 12:00:00 | IWM | ETF | 45.055 | 45.175 | 45.04 | 45.17 | 128000.0 |
| 2003-06-11 13:00:00 | IWM | ETF | 45.175 | 45.21 | 45.125 | 45.15 | 238800.0 |
| 2003-06-11 14:00:00 | IWM | ETF | 45.15 | 45.345 | 45.11 | 45.26 | 399200.0 |
| 2003-06-11 15:00:00 | IWM | ETF | 45.285 | 45.525 | 45.255 | 45.515 | 416800.0 |
| 2003-06-11 16:00:00 | IWM | ETF | 45.525 | 45.525 | 45.45 | 45.45 | 180600.0 |
| 2003-06-11 17:00:00 | IWM | ETF | 45.455 | 45.455 | 45.455 | 45.455 | 44400.0 |
| 2003-06-11 08:00:00 | DIA | ETF | 90.88 | 91.15 | 90.88 | 91.15 | 7400.0 |
| 2003-06-11 09:00:00 | DIA | ETF | 91.07 | 91.22 | 90.74 | 91.15 | 1104200.0 |
| 2003-06-11 10:00:00 | DIA | ETF | 91.18 | 91.6 | 90.93 | 91.35 | 1658100.0 |
| 2003-06-11 11:00:00 | DIA | ETF | 91.39 | 91.51 | 91.11 | 91.22 | 667500.0 |
| 2003-06-11 12:00:00 | DIA | ETF | 91.2 | 91.5 | 91.12 | 91.41 | 241300.0 |
| 2003-06-11 13:00:00 | DIA | ETF | 91.39 | 91.54 | 91.16 | 91.27 | 583600.0 |
| 2003-06-11 14:00:00 | DIA | ETF | 91.27 | 91.83 | 91.18 | 91.79 | 1025900.0 |
| 2003-06-11 15:00:00 | DIA | ETF | 91.8 | 92.15 | 91.69 | 92.15 | 2042000.0 |
| 2003-06-11 16:00:00 | DIA | ETF | 92.15 | 92.23 | 92.09 | 92.11 | 172100.0 |
| 2003-06-11 17:00:00 | DIA | ETF | 92.15 | 92.16 | 92.1 | 92.1 | 2700.0 |
| 2003-06-11 18:00:00 | DIA | ETF | 92.15 | 92.15 | 92.15 | 92.15 | 300.0 |
| 2003-06-11 19:00:00 | DIA | ETF | 92.14 | 92.15 | 92.14 | 92.15 | 8300.0 |
| 2003-06-11 09:00:00 | TLT | ETF | 96.25 | 96.56 | 96.25 | 96.5 | 54800.0 |
| 2003-06-11 10:00:00 | TLT | ETF | 96.47 | 96.6 | 96.15 | 96.2 | 266400.0 |
| 2003-06-11 11:00:00 | TLT | ETF | 96.25 | 96.39 | 96.18 | 96.23 | 54600.0 |
| 2003-06-11 12:00:00 | TLT | ETF | 96.23 | 96.36 | 96.18 | 96.28 | 18300.0 |
| 2003-06-11 13:00:00 | TLT | ETF | 96.28 | 96.28 | 96.05 | 96.25 | 39200.0 |
> showing 50 of 424 rows — these rows as CSV