PREVIEW / etf_1hour / 2024-11-27
file: by_date/etf_1hour/2024/2024-11-27.parquet size: 584 KB rows: 22,067
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-27 04:00:00 | SPY | ETF | 600.11 | 600.4 | 599.68 | 599.87 | 35119.0 |
| 2024-11-27 05:00:00 | SPY | ETF | 599.97 | 600.08 | 599.76 | 599.91 | 4229.0 |
| 2024-11-27 06:00:00 | SPY | ETF | 600.06 | 600.24 | 599.59 | 600.16 | 17369.0 |
| 2024-11-27 07:00:00 | SPY | ETF | 600.21 | 600.5 | 599.95 | 600.35 | 93915.0 |
| 2024-11-27 08:00:00 | SPY | ETF | 600.19 | 602.0225 | 599.8196 | 600.75 | 433976.0 |
| 2024-11-27 09:00:00 | SPY | ETF | 600.75 | 600.85 | 599.94 | 600.44 | 2516449.0 |
| 2024-11-27 10:00:00 | SPY | ETF | 600.42 | 600.42 | 598.55 | 598.86 | 4054047.0 |
| 2024-11-27 11:00:00 | SPY | ETF | 598.86 | 599.15 | 598.01 | 598.15 | 2644662.0 |
| 2024-11-27 12:00:00 | SPY | ETF | 598.14 | 598.46 | 597.28 | 598.375 | 2330914.0 |
| 2024-11-27 13:00:00 | SPY | ETF | 598.375 | 599.12 | 598.18 | 598.9294 | 2217038.0 |
| 2024-11-27 14:00:00 | SPY | ETF | 598.94 | 599.1099 | 598.42 | 598.7099 | 1666030.0 |
| 2024-11-27 15:00:00 | SPY | ETF | 598.71 | 598.99 | 597.94 | 598.79 | 4824591.0 |
| 2024-11-27 16:00:00 | SPY | ETF | 598.78 | 598.94 | 598.58 | 598.76 | 1769454.0 |
| 2024-11-27 17:00:00 | SPY | ETF | 598.8571 | 598.86 | 598.65 | 598.83 | 9521.0 |
| 2024-11-27 18:00:00 | SPY | ETF | 598.75 | 599.31 | 598.75 | 599.19 | 20278.0 |
| 2024-11-27 19:00:00 | SPY | ETF | 599.21 | 599.43 | 599.21 | 599.4 | 12827.0 |
| 2024-11-27 04:00:00 | QQQ | ETF | 508.17 | 508.52 | 507.38 | 507.76 | 58698.0 |
| 2024-11-27 05:00:00 | QQQ | ETF | 507.8 | 508.21 | 507.57 | 508.14 | 22659.0 |
| 2024-11-27 06:00:00 | QQQ | ETF | 508.08 | 508.15 | 507.53 | 508.02 | 25390.0 |
| 2024-11-27 07:00:00 | QQQ | ETF | 508.04 | 508.52 | 507.7 | 508.38 | 130379.0 |
| 2024-11-27 08:00:00 | QQQ | ETF | 508.06 | 509.31 | 507.605 | 508.6 | 153840.0 |
| 2024-11-27 09:00:00 | QQQ | ETF | 508.61 | 508.64 | 505.85 | 506.38 | 2693501.0 |
| 2024-11-27 10:00:00 | QQQ | ETF | 506.38 | 506.38 | 503.16 | 503.58 | 3106778.0 |
| 2024-11-27 11:00:00 | QQQ | ETF | 503.58 | 504.0 | 502.42 | 502.92 | 2374529.0 |
| 2024-11-27 12:00:00 | QQQ | ETF | 502.88 | 503.66 | 501.93 | 503.59 | 1982507.0 |
| 2024-11-27 13:00:00 | QQQ | ETF | 503.58 | 505.38 | 503.3901 | 505.19 | 2044996.0 |
| 2024-11-27 14:00:00 | QQQ | ETF | 505.19 | 505.55 | 504.7 | 505.06 | 1713019.0 |
| 2024-11-27 15:00:00 | QQQ | ETF | 505.06 | 505.65 | 504.22 | 505.28 | 3637322.0 |
| 2024-11-27 16:00:00 | QQQ | ETF | 505.3 | 505.53 | 504.88 | 505.1 | 881806.0 |
| 2024-11-27 17:00:00 | QQQ | ETF | 505.13 | 505.3 | 505.1 | 505.15 | 27123.0 |
| 2024-11-27 18:00:00 | QQQ | ETF | 505.2 | 505.62 | 505.2 | 505.48 | 26300.0 |
| 2024-11-27 19:00:00 | QQQ | ETF | 505.68 | 506.14 | 505.68 | 506.0 | 35785.0 |
| 2024-11-27 04:00:00 | IWM | ETF | 240.93 | 241.7 | 240.91 | 241.68 | 17816.0 |
| 2024-11-27 05:00:00 | IWM | ETF | 241.7 | 242.23 | 241.35 | 242.07 | 24167.0 |
| 2024-11-27 06:00:00 | IWM | ETF | 242.12 | 242.28 | 241.72 | 242.15 | 25183.0 |
| 2024-11-27 07:00:00 | IWM | ETF | 242.19 | 242.58 | 242.07 | 242.31 | 71146.0 |
| 2024-11-27 08:00:00 | IWM | ETF | 242.1601 | 243.48 | 240.72 | 242.5 | 189824.0 |
| 2024-11-27 09:00:00 | IWM | ETF | 242.5 | 243.69 | 240.62 | 242.54 | 2098581.0 |
| 2024-11-27 10:00:00 | IWM | ETF | 242.555 | 242.95 | 240.66 | 241.03 | 2855247.0 |
| 2024-11-27 11:00:00 | IWM | ETF | 241.0 | 241.76 | 240.78 | 241.11 | 2055270.0 |
| 2024-11-27 12:00:00 | IWM | ETF | 241.11 | 241.32 | 240.44 | 240.915 | 1931481.0 |
| 2024-11-27 13:00:00 | IWM | ETF | 240.9 | 241.3 | 240.62 | 241.04 | 958266.0 |
| 2024-11-27 14:00:00 | IWM | ETF | 241.03 | 241.2 | 240.795 | 241.14 | 714597.0 |
| 2024-11-27 15:00:00 | IWM | ETF | 241.15 | 241.16 | 240.74 | 240.95 | 2278542.0 |
| 2024-11-27 16:00:00 | IWM | ETF | 240.95 | 241.29 | 240.94 | 241.17 | 1075625.0 |
| 2024-11-27 17:00:00 | IWM | ETF | 241.17 | 241.31 | 241.1001 | 241.31 | 10458.0 |
| 2024-11-27 18:00:00 | IWM | ETF | 241.33 | 241.65 | 241.33 | 241.42 | 10916.0 |
| 2024-11-27 19:00:00 | IWM | ETF | 241.4 | 241.6699 | 241.4 | 241.6001 | 39571.0 |
| 2024-11-27 04:00:00 | DIA | ETF | 448.6 | 448.6 | 448.45 | 448.48 | 826.0 |
| 2024-11-27 05:00:00 | DIA | ETF | 448.67 | 448.67 | 448.67 | 448.67 | 158.0 |
> showing 50 of 22,067 rows — these rows as CSV