PREVIEW / etf_1hour / 2024-11-07
file: by_date/etf_1hour/2024/2024-11-07.parquet size: 608 KB rows: 23,120
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-07 04:00:00 | SPY | ETF | 591.95 | 592.59 | 591.82 | 592.1 | 44014.0 |
| 2024-11-07 05:00:00 | SPY | ETF | 592.1 | 592.43 | 592.06 | 592.29 | 53394.0 |
| 2024-11-07 06:00:00 | SPY | ETF | 592.29 | 592.31 | 591.89 | 592.3 | 49812.0 |
| 2024-11-07 07:00:00 | SPY | ETF | 592.37 | 592.86 | 592.26 | 592.66 | 118912.0 |
| 2024-11-07 08:00:00 | SPY | ETF | 592.43 | 593.04 | 591.26 | 592.6 | 265646.0 |
| 2024-11-07 09:00:00 | SPY | ETF | 592.52 | 594.05 | 592.5 | 594.0 | 3619736.0 |
| 2024-11-07 10:00:00 | SPY | ETF | 593.97 | 594.965 | 593.78 | 594.8166 | 4099001.0 |
| 2024-11-07 11:00:00 | SPY | ETF | 594.83 | 595.28 | 594.1 | 595.135 | 2699135.0 |
| 2024-11-07 12:00:00 | SPY | ETF | 595.14 | 595.56 | 594.76 | 595.3913 | 2085270.0 |
| 2024-11-07 13:00:00 | SPY | ETF | 595.4 | 595.44 | 594.21 | 594.8062 | 2374269.0 |
| 2024-11-07 14:00:00 | SPY | ETF | 594.78 | 596.03 | 593.92 | 596.02 | 3946490.0 |
| 2024-11-07 15:00:00 | SPY | ETF | 596.025 | 596.65 | 595.18 | 595.55 | 8640186.0 |
| 2024-11-07 16:00:00 | SPY | ETF | 595.55 | 596.25 | 595.44 | 596.0 | 3053317.0 |
| 2024-11-07 17:00:00 | SPY | ETF | 595.95 | 596.0901 | 595.61 | 596.06 | 385894.0 |
| 2024-11-07 18:00:00 | SPY | ETF | 596.13 | 596.14 | 595.6 | 596.09 | 57270.0 |
| 2024-11-07 19:00:00 | SPY | ETF | 596.07 | 596.2 | 595.71 | 595.73 | 28715.0 |
| 2024-11-07 04:00:00 | QQQ | ETF | 506.65 | 507.2 | 506.17 | 506.75 | 113790.0 |
| 2024-11-07 05:00:00 | QQQ | ETF | 506.8 | 507.01 | 506.66 | 506.69 | 16654.0 |
| 2024-11-07 06:00:00 | QQQ | ETF | 506.73 | 506.86 | 506.41 | 506.8 | 85773.0 |
| 2024-11-07 07:00:00 | QQQ | ETF | 506.8 | 507.64 | 506.78 | 507.39 | 153532.0 |
| 2024-11-07 08:00:00 | QQQ | ETF | 507.33 | 508.18 | 505.201 | 507.85 | 290577.0 |
| 2024-11-07 09:00:00 | QQQ | ETF | 507.9 | 510.92 | 507.79 | 510.89 | 3211032.0 |
| 2024-11-07 10:00:00 | QQQ | ETF | 510.88 | 512.23 | 510.3501 | 512.06 | 3433652.0 |
| 2024-11-07 11:00:00 | QQQ | ETF | 512.08 | 512.989 | 511.24 | 512.9 | 2151760.0 |
| 2024-11-07 12:00:00 | QQQ | ETF | 512.9 | 512.96 | 512.07 | 512.86 | 1479437.0 |
| 2024-11-07 13:00:00 | QQQ | ETF | 512.9 | 512.93 | 511.87 | 512.57 | 1576120.0 |
| 2024-11-07 14:00:00 | QQQ | ETF | 512.61 | 513.84 | 512.05 | 513.84 | 2657532.0 |
| 2024-11-07 15:00:00 | QQQ | ETF | 513.85 | 514.33 | 513.175 | 513.6 | 4255700.0 |
| 2024-11-07 16:00:00 | QQQ | ETF | 513.59 | 514.27 | 513.29 | 513.66 | 2311103.0 |
| 2024-11-07 17:00:00 | QQQ | ETF | 513.64 | 513.68 | 513.45 | 513.55 | 183417.0 |
| 2024-11-07 18:00:00 | QQQ | ETF | 513.71 | 513.72 | 513.19 | 513.63 | 80826.0 |
| 2024-11-07 19:00:00 | QQQ | ETF | 513.73 | 513.94 | 513.58 | 513.61 | 40308.0 |
| 2024-11-07 04:00:00 | IWM | ETF | 238.06 | 238.3 | 237.62 | 237.86 | 28116.0 |
| 2024-11-07 05:00:00 | IWM | ETF | 237.97 | 238.4 | 237.85 | 238.32 | 27206.0 |
| 2024-11-07 06:00:00 | IWM | ETF | 238.23 | 239.05 | 238.12 | 239.05 | 28644.0 |
| 2024-11-07 07:00:00 | IWM | ETF | 239.01 | 239.1 | 238.39 | 238.49 | 102755.0 |
| 2024-11-07 08:00:00 | IWM | ETF | 239.03 | 239.11 | 236.01 | 236.9 | 460577.0 |
| 2024-11-07 09:00:00 | IWM | ETF | 236.79 | 237.86 | 236.11 | 236.89 | 3791320.0 |
| 2024-11-07 10:00:00 | IWM | ETF | 236.9 | 238.49 | 236.09 | 237.93 | 3704576.0 |
| 2024-11-07 11:00:00 | IWM | ETF | 237.94 | 237.99 | 236.7 | 237.04 | 1611093.0 |
| 2024-11-07 12:00:00 | IWM | ETF | 237.0397 | 237.76 | 236.6921 | 236.99 | 1614848.0 |
| 2024-11-07 13:00:00 | IWM | ETF | 237.02 | 237.08 | 236.19 | 236.62 | 1483835.0 |
| 2024-11-07 14:00:00 | IWM | ETF | 236.65 | 237.29 | 235.4 | 236.98 | 4016292.0 |
| 2024-11-07 15:00:00 | IWM | ETF | 236.97 | 237.86 | 236.19 | 236.31 | 5490432.0 |
| 2024-11-07 16:00:00 | IWM | ETF | 236.38 | 237.11 | 236.33 | 237.02 | 1960595.0 |
| 2024-11-07 17:00:00 | IWM | ETF | 236.99 | 237.15 | 236.38 | 237.02 | 51892.0 |
| 2024-11-07 18:00:00 | IWM | ETF | 237.04 | 237.04 | 236.75 | 236.96 | 28217.0 |
| 2024-11-07 19:00:00 | IWM | ETF | 236.98 | 236.99 | 236.7 | 236.739 | 25983.0 |
| 2024-11-07 04:00:00 | DIA | ETF | 438.42 | 438.42 | 438.41 | 438.41 | 200.0 |
| 2024-11-07 05:00:00 | DIA | ETF | 438.2 | 438.2 | 438.2 | 438.2 | 200.0 |
> showing 50 of 23,120 rows — these rows as CSV