PREVIEW / etf_1hour / 2006-11-08
file: by_date/etf_1hour/2006/2006-11-08.parquet size: 57 KB rows: 1,769
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-08 06:00:00 | SPY | ETF | 138.06 | 138.13 | 138.0 | 138.05 | 56200.0 |
| 2006-11-08 07:00:00 | SPY | ETF | 138.01 | 138.13 | 137.87 | 138.12 | 326500.0 |
| 2006-11-08 08:00:00 | SPY | ETF | 138.08 | 138.17 | 137.88 | 138.0 | 3207800.0 |
| 2006-11-08 09:00:00 | SPY | ETF | 137.99 | 138.37 | 137.75 | 138.12 | 14901200.0 |
| 2006-11-08 10:00:00 | SPY | ETF | 138.14 | 138.49 | 138.01 | 138.35 | 16537300.0 |
| 2006-11-08 11:00:00 | SPY | ETF | 138.35 | 138.38 | 138.18 | 138.3 | 6807600.0 |
| 2006-11-08 12:00:00 | SPY | ETF | 138.3 | 138.46 | 137.98 | 138.31 | 9084300.0 |
| 2006-11-08 13:00:00 | SPY | ETF | 138.3 | 138.59 | 138.06 | 138.53 | 7389600.0 |
| 2006-11-08 14:00:00 | SPY | ETF | 138.5201 | 139.05 | 138.39 | 138.91 | 12440000.0 |
| 2006-11-08 15:00:00 | SPY | ETF | 138.92 | 139.0 | 138.63 | 138.74 | 10551100.0 |
| 2006-11-08 16:00:00 | SPY | ETF | 138.74 | 138.96 | 138.3795 | 138.92 | 2961100.0 |
| 2006-11-08 17:00:00 | SPY | ETF | 138.92 | 139.03 | 138.92 | 138.95 | 409700.0 |
| 2006-11-08 18:00:00 | SPY | ETF | 138.95 | 138.98 | 138.95 | 138.97 | 3300.0 |
| 2006-11-08 19:00:00 | SPY | ETF | 138.97 | 138.97 | 138.94 | 138.96 | 800.0 |
| 2006-11-08 09:00:00 | QQQ | ETF | 42.58 | 42.77 | 42.47 | 42.74 | 25274000.0 |
| 2006-11-08 10:00:00 | QQQ | ETF | 42.74 | 42.86 | 42.62 | 42.77 | 30068400.0 |
| 2006-11-08 11:00:00 | QQQ | ETF | 42.77 | 42.8 | 42.7 | 42.75 | 6673700.0 |
| 2006-11-08 12:00:00 | QQQ | ETF | 42.75 | 42.91 | 42.66 | 42.8 | 20361300.0 |
| 2006-11-08 13:00:00 | QQQ | ETF | 42.81 | 43.07 | 42.7 | 43.04 | 24607300.0 |
| 2006-11-08 14:00:00 | QQQ | ETF | 43.04 | 43.2 | 42.95 | 43.13 | 23281400.0 |
| 2006-11-08 15:00:00 | QQQ | ETF | 43.12 | 43.18 | 42.94 | 43.02 | 20959400.0 |
| 2006-11-08 08:00:00 | IWM | ETF | 75.73 | 75.81 | 75.59 | 75.63 | 172400.0 |
| 2006-11-08 09:00:00 | IWM | ETF | 75.62 | 75.99 | 75.41 | 75.88 | 9214500.0 |
| 2006-11-08 10:00:00 | IWM | ETF | 75.89 | 76.32 | 75.84 | 76.12 | 8727800.0 |
| 2006-11-08 11:00:00 | IWM | ETF | 76.12 | 76.32 | 76.08 | 76.22 | 3006100.0 |
| 2006-11-08 12:00:00 | IWM | ETF | 76.23 | 76.43 | 75.88 | 76.28 | 7227300.0 |
| 2006-11-08 13:00:00 | IWM | ETF | 76.28 | 76.6 | 76.11 | 76.55 | 6088000.0 |
| 2006-11-08 14:00:00 | IWM | ETF | 76.55 | 76.8 | 76.4 | 76.7 | 7364500.0 |
| 2006-11-08 15:00:00 | IWM | ETF | 76.7 | 76.74 | 76.37 | 76.53 | 7573800.0 |
| 2006-11-08 16:00:00 | IWM | ETF | 76.54 | 76.68 | 76.48 | 76.68 | 2252500.0 |
| 2006-11-08 17:00:00 | IWM | ETF | 76.68 | 76.85 | 76.64 | 76.83 | 209000.0 |
| 2006-11-08 18:00:00 | IWM | ETF | 76.76 | 76.76 | 76.76 | 76.76 | 1000.0 |
| 2006-11-08 19:00:00 | IWM | ETF | 76.75 | 76.75 | 76.74 | 76.74 | 1100.0 |
| 2006-11-08 07:00:00 | DIA | ETF | 121.15 | 121.21 | 121.15 | 121.21 | 11900.0 |
| 2006-11-08 08:00:00 | DIA | ETF | 121.27 | 121.38 | 121.14 | 121.17 | 112700.0 |
| 2006-11-08 09:00:00 | DIA | ETF | 121.16 | 121.45 | 121.0 | 121.35 | 1331600.0 |
| 2006-11-08 10:00:00 | DIA | ETF | 121.37 | 121.57 | 121.18 | 121.49 | 1354100.0 |
| 2006-11-08 11:00:00 | DIA | ETF | 121.49 | 121.51 | 121.3 | 121.35 | 499400.0 |
| 2006-11-08 12:00:00 | DIA | ETF | 121.37 | 121.45 | 121.13 | 121.35 | 999200.0 |
| 2006-11-08 13:00:00 | DIA | ETF | 121.33 | 121.51 | 121.15 | 121.46 | 1218000.0 |
| 2006-11-08 14:00:00 | DIA | ETF | 121.45 | 121.96 | 121.36 | 121.86 | 2077600.0 |
| 2006-11-08 15:00:00 | DIA | ETF | 121.86 | 121.92 | 121.68 | 121.77 | 1576700.0 |
| 2006-11-08 16:00:00 | DIA | ETF | 121.76 | 121.88 | 121.72 | 121.88 | 27100.0 |
| 2006-11-08 17:00:00 | DIA | ETF | 121.9 | 121.95 | 121.9 | 121.9 | 500.0 |
| 2006-11-08 19:00:00 | DIA | ETF | 121.94 | 121.94 | 121.94 | 121.94 | 500.0 |
| 2006-11-08 07:00:00 | GLD | ETF | 61.55 | 61.63 | 61.45 | 61.63 | 27300.0 |
| 2006-11-08 08:00:00 | GLD | ETF | 61.67 | 61.9 | 61.4 | 61.9 | 232000.0 |
| 2006-11-08 09:00:00 | GLD | ETF | 61.93 | 62.2 | 61.74 | 61.88 | 568400.0 |
| 2006-11-08 10:00:00 | GLD | ETF | 61.9 | 62.0 | 61.77 | 61.96 | 863700.0 |
| 2006-11-08 11:00:00 | GLD | ETF | 61.97 | 62.08 | 61.55 | 61.59 | 1001800.0 |
> showing 50 of 1,769 rows — these rows as CSV