PREVIEW / etf_1hour / 2006-11-09
file: by_date/etf_1hour/2006/2006-11-09.parquet size: 58 KB rows: 1,777
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-09 07:00:00 | SPY | ETF | 139.05 | 139.05 | 138.86 | 138.86 | 32500.0 |
| 2006-11-09 08:00:00 | SPY | ETF | 138.92 | 139.1 | 138.85 | 139.03 | 1956500.0 |
| 2006-11-09 09:00:00 | SPY | ETF | 139.03 | 139.14 | 138.8 | 138.97 | 8348700.0 |
| 2006-11-09 10:00:00 | SPY | ETF | 139.0 | 139.0 | 138.51 | 138.86 | 10869900.0 |
| 2006-11-09 11:00:00 | SPY | ETF | 138.86 | 139.04 | 138.63 | 138.73 | 16652900.0 |
| 2006-11-09 12:00:00 | SPY | ETF | 138.73 | 138.84 | 138.59 | 138.79 | 6059900.0 |
| 2006-11-09 13:00:00 | SPY | ETF | 138.79 | 138.82 | 138.43 | 138.49 | 8079200.0 |
| 2006-11-09 14:00:00 | SPY | ETF | 138.48 | 138.6 | 138.04 | 138.24 | 28158200.0 |
| 2006-11-09 15:00:00 | SPY | ETF | 138.25 | 138.25 | 137.9 | 138.1 | 13541500.0 |
| 2006-11-09 16:00:00 | SPY | ETF | 138.09 | 138.25 | 138.01 | 138.18 | 595800.0 |
| 2006-11-09 17:00:00 | SPY | ETF | 138.16 | 138.18 | 138.14 | 138.18 | 141700.0 |
| 2006-11-09 18:00:00 | SPY | ETF | 138.15 | 138.16 | 138.13 | 138.13 | 1400.0 |
| 2006-11-09 19:00:00 | SPY | ETF | 138.15 | 138.15 | 138.13 | 138.15 | 2500.0 |
| 2006-11-09 09:00:00 | QQQ | ETF | 43.27 | 43.35 | 43.16 | 43.22 | 20645900.0 |
| 2006-11-09 10:00:00 | QQQ | ETF | 43.22 | 43.27 | 43.04 | 43.26 | 22106500.0 |
| 2006-11-09 11:00:00 | QQQ | ETF | 43.26 | 43.5 | 43.12 | 43.18 | 12858500.0 |
| 2006-11-09 12:00:00 | QQQ | ETF | 43.18 | 43.25 | 43.1 | 43.24 | 7435700.0 |
| 2006-11-09 13:00:00 | QQQ | ETF | 43.24 | 43.24 | 43.01 | 43.05 | 10923800.0 |
| 2006-11-09 14:00:00 | QQQ | ETF | 43.04 | 43.09 | 42.8 | 42.89 | 19139000.0 |
| 2006-11-09 15:00:00 | QQQ | ETF | 42.89 | 43.0 | 42.67 | 42.82 | 21378800.0 |
| 2006-11-09 07:00:00 | IWM | ETF | 76.65 | 76.7 | 76.65 | 76.7 | 200.0 |
| 2006-11-09 08:00:00 | IWM | ETF | 76.63 | 76.82 | 76.6 | 76.75 | 86500.0 |
| 2006-11-09 09:00:00 | IWM | ETF | 76.74 | 76.8 | 76.31 | 76.44 | 5634600.0 |
| 2006-11-09 10:00:00 | IWM | ETF | 76.41 | 76.5 | 76.05 | 76.49 | 6496800.0 |
| 2006-11-09 11:00:00 | IWM | ETF | 76.48 | 76.58 | 76.28 | 76.31 | 5957500.0 |
| 2006-11-09 12:00:00 | IWM | ETF | 76.31 | 76.46 | 76.2 | 76.45 | 4346100.0 |
| 2006-11-09 13:00:00 | IWM | ETF | 76.45 | 76.45 | 75.86 | 75.9 | 6682400.0 |
| 2006-11-09 14:00:00 | IWM | ETF | 75.89 | 75.98 | 75.57 | 75.68 | 8022900.0 |
| 2006-11-09 15:00:00 | IWM | ETF | 75.68 | 75.76 | 75.33 | 75.72 | 8663900.0 |
| 2006-11-09 16:00:00 | IWM | ETF | 75.72 | 75.87 | 75.71 | 75.84 | 413600.0 |
| 2006-11-09 18:00:00 | IWM | ETF | 75.85 | 75.85 | 75.82 | 75.84 | 2800.0 |
| 2006-11-09 19:00:00 | IWM | ETF | 75.86 | 75.86 | 75.86 | 75.86 | 500.0 |
| 2006-11-09 08:00:00 | DIA | ETF | 121.77 | 121.82 | 121.73 | 121.73 | 7200.0 |
| 2006-11-09 09:00:00 | DIA | ETF | 121.79 | 121.9 | 121.63 | 121.77 | 567200.0 |
| 2006-11-09 10:00:00 | DIA | ETF | 121.77 | 121.79 | 121.35 | 121.65 | 1286000.0 |
| 2006-11-09 11:00:00 | DIA | ETF | 121.63 | 121.68 | 121.42 | 121.47 | 618700.0 |
| 2006-11-09 12:00:00 | DIA | ETF | 121.48 | 121.55 | 121.37 | 121.54 | 500300.0 |
| 2006-11-09 13:00:00 | DIA | ETF | 121.55 | 121.55 | 121.24 | 121.3 | 922100.0 |
| 2006-11-09 14:00:00 | DIA | ETF | 121.28 | 121.38 | 120.99 | 121.12 | 847600.0 |
| 2006-11-09 15:00:00 | DIA | ETF | 121.12 | 121.12 | 120.91 | 121.09 | 1174600.0 |
| 2006-11-09 16:00:00 | DIA | ETF | 121.09 | 121.19 | 121.08 | 121.15 | 14400.0 |
| 2006-11-09 07:00:00 | GLD | ETF | 61.7 | 61.7 | 61.6 | 61.65 | 1200.0 |
| 2006-11-09 08:00:00 | GLD | ETF | 61.66 | 62.02 | 61.65 | 61.89 | 118100.0 |
| 2006-11-09 09:00:00 | GLD | ETF | 61.9 | 62.24 | 61.85 | 62.2 | 909000.0 |
| 2006-11-09 10:00:00 | GLD | ETF | 62.2 | 62.25 | 61.94 | 62.04 | 721600.0 |
| 2006-11-09 11:00:00 | GLD | ETF | 62.05 | 63.05 | 62.0 | 62.85 | 2450000.0 |
| 2006-11-09 12:00:00 | GLD | ETF | 62.87 | 62.96 | 62.68 | 62.85 | 660100.0 |
| 2006-11-09 13:00:00 | GLD | ETF | 62.84 | 63.13 | 62.84 | 63.08 | 561900.0 |
| 2006-11-09 14:00:00 | GLD | ETF | 63.09 | 63.13 | 62.86 | 62.91 | 563900.0 |
| 2006-11-09 15:00:00 | GLD | ETF | 62.91 | 63.0 | 62.87 | 62.9344 | 537000.0 |
> showing 50 of 1,777 rows — these rows as CSV