PREVIEW / etf_1hour / 2006-10-18
file: by_date/etf_1hour/2006/2006-10-18.parquet size: 55 KB rows: 1,727
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-10-18 07:00:00 | SPY | ETF | 136.59 | 136.64 | 136.52 | 136.64 | 138800.0 |
| 2006-10-18 08:00:00 | SPY | ETF | 136.6 | 137.07 | 136.52 | 137.05 | 7633000.0 |
| 2006-10-18 09:00:00 | SPY | ETF | 137.05 | 137.37 | 137.02 | 137.06 | 12309400.0 |
| 2006-10-18 10:00:00 | SPY | ETF | 137.04 | 137.09 | 136.33 | 136.61 | 23581600.0 |
| 2006-10-18 11:00:00 | SPY | ETF | 136.61 | 136.91 | 136.47 | 136.73 | 9453800.0 |
| 2006-10-18 12:00:00 | SPY | ETF | 136.72 | 136.78 | 136.56 | 136.61 | 4165100.0 |
| 2006-10-18 13:00:00 | SPY | ETF | 136.59 | 136.66 | 136.1 | 136.33 | 11176200.0 |
| 2006-10-18 14:00:00 | SPY | ETF | 136.33 | 136.7 | 136.2 | 136.63 | 8067500.0 |
| 2006-10-18 15:00:00 | SPY | ETF | 136.62 | 136.66 | 136.4 | 136.59 | 7893000.0 |
| 2006-10-18 16:00:00 | SPY | ETF | 136.59 | 136.72 | 136.47 | 136.56 | 1148100.0 |
| 2006-10-18 17:00:00 | SPY | ETF | 136.57 | 136.58 | 136.43 | 136.43 | 166800.0 |
| 2006-10-18 18:00:00 | SPY | ETF | 136.45 | 136.46 | 136.34 | 136.37 | 515500.0 |
| 2006-10-18 19:00:00 | SPY | ETF | 136.39 | 136.43 | 136.39 | 136.43 | 9400.0 |
| 2006-10-18 09:00:00 | QQQ | ETF | 42.22 | 42.31 | 42.08 | 42.09 | 15712600.0 |
| 2006-10-18 10:00:00 | QQQ | ETF | 42.1 | 42.12 | 41.71 | 41.83 | 31413000.0 |
| 2006-10-18 11:00:00 | QQQ | ETF | 41.84 | 41.96 | 41.75 | 41.88 | 14395800.0 |
| 2006-10-18 12:00:00 | QQQ | ETF | 41.89 | 41.91 | 41.83 | 41.85 | 5468300.0 |
| 2006-10-18 13:00:00 | QQQ | ETF | 41.86 | 41.9 | 41.65 | 41.77 | 13132600.0 |
| 2006-10-18 14:00:00 | QQQ | ETF | 41.77 | 41.93 | 41.69 | 41.83 | 14666200.0 |
| 2006-10-18 15:00:00 | QQQ | ETF | 41.84 | 41.86 | 41.73 | 41.8 | 9403400.0 |
| 2006-10-18 07:00:00 | IWM | ETF | 76.1 | 76.1 | 76.1 | 76.1 | 100.0 |
| 2006-10-18 08:00:00 | IWM | ETF | 76.17 | 76.56 | 75.97 | 76.48 | 2557700.0 |
| 2006-10-18 09:00:00 | IWM | ETF | 76.47 | 76.8 | 76.4 | 76.41 | 6608300.0 |
| 2006-10-18 10:00:00 | IWM | ETF | 76.41 | 76.41 | 75.86 | 76.07 | 8905500.0 |
| 2006-10-18 11:00:00 | IWM | ETF | 76.07 | 76.4 | 75.92 | 76.25 | 7841100.0 |
| 2006-10-18 12:00:00 | IWM | ETF | 76.25 | 76.58 | 75.99 | 76.0 | 3560900.0 |
| 2006-10-18 13:00:00 | IWM | ETF | 75.99 | 76.09 | 75.6 | 75.81 | 6111600.0 |
| 2006-10-18 14:00:00 | IWM | ETF | 75.8 | 75.97 | 75.63 | 75.91 | 4020500.0 |
| 2006-10-18 15:00:00 | IWM | ETF | 75.91 | 76.25 | 75.71 | 75.9 | 4099200.0 |
| 2006-10-18 16:00:00 | IWM | ETF | 75.9 | 76.05 | 75.85 | 75.87 | 445000.0 |
| 2006-10-18 17:00:00 | IWM | ETF | 75.89 | 75.9 | 75.8 | 75.86 | 44300.0 |
| 2006-10-18 18:00:00 | IWM | ETF | 75.85 | 75.85 | 75.8 | 75.8 | 4400.0 |
| 2006-10-18 19:00:00 | IWM | ETF | 75.78 | 75.78 | 75.78 | 75.78 | 1500.0 |
| 2006-10-18 07:00:00 | DIA | ETF | 119.78 | 119.78 | 119.78 | 119.78 | 100.0 |
| 2006-10-18 08:00:00 | DIA | ETF | 119.79 | 120.2 | 119.78 | 120.15 | 97200.0 |
| 2006-10-18 09:00:00 | DIA | ETF | 120.17 | 120.49 | 120.14 | 120.19 | 1768200.0 |
| 2006-10-18 10:00:00 | DIA | ETF | 120.19 | 120.22 | 119.62 | 119.83 | 2003500.0 |
| 2006-10-18 11:00:00 | DIA | ETF | 119.83 | 120.44 | 119.76 | 119.94 | 1028600.0 |
| 2006-10-18 12:00:00 | DIA | ETF | 119.96 | 120.02 | 119.83 | 119.86 | 804600.0 |
| 2006-10-18 13:00:00 | DIA | ETF | 119.87 | 119.89 | 119.5 | 119.75 | 861200.0 |
| 2006-10-18 14:00:00 | DIA | ETF | 119.75 | 119.99 | 119.67 | 119.94 | 890200.0 |
| 2006-10-18 15:00:00 | DIA | ETF | 119.94 | 119.96 | 119.71 | 119.95 | 918400.0 |
| 2006-10-18 16:00:00 | DIA | ETF | 119.96 | 120.02 | 119.88 | 119.99 | 324200.0 |
| 2006-10-18 17:00:00 | DIA | ETF | 119.97 | 119.97 | 119.83 | 119.83 | 6100.0 |
| 2006-10-18 18:00:00 | DIA | ETF | 119.89 | 119.89 | 119.83 | 119.83 | 400.0 |
| 2006-10-18 08:00:00 | GLD | ETF | 58.9 | 59.8 | 58.7 | 58.73 | 35500.0 |
| 2006-10-18 09:00:00 | GLD | ETF | 58.76 | 59.03 | 58.69 | 58.96 | 734500.0 |
| 2006-10-18 10:00:00 | GLD | ETF | 58.97 | 59.0 | 58.75 | 58.88 | 957400.0 |
| 2006-10-18 11:00:00 | GLD | ETF | 58.86 | 58.96 | 58.71 | 58.89 | 200200.0 |
| 2006-10-18 12:00:00 | GLD | ETF | 58.9 | 58.99 | 58.79 | 58.7912 | 274700.0 |
> showing 50 of 1,727 rows — these rows as CSV