PREVIEW / etf_1hour / 2022-11-11
file: by_date/etf_1hour/2022/2022-11-11.parquet size: 465 KB rows: 17,009
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-11 04:00:00 | SPY | ETF | 398.0 | 398.11 | 396.41 | 396.87 | 104984.0 |
| 2022-11-11 05:00:00 | SPY | ETF | 396.89 | 397.25 | 396.0 | 396.35 | 71147.0 |
| 2022-11-11 06:00:00 | SPY | ETF | 396.15 | 396.8 | 395.84 | 396.53 | 266361.0 |
| 2022-11-11 07:00:00 | SPY | ETF | 396.51 | 396.65 | 395.77 | 396.61 | 422992.0 |
| 2022-11-11 08:00:00 | SPY | ETF | 396.44 | 398.0 | 395.29 | 396.83 | 980394.0 |
| 2022-11-11 09:00:00 | SPY | ETF | 396.84 | 397.03 | 393.61 | 395.16 | 7932658.0 |
| 2022-11-11 10:00:00 | SPY | ETF | 395.14 | 397.55 | 393.68 | 396.33 | 10641821.0 |
| 2022-11-11 11:00:00 | SPY | ETF | 396.33 | 397.11 | 394.03 | 395.19 | 8064195.0 |
| 2022-11-11 12:00:00 | SPY | ETF | 395.19 | 396.63 | 394.64 | 396.165 | 4564150.0 |
| 2022-11-11 13:00:00 | SPY | ETF | 396.17 | 398.32 | 396.13 | 398.18 | 6352824.0 |
| 2022-11-11 14:00:00 | SPY | ETF | 398.16 | 399.34 | 397.66 | 399.23 | 6722022.0 |
| 2022-11-11 15:00:00 | SPY | ETF | 399.23 | 399.35 | 397.32 | 398.5 | 15657446.0 |
| 2022-11-11 16:00:00 | SPY | ETF | 398.49 | 398.7 | 398.02 | 398.31 | 4204518.0 |
| 2022-11-11 17:00:00 | SPY | ETF | 398.42 | 398.87 | 398.2 | 398.63 | 151040.0 |
| 2022-11-11 18:00:00 | SPY | ETF | 398.77 | 398.94 | 398.57 | 398.6 | 39502.0 |
| 2022-11-11 19:00:00 | SPY | ETF | 398.6 | 398.6 | 398.33 | 398.51 | 25322.0 |
| 2022-11-11 04:00:00 | QQQ | ETF | 285.46 | 286.12 | 284.72 | 285.09 | 134482.0 |
| 2022-11-11 05:00:00 | QQQ | ETF | 285.07 | 285.38 | 284.14 | 284.36 | 126874.0 |
| 2022-11-11 06:00:00 | QQQ | ETF | 284.26 | 284.84 | 284.01 | 284.44 | 155521.0 |
| 2022-11-11 07:00:00 | QQQ | ETF | 284.46 | 284.55 | 283.7 | 284.531 | 307601.0 |
| 2022-11-11 08:00:00 | QQQ | ETF | 284.2 | 286.23 | 282.538 | 284.46 | 525293.0 |
| 2022-11-11 09:00:00 | QQQ | ETF | 284.4 | 285.25 | 281.19 | 283.0 | 8159899.0 |
| 2022-11-11 10:00:00 | QQQ | ETF | 283.0 | 286.3399 | 281.75 | 285.57 | 8717346.0 |
| 2022-11-11 11:00:00 | QQQ | ETF | 285.57 | 286.29 | 282.9 | 284.56 | 5834275.0 |
| 2022-11-11 12:00:00 | QQQ | ETF | 284.53 | 286.27 | 284.01 | 285.9 | 3369549.0 |
| 2022-11-11 13:00:00 | QQQ | ETF | 285.9083 | 287.99 | 285.84 | 287.86 | 5228524.0 |
| 2022-11-11 14:00:00 | QQQ | ETF | 287.84 | 288.64 | 287.372 | 288.59 | 4598694.0 |
| 2022-11-11 15:00:00 | QQQ | ETF | 288.59 | 288.63 | 286.51 | 287.97 | 11310430.0 |
| 2022-11-11 16:00:00 | QQQ | ETF | 287.965 | 288.08 | 287.5 | 287.65 | 2176656.0 |
| 2022-11-11 17:00:00 | QQQ | ETF | 287.7 | 287.96 | 287.5176 | 287.81 | 606966.0 |
| 2022-11-11 18:00:00 | QQQ | ETF | 287.8 | 287.95 | 287.8 | 287.93 | 35593.0 |
| 2022-11-11 19:00:00 | QQQ | ETF | 287.87 | 288.2 | 287.81 | 288.18 | 36128.0 |
| 2022-11-11 04:00:00 | IWM | ETF | 187.06 | 187.06 | 186.41 | 186.61 | 85536.0 |
| 2022-11-11 05:00:00 | IWM | ETF | 186.74 | 186.74 | 186.13 | 186.28 | 44344.0 |
| 2022-11-11 06:00:00 | IWM | ETF | 186.19 | 186.67 | 186.05 | 186.6 | 109189.0 |
| 2022-11-11 07:00:00 | IWM | ETF | 186.54 | 186.55 | 186.11 | 186.5 | 72018.0 |
| 2022-11-11 08:00:00 | IWM | ETF | 186.14 | 187.0 | 185.99 | 186.5 | 154860.0 |
| 2022-11-11 09:00:00 | IWM | ETF | 186.46 | 187.57 | 185.69 | 187.48 | 3284948.0 |
| 2022-11-11 10:00:00 | IWM | ETF | 187.3 | 188.84 | 186.75 | 187.66 | 3837722.0 |
| 2022-11-11 11:00:00 | IWM | ETF | 187.665 | 188.01 | 186.0 | 186.27 | 2806246.0 |
| 2022-11-11 12:00:00 | IWM | ETF | 186.27 | 186.81 | 185.95 | 186.26 | 1477546.0 |
| 2022-11-11 13:00:00 | IWM | ETF | 186.25 | 187.23 | 186.23 | 187.155 | 1565603.0 |
| 2022-11-11 14:00:00 | IWM | ETF | 187.15 | 188.0875 | 186.985 | 187.93 | 1999360.0 |
| 2022-11-11 15:00:00 | IWM | ETF | 187.94 | 187.96 | 186.44 | 186.9 | 4799590.0 |
| 2022-11-11 16:00:00 | IWM | ETF | 186.9 | 187.01 | 186.71 | 186.98 | 1201385.0 |
| 2022-11-11 17:00:00 | IWM | ETF | 186.9 | 187.0 | 186.8 | 186.95 | 67144.0 |
| 2022-11-11 18:00:00 | IWM | ETF | 186.93 | 187.06 | 186.9 | 186.9 | 12879.0 |
| 2022-11-11 19:00:00 | IWM | ETF | 186.9 | 186.98 | 186.8 | 186.9 | 8836.0 |
| 2022-11-11 04:00:00 | DIA | ETF | 339.45 | 339.55 | 338.51 | 338.95 | 6226.0 |
| 2022-11-11 05:00:00 | DIA | ETF | 338.53 | 338.53 | 338.45 | 338.45 | 500.0 |
> showing 50 of 17,009 rows — these rows as CSV