PREVIEW / etf_1hour / 2006-11-24
file: by_date/etf_1hour/2006/2006-11-24.parquet size: 38 KB rows: 1,103
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 |
|---|---|---|---|---|---|---|---|
| 2006-11-24 07:00:00 | SPY | ETF | 140.34 | 140.39 | 140.25 | 140.25 | 185800.0 |
| 2006-11-24 08:00:00 | SPY | ETF | 140.25 | 140.4 | 140.1 | 140.18 | 1460500.0 |
| 2006-11-24 09:00:00 | SPY | ETF | 140.19 | 140.4 | 140.17 | 140.38 | 6020700.0 |
| 2006-11-24 10:00:00 | SPY | ETF | 140.37 | 140.8 | 140.36 | 140.74 | 7264300.0 |
| 2006-11-24 11:00:00 | SPY | ETF | 140.74 | 140.84 | 140.53 | 140.64 | 4571600.0 |
| 2006-11-24 12:00:00 | SPY | ETF | 140.63 | 140.75 | 140.44 | 140.46 | 4103700.0 |
| 2006-11-24 13:00:00 | SPY | ETF | 140.45 | 140.55 | 140.35 | 140.35 | 738300.0 |
| 2006-11-24 09:00:00 | QQQ | ETF | 44.39 | 44.54 | 44.38 | 44.53 | 9206900.0 |
| 2006-11-24 10:00:00 | QQQ | ETF | 44.53 | 44.78 | 44.52 | 44.75 | 13329400.0 |
| 2006-11-24 11:00:00 | QQQ | ETF | 44.75 | 44.86 | 44.68 | 44.71 | 9694000.0 |
| 2006-11-24 12:00:00 | QQQ | ETF | 44.71 | 44.75 | 44.63 | 44.65 | 10624300.0 |
| 2006-11-24 08:00:00 | IWM | ETF | 78.5 | 78.58 | 78.3 | 78.36 | 873600.0 |
| 2006-11-24 09:00:00 | IWM | ETF | 78.38 | 78.65 | 78.23 | 78.34 | 3840400.0 |
| 2006-11-24 10:00:00 | IWM | ETF | 78.33 | 79.0 | 78.33 | 78.97 | 4942100.0 |
| 2006-11-24 11:00:00 | IWM | ETF | 78.97 | 79.03 | 78.84 | 78.89 | 4534400.0 |
| 2006-11-24 12:00:00 | IWM | ETF | 78.89 | 78.98 | 78.75 | 78.8 | 2966700.0 |
| 2006-11-24 13:00:00 | IWM | ETF | 78.79 | 78.79 | 78.51 | 78.56 | 547800.0 |
| 2006-11-24 07:00:00 | DIA | ETF | 122.81 | 122.81 | 122.79 | 122.79 | 600.0 |
| 2006-11-24 08:00:00 | DIA | ETF | 122.75 | 122.81 | 122.64 | 122.67 | 31100.0 |
| 2006-11-24 09:00:00 | DIA | ETF | 122.66 | 122.74 | 122.53 | 122.63 | 592400.0 |
| 2006-11-24 10:00:00 | DIA | ETF | 122.6388 | 123.09 | 122.6388 | 123.0 | 757400.0 |
| 2006-11-24 11:00:00 | DIA | ETF | 123.0 | 123.1 | 122.79 | 122.88 | 306400.0 |
| 2006-11-24 12:00:00 | DIA | ETF | 122.87 | 122.97 | 122.81 | 122.82 | 260700.0 |
| 2006-11-24 13:00:00 | DIA | ETF | 122.81 | 122.84 | 122.68 | 122.68 | 18200.0 |
| 2006-11-24 07:00:00 | GLD | ETF | 63.33 | 63.33 | 63.3 | 63.3 | 54900.0 |
| 2006-11-24 08:00:00 | GLD | ETF | 63.32 | 63.53 | 63.25 | 63.29 | 251000.0 |
| 2006-11-24 09:00:00 | GLD | ETF | 63.28 | 63.68 | 63.28 | 63.6001 | 3975000.0 |
| 2006-11-24 10:00:00 | GLD | ETF | 63.6 | 63.61 | 63.31 | 63.4312 | 1625500.0 |
| 2006-11-24 11:00:00 | GLD | ETF | 63.44 | 63.52 | 63.4 | 63.5 | 582200.0 |
| 2006-11-24 12:00:00 | GLD | ETF | 63.48 | 63.54 | 63.41 | 63.45 | 380900.0 |
| 2006-11-24 13:00:00 | GLD | ETF | 63.455 | 63.5 | 63.42 | 63.5 | 12100.0 |
| 2006-11-24 08:00:00 | TLT | ETF | 90.65 | 90.68 | 90.65 | 90.68 | 7200.0 |
| 2006-11-24 09:00:00 | TLT | ETF | 90.66 | 90.8 | 90.65 | 90.74 | 209500.0 |
| 2006-11-24 10:00:00 | TLT | ETF | 90.73 | 90.9 | 90.72 | 90.84 | 187800.0 |
| 2006-11-24 11:00:00 | TLT | ETF | 90.87 | 90.88 | 90.76 | 90.79 | 39900.0 |
| 2006-11-24 12:00:00 | TLT | ETF | 90.8 | 90.8 | 90.65 | 90.65 | 73300.0 |
| 2006-11-24 13:00:00 | TLT | ETF | 90.69 | 90.69 | 90.62 | 90.62 | 15500.0 |
> showing 37 of 1,103 rows — these rows as CSV