PREVIEW / etf_1hour / 2004-06-10
file: by_date/etf_1hour/2004/2004-06-10.parquet size: 24 KB rows: 672
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 |
|---|---|---|---|---|---|---|---|
| 2004-06-10 08:00:00 | SPY | ETF | 114.14 | 114.15 | 113.96 | 114.1 | 446900.0 |
| 2004-06-10 09:00:00 | SPY | ETF | 114.12 | 114.15 | 113.95 | 114.08 | 2491000.0 |
| 2004-06-10 10:00:00 | SPY | ETF | 114.09 | 114.3 | 114.07 | 114.08 | 6067600.0 |
| 2004-06-10 11:00:00 | SPY | ETF | 114.08 | 114.25 | 113.93 | 114.14 | 2537600.0 |
| 2004-06-10 12:00:00 | SPY | ETF | 114.09 | 114.19 | 114.04 | 114.09 | 1671700.0 |
| 2004-06-10 13:00:00 | SPY | ETF | 114.1 | 114.19 | 113.97 | 114.09 | 1508900.0 |
| 2004-06-10 14:00:00 | SPY | ETF | 114.11 | 114.2 | 114.03 | 114.16 | 1599300.0 |
| 2004-06-10 15:00:00 | SPY | ETF | 114.14 | 114.32 | 114.0 | 114.3 | 3307000.0 |
| 2004-06-10 16:00:00 | SPY | ETF | 114.3 | 114.42 | 114.15 | 114.32 | 1273300.0 |
| 2004-06-10 17:00:00 | SPY | ETF | 114.32 | 114.39 | 114.28 | 114.28 | 8800.0 |
| 2004-06-10 18:00:00 | SPY | ETF | 114.32 | 114.34 | 114.28 | 114.28 | 3300.0 |
| 2004-06-10 19:00:00 | SPY | ETF | 114.28 | 114.28 | 114.28 | 114.28 | 300.0 |
| 2004-06-10 08:00:00 | QQQ | ETF | 36.73 | 36.78 | 36.64 | 36.78 | 456500.0 |
| 2004-06-10 09:00:00 | QQQ | ETF | 36.77 | 36.79 | 36.65 | 36.69 | 9589000.0 |
| 2004-06-10 10:00:00 | QQQ | ETF | 36.7 | 36.82 | 36.69 | 36.71 | 10228800.0 |
| 2004-06-10 11:00:00 | QQQ | ETF | 36.709 | 36.77 | 36.55 | 36.69 | 10722700.0 |
| 2004-06-10 12:00:00 | QQQ | ETF | 36.69 | 36.7 | 36.63 | 36.641 | 3578700.0 |
| 2004-06-10 13:00:00 | QQQ | ETF | 36.64 | 36.7 | 36.61 | 36.68 | 3155900.0 |
| 2004-06-10 14:00:00 | QQQ | ETF | 36.678 | 36.76 | 36.64 | 36.72 | 4512600.0 |
| 2004-06-10 15:00:00 | QQQ | ETF | 36.71 | 36.81 | 36.67 | 36.8 | 8654200.0 |
| 2004-06-10 16:00:00 | QQQ | ETF | 36.79 | 36.859 | 36.765 | 36.84 | 1768600.0 |
| 2004-06-10 17:00:00 | QQQ | ETF | 36.837 | 36.85 | 36.82 | 36.82 | 68500.0 |
| 2004-06-10 18:00:00 | QQQ | ETF | 36.84 | 36.84 | 36.82 | 36.82 | 26500.0 |
| 2004-06-10 19:00:00 | QQQ | ETF | 36.82 | 36.83 | 36.82 | 36.83 | 2000.0 |
| 2004-06-10 09:00:00 | IWM | ETF | 56.85 | 57.075 | 56.82 | 56.91 | 854800.0 |
| 2004-06-10 10:00:00 | IWM | ETF | 56.91 | 57.04 | 56.68 | 56.755 | 1080400.0 |
| 2004-06-10 11:00:00 | IWM | ETF | 56.74 | 56.855 | 56.585 | 56.71 | 2398800.0 |
| 2004-06-10 12:00:00 | IWM | ETF | 56.705 | 56.725 | 56.6 | 56.605 | 625000.0 |
| 2004-06-10 13:00:00 | IWM | ETF | 56.615 | 56.71 | 56.54 | 56.695 | 890800.0 |
| 2004-06-10 14:00:00 | IWM | ETF | 56.7 | 56.75 | 56.645 | 56.695 | 1332200.0 |
| 2004-06-10 15:00:00 | IWM | ETF | 56.69 | 56.825 | 56.54 | 56.74 | 1440800.0 |
| 2004-06-10 16:00:00 | IWM | ETF | 56.735 | 56.85 | 56.705 | 56.825 | 382200.0 |
| 2004-06-10 08:00:00 | DIA | ETF | 104.18 | 104.2 | 104.1 | 104.15 | 4700.0 |
| 2004-06-10 09:00:00 | DIA | ETF | 104.11 | 104.11 | 103.94 | 104.08 | 317400.0 |
| 2004-06-10 10:00:00 | DIA | ETF | 104.05 | 104.25 | 104.04 | 104.06 | 855400.0 |
| 2004-06-10 11:00:00 | DIA | ETF | 104.08 | 104.15 | 103.95 | 104.08 | 626600.0 |
| 2004-06-10 12:00:00 | DIA | ETF | 104.08 | 104.1 | 104.0 | 104.04 | 103700.0 |
| 2004-06-10 13:00:00 | DIA | ETF | 104.06 | 104.14 | 103.94 | 104.06 | 136800.0 |
| 2004-06-10 14:00:00 | DIA | ETF | 104.05 | 104.11 | 103.96 | 104.06 | 107400.0 |
| 2004-06-10 15:00:00 | DIA | ETF | 104.06 | 104.24 | 103.96 | 104.23 | 464000.0 |
| 2004-06-10 16:00:00 | DIA | ETF | 104.24 | 104.31 | 104.17 | 104.31 | 262400.0 |
| 2004-06-10 18:00:00 | DIA | ETF | 104.33 | 104.34 | 104.33 | 104.34 | 200.0 |
| 2004-06-10 09:00:00 | TLT | ETF | 81.36 | 81.41 | 81.26 | 81.28 | 6400.0 |
| 2004-06-10 10:00:00 | TLT | ETF | 81.31 | 81.35 | 81.25 | 81.31 | 24300.0 |
| 2004-06-10 11:00:00 | TLT | ETF | 81.3 | 81.32 | 81.18 | 81.23 | 26100.0 |
| 2004-06-10 12:00:00 | TLT | ETF | 81.28 | 81.28 | 81.15 | 81.2 | 4800.0 |
| 2004-06-10 13:00:00 | TLT | ETF | 81.18 | 81.41 | 81.18 | 81.41 | 25500.0 |
| 2004-06-10 14:00:00 | TLT | ETF | 81.37 | 81.56 | 81.34 | 81.56 | 182200.0 |
| 2004-06-10 15:00:00 | TLT | ETF | 81.51 | 81.6 | 81.5 | 81.5 | 62300.0 |
| 2004-06-10 16:00:00 | TLT | ETF | 81.56 | 81.56 | 81.48 | 81.52 | 4600.0 |
> showing 50 of 672 rows — these rows as CSV